Due to the constant development of technology, it is very difficult to imagine the work of large organizations without databases in the world today. Most likely, not everyone knows that there are a variety of types of databases. And they all have their own advantages and disadvantages.
What are hierarchical bases
They appeared first, they have been used on computers for a very long time. Oddly enough, despite all the "antiquity" of such databases, they are still popular in some companies. They are a pyramid. All fields and records associated with each other are grouped together. In such a pyramid, records of both the highest and the lowest level can be used. Each record observes a kind of subordination, the implementation of which is controlled by the database management system.This construction, which has a hierarchical database, does not look so complicated, it is enough to draw an analogy with the family tree. Its advantage is that it is very easy to update. In addition, the employee can access the hierarchical base quite simply. The disadvantage is the fact that it is almost impossible to establish more than one connection between the "descendant" and the "parent".
Advantages of network bases
. , . , , "", . , , , . . , .
Relational database types are the most flexible of all the listed databases. All data is stored in tables, each of which has its own key field. Using this key, the identification of a particular record is simplified. In addition, it is unique to the entire table. Tables communicate with each other by a specific key. For example, one has the key fields "Product Code" and "Seller Code", and the other - the key fields "Seller Code" and "Manufacturer Code". They will be interconnected by means of the "Seller Code" field. Such databases have gained popularity due to their simplicity and ease of redefining records. The disadvantage is a more time-consuming search for the necessary information.A promising future with object-oriented databases
Object-oriented types of databases provide the user with the ability to add new types of information fields, as well as add audio, video and image files to the table structure. Compared to previous databases, object-oriented DBMSs have a large number of advantages.
In addition, their processing is much simpler than in the above cases. Objects that contain such a variety of databases are built from two elements: from data and from instructions that help determine the type of data processing. Among the shortcomings, one can single out the high cost and unwillingness of many companies to acquire such databases instead of old ones that have already been tested for a long time.But database development with the ability to add multimedia objects is becoming increasingly popular. Therefore, there is confidence that in the near future, most organizations will still switch to object-oriented databases.