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;
30 Cards in this Set
- Front
- Back
Application generation subsystem
|
contains facilities to help you develop transaction-intensive applications.
|
|
Business intelligence
|
knowledge about your customers, your competitors, your partners, your competitive environment, and your own internal operations. Business intelligence comes from information.
|
|
Chief information officer (CIO)
|
responsible for overseeing an organization's information resource.
|
|
Data administration
|
the function in an organization that plans for, oversees the development of, and monitors the information resource.
|
|
Data administration subsystem
|
helps you manage the overall database environment by providing facilities for backup and recovery, security management, query optimization, concurrency control, and change management.
|
|
Database
|
a collection of information that you organize and access according to the logical structure of that information.
|
|
Database administration
|
the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational databases (which can include data warehouses and data marts).
|
|
Database management system (DBMS)
|
helps you specify the logical organization for a database and access and use the information within the database.
|
|
Data definition subsystem
|
helps you create and maintain the data dictionary and define the structure of the files in a database.
|
|
Data dictionary
|
contains the logical structure for the information.
|
|
Data manipulation subsystem
|
helps you add, change, and delete information in a database and mine it for valuable information.
|
|
Data mart
|
subset of a data warehouse in which only a focused portion of the data warehouse information is kept.
|
|
Data-mining tool
|
software tool you use to query information in a data warehouse.
|
|
Data warehouse
|
a logical collection of information-gathered from many different operational databases-used to create business intelligence that supports business analysis activities and decision making tasks.
|
|
DBMS engine
|
accepts logical requests from the various other DBMS subsystems, converts them into their physical equivalent, and actually accesses the database and data dictionary as they exist on a storage device.
|
|
Foreign key
|
a primary key of one file (relation) that appears in another file (relation).
|
|
Integrity constraints
|
rules that help ensure the quality of the information.
|
|
Logical view
|
focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs.
|
|
Multidimensional analysis (MDA) tool
|
slice-and-dice techniques that allow you to view multidimensional information from different perspectives.
|
|
Online analytical processing (OLAP)
|
the manipulation of information to support decision making.
|
|
Online transaction processing (OLTP)
|
the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.
|
|
Operational database
|
a database that supports OLTP.
|
|
Physical view
|
deals with how information is physically arranged, stored, and accessed on some type of storage device such as a hard disk.
|
|
Primary key
|
a field (or group of fields in some cases) that uniquely describes each record.
|
|
Query-and-reporting tools
|
similar to QBE tools, SQL, and report generators in the typical database environment.
|
|
Query-by-example (QBE) tool
|
helps you graphically design the answer to a question.
|
|
Relation
|
describes each two-dimensional table or file in the relational model (hence its name relational database model).
|
|
Report generator
|
helps you quickly define formats of reports and what information you want to see in a report.
|
|
Structured query language (SQL)
|
a standardized fourth-generation query language found in most DBMSs.
|
|
View
|
allows you to see the contents of a database file, make whatever changes you want, perform simple sorting, and query to find the location of specific information.
|