The database is the most search term on Google, people usually look for database for business purpose
We live in the era of Big Data. The driving force behind everything from operational robots to autonomous cars, big data and cloud computing are some of the most exciting and important technological innovations.
What is the database?
A database is a collection of information organized in such a way that it can be easily viewed, managed and updated.
Databases, also known as electronic databases, are designed to efficiently facilitate the creation, insertion and updating of data in the form of files on magnetic disk and other types of secondary devices.
On technical terms, the database can be divided into two types:
1. RDBMS (Relational Database Management System) and
2. Non-relational database (No SQL)
Relational database management system
In the relational database management system (RDBMS), the data is stored in relation (tables) in the form of tuples (rows) and attributes (columns).
The data contained in the RDBMS has little data duplication and redundancy.
For instance MySQL
For non-relational databases, there is no concept for relations, tuples, or attributes. This means that it contains a high duplication of data.
For complex queries, however, the response time of non-relational databases is much shorter than that of the RDBMS.
Why do we need a database?
If you have data and want to save it somewhere, this data can be anything. This can be of customers, products, employees, orders, etc.
These data may be in text format, digital format, dates, document files, images, audio or video.
If you have data about your company’s customers, you should first open a spreadsheet.
Then write the information you want to save.
This can be the name of the customer, the identification of the e-mail, the position, etc. You can add as many customers as you like, delete them or even change them.
Eventually, this comes to mind when you hear the term “database”. We now have a data type that you have stored in spreadsheets that suits your needs.
This could be because the mere availability of data is not enough to need a database, and that is not the problem.
The problem is what comes next, and there are many potential problems.
And if you have a lot of data, maybe 10,000 customers?
Are you scrolling the table to get the 9999 client?
What would happen if security is a problem? Does it bother you that someone else has access to your data?
And if? You accidentally entered redundant information: “Is it okay to have duplicate information in the table?
These are all thoughts comes to your mind because It’s a structured system that puts in your data that regulates it, and you’re in control of the rules as the meaning of these topics changes according to your needs.
Your problem may be in size, while another person may have less data where sensitivity is a major concern.
These are things you cannot see, what’s going on in the background. Security, enforced data integrity, the ability to access it quickly and reliably, strength; It serves several people at the same time and even withstands breakdowns and hardware problems without damaging the data.
And that’s what we have to do here. Understand how we describe our structure and define these rules so that all these invisible things actually happen.
In the coming days, we will further look on types of database in depth, if you find it useful please let me know in the comment section