Term
|
Definition
| maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) |
|
|
Term
| Hierarchical database model |
|
Definition
| information is organized into a tree-like structure (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 |
|
|
Term
| Relational database model |
|
Definition
| 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
| Attributes (fields, columns) |
|
Definition
characteristics or properties of an entity class
-The columns of each table contain the attributes |
|
|
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 an attribute in another table and acts to provide a logical relationship among the two tables |
|
|
Term
| Database advantages from a business perspective |
|
Definition
Increased flexibility
Increased scalability and performance
Reduced information redundancy
Increased information integrity (quality)
Increased information security |
|
|
Term
|
Definition
| deals with the physical storage of information on a storage device |
|
|
Term
|
Definition
| focuses on how users logically access information |
|
|
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
| A database has one a.)_________ and multiple b.)___________ |
|
Definition
a.)physical view
b.)logical view |
|
|
Term
|
Definition
| measures the quality of information |
|
|
Term
|
Definition
| rules that help ensure the quality of information |
|
|
Term
|
Definition
| Provides authentication of the user |
|
|
Term
|
Definition
| determines who has access to the different types of information |
|
|
Term
|
Definition
| determines types of user access, such as read-only access |
|
|
Term
| Database management systems (DBMS) |
|
Definition
| software through which users and application programs interact with a database |
|
|
Term
|
Definition
| an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database |
|
|
Term
|
Definition
| allows separate systems to communicate directly with each other |
|
|
Term
|
Definition
| takes information entered into a given system and sends it 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 – that supports business analysis activities and decision-making tasks |
|
|
Term
| Primary Purpose of a Data warehouse |
|
Definition
| aggregate information throughout an organization into a single repository for decision-making purposes |
|
|
Term
| Extraction, transformation, and loading (ETL) |
|
Definition
| a process that extracts 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
| Databases contain information in a series of ___________________________ |
|
Definition
|
|
Term
| In data warehouses and data marts, information is _______________ |
|
Definition
|
|
Term
|
Definition
| a particular attribute of information |
|
|
Term
|
Definition
| Common term for the representation of multidimensional information |
|
|
Term
|
Definition
| the process of analyzing data to extract information not offered by the raw data alone |
|
|
Term
|
Definition
| uses a variety of techniques to find patterns and relationships in large volumes of information and infers rules that predict future behavior and guide decision making |
|
|
Term
| Information cleansing or scrubbing |
|
Definition
| a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information |
|
|
Term
|
Definition
| information that people use to support their decision-making efforts |
|
|
Term
| Principle BI enablers include: |
|
Definition
| Technology, People, Culture |
|
|
