Data and Knowledge Management Vocabulary

Vocabulary flashcards related to data and knowledge management, covering traditional file organization, database approaches, and business intelligence concepts.

Traditional File Organization

Organizing data into specialized files designed for processing by specific application programs.

Data Redundancy

Duplicate data in multiple data files, leading to wasted storage space.

Data Inconsistency

Different values for the same attribute across multiple data locations.

Program-Data Dependence

The close relationship between data stored in files and the software programs that update and maintain that data. Any change in the data requires a change in the programs associated with that data.

Database Approach

An approach where related data is stored in one location (database) and can be shared by multiple database management system (DBMS) programs.

Database Management System (DBMS)

Software that serves as an interface between a database and its users or application programs.

Data Warehouse

A database that collects business information from many sources within an enterprise, covering all aspects of the company’s processes, products, and customers, providing a multidimensional view of the data.

Data Mart

A subset of a data warehouse, usually oriented to a specific business line or unit, used to retrieve user-facing data.

Business Intelligence (BI)

A broad category of applications and technologies for gathering, storing, analyzing, and providing access to data sets, helping users make better business decisions.

Online Analytical Processing (OLAP)

Supports multidimensional data analysis, enabling users to view data in different ways using multiple dimensions.

Data Mining

An information analysis tool that involves the automated discovery of patterns and relationships in data warehouses to support decision making.

Character

A basic building block of information, consisting of uppercase letters, lowercase letters, numeric digits or special symbols.

Field

Typically name, number or combination of characters that describes an aspect of a business object or activity.

Record

A collection of related data fields.

File

A collection of related records.

Database

An organized collection of files.