Database: Intro

Definition

A database is a collection of information that is usually stored in computer systems. The information are usually data of various forms. The main function of database is for the managers of these information to better store and manipulate the data efficiently.

A database can be either relational or non-relational.

Relational database

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 attribute of the data, and each record usually has a value for each attribute, making it easy to establish the relationships among data points.

Non-relational database

A non-relational database is a database that does not use the tabular schema of rows and columns found in most traditional database systems. Instead, non-relational databases use a storage model that is optimized for the specific requirements of the type of data being stored. For example, data may be stored as simple key/value pairs, as JSON documents, or as a graph consisting of edges and vertices.¹

Note: The 3 points above are for interview preparation. They are succint and clearly explains each part. You can directly use them or shorten them in interview.

4. DBMS (Database management system)

I assume that most of you have some prior knowledge about SQL. Otherwise, you are welcome to review my posts on SQL. So I'm not gonna explain what DBMS is and some examples of DBMS.


To be updated…