Performance Optimization Of Database And Its Application In The Press & Information System

As a large database management system, the Oracle is presently the most extensively applied in many systems. Among those, the press & information system demands relatively higher performance resulted from its unique characteristics, such as the complex build-up structure of the operation system, huge data and numerous user.Here, we have studied the optimization technique of the database system, addressing ourselves to the detailed implementing methods and procedure to optimize the performance of the press & information system database, from the constructing step to the running step.On the aspect of the optimization technique of the database system, we have mainly investigated three optimization contents including environment optimization, examples and database optimization, and the SQL sentence optimization, which supplies the indispensable theoretical foundation for the optimization of the press & information system database.In the constructing and optimizing process of the press database system, we firstly present the total framework of the press system database, after that, we establish the optimizing and building-up scheme with high practicability for the press & information database by analyzing the system configuration and the key technique, ultimately, we make a fully research on the detailed implementing procedure of the press & information system database.The press & information system database take the nationwide and highly centralized mode and demand high database performance. In view of the business characteristic of such system, we establish a rational configuration scheme for both software and hardware by making a reasonable rough estimate for the server performance and the disk capacity of the database, at the same time, offer the system with a high performance guarantee by adopting advanced database parallel technique, the SAN memory technique, and disk RAID technique, etc.. Thus, the insufficiency of the system configuration and the problems arose from unreasonable system constructing are radically avoided.After the system constructing accomplished, the essential optimization and adjustment for the database interior have been done, mainly focus on the database parameters, the big table, and the SQL sentence.At present, the system runs stably with good performance, which can well satisfy the highly centralized business requirement for the press data within the whole nation. Meanwhile, this paper provides a feasible and integrated optimizing method for other application systems based on ORACLE database.