What is a Database? - MySQL Tutorial

Before learning about database, we need to understand what is raw data.

What is Raw Data?

Unprocessed or un-grouped data is called raw data. Data refers to a collection of small pieces of information. 

The word 'data' finds its origins from the Latin word 'datum' which means 'single piece of information'.

Data can be present in variety of forms like text, numbers, media, bytes, etc.

Now let's learn about database!

What is a Database?

Raw data, when meaningfully organized, forms a database. Organizing raw data helps it make sense. 

Making a database helps in easy navigation and sharing of data.

Database usually refers to such an organized collection of data which is stored and accessed electronically from a computer system.

In SQL, a database is a collection of tables containing organized data. This means that a database can have multiple related tables in it.

For example: When asked about their favorite phone brand, 10 people gave these answers: 

This can be called a database. Using this information one can tell which phone brand is loved the most. It is also easy to navigate and share the data in this form.

What is a DBMS?

Database Management System (DBMS) is a software that is used for storing, retrieving as well as manipulating the data in a database. DBMS acts likes a window between the user and the database. 

Another important feature of a DBMS is its ability to secure data from being deleted/altered accidentally. 

It follows the ACID ( Atomicity, Consistency, Isolation and Durability ) concept.

Examples of commercially available DBMS are: MySQL, Microsoft Access, LibreOffice Base, etc.

~~~~~~~~~~~~~~~~~~~~~~~~~

Next: Types of Databases

This article is a part of our MySQL Tutorial For Beginners Series.