Term
|
Definition
| Pieces of information describing a particular entity |
|
|
Term
|
Definition
| a special organizational function for managing the organizations's data resources, concerned with information policy, data planning, maintenance of data dictionaries, and data quality standards. |
|
|
Term
|
Definition
| Activities for detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant. AKA data scrubbing. |
|
|
Term
|
Definition
| Specifies the structure of the content of a database. |
|
|
Term
|
Definition
| An automated or manual tool for storing and organizing information about the data maintained in a database. |
|
|
Term
| Data manipulation language |
|
Definition
| a language associated with a database management system that end users and programmers use to manipulate data in the database. |
|
|
Term
|
Definition
| a small data warehouse containing only a potion of the organization's data for a specified function or population of users. |
|
|
Term
|
Definition
| analysis of large pools of data to find patterns and rules that can be used to guide decision making and predict future behavior. |
|
|
Term
|
Definition
| a survey and/or sample of files to determine accuracy and completeness of data in an information system. |
|
|
Term
|
Definition
| a database, with reporting and query tools, that stores current and historical data extracted from various operational systems and consolidated for management reporting and analysis. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| refers to the more technical and operational aspects of managing data, including physical database design and maintenance. |
|
|
Term
| Database management system (DBMS) |
|
Definition
| special software to create and maintain a database and enable individual business applications to extract the data they need without having to create separate files or data definitions in their computer programs. |
|
|
Term
|
Definition
| A computer in a client/server environment that is responsible for running a DBMS to process SQL statements and perform database management tasks. |
|
|
Term
|
Definition
| a person, place, thing, or event about which information must be kept. |
|
|
Term
| Entity-relationship diagram |
|
Definition
| a methodology for documenting databases illustration the relationship between various entities in the database. |
|
|
Term
|
Definition
| a grouping of characters into a word, a group of words, or a complete number, such as a person's name or age. |
|
|
Term
|
Definition
| field in a database table that enables users to find related information in another database table. |
|
|
Term
|
Definition
| formal rules governing the maintenance, distribution, and use of information in an organization. |
|
|
Term
|
Definition
| a field in a record that uniquely identifies instances of that record so that it can be retrieved, updated, or sorted. |
|
|
Term
|
Definition
| the process of creating small stable data structures from complex groups of data when designing a relational database. |
|
|
Term
|
Definition
| an approach to data management that stores both data and the procedures acting on the data as objects that can be automatically retrieved and shared; the objects can contain multimedia. |
|
|
Term
|
Definition
| a database management system that combines the capabilities of a relational DBMS for storing traditional information and the capabilities of an object-oriented DBMS for storing graphics and multimedia. |
|
|
Term
| Online analytical processing (OLAP) |
|
Definition
| capability for manipulating and analyzing large volumes of data from multiple perspectives. |
|
|
Term
|
Definition
| use of datamining techniques, historical data, and assumptions about future conditions to predict outcomes of events. |
|
|
Term
|
Definition
| Unique identifier for all the information in any row of a database table. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| rules to ensure that relationships between coupled database tables remain consistent |
|
|
Term
|
Definition
| a type of logical database model that treats data as if they were stored in two-dimensional tables. It can relate data stored in one table to data in another as long as the two tables share a common data element. |
|
|
Term
| Structured Query language (SQL) |
|
Definition
| the standard data manipulation language for relational database management systems. |
|
|
Term
|
Definition
| discovery of patterns and relationships from large sets of unstructured data. |
|
|
Term
|
Definition
| rows or records in a relational database. |
|
|
Term
|
Definition
| discovery and analysis of useful patterns and information from the World Wide Web. |
|
|
