jueves, 21 de mayo de 2015

THE DATA BASE

 the database


What is a database?

es una entidad en la cual se pueden almacenar datos de manera estructurada, con la menor redundancia posible. Diferentes programas y diferentes usuarios deben poder utilizar estos datos. Por lo tanto, el concepto de base de datos generalmente está relacionado con el de red ya que se debe poder compartir esta información. De allí el término base. "Sistema de información" es el término general utilizado para la estructura global que incluye todos los mecanismos para compartir datos que se han instalado.
http://file.mrbool.com/mrbool/articles/Anurag/ProjectDatabase/ProjectDatabase01.gif
http://www.vcharkarn.com/images/varticle/thumbnail/databaseDevelopment.jpg


Why use a database?

A database gives users access to data that can view, enter or update, in accordance with the access rights have been granted. It becomes more useful as the amount of stored data grows.

A database can be local, meaning that you can use only one user on a computer, or it can be distributed, meaning that the information is stored on remote computers and can be accessed via a network.

The main advantage of using databases is that multiple users can access them simultaneously.


types of databases

1. The hierarchical databases
In a hierarchical database data using tree structures (tree) are organized.
A tree is a hierarchical structure in which the elements are usually called nodes and there are dependencies between nodes.

2. The network databases
Also unused in a database network structure graph / network is used, as in the previous case the different objects are linked together by relations type 1: M but in this case an object may be related as child with several items that will be their parents. A case relationships that are created are called SET and the equivalent father called OWNER (owner) and the equivalent son is called MEMBER (MEMBER).

3. relational databases
This is the structure that has been imposed for business applications, is to organize data in tables, relationships between objects are achieved by including in the child table, the key to the parent object. Such as those that use throughout the module have reserved a special section for them.

4. The terms of object-oriented databases
It is a newer model, is stored in the database whole objects (state and behavior). The information provided is divided into attributes and behavior in operations.

5. data bases mutidimensionales
In a multidimensional database data is stored in multidimensional tables instead of two-dimensional tables as the relational model. They are used for large volumes of information.



Elements of a relational database


•    The data is organized in relations composed of tuples of attributes. If we convert this definition tables have that data is organized in tables composed of rows (records) and columns (fields).
•    Each table is assigned a unique name.
•    A table has 0 or more rows, and each row contains the information for a particular "subject" of the relationship.
•    The rows are initially disordered.
•    The list of attributes provided in a specific order from left to right and that form the definition of a table is called a schema of the table, while the specific values of data stored in the table are called occurrences.




It is called database information banks containing data on various topics and categorized differently, but share together some sort of link or relationship that seeks to sort and classify them together.

A database or database is a set of data within the same context and systematically stored for later use. In this sense; a library can be considered a database composed mostly of documents and texts printed on paper and indexed for reference.
Currently, due to technological development in fields such as computer and electronics, most databases are in digital format, this being an electronic component and therefore has developed and offers a wide range of solutions to the problem data storage.

There are denominated management systems databases, abbreviated DBMS to store and subsequently access data quickly and structured programs. The properties of these DBMS, as well as its use and administration, are studied within the field of computing.

The most common applications are for the management of enterprises and public institutions; They are also widely used in scientific environments in order to store the experimental data.

Although databases can contain many types of data, some of which are protected by the laws of several countries. For example in Spain, personal data are protected by the Organic Law of Protection of Personal Data (Act), in Mexico by the Federal Law of Transparency and Access to Public Government Information Law Argentina and Data Protection Personal

No hay comentarios:

Publicar un comentario