Database – RDBMS:
There are a number of relational databases to store data. A relational database contains normalized data stored in tables. Tables contain records and columns. RDBMS makes it easy to work with individual records. Each row contains a unique instance of data for the categories defined by the columns.
RDBMS are used in OLTP applications(e.g. ATM cards) very frequently and sometimes data warehouse may also use relational databases. Please refer to Relational data modeling for details to know how data from a source system is normalized and stored in RDBMS databases.
Popular RDBMS Databases:
| RDBMS Name | Company Name |
|---|---|
| Oracle | Oracle Corporation |
| IBM DB2 UDB | IBM Corporation |
| IBM Informix | IBM Corporation |
| Microsoft SQL Server | Microsoft |
| Sybase | Sybase Corporation |
| Terradata | NCR |