Create your own awesome maps

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account?
Log In

Database Management by Mind Map: Database
Management
0.0 stars - 0 reviews range from 0 to 5

Database Management

Databases, Data, and Information

Quality of Valuable Information

Accurate

Verifiable

Timely

Organized

Accessible

Useful

Cost-effective

Data Integrity

Garbage in, garbage out (GIGO) points out the accuracy of a computer’s output depends on the accuracy of the input

The Hierarchy of Data

Fields

Field name

Field size

Data type

Files

A data file is a collection of related records

Records

A primary key uniquely identifies each record

Characters

Numbers, letters, space, punctuation marks, or other symbols

Maintaining Data

Validating Data

Validation compares data with a set of rules or values to find out if the data is correct

Deleting Records

When a record no longer is needed, a user deletes it from a file

Modifying Records

Users modify a record to correct inaccurate data or update old data

Adding Records

Users add new records to a file when they obtain new data

File Processing Versus Databases

The Database Approach

Programs and users share data

Reduce data redundancy

Improve data integrity

Share data

Allows easier access

Reduces development time

Can be more vulnerable

File Processing Systems

Each department has its own set of files

Used for many years

Have data redundancy

Isolate data

Database Management Systems

Data Dictionary

A data dictionary contains data about each file in the database and each field in those files

File Retrieval and Maintenance

A DBMS provides several tools that allow users and programs to retrieve and maintain data in the database

Backup and Recovery

A DMBS provides a variety of techniques to restore the database to a usable form in case it is damaged or destroyed

Data Security

A DBMS provides means to ensure that only authorized users access data at permitted times

Relational, Object-Oriented, and Multidimensional Databases

Relational Database

A relational database stores data in tables that consist of rows and columns, Each row has a primary key, Each column has a unique name

Object-Oriented Databases (OODB)

An object-oriented database (OODB) stores data in objects

Multidimensional Databases

A multidimensional database can store data in more than two dimensions of data, Sometimes known as a hypercube, Can consolidate data much faster than a relational database

Web Databases

Shop for products or services

Register for college classes

Search for a job

Buy or sell stocks

Check semester grades

Make airline reservations

Database Administration

Database Design Guidelines

It is important to have a carefully designed database

Role of the Database Anaylsts and Administrators

Database analysts and administrators are responsible for managing and coordinating all database activities

Role of the Employee as a User

Employees should learn how to use the data in the database effectively, Interact with database, Identify new data for the database, Maintain the database