Dissertation > Excellent graduate degree dissertation topics show

Design and Implementation of ETL Module for Business Intelligence System

Author: ZhuJinXiao
Tutor: SongBin；ZhengZuo
School: Xi'an University of Electronic Science and Technology
Course: Software Engineering
Keywords: Business Intelligence ETL Data Mart Grid
CLC: TP311.52
Type: Master's thesis
Year: 2011
Downloads: 111
Quote: 2
Read: Download Dissertation

Abstract


In recent years, grid computing and business intelligence become more and more popular both in research and practice area. Adopted by many companies, grid technology greatly improves the efficiency and utilization of computing resources. And business intelligence technology which aims to turn business data to knowledge helps companies to make more sensible business decisions. Concerning the resource information and job running data of LSF(Load Sharing Facility), a grid cluster job-management system developed by Platform Computing company, an business intelligence system Platform Analytics is proposed to assist company managers to analyze data.Firstly, this paper analyzes the framework of Platform Analytics system, which is oriented to gird environment, deciding the important position of ETL (Extraction-Transformation-Loading) module in business intelligence system. Secondly, through analyzes the requirement of ETL module in PA business system, a configurable ETL module is designed and implemented. ETL module, whose main function is performing data translation, plays a core role in the business intelligence system. According to different functions, ETL module can be devided into ETL engine, Extractor sub-module, Tansformer sub-module, and Loader sub-module. The ETL module designed in this paper can transform raw data to data warehouse according to the configuration files.Finally, according to Platform Analytics application environment, an ETL flow instance is designed to verify the proposed ETL module. The result shows that the ETL module can complete data transformation from database to datamarts; moreover, it has good extensibility and usablity. The proposed ETL module has been applied to the development Platform Analytics, a business intelligence system of Platform Computing company.

Related Dissertations

  1. Grid-Side Converter Control and Wind Turbine Emulator in Direct Drive Wind Power System,TM46
  2. The Establishment of Grid Platform on Agricultural Supply Chain System,S126
  3. The Study on the Management of the Labor Security Inspection,F249.27
  4. The Research and Application of Data Mart in the Telecommunication Business Analysis,TP311.13
  5. Research and Application of Home-School Education Platform Interactive Based on Warehouse,TP311.13
  6. Design and Implementation for Decision Support System of Drug Administration Based on Data Warehouse,TP311.13
  7. Research of Path Planning for Small-Size Intelligent Soccer Robot in Complex and Dynamic Environment,TP242
  8. Study and Implementation of ETL Technology for Complex Scientific Text Data,TP391.1
  9. Research and Implementation of Key Technology of Model Running in Business Intelligence,TP274.2
  10. Study on the Lightning Protection of the Regional Transmission Grid,TM862
  11. PG steelworks MES system design and development of data mining,TP311.13
  12. Research on the Project Requirement Management of the Telecommunications Business Intelligence System,TP311.52
  13. Building geometry and discrete spline modeling technology research,TU17
  14. Numerical Aerodynamic heating combined with engineering calculation method,V412.4
  15. DSP-based network side converter control technology,TM46
  16. Demand for power system operation characteristics of wind power,TM732
  17. Oriented macroeconomic policy-making power of the Northeast Power Grid Planning Assessment Study,F426.61
  18. Bank Operational Risk Measurement Approach System Realization,TP311.52
  19. CCB Sichuan SMS platform to optimize the design and implementation of data warehouse,TP311.13
  20. Research on the Applications of BI’s ETL Optimization and Quality Control on Aviation Warning,F562
  21. Reactive Power Optimization for Power Grid of Ping Yang County,TM714.3

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Software Engineering > Software Development
© 2012 www.DissertationTopic.Net  Mobile