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