
A factory can collect enormous amounts of data and still struggle to answer a basic operational question: what does this event actually affect?ERP knows customer orders, materials, planned dates, and inventory. MES knows what is executing on the shop floor. PLCs and SCADA know machine states, alarms, and process values. Maintenance knows asset condition and service history. Quality knows inspection and release status. Engineering knows the product definition. The problem is not usually a lack of data. The problem is that these systems describe the same factory through different names, IDs, states, and rules.An industrial data model creates shared meaning across those boundaries. It defines the factory objects that matter, gives them stable identity, and describes how products, processes, resources, orders, materials, people, tools, quality records, and machine events relate to each other. The goal is not to replace ERP, MES, maintenance, or other source systems. The goal is to make their information understandable as one connected production context. PLENTY OF SYSTEMS — NO SHARED MEANINGA modern plant already has specialized systems for almost every important job. ERP manages demand and commitments. MES manages execution. PLCs control equipment. SCADA presents machine conditions. Historians store process data. Maintenance systems manage assets and service work. Quality systems maintain inspection records, and Power BI can combine information for reporting.Each system exists for a reason. The problem begins when the same real-world object appears differently in every one of them. A machine may be represented as a work center in ERP, an asset number in maintenance, a resource in MES, a group of OPC UA nodes in the control system, and a completely different friendly name on the shop floor.An industrial model does not force all of those systems to use one identifier. Instead, it records how those references relate to the same physical or logical object. That gives the factory a stable identity layer without destroying the local structures each source system needs.WHAT AN INDUSTRIAL DATA MODEL ACTUALLY ISAn industrial data model is a shared set of rules describing what matters in the factory and how those things connect.It answers practical questions such as what counts as a production order, what a product revision represents, how a work center differs from a physical asset, when material is released, and what it actually means for a machine to be available.The model can describe:• Object types and identities• Properties and states• Relationships between factory objects• Source-system references• Effective dates and versions• Conditions attached to relationships• Ownership of definitions and rulesThis lets several systems describe different aspects of the same production situation without collapsing them into one misleading status. An order can be released in ERP while its current MES operation remains blocked. A machine can be mechanically healthy while still unavailable because the required fixture is missing. Those facts can all be true at the same time.THE MODEL IS NOT THE DATA PLATFORMMicrosoft Fabric, SQL databases, historians, data lakes, and other platforms are useful for storing, moving, governing, and analyzing information. But none of them can determine what a work center means in your factory simply because the records are stored together.You can load ERP orders, MES execution records, maintenance events, quality results, and machine telemetry into one Lakehouse and still be unable to answer whether a particular order can move to another machine before the end of the shift.That answer depends on relationships.Which product revision is involved? Which operation must run next? Which resources are approved for that operation? Which tooling is required? Is the operator qualified? Does the current machine state allow the work? Is an inspection rule attached to the alternate route?The platform can host and query those relationships, but the factory still has to define them. WHY TABLES ALONE OFTEN BECOME DIFFICULTRelational tables are not the problem. ERP, MES, maintenance, and many manufacturing applications depend on relational models because they are excellent for transactions and structured records.The difficulty appears when production questions cross many relationships that change over time.A product revision may require several operations. An operation may be approved on multiple resources. One machine may support only certain product versions, tooling combinations, size ranges, or inspection requirements. Operator qualifications may expire. Engineering changes may invalidate a previously approved route.All of this can be represented i
Podzilla Summary coming soon
Sign up to get notified when the full AI-powered summary is ready.
Free forever for up to 3 podcasts. No credit card required.

How Machine Data Reaches Microsoft Fabric - From OPC UA to Real-Time Analytics

Connectivity Is Not Integration — Why Your Connected Factory Still Can't Answer the Right Questions

Why Continuous Improvement Needs Better Data

IoT Hub Message Routing vs Event Grid — Why Telemetry and Events Are Not the Same Problem
Free AI-powered recaps of M365.FM a Microsoft MVP Podcast by Mirko Peters and your other favorite podcasts, delivered to your inbox.
Free forever for up to 3 podcasts. No credit card required.