【作者】 温创新；

【导师】 谭汉松；

【作者基本信息】 中南大学 ， 计算机科学与技术， 2011， 硕士

【摘要】 电视的普及,带动了电视广告的飞速发展。广告已成为各个电视台收入的主要来源。为了在竞争日益激烈的广告行业中立于不败之地,电视台对电子商务平台的需求越来越强烈。电视广告商务平台正是在这样一种背景下产生的,它能有效协调广告主、电视台和广告公司的关系,简化广告播放的流程,降低广告错播率,从而提高电视台的经济效益。电视广告商务平台因其处理的数据非常庞大,需要一个强大的后台数据库做支撑。本文研究Oracle数据库在电视广告商务平台中的应用,针对应用系统对数据的高可用性需求,设计高性能电视广告商务平台Oracle数据库系统。要设计出高性能的数据库就要有强大的理论做支撑。本文在简要描述了电视广告行业各信息平台的总体架构及主要流程后,对Oracle数据库的体系结构,分级模式,数据库设计理论,在N-层级实现业务规则等都做了比较详细的分析和研究。结合电视广告商务平台项目提出了ADICI设计方法,讨论了Oracle集群技术、高可用性技术,为Oracle的横向扩展提供理论支撑。之后,用ADICI设计方法指导电视广告商务平台的整个数据库设计过程。采用分析表单和报表的方式提取实体集,用并行集成设计提升Oracle数据库的开发效率,并详细描述了CDM建模。将建立物理数据库分成两个阶段进行,以增强数据库开发的扩展性和灵活性。考虑到系统可能存在的性能问题,对Oracle数据库优化进行了研究。讨论了SQL优化技术、使用强选择性访问结构来提升数据库性能的方法和高级优化技术,如物化视图和行预取。本文最后对空位冲突算法进行了逻辑分析,提出了概率选择树模型,并结合模型最终用PL/SQL块实现了空位冲突算法。本文所采用的ADICI设计方法对其他信息系统或电子商务平台的数据库设计同样具有参考意义。更多还原

【Abstract】 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.更多还原