Term
|
Definition
| Raw facts that describe the characteristics of an event |
|
|
Term
|
Definition
| Data converted into a meaningful and useful context |
|
|
Term
|
Definition
| Refers to the extent of detail within the information (fine and detailed or course and abstract) |
|
|
Term
| Transactional Information |
|
Definition
| Encompasses all the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks |
|
|
Term
|
Definition
| Encompasses all organizational information, and its primary purpose is to support the performance of managerial analysis tasks |
|
|
Term
|
Definition
| Immediate, up-to-date information |
|
|
Term
|
Definition
| Provide real-time information in response to query requests |
|
|
Term
| 5 common characteristics of high quality information |
|
Definition
| Accuracy, completeness, consistency, uniqueness, and timeliness |
|
|
Term
| 4 primary sources of low-quality information |
|
Definition
1. Online customers intentionally enter inaccurate information to protect their privacy
2. Different systems have different information entry standards and formats
3. Call-center operators enter abbreviated or erroneous information by accident or to save time
4. Third-party and external information contains inconsistencies, inaccuracies, and errors |
|
|
Term
|
Definition
| Maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) |
|
|
Term
|
Definition
| Information is organized into treelike as structure that allows repeating information using parent–child relationships in such a way that it cannot have too many relationships |
|
|
Term
|
Definition
| A flexible way of representing objects and their relationships- The network model allows each record-multiple parent and child records, forming a lattice structure |
|
|
Term
| Relational Database Model |
|
Definition
| A type of database that stores information in the form of logically related two-dimensional tables |
|
|
Term
|
Definition
| A person, place, thing, transaction, or event about which information is stored |
|
|
Term
|
Definition
| Also called fields or columns, are characteristics or properties of an entity class |
|
|
Term
|
Definition
| A field (or group of fields) that uniquely identifies a given entity in a table |
|
|
Term
|
Definition
| A primary key of one table that appears as an attribute in another table and asked to provide a logistical relationship between the 2 tables |
|
|
Term
|
Definition
| A view of information that deals with the physical storage of information on a storage service such as a hard disk |
|
|
Term
|
Definition
| A view of information that focuses on how users logically access information to meet their particular business needs |
|
|
Term
|
Definition
| Refers to how well a system can adapt to increased demands |
|
|
Term
|
Definition
| Measures how quickly a system performs a certain process or transaction |
|
|
Term
|
Definition
| The duplication of information, or storing the same information in multiple places |
|
|
Term
|
Definition
| A measure of the quality of information |
|
|
Term
|
Definition
| Rules that help ensure the quality of information–these can be defined and built into the database design |
|
|
Term
| Relational Integrity Constraints |
|
Definition
| Rules that enforce basic and fundamental information-based constraints |
|
|
Term
| Business-Critical integrity Constraints |
|
Definition
| Enforce business rules model to an organization success and often require more insight and knowledge that relational integrity constraints |
|
|
Term
| Database Management System |
|
Definition
| Software through which users and application programs interact with a database |
|
|
Term
|
Definition
| An interactive website Constantly updated and relevant to the needs of its customers through the use of the database |
|
|
Term
|
Definition
| Allow separate systems to communicate directly with each other |
|
|
Term
|
Definition
| Takes information entered into a given system and sends that automatically to all downstream systems and processes |
|
|
Term
|
Definition
| Takes information entered into a given system and sends it automatically to all upstream systems and processes |
|
|
Term
|
Definition
| A logical collection of information–gathered from many different operational databases–the support of business analysis activities in decision-making tasks |
|
|
Term
| Extraction, Transformation, and Loading |
|
Definition
| A process that tracks information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse |
|
|
Term
|
Definition
| Contains a subset of data warehouse information |
|
|
Term
|
Definition
| The common term for the representation of multidimensional information |
|
|
Term
| Information cleansing or scrubbing |
|
Definition
| A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information |
|
|
Term
|
Definition
| The process of analyzing data to extract information not offered by the raw data alone |
|
|
Term
|
Definition
| Use a variety of techniques to find patterns in relationships in large volumes of information and confirm rules from them that predict future behavior and guide decision-making |
|
|
