Types of Database Models
A database is an organized collection of information or data, records arranged. Various types of DBMS are given as follows :
1. Hierarchical DBMS (HDBMS)
2. Network DBMS (NDBMS)
3. Relational DBMS (RDBMS)
4. Object-Oriented Database (OODB)
5. Distributed DBMS (DDBMS)
Hierarchical DBMS (HDBMS):
Hierarchical data model was developed by IBM in 1968 and it is introduced in IMS (Information Management System). This model is like a structure of a tree with the records forming the nodes and fields forming the branches of the tree. In this model, records are linked in the form of an organization chart
Advantages of Hierarchical DBMS Model :
(i) It is a simple, straightforward and natural method of implementing record relationships.
(ii) Hierarchical model is useful when there is some hierarchical character in the database.
Disadvantages of Hierarchical DBMS Model :
Network DBMS (NDBMS):
In network database structure, a record type can have multiple owners. In network model, data are represented by records using links among them. It is an improvement over the hierarchical model, here we can have many to many relationships (M:M) among records.
Advantages of Network DBMS Model :
Disadvantages of Network DBMS Model :
(i) All records are maintained using pointers and hence the whole database structure becomes very complex.
(ii) Insertion, deletion and updation of any record would require pointer adjustments.
Relational DBMS (RDBMS):
In a Relational Database Model, data is organized in the form of rows and columns similar to a table. The tables are referred to as relations in a relational data model. Rows of the table are referred to as tuples and the columns of a table are referred to as attributes. A relational database model is defined as a database that allows you to group its data items into one or more independent tables that can be related to one another by using fields common to each related table.
Advantages of Relational DBMS Model :
Object Oriented Database (OODB):
Object Oriented Database (OODB) are dependent on the object oriented programming paradigm. It enables us to create classes, organize objects, structure an inheritance hierarchy and call methods of represents class-subclass link. The dash ( – – – – ) represents attribute-domain link.
Advantages of OODB Model :
Distributed DBMS (DDBMS):
In the centralized database system, data stored or resides in one single location, but in a distributed database system, database is stored in several computers. The computers in a distributed system communicate and exchange data among one another using leased lines, telephone lines or other means of communication. These computers do not share a memory or a clock. Each of the computers in a distributed system participates in the execution of transactions. These computers can also be known as sites or nodes.
1. Types of DBMS
2. Role of Database Administrator
3. Three Level Architecture of DBMS
4. Comparison Between Hierarchical model Network model Relational model
5. Entity Relationship Diagram
6. Codd’s Rules in DBMS
7. Different Types of Keys in DBMS
8. Normalization in DBMS: 1NF, 2NF, 3NF and BCNF
9. Relational Algebra in DBMS
10. Transaction States in DBMS
11. ACID Properties in DBMS
12. Armstrong’s Axioms in DBMS
13. Types of Dependency in DBMS
14. Concurrency Control in DBMS
15. Deadlock in DBMS
16. Database Backup
17. Database Recovery Techniques
18. Database Security
19. Data Encryption in DBMS
20. Database Integrity
21. SQL Constraints