优化数据库（Optimization of database）.docVIP

优化数据库（Optimization of database） Database optimization strategy in 2009 03 months 16 days 11:25, this paper firstly discusses the basic design of the database table third based on the paradigm, focuses on the strategy and plan of establishing the primary key and index, and then from the database table design and database table expansion object placement summarized the optimization scheme of database management system. Keywords: optimization (Optimizing), third paradigm (3NF), redundant data (Redundant, Data), index (Index), data segmentation (Data, Partitioning), object placement (Object, Placement) 1 Introduction The goal of database optimization is to avoid disk I/O bottlenecks, reduce CPU utilization, and reduce resource contention. In order to facilitate the readers to read and understand, the author refer to Sybase, Informix and Oracle and other large database system reference, based on years of experience in engineering practice, from the basic table design, expansion design and database object placement angle discussion focuses on how to avoid I/O disk bottlenecks and reduce resource competition, I believe that readers will be clear at a glance. 2 basic table design based on the third paradigm In a table driven information management system (MIS), the design specification for the base table is the third paradigm (3NF). The basic feature of the third paradigm is that non primary key attributes depend only on primary key attributes. It has many advantages in database design paradigm based on table third: one is to eliminate the redundant data, saves disk storage space; two is a good data integrity constraints, which is based on the foreign key reference integrity constraints and entity integrity constraints based on the primary key, the data is easy to maintain, easy to transplant and update; three is the reversible data, in the connection table or query (Join) is missing, do not repeat; four is due to the elimination of redundant data (Rong Yulie), in the query