1 / 13

1.1 Introduction

1.1 Introduction. A database system ⇒ a computerized record-keeping system Operations: 1) adding new, empty files to the database 2) inserting data into existing files 3) retrieving data from existing files 4) deleting data from existing files 5) changing data in existing files

marchesew
Download Presentation

1.1 Introduction

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. 1.1 Introduction • A database system ⇒ a computerized record-keeping system • Operations: 1) adding new, empty files to the database 2) inserting data into existing files 3) retrieving data from existing files 4) deleting data from existing files 5) changing data in existing files 6) removing existing files from the database (See Fig. 1.1, 1.2, & 1.3) Advanced Database System

  2. Advanced Database System

  3. Advanced Database System

  4. 1.2 What is a Database System ? • A database system Advanced Database System

  5. 1.2 What is a Database System ? (cont.) • Four components: 1) data ⇒ integrated & shared (See Fig. 1.5) 2) hardware ⇒ the second storage volumes, the processors, & main memory 3) software ⇒ database management system (DBMS) 4) users ⇒ application programmers, end users, & database administrator (DBA) Advanced Database System

  6. 1.3 What is a Database ? • A database ⇒ persistent data • Entities & Relationships • Example: E/R diagram (See Fig. 1.6) • A number of points: • 1) ternary relationship • 2) one relationship involving just one entity type • 3) more relationships between entities • Properties • Data and data models Advanced Database System

  7. Advanced Database System

  8. Centralized control of data Data administration (manager) Database administration (technician) Benefits of the database approach The data can be shared Redundancy can be reduced Inconsistency can be avoided Transaction support can be provided Integrity can be maintained Security can be enforced Conflicting requirements can be balanced Standards can be enforced 1.4 Why Database ? Advanced Database System

  9. 1.5 Data Independence • The immunity of applications to change in physical representation and access technique • Stored field, stored record, stored file (See Fig. 1.7) Advanced Database System

  10. The oldest systems: Inverted list Hierarchic Network Relation systems: DB2, Ingres II, Informix Dynamic Server, Microsoft SQL server, Oracle 9i, Sybase Adaptive Server (See Fig. 1.8) Object systems: GemStone, Versant ODBMS 1.6 Relational Systems and Others Advanced Database System

  11. Advanced Database System

  12. The End. Advanced Database System

More Related