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.
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
- Airlines: Reservations and Ticket Sales
- Banks: Banking transactions and transactions
- Universities: Student Tracking system and Note entries
- Online Sales: Customer and Product information
- Online Perakende: Sipariş Kayıtları ve sonuçları
- Human Resources: Employee Profiles and Salaries
- Production: Stocks and tracking of manufactured products
We say Database management systems are indispensable now let’s look at them what are the most fundamental benefits of Database management systems .
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.
- SQL Server
Do you want to learn Oracle Database for Beginners, then read the following articles.
Do you want to learn Microsoft SQL Server DBA, then read the following articles.