Data base management system (DBMS) consists of collection of interrelated data and a set of programs to aceess that data in a persistant way.
It takes care of storing and accessing data specifically related to the application.
The main objectives of DBMS are
Data Availability -- available to users in a meaning ful format that can easily access.
Data Integrity -- Data base, maintains the data in reliable (correctness) manner.
Data Security -- provides authorization to access the data in different levels at different scenarios.
Data Independence -- It's nothing but 'abstraction' i.e., to store, update and retrieve data in effecient manner without changing the nature of data.
RDBMS is nothing but Relational DBMS, uses a collection of tables to represent both data and the relationship among those data. The relational model is a combination of three components as
Structural Part -- Defines the database as a collection of relations.
Integrity Part -- maintains integrity using various keys like primary key, foreign key, super key and etc...
Manipulative Part -- The relational algebra and relational calculus are the tools used to manipulate the data in database by introducing key features like tuples(rows), attributes(columns), keys, cardinalities, Domains and Degrees.
A relational system may support the following items
1. Data Definition
2. View Definition
3. Data Manipulation
4. Integrity Constraints
5. Authorization
6. Transaction Management
7. Data Recovery
The following are main differences:
1. The speed of operations on data base is very fast in RDBMS compare with ordianry DBMS
2. RDBMS can be implimented by the concept of relationships (logical mapping).
3. The concept behind the RDBMS is 'TABLE' but in 'Flat files' are used in DBMS.
It takes care of storing and accessing data specifically related to the application.
The main objectives of DBMS are
Data Availability -- available to users in a meaning ful format that can easily access.
Data Integrity -- Data base, maintains the data in reliable (correctness) manner.
Data Security -- provides authorization to access the data in different levels at different scenarios.
Data Independence -- It's nothing but 'abstraction' i.e., to store, update and retrieve data in effecient manner without changing the nature of data.
RDBMS is nothing but Relational DBMS, uses a collection of tables to represent both data and the relationship among those data. The relational model is a combination of three components as
Structural Part -- Defines the database as a collection of relations.
Integrity Part -- maintains integrity using various keys like primary key, foreign key, super key and etc...
Manipulative Part -- The relational algebra and relational calculus are the tools used to manipulate the data in database by introducing key features like tuples(rows), attributes(columns), keys, cardinalities, Domains and Degrees.
A relational system may support the following items
1. Data Definition
2. View Definition
3. Data Manipulation
4. Integrity Constraints
5. Authorization
6. Transaction Management
7. Data Recovery
The following are main differences:
1. The speed of operations on data base is very fast in RDBMS compare with ordianry DBMS
2. RDBMS can be implimented by the concept of relationships (logical mapping).
3. The concept behind the RDBMS is 'TABLE' but in 'Flat files' are used in DBMS.
No comments:
Post a Comment