lect05.ppt

Inspecting a DBMS Lecture 5 This lecture will cover many of the functions required of a Database Management System. It is a good opportunity to review much of the material covered to date, and will also open the way to other topics such as Data Dictionary, Integrity, Recovery and Concurrency considerations. We will be moving from the Logical Design, through the Implementation Planning stage to the Physical Design stge of database design. DBMS Outline DBMS Block Diagram 1. General Comms Communications to Front Ends Facility Front Ends Locations transparent to DBMS Provides Datatype Translations - Heterogeneous networking 2. System Control Tracks state for internal threads ( I/O control return) Facility Time-slices threads Co-ordinates access to global resources e.g. memory 3. Parser Facility Parses query text and builds query tree Stores query tree in QSF Notifies SCF that control must now pass to OPF 4. Optimiser Facility Reads query tree in QSF Builds optimal query plan and stores plan in QSF Ingres Components 6. Relation Description Support Facility Facility Cache of Table and Column descriptions Reduces I/O to System Catalogs 7. Query Storage Support Facility Facility Common Storage Pool for passing objects between ( Size is user option) PSF, OPF, and QEF Stores Query Plans No. of stored query plans can be controlled by user Ingres Components 8. Abstract Datatype Defines all datatypes and their Facility