ITEC39_MIDTERM Flashcards
collective information that gives you the ability to make effective, important, and strategic business decisions
Business intelligence
the science of fact-based decision making
Analytics
information used in decision making
Data Warehouse
collection of information that you organize and access according to the logical structure of the information
Database
series of logically related two-dimensional tables or files for storing information
Relational database
= table = file
Relation
Most popular database model
Relational database model
field (or group of fields) that uniquely describes each record
Primary Key
primary key of one file that appears in another file
Foreign Key
helps you specify the logical requirements for a database and access and use the information in a database
Database management system (DBMS)
Help you build and work with BI and some forms of knowledge
DATA WAREHOUSES AND DATA MINING
collection of information (from many places) that supports business analysis activities and decision making
Data Warehouse
subset of a data warehouse in which only a focused portion of the data warehouse information is kept
Data Mart
Information is a resource you must manage and organize to help the organization meet its goals and objectives
Information Ownership
a highly flexible and interactive system that is designed to support decision making when the problem is not structured
Decision support system
help you analyze, but you must know how to solve the problem, and how to use the results of the analysis
Decision support systems
DSS designed specifically to analyze spatial information
Geographic information system
Spatial information is any information in map form
Geographic information system
what software use to analyze information, generate business intelligence, and make decisions
GIS