Chapter 3 Databases and Data Warehouses Flashcards
OLTP
Online Transaction Processing
is the gathering of input information, processing thta information, and updating existing information to reflect the gathered and processed information.
1 of 2 parts of IT tools for BI
Databases and DBMSs support OLTP
OLAP
Online Analytical Processing
is the manipulation of information to support decision making
OLTP & OLAP
Relational Database Model
- database: is a collection of information that you organize and access according to the logical structure of that information
- relational database: it uses a series of logically related dtwo-dimensional tables or files to store information in the form of a database
composed of:
- 1)the information itself, stored in a series of two-dimensional tables, files and relations
- 2) the logical structure of that information, not its phyiscal position
Integrity Constraints
helps insure the quality of the information
primary keys and foreign keys
relationships between files
Database Management System Tools
DBMS
helps specify the logical organziation for a database and access and use the information within a database
- DBMS engine
- data defintion sybsystem
- data manipulation subsystem
- application generation subsytem
- data adminstration sybsystem
Query by Example
QBE tools
hlep you graphically design the answer to a question
CRUD
- C: reate
- R: ead
- U: pdate
- D: elete
security management facilities
Data Warehouse
- is a logical collection of information, gathered from different operational databases, used to create BI
- their multidimensional
Data-mining tools are the software tools you use to query information in a data warehouse
Digital Dashboards & KPIs
displays informatin gathered from several sources on a computer screnn in a format tailored to the needs and wants of an individual
Key Performance Indicators: the key items of information
Data Mart
a subset of a data warehouse in which only a focused portion of the data warehouse information is kept
