Programming

Network Database Model: Database Models in Computing

Today’s world is increasingly virtual, so we are obliged to interact with programs, applications and technological tools, so that it is necessary to know them. On this occasion, information of interest about the Computer Database models is presented. network database model

Database models

Network database model
Network database model

A database is defined, it is a group of data that have a similar origin and that are systematically recorded so that they can be processed later. How this information is processed will depend on the scope that the user has established.

If you want to understand in a simple way what a database is, you can take a library as an example, since information and documents of different topics are recorded and stored , which are kept with common points and in an orderly way so that be consulted in the future.

The databases work in the same way, they order and categorize the registered data, which will be available for later consultation and analysis.

Regarding the process of saving information in the library, it can be the mirror image of what is known as indexing, which is daily in search engines or Internet browsers, this is supported by different types of base models of data .

Special software has been developed with which it is possible to work with all the database models , which are known as Database Management Systems. These systems allow quick storage and subsequent access to the data stored within the database.

In particular, Database Management Systems have customized characteristics for the different types of database models .

In network

Network databases are similar to hierarchical databases, but their main difference is the way the node is made up. In this type of database models , nodes can have different parents or parents.

Which was developed for the first time, represented a great evolution in relation to hierarchical databases , because its variant in the way of constructing the nodes provided a solution to the inconveniences when data were redundant.

Currently this type of database models is not used regularly, because the complexity of making changes or modifications, in addition to making adaptations, increases the level of complexity of the way they are structured, which makes it unattractive to be used by programmers. or regular database users.

Types

Currently, there are a large number of databases that can be used, they are classified according to their context, structure, user needs and usefulness. Below we present the classification of the Types of database models :

According to the variability of the database

The first type of database models that is presented will depend on the way in which the data is structured within it. There are two types: dynamic and static databases.

Static Databases network database model

Network database model
Network database model

These databases in particular are created for reading the stored data. It is used for the storage and recording of historical data and the development of studies that allow us to understand behavior and patterns over a certain time.

This type of database is very useful for organizations that want to make projections, statistics and direct their decision-making processes from the organizational aspect.

Dynamic databases network database model

In contrast to static ones , dynamic databases can be modified over time, allowing permanent functions in terms of updating, editing and deleting data as desired.

To understand in a practical way how a database works, an ambulance service at home will be used as an example. In order to provide an adequate medical service, the patient care staff keeps a record of the ambulances they have and the personnel assigned to each one.

At the time of being called for an emergency, the patient care staff must quickly consult the available ambulances with their respective health personnel and also, must tell the patient in emergency: the availability and estimated waiting time.

According to the content network database model

Continuing with the analysis of the data and the types of database models that exist, we present a class of databases that depends on the prioritization of the content to be analyzed. Among those that can be mentioned in this type of database models , we have:

Bibliographic network database model

Bibliographic databases , perhaps the best known and managed by all, are the record that helps the user to classify different data fields.

A database of this type can include the following fields: date of publication , author, title, publisher, among other fields.

These fields can be consulted and reviewed individually or in groups. However, it should be noted that in this type of database models the complete information contained in a document will not be obtained.

Full text network database model

This is a functional database that allows you to search for specific terms or words, keywords and any option that can be presented in a bibliographic type database, but in this type of database models you can query the full text that is stored.

These databases are widely used at academic and scientific research levels .

Directories network database model

These types of database models are what we use daily. In fact, we have them on mobile devices, with the information that is collected in the applications we use and that we back up in a virtual cloud.

They are usually used for business purposes, and include basic parameters that allow to maintain order and have the information organized, an example of this: names, addresses, telephone contacts, email addresses, postal codes , among others.

According to the models  

These types of database models are characterized by different data management archetypes.

Most of these types of database models are governed by their structuring to the way in which the data is saved, through descriptions, on the other hand, there are other types that will depend on the techniques of storing and retrieve those descriptions.

The powerful thing about these types is that as they are completely digital, more efficient database systems can be implemented in relation to algorithms.

Hierarchical network database model

This type of database models allows information to be stored in a hierarchical structure or with an order or category of importance. In this database the data is organized in a tree or inverted triangle image.

This hierarchical structure that is built in the form of an upside down triangle, is built with segments or fragments known as branches or nodes.

The nodes or segments that the tree database allows to build can be achieved in three categories or ways:

  1. Parental: this is a node that triggers descendants. All parents are located at the same level and are given the same importance value.

  2. Child: this node will depend on the parental node, it is a derivative of the previous one.

  3. Root: this is the origin of the data, since it does not have a parental node, it is located in the highest part of the inverted tree, from this all nodes are triggered.

Advantages of the data structure  network database model

Among some of the advantages that implementing this type of database models gives us we can highlight the process of globalization of information, the incredible ability to share information between the different users of the databases, the integration of the information, since its structure ensures that only the correct information will be recorded and stored and, finally, the independence of the data.

Disadvantages of the data structure

Among the disadvantages that can be highlighted, we have: the weak points of this type of database model are concentrated in that it is rigid, since, once the database is created and designed, it is difficult to make changes or modifications. network database model

Likewise, it can be emphasized that the construction of this type of database models is not easy . In addition, it requires a lot of knowledge of the information units that are going to feed it and it is necessary to define in a very specific way the relationships said units will have with each other.

Transactional network database model

These types of databases are built to meet very specific objectives. They take care of sending and receiving data at high speed. Transactional databases are really unusually used by users who are not associated with the industrial area and production areas in very complex lines.

A typical example , where a transactional database can be used, is within the banking system, where any type of monetary exchange operation between accounts is recorded. From an account there is an emission of data of the debit of the money and instantaneously, the account that was defined as the destination account, load data of the amount or amount of money that is received is created.

Relational network database model

Relational databases have long taken over the database arena. The central point of this type of database models is the use of the relationships between the data. network database model

The programming language that dominates in this type of database is SQL, which stands for “Structured Query Language”.

For more information, we invite you to read the article on History of programming languages .

Its operation is basically that the data is entered in the respective registers, which will then be organized in tables. As the data is organized, the possible relationships that exist between these data can be raised in a simple way, and it is possible to cross them quickly for the subsequent issuance of the required reports and analysis .

These databases are recommended when the data to be used has a minimum to null margin of error and will not need to be constantly changed or modified. network database model

Basically, these databases are based on the fact that the data is placed in records, which are then organized in tables, allowing the elements or parameters to be related to each other in a very simple way and immediately crossing them, managing to establish relationships or associations between the records of intuitive way.

Multi-dimensional network database model

These databases are created to perform very defined functions. There is not much difference between relational databases and multidimensional databases. Where they differ, it can only be seen in the conceptual range, because in them, the attributes or fields of the table can be of two classes.

Object oriented network database model

This type of object-oriented database models are among the most current known. It is important to highlight the great capacity and power of these databases. In this type of database models, not only is specific information about the object stored, but the object is completely stored.

The object is given a set of characteristics to distinguish it from objects that may be similar. The advantages and benefits of this database model are that they admit a greater number of content and allow the user to have much more information about the object at hand.

Documentaries network database model

This type of database model is a group of information that documents such as data query and storage structuring use. These documents are made up of multiple data and records, and are designed with the NoSQL programming language, which provides a large number of technical and flexible advantages and benefits.

These databases allow the manipulation of large volumes of information in short periods of time. Today, its wide variety of modules and functions that can be adapted to many query mechanisms, have made it one of the most popular working databases for programmers.

Deductives network database model

This is a database that gives the possibility of carrying out deductive actions through inference, its operation will depend on the parameters , conditions and events that can be stored in that database.

These databases are better known as logical databases, since it is based on mathematical logic. These arise as a result of the restrictions that arise in relational databases when making queries and establishing theories about the relationships that may arise between the data that were stored.

This database uses a well-known programming language datalog that allows the computer to solve the deductions in order to answer the users’ queries.

Among the benefits or advantages that deductive databases offer us, we can mention:

  1. Use of logical norms to resolve queries.

  2. It has stratified negations.

  3. Ability to acquire new information through information that is already stored in the database through inference.

  4. Use of algorithms that achieve the optimization of the queries.

  5. Supports more complex objects and groups .

Access to the information of the Databases 

Although the great particularity of databases is data storage, but users stand out as the key feature, the retrieval of information simply and quickly . network database model

In a relational database, it is very easy to query information about a worker, but in addition, these databases add the powerful complex queries, such queries are requests to teach specific kinds of information or to report on the use of the data.

A clear example is a database of workers that contains tables such as information on salary compensation, job description, and a supervisor can make a query of workers who have higher salaries or from a certain salary amount.

It is irrelevant what kind of information is stored in the database, the respective queries can be designed using SQL as a programming language, which will help you answer more critical questions .

Storage network database model

The databases range from small sizes, 1MB, to larger and more complex, such as terabyte government databases, however, all databases manage to store and locate the information saved on the used storage device through the use of a computer.

Large databases may require the use of servers at different sites, but databases can be easily stored as files on a computer’s hard drive .

Assurance network database model

A large part of databases store information of a security and important nature, which should not be easily accessible by any user, so that access codes and other security measures must be used to achieve access to complete information. .

Some databases can be entered through the use of the Internet, but others are closed systems and can be entered on local computers. network database model

Related Articles

Leave a Reply

Your email address will not be published.

Back to top button