Flashcards in Chapter 6: Foundations of Business Intelligence: Databases and Information Management Deck (48)
Preconfigured hardware-software system that is specifically designed high-speed analysis of large datasets.
A piece of information describing a particular entity.
Datasets with volumes so huge that they are beyond the ability of typical relational DBMS to capture, store, and analyze. The data are often unstructured or semi-structured.
A binary digit representing the smallest unit of data in a computer system. It can only have one of two states, representing 1 or 2..
A string of bits, usually eight, used to store one number or character in a computer system.
A special organizational function for managing the organization's data resources, concerned with information policy, data planning, maintenance of data dictionaries, and data quality standards.
Activities for detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant. Also known as data scrubbing.
DBMS capability that specifies the structure and content of the database.
An automated or manual tool for storing and organizing information about the data maintained in a database.
Policies and processes for managing the availability, usability, integrity, and security of the firm's data.
The presence of different values for same attribute when the same data are stored in multiple locations.
Data Manipulation Language
A language associated with a database management system that end users and programmers use to manipulate data in the database.
A small data warehouse containing only a portion of the organization's data for a specified function or population of users.
Analysis of large pools of data to find patterns and rules that can be used to guide decision making decision making and predict future behavior.
Data Quality Audit
A survey and/or sample of files to determine accuracy and completeness of data in an information system.
The presence of duplicate data in multiple data files.
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.
A group of related files.
OR A collection of data organized to service many applications at the same time by storing and managing data so that they appear to be in one location.
Refers to the more technical and operational aspects of managing data, including physical database design and maintenance.
Database Management System (DBMS)
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.
A computer in a client/server environment that is responsible for running a DBMS to process SQL statements and perform database management tasks.
A person, place, thing, or event about which information must be kept.
A methodology for documenting databases illustrating the relationship between various entities in the database.
A grouping of characters into a word, a group of words, or a complete number, such as a person's name or age.
A group of records of the same type.
Field in a database table that enables users find related information in another database table.
Open-source software framework that enables distributed parallel processing of huge amounts of data across many inexpensive computers.
Technology for very rapid analysis and processing of large quantities of data by storing the data in the computer's main memory rather than in secondary storage.
Formal rules governing the maintenance, distribution, and use of information in an organization.