Serial: Tell you how to design a daily traffic tens other systems, about Oracle Advanced Design and Development (2)

The following is a formal introduction to the actual large-scale projects Oracle the advanced design and development of the content, the following explanation Oracle both the content and the sample programs are based on ORACLE11R2 .

in order to prevent from actually doing a bunch of theories, I try to use practical examples to illustrate the problem, of course, some of the necessary theories sometimes need to be explained, because the content is advanced design and development, entry-level SQL and database concepts will not be explained in detail.

most IT projects, are all around the database for a variety of business, so also some people call this type of Project database project, that is, the database is the focus, have the project design experience is known, good database design, can make development and maintenance become simple, improve the system's extensibility. To design a good database system, the degree of knowledge of the database, coupled with personal business experience, directly determine the quality of the design.

Oracle The database is a huge system, from the big direction can be divided into Oracle internal architecture and external architecture. In the future, I will continue to introduce Oracle 's various knowledge structures through practical examples.

To start with, we are now going to develop a business survey system for millions traffic, and the survey users will participate in the lottery, and we begin to design the database.

because it is Oracle Advanced design and development of the explanation, the specific business analysis is not in-depth, simple explanation: From the user's point of view, the system will be divided into two parts, one is the front end of the site, a management background, from the business classification, will include the member management module, the questionnaire Content Management module, statistical analysis module, integration module, permission settings, System settings, and so on.

the next part of the member management module will be intercepted, detailing the database advanced design, leads to various Oracle knowledge, especially those that can be optimized for design and development, some of which are overlooked in business details. Please forgive me for your mistakes, thank you for your criticism.

The first thing to do is to determine the type of system, and the survey system is a OLTP System.

second, assess the amount of data that will be -Users , active users will have $million. -million users of course not small,1byte bits are20Mdata, if a member record information is0.5K, the size of the membership table is10G.

From the above two assessment and judgment can be concluded that the common enterprise management software design ideas is certainly not a good way.

The membership table in the usual membership system will include the following fields:

member ID , member login name, member login password, member nickname, member Email , member's Chinese name, document type, ID number, member mobile, member's gender, member type, member QQ number, contact phone, contact address, zip code, member's region, member's birthday, hobbies, occupation, post,

Self introduction, profile picture, registration time, etc.

Performance considerations are important in design and can be considered at least from the following five points:

A) reasonably define the data type of a field

B) splitting a membership table into multiple tables

C) Create a partitioned table

D) establish an appropriate index

E) data table space separation for table space and index table corresponding to normal table data

For the above five points discussed, to be continued ...

Serial: Tell you how to design a daily traffic tens other systems, about Oracle Advanced Design and Development (2)