Intro To Databases

Front 1

Operational Database, Transactional or Production Database

Back 1

Supports a company's Day-to-day operations

Front 2

Structured data

Back 2

Result from formatting
- Structure applied based on type of processing to be formed

Front 3

XML Database

Back 3

Supports semistructured XML Data

Front 4

Data Warehouse

Back 4

Stores data used for tactical or strategic decisions

Front 5

Semistructured data

Back 5

Have been processed to some extent

Front 6

Database Design

Back 6

Focuses on design of database
- Designer must identify database's expected use

Front 7

Unstructured Data

Back 7

Exist in their original state

Front 8

Extensible Markup Language (XML)

Back 8

Represents data elements in textual format

Front 9

Data Processing (DP) Specialist

Back 9

Converted computer file structure from manual system

Front 10

Metadata

Back 10

Data about data

Front 11

Desktop database

Back 11

Single-user, runs on PC

Front 12

Enterprise database

Back 12

Supports large number of users

Front 13

Database Management Systems (DBMS)

Back 13

Collection of programs

Front 14

Multiuser Database

Back 14

Supports multiple users at same time

Front 15

Centralized Database

Back 15

Data located at a single site

Front 16

Single-User Database

Back 16

Supports only one user at a time

Front 17

Workgroup Database

Back 17

Supports small number of users

Front 18

Distributed Database

Back 18

Data Distributed across several sites

Front 19

Data Processing (DP) Manager

Back 19

Supervised the DP Department

Front 20

Data

Back 20

"Raw" Facts
Must be formatted for storage, processing and presentation

Front 21

Field

Back 21

A character or group of characters that has a specific meaning. Used to define and store data.

Front 22

Record

Back 22

A logically connected set of one or more fields that describes a pers place or thing.

Front 23

File

Back 23

A collection of related records

Front 24

Structural Dependence

Back 24

Access to a file dependent on its own structure
- All file system programs must be modified to conform to a new file structure

Front 25

Structural Independence

Back 25

Change file structure without affecting data access

Front 26

Data Dependence

Back 26

Data access changes when data storage characteristics change

Front 27

Data Independence

Back 27

Data storage characteristics do not affect data access

Front 28

Logical Data Format

Back 28

How human views the data

Front 29

Physical Data Format

Back 29

How COmputer must work with data

Front 30

Data Redundancy

Back 30

Same data stored unnecessarily in different places

Front 31

Data Inconsistency

Back 31

Different and conflicting versions of same data occur at different places

Front 32

Data Anomalies

Back 32

Abnormalities when all changes in reduntant data not made correctly

Front 33

Types of Data Anomalies

Back 33

Update, Insertion, Deletion Anomalies

Front 34

Database System

Back 34

Defines and regulates the collection, storage, management, and use of data

Front 35

Five major parts of Database System

Back 35

Hardware, software, people, procedures, data

Front 36

Three types of software required in Database System Environment

Back 36

Operating system software
DBMS software
Application programs and utility software

Front 37

Name the users of the database system

Back 37

System & Database Administrators
Database Designers
Systems Analysts and Programmers
End Users

Front 38

Performance Tuning

Back 38

Activities that make the database perform more efficiently

Front 39

Disadvantages of database systems

Back 39

Increased Costs,
Management Complexity,
Maintaining currency,
Vender Dependence,
Frequent Upgrade/replacement cycles

Front 40

Information

Back 40

Result of processing Raw Data to reveal meaning

Requires context to reveal meaning