Overview

4 Data integration and management

Data is presented as the lifeblood of a digital twin, making integration and management the foundation for accuracy, trust, and impact. The chapter catalogs the main data types—reference, timeseries, unstructured and semi-structured objects, spatial, and derived data (including features and embeddings)—explaining how each contributes context, behavior, and semantics. It then maps the principal sources: operational technology (SCADA, historians, IIoT), information technology (ERP, finance, BI), and external feeds, emphasizing that coherent combination across these domains turns raw signals into decision-ready intelligence.

To operationalize this, the chapter surveys data structures and pipelines matched to access patterns: relational, columnar, graph, document, and key-value models; ingestion modes spanning batch for historical context, streaming with sliding windows for live signals, and API integrations for on-demand retrieval; and ETL/ELT to cleanse, standardize, and enrich. It addresses the realities of IT/OT convergence—security constraints, air-gapped networks, proprietary protocols—and recommends mirrored data, demilitarized zones, protocol translation, and layered architectures to protect control systems while enabling analytics.

Storage and governance complete the blueprint. The chapter advocates polyglot persistence—timeseries databases for telemetry, analytical warehouses or columnar files for large-scale queries, data lakes/lakehouses for heterogeneous assets, transactional stores for reference data, and specialized systems such as object, graph, vector, and feature stores—combined with lifecycle tiering (hot/warm/cold) to balance performance and cost. Robust governance spans data classification, regulatory compliance, zero-trust access control, and rigorous data quality management. Selection criteria focus on performance, scale, consistency, cost, and integration complexity, illustrated by a practical example that pairs serverless key-value storage for timeseries, object storage for media, and a graph database for relationships in a home digital twin.

Examples of unstructured data stored in my home digital twin, with an image taken by an IoT camera shown to the left, and a device manual on the right.
ch04 f01 biegel
A 3D mesh model of my home that I will use in my digital twin with the coordinates displayed for three sensors I have deployed to measure water usage around the home. Listing 4.2 shows how I can use the coordinates to find objects within five meters of the person.
ch04 f02 biegel
The relationship between a raw data store, derived data in a feature store, and the training and serving of ML models.
ch04 f03 biegel
An example of how higher dimensionality raw data can be converted to a compact format that encodes the similarity in operating parameters between Pump A and C, while showing the difference in Pump B.
ch04 f04 biegel
The Purdue model of IT/OT convergence segments the network into layers with a DMZ acting as a buffer zone between the OT and IT networks.
ch04 f05 biegel
A relational model of a work order showing tables and properties representing entities, and their relationships.
ch04 f06 biegel
A house, its rooms, and their devices modelled as a graph structure.
ch04 f07 biegel
A sliding window of length four over a data stream. As the window slides through time, older readings fall out, and new readings are added.
ch04 f08 biegel
An example lifecycle policy for data stored in Amazon S3 that transitions data to cheaper storage and eventual deletion as it ages.
ch04 f09 biegel

Summary

  • There are a number of different types of data that are found in most digital twins including timeseries, relational, object, spatial, and derived data which includes features and embeddings.
  • Digital twins source data from both internal data stores, and from external sources.
  • Both operational systems and information technology systems within the organization are important sources of data that digital twins leverage, with these traditionally separate systems beginning to converge.
  • There are different strategies digital twins adopt to ingest data including batch-based, streaming, and API-based integrations.
  • There are a range of modern data storage technologies that can be adopted to store the types of data a digital twin uses.
  • Digital twins aggregate data from many sources and governance and management of compliance of this data is an important consideration.

FAQ

What types of data do digital twins handle, and why do they matter?Digital twins typically work with five key data types: reference data (stable asset/configuration context), timeseries data (timestamped operational signals), unstructured and semi-structured data (documents, images, videos, configs), spatial data (2D/3D location and geometry), and derived data (features and embeddings created from raw data). Each plays a distinct role in making the twin accurate, contextual, and useful for analysis and decision-making.
Where does the data for a digital twin come from?Three main domains feed a twin: operational technology (OT) systems such as SCADA/DCS/PLCs and IIoT devices; information technology (IT) systems like ERP, finance, procurement, and BI; and external sources including third-party APIs and open datasets. Together they provide real-time state, business context, and environmental context.
Why is integrating OT data challenging, and how is it typically addressed?OT environments prioritize safety and determinism, often run air-gapped networks, and use proprietary protocols, making direct queries risky and impractical. Common patterns include mirroring/process historians, data diodes or unidirectional gateways, and an industrial DMZ with protocol converters and security gateways, all aligned to the Purdue model to safely bridge OT and IT.
How should I choose among relational, columnar, graph, document, and key-value structures?Use relational models for consistency and flexible ad-hoc queries; columnar layouts for efficient analytics and aggregations; graph structures for traversing rich relationships (assets-locations-dependencies); document stores for flexible, evolving schemas; and key-value stores for predictable, high-throughput lookups and caching. Pick based on access patterns and consistency needs.
When should I use batch, streaming, or API-based ingestion?Batch is ideal for slow-moving enterprise data and historical backfills with complex transforms. Streaming suits live sensor/telemetry where you need rolling aggregates (e.g., sliding windows) and alerts. APIs enable targeted, on-demand collection (REST/GraphQL/gRPC/WebSockets) that can be scheduled or event-driven without constant ingestion.
What is the role of ETL/ELT in a digital twin?ETL/ELT standardizes and enriches data: cleansing, unit conversion, validation, aggregation, and contextual joins (e.g., adding asset metadata). ETL transforms before loading; ELT loads raw data first and transforms in the target system (common with cloud warehouses). Both ensure consistent, analytics-ready data for the twin.
Which storage systems best fit common digital twin workloads?Timeseries databases (e.g., InfluxDB, TimescaleDB, Timestream) optimize temporal writes, compression, aggregations, and time partitioning. Analytical warehouses/lakehouses (e.g., Redshift, BigQuery, Snowflake, Delta/Parquet on object storage) handle large-scale analytics and diverse formats. Transactional stores (relational/NoSQL) manage reference and configuration data. Specialized systems include object storage for media, graph databases for relationships, vector databases for embeddings, and feature stores for ML.
How do I manage data across its lifecycle (hot, warm, cold)?Keep recent “hot” data on fast storage for low-latency decisions and dashboards; move older “warm” data to cost-efficient stores with compression/aggregation for reporting and model training; archive “cold” data to low-cost tiers (e.g., Glacier/Archive) with lifecycle policies, accepting longer retrieval times.
What are the essentials of data governance and compliance for digital twins?Define classification (public, internal, confidential, restricted); meet regulatory obligations (e.g., GDPR, HIPAA, PCI) including minimization, portability, deletion, and audit trails; enforce RBAC/ABAC with zero-trust principles; and implement strong data quality rules, monitoring, and remediation to keep the twin reliable and safe.
What does a practical polyglot storage design look like in practice?A typical design pairs purpose-picked stores: e.g., timeseries in a key-value or timeseries DB (partitioned by sensor and timestamp), object storage for documents and media, a graph DB for relationships, and an analytical layer (warehouse or Parquet/Delta in a lakehouse) for large-scale queries. The home twin example uses DynamoDB for timeseries, S3 for objects/exports, and Memgraph for relationships, trading some specialization for simplicity, scalability, and cost control.

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases
  • renews monthly, pause or cancel renewal anytime

lite $19.99 per month

  • access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more


choose your plan

team

monthly
annual
$49.99
$499.99
only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • renews monthly, pause or cancel renewal anytime
  • renews annually, pause or cancel renewal anytime
  • Digital Twins in Action ebook for free
choose your plan

team

monthly
annual
$49.99
$499.99
only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • renews monthly, pause or cancel renewal anytime
  • renews annually, pause or cancel renewal anytime
  • Digital Twins in Action ebook for free
choose your plan

team

monthly
annual
$49.99
$499.99
only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • renews monthly, pause or cancel renewal anytime
  • renews annually, pause or cancel renewal anytime
  • Digital Twins in Action ebook for free