MATERIALIZED VIEW - ARCHITECTURE

 MATERIALIZED VIEW - ARCHITECTURE





Comments

Post a Comment

Popular posts from this blog

Oracle GoldenGate Microservices Architecture - 1

Image
Data Replication techniques has gained importance in the market with the need of maintaing production data in other databases like Postgre, Mysql etc.. to avoid heavy license fee charged by top rdbms providers like Oracle, Sql Server .Goldengate is one of the most famous and popular software which can be used for data replication between homogenous and hetrogenous databases.  GoldenGate supports two types of architectures : Classic Architecture Microservice Architecture CLASSIC ARCHITECTURE It is first architecture supported by the Goldengate when it was introduced 20 years ago. Goldengate Classic architecture drawn many advantages in the market when customers are facing problems when replicating data between heterogenous databases. Classic Architecture has below components: Manager - Is the master process running in the Goldengate which takes care of all other slave                 process like Extract, Datapump, Replicat and Collector....
Read more

Parallel Servers in Oracle Database

Image
       Many think that processing a activity or work parallely will be more effective then performing it sequentially(serially),Even we do apply for most of the cases.Since, in parallel processing , the work is divided among the multiple resources and each resource will take care of their allocated work and finally  results from all of them are merged as one final result. Oracle has also introduced Parallel processing technique which is called as Parallel servers or Parallel query servers, where work is divided among multiples resources , resources here mean threads which are capable of doing working dependently. But when it comes to implementing parallel processing techniques in machines , it is not as easy as what we can do as human, Since the machines need to be guided so that each parallel thread should coordinate with other whenever required.   Lets discuss in depth about Parallel processing technique i.e Parallel servers implemented in Oracle Database...
Read more

BLOOM FILTER AND ITS POSITIVE IMPACT ON HASH JOINS

Image
HASH JOIN : Hash Joins is one of the method of joining two tables based on the join condition mentioned in the query. It is important to mention the smaller table  in leading position in the sql query when joining two tables. The optimizer always picks the leading table/first table as per the order mentioned in the query.If the execution plan does not pick the smaller table as the leading table then there will be more load/activity at the joining step then the plan which might impact the overall elapsed time of the query. We can explicitly ask the optimizer to pick a particular table as leading table using a oracle hint Ex: /*+ leading(table name)*/  How Hash Join works?  1) First Optimizer scan the smaller table and creates a hash table  by applying hash function on the column to be joined.   2) Now the optimizer scans the second table applies a hash function(applies on the column to be joined) to get the hash value for each record in the second table. ...
Read more