ORACLE Database's Application In The Large-scale Website

This thesis is based on "Yue Tan Shi Jie" e-commerce Web site's database structure of design, store and design, control, optimize, backup and recover, Combined the theory knowledge of study at school and the database administration experience of some other web site, such as "zhong guo zhi men", "agricultural product of China trade network", etc., Produced and published a practical scheme of database's structure design, store design, control, performance optimize and backup. The thesis introduced the demand analysis of the e-commerce Web site of "Yue Tan Shi Jie" in detail, Plan of design of structure of data base put forward on the basis of analyzing in demand, And during function of website, how be according to the actual conditions of the website, Carry on the performance of the data base to optimize, control, backup. Besides, utilizing the knowledge and experience of the database in the software developing, have finished the function core of the website -Trade Deal Program that on the basis of the database application.Have introduced the demand analysis of the e-commerce Web site of "Yue Tan Shi Jie" in detail in the thesis, Have put forward the plan of structure design of the database on the basis of demand analysis, And during function of website, how be according to the actual conditions of the website, Make procedure to control database space, memory change, data file change situation regularly; How to carry on the database performance optimize according to the controlling report; How to make backup schemes. Not merely makes the management scheme can be suitable for the website and affairs intensive ORACLE database, extensively in this thesis, Having listed most procedure source codes at the same time, these codes can be used in many platforms.The demand and system related to website construction of "Yue Tan Shi Jie" even is analyzed in the thesis, And to what I finished " trade deal procedure" this application program based on database, Analyze it's structure in detail and draw flow chart, Introduce opening manage module and closing manage module. This procedure not only has realized the key function of the electronic trade of website of "Yue Tan Shi Jie" but also has realized that the database relevant tables operate during opening and closing trade. Through the procedure, discuss how to combined operating system knowledge, database knowledge, application and development knowledge in a project.