Technology Questions

Basic Replication : Basic replication is implemented using standard CREATE SNAPSHOT or CREATE MATERIALIZED VIEW statements. It can only replicate data and not procedures, indexes replication is always one-way, and snapshot copies are read only.

Advanced Replication : Advanced replication supports various configurations of updatable snapshot, multi-master and update anywhere replication. It is more difficult to configure but allows data and other database objects like indexes and procedures to be replicated.

Differences between Basic and Advanced replications:

- With basic replication, data replicas provide read-only access to the table data whereas advanced replication features extend the capabilities of basic read-only replication by allowing applications to update table replicas throughout a replicated database system.

- With Basic Replication applications can query data from local data replicas. On the other hand with advanced replication, data replicas anywhere in the system can provide both read and update access to a table's data.

To make this method available to every implementation class

Marshalling is the process of gathering data from one or more applications or non-contiguous sources in computer storage, putting the data pieces into a message buffer, and organizing or converting the data into a format that is prescribed for a particular receiver or programming interface.  

View:

- Tail raid data representation is provided by a view to access data from its table.

- It has logical structure can not occupy space.

- Changes get affected in corresponding tables.

Materialized view

- Pre calculated data persists in materialized view.

- It has physical data space occupation.

- Changes will not get affected in corresponding tables.

SELECT DISTINCT(salary) FROM emp as e1 

WHERE (3) = (SELECT COUNT(DISTINCT(salary)) FROM emp as e2  WHERE e1.salary <= e2.salary)

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.

All the above listed actions are the functions of cursor