Dissertation > Excellent graduate degree dissertation topics show

The Research of High Available Data Warehouse Based on Failure Recovery

Author: Peng
Tutor: GuoShaoZhong
School: PLA Information Engineering University
Course: Software Engineering
Keywords: Failure Recovery High Availability Data Warehouse
CLC: TP311.13
Type: Master's thesis
Year: 2013
Downloads: 22
Quote: 0
Read: Download Dissertation

Abstract


The paper introduces the development status of the high availability of the data warehouse,analyses the shortcomings of traditional data warehouse failure recovery mechanisms, studies thekey technologies of the fragments in the delivery of data warehouse design based on thethree-phase optimized structure and delivery of treatment, proposes a failure recovery algorithm--REVIVAL in a distributed data warehouse.To evaluate REVIVAL’s feasibility, I compare REVIVAL’s runtime overhead and recoveryperformance with those of two-phase commit and ARIES, the gold standard for log-basedrecovery, on a four-node distributed database system that I have implemented. My experimentsshow that REVIVAL incurs lower runtime overhead because it does not require log writes to beforced to disk during transaction commit. Furthermore, they indicate that REVIVAL’s recoveryperformance is comparable to ARIES’s performance on many workloads and even surpasses iton characteristic warehouse workloads with few updates to historical data. The results are highlyencouraging and suggest that my integrated approach is quite tenable.Any highly available data warehouse will use some form of data replication to ensure that itcan continue to service queries despite machine failures. In this thesis, I demonstrate that it ispossible to leverage the data replication available in these environments to build a simple yetefficient crash recovery mechanism that revives a crashed site by querying remote replicas formissing updates. My new integrated approach to recovery and high availability, called REVIVAL,targets updatable data warehouses and offers an attractive alternative to the widely usedlog-based crash recovery algorithms found in existing database systems. Aside from itssimplicity over log-based approaches, REVIVAL also avoids the runtime overhead ofmaintaining an on-disk log, accomplishes recovery without quiescing the system, allowsreplicated data to be stored in non-identical formats, and supports the parallel recovery ofmultiple sites and database objects.

Related Dissertations

  1. The Study and Design of High Availability Monitoring Subsystem for Fault Tolerant Computing Systems,TP311.52
  2. Data warehouse technology in the banking customer management systems research and implementation,TP315
  3. The Application Research of Database Synchronization Technology in Disaster Recovery System,TP309.3
  4. The Application of Association Rules Algorithm in Higher Vocational Colleges’ Endorsement of Impoverished Students,G717
  5. Research and Application of Home-School Education Platform Interactive Based on Warehouse,TP311.13
  6. Design and Implementation of Network Teaching and Research OLAP Analysis System Based on Data Warehouse,TP311.13
  7. Design and Implementation for Decision Support System of Drug Administration Based on Data Warehouse,TP311.13
  8. The Research of Data Mining and OLAP about Medical Insurance in Social Protection System,TP311.13
  9. Data Mining Research Basedo on Governmnet Procurement Funds,TP311.13
  10. Research and Design of Equipment Material Support Integrated Management System Based on Data Warehouse,TP311.13
  11. Data Mining Application in Higher Vocational Teaching Administration,TP311.13
  12. Based on community structure found in the data warehouse subject extraction studies,TP311.13
  13. Research and Application of Data Integration Technique in the Comprehensive Billing System of Bank,TP311.13
  14. Construction and quick access to the marine disaster prevention and mitigation technology research data warehouse,TP311.13
  15. The Analysis and Application of Telecom Customer Retention System Based on Data Mining Technology,TP311.13
  16. Mine Integrated Management System Design and Implementation,TP311.52
  17. The Design Based on the Data Mining of Financial Information Management and Decision Supporting,TP311.52
  18. Construction and Application of Computer Audit Based on Date Warehouse and Date Mining,TP311.13
  19. Ocean data warehouse architecture and interface specifications Design and Implementation,TP311.13
  20. PG steelworks MES system design and development of data mining,TP311.13
  21. Liupanshui City tobacco company's human resource management system integrated design and implementation,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