![]() In the Database Synchronization Strategies whitepaper, we explored some strategies for synchronizing two databases that are of the same and of dissimilar type, using the Navicat Premium Database Management System. The implementation of database replication for the purpose of eliminating data ambiguity or inconsistency among users is known as normalization. In either case the result is a distributed database in which users can access data relevant to their tasks without interfering with the work of others. ![]() ![]() The main role of replication is to create an amalgamated repository of all user databases and/or disseminate the same level of information amongst all users. Replication may either be done asynchronously, so that a permanent connection between the two databases is not required, or during non-peak hours, when there is little traffic on the database server, for instance, during the late-night hours. Unlike synchronization, which is a one-time process that brings the schema and data of two databases in sync, replication is a process that continuously (automatically) reproduces data between two databases (although schema updates are also possible).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |