Relational Databases

Updated Sep 09, 2021#system#databases#lists

A relational database is a type of database that stores and provides access to data points that are related to one another. Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables. In a relational database, each row in the table is a record with a unique ID called the key. The columns of the table hold attributes of the data, and each record usually has a value for each attribute, making it easy to establish the relationships among data points.

The relational model is the best at maintaining data consistency across applications and database copies (called instances). For example, when a customer deposits money at an ATM and then looks at the account balance on a mobile phone, the customer expects to see that deposit reflected immediately in an updated account balance. Relational databases excel at this kind of data consistency, ensuring that multiple instances of a database have the same data all the time.

  • Oracle - Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database, most popular database for running online transaction processing.
  • MySQL - Freely available open source database that uses SQL, most noted for its quick processing, proven reliability, ease and flexibility of use.
  • Microsoft SQL Server - Relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence.
  • PostgreSQL - A powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
  • IBM Db2 - AI-infused, cost-effective data management system with proven performance and scalability, available both on premises and on the cloud.

You might also like

Scaffolding ToolsFeb 21, 2020
Build ToolsSep 09, 2021