Term
| Relational Database Advantages |
|
Definition
- Flexibility
- Scalability/Performance
- Reduce Redundancy
- Increase Security
- Integrity (quality of the info) |
|
|
Term
|
Definition
| one physical view, many logical views |
|
|
Term
|
Definition
| how well a system can adapt to increased demands |
|
|
Term
| How to increase info integrity |
|
Definition
| add integrity constraints |
|
|
Term
|
Definition
| Database management system - software through which users and application programs interact with a database. the user sends requests and the DBMS performs the actual manipulation of the information in the database. |
|
|
Term
| Relational integrity constraints |
|
Definition
| enforces basic and fundamental info; avoids fraud by not allowing things like orders without customers etc. |
|
|
Term
| Business-critical integrity constraints |
|
Definition
| enforces individual constraints based on a certain business; requires insight/knowledge |
|
|
Term
|
Definition
| Allows separate systems to communicate directly with each other |
|
|
Term
|
Definition
| takes info entered into a given system and sends it automatically to all downstream systems and processes |
|
|
Term
|
Definition
| takes info entered into a given system and sends it automatically to all upstream systems and processes. |
|
|
Term
| How is data integrated into multiple databases? |
|
Definition
| by making connections between the databases |
|
|
Term
|
Definition
| Decision Support System - models information to support managers and business professionals during the decision-making process. Three quantitative models are typicalled used by DSSs: sensitivity analysis, what-if analysis, goal-seeking analysis |
|
|
Term
|
Definition
| Transaction Support Systems - get data straight from the source. |
|
|
Term
|
Definition
| Executive Information Systems - a specialized DSS that supports senior-level executives; contains info from internal and external sources; Three capabilities: consolidation, drill-down, slice-and-dice |
|
|
Term
|
Definition
| the study of the impact that changes–in one or more parts of the model. |
|
|
Term
|
Definition
| checks the impact of a change in an assumption on the proposed solution. |
|
|
Term
|
Definition
| find the inputs necessary to achieve a goal such as a desired level of output. You set a target value and figure out how you can reach it. |
|
|
Term
| 4 types of AIS (Artificial Intelligence Systems) |
|
Definition
1. Expert Systems
2. Neural Networks
3. Genetic Algorithms
4. Intelligent Agents |
|
|
Term
|
Definition
| Computerized advisory programs that imitate the reasoning processes of experts in solving difficult problems; uses accumulated experience and a set of rules for applying the knowledge base to each particular situation |
|
|
Term
|
Definition
| Emulates the way the human brain works; most useful for things that involve pattern or image recognition |
|
|
Term
|
Definition
| Mimics the evolutionary, survival-of-the-fittest process to generate increasingly better situations to a problem. It finds the combination of inputs to yield the best outputs; best for when many solutions are possible. |
|
|
Term
|
Definition
| Accomplishes specific tasks on behalf of its users; finds data by looking in many places for you. |
|
|
Term
| Three Data Mining analysis capabilities |
|
Definition
1. instantly sift through large amounts of info
2. uncover patterns and relationships
3. find trends |
|
|
Term
|
Definition
Extraction, Transformation, Loading
- Extraction: gets info from internal/external databases
- Transformation: makes the data useable
- Loading: puts the info into a warehouse |
|
|
Term
|
Definition
| A way to present multi-dimensional information from a data warehouse. (layers, rows, columns) allows you to pinpoint certain aspects. |
|
|
Term
|
Definition
| Used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible. |
|
|
Term
| Characteristics of Ideal Measures |
|
Definition
1. Simple
2. Precisely Definable
3. Objective
4. Valid
5. Robust
6. Easily obtainable |
|
|
Term
|
Definition
| Measures should be easy to understand |
|
|
Term
|
Definition
| Ease of Collection; Ease of Calculation |
|
|
Term
|
Definition
| measures should be clearly defined so that they can be applied and evaluated consistently; organizations need to establish and adhere to specific rules when collecting measures and ensure that these rules are being followed so that the integrity of the data is maintained. |
|
|
Term
| Objective (Ideal Measure) |
|
Definition
| two or more qualified observers should arrive at the same value for the measure |
|
|
Term
|
Definition
| should measure the property it is intended to measure |
|
|
Term
|
Definition
| Measures should be insensitive to insignificant changes in the process or product. |
|
|
Term
|
Definition
| Customer Relationship Management - strategy for managing customer relations; focuses on marketing, customer service, and technical support. |
|
|
Term
|
Definition
| Recency, Frequency, Monetary Value (how much the customer spends) |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| predict what customers will do in the future |
|
|
Term
| Three phases of CRM evolution |
|
Definition
| reporting, analyzing, predicting |
|
|
Term
|
Definition
| used for day-to-day/front-office information that deals directly with the customers |
|
|
Term
|
Definition
| supports back-office and strategic analysis; doesn't deal with customers. |
|
|
Term
|
Definition
- understand customer behavior/preferences
- realigning product/service offerings to make sure they're in line with customer's wants |
|
|
