Site icon IT Tutorial

What is the Database, Why Database ?

Hi,

In this article I will tell you the Database concept and clarify what is the database and why database ?

 

Database is a software that allows large amounts of data to be kept together in an order.

Database systems that establish the connection between the data related to each other and keep them in a regular manner and eliminate the security problem are called Database Management Systems. An example scenario that will reveal the importance of a database management system can be as follows.

For example,  Student is going to the library wants to borrow one or more books. There are 1000-10.000 different categories and mostly independent books from each other in the library .

If these books are not arranged according to a specific Logic, the person who is looking for books on the shelves is probably looking for the book until night.

This is not possible in real life and is an undesirable situation. That is why there are many ways to facilitate searching in libraries. For example: Sort books in alphabetical order. In this way, when we search for a book, we will find the book in such a short time as to be comparable to other amateur methods.

 

The main reason I tell the above scenario is the main reason for the need for Database and Database management systems. As can be seen here, the Database management system and the Database will always be an indispensable part of the increasing information technologies in the developing world.

Here are the places where real life database is used

 

We say Database management systems are indispensable now let’s look at them what are the most fundamental benefits of Database management systems .

Data Consistency: The data is seen the most current to users when multiple users have access. Ex: You want to buy the ticket from the internet page of the airline, and someone else was doing the same procedure on the same system as you did 1-2 seconds before you bought the ticket. In this case, a second customer can buy that ticket if there is not a Database Management System. This will cause inconsistency of the data. Therefore, Database Management Systems guarantee data consistency in database where multiple users are connected.

Data Redundancy: Enables a common data repository used by many people to be managed in a unique place. Otherwise, there will be many repetitions or copies of the data, and the consistency of the data will not be ensured.

Data Concurrency:  Database management system provides concurrent access multiple users  to the same data. Otherwise, if the file was used instead of database, users would have access to the same data in turn.

Data Integrity: When a user in the system is deleted in this method, all data of related user must be deleted.

Data Security: Prevents data from being unintentionally destroyed and corrupted. It also provides Security by allowing users to access only the schemes or tables on which it is permitted.

Data Independence: The structure of the data stored in the database, regardless of the matter does not matter Database management system solves this complexity itself.

What is the most popular database management used in the world? The list is as follows .
  1. Oracle
  2. SQL Server
  3. MySQL
  4. PostgreSQL
  5. Sybase
  6. DB2
  7. FileMaker
  8. Ingress
  9. Informix
  10. MS-Access

 

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 

 

Do you want to learn Microsoft SQL Server DBA, then read the following articles.

https://ittutorial.org/sql-server-tutorials-microsoft-database-for-beginners/

 

Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.

https://ittutorial.org/sql-server-tutorials-microsoft-database-for-beginners/

Exit mobile version