What is the comparison of the scheme?

The scheme of the scheme is a technique used to merge two or more complicated databases or sets of information together. Since the use of databases and electronic information storage increases and more complicated over the Internet, defined methods of merging SAD data from one database to another must be one of such techniques. The concept is simple, but the reality of data merger is quite complex. Two or more databases are mapped together and similar aspects of each database are mapped to each other. The most common way to merge data is the use of accurate links. An example of this style of merger is a combination of the names of the column of one database with the column of another database name.

merging is not usually so simple, for people or computers. With so many data that must be filtered, combined and used, with databases, databases not than more databases. The scheme mapping focuses on this tiring process automated and more efficient. An example of where it isIt may be when one database has a "main student" field and another database has a "student's study field" field. It is the same information, but slightly different titles complicate the efforts to mix it.

The

scheme compares this complex process of merging databases into four steps: pre -integration, comparison, adaptation and merger. They should be analyzed in terms of similarities and differences before it is possible to merge more databases. This is called pre -integration in the area of ​​the scheme. The computer begins to determine the most effective integration method.

Furthermore, the computer evaluates the schemes by comparing each other at a more detailed level. In comparison, the computer deals with each database item and determines where conflicts can occur. An example of this is when the field of "student interest" is mentioned "doctor" and other databases mention it as "doctor". A person would probably recognize information as the same but for a databaseThe tools are two separate entities.

As soon as the computer determines all potential conflicts, it can move forward and try to solve these problems. It can be as simple as changing all the "doctor" cases to a "doctor". In fact, this process is much more complex.

Once all conflicts are fixed, the computer can continue to merge data into the comparison process. At this stage, two or more databases are merged into one large database. If everything goes well, there will be no conflicts or errors during integration and future access to the database.