The Research Of The Data Management Technology Based On The B2B E-Commerce System

Based on the research of medium-sized wholesale enterprises in clothing industry, we develop a B2B E-Commerce application cloud platform. It adopts B/S structure and is used for enterprises to manage their business information. And it is available for multiple enterprise users at the same time. Combining with the characteristic and performance of the system, it uses the multiple database system to store enterprises’data, which can not only improve the efficiency of query but also be easy to expand the system database. The data management need is proposed on the basis of the B2B E-Commerce application cloud platform system. This topic mainly studies and implements the data management function based on the E-Commerce application cloud platform system.The topic must follow some schemes. First, it does not affect the normal operation of the business system, and operates as effectively as possible. Then, it is operated simply. In this paper, data management function and key technologies are briefly introduced at first, which including data dump, data backup and recovery. Next the backup and recovery strategy of Oracle database, which is used in business system, is introduced. According to the advantages and disadvantages of the backup and recovery mode that Oracle database provide, the final implementation plan is the EXP for data dump and the RMAN for data backup and recovery.The thesis involved multiple databases systems centralized management in the system, and uses RMAN catalog mode to restore, in order to avoid restoring the control files when recovering. At same time, this module provides flexible backup and recovery strategies for users of the system, including full backup and incremental backup. The backup cycle, backup time and the location of the backup files all can be set by the user.With the increase of business system’s users, it will dynamically append a set or multiple sets of database systems according to the rules established when the database performance declines. So some norms are setting for all backup files and dump files in multiple database systems, in order to prevent the file covered and choose correct backup file when recovery.The implementation of this topic adopts the SSH structure and Oracle databases. The system users can unify the management of all business databases through a visual interface.