What is the Database and Relational Database Management System (RDBMS)

Hi,

I will explain What is the Database and Relational Database Management System (RDBMS) in this article.

Database is a set of physical data that relational data is combined with, in other words, linked data. Well, What is the Data and Information and What are differences between Data and Information ? Read following article to learn answers of these questions.

 

 

 

Database and Relational Database Management System (RDBMS)

A database is a set of physical data that relational data is combined with, in other words, linked data. Databases are growing very fast day by day. In the 1970s, Gigabyte-sized data was probably a dream, but today, Terabyte, even Petabyte Databases, is normal and exist for almost every institution.

In the future, petabyte (1024 terabyte), exabyte, zettabyte and maybe yottabyte  (2^80)  will be normal.

Database Management Systems are available for the management of databases, which are the treasury of institutions.

 

Database management systems are defined as software that ensures that operations such as creating, deleting databases, adding, deleting, updating data from users are performed in a consistent and secure manner.

Ex: A student going to the library wants to find and read a book. Let us assume that the library contains 1000-10,000 different categories and mostly independent books. If these books are not lined up according to a Logic, the person who comes to the Shelves to look for a Book is probably only able to find the book he has been looking for after days of searching if he has not given up his search

 

 

 

This is undesirable and unlikely to occur in real life. That’s why there are a number of methods in libraries that will facilitate many searches with different logic. For example: Sort books in alphabetical order. In this way, when the person is searching for a book, he will get the book he wants in a short time incomparable with other amateur methods.

 

 

Turkish airlines flying to more than 400 planes and more than a thousand cities that we use continuously. Millions of passengers choose one of these airplanes and cities or even certain times. Without a database management system, wouldn’t there be an atmosphere of chaos at the airports if there was no order that kept which passengers would fly to which plane, which city and even with which seat?

The main reason for explaining the above scenario is among the main reasons for the need for Database and Database management systems. As it can be understood from here, Database management system and Database will always be a must among the increasing information technologies in the developing world.

 

Here are the places where the database is used in real life

Airlines: Reservations and Ticket Sales

Banks: Banking and transactions

Insurances: Insurance and transactions

Hospitals: Patient registration and appointment systems

Universities: Student Tracking System and Grade Entries

Online Sales: Customer and Product information

Online Retailing: Order Records and results

Human Resources: Employee Profiles and Salaries

Production: Stocks and tracking of produced products

 

 

Database management systems are a must, now briefly look at what are the most basic Benefits of Database management systems.

 

Data Consistency :  Original data should reflect the most up-to-date status of the Data to users if more than one user accesses it. Ex: You can check the availability on the airline’s web page to buy air tickets and see that there is a quota at the exact moment, and someone else is doing the same procedure you did in the same system and he can also buy the ticket like you.

In this case, if there is no Database Management System, a new customer will receive that ticket based on the availability of the quota. This will cause data inconsistency. That is why Database Management Systems ensure Data consistency in systems where multiple users connect. And only One person can buy that ticket if database managent systems are available.

 

Data Redundancy: It allows managing a common repository that many people use from a single location. Otherwise, there will be many repetitions in the data repository and the consistency of the data will not be ensured.

 

 

 

Data Concurrency: Database management system provides multiple users access to the same data consistently. Otherwise, if the old method and file method were used, users would have access to the same data in order.

 

Data Integrity: when a user in the system is deleted, all data belonging to it must be deleted.

 

 

Data Security: Prevents unwanted destruction and corruption of data. It also exposes Security by allowing users to access only the schemas or tables to which it is authorized.

 

 

Data Independence: Regardless of the structure of the data stored in the database is not important Database management system solves this situation itself.

 

We talked about the benefits of database management systems. What are the database management systems used in the world? The list is as follows Listed from the most important and most used.

 

Oracle : It is the most popular Database Management System with a large portion of DBMS market in the world.

SQL Server : This software, which is a Microsoft product, has increased its market dominance in recent years and increased its pie slice.

MySQL : It is the most widely used Open Source DBMS worldwide. Oracle is the new owner. In addition, the World Wide Social Sharing site, such as Facebook, uses this Database management system.

PostgreSQL : PostreSQL, which is open source and free of charge in recent years, can be the database management system of the future if it continues for 3-5 years.

Sybase : It is a database management system that has increased usage in recent years. SAP is the new owner of Sybase.

DB2 : IBM DBMS is also a widely used product.

 

 

According to recent researches, the popularity and order of DBMS are given below. TOP Rank Databases are as follows.

 

Most of the many database management systems used today are the Relational Database Management System (RDBMS). In relational database management systems, data is kept in structures that we call table consisting of rows and columns. There are hundreds of linked tables in databases. In relational database management systems, the relationship between tables is established through common columns.

 

 

The following illustration shows the tables that hold the Database Server, Server, Virtual Machine, Rack, Load balancer, Database, Application, and User inventory in a Data Center and their relationship to each other.

 

 

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.