Data Management Overview

These flashcards cover key concepts related to data management including data governance, types of data, database management systems, big data characteristics, and data science techniques.

Data Governance

An approach to managing information across an entire organization, involving processes to ensure data is handled in a transparent and useful way.

Data Redundancy

Occurs when information systems do not communicate, leading to duplicate data being stored across different locations.

Data Integrity

Ensures that data meets certain constraints and remains accurate and reliable.

Master Data Management (MDM)

A strategy for maintaining a consistent, accurate set of data across all business processes and applications.

Transactional Data

Operational data pertaining to business activities or transactions, such as entries in a student database.

Database Management System (DBMS)

A set of programs that provide tools to add, delete, access, and analyze data stored in one location.

SQL (Structured Query Language)

A programming language used to perform operations on databases, allowing users to query and retrieve data.

Data Modeling

The process of creating a visual representation of a data system to organize and manage similar data.

Primary Key (PK)

An identifier that uniquely specifies a particular record within a database table.

Foreign Key (FK)

An attribute that can identify a record in a related table but does not uniquely identify a record in its own table.

Big Data Characteristics

Defined by its volume, velocity, and variety, which create challenges and opportunities for data management.

NoSQL Databases

Databases designed to process unstructured and structured data, offering flexibility for big data applications.

Entity-Relationship Diagramming

A visual representation of relationships between data entities in a database.

Data Mining

The practice of analyzing large datasets to discover patterns or insights within the data.

Data Visualization

The representation of data in graphical formats to help users understand complex data relationships.

Data Cleaning

The process of correcting or removing incorrect, corrupted, or improperly formatted data.

Predictive Modeling

Using statistical techniques and algorithms to predict future outcomes based on historical data.

Data Security

Measures taken to protect data from unauthorized access or breaches.