面向对象的数据建模——数据筛选接口的设计

包括论文,设计,论文字数:8237,页数:29

摘  要
《WISE系统》是一个功能强大的数据处理系统。它应用于某公司，此公司由于行业的关系需要它去处理庞大的数据，这些数据每天都在以上百万条甚至上亿条的数量在增加。因此它需要处理海量的数据，它的其中一个比较重要的功能是根据复杂并且灵活的条件筛选出适当的数据返回给客户。本论文主要讲述了如何针对数据筛选条件比较复杂并且比较灵活这一需求，在做了详尽的需求分析之后，进行了一系列的设计，包括解决方案的设计，数据建模，PL/SQL程序设计，最终完成整个数据筛选接口的设计。在整个数据筛选接口的设计中，在传统的关系性数据库的基础上，会尝试着应用一些面向对象的思想去设计。尤其在数据建模阶段,通过传统的数据模型之间的关系,例如主外键关系,实现了一些重要的面向对象的思想。

关键字：数据筛选；面向对象；数据建模；PL/SQL
Implement the Object Oriented thinking in the project to data modeling
——the design about the API to filter data
Abstract
《The WISE system》 is a powerful system for data processing .It is applied in a company which needs to use this system to process huge amount data. And these data will be increased by millions or hundreds millions.   So it needs to process the huge amount data .One of its important function is return the right data to client filtered by some complex and flexible conditions. The most content of the paper talks about how to finish the total design for the requirement which is the conditions to filter data can be complex and flexible. The entire design will include the design of project to solve problem, the design about data modeling, and the design about PL/SQL program. Finally the all designs to implement the interface for filtering the data are finished .We will try implementing the object oriented thinking to design on the base of the relational database in the process to finish all the design. Especially in the process to implement data modeling, we will implement some important object oriented thinking by some relations among traditional data models, such as PK or FK relationship.

Key words: data filtration；object oriented；data modeling；PL/SQL

目  录

1 引  言 1
2 开发概述 1
3 需求分析 1
3．1 需求调研 1
3．2 开发运行环境 3
4 解决方案的设计 3
5 数据建模 8
5.1 数据模型的建立 8
5.2 数据库表结构的设计 9
5.3 数据库基础视图的设计 11
6 PL/SQL程序设计 12
结    论 22
参考文献 22
致    谢 23
声    明 24