Term
| Application generation subsystem (of a DBMS)(4/5) |
|
Definition
| contains facilities to help you develop transaction-intensive applications |
|
|
Term
|
Definition
| is simply a copy of the information stored on a computer |
|
|
Term
| business intelligence (BI) |
|
Definition
|
|
Term
| competitive intelligence (CI) |
|
Definition
| is BI focused on the external competitive environment |
|
|
Term
|
Definition
| is the function in an organization that plans for, oversees the development of, and monitors the information resource |
|
|
Term
| data administration subsystem (of a DBMS)(5/5) |
|
Definition
| helps you manage the overall database environment by providing facilities for backup and recovery, security management, query optimization, concurrency control, and change management |
|
|
Term
|
Definition
| is a collection of information that you organize and access according to the logical structure of that information |
|
|
Term
|
Definition
| is the function in an organization that is responsible for the more technical and operational aspects of managing info contained in organizational information repositories |
|
|
Term
| database management system (DBMS) |
|
Definition
| helps you specify the logical organization for a database and access and use the information within a database |
|
|
Term
| data definition subsystem (of a DBMS)(2/5) |
|
Definition
| helps you create and maintain the data dictionary and define the structure of the files in a database |
|
|
Term
|
Definition
| contains the logical structure for the information in a database |
|
|
Term
| data manipulation subsystem (of a DBMS)(3/5) |
|
Definition
| helps you add, change, and delete information in a database and query it for valuable information |
|
|
Term
|
Definition
| is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept |
|
|
Term
|
Definition
| are the software tools you use to query information in a data ware-house |
|
|
Term
|
Definition
| is a logical collection of information, gathered from many different operational databases, used to create BI that supports business analysis activities and decision-making tasks. |
|
|
Term
|
Definition
| accepts logical requests from the various other DBMS subsystems, converts them into their physical equivalents and actually accesses the database and data dictionary as they exist on a storage device |
|
|
Term
|
Definition
| a feature of BI software packages that displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker |
|
|
Term
|
Definition
| is a primary key of one file that appears in another file. They are essential in the relational database model |
|
|
Term
|
Definition
| rules that help ensure the quality of the information |
|
|
Term
|
Definition
| focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs |
|
|
Term
| multidimensional analysis (MDA) tool |
|
Definition
| are slice-and-dice techniques that allow you to view multidimensional information from different perspectives. |
|
|
Term
| Online analytical processing (OLAP) |
|
Definition
| is the manipulation of information to support decision making. |
|
|
Term
| Online transaction processing (OLTP) |
|
Definition
| is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information |
|
|
Term
|
Definition
| databases that support OLTP |
|
|
Term
|
Definition
| deals with how information is physically arranged, stored, and accessed on some type of storage device such as a floppy disk |
|
|
Term
|
Definition
| is a field that uniquely describes each record |
|
|
Term
|
Definition
| are similar to QBE tools, SQL, and report generators in the most typical database environment |
|
|
Term
| query-by-example tool (QBE) |
|
Definition
| help you graphically design the answer to a question. (point and click) |
|
|
Term
|
Definition
| is the process of reinstalling the backup information in the event that the information is lost |
|
|
Term
|
Definition
| often describes each two-dimensional table or file in the relational model |
|
|
Term
|
Definition
| it uses a series of logically related two-dimensional tables or files to store information in the form of a database. Essentially a huge spreadsheet of information |
|
|
Term
|
Definition
| helps you quickly define formats of reports and what info you want to see in a report |
|
|
Term
| structured query language (SQL) |
|
Definition
| is a standardized fourth-generation query language found in most DBMSs. It works like a sentence (Select...From...Where...) |
|
|
Term
|
Definition
| allows you to see the contents of a database file, make whatever changes you want, perform simple sorting, and query to find specific information |
|
|
