Asset Information Model With Dual Object and Table Representation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing industrial information models treat objects and data inconsistently, with objects lacking full object-oriented behavior and tabular data not easily queryable, leading to inefficiencies in data collection and output.
Innovation Solution
A method is implemented that creates an assets model with classes and relations, automatically generating assets collections and objects, allowing dual representation of assets as both tabular and object-oriented data, ensuring consistency and efficient data handling.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If objects are treated as first-class citizens in industrial information models, then object-oriented behavior and manipulation are improved, but data becomes difficult to query and manipulate using relational methods
Solution Approach 1:
The patent merges object-oriented data structures with relational database capabilities by implementing object-relational mapping that allows objects to be persisted in relational databases while maintaining their object-oriented properties and behaviors, enabling both object-oriented manipulation and relational querying simultaneously
Solution Approach 2:
The patent introduces an object-relational mapping layer as an intermediary between the object-oriented application layer and the relational database layer, translating between object structures and relational tables to enable both object-oriented operations and SQL querying without compromise
2Ease of operation
If tabular data are made to appear as objects in visualization applications, then ease of visualization is improved, but fundamental object characteristics like granular security and live data updates are lost
Solution Approach 1:
The patent creates persistent object copies that can be visualized in applications while maintaining links to the original object data in the database, allowing visualization of objects with full object characteristics including security and live updates without compromising the underlying data integrity
3Adaptability or versatility
If objects and data are stored redundantly and accessed in incompatible ways, then data representation flexibility is improved, but system complexity and inconsistency increase
Solution Approach 1:
The patent implements a universal object model that can represent multiple types of industrial data (process data, asset data, maintenance data) in a unified object structure, allowing the same system to handle diverse data types without redundant storage or incompatible access methods
Data Source
Figure 1
Figure 2
Figure 3
AI summary
The invention relates to a method for generating an information model for the collection and output of asset data originating from multiple data sources, the method comprising: - creating an assets model (1) being a class system with several classes (2, 3, 4) and relations between classes (2, 3, 4), - automatically creating assets collections (5, 6) from the assets model (1), and - automatically creating objects (9) for the assets, wherein the assets are on one hand represented as rows (7) in the assets collections (5, 6) and on the other hand as a hierarchy of matching asset objects (9). Furthermore, the invention relates to a computer program and a computer-readable medium