Chapter 5 Data and Knowledge Management

Data Governance

Organization-wide framework for managing information.

Master Data Management (MDM)

 Process to ensure consistency of key business entities.

Database Management System (DBMS)

Software to manage databases, reduces redundancy/inconsistency.

Relational Database

Data stored in tables with rows (records) and columns (attributes).

Primary Key

Unique identifier for a record in a table.

Foreign Key

Field in one table that links to the primary key in another.

Big Data

Data sets too large/complex for traditional databases.

3Vs of Big Data

 Volume, Velocity, Variety.

NoSQL Database

Non-relational databases designed for Big Data.

Data Warehouse

Central repository of historical organizational data.

Data Mart

Smaller, departmental version of a data warehouse.

OLAP (Online Analytical Processing)

 Analytical processing for multidimensional data.

Data Lake

Storage for raw/unstructured Big Data.

Knowledge Management (KM)

Process of capturing and leveraging organizational knowledge.

Explicit Knowledge

Formal, codified knowledge (manuals, reports).

Tacit Knowledge

Informal, experiential knowledge.

Knowledge Management System (KMS)

 IT-based system to manage organizational knowledge.

Normalization

Structuring databases to reduce redundancy.

Entity-Relationship (ER) Diagram

Visual model of database structure.

SQL (Structured Query Language)

Standard language for querying relational databases.

Join

Operation to merge related tables in a database