1 / 12

Database Architecture

Lecture 9 Chapter # 4 By Sir Ahmad Kareem Department of Information Technology Institute of Computing BZU Multan. Database Architecture.

louie
Download Presentation

Database Architecture

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. Lecture 9Chapter # 4By Sir Ahmad KareemDepartment of Information Technology Institute of Computing BZU Multan BZUPAGES.COM

  2. Database Architecture Architecture of a system define its structure, means the components of the systems, function performed by each component and the relationship among components. BZUPAGES.COM

  3. Three major architecture of DDBMS • Peer to Peer • Client/ Server • Multi database These are idealized architecture; practical installations may vary environment to environment. BZUPAGES.COM

  4. DBMS Standardization A conceptual framework whose purpose is to divide standardization work into manageable pieces and to show at a general level how these pieces are relation to one another approaches (Reference Model) BZUPAGES.COM

  5. Component Based • Components of system are defined together with the interrelationships between components. • Good for design and implementation of the system. However it is difficult to determine functionality of system by seeing its individual component. Components can reuse in any other system or at any other place anytime. BZUPAGES.COM

  6. Functions Based • Classes of users are identified together with the functionality that the system will provide for each class. • The objectives of the system are clearly identified. • But how do you achieve these objectives. BZUPAGES.COM

  7. Data Based • Identify the different types of describing data and specify the functional units that will realize and/or use data according to these views. Views:Subset of data for particular functions BZUPAGES.COM

  8. BZUPAGES.COM

  9. Practically: • Every aspect has to be considered. • These classification schemes are orthogonal (One after another, dependent) • A committee for the DBMS standardization was establish in 1972 by ANSI under SPARC ( Standards Planning & Requirement committee) • Published its initial report in 1975 and then in 1977. • Its full name being “ AMSI/X3/SPARC DBMS framework”. • Mainly based on data organization BZUPAGES.COM

  10. BZUPAGES.COM

  11. In last figure: • Square boxes represents present function • Hexagons are admin roles Arrows indicate data, command execute flow. • I represents interface (Provide compatibility and connectivity) • Interfacing between components is possible through data dictionary. • Contains schema mapping define… statistics and access control information. BZUPAGES.COM

  12. Database admin responsible for internal schema. • Enterprise admin (Conceptual schema) • Application Admin (External Schema) • May be same person, • The concludes our discussion on reference DBMS architecture. BZUPAGES.COM

More Related