Home Solutions Gas Network Management Database

Database model

The database model utilized in our Pipeline Network Management solution offers a solid framework for network billing systems. Actual implementatoins may vary from application to application, and can be easily tailored to specific requirements.


pnm 6

Database object hierarchy

In our database model, entities like:
  • Stations
  • Skids
  • Meter Runs
  • Gas Chromatographs
  • Densitometers
  • Flow Computers

are available under which appertained station data is stored. Reports can be generated from the database using the above entities. For example a report can be generated containing combined data from all stations in the network.

The reports are all defined from within an Excel template system, with embedded MySQL statements and functions, offering a highly flexible and user-friendly environment.


Time-stamped & signatured data

Data stored in the relational database includes:
  • Period totals
  • Period averages
  • Batch totalsmysql
  • Batch averages
  • Snapshot data
  • Periodic averages of transmitter data
  • Parameter changes
  • Events
  • Alarms