The most common in practice are which database?

Working with the database accompanies any more or less complex project. The database acts as a repository of information containing everything necessary for the correct working of the system parameters. And what practices most common in practice are? When they are used? To these and other questions will find answers in this article.

General information

So, first you have to decide what is the program in question. Database – the name for the orderly storage of arbitrary information. It can be arranged not only with the help of IT-technologies, but also other ways and methods. But at the same time as a basis must use the principle of systematization.

It Should be noted that the opportunities for organizing and saving data very much. Each method makes certain demands. There are DB, which is aimed at Autonomous operation in one computer. Others provide for interaction with a remote server. If we talk about architecture, the most common are the hierarchical and network databases. In this article, that they will be pointed out.

Hierarchical database

The architecture of the system in this case provides that each object is presented as a specific entity. Because of this it can have parent or child elements. Feature of this architecture is that must be a single object, where it all starts. The result is a structure that resembles a tree. To understand how this organization will help nearly any old program. A database of this type-it is also the file system of the computer.

Recommended

How to get out of "Skype" on the "Android" and not only

How to get out of "Skype" "Android"? This question bothers many users. The thing is that the messenger is not so difficult. But there are features that are only for mobile versions. To log out of Skype in this case more difficult than it seems. But i...

Kingo ROOT: how to use the program to gain administrative rights on Android

The Gadgets on the platform Android regained the lion's share of the market. Developers are continually perfecting the OS, trying to fit the needs of the users, but from year to year admit palpable mistake: forbid the owner to "stuffing" of his gadge...

How to get from Stormwind to Tanaris: practical tips

World of Warcraft is an iconic MMORPG, uniting millions of players around the world. There are many locations and puzzles, secret trails and larger, but rather dangerous paths. Sooner or later, every player chose the side of the Alliance, we have to ...

You Often hear that the use of such structure is not effective. But nevertheless it is still widely used. This is due to the fact that the database is beneficial when you want mainly to read information. Indeed, in this case the structure of this extremely helps. As an example, let's consider such situation: when we choose a certain folder, the interaction is fast. But if we start checking the computer for viruses, as it will last a very long time.

Network database

This is sort of a modification of the previously discussed example. The main difference here is the number of ties. Thus, in hierarchical databases, it is provided that one element can have only one parent. Thus, it is possible to speak about a certain constraint in the development of the database. The network database can have multiple parents. This applies even more to the creation of a database based on XML.

Relational databases

The Most common in practice are they, if we talk about the massive use, edit, and so on. The reason for their popularity is that relational databases are easy to describe in mathematics. Due to the ease of implementation, they are widespread.

A Theoretical basis for them failed mathematician Edgar Frank kodd (now deceased). It in the eighties could very thoroughly and accurately describe the structure of such database, using mathematical language. But as practice shows, such a study is a good basis for program implementation. Relational databases became so popular that when talking about DB, the default understand them. Let us consider the specifics of their implementation.

Relational database

Their Main distinctive feature is that data is stored as sets of two-dimensional tables. As the simplest example can be given database Access, part of office Suite from Microsoft . The role of alpha and omega using the columns and rows. The first feature is that by indicates the name of fields, type of data used in them. In addition, the number of columns is fixed and can be modified only with administrator privileges database. Row well – objects of information. Their number changes relatively easy by providing special instructions.

You Must understand that the database is an abstract concept. Therefore, the most common in practice are the databases in which the tables are related. Very good graphical representation of this question can give the previously mentioned Access. The most important aspect at work is the design of the structure. This process is to create the above mentioned elements. It should be noted that this is a difficult phase to which many novice trifled with. And for good reason. Indeed, while data are limited, the computer will be processed quickly. But with the growth of information quantity will be much slower. Its value will be directly proportional to the size of the stored data and the optimal building structure.

Database Design

So, we have considered most popular options for building a database. Now let's talk about what approaches are the most common in practice are when they are created and why so. As an example, consider MySQL. So, the end result is:

• The database should be a simple object from the point of view of processing.
• The Database needs to be compact in size.

If you have experience it is easy to see that these concepts are contradictory. First we need to understand exactly what will be transferred into a database and withdrawn from it. In serious projects, you can meet dozens and hundreds of tables with an incredible amount of objects. Should consider the following questions:

1. To Determine what data will be stored.
2. Figure Out where information will be posted.
3. To Decide which data type to choose for an individual column.

To reduce the load you can use a breakdown into separate tables. But you must make sure to have certain unifying elements.

Conclusion

Databases are important components any more-less complex project. Initially, in the practical implementation of a person may not be able to organize optimal communication. But over time, when studying this region and increasing experience, it will be possible to create more advanced objects.

You should Also not throw out of focus and then gradually offer more sophisticated policy structure. In addition, all possible assistance in the optimization may be provided by the database management system. They provide the developer with broad functionality, which can be done almost any task. The diversity of the database is quite large, so you can choose one that will suit the taste.