Dagster is now part of PrefectRead the announcement →

Data Engineering Terms Explained

A guide to key terms used in data engineering. Entries with the icon include useful code examples in Python. For installation instructions for the packages used in the examples, visit the packages page. For a complete list of Data Engineering terms all data engineers should know, please check out the terms index.

104Terms

Aggregate

Combine data from multiple sources into a single dataset.

Includes a Python code example

Align

Aligning data can mean one of three things: aligning datasets, meeting business rules, or arranging data elements in memory.

Includes a Python code example

Anomaly Detection

Identify data points or events that deviate significantly from expected patterns or behaviors.

Includes a Python code example

Anonymize

Remove personal or identifying information from data.

Includes a Python code example

Append

Adding or attaching new records or data items to the end of an existing dataset, database table, file, or list.

Includes a Python code example

Archive

Move rarely accessed data to a low-cost, long-term storage solution to reduce costs. Store data for long-term retention and compliance.

AsyncIO

Speed up execution with asynchronous I/O.

Includes a Python code example

Auto-materialize

The automatic execution of computations and the persistence of their results.

Backpressure

A mechanism to handle situations where data is produced faster than it can be consumed.

Includes a Python code example

Backup

Create a copy of data to protect against loss or corruption.

Batch Processing

Process large volumes of data all at once in a single operation or batch.

Includes a Python code example

Categorize

Organizing and classifying data into different categories, groups, or segments.

Includes a Python code example

Checkpointing

Saving the state of a process at certain points so that it can be restarted from that point in case of failure.

Includes a Python code example

Clean or Cleanse

Remove invalid or inconsistent data values, such as empty fields or outliers.

Includes a Python code example

Cluster

Group data points based on similarities or patterns to facilitate analysis and modeling.

Includes a Python code example

Compact

Reducing the size of data while preserving its essential information.

Includes a Python code example

Compress

Reduce the size of data to save storage space and improve processing performance.

Includes a Python code example

Consolidate

Combine multiple datasets into one to create a more comprehensive view of the data.

Includes a Python code example

Cosine Similarity

A measure of similarity between two entities used in text analysis, natural language processing, etc.

Includes a Python code example

Curate

Select, organize, and annotate data to make it more useful for analysis and modeling.

Includes a Python code example

Deduplicate

Identify and remove duplicate records or entries to improve data quality.

Includes a Python code example

De-identify

Remove personally identifiable information (PII) from data to protect privacy and comply with regulations.

Includes a Python code example

Denoise

Remove noise or artifacts from data to improve its accuracy and quality.

Includes a Python code example

Denormalize

Optimize data for faster read access by reducing the number of joins needed to retrieve related data.

Includes a Python code example

Derive

Extracting, transforming, and generating new data from existing datasets.

Includes a Python code example

Deserialize

Deserialization is essentially the reverse process of serialization. See: 'Serialize'.

Dimensionality

Analyzing the number of features or attributes in the data to improve performance.

Includes a Python code example

Discretize

Transform continuous data into discrete categories or bins to simplify analysis.

Includes a Python code example

Downsample

Reduce the amount of data for analysis, storage, or processing.

Includes a Python code example

Encapsulate

The bundling of data with the methods that operate on that data.

Includes a Python code example

Encode

Convert categorical variables into numerical representations for ML algorithms.

Includes a Python code example

Enrich

Enhance data with additional information from external sources.

Includes a Python code example

ETL

Extract, transform, and load data between different systems.

Includes a Python code example

Export

Extract data from a system for use in another system or application.

Extrapolate

Predict values outside a known range, based on the trends or patterns identified within the available data.

Includes a Python code example

Fan-Out

A pipeline design in which one operation is broken into - or results in - many parallel downstream tasks.

Feature Extraction

Identify and extract relevant features from raw data for use in analysis or modeling.

Includes a Python code example

Feature Selection

Identify and select the most relevant and informative features for analysis or modeling.

Includes a Python code example

Filter

Extract a subset of data based on specific criteria or conditions.

Includes a Python code example

Fragment

Break data down into smaller chunks for storage and management purposes.

Includes a Python code example

Geospatial Analysis

Analyze data that has geographic or spatial components to identify patterns and relationships.

Includes a Python code example

Graph Theory

A powerful tool to model and understand intricate relationships within our data systems.

Includes a Python code example

Hash

Convert data into a fixed-length code to improve data security and integrity.

Includes a Python code example

Homogenize

Make data uniform, consistent, and comparable.

Includes a Python code example

Idempotent

An operation that produces the same result each time it is performed.

Includes a Python code example

Impute

Fill in missing data values with estimated or imputed values to facilitate analysis.

Includes a Python code example

Index

Create an optimized data structure for fast search and retrieval.

Includes a Python code example

Ingest

The initial collection and import of data from various sources into your processing environment.

Includes a Python code example

Interpolate

Use known data values to estimate unknown data values.

Includes a Python code example

Lineage

Understand how data moves through a pipeline, including its origin, transformations, dependencies, and ultimate consumption.

Includes a Python code example

Linearizability

Ensure that each individual operation on a distributed system appear to occur instantaneously.

Includes a Python code example

Linearize

Transforming the relationship between variables to make datasets approximately linear.

Includes a Python code example

Mask

Obfuscate sensitive data to protect its privacy and security.

Includes a Python code example

Materialize

Executing a computation and persisting the results into storage.

Includes a Python code example

Memoize

Store the results of expensive function calls and reusing them when the same inputs occur again.

Includes a Python code example

Merge

Combine data from multiple datasets into a single dataset.

Includes a Python code example

Model

Create a conceptual representation of data objects.

Includes a Python code example

Multiprocessing

Optimize execution time with multiple parallel processes.

Includes a Python code example

Munge

See 'wrangle'.

Named Entity Recognition

Locate and classify named entities in text into pre-defined categories.

Includes a Python code example

View the Index

Can’t find what you are looking for? Check the complete Index here

Check Index

Interested in trying Dagster+ for free?

Enterprise orchestration that puts developer experience first.
Serverless or hybrid deployments, native branching, and out-of-
the-box CI/CD.

Start free