Snapshot replication in DBMS
What do you understand by the term snapshot replication in DBMS?
Expert
Snapshot replication can be employed if an application does not necessitate that the data always be current. Such applications can be updated by periodic table snapshots or copying. As part of the snapshot effort, all of the data to be consisted in the snapshot is collected at a primary point. And then a read-only snapshot is taken and is sent to each and every site and hence the update can be made.
Describe briefly the difference between identifier and attributes?
Describe briefly Aggregate transformation?
Specify the other areas for the purpose of Data warehousing and the data mining.
Describe any two reasons which show the necessity of database redesign?
What is OLAP? Briefly define it.
Describe why XML is a better markup language than HTML?
Who can create up a database or system team? Give a short demonstration of each.
Explain the function of metadata for the three-layer architecture?
What is the main dissimilarity between horizontal and vertical partitioning?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
18,76,764
1960389 Asked
3,689
Active Tutors
1452611
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!