1 / 16

Course Review

Course Review. Advanced Database Systems Fall Semester, 2003. Module 1 DBMS foundations. DBMS architecture, Distinction between a DBMS and a DB Main functions of a relational DBMS, Query processor, Concurrency Controller, Transaction processing, Catalog role and content,

kura
Download Presentation

Course Review

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. Course Review Advanced Database Systems Fall Semester, 2003

  2. Module 1 DBMS foundations • DBMS architecture, • Distinction between a DBMS and a DB • Main functions of a relational DBMS, • Query processor, • Concurrency Controller, • Transaction processing, • Catalog role and content, • Views for centralised RDBs

  3. Module 2 DDBS • Motivation for DDBSs, • DDBS architecture, • Understanding of dependency of Query processing, DB design, Concurrency Control, Directory (Catalog) Management and Reliability for DDBs,

  4. M2 DDBS –Design • Distributed Database Systems • Fragmentation – types, why we need it, methods to construct, information requirements, • Allocation – motivation, cost functions, methods, information requirements, • Correctness issues : Completeness, Reconstruction, Disjointness • Data replication issues, how to manage

  5. M2 DDBS –Query Processing • Relational Operators definitions and basic properties, • Query Processing • Normalisation, analysis, elimination of redundancy, rewriting, • Data localization • Estimation of intermediate relations size and its role, • Semi-join definition & computation

  6. M2 DDBS –Transactions • Role of transactions in DDBs, • Specific problems of distributed transactions • Distributed locking • Distributed deadlock • Two phase commit protocol and its role in distributed reliability

  7. Module 3 DBS Integration • Different integration architectures, • Issues in data representation differences, • Views as a solution for data unification, • Query processing in complex systems • Why it is hard to build a fully integrated solution?!

  8. Module 4 Data Warehousing • Data Warehousing and Data Mining • For what applications it is suitable • What is the DW architecture, • Relationship to system integration issues, • Multidimensional data modelling, data cube, star schema and other structures, • Role of views in DW, • Operations in data warehousing

  9. Module 5 Data Mining • Motivation and goals of Data Mining, • Key techniques • Association Rules • Classification • Clustering • Sequential Patterns • Frequent Item Sets & A-Priori Algorithm • Supporting claims made

  10. Module 6 OO and OR DB • Motivation for objects, • What are the differences between OO and OR databases, • Problems with non-O, OO, OR, • Benefits of OO, OR over non-O

  11. Module 7 SQL3 (SQL 99) • Features of SQL3 • Methods/functions • Row Types • User Defined Types (UDTs) • Large Objects (LOB) • Triggers • Recursive Queries • Relationship to Object Relational DB

  12. Module 8 Object Role Modelling • Elementary Fact Types • Conceptual Schema constructs • Object types • Roles and relationships • Uniqueness, mandatory, set constraints • CSDP and relational mapping • Benefits of ORM over ER

  13. Module 9 Workflows • How do WfMSs fit into information architecture? … into businesses? • Main architecture components (WfMC), • Process specification issues, • types of errors and conditions under which they may occur, • problems with dynamic modifications, • time constraints, • What do you need to know to fix?

  14. Final Exam • When/Where • Wed 25th June • Session 3, 2:30pm • Holt Room, Student Union Complex • What • 60 marks • 7 questions • Covers modules 2-9

  15. Consultation • Thu 5/6/3 12:00 - 14:00 • Tue 10/6/3 10:00 - 12:00 • Thu 12/6/3 10:00 - 12:00 • Tue 17/6/3 10:00 - 12:00 • Thu 19/6/3 10:00 - 12:00 • Mon 23/6/3 10:00 - 12:00 • Tue 24/6/3 10:00 - 12:00 • Other times by appointment.

  16. Thank you for doing Course ADS Good Luck with your Exam!

More Related