First of all, we need to understand first, what is data, database, DBMS?
Data – In the real world, data is basically a collection of raw facts and figures.
Database – database basically a collection of related data. Organized collection of data or information that can be accessed, updated, and managed. Charles Bachman along with his team invented the first DBMS known as Integrated Data Store (IDS).
We generally treated there are 2 types of databases:
- Relational databases
- Non-relational databases.
Popular relational database like MySQL, SQL Server etc. Popular non-relational databases like MongoDB, Redis etc.
Note: In relational database data basically stored in the form of rows & column (table). In non-relational databases, data basically stored in the form of document.
Generally RDBMS uses a language called SQL (Structured Query language).
DBMS (Database Management System) –
DBMS basically an interface between end user and database. It’s software which helps to insert, update, delete & retrieve records from a database. Ex: MySQL, SQL Server, Oracle SQL, MongoDB etc. For the enterprise use purpose basically widely uses Oracle SQL. MySQL uses by many popular websites including Meta (Facebook), Uber, Twitter etc. Frameworks like WordPress, Drupal etc.
Note: DBMS basically used B+ Trees. In relational databases rows are treated as tuple. The set of tuples called as cardinality. Columns are treated as attributes of relation(table). We will study later.
We will continue our further articles with MySQL. Let’s see how it works…
Structured database –
we can say structured database is a good example of relational database. In this, data basically stores in the form of tables(rows and columns). Ex – IRCTC(Indian railway booking system), is a good example of a relational/structured database. Here, a visitor can see all the train records which are available from a particular source and destination. All the train records which will be available between two places (source and destination) will show as a table.
Same thing also applicable for University databases. A university database also stores all the colleges and students data in the form of row and column major (table form).
Unstructured databases – web pages is a good example of this. Like, a common news can be display by news websites in many way, some will shows videos with paragraphs, some will shows only paragraphs, some will only shows images with hyperlinks. So basically every page does not follow a common structure. but their delivered news becomes the same all the time.
But the fact is, currently in the world at around 85% of data in the unstructured form.