Get Started. It's Free
or sign up with your email address
Rocket clouds
Database Management by Mind Map: Database Management

1. Data

1.1. The Hierarchy

1.1.1. Files

1.1.1.1. A data file is a collection of related records

1.1.2. records

1.1.2.1. A record is a group of related fields

1.1.2.2. primary key

1.1.3. fields

1.1.3.1. Field name

1.1.3.2. Field size

1.1.3.3. Data type

1.1.4. characters

1.1.4.1. Numbers

1.1.4.2. letters

1.1.4.3. space

1.1.4.4. punctuation marks

1.1.4.5. other symbols

1.2. Type

1.2.1. Text

1.2.2. Video

1.2.3. Numbers

1.2.4. Audio

1.2.5. Images

1.3. Maintaining Data

1.3.1. File maintenance

1.3.1.1. Adding records

1.3.1.2. Modifying records

1.3.1.3. Deleting records

1.3.2. Validation

1.3.2.1. Alphabetic/Numeric check

1.3.2.2. Range check

1.3.2.3. Consistency check

1.3.2.4. Completeness check

1.3.2.5. Check digit

1.3.2.6. Other check

2. Database

2.1. File Processing Versus Databases

2.1.1. file processing system

2.1.2. Database approach

2.2. Database Management Systems

2.2.1. data diconary

2.2.2. tools

2.2.2.1. Query language

2.2.2.2. Query by example

2.2.2.3. Form

2.2.2.4. Report generator

2.2.3. variety of techniques

2.2.3.1. Backup

2.2.3.2. Log

2.2.3.3. Recovery utility

2.2.3.4. Continuous backup

2.3. Relational, Object-Oriented, and Multidimensional Databases

2.3.1. data model

2.3.2. relational database

2.3.2.1. stores data in tables that consist of rows and columns

2.3.3. relationship

2.3.3.1. a link within the data

2.3.4. Structured Query Language (SQL)

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

2.3.5. object-oriented database (OODB)

2.3.6. applications appropriate

2.3.6.1. Multimedia database

2.3.6.2. Computer-aided design database

2.3.6.3. Groupware database

2.3.6.4. Hypertext database

2.3.7. multidimensional database

2.3.7.1. can store data in more than two dimensions of data

2.3.8. data warehouse

2.3.8.1. a huge database that stores and manages the data required

2.4. Web Databases

2.4.1. Databases on the Web

2.4.1.1. Shop for products or services

2.4.1.2. Buy or sell stocks

2.4.1.3. Search for a job

2.4.1.4. Make airline reservations

2.4.1.5. Register for college classes

2.4.1.6. Check semester grades