Research On The Flow Replication Technology Storage Separation Methods

Daqing oilfield development so far, the units have already accumulated a large amount of exploration and development as well as production and business data, storage and use of the data is particularly important, is linked to the survival and development of enterprises. In addition, due to the current number of self-built system oilfield Commission built the system and supporting the construction of gradually increasing, the server service life is longer, broader applications, these applications are used together with independent users to read and write data to the database every day, a large number of write and read operations, database updates fast, so when a large number of users simultaneously access the database, the database server will consume processing power to bring some burden on the server, for application access and support obviously inadequate, affect the database execution efficiency, sometimes as a direct result of server downtime.In this paper carried Oracle Streams replication technology, database read and write separation methods and real-time database performance information extraction and analysis of other aspects of the research and development work, according to the data center needs of the actual situation and the database server data management, oracle-based replication technology to achieve a two-stream and three-level synchronization and synchronize two data synchronization mode, to meet different application requirements; through the acquisition, dissemination and application of process concurrency control, to achieve efficient data synchronization process. Developed a graphical database real-time performance monitoring tool, in the form of real-time curve display various performance indicators and load the database and provide performance analysis reporting. For improving the database system at the same time a large number of users accessing the service capability and data security is of great significance and practical value of production and research applications.