image

Relational databases

Relational database management systems (RDBMS) use the SQL data definition and query language

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

image

www.oracle.com

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

image

www.mysql.com

MySQL is a freely available open source database that uses SQL, most noted for its quick processing, proven reliability, ease and flexibility of use.

Microsoft SQL Server

image

www.microsoft.com

Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence

PostgreSQL

image

www.postgresql.org

PostgreSQL is 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

image

www.ibm.com

IBM Db2® Database is an AI-infused, cost-effective data management system with proven performance and scalability, available both on premises and on the cloud.