1 / 19

Data Base Concepts

Data Base Concepts. Lesson 6. Topics to cover. Advantages of Automated System Conceptualizing Data File Evolution of Database System Elements Of Database System DBMS & RDBMS Data Models Factors Determining Database Performance. 1. Advantages of Automated System.

trinh
Download Presentation

Data Base Concepts

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. Data Base Concepts Lesson 6 Introduction to Computers & MIS

  2. Topics to cover • Advantages of Automated System • Conceptualizing Data File • Evolution of Database System • Elements Of Database System • DBMS & RDBMS • Data Models • Factors Determining Database Performance

  3. 1. Advantages of Automated System • Cycle Time for Information retrieval can be reduced • Information can be stored for long period without deterioration • Data can be updated with small workforce • Centralised Storing of voluminous data is possible • Data redundancy can be minimised • Person independent systems possible

  4. Essentials of Computer Based Information System (CBIS) • Ability to store & retrieve information • Unique file name • Extension name to depict the file type • Program files - set of instructions

  5. 2. Conceptualizing Data File Item_Detail Table or Data File Records or Tuples Fields or Attributes

  6. Item_Detail Supplier_Detail Sales Data Base Tables Customer_Detail

  7. Components of Database • Field/Attributes • Meaningful transaction details. No. of fields is known as the degree of the Table • Records /Tuples • The rows of a table describing the details of a transaction. No. of rows determines the cardinality of a table • Tables • Collection of relevant records • Database • Collection of related Tables

  8. Data Base Management System • Collection of interrelated Data • Set of programs to control • the organization • Storage & retrieval

  9. Features • Add, Modify, Delete, Extract data from a database • Provide an environment which is convenient & efficient to use • A system which provides safety of the data stored from unauthorized use and in event of system crashing.

  10. Elements of Data Base • Database • Tables • Queries • Forms • Reports • Macros • Modules • Relationship

  11. 3. Evolution of Database System • Late 1950s & Early 1960s • Flat files organised using sequential method • Physical & Logical data structures were identical • Data redundancy very high • 1st DBMS designed by Bachman in 1964

  12. 3. Evolution of Database System • Late 1960s • Direct Access & Random Access Files Introduced • Physical data independence became possible • 1970s • Database concepts gained popularity • Multiple views from same physical data • Redundancy controlled • Relational Database Model & Normalization procedures were developed • ER Model introduced • Query Language Developed

  13. 3. Evolution of Database System • 1980s & 1990s • Relational Database introduced -DB2 by IBM • Microcomputer products developed • Client-Server RDBMS gained popularity – ORACLE & SYBASE • Object oriented Database Management System introduced

  14. 3. Evolution of Database System • Current Trend • Distributed DBMS, • Expert DBMS • Object Oriented DBMS • Extensible DBMS

  15. 3. Evolution of Database System • Late 1950s & Early 1960s • Flat files organised using sequential method • Physical & Logical data structures were identical • Data redundancy very high • 1st DBMS designed by Bachman in 1964

  16. 4. Elements Of Database System

  17. 5. DBMS & RDBMS

  18. 6. Data Models

  19. 7. Factors Determining Database Performance

More Related