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

  • 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 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/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and 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 [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

15 comments

  1. would love to constantly get updated outstanding site! .

  2. Somebody necessarily lend a hand to make severely articles I might state. That is the very first time I frequented your website page and to this point? I amazed with the analysis you made to make this particular put up incredible. Wonderful activity!|

  3. I do not even know how I ended up here, but I thought this post was great. I do not know who you are but certainly you’re going to a famous blogger if you aren’t already 😉 Cheers!|

  4. Your mode of describing all in this piece of writing is really nice, all can simply be aware of it, Thanks a lot.|

  5. This blog was… how do I say it? Relevant!! Finally I’ve found something that helped me. Thanks!|

  6. I really like what you guys tend to be up too. This kind of clever work and exposure! Keep up the great works guys I’ve incorporated you guys to our blogroll.|

  7. I all the time emailed this webpage post page to all my contacts, as if like to read it after that my contacts will too.|

  8. Fantastic beat ! I wish to apprentice while you amend your web site, how could i subscribe for a blog website? The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear concept|

  9. Araya bir paragraf Türkçe karışmış hocam. ☺️

Leave a Reply

Your email address will not be published. Required fields are marked *