Describe Replication Architecture

Replication is a set technology  for copying and distributing the data and database objects from one database to another database and synchronizing between database to maintain consistency. it is possible to create an identical copy of you primary database or synchronize changes between multiple database and maintain data consistency and integrity.

  • Article: an article is the basic unit of SQL server. these include table, views and stored procedures, and user define function
  • publication: a publication is logical collection of the article that exits on publisher. 
  • distributor: a publisher is a SQL server instance that has publication which contain the article to be published to subscribers.
  • distributor: distributor collects the article from the publisher. and delivers them to subscribers.
  • subscriber: a subscriber subscribes to one or more publication, it will receive each article in publication.
  • subscription: a request for copy a publication that must be delivered the subscriber. 
there are different type of replication technique that support a variety of data synchronization approaches.; one way; one to many many to one, bi-directional and keep several data sets in synchronization with each other. 
  1. Snapshot replication
  2. transactional replication
  3. merge replication 
  4. peer to peer replication 
the most replication that are used is snapshot replication and transactional replication 

Comments

Post a Comment

Popular posts from this blog

Quick Revision for Multimedia and Animation - Vikatu

Image
Unit 1     Multimedia is a type of medium that allows information to be easily transferred from one location to another . Multimedia is the presentation of  text ,  pictures ,  audio , and  video  with links and tools that allow the user to navigate, engage, create, and communicate using a computer. Multimedia refers to the computer-assisted integration of text, drawings, still and moving images(videos) graphics, audio, animation, and any other media in which any type of information can be expressed, stored, communicated, and processed digitally. Multimedia is being employed in a variety of disciplines, including  education ,  training , and  business . Applications of Multimedia   Multimedia indicates that, in addition to  text ,  graphics / drawings , and  photographs ,  computer information  can be represented using audio, video, and animation. Multimedia is used in: 1. Education In the subject of education, multimedia is becoming so popular. It is often used to pr
Read more

Java Quick revision

Image
UNIT I Parameters Java C++ First Release The Java language came into existence on 23rd May 1995. The C++ language first came into existence in October 1985. A stable form of Release The JDK 14 or Java SE was finally released on 17th March 2020. The C++ 17 was released back in December 2017. Founder James Gosling developed Java at Sun Microsystems. Bjarne Stroustrup developed C++ at Bell Labs back in 1979 in the form of an extension to the C language. Platform Dependency The Java bytecode can easily work on any given OS (operating system). It is very much platform-independent. The C++ language is platform-dependent. It means that we need to compile it for a different platform. Official Website The official website for Java is oracle.com/java The official website for C++ is isocpp.org Influenced By The C#, C++, Pascal, Ada 83, and many more languages have an influence on the Java language. Smalltalk, Simula, ML, C, ALGOL 68, Ada, and many more languages have an influence on the C++ langu
Read more

Quick revision for software engineering by vikatu

Image
UNIT I Software characteristics refer to the qualities or attributes that define the behavior, functionality, and performance of a software system. These characteristics help in evaluating, understanding, and designing software effectively. Here are some common software characteristics: Functionality : It refers to the extent to which the software performs its intended tasks. A software system should meet the specified requirements and provide the desired features to users. Reliability : This characteristic indicates the ability of the software to perform consistently and predictably under various conditions. Reliable software should be robust and resilient to errors and failures. Usability : Usability measures how easy it is for users to interact with the software. It involves aspects such as user interface design, intuitiveness, simplicity, and accessibility. Efficiency : Efficiency relates to the optimal use of system resources (such as CPU, memory, and disk space) to achieve desire
Read more