Chapter 6: Foundations of Business Intelligence: Databases and Information Management Flashcards Preview

Computer Information Systems 5620 > Chapter 6: Foundations of Business Intelligence: Databases and Information Management > Flashcards

Flashcards in Chapter 6: Foundations of Business Intelligence: Databases and Information Management Deck (48)
Loading flashcards...
1

Analytic Platform

Preconfigured hardware-software system that is specifically designed high-speed analysis of large datasets.

2

Attribute

A piece of information describing a particular entity.

3

Big Data

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.

4

Bit

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..

5

Byte

A string of bits, usually eight, used to store one number or character in a computer system.

6

Data Administration

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.

7

Data Cleansing

Activities for detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant. Also known as data scrubbing.

8

Data Definition

DBMS capability that specifies the structure and content of the database.

9

Data Dictionary

An automated or manual tool for storing and organizing information about the data maintained in a database.

10

Data Governance

Policies and processes for managing the availability, usability, integrity, and security of the firm's data.

11

Data Inconsistency

The presence of different values for same attribute when the same data are stored in multiple locations.

12

Data Manipulation Language

A language associated with a database management system that end users and programmers use to manipulate data in the database.

13

Data Mart

A small data warehouse containing only a portion of the organization's data for a specified function or population of users.

14

Data Mining

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.

15

Data Quality Audit

A survey and/or sample of files to determine accuracy and completeness of data in an information system.

16

Data Redundancy

The presence of duplicate data in multiple data files.

17

Data Warehouse

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.

18

Database

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.

19

Database Administration

Refers to the more technical and operational aspects of managing data, including physical database design and maintenance.

20

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.

21

Database Server

A computer in a client/server environment that is responsible for running a DBMS to process SQL statements and perform database management tasks.

22

Entity

A person, place, thing, or event about which information must be kept.

23

Entity-Relationship Diagram

A methodology for documenting databases illustrating the relationship between various entities in the database.

24

Field

A grouping of characters into a word, a group of words, or a complete number, such as a person's name or age.

25

File

A group of records of the same type.

26

Foreign Key

Field in a database table that enables users find related information in another database table.

27

Hadoop

Open-source software framework that enables distributed parallel processing of huge amounts of data across many inexpensive computers.

28

In-Memory Computing

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.

29

Information Policy

Formal rules governing the maintenance, distribution, and use of information in an organization.

30

Key Field

A field in a record that uniquely identifies instances of that record so that it can be retrieved, updated, or sorted.