Front | Back |
What is a set of interrelated, centrally coordinated files?
|
Database
|
What is the interface between the database and the various application programs?
|
Database Management System (DBMS)
|
Who is responsible for the database?
|
Database Administrator (DBA)
|
What contains both detailed and summarized data for a number of years and is used for analysis rather than transaction processing?
|
Data Warehouse
|
What is using a data warehouse for strategic decision making often referred to as?
|
Business Intelligence
|
One type of business intelligence which uses queries to guide the investigation of hypothesized relationships in data is called?
|
Online Analytic Processing (OLAP)
|
This technique is the method of using sophisticated statistical analysis, including artificial intelligence techniques such as neural networks, to "discover" unhypothesized relationships in the data.
|
Data Mining
|
The location and length of the fields needed
|
Record Layout
|
This is how people conceptually organize and understand the data.
|
Logical View
|
This is how and where data are physically arranged and stored in the computer system.
|
Physical View
|
This describes the logical structure of a database.
|
Schema
|
This is the organization wide view of the entire database, it lists all the data elements and the relationship amongst them.
|
Conceptual-Level Schema
|
This consists of the individual user views of portions of the database, each of which is referred to as a subschema.
|
External-Level Schema
|
These are individual user views of portions of the database.
|
Sub-schema
|
This is a low-level view of the database, it describes how the data are stored and accessed, including record layouts, definitions, addresses, and indexes.
|
Internal-Level Schema
|