{"id":23661,"date":"2023-04-24T13:48:34","date_gmt":"2023-04-24T10:48:34","guid":{"rendered":"https:\/\/klona.ua\/blog\/uncategorized\/database-the-concept-of-a-dbms"},"modified":"2023-05-10T18:13:42","modified_gmt":"2023-05-10T15:13:42","slug":"database-the-concept-of-a-dbms","status":"publish","type":"post","link":"https:\/\/klona.ua\/en\/blog\/artificial-intelligence\/database-the-concept-of-a-dbms","title":{"rendered":"Database. The concept of a DBMS"},"content":{"rendered":"\n

The history of databases is the history of experts who, at various times, tried to understand their complexity. The first information explosions<\/strong> of the early computer era had a lasting impact<\/strong> on how we think about structuring information. The practices, structures, and use of databases<\/strong> , so innovative at the time, have become an integral part<\/strong> of how organizations manage data today. <\/p>\n\n

\"database<\/figure>\n\n

Our company also did not stand aside. It is often difficult for organizations to keep up with dynamic changes in database and AI technology. KLONA<\/a> staff<\/strong> will help you figure it all out. Thanks to many years of experience, the company’s team will be able to determine exactly what needs to be optimized in your business and offer innovative solutions<\/strong> to the problem.<\/p>\n\n

In past articles, we have already discussed the concepts of big data<\/a> and artificial intelligence<\/a> . Now we propose to analyze what<\/strong> databases<\/strong> are, what are their types and where they are useful.<\/p>\n\n

Imagine that you have your own online gardening store. In order to record purchase data , one table<\/strong> was created with records: with the date of purchase, product name, quantity of goods and addresses of buyers.<\/p>\n\n

\"database<\/figure>\n\n

Let’s say Sergey Kovalenko called you and asks about his purchase. You check the table, and there are several such Sergeyev Kovalenko in the database. How to be?<\/p>\n\n

It is much more convenient<\/strong> to create separate tables<\/strong> of customers, orders and products.<\/p>\n\n

Now these tables, although they seem so different, are actually connected<\/strong> . For example, each customer and product of a store has its own ID, and in the table these IDs are placed on one common row. Agree, now it is much easier and more convenient to work with customer data.<\/p>\n\n

\"database<\/figure>\n\n

What was before databases?<\/h2>\n\n

The way computers manage data has changed dramatically<\/strong> over the past few decades. Today’s users take for granted many of the benefits<\/strong> of a data warehouse<\/strong> system. <\/p>\n\n

One way to store information on a computer is to store<\/strong> it in<\/strong> permanent files<\/strong> . The company’s system has a number of application programs; each of which is designed to manipulate data files. These applications<\/strong> were written at the request<\/strong> of users in organizations. New applications are added to the system when needed. The system just described is called the file system<\/strong> .<\/p>\n\n

\"file<\/figure>\n\n

In the 60s,<\/strong> database management systems ( DBMS<\/strong> ) were created. The technology made it possible to arrange<\/strong> huge volumes of information<\/strong> . The difficult task of organizing the records on the media for optimal access was now handled by a subsystem called the DBMS.<\/p>\n\n

What are databases?<\/h2>\n\n

Databases<\/strong> are collections<\/strong> of organized information<\/strong> . <\/p>\n\n

Any collection<\/strong> of information is an information system<\/strong> . A payroll file, a stack of hospital forms for patients, a collection of information about a company’s clients – these are all databases.<\/p>\n\n

Information stores<\/strong> not only provide<\/strong> places to store data, but also provide an organized structure<\/strong> for it. In addition, the technology provides mechanisms for interacting<\/strong> with information. The databases allow you to query<\/strong> , create<\/strong> , modify and delete data.<\/p>\n\n

\n