Replicating data, Database Management System

Replicating Data

One approach that may support efficient access to dissimilar applications as above may be to give access to every of the applications from dissimilar replicated files of the data. Each of the file may be prepared in a dissimilar way to serve the requirements of a dissimilar application. For instance, for the problem over, we may give an indexed sequential account file having accounted number as the key to account holders and the bank teller. A sequential file in the order of permissible loan limit to the Loan officers and a sorted sequential file in the order of balance to branch manager.

All of these files therefore differ in the organisation and would need different replica for dissimilar applications. Though, the Data replication brings in the problems of inconsistency under updating environments. Therefore, a better approach for data access for multiple keys has been proposed.

 

Posted Date: 3/8/2013 6:16:54 AM | Location : United States







Related Discussions:- Replicating data, Assignment Help, Ask Question on Replicating data, Get Answer, Expert's Help, Replicating data Discussions

Write discussion on Replicating data
Your posts are moderated
Related Questions
A database named yourusernameFMA has been set up for you to use for this assignment.  For the FMA you must create the required tables and run the queries using this database.  If y

Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu

Question: (a) e-Government implementations normally evolve through a multi-stage process. Describe, using appropriate examples, the stages involved in an e-Government implemen

What is Multivalued Attribute? Multivalued Attribute - Multivalued attribute might have more than one value for an entity. For instance, PreviousDegrees of a STUDENT.

By using the delete operation some consisting records can be deleted from a relation. To delete some definite records from the database a condition is also specified based on which

he SQL query that will return the order number, quantity ordered, price each and total cost of an order (quantity * price each) from the order details table. Label the calculated c

Give the reasons for allowing concurrency? The reasons for allowing concurrency is if the transactions run serially, a short transaction might have to wait for a preceding long


read-set(T) : Each data items that are read by a transaction T Timestamps : for all transaction T, the start-time and the end time are reserved for all the three phases.

Sequential File Organisation The most necessary way to organise the collection of records in a file is to use sequential Organisation. Records of the file are stored in series