|
Relational Database Management Systems
Relational DataBase Management System or RDBMS is a type of database management system (DBMS) that stores data in the form of related tables.
Each table has one or more keys to uniquely identify a record in the table. A primary key of one table is also stored in related tables
as referential keys in related tables to establish relationships between tables so that information can be retrieved by way of joining related
tables. Hierarchy and network are other types of DBMSs. The power of Relational databases comes from the fundamental differences in DBMS design.
Unlike traditional Hirsch and network models, RDBMS separates how data is stored (in tables) from how data is presented (views).
Database Development Tasks
- Schema Design is the first step of database development. Identification of
logical relationship between business entities, captured in a Entity-Relationship
Diagram (RE Diagram), is called logical design. Mapping of logical entity-relation to
a specific database is called physical design. Creation of database tables is the
implementation of the physical design.
- Views are used to present data to applications. A view acts like a virtual table usually retrieving data
from multiple tables dynamically.
- Stored Procedures and Functions are used to hide implementation details of
data manipulation on database sever side with superior performance.
- Indexing improves the performance of data retrieval. The idea is to trade disk space for the speed.
Related Topics
Operating Systems - Unix, Linux or Windows
Object Oriented Programming - 3 Principles
Today's Internet
|