ITEC39 Flashcards
It is a collective information that gives you the ability to make effective, important, and strategic business decisions.
Business Intelligence
It is the science of fact-based decision making.
Analytics
OLTP stands for?
Online Transaction Processing
OLAP stands for?
Online Analytical Processing
It is the collection of information that you organize and access according to the logical structure of the information.
Database
The series of logically related two-dimensional tables or files for storing information.
Relational Database
The field (or group of fields) that uniquely describes each record.
Primary Key
The primary key of one file that appears in another file.
Foreign Key
It helps you specify the logical requirements for a database and access and use the information in a database
Database Management System (DBMS)
5 Components of DBMS
- DBMS engine
- Data definition subsystem
- Data manipulation subsystem
- Application generation subsystem
- Data administration subsystem
It is the collection of information
(from many places) that supports business analysis activities and decision making.
Data Warehouse
Analytics Life Cycle
- Gather analytics needs
- Find the data
- ETL
- Mine the data
The subset of a data warehouse in
which only a focused portion of the data warehouse information is kept.
Data Mart
Decision and Decisions Support
- Intelligence
- Design
- Choice
- Implementation
A highly flexible and interactive system that is designed to support decision making when the problem is not structured.
Decisions Support System (DSS)