Classification of data banks

Table of contents

1. Data bank (BnD) 1

1.2 Benefits of BnD.. 2

1.3 Classification of data banks. 2

Database classification. 3

DBMS classification.. 4

Classification groupings related to BnD as a whole.. 6

2. Database design. 7

2.2. Classic approach to database design. nine

3. Normalization of relationships in the database.. 10

BANKS AND DATABASES

Data bank (BnD)

A data bank is a system of specially organized data ( databases ), software, technical, linguistic, organizational and methodological means designed to ensure centralized accumulation and collective multi-purpose use of data.

Databank is an automated information system for centralized storage and collective use of data. The data bank includes one or more databases, a database directory, a DBMS, as well as libraries of queries and application programs.

Data bankaccording to the legislation of the Russian Federation – a set of databases, as well as software, language and other tools designed for centralized accumulation of data and their use with the help of electronic computers.

Basic data array – information on electronic media, organized in accordance with the requirements of a single data description language and representing the information basis of the data bank.

Information retrieval system IPS (Information retrieval system) is a system that performs the following functions:

– storage of large amounts of information;
– fast search of the required information;
– adding, deleting and changing stored information;
– output of information in a human-friendly form.

Distinguish:
– automated (coputerised);
– bibliographic (reference);
– dialogue (online);
– documentary and factographic information retrieval systems.

A bank of sociological information is a set of information used and obtained in the process of sociological research, as well as means for obtaining, storing, processing and disseminating it.

Cartographic data bank is a set of technical, software, information and organizational tools for storing, processing and using digital cartographic data. The cartographic data bank includes:

– cartographic databases for one or more subject areas;
– database management system;

– libraries of requests and application programs.

Distributed databank – a system of geographically dispersed databanks, united by means of computer technology and functioning under a single control.

Television library (Television library) – a data bank containing mainly images and videos. Television libraries use various types of optical storage media for data storage.

The main distinguishing features of data banks:

· Databases are usually created not to solve any single task for one user, but for multi-purpose use .

· Databases reflect a certain part of the real world . We must strive to ensure that all information describing the subject area is recorded in the database once, accumulated and kept up to date centrally, and all users who need this information should be able to work with it.

Databases are specially organized data . These features in the organization of data lie, first of all, in the fact that databases are systems of interconnected data, the unity and integrity of which is maintained by special software.

· For the functioning of the database, it is necessary to have special language and software tools (called DBMS – Database Management System), which make it easier for users to perform all operations related to the organization of data storage, their correction and access to them.

Benefits of BND

The presence of a single display of a certain part of the real world makes it possible to ensure the consistency and integrity of information, the ability to access it not only when solving predetermined tasks, but also with unregulated requests. Integrated storage reduces the redundancy of stored data, which reduces the cost of not only creating and storing data, but also keeping it up to date. Providing a more complete implementation of the principle of independence of application programs from data than is possible with the organization of local files.

Classification of data banks

Data banks are complex systems, and their classification can be made both for the entire data bank as a whole, and for each of its components separately; classification for each of the components can be carried out according to many different features (Fig. 1.1).

Be First to Comment

Leave a Reply

Your email address will not be published.