Data Architectur

Data Architectur

1. There are three important characteristics inherent to database systems: the separation between application programs and data, the handling of multiple views by users and the use of a catalog to store the database schema.

2. In 1975, the ANSI-SPARC committee (American National Standard Institute - Standards Planning and Requirements Committee) proposed a three-tier architecture for the base systems of data, which is very useful in achieving these three characteristics.ma of the database.

3. CLIENT / SERVER: System is one in which one or more clients and one or more servers, together with an underlying operating system and an interprocess communication system, forms a composite system that allows distributed computation, analysis, and presentation of data .

4. DISTRIBUTED: This is the approach followed by the ANSI / SPARC model. 8. COMPONENT BASED ARCHITECTURE OF A DISTRIBUTED DATABASE MANAGEMENT SYSTEM It consists of two parts such as: data processor and user processor. ... The data processor exists in each node of the distributed database

5. FEDERATED: A federated database can be composed of a heterogeneous collection of databases, in which case it allows applications to look at the data in a more unified way without having to duplicate it through databases or make several queries and combine Manually the results.

6. Centralized Architecture A centralized database it is the one that is totally in a single physical place, it is that is, it is stored in a single machine and in a single CPU, in which users work on terminals that only Show results

Bilder und Dateien der Mindmap