Relational Database Management System(RDBMS)
RDBMS stands for Relational Database Management System.In RDBMS data is structured in database tables, fields and records.RDBMS store the data into collection of tables, which might be related by common fields (database table columns). RDBMS also provide relational operators to manipulate the data stored into the database tables. Most RDBMS use SQL as database query language.
RDBMS Characteristics
- RDMS Supports relational data structure.
- RDBMS has Data Manipulation Language at least as powerful as the relational algebra.
- Data is stored in a set of tables.
- Tables are joined by relational links.
- RDBMS Reduces Duplication of data in database(Normalization).
- Allows greater flexibility and efficiency.
- in RDBMS Each table must have a unique references for each record called Primary key.
- Replicating these into other tables creates the Foreign Key.
- These foreign keys form the Relationship that link the tables together.
- Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields.
- In RDBMS data need only be updated once as it would only have been entered once.
- RDBMS eliminates the problems in using Flat file databases
Edgar Codd introduced the relational database model.The most popular RDBMS are MS SQL Server, DB2, Oracle and MySQL.
Advantages of RDBMS
- Highly secured
- Supports data independence
- Avoids data redundancy
- Uses OOPs concept.
- Multiple users can access which is not possible in DBMS.
- Avoids data redundancy problems using NORMAL FORMS
- It performs all DML operations which is not possible with ordineray DBMS (it performs only INSERT n RETRIEVE)
- Supports data Independence.
- finally it supports DDBMS concepts too and so on.
- Avoid Reduntnat data.
- Avoid Typographical errors.
Written by admin on December 21st, 2010 with
comments disabled.
Read more articles on RDBMS.
- [+] Digg: Feature this article
- [+] Del.icio.us: Bookmark this article
- [+] Furl: Bookmark this article