Bài giảng Cơ sở dữ liệu nâng cao - Chapter 6: Data replication. Những nội dung chính được trình bày trong chương này gồm có: Overview of replication, replication scenario, replication types. . | Data Replication Overview of Replication SQL Server replication is a set of technologies for: copying and distributing data and database objects from one database to another. Then, synchronizing between databases to maintain consistency. Types of replication: Snapshot replication. Transactional replication Merge replication Peer – to – peer replication Oracle Publishing replication All of these types rely on a number of standalone programs – agents. Replication Scenario Replication is analogous to the publishing industry Article: a database object that you want to replicate; it can be a Table, View, or Store procedure, or other objects. Publication: A collection of articles. One article can be in one or more publications. Publication can be treated as a logical grouping for the articles For example: To replicate only the employee master data, you can include employee table article, address article, and any other relevant views to the publication Replication Scenario Subscription: A request for a copy from the publication. Define where to receive the publication, what the frequency for the receiving is, Publisher A database instance that holds publications for other database instances to receive. There can be several different types of publication in one publisher. Replication Scenario Distributor: Each publisher has a distributor to store replication status data, and metadata about the publication. Sometimes the distributor acts as a data queue for data moving from the publisher to the subscribers and vice versa. There are two types of distributors: local and remote. Local distributor is where the publisher and distributor are in one database server instance. Subscriber: A database instance that receives replicated data from the publisher. In some replication types the subscriber also passes data to the publisher. Replication Types Snapshot: Distribute data as it appears in the publisher at a specific moment of time. Whenever the Subscriber called for . | Data Replication Overview of Replication SQL Server replication is a set of technologies for: copying and distributing data and database objects from one database to another. Then, synchronizing between databases to maintain consistency. Types of replication: Snapshot replication. Transactional replication Merge replication Peer – to – peer replication Oracle Publishing replication All of these types rely on a number of standalone programs – agents. Replication Scenario Replication is analogous to the publishing industry Article: a database object that you want to replicate; it can be a Table, View, or Store procedure, or other objects. Publication: A collection of articles. One article can be in one or more publications. Publication can be treated as a logical grouping for the articles For example: To replicate only the employee master data, you can include employee table article, address article, and any other relevant views to the publication Replication Scenario Subscription: A .
