1 / 26

Database Management System

Database Management System. Lecture 3 Models of Database Management Systems. Learning Outcome. Compare and contrast the structure of different database management systems Define hierarchical databases Define network databases Define relational databases

petula
Download Presentation

Database Management System

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. Database Management System Lecture 3 Models of Database Management Systems

  2. Learning Outcome • Compare and contrast the structure of different database management systems • Define hierarchical databases • Define network databases • Define relational databases • Define object-oriented databases

  3. List of Topic

  4. Hierarchical Databases • The hierarchical data model organizes data in a tree structure (as shown in the Figure) which includes parents and child data segments.

  5. Hierarchical Databases (Cont.) • Hierarchical databases were introduced by IBM in the 1960s with the introduction of their IMS DBMS and were popular until the 1970s • It is one of the oldest methods of organizing and storing data

  6. Hierarchical Databases (Cont.) • A hierarchical database is organized in pyramid fashion, like the branches of a tree extending downwards • Related fields or records are grouped together so that there are higher-level records and lower-level records

  7. Network Databases Model

  8. Network Databases Model (Cont) • The network data model was formally defined in 1971 at the Conference on Data Systems Languages (CODASYL). • It is a modified version of the hierarchical model described with the one-to-many parent-child relationship constraint relaxed allowing many-to-many relationships in data

  9. Network Databases Model (Cont) • a network database looks more like a cobweb or interconnected network of records • child or member can have more than one parent (or owner).

  10. First Generation DBMS: Network and Hierarchical • Required complex programs for even simple queries. Minimal data independence

  11. Relational Data Model

  12. Relational Data Model (Cont.) • The most widely used data model in DBMSs • It was developed by E. F. Codd at IBM in 1970. • Data in a relational data model is organised in tables. • Each table is composed of a collection of records.

  13. Relational Data Model (Cont.) • Each record contains a set of fields. • Tables in a database can have relationships between them. • Each row in a table is unique with no two rows or more having the same values in all its fields

  14. Relational Data Model (Cont.)

  15. Relational Data Model (Cont.) • Tuple / Row • A single row in the table is called as tuple. Each row represents the data of a single entity. • Attribute / Column • A column stores an attribute of the entity. For example, if details of students are stored then student name is an attribute; course is another attribute and so on.

  16. Relational Data Model (Cont.) • Column Name • Each column in the table is given a name. This name is used to refer to value in the column • Table Name • Each table is given a name. This is used to refer to the table. The name depicts the content of the table

  17. Object-oriented Databases (OODBMS)

  18. Object-oriented Databases (OODBMS) (Cont.) • An OODBMS is the result of combining object oriented programming principles with database management principles. .

  19. Object-oriented Databases (OODBMS) (Cont.) • One-to-one mapping between object-oriented programming objects and database objects is achieved in OODBs. • Thus, less overhead can be achieved when storing and retrieving database objects by object-oriented applications

  20. Object-oriented Databases (OODBMS) (Cont.) • able to handle many new data types, including graphics, photographs, audio, and video • an object-oriented database can be used to store data from a variety of media sources, such as photographs and text, and produce work, as output, in a multimedia format.

  21. Object-oriented Databases (OODBMS) (Cont.) • Object-oriented databases use small, reusable chunks of software called objects • The objects themselves are stored in the object-oriented database

  22. Object-oriented Databases (OODBMS) (Cont.) • Each object consists of two elements: 1) a piece of data (e.g., sound, video, text, or graphics) 2) the instructions, or software programs called methods, for what to do with the data

  23. Object-oriented Databases (OODBMS) (Cont.) • The instructions contained within the object are used to do something with the data in the object • For example, test scores would be within the object as would the instructions for calculating average test score

  24. Object-oriented Databases (OODBMS) (Cont.) • Object-oriented databases have two disadvantages • they are more costly to develop 2) most organizations are reluctant to abandon or convert from those databases that they have already invested money in developing and implementing

  25. Object-oriented Databases (OODBMS) (Cont.) • benefits to object-oriented databases are • The ability to mix and match reusable objects provides incredible multimedia capability • Healthcare organizations, for example, can store, track, and recall CAT scans, X-rays, electrocardiograms and many other forms of crucial data.

  26. Summary • In this lesson, the following topics were discussed: • Compare and contrast the structure of different database management systems. • Define hierarchical databases. • Define network databases. • Define relational databases. • Define object-oriented databases.

More Related