What is a Relational Database (More Information Below)

what is relational database
what is relational database

What is a Relational Database – A relational database is a form of a digital database whose organization follows the relational data model, as proposed by EF Codd in 1970. Various software systems that will be used to maintain relationships between databases are known as relational database management systems. .

What is a Relational Database

relational database
relational database

A relational database is a collection of data items with predefined relationships. These various items have been arranged into a set of tables with neatly arranged columns and rows. The table will be used as a container to store information about objects that will be represented in the form of a database. Each column in the table contains certain types of data and fields that store the actual values ​​of the attributes. Rows in the table that have represented a set of related values ​​from one object or from certain entities. Each row in a table can be marked with a unique identifier called a primary key, and rows between multiple tables can be created by linking each other using a foreign key. This data can be accessed in a variety of ways without the hassle of rearranging the database tables themselves.

Important Aspects of Relational Database

  1. SQLSQL stands for Structured Query Language is the main interface used to communicate with Relational Databases. This SQL has become a standard of the American National Standards Institute (ANSI) precisely in 1986. The standard ANSI SQL has been supported by all popular relational database engines, and some of these engines also have extensions to ANSI SQL to support engine-specific functions. the. This SQL is used to be able to add, update or even delete rows of data, retrieve subsets of data for advanced steps of transaction processing and analytical applications, and to manage all aspects of the database.
  2. Data IntegrityData integrity is an overall completeness, accuracy and consistency of data. Relational databases use a set of constraints to enforce data integrity in the database. This includes Primary Key, Foreign Key, Not NULL constraint, Unique constraint, Default constraint and Check constraint. This integrity constraint can help enforce business rules on the data in the table to ensure the accuracy and reliability of the data. Also, most relational databases also allow custom code to be embedded in triggers that execute based on the actions in the database.
  3. TransactionA database transaction is one or more SQL statements that have been executed as a sequence of operations that form a logical unit of work. Transactions have become an “all or nothing” proposition, meaning that all transactions must be completed as a single entity and subsequent processing will be written to the database or none of the transaction components must take place. In relational database terminology, the transaction will result in a COMMIT or ROLLBACK. Each transaction is treated in a coherent and reliable manner regardless of the other transactions.
  4. ACID ComplianceAll database transactions must comply with the rules of ACID or Atomic, Consistent, Isolated, and Durable to ensure data integrity. Atomicity provides a condition that a transaction as a whole is successful or if some transactions fail, then all transactions will be invalid transactions.

That’s some information that I can share with you all, for more and less I apologize, see you in the next article that will come.