Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
40 Cards in this Set
- Front
- Back
Operational Database, Transactional or Production Database
|
Supports a company's Day-to-day operations
|
|
Structured data
|
Result from formatting
- Structure applied based on type of processing to be formed |
|
XML Database
|
Supports semistructured XML Data
|
|
Data Warehouse
|
Stores data used for tactical or strategic decisions
|
|
Semistructured data
|
Have been processed to some extent
|
|
Database Design
|
Focuses on design of database
- Designer must identify database's expected use |
|
Unstructured Data
|
Exist in their original state
|
|
Extensible Markup Language (XML)
|
Represents data elements in textual format
|
|
Data Processing (DP) Specialist
|
Converted computer file structure from manual system
|
|
Metadata
|
Data about data
|
|
Desktop database
|
Single-user, runs on PC
|
|
Enterprise database
|
Supports large number of users
|
|
Database Management Systems (DBMS)
|
Collection of programs
|
|
Multiuser Database
|
Supports multiple users at same time
|
|
Centralized Database
|
Data located at a single site
|
|
Single-User Database
|
Supports only one user at a time
|
|
Workgroup Database
|
Supports small number of users
|
|
Distributed Database
|
Data Distributed across several sites
|
|
Data Processing (DP) Manager
|
Supervised the DP Department
|
|
Data
|
"Raw" Facts
Must be formatted for storage, processing and presentation |
|
Field
|
A character or group of characters that has a specific meaning. Used to define and store data.
|
|
Record
|
A logically connected set of one or more fields that describes a pers place or thing.
|
|
File
|
A collection of related records
|
|
Structural Dependence
|
Access to a file dependent on its own structure
- All file system programs must be modified to conform to a new file structure |
|
Structural Independence
|
Change file structure without affecting data access
|
|
Data Dependence
|
Data access changes when data storage characteristics change
|
|
Data Independence
|
Data storage characteristics do not affect data access
|
|
Logical Data Format
|
How human views the data
|
|
Physical Data Format
|
How COmputer must work with data
|
|
Data Redundancy
|
Same data stored unnecessarily in different places
|
|
Data Inconsistency
|
Different and conflicting versions of same data occur at different places
|
|
Data Anomalies
|
Abnormalities when all changes in reduntant data not made correctly
|
|
Types of Data Anomalies
|
Update, Insertion, Deletion Anomalies
|
|
Database System
|
Defines and regulates the collection, storage, management, and use of data
|
|
Five major parts of Database System
|
Hardware, software, people, procedures, data
|
|
Three types of software required in Database System Environment
|
Operating system software
DBMS software Application programs and utility software |
|
Name the users of the database system
|
System & Database Administrators
Database Designers Systems Analysts and Programmers End Users |
|
Performance Tuning
|
Activities that make the database perform more efficiently
|
|
Disadvantages of database systems
|
Increased Costs,
Management Complexity, Maintaining currency, Vender Dependence, Frequent Upgrade/replacement cycles |
|
Information
|
Result of processing Raw Data to reveal meaning
Requires context to reveal meaning |