M-Lecture 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
Two things that both huge in today’s business world.
BI and Analytics
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
Most popular database model
Relation
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)
5 Components of DBMS
- DBMS engine
- Data definition subsystem
- Data manipulation subsystem
- Application generation subsystem
- Data administration subsystem
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
a resource you must manage and organize to help the organization meet its goals and objectives
Information
You need to consider in information:
- Strategic management support
- Sharing information with responsibility
- Information cleanliness
