.1. How pipeline promotes parallel processing?Explain with examples.2. Mention the Hardware issues involved in parallel processing? 3.Give the purpose of having buses in distrubuted parallel processing?
Simple and Complex.
- Replication of data in distributed environment. - Using snapshots to replicate data. - Using remote procedure calls.
Snapshot is an object used to dynamically replicate data between distribute database at specified time intervals. In ver 7.0 they are read only.
- A simple snapshot is based on a query that does not contains GROUP BY clauses, CONNECT BY clauses, JOINs, sub-query or snashot of operations.
Updating or Inserting records in remote database through database triggers. It may fail if remote database is having any problem.
Time the references to occur when master tables are not in use. Peform the reference the manually immdiately locking the master tables. We can join tables in snopshots by creating
COMPLETE - Tables are completely regenerated using the snapshots query and the master tables every time the snapshot referenced.FAST - If simple snapshot
It is a table that maintains a record of modifications to the master table in a snapshot. It is stored in the same database as master table and is only available
View page [1] 2 Next >>
Go Top
