Research On Oracle Database ADICI Design And Optimization In Television Advertising Commerce Platform

The spread of television pushes forward the development of the TV advertisement,which becomes the major income of TV station.In order to win a place to set their feet in competitive advertizing,TV stations violently require a electronic commerce system. The television advertising commerce platform(TACP) appears in this requirement,which resolve the contradiction in advertiser,TV station and advertising company, shorten the complex procedure in playing advertisement,reduce the probability of playing inaccurate advertise and increase TV station's income.Taking account of the enormous data to deal with,the TACP should hava a powerful database to support this application.In this thesis,we research the application of Oracle database in TACP, design a high-performance Oracle database on account of the high availability of data in application system.Designing a high availability database should hava a convincing theory.The thesis deeply discusses the architecture and hierarchical model of oracle database,design theory for database and implement of the business rule in N-level after describing the global structure and main business process of the TACP and put forward the ADICI design method combining the practice of the TACP project.Oracle's high availability and RAC technology are also discussed,which is the theoretical basis for the parallel extension of oracle. After that,using the ADICI design method directs the overall procedure of the TACP'database design.Utilize the forms and reports to extract the entity set,make use of parallel design method to improve the efficiency of database development and describe the CDM modeling in detail.Divide the process of constructing physical database into two steps,which enhance the flexibility and expansibility of database development. This thesis researchs the oracle performance optimization taking account of the system performance problem.Discuss the optimization technique of SQL,apply filterable accessing structure to advance the performance of database and high-grade optimization technique,such as materialized view and row prefetching. Finally,we analyse the logic of blankposition collision algorithm, put forward the selected tree model based on probability,and implement the blankposition collision algorithm with PL/SQL block combining this model in the end. The ADICI design method discussed in this thesis can also be used as the reference when design a database for information system or e-commerce platform.