电视广告商务平台中Oracle数据库的ADICI设计与优化研究

发布时间：2018-03-18 22:48

本文选题：Oracle数据库　切入点：设计　出处：《中南大学》2011年硕士论文　论文类型：学位论文

【摘要】：电视的普及,带动了电视广告的飞速发展。广告已成为各个电视台收入的主要来源。为了在竞争日益激烈的广告行业中立于不败之地,电视台对电子商务平台的需求越来越强烈。电视广告商务平台正是在这样一种背景下产生的,它能有效协调广告主、电视台和广告公司的关系,简化广告播放的流程,降低广告错播率,从而提高电视台的经济效益。电视广告商务平台因其处理的数据非常庞大,需要一个强大的后台数据库做支撑。本文研究Oracle数据库在电视广告商务平台中的应用,针对应用系统对数据的高可用性需求,设计高性能电视广告商务平台Oracle数据库系统。要设计出高性能的数据库就要有强大的理论做支撑。本文在简要描述了电视广告行业各信息平台的总体架构及主要流程后,对Oracle数据库的体系结构,分级模式,数据库设计理论,在N-层级实现业务规则等都做了比较详细的分析和研究。结合电视广告商务平台项目提出了ADICI设计方法,讨论了Oracle集群技术、高可用性技术,为Oracle的横向扩展提供理论支撑。之后,用ADICI设计方法指导电视广告商务平台的整个数据库设计过程。采用分析表单和报表的方式提取实体集,用并行集成设计提升Oracle数据库的开发效率,并详细描述了CDM建模。将建立物理数据库分成两个阶段进行,以增强数据库开发的扩展性和灵活性。考虑到系统可能存在的性能问题,对Oracle数据库优化进行了研究。讨论了SQL优化技术、使用强选择性访问结构来提升数据库性能的方法和高级优化技术,如物化视图和行预取。本文最后对空位冲突算法进行了逻辑分析,提出了概率选择树模型,并结合模型最终用PL/SQL块实现了空位冲突算法。本文所采用的ADICI设计方法对其他信息系统或电子商务平台的数据库设计同样具有参考意义。
[Abstract]:The popularity of television has led to the rapid development of television advertising. Advertising has become the main source of revenue for television stations. In order to be invincible in the increasingly competitive advertising industry, The demand of TV stations for e-commerce platforms is getting stronger and stronger. The TV advertising business platforms are created under such a background, which can effectively coordinate the relationship between advertisers, television stations and advertising agencies, and simplify the process of advertising broadcast. Reduce the rate of misplacement of advertisements, thereby increasing the economic efficiency of television stations. The TV advertising business platform is very large in terms of the data it handles. This paper studies the application of Oracle database in TV advertising business platform, and designs the Oracle database system of high performance TV advertising business platform according to the high availability requirement of data in the application system. In order to design a high performance database, it is necessary to have a powerful theory to support it. After a brief description of the overall structure and main flow of various information platforms in the television advertising industry, the architecture and hierarchical model of the Oracle database are discussed. The theory of database design and the implementation of business rules in N- level are analyzed and studied in detail. Combining with the project of TV advertising business platform, the ADICI design method is put forward, and the Oracle cluster technology and high availability technology are discussed. It provides theoretical support for the horizontal expansion of Oracle. After that, the whole database design process of TV advertising business platform is guided by ADICI design method. The entity set is extracted by analyzing forms and reports. The parallel integration design is used to improve the development efficiency of Oracle database, and the modeling of CDM is described in detail. The physical database is divided into two stages. In order to enhance the expansibility and flexibility of database development, considering the possible performance problems of the system, the optimization of Oracle database is studied, and the optimization technology of SQL is discussed. Methods and advanced optimization techniques, such as materialized views and row prefetching, to improve database performance using strongly selective access structures. In the end of this paper, the vacancy conflict algorithm is analyzed logically, and the probability selection tree model is proposed. Finally, the vacancy collision algorithm is implemented with PL/SQL block. The ADICI design method used in this paper is also useful for the database design of other information systems or electronic commerce platforms.
【学位授予单位】：中南大学
【学位级别】：硕士
【学位授予年份】：2011
【分类号】：TP311.13

【相似文献】