Dissertation > Excellent graduate degree dissertation topics show

Design and Implementation of Data Warehouse in Community Service

Author: LiMingGuo
Tutor: LiuZhiJing
School: Xi'an University of Electronic Science and Technology
Course: Applied Computer Technology
Keywords: Data Warehouse Multidimensional Modeling ETL Community Service
CLC: TP311.13
Type: Master's thesis
Year: 2010
Downloads: 22
Quote: 0
Read: Download Dissertation

Abstract


Some basic concepts and theories of DW (data warehouse), ETL (data extraction, conversion, loading), OLAP (online analytical processing), DM (data mining) and the relationships among DW, OLAP and DM are introduced in this paper firstly. Then the data of Lian company is analyzed, after which requirement analysis, a dimensional model of data warehouse is designed using four-step dimensional modeling method, the index is designed in the background of Lian Community electronic services system(LESS). ETL, the data dump module is built in light of practical requirement of LESS, and the system’s goal, architecture, data structure, process logic and interface is detailed designed. Based on SybaselQ DW system, the Data Warehouse oriented community service is constructed eventually, which is the most significant research work.In this paper, then the data mart and multidimensional cube are constructed using OLAP tool based on relative themes, and associations analysis is constructed using DM tool. Our system explores the conditions and causes of Lian performance to help the decision-makers formulate optimal strategies in which way the business is expanded and improved. The practicality and effectiveness of the DW system designed in this paper is demonstrated properly with abundant graphic charts in the realization part. The research achievements are summarized and the future work is still in progress as shown in the last chapter.

Related Dissertations

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