Dissertation > Excellent graduate degree dissertation topics show

The Research and Application of Data Warehouse in Decision System of EMU Maintenance

Author: ZhaoHong
Tutor: ZhangChun
School: Beijing Jiaotong University
Course: Computer Science and Technology
Keywords: EMU Data warehouse Multidimensional model Online analytical processing Data cube Business Intelligence
CLC: TP311.13
Type: Master's thesis
Year: 2009
Downloads: 121
Quote: 1
Read: Download Dissertation

Abstract


Our use of EMU where maintenance decision-making , there are two main problems : First, the use of the existence of many different information systems , maintenance decision-makers in the integration of information in different systems can only rely on artificial completed ; Second, the information system accumulated a large amount of historical data in the application process , these data are independent of each other to accumulate in the database system , can not be converted into valuable information . In this context , the introduction of data warehouse and OLAP technology to the field of information construction of EMU , build decision support systems can be effectively integrated with the full use of existing data and maintenance of the state of parts of the decision-makers need to overhaul the information , fault records and other relevant data as a whole show out to assist in its development of maintenance decisions . This article first of all analyze the data organization EMU use by the current all kinds of moving car group information systems and the use of the business process , to determine the EMU key component state analysis , maintenance situation analysis , failure statistics and maintenance situation analysis of the four main themes domain , for each subject domain the design logic multidimensional model to combine the theory of multi - dimensional modeling , physical model design , design a the background storage architecture , dimension tables and fact tables , and discussed the possibility of partitioning and indexing techniques to optimize system performance . In this paper, the three modes of data warehouse -OLAP - BI system to achieve the conversion of data into knowledge . Application data warehouse ETL processes and OLAP data cube theory , the completion of the data source data to multidimensional model relational structure data , and then to the cube structure data conversion , and ultimately through BIEE presentation layer in the form of data reporting, analysis and map demonstrate to decision-makers . The application Oracle's Warehouse builder10g development OLAP 10g and the BIEE development platform to build three modes . In this paper, the design of moving car group maintenance decision-making system data warehouse , OLAP cubes with BIEE front-end interface implementation process using EMU use of the on-site data to complete the system functions after a preliminary test basic right , expectations provide effective information support for the maintenance of decision-makers .

Related Dissertations

  1. EMU maintenance base in Guangzhou Project Management Research,F532
  2. Data warehouse technology in the banking customer management systems research and implementation,TP315
  3. The Application of Association Rules Algorithm in Higher Vocational Colleges’ Endorsement of Impoverished Students,G717
  4. Research and Application of Home-School Education Platform Interactive Based on Warehouse,TP311.13
  5. Design and Implementation for Decision Support System of Drug Administration Based on Data Warehouse,TP311.13
  6. The Analysis and Application of Telecom Customer Retention System Based on Data Mining Technology,TP311.13
  7. PG steelworks MES system design and development of data mining,TP311.13
  8. Liupanshui City tobacco company's human resource management system integrated design and implementation,TP311.52
  9. Domain Ontology-based Marine Environmental Data Warehouse Design,TP311.13
  10. Design and Implementation of Metadata and Data Buffer in Column-oriented DWMS,TP311.13
  11. Optimization and Implementation for DWMS Column-Store Query Execution Engine,TP311.13
  12. Research on Monitoring and Early-Warning of TBT Risk in Textile and Garment,TP311.13
  13. The design and application of the tax data warehouse system,TP311.13
  14. Research and Implementation of medical resources management decision support system,TP311.52
  15. Research on the Project Requirement Management of the Telecommunications Business Intelligence System,TP311.52
  16. Based on Data Warehouse telecommunications targeted marketing support research,F626;F274
  17. The Exploitation and Application of Customer-Action Analysis System on Date Mining,TP311.13
  18. Student Management Based on Data Warehouse Decision Support System Design and Implementation,TP311.52
  19. POS data is based multidimensional space of marketing analysis,TP311.13
  20. XXX system design and implementation of data warehouse,TP311.13
  21. Based on statistical process diagram automatic query optimization technology accumulation table,TP311.13

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems
© 2012 www.DissertationTopic.Net  Mobile