The Research Of The DatabasemanagementTechnology Based On The Multiple Database Environment

The main subject of multi-database management system environment database schema and database migration technology,and application-oriented multi-enterprise inventory management system project.Target of the multiple database environment is through the use of inexpensive hardware and flexible software, build high scalability and high availability computer clusters, completely abandon the over-reliance on expensive large and complex hardware.Database Management Technologies are about creating, accessing, monitoring, and maintenance of data in the database technology, refers to the technical management in order to ensure the normal operation of the database to ensure lossless data access must be carried out. There are many database management technology content, For example, to build the database structure, User Management and Security, data integrity and data constraints, database performance optimization, fault diagnosis database, etc.Multi-database environment is to use multiple database servers, together to form a complete, global large databases in order to provide transparent data services to clients. Each local database server can be deployed in a high-speed LAN, you can also be deployed in cross-sectoral, cross-unit off-site remote network.This article based on topics Oracle11g r2,the key technology embodied in:(1) Create a tablespace using an isolated tablespace template, this way use template design constraint specification,to ensure that the multi-database environment each local spatial structure standardized and unified database table;(2) Combined with Oracle Data Pump toolset provided by the database metadata and the actual data underlying network connection using a synchronous loading migrate to the destination database server. This approach does not adhere to the traditional way of transporting tablespace,but full account of the physical location of each local database close multi-database environment, and entire network overhead is not reality.Multi-database environment database management technology is used in inventory management for multi-enterprise system.Multi-oriented enterprise inventory management system, to meet the security requirements of the enterprise data enterprise data stored separately. Meanwhile, the life cycle of each business is different, so the data size of each enterprise is not the same.Multi-database environment database management technology through mode management technology to solve a number of good corporate database model is not the issue of reunification, and to ensure that each local database server to maximize performance through migration technology.