Write about your understanding of databases. Explore the database advantages and write about database concepts such as primary and foreign keys

(freepik.com, 2018)

Database

A database is an organized collection of structured information or data, usually stored electronically in a computer system. A database is usually managed by a database management system, "DBMS". controlled. Data and his DBMS and related applications are collectively called a database system, often abbreviated simply as database.

Data in the most common types of databases in operation today are typically modeled as rows and columns in a series of tables to streamline processing and data retrieval. You can then easily access, manage, modify, update, control and organize your data. Most databases use Structured Query Language (SQL) to write and query data(Oracle.com, 2023). 

Databases have evolved dramatically since their birth in the early 1960s. Navigational databases such as hierarchical databases (based on a tree-like model and allowing only one-to-many relationships) and network databases (a more flexible model that allows multiple relationships) are used for storage and preservation. was the original system. Manipulate the data. Although simple, these early systems lacked flexibility. Relational databases became popular in the 1980s, followed by object-oriented databases in the 1990s. More recently, NoSQL databases have emerged in response to the growth of the Internet and the need to accelerate and process unstructured data. Today, cloud and self-propelled databases are breaking new ground in how data is collected, stored, managed, and consumed (Oracle.com, 2023). 

Advantages of database

• Minimum data redundancy
• Improved data security
• Increased consistency
• Lower updating errors
• Reduced costs of data entry, data storage, and data retrieval
• Improved data access using host and query languages
• Higher data integrity from application programs(intellipaat.com, 2022)

Concepts of database

Primary keys: A primary key is a unique column (or set of fields) in a relational database table that is used to identify each entry in the table. To easily parse the data in the table, a primary key is employed as a unique identifier. There can only be one primary key per table.

A primary key’s main features are:

• It must contain a unique value for each row of data.
• It cannot contain null values.
• Every row must have a primary key value (techopedia.com, 2020).

Foreign keys: A column or set of columns in a relational database table known as a foreign key serves as a connection between the data in two different databases. It refers to the primary key of another table, creating a link between the two tables and serving as a cross-reference between them.

A relational database system's tables generally follow the foreign key principle. Data in a domain must be added across several tables in sophisticated databases and data warehouses to maintain a relationship between them. Foreign key theory serves as the foundation for the idea of referential integrity.

The installation of foreign keys is more difficult than that of primary keys (techopedia.com, 2020).

Reference

Free vector: Big Data Processing concept, server room, blockchain technology token access (2018) Freepik. Available at: https://www.freepik.com/free-vector/big-data-processing-concept-server-room-blockchain-technology-token-access_3629651.htm#query=database&position=1&from_view=search&track=sph (Accessed: February 15, 2023).

What is a database? (2023) What Is a Database | Oracle United Kingdom. Available at: https://www.oracle.com/uk/database/what-is-database/ (Accessed: February 15, 2023).

What is database? types, examples and advantages (2022) Intellipaat Blog. Available at: https://intellipaat.com/blog/what-is-database/ (Accessed: February 15, 2023).

(2020) Primary key, Techopedia. Available at: https://www.techopedia.com/definition/5547/primary-key (Accessed: February 15, 2023).