What is Database? What Does It Do?

What is Database?

Database, to put it simply, the systems in which data is stored according to a certain order are called databases. Since the data in database is stored in a certain order, it is very easy and fast to access this information, add new ones or update the existing information.

If we think that every information is a great treasure today, you can see databases as safes where these treasures are stored. These safes are used in many areas from social media to banks, from government offices to personal websites, from desktop software to mobile applications. Even if you are not aware of it, you access various information, add new ones or update them by using these databases.

What are Database Management Systems?

Programming languages with dynamic infrastructure such as PHP, ASP, Java, which are used in servers or computer programs, have developed different interfaces and methods to communicate with databases. These developed interfaces are called "Data Base Management System (DBMS)".

E.g; a dynamic code running on a web server on a database located on a local or remote server; it can do all the features such as deleting, adding, sorting, editing, changing. Of course, in order to perform these operations, there must be a connection between the database and the code you wrote and the necessary permissions must be defined.

Database Types

Distributed Databases: Databases stored in two or more physical media are called shared databases. There are two basic methods of sharing this database. The first method is to partition the central database. Thus, each remote processor has the necessary data to serve its local area. In the second method, the central database is copied to all remote points.

Object-Oriented Databases: A database that automatically stores drawings, images, graphics, sounds, photographs, and all motion video representations as objects to animate and share. This database is often used in marketing and finance. Reason; The storage system, which allows finance and marketing to work in the most appropriate way to the changes in economic conditions, is an object-oriented database.

Hypermedia Databases: The user can choose his own method to switch from module to module. The knowledge chart does not require a predetermined organizational chart. All modules can be displayed on the screen and can also show the connections between the displayed module and other database modules.

Multidimensional Data Analysis: It is offered to the user to see the same data in very different dimensions. E.g; A business that sells four different products such as screws, nuts, bolts and sanitary ware in the Marmara, Aegean and Mediterranean regions can be used to see their actual sales.

Data Banks: Database software that stores up-to-date and historical data in accordance with the expectations of all personnel in the enterprise is called Data Banks. The data processed instantaneously, hourly, daily, weekly or monthly from internal and external sources are copied to the database. This data is standardized and integrated so that it can be easily used in management systems in different units. Anyone in the enterprise can access the database, but they cannot make changes.

Commonly Used Database Types

There are many database systems available today, and the most popular are; MySQL, Microsoft Access, Oracle, MSSQL, PostgreSQL, Sybase, BerkeleyDB, DB2, Informix, Interbase and Sysbase databases.