Reading...
Play button
Play button
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;
19 Cards in this Set
- Front
- Back
|
Information Granularity
|
-the extent of detail within the information
-ex. fine and detail or coarse and abstract |
|
|
Transactional Information
|
-encompasses all of the information contained within a single business process or unit of work
-its primary purpose is to support the performing of daily operational tasks |
|
|
Analytical Information
|
-encompasses all organizational information
-its primary purpose is to support the performing of managerial analysis tasks |
|
|
Real Time Systems
|
-provide real-time information (immediate, up to date) in response to query requests
|
|
|
Five Common Characteristics of High Quality Information
|
1. accuracy
2. completeness 3. consistency 4. uniqueness 5. timeliness |
|
|
Hierarchical Database Model
|
-information is organized into a tree-like structure that allows repeating information using parent/child relationships in such a way that it cannot have too many relationships
|
|
|
Network Database Model
|
-flexible way of representing objects and their relationships
|
|
|
Relational Database Model
|
-type of database that stores information in the form of logically related two-dimensional tables
|
|
|
Entity
|
-person, place, thing, transaction or event in the relational database
|
|
|
Attributes (fields or columns)
|
-characteristics or properties of an entity class
|
|
|
Primary Key
|
-a field (or group of fields) that uniquely identifies a given entity in a table
-ex. customer i.d. or order number |
|
|
Foreign Key
|
-primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
|
|
|
Relational Database Advantages
|
-increased flexibility
-increase scalability and performance -reduced information redundancy -increase information quality -increased information security |
|
|
Data-driven website
|
-interactive website kept constantly updated and relevant to the needs of of its customers through the use of its database
|
|
|
Data Warehouse
|
-logical collection of information-gathered from many different operational databases
|
|
|
Extraction, Transformation, and Loading (ETL)
|
-process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the info into a data warehouse
|
|
|
Data Mart
|
-contains a subset of data warehouse information
|
|
|
Cube
|
-common term for the representation of multidimensional information
|
|
|
Informational Cleansing or Scrubbing
|
-process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information
|
