ITEC39_Q Flashcards
collective information that gives you the ability to make effective, important, and strategic business decisions
Business intelligence ( BI )
the science of fact-based decision making
Analytics
OLTP stands for ?
Online transaction processing ( OLTP )
OLAP stands for?
Online analytical processing ( OLAP )
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
what is 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
DBMS stands for?
Database management System
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
A data warehouse system has an engine responsible for converting your logical requests into their physical equivalent
DBMS
The analytics life cycle
Gather analytics needs
find the data
ETL
mine the data
Gather analytics needs
- Interview users
- Determine key performance
Find the data
- identify sources _ internally or externally
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
DBMS engine / Data dictionary
Data Definition
Data Manipulation
Application Generation
Data Administrator
Information ( 3 )
Product Database
Advertise Database
Customer Database
Business intelligence
Data Warehouse
