(See related pages)
|
|
|
| Data Dictionary | A software module and database containing descriptions and definitions concerning the structure, data elements, interrelationships, and other characteristics of a database. |
| |
| |
| |
| Data Mining | Using special purpose software to analyze data from a data warehouse to find hidden patterns and trends. |
| |
| |
| |
| Data Modeling | A process in which the relationships between data elements are identified and defined to develop data models. |
| |
| |
| |
| Data Resource Management | A managerial activity that applies information systems technology and management tools to the task of managing an organization’s data resources. Its three major components are database administration, data administration, and data planning. |
| |
| |
| |
| Database Administrator | A specialist responsible for maintaining standards for the development, maintenance, and security of an organization’s databases. |
| |
| |
| |
| Database Management Approach | An approach to the storage and processing of data in which independent files are consolidated into a common pool, or database, of records available to different application programs and end users for processing and data retrieval. |
| |
| |
| |
| Database Management System (DBMS) | A set of computer programs that controls the creation, maintenance, and utilization of the databases of an organization. |
| |
| |
| |
| File Processing | Organizing data into specialized files of data records designed for processing only by specific application programs. Contrast with Database Management Approach. |
| |
| |
| |
| Logical Data Elements | Data elements that are independent of the physical data media on which they are recorded. Field: A data element that consists of a grouping of characters that describe a particular attribute of an entity. For example, the name field or salary field of an employee. Record: A collection of related data fields treated as a unit. File: A collection of related data records treated as a unit. Sometimes called a data set. Database: An integrated collection of logically related data elements. A database consolidates many records previously stored in separate files so that a common pool of data serves many applications. |
| |
| |
| |
| Metadata | Data about data; data describing the structure, data elements, interrelationships, and other characteristics of a database. |
| |
| |
| |
| Structured Query Language (SQL) | A query language that is becoming a standard for advanced database management system packages. A query’s basic form is SELECT ... FROM ... WHERE. |
| |
| |
| |
| Types of databases | Data Warehouse: An integrated collection of data extracted from operational, historical, and external databases and cleaned, transformed, and cataloged for retrieval and analysis ( data mining ) to provide business intelligence for business decision making. Distributed Databases: The concept of distributing databases or portions of a database at remote sites where the data are most frequently referenced. Sharing of data is made possible through a network that interconnects the distributed databases. Hypermedia: Documents containing multiple forms of media, including text, graphics, video, and sound, that can be interactively searched, like Hypertext. |