Surrogate Key And Its Application In The Information Integration

In recent years,"information system integration"is one of the most applied glossaries in the IT industry. The information technology has already become an important domain in the computer application technology. And technology of the information system integration was not only the core aspect of the information technology but also the foundation of the information technology. In the area of information system integration technology, there are many successful instances from the domestic and foreign engineering project. Many scholars and engineers have conducted the fruitful research and summary to the connotation of information system integration. Nowadays still much work related to the information system integration is in process of summarizing and increasing implementing.The information system integration technology is a comprehensive technology including many aspects, for example, the platform integration, the data integration, the application integration, the operation process integration, and the operation expression integration. The integrated process is multi-stratification and step- implementation. It can not be accomplished in one separated action. It is a step-by-step construction process based on the integrated background and the requirement. Different technology in the integrated stratification emphasis the different point, high level plays the instructive role to the lower-level technology, and the under-level function supports the high-level technology. These technologies are not in classification but exist under overlap and the intercourse of help from each other.This article has carried on the brief elaboration to the information system integration, also on some technology which used in the process. As a result of the system construction process, much integrated technology is based on relative databases. Treating the database system integration as an important foundation, we take the relative database table as the object of study. We use the surrogate key to solve the problem in the table integration. Relation in the relative database refers to the two dimensional table, the relative database model expresses the data with the table. Each table is through (also is principal linkage primary key) unites with another table in main key words completes. However no matter if each table is alone or not is identified through main key words defined in the table. In the relative database the main key words is the most important. In former relative database, the table principal linkage majority uses the natural key, namely the operation system use identifier has certainly in sets meaning identifier. But this will inevitably cause the attribute enumeration quantity different question which the principal linkage contains. Because some primary key may be composite natural key, it needs many attribute rows to determine the independence of each line. We have utilized the surrogate key to solve the problems when different entity needs to be integrated or carried on operation processing with the same flow. Using surrogate key technology, we can eliminate the host code semantics, through the method to screen the difference structure of the entity which is in the table of the relative database. Thus provides the convenience for the information integration and software reuse in the work flow application.