AIS - Chapter 4

AIS - Chapter 4

44 cards   |   Total Attempts: 183
  

Cards In This Set

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