电视广告商务平台中Oracle数据库的ADICI设计与优化研究
|
摘要
电视的普及,带动了电视广告的飞速发展。广告已成为各个电视台收入的主要来源。为了在竞争日益激烈的广告行业中立于不败之地,电视台对电子商务平台的需求越来越强烈。电视广告商务平台正是在这样一种背景下产生的,它能有效协调广告主、电视台和广告公司的关系,简化广告播放的流程,降低广告错播率,从而提高电视台的经济效益。电视广告商务平台因其处理的数据非常庞大,需要一个强大的后台数据库做支撑。本文研究Oracle数据库在电视广告商务平台中的应用,针对应用系统对数据的高可用性需求,设计高性能电视广告商务平台Oracle数据库系统。
要设计出高性能的数据库就要有强大的理论做支撑。本文在简要描述了电视广告行业各信息平台的总体架构及主要流程后,对Oracle数据库的体系结构,分级模式,数据库设计理论,在N-层级实现业务规则等都做了比较详细的分析和研究。结合电视广告商务平台项目提出了ADICI设计方法,讨论了Oracle集群技术、高可用性技术,为Oracle的横向扩展提供理论支撑。之后,用ADICI设计方法指导电视广告商务平台的整个数据库设计过程。采用分析表单和报表的方式提取实体集,用并行集成设计提升Oracle数据库的开发效率,并详细描述了CDM建模。将建立物理数据库分成两个阶段进行,以增强数据库开发的扩展性和灵活性。考虑到系统可能存在的性能问题,对Oracle数据库优化进行了研究。讨论了SQL优化技术、使用强选择性访问结构来提升数据库性能的方法和高级优化技术,如物化视图和行预取。
本文最后对空位冲突算法进行了逻辑分析,提出了概率选择树模型,并结合模型最终用PL/SQL块实现了空位冲突算法。本文所采用的ADICI设计方法对其他信息系统或电子商务平台的数据库设计同样具有参考意义。
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.
要设计出高性能的数据库就要有强大的理论做支撑。本文在简要描述了电视广告行业各信息平台的总体架构及主要流程后,对Oracle数据库的体系结构,分级模式,数据库设计理论,在N-层级实现业务规则等都做了比较详细的分析和研究。结合电视广告商务平台项目提出了ADICI设计方法,讨论了Oracle集群技术、高可用性技术,为Oracle的横向扩展提供理论支撑。之后,用ADICI设计方法指导电视广告商务平台的整个数据库设计过程。采用分析表单和报表的方式提取实体集,用并行集成设计提升Oracle数据库的开发效率,并详细描述了CDM建模。将建立物理数据库分成两个阶段进行,以增强数据库开发的扩展性和灵活性。考虑到系统可能存在的性能问题,对Oracle数据库优化进行了研究。讨论了SQL优化技术、使用强选择性访问结构来提升数据库性能的方法和高级优化技术,如物化视图和行预取。
本文最后对空位冲突算法进行了逻辑分析,提出了概率选择树模型,并结合模型最终用PL/SQL块实现了空位冲突算法。本文所采用的ADICI设计方法对其他信息系统或电子商务平台的数据库设计同样具有参考意义。
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.
引文
[1]陈荣勇.2010中央电视台的广告与发展[J].中国广告,2011,(2)：42-45.
[2]徐虎虎.电视广告的现状与未来发展[J].法制与社会,2009,(15)：264-264.
[3]聂艳悔.论电视广告的发展趋势[J].北京商学院学报,2000,15(5)：77-80.
[4]陈刚,赵梅.电视媒体的新机遇与电视广告经营的发展[J].电视研究,2011,(1)：9-12.
[5]黄升民,管倩,李子钧.2010年电视广告市场的走向[EB/OL]. http://www. ciu.gov.cn/Webnews/News/News/2010-03-08/100308024003299.html,2010.
[6]尚普咨询(S&P Consulting)中国电视广告的发展现状及投资前景预测报告[EB/OL]. http://www.cu-market.com.cn/hybg/2010-9-6/144941922877.html,20 10.
[7]李嘉.收费电视广告的发展前景和对策分析[J].今日南国,2009,(6)：135-136.
[8]刘潆檑,莫梅锋.电视互动广告的发展现状与问题[J].电视研究,2010,(7)：59-61.
[9]汤庸.高级数据库技术与应用[M].北京：高等教育出版社,2008：1-234.
[10]Ping Chen. Goal-oriented Schema in Biological Database Design[C]. Manageme-nt of Biological Databases(3cu),spring 2008.
[11]Panagiotis Afratis, Constantinos Galanakis. Design and Implementation of a Database Filter for BLAST Acceleration [C]. Proceedings of the Conference on Design, Automation, and Test in Europe:2009,166-171.
[12]Meike Klettke. Reuse of database design decisions[J]. Computer Science,1999, 1727(1999):213-224.
[13]Hui Ma,Rene Noack,Klaus-Dieter Schewe. Using Meta-Structures in Database Design[J].Informatica,2010,(34):387-403.
[14]Theresa Beaubouef, Frederick E. Petty. Uncertainty modeling for database design using intuitionistic and rough set theory[J]. Journal of Intelligent & Fuzzy Systems,2009,20(3):105-117.
[15]Henning Kohler. Global Database Design based on Storage Space and Update Ti-me Minimization[J]. Universal Computer Science,2009,15(1):195-240.
[16]Mazimpaka Jean Damascene. Methodical spatial database design with Topolog-ical polygon structures[D]. International institute for GEO-information science and earth observation enschede,the Netherlands,2009.
[17]Sang-Wook KIM, Jinho KIM. Physical Database Design for Efficient Time-Ser-ies Similarity Search [J]. IEICE TRANS. COMMUN,2008,91(4):1251-1254.
[18]Lik Wong, Nimar S. Arora. A High Performance Implementation for Near Real Time Asynchronous Replication[C]. International Conference on Data Engineeri-ng:2009,1363-1374.
[19]Jozsef Patvarczki, Murali Mani, Neil Heffernan. Performance Driven Database Design for Scalable Web Application[C]. the 13th East European Conference on Advances in Databases and Information Systems:2009,43-58.
[20]Gerard Tel分布式算法导论[M].北京：机械工业出版社,2004：1-6.
[21]Benoit Dageville, Dinesh Das,Karl Dias. Automatic SQL Tuning in Oracle 10g [C]. The 30th VLDB Conference,Toronto,Canada:2004,1098-1109.
[22]Thomas Blumensath and Mike E. Davies. guaranteed stability and performance [J]. IEEE Signal Processing Society,2010,4(2):298-309.
[23]NAZLIA OMAR, ROSILAH HASSAN. Automation of Database Design throu-gh Semantic Analysis[C]. The 7th WSEAS Int. Conf. on COMPUTATIONAL INTELLIGENCE, MAN-MACHINE SYSTEMS and CYBERNETI CS:2010, 71-76.
[24]Hannes Voigt, Wolfgang Lehner, Kenneth Salem. Constrained Dynamic Physical Database Design[C]. IEEE 24th International Conference on Data Engineering Workshop:2008,63-70.
[25]Martin Graciarena,Michelle Delplanche. ACOUSTIC FRONT-END OPTIMIZA-TION FOR BIRD SPECIES RECOGNITION[N]. IEEE International Conferen-ce on ICASSP:2010,293-296.
[26]Afgan, Enis,Skala. Design and Implementation of a Readily Available Historical Application Performance Database (AppDB) for Grid[C]. International conventi-on on information and communication technology, electronics and microelectro-nics, Opatija, Hrvatska:2010,313-318.
[27]Li Qian, Kristen LeFevre. CRIUS:UserFriendly Database Design[J]. Proceedings of the VLDB Endowment,2010,4(2):81-92.
[28]Pankaj Gupta, Rahul Rishi, Harish Mittal. Database Design for Storage of Fuzzy Information inTraditional Database[J]. International Journal of Computer Appli-cations,2011,15(2):40-45.
[29]Zhao Erfeng, Wang Yachao. Multi-dimensional database design and implementa -tion of dam safety monitoring system[J]. Water Science and Engineering,2008, 1(3):112-120.
[30]Tanu Malik, Xiaodan Wang, Randal Burns. Automated Physical Design in Database Caches[C]. the 2008 IEEE 24th International Conference on Data Engineering Workshop,2008:27-34.
[31]Krizhanovsky A. A. Index wiki database:design and experiments[C]. The 11th Russian Conference on Digital Libraries,Petrozavodsk, Russia,2009:363-369.
[32]Sherif Abdelwahed, Jia Bai, Rong Su. On the Application of Predictive Control-Techniques for Adaptive Performance Managementof Computing Systems[J]. IEEE TRANSACTIONS ON NETWORK AND SERVICE MANAGEMENT, 2009,6(4):212-225.
[33]Maguelonne Teisseird, Pascal Poncelet. Towards Event-Driven Modelling for Database Design[C]. the 20th VLDB Conference,Santiago, Chile,1994:285-296.
[34]Shengjun Zhong, Zhufang Wang, Tianping Bi. Key Technique Analysis of the Management Information System for Provincial MineralResources Based on Arc-GIS[J]. Information and Communication Technology,2009,2(4):179-184.
[35]Michanel V.Mannino数据库设计、应用开发和管理[M].北京：清华大学出版社,2007：181-189.
[36]Thomas Kyte著,钟鸣郝玉洁等译.Oracle高效设计[M].北京：机械工业出版社,2006：1-466
[37]Ryan K.Stephens, Ronald R.Plew.数据库设计[M].北京：机械工业出版社,2001：34-207.
[38]陈吉平.构建Oracle高可用环境[M].北京：电子工业出版社,2008：5-421.
[39]Christian Antognini. Troubleshooting Oracle Performance[M]北京：人民邮电出版社,2009：1-428.
[40]周龙骧.分布式数据库管理系统实现技术[M].北京：科学出版社,1998：1-6.
[41]Ralph Kimball数据仓库生命周期工具箱[M].北京：清华大学出版社,2009：270-272.
[42]钟明,苏宏业.基于B/S结构的物流管理系统与应用[J].计算机应用研究,2005,22(9)：203-205.
[43]刘风龙Oracle监控处理系统的设计与实现[J].计算机工程,2009,35(10)：54-59.
[44]陈秀英.大型Oracle数据库系统的优化设计方案[J].舰船科学技术,2009,31(2)：150-153.
[45]孙风栋,闫海珍Oracle 1Og数据库系统性能优化与调整[J].计算机技术与发展,2009,19(2)：83-86.
[46]Y.-S. Maa, S.-H. Tang. Collaborative feature-based design via operations with a fine-grainproduct database[J]. Computers in Industry,2009,60(6):381-391.
[47]Stratos Papadomanolakis, Anastassia Ailamaki. An Integer Linear Programming Approach to Database Design[C]. the IEEE 23rd International Conference on Data Engineering Workshop,2007:442-449.
[48]SOLMAZ KOLAHI, LEONID LIBKIN. An information-theoretic analysis of worst-case redundancy in database design[J]. ACM Transactions on Database Systems,2010,V(N):1-77.
[49]严蔚敏,吴伟民.数据结构(C语言版)[M].北京：清华大学出版社,1997：238-246.
[50]Xiaoqiang Liu and Ning Jiang. The Design of Mixed Database in the 4PL Infra-structure[C]. the international MultiConference of Engineers and computer scien-tists,2010,1:17-19.
[51]AvromRoy-Faderman, Peter Koletzke,Paul Dorsey. Oracle JDeveloper lOg开发手册[M].北京：清华大学出版社,2006：143-154.
[52]Hsiang-Jui Kung. COMPARING TWO BOTTOM-UP DATABASE DESIGN METHODS[C]. Southern Association for Information Systems Conference,2007: 87-92.
[53]Anne C.S. McIntosh, Judith B. Cushing. Database design for ecologists:Compos-ing coreentities with observations[J]. ecological informatics,2007,2(3):225-235.
[54]DAVID G. HENDRY. History Places:A Case Study for Relational Database and Information Retrieval System Design[J]. ACM Journal on Educational Resource in Computing,2007,7(1),Article 3:1-20.
[55]王珊.数据库系统概论[M].北京：高等教育出版社,2006：174-182.
[56]Brajesh Goyal, Shilpa Lawande. Oracle 网格计算[M].北京:清华大学出版社, 2007:160-162.
[57]Erez Shmueli, Ronen Vaisenberg. Database Encryption-An Overview of Contem-porary Challenges and Design Considerations[J]. ACM SIGMOD Record,2009, 38(3):29-34.
[58]ANTHONY MARMAROU, JUAN LU. IMPACT Database of Traumatic Brain Injury:Design and Description[J]. NEUROTRAUMA,2007,24(2):239-250.
[59]Markus Olsson. Design and Implementation of Transactions in a Column Orie -nted In-Memory Database System[D]. Umea University,2010.
[60]Donald R. Chand. INCORPORATING DATABASE DESIGN IN WARMER METHOD[J]. AJIS,2000,8(1):17-28.
[61]Linda Lilburne, Allan Hewitt and Steve Ferriss. Progress with the design of a soil uncertainty database, andassociated tools for simulating spatial realisations of soil properties[C]. the 7th International Symposium on Spatial Accuracy Assessment in Natural Resources and Environmental Sciences,2006:510-519.
[62]Ayman Al-Dmour. A Cognitive Apprenticeship Based Approach to Teaching Re-lational Database Analysis and Design[J]. Information & Computational Scien-ce,2010,7(12):2495-2502.
[2]徐虎虎.电视广告的现状与未来发展[J].法制与社会,2009,(15)：264-264.
[3]聂艳悔.论电视广告的发展趋势[J].北京商学院学报,2000,15(5)：77-80.
[4]陈刚,赵梅.电视媒体的新机遇与电视广告经营的发展[J].电视研究,2011,(1)：9-12.
[5]黄升民,管倩,李子钧.2010年电视广告市场的走向[EB/OL]. http://www. ciu.gov.cn/Webnews/News/News/2010-03-08/100308024003299.html,2010.
[6]尚普咨询(S&P Consulting)中国电视广告的发展现状及投资前景预测报告[EB/OL]. http://www.cu-market.com.cn/hybg/2010-9-6/144941922877.html,20 10.
[7]李嘉.收费电视广告的发展前景和对策分析[J].今日南国,2009,(6)：135-136.
[8]刘潆檑,莫梅锋.电视互动广告的发展现状与问题[J].电视研究,2010,(7)：59-61.
[9]汤庸.高级数据库技术与应用[M].北京：高等教育出版社,2008：1-234.
[10]Ping Chen. Goal-oriented Schema in Biological Database Design[C]. Manageme-nt of Biological Databases(3cu),spring 2008.
[11]Panagiotis Afratis, Constantinos Galanakis. Design and Implementation of a Database Filter for BLAST Acceleration [C]. Proceedings of the Conference on Design, Automation, and Test in Europe:2009,166-171.
[12]Meike Klettke. Reuse of database design decisions[J]. Computer Science,1999, 1727(1999):213-224.
[13]Hui Ma,Rene Noack,Klaus-Dieter Schewe. Using Meta-Structures in Database Design[J].Informatica,2010,(34):387-403.
[14]Theresa Beaubouef, Frederick E. Petty. Uncertainty modeling for database design using intuitionistic and rough set theory[J]. Journal of Intelligent & Fuzzy Systems,2009,20(3):105-117.
[15]Henning Kohler. Global Database Design based on Storage Space and Update Ti-me Minimization[J]. Universal Computer Science,2009,15(1):195-240.
[16]Mazimpaka Jean Damascene. Methodical spatial database design with Topolog-ical polygon structures[D]. International institute for GEO-information science and earth observation enschede,the Netherlands,2009.
[17]Sang-Wook KIM, Jinho KIM. Physical Database Design for Efficient Time-Ser-ies Similarity Search [J]. IEICE TRANS. COMMUN,2008,91(4):1251-1254.
[18]Lik Wong, Nimar S. Arora. A High Performance Implementation for Near Real Time Asynchronous Replication[C]. International Conference on Data Engineeri-ng:2009,1363-1374.
[19]Jozsef Patvarczki, Murali Mani, Neil Heffernan. Performance Driven Database Design for Scalable Web Application[C]. the 13th East European Conference on Advances in Databases and Information Systems:2009,43-58.
[20]Gerard Tel分布式算法导论[M].北京：机械工业出版社,2004：1-6.
[21]Benoit Dageville, Dinesh Das,Karl Dias. Automatic SQL Tuning in Oracle 10g [C]. The 30th VLDB Conference,Toronto,Canada:2004,1098-1109.
[22]Thomas Blumensath and Mike E. Davies. guaranteed stability and performance [J]. IEEE Signal Processing Society,2010,4(2):298-309.
[23]NAZLIA OMAR, ROSILAH HASSAN. Automation of Database Design throu-gh Semantic Analysis[C]. The 7th WSEAS Int. Conf. on COMPUTATIONAL INTELLIGENCE, MAN-MACHINE SYSTEMS and CYBERNETI CS:2010, 71-76.
[24]Hannes Voigt, Wolfgang Lehner, Kenneth Salem. Constrained Dynamic Physical Database Design[C]. IEEE 24th International Conference on Data Engineering Workshop:2008,63-70.
[25]Martin Graciarena,Michelle Delplanche. ACOUSTIC FRONT-END OPTIMIZA-TION FOR BIRD SPECIES RECOGNITION[N]. IEEE International Conferen-ce on ICASSP:2010,293-296.
[26]Afgan, Enis,Skala. Design and Implementation of a Readily Available Historical Application Performance Database (AppDB) for Grid[C]. International conventi-on on information and communication technology, electronics and microelectro-nics, Opatija, Hrvatska:2010,313-318.
[27]Li Qian, Kristen LeFevre. CRIUS:UserFriendly Database Design[J]. Proceedings of the VLDB Endowment,2010,4(2):81-92.
[28]Pankaj Gupta, Rahul Rishi, Harish Mittal. Database Design for Storage of Fuzzy Information inTraditional Database[J]. International Journal of Computer Appli-cations,2011,15(2):40-45.
[29]Zhao Erfeng, Wang Yachao. Multi-dimensional database design and implementa -tion of dam safety monitoring system[J]. Water Science and Engineering,2008, 1(3):112-120.
[30]Tanu Malik, Xiaodan Wang, Randal Burns. Automated Physical Design in Database Caches[C]. the 2008 IEEE 24th International Conference on Data Engineering Workshop,2008:27-34.
[31]Krizhanovsky A. A. Index wiki database:design and experiments[C]. The 11th Russian Conference on Digital Libraries,Petrozavodsk, Russia,2009:363-369.
[32]Sherif Abdelwahed, Jia Bai, Rong Su. On the Application of Predictive Control-Techniques for Adaptive Performance Managementof Computing Systems[J]. IEEE TRANSACTIONS ON NETWORK AND SERVICE MANAGEMENT, 2009,6(4):212-225.
[33]Maguelonne Teisseird, Pascal Poncelet. Towards Event-Driven Modelling for Database Design[C]. the 20th VLDB Conference,Santiago, Chile,1994:285-296.
[34]Shengjun Zhong, Zhufang Wang, Tianping Bi. Key Technique Analysis of the Management Information System for Provincial MineralResources Based on Arc-GIS[J]. Information and Communication Technology,2009,2(4):179-184.
[35]Michanel V.Mannino数据库设计、应用开发和管理[M].北京：清华大学出版社,2007：181-189.
[36]Thomas Kyte著,钟鸣郝玉洁等译.Oracle高效设计[M].北京：机械工业出版社,2006：1-466
[37]Ryan K.Stephens, Ronald R.Plew.数据库设计[M].北京：机械工业出版社,2001：34-207.
[38]陈吉平.构建Oracle高可用环境[M].北京：电子工业出版社,2008：5-421.
[39]Christian Antognini. Troubleshooting Oracle Performance[M]北京：人民邮电出版社,2009：1-428.
[40]周龙骧.分布式数据库管理系统实现技术[M].北京：科学出版社,1998：1-6.
[41]Ralph Kimball数据仓库生命周期工具箱[M].北京：清华大学出版社,2009：270-272.
[42]钟明,苏宏业.基于B/S结构的物流管理系统与应用[J].计算机应用研究,2005,22(9)：203-205.
[43]刘风龙Oracle监控处理系统的设计与实现[J].计算机工程,2009,35(10)：54-59.
[44]陈秀英.大型Oracle数据库系统的优化设计方案[J].舰船科学技术,2009,31(2)：150-153.
[45]孙风栋,闫海珍Oracle 1Og数据库系统性能优化与调整[J].计算机技术与发展,2009,19(2)：83-86.
[46]Y.-S. Maa, S.-H. Tang. Collaborative feature-based design via operations with a fine-grainproduct database[J]. Computers in Industry,2009,60(6):381-391.
[47]Stratos Papadomanolakis, Anastassia Ailamaki. An Integer Linear Programming Approach to Database Design[C]. the IEEE 23rd International Conference on Data Engineering Workshop,2007:442-449.
[48]SOLMAZ KOLAHI, LEONID LIBKIN. An information-theoretic analysis of worst-case redundancy in database design[J]. ACM Transactions on Database Systems,2010,V(N):1-77.
[49]严蔚敏,吴伟民.数据结构(C语言版)[M].北京：清华大学出版社,1997：238-246.
[50]Xiaoqiang Liu and Ning Jiang. The Design of Mixed Database in the 4PL Infra-structure[C]. the international MultiConference of Engineers and computer scien-tists,2010,1:17-19.
[51]AvromRoy-Faderman, Peter Koletzke,Paul Dorsey. Oracle JDeveloper lOg开发手册[M].北京：清华大学出版社,2006：143-154.
[52]Hsiang-Jui Kung. COMPARING TWO BOTTOM-UP DATABASE DESIGN METHODS[C]. Southern Association for Information Systems Conference,2007: 87-92.
[53]Anne C.S. McIntosh, Judith B. Cushing. Database design for ecologists:Compos-ing coreentities with observations[J]. ecological informatics,2007,2(3):225-235.
[54]DAVID G. HENDRY. History Places:A Case Study for Relational Database and Information Retrieval System Design[J]. ACM Journal on Educational Resource in Computing,2007,7(1),Article 3:1-20.
[55]王珊.数据库系统概论[M].北京：高等教育出版社,2006：174-182.
[56]Brajesh Goyal, Shilpa Lawande. Oracle 网格计算[M].北京:清华大学出版社, 2007:160-162.
[57]Erez Shmueli, Ronen Vaisenberg. Database Encryption-An Overview of Contem-porary Challenges and Design Considerations[J]. ACM SIGMOD Record,2009, 38(3):29-34.
[58]ANTHONY MARMAROU, JUAN LU. IMPACT Database of Traumatic Brain Injury:Design and Description[J]. NEUROTRAUMA,2007,24(2):239-250.
[59]Markus Olsson. Design and Implementation of Transactions in a Column Orie -nted In-Memory Database System[D]. Umea University,2010.
[60]Donald R. Chand. INCORPORATING DATABASE DESIGN IN WARMER METHOD[J]. AJIS,2000,8(1):17-28.
[61]Linda Lilburne, Allan Hewitt and Steve Ferriss. Progress with the design of a soil uncertainty database, andassociated tools for simulating spatial realisations of soil properties[C]. the 7th International Symposium on Spatial Accuracy Assessment in Natural Resources and Environmental Sciences,2006:510-519.
[62]Ayman Al-Dmour. A Cognitive Apprenticeship Based Approach to Teaching Re-lational Database Analysis and Design[J]. Information & Computational Scien-ce,2010,7(12):2495-2502.