Dissertation > Excellent graduate degree dissertation topics show

Design and Implementation of Multidimensional Analysis System in Digital Ocean

Author: DongLeSheng
Tutor: YuGe
School: Northeastern University
Course: Applied Computer Technology
Keywords: Digital Ocean Data Warehouses OLAP Materialized View Materialized ViewSelection Cluster
CLC: TP311.13
Type: Master's thesis
Year: 2010
Downloads: 31
Quote: 0
Read: Download Dissertation

Abstract


In order to welcome the coming of21century of marine, from the national development strategic, our country has put the "Digital Ocean" into the fifteenth and national marine development plan of2015, with the purpose of collecting marine three-dimensional monitoring information extensively, completing marine information engineering and the infrastructure construction of marine data. In order to manage and analyze mass of marine data, we must cluster marine data and build data warehouses. We are now building a multidimensional analysis system based on data warehouses, which can help us find some laws from mass of data in order to facilitate the decision-making related to marine scientific research persons.Currently there have been many of the world’s leading suppliers of data warehouse products, but these commercial products are expensive and not suitable for most enterprises, institutions or government agencies to use. Because the code is not open, it is not conducive to study. In response, the field of open source data warehouse project has been rapid development. There are some excellent open source products in ETL, OLAP and Data Mining. We design our multidimensional analysis system based on an open source OLAP engine Mondrian, the relational database ORACLE as data layer, Mondrian as OLAP engine, Jpivot as OLAP front-end show. Taking into account our proposal does not need EJB support, we use Tomcat as J2EE server. To extend our system, we have Mondrian’s source code in detail analysis and Jpivot’s source code in general. We also mainly focused on designing data model and building system architecture.We focused on a number of implementation details in multidimensional analysis system, including authorization management, schema file designing, some implementation details in multi-user environment and implementation of chart module. The multidimensional analysis system has been running and it is very well for marine science staff for decision support and reporting queries, which achieved the desired purpose.The data Warehouse is different from traditional transactional processing, which have the characteristics of analyzing large capacity data, so how to build a high-performance data warehouse system have become a hot topic of current research. Materialized view technology and indexing technology are two important technologies to enhance data warehouse performance. In order to improve multidimensional analysis system’s query efficiency, we presented a materialized view selection method based on workloads. The method first clustered queries in our logging system, then merging view technology was adopted within a cluster to generate candidate views, finally we would have materialized views with objective functions. We used these views to guide Mondrian’s query processing and improve the efficiency of query response. The results showed that it had greatly improved query response time and our method had good scalability. When storage space is limited, our method is still very effective.

Related Dissertations

  1. Design and Study on Movable Packing Machine in Acrylic Fiber Production Lines,TH248
  2. Study on the Heat Transfer Characteristics of Particle Cluster in Circulating Fluidized Bed,TK124
  3. Multiple Pairwise Keys Management Protocol of Function Node-Based for Wireless Sensor Networks,TP212.9
  4. Development of EST-SSR Primers and Application in Analysis of Genetic Realtionships in Tree Peony,S685.11
  5. Pre-hypertension syndrome characteristics,R259
  6. Comprehensive Quality Assessment of College Students,G645.5
  7. Weaving in the children's clothing industry cluster development,F426.86
  8. Studieson Effects of Soybean Species on Yuba and Initial Establishment of Quality Evalution System for Yuba,TS214.2
  9. ISSR Analysis of Genetic Diversity on 21 Lotus(Nelumbo Nucifera) Cultivars,S682.32
  10. Characterization of an Atrazine-Degrading Strain, Cloning of Key Degrading Related Genes and Construction of a Gene Cluster,X172
  11. Research on the Soil Environmental Function Zoning,X321
  12. Research on Intelligent Aerial Bomb for Forest Fire Fighting,S762
  13. Comparison of Gene Expression Data Cluster Methods and Gene Network Construction for Phytophthora Sojae Genes,S435.651
  14. Study on Heterosis and Genetic Basis of Soybean,S565.1
  15. Evaluation on Forage Quality and Biomass Energy Characters of Inbred Vegetative Lines of Napier Grass,S543.9
  16. Yunnan Province 's direct control of the county Reform,D630
  17. Research on Intrusion Detection Technology of Wireless Sensor Networks Based on Behavior Trust,TP212.9
  18. The Research on Routing Protocol of Agricultural Environmental Monitoring System Based on Wir Eless Sensor Networks,TN915.04
  19. Clustering Method Research Based on Divided and Conquered Method,TP311.13
  20. Elements of Thirty Kinds of Proprietary Chinese Medicines and Classification Based on Elements,R286.0
  21. Mobile WSN data collection based on the virtual cluster head Strategy,TP212.9

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