高校数据中心的实现

发布时间：2018-01-21 14:28

本文关键词： 数据仓库元数据 ETL 数据集成　出处：《济南大学》2012年硕士论文　论文类型：学位论文

【摘要】：随着高校信息化建设的发展，学校建立了越来越多的应用系统，这些应用系统能基本满足部门日常工作的需要。但是各个系统表现为各自为政的信息化建设方式，多采用不同的数据库系统，数据结构和数据格式，导致了不同系统之间信息共享困难，并且由于大量数据重复存储，同一数据出处不同，造成了数据不一致，数据冗余，数据不正确等问题，影响了学校的信息化进程和工作效率。为了能够高效的使用学校的信息资源，实现信息共享，迫切的需要进行数据集成，建立一个共享数据中心的应用系统。本论文介绍了高校信息化建设的现状，针对存在的问题，在现有资源的基础上，设计了一个高校信息化建设的整体方案，并对高校数据中心的建立进行了详细的设计和实现。在文中，对系统进行需求分析和概要设计，确定了系统的功能模块，搭建了系统的整体架构。为了顺利完成高校数据中心的实现，要设计好用于数据抽取清洗转换加载的元数据和数据仓库的数据模型和数据流程。完成了用于数据集成的元数据的设计，确定了元数据的元素，设计好的元数据表格对每一个数据项的数据源、目标数据库、数据源与目标数据库的映射都进行了很好的定义，使元数据表格更合理，更易于共享数据库的实现。参照国家高校管理信息标准，结合学校实际情况，定义了共享数据库中的五层数据结构，设计了数据抽取转换加载的数据流程，完成了数据仓库的填充过程。本课题采用Myeclipse集成开发环境，使用Tomcat服务器，，Oracle数据库，设计实现了一个建立高校数据中心的应用系统，文中详细介绍了各个功能模块的实现过程，并对整个系统进行了测试。该系统实现了用户友好的界面，实现了数据的自动同步，完成了共享数据中心的建立，解决了数据不一致，共享困难等问题，为用户提供即时精确权威的共享数据。
[Abstract]:With the development of information construction in colleges and universities, more and more application systems have been established. These application systems can basically meet the needs of the daily work of the department. However, each system shows its own way of information construction, mostly using different database system, data structure and data format. It leads to the difficulty of information sharing among different systems, and because of a large number of data repeated storage, the same data source is different, resulting in inconsistent data, data redundancy, data incorrect and so on. In order to efficiently use the information resources of the school and realize the information sharing, it is urgent to integrate the data and establish an application system of the shared data center. This paper introduces the current situation of the information construction in colleges and universities, aiming at the existing problems, on the basis of the existing resources, designed an overall plan of the information construction in colleges and universities. And the establishment of the university data center is designed and implemented in detail. In this paper, the requirement analysis and summary design of the system are carried out, the functional modules of the system are determined, and the overall structure of the system is built. In order to realize the university data center successfully, we should design the data model and data flow of metadata and data warehouse which is used for data extraction, cleaning and transformation, and complete the design of metadata for data integration. The elements of metadata are determined, and the metadata table is designed to define the data source of each data item, the target database, the mapping between the data source and the target database, so as to make the metadata table more reasonable. More easily to share the implementation of database. Referring to the national university management information standards, combined with the actual situation of the school, defined the five-tier data structure in the shared database, designed the data extraction conversion loading data flow. The filling process of data warehouse is completed. This subject adopts the Myeclipse integrated development environment, uses the Tomcat server to develop the Oracle database, has designed and realized an application system which establishes the university data center. The realization process of each function module is introduced in detail, and the whole system is tested. The system realizes the user friendly interface, realizes the automatic synchronization of data, and completes the establishment of shared data center. It solves the problems of data inconsistency and sharing difficulty, and provides users with instant accurate and authoritative data sharing.
【学位授予单位】：济南大学
【学位级别】：硕士
【学位授予年份】：2012
【分类号】：TP308

【相似文献】