Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
15 Cards in this Set
- Front
- Back
- 3rd side (hint)
|
Business Intelligence
|
knowledge about your customers, competitors, business partners, environment, and internal operations
|
becci
|
|
|
OLTP
|
gathering and processing transaction information and updating existing information to reflect transaction
- Used for day-to-day activities - Info stored in databases |
|
|
|
OLA
|
Manipulation of information to support decision making
- Support decision making - Summary info |
|
|
|
Databases
|
- Collections of information
- Created with logical structures - With logical ties within the information - With built-in integrity constraints |
|
|
|
Data Dictinary
|
contains the logical structure of the information in a database; documentation of database components
|
|
|
|
Primary Key
|
field that uniquely identifies each record in a table.
|
|
|
|
Foreign Key
|
Primary key in a related table used to link two tables
|
|
|
|
Integrity constraint
|
rule that helps ensure the quality of information; reliability; errors? all infor there?
|
|
|
|
DBMS
|
helps you specify the logical organization for a database and access and use the information within a database
|
|
|
|
DBMS Tools
|
1)DBMS Engine
2)Data Definition Subsystem 3)Data Manipulation Subsystem 4)Application Generation Subsytem 5)Data Administration Subsystem |
EDMAA
|
|
|
DBMS Engine
|
accepts logical requests, converts them into their physical equivalent, and access the database and data dictionary
|
|
|
|
DBMS Engine Physical view
|
how information is arranged, stored, and accessed on a storage device.
|
|
|
|
DBMS Engineligical view
|
how you (knowledge worker) need to arrange and access information
|
|
|
|
Data definition subsytem
|
helps you create and maintain the data dictonary and define the structure of the files in a database
|
|
|
|
Data Manipulation Subsytem
|
helps you add, change, and delete information
- views - reports - QBE tools - SQL |
|
