Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
The following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systems.
(a) A transaction executing at site A updates only the replicas at A before it commits (it needed to access no other site since replication is total).
(b) After the transaction commits, a second transaction is initiated to update the primary copies of all items updated at A.
(c) After the transaction in step (b) has completed, each primary site propagates the update made at that site to all secondaries (including the one at site A). Updates made to a primary copy by several transactions are propagated to secondaries in the order in which the primary was updated.
Explain why, in step (b), all primaries must be updated in a single transaction and, in step (c), the update is propagated to site A.
The indices are accumulated in the index files. The data is accumulated in the data files. Indices give fast access to data items. For example, a book database may be managed in th
Describe Query evaluation engine? Query Evaluation engine: Vehicle executes low-level instructions obtained through the DML compiler. The Storage Manager Components gives in
What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and
Explain CNT in the respects of QBE ? CNT: It is one of the aggregation commands given in QBE. It is used to identify number of tuples
i am not clear with the climetic condition of the north indian plain. can u plz explain it for me
what do you mean by consistency in rdbms?
Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap
Difference between LEFT OUTER JOIN and RIGHT OUTER JOIN In left outer join tuples from the left-hand-side relation which do not match any tuple in the right-hand-side relation
List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation
Increased parallelism : Since the replicated date has several copies a query can be distributed or can be answered from the smallest loaded site. Also, with more replicas you have
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd