(See related pages)
|
|
|
| Application generation subsystem | Contains facilities to help you develop transaction-intensive applications. (See page(s) 133) |
| |
| |
| |
| Business intelligence | Knowledge – knowledge about your customers, your competitors, your partners, your competitive environment, and your own internal operations. Business intelligence comes from information. (See page(s) 120) |
| |
| |
| |
| Chief information officer (CIO) | Responsibility for overseeing an organization’s information resources. (See page(s) 143) |
| |
| |
| |
| 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. (See page(s) 133) |
| |
| |
| |
| Data administration | The function in an organization that plans for, oversees the development of, and monitors the information resources. (See page(s) 143) |
| |
| |
| |
| Data definition subsystem | Helps you create and maintain the data dictionary and define the structure of the files in a database. (See page(s) 127) |
| |
| |
| |
| Data dictionary | Contains the logical structure of the information. (See page(s) 122) |
| |
| |
| |
| Data manipulation subsystem | Helps you add, change, and delete information in a database and mine it for valuable information. (See page(s) 128) |
| |
| |
| |
| Data mart | Subset of a data warehouse in which only a focused portion of the data warehouse information is kept. (See page(s) 139) |
| |
| |
| |
| Data mining tool | Software tool you use to query information in a data warehouse. (See page(s) 137) |
| |
| |
| |
| 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. (See page(s) 136) |
| |
| |
| |
| Database | A collection of information that your organize and access according to the logical structure of that information. (See page(s) 122) |
| |
| |
| |
| Database administration | The function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational database (which can include data warehouses and data marts). (See page(s) 143) |
| |
| |
| |
| Database management system (DBMS) | Helps you specify the logical organization for a database and access and use the information within the database. (See page(s) 125) |
| |
| |
| |
| 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. (See page(s) 126) |
| |
| |
| |
| Foreign key | A primary key of one file (relation) that appears in another file (relation). (See page(s) 124) |
| |
| |
| |
| Integrity constraint | Rules that help ensure the quality of the information. (See page(s) 124) |
| |
| |
| |
| Logical view | Focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs. (See page(s) 126) |
| |
| |
| |
| Multidimensional analysis (MDA) tool | Slice-and-dice techniques that allow you to view multidimensional information from different perspectives. (See page(s) 138) |
| |
| |
| |
| Online analytical processing (OLAP) | The manipulation of information to support decision making. (See page(s) 121) |
| |
| |
| |
| Online transaction processing (OLTP) | The gathering of input information, processing that information, and updating existing information to reflect the gathered and processing information. (See page(s) 120) |
| |
| |
| |
| Operational database | A database that supports OLP. (See page(s) 120) |
| |
| |
| |
| Physical view | Deals with how information is physically arranged, stored, and accessed on some type of storage device such as a hard disk. (See page(s) 126) |
| |
| |
| |
| Primary key | A field (or group of fields in some cases) that uniquely describes each record. (See page(s) 124) |
| |
| |
| |
| Query-and-reporting tool | Similar to QBE tools, SQL, and report generators in the typical database environment. (See page(s) 137) |
| |
| |
| |
| Query-by-example (QBE) tool | Helps you graphically design the answer to a question. (See page(s) 131) |
| |
| |
| |
| Relation | Describes each two-dimensional table or file in the relational model (hence its name relational database model). (See page(s) 122) |
| |
| |
| |
| Relational database model | Uses a series of logically related two-dimensional tables or files to store information in the form of a database. (See page(s) 122) |
| |
| |
| |
| Report generator | Helps you quickly define formats of reports and what information you want to see in a report. (See page(s) 129) |
| |
| |
| |
| Structured query language (SQL) | A standardized fourth-generation query language found in most DBMS. (See page(s) 132) |
| |
| |
| |
| 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. (See page(s) 128) |