Data model & Integration

In modern digitalization architectures, Data models and Data service layers play an essential role in serving the data in a transparent way to the data analytics modules, visualization layers and reporting engines. IPCOS has built up extensive experience in designing and implementing data models and data service layers.

IPCOS has developed a reference architecture where data model and data services are central.

IPCOS’ Simplified reference architecture
IPCOS’ Simplified reference architecture

Data Modeling and Data Integration overcomes multiple challenges

  • There is no single version of the truth – data is stored in multiple versions in multiple databases or Excel
  • Engineers need to know the tag IDs of the sensors to retrieve the correct data from the database
  • Engineers lose lots of time manually copying data from one application to another to perform analysis or create reports
  • Adding new equipment to the system is time consuming and requires lots of copy pasting

Best practices

  • Data models represent the structure of the asset in a logical and comprehensible way
  • Data models make use of templates to ensure scalability and maintainability
  • Data is not replicated in the data service layer except if required for performance reasons
  • Data service layers offer interfaces to data analytics, workflow and visualization layers using a secure and performant protocol