The structured information stored in computer systems and all electronic media is called Database. The database, which consists of a large amount of information, is controlled with the help of database systems.

What Does a Database Do?

Today, database systems are used not only in computer or electronic environments, but also in all web applications. We have listed the answers to the question of what a database is for, in bullet points:   

Enables the required information to be recorded and used when necessary.   

Helps update information.   

It provides access to all the information of millions of people in a short way.   

He contributed to the development of the software industry. Storing the codes required for the software through database systems is very important in moving to the next stage.   

Data; All operations such as deleting, editing, querying and changing can be done thanks to database systems.

What are the Database Types?

We will talk about database programs that are well known to those who work in coding. We can discuss database types in two categories.

In flat file database type: A single database is fitted into a single table. Databases used by programs such as Word and Excel are of this type.

In Relational Database: Many data tables are used. A relationship is also established between these tables. It has features such as taking up little space and being easy to use. Such database systems are used in coding programs and web structures. It was first developed by IBM in the 1970s.

SQL:

Database system with Structured Query Language; It has a structure that regulates the information of the contact directory on mobile phones, visitors and users on web pages, and members on websites that operate with a membership system. The SQL system is used in many areas today, including websites. This system is a must, especially in package programs prepared for human resources.

Access:

It is a good example of a relational database system. Multiple tables can be created and edited with an Access database. It is also very easy to edit these tables. You can create tables with the help of icons with Access, a product of Microsoft. The program also allows the user to design transactions. For example, you will prepare labels for your mailing operations and this process takes a lot of time. With the Access program, you can perform batch operations with a few mouse movements and perform many labeling operations in a short time. You can also perform mathematical operations on the tables you create. You can edit the tables you create in programs such as Excel, Word, Paradox, Dbase, in the Access database.

DB2:

This database system developed by IBM is designed for warehousing and control of moving workloads. It is also preferred by students and programmers. It is easy to install and use. It has an independent platform. Compatible with Java, PHP and .Net. The biggest advantage of the DB2 database program is that it can be used easily with its advanced wizard feature, even if you do not know anything.

Ingformix:

Another IBM wonder... Ingformix is ​​another database type developed by the company. It is also highly compatible with SQL and NoSQL/JSON database programs. It has a fast and flexible structure. It can be used without any problems in processing corporate data and in areas with high workload. One of the best features of the program is that it processes highly available data quickly. It also prevents data loss thanks to remote secondary backup database servers.

MySQL:

It is the most preferred database program by web hosting companies. You must have come across this database in your panel when you received hosting service. It was developed by a Swedish company called AB. However, in 2008, Sun Microsystems acquired all rights. We can compare the working system of the program to the gallery folder on your mobile phone. When you take a photo, it is automatically kept in a folder called gallery. So the gallery folder is a database for you. Here you organize photos, delete them and use them as needed. This is the working principle of the program. Since it is open source, it can be changed and edited easily.

Oracle:

It is the name of a technology company originating from California. The company has developed a database system named after itself. The same company is the one that released the software called Java. Working according to the relational database principle, Oracle can hold large data. It allows setting the storage areas of the data.It can serve multiple users without compromising the integrity of the data. It does not affect the performance of the system it uses and uses its performance in the best way.

SQL Server:

It is the server version of the SQL database system created by Microsoft. The Express version is for educational purposes and is free. The Compact version connects systems with mobile devices. The WEB version is used for applications on small-scale websites. In this way, there are many different versions of the SQL Server system.

Sybase:

It is the database system released by SAP, which was founded in 1984. SAP company first presented its database management system to the world. In addition, the company; He also has successful studies in the fields of analytical technologies, information management, finance and telecommunications. General features of the program; database management system, replication technology, investment banking data processing, can be listed as the world's largest data warehouse.

What Does a Table Mean in a Database?

Tables are the backbone of databases. Information such as address information, names, passwords and e-mail addresses are all stored in tables in database systems. Likewise, with the help of these tables, data is sorted and manipulated. In some database programs, tables are located in rows of 2 or 3. In some programs, it is available in systems of 12. Tables can be created and personalized in database systems. At least many database systems allow these applications.

Brief Database History and Evolution of the Database

It all started in 1960. The first database was used for storing electromagnetic data. However, since it was a very expensive process, it was used only by people who could afford this expense. In the 1970s, memory systems improved and component prices began to fall. These years were also the years when database systems began to develop and become widespread.

By the 1980s, storing and storing data became a mandatory need for those selling hardware systems and trading on a large scale. In these years, IBM company developed data systems similar to today's in order to meet these needs. In the 90s, database systems began to evolve towards management systems.