RTQP Engine Data Model

Document created by kduffy on Nov 13, 2018Last modified by jkim on Nov 22, 2018
Version 3Show Document
  • View in full screen mode

A diagram of the RTQP Engine's data model is attached to this document.

  • On a machine with the PI SQL Client installed, the jpg is found in %pihome64%SQL\SQL Commander\PI SQL Query Compendium\PI SQL Client"


The data model shows the table relations within the Master catalog. This is particularly useful for this schema as the RTQP Engine is a denormalized model, and there are columns present in certain tables that you may not be expecting to be there. Data model diagrams are also a useful tool for query development, so we've released the document if you prefer to use it over the query compendium or object explorer.

1 person found this helpful