Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

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.
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.
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.
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.