Types and role of database administrators

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp

Contents

Database management systems (SGBD), also known as database management systems or DBMS (DataBase Management System), are a set of programs who are responsible for the administration of the database, managing everything database access, in order to serve as Iinterface between him, the user and the applications used.

abstract-background-of-technology-science-and-cloud-computer-3d-illustrationn

carloscastilla

Thanks to this specific software system the user can manage the database (to stock, modify and access the data contained therein) through the use of different analysis tools, with which you can make queries and generate reports.

The functions of a database management system

While managing data and maintaining its consistency, lUsing a database management system has many advantages. Especially when building and establishing the database at different levels of abstraction. for different applications, since it facilitates the processes and also its maintenance.

Executing operations on the database and then providing them to the user based on their requirement is carried out efficiently and securely. The characteristics of a SGDB enable the fulfillment of a number of functions, that can be grouped in the next way:

1. Defining the data: the dbms must be able to set all objects in the database from the definitions in the source version to convert them to the version of the object.

2. Data manipulation: the database management system responds to user requests to perform delete operations, updating and extraction, among other.. Data management must be done quickly, according to requestsions made by users, and make it possible to modify the database schema thanks to their independence.

tipos_funcion_gestores_bases_datos-6111786

3. Data security and integrity: At the same time to record the use of the databases, before any request, will also apply security and data integrity measures (adopts measures to guarantee its validity) previously defined. A DBMS must ensure its security against attacks or simply prevent its access to unauthorized users for any reason..

4. Data recovery and restoration: the recovery and restoration of data in case of a feasible failure is another of the main functions of a DBMS. Your application will be carried out through a data recovery and restoration plan that will be useful backup.

Types of Database Administrators

The typology of DBMS is very varied, depending on the criteria we use. In reality, The database management system can be grouped according to the data model, number of users or sites. Even though this is usually the most common, typology can obey many other guidelines, as appropriate from a specific practical approach:

If we attend data model, database testers can be:

  • Relational

  • Networked

  • Hierarchical

  • Object-oriented

Besides, it is feasible to differentiate them according to whether they are owners or not, but also according to the license, according to the Number of users single or multi-user user. In conclusion, it is worth mentioning that It is also feasible to group these database management systems into centralized and distributed, this time according to the number of sites..

Related Post:

(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = “//connect.facebook.net/es_ES/all.js#xfbml=1&status=0”;
fjs.parentNode.insertBefore(js, fjs);
}(document, ‘script’, 'facebook-jssdk'));

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.