Database Management

Lancez-Vous. C'est gratuit
ou s'inscrire avec votre adresse e-mail
Database Management par Mind Map: Database Management

1. Data

1.1. Hierarchy

1.1.1. Character

1.1.2. Field

1.1.2.1. Field name

1.1.2.2. Field size

1.1.2.3. Data type

1.1.3. Record

1.1.3.1. Primary key

1.1.4. Data file

1.2. Maintaining Data

1.2.1. File maintenance

1.2.1.1. Adding records

1.2.1.2. Modifying records

1.2.1.3. Deleting records

1.2.2. Validation

1.2.2.1. Alphabetic/Numeric Check

1.2.2.2. Range check

1.2.2.3. Consistency check

1.2.2.4. Completeness check

1.2.2.5. Check digit

1.2.2.6. Other checks

2. Database Management Systems

2.1. Data dictionary

2.1.1. contains data about each file in the database and each field in those files

2.2. Query language

2.3. Form

2.3.1. is a window on the screen that provides areas for entering or modifying data in a database

2.4. Report generator

3. Relational, Object-Oriented, and Multidimensional Databases

3.1. Data model

3.2. Relational database

3.2.1. stores data in tables

3.3. Relationship

3.4. Structured Query Language (SQL)

3.4.1. a query language that allows users to manage, update, and retrieve data

3.5. Object-oriented database (OODB)

3.5.1. stores data in objects

3.6. Multidimensional database

3.6.1. Sometimes known as a hypercube

3.6.2. Can consolidate data much faster than a relational database

3.7. Data warehouse

3.7.1. is a huge database that stores and manages the data required to analyze historical and current transactions