1 / 11

12. Course Summary

12. Course Summary. Course Summary. Distributed Database Systems. Review - Course Goal. to enhance the previous knowledge of database systems by deepening the understanding of the theoretical and practical aspects of the database technologies;

lucasjohnson
Télécharger la présentation

12. Course Summary

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 12. Course Summary Course Summary Distributed Database Systems

  2. Review - Course Goal • to enhance the previous knowledge of database systems by deepening the understanding of the theoretical and practical aspects of the database technologies; • to show the need for distributed database technology to tackle deficiencies of centralized database systems; • to introduce basic principles and implementation techniques of distributed databases including • distributed database design and architecture, query processing and optimization, transaction management, recovery, and reliability protocols • to expose active research issues in distributed database systems and application development.

  3. Review - Course Content Theoretical study of distributed database systems. It covers the core of principles of distributed database management systems, including database design, architecture of Distributed Database Management System (DDBMS), distributed transaction management, concurrency control, recovery, and reliability. Experimental DDBMS. Students are organized in teams to design and implement a mini-DDBMS with distributed SQL query processing and optimization capabilities in a network environment. The system is subject to the benchmark testing of the course.

  4. Course Topics • Chapter 1: Introduction • Chapter 2: Distributed DBMS Architecture • Data independence (logical/physical) • Transparency (distribution/fragmentation/replication)(the major goals of DDBMS) • ANSI/SPARC 3-level architecture (internal/conceptual/external views) • Components of DDBMS • User Processor at local site, plus Data Processor at remote site • Global directory

  5. Course Topics (cont.) • Chapter 3: Distributed DB Design • DDB design = Data fragmentation and allocation • Why • How • Correctness of fragmentation (completeness, reconstruction, disjointness) • Chapter 6/7: Overview of Query Processing • Problem • Objective • Complexity, characterization • Layers of query processing

  6. Course Topics (cont.) • Chapter 8: Optimization of Distributed Queries • Cost model • Centralized query optimization • INGRES • System R • Distributed query optimization • Distributed INGRES • System R*

  7. Course Topics (cont.) • Chapter 10: Introduction to Transaction Management • Properties of transactions: ACID • Formalization – partial order, or DAG • Termination of transactions

  8. Course Topics (cont.) • Chapter 11: Distributed Concurrency Control • Serializability theory • Locking-based algorithms • Basic • 2PL • Strict 2PL • Timestamp-based algorithms • Basic • Conservative • Extremely conservative • Optimistic versus pessimistic

  9. Course Topics (cont.) • Chapter 12: Distributed DBMS Reliability • Reliability and types of failures • Local recovery protocols • Architecture and log file • Execution of LRM commands • Checkpoint • Distributed reliability protocols • 2PC protocol • Termination protocols • Recovery protocols • 3PC – an non-blocking protocols

  10. Course Topics (cont.) • Beyond Traditional RDBMS (State-of-Art) • NoSQL and NewSQL • Chapter 13: Parallel Database Systems • Parallel architectures • Parallel DBMS techniques • Chapter 18: Streaming Data Management • Challenges • Architecture • Query Processing

  11. Question & Answer

More Related