Dissertation > Excellent graduate degree dissertation topics show

The Research and Application on Slowly Changing Dimensions in Multidimensional Model

Author: YangJin
Tutor: PeiXiaoBing
School: Huazhong University of Science and Technology
Course: Software Engineering
Keywords: Data warehouse Multi-dimension data model Star schema Slowly changing dimension
CLC: TP311.13
Type: Master's thesis
Year: 2009
Downloads: 28
Quote: 0
Read: Download Dissertation

Abstract


Enterprise information construction has accumulated a lot of business data for companies. Therefore, the problems faced by companies today is not how to find data, but how to take full advantage of these existing useful data, from which to explore the potential commercial value in order to promote further development of business. The emergence of data warehouse technology precisely meets the urgent needs of the enterprise.Data warehouse provides an integrated data environment, which can carry out a series of comprehensive operation on company historical data, such as extraction, cleaning, integration and so on, and then load it into databases of data warehouse. The data warehouse is subject oriented. Analysts point of view depending on the angles which they observe the data, in order to verify their business prediction. In data warehouse, multi-dimensional data model is one of data models which is most used. According it business data is divided into fact data and dimension data. The fact data is used to measure the operational indicators; the dimension data indicate the various descriptive data.In multi-dimensional data model, dimension is the angle which analysts analysis the business data. Different perspectives can yield different results. On dimension of data warehouse, its value does not always remain the same. This leads to an update issues of slowly changing dimension in data warehouse. Slowly changing dimension is focus on attributes which change in the frequency and change slowly. When the dimension attributes change, the angles are used to observe fact data change, so the result of data analysis is different. When the dimension attribute values change, its changes should be timely reflected in data warehouse databases, so that the data warehouse can correctly track the data before and after change. The event-based update solution for slowly changing dimensions is response to this issue, which combines three existing strategies: directly coverage of the property value, add dimension record rows and add dimension columns. Meanwhile, it uses the event mechanism to accurately monitor the dimension attribute changes in operational databases. The event-based update model for slowly changing dimension saves storage space trough incremental approach, at the same time, it embodies the advantage of real time operations.

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. Research and Implementation of medical resources management decision support system,TP311.52
  14. Based on Data Warehouse telecommunications targeted marketing support research,F626;F274
  15. The Exploitation and Application of Customer-Action Analysis System on Date Mining,TP311.13
  16. Student Management Based on Data Warehouse Decision Support System Design and Implementation,TP311.52
  17. POS data is based multidimensional space of marketing analysis,TP311.13
  18. XXX system design and implementation of data warehouse,TP311.13
  19. Based on statistical process diagram automatic query optimization technology accumulation table,TP311.13
  20. Based on Data Warehouse Management System NCMS,TP311.13
  21. Telecommunications based on data warehouse design and implementation of management analysis system,TP311.52

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