iPDC Database Server - Design

When iPDC receives data & configuration frames, it would also direct them to another process called DBServer. DBServer may run on the same machine or a remote machine. This process acts as database server. Among the various known open source databases, MySQL has been used for storing the PMU/iPDC data. The process would have a parser to parse con guration and data frames. After parsing, con guration and data frames entries would be stored in the iPDC MySQL database. If a configuration frame for a newly added PMU arrives, it would be inserted in the con guration tables. If configuration frame for a previously added PMU arrives, then the previous entry in the table will be updated. The data frames are inserted as they come. This data which is stored in the tables can then be used for later analysis. The data from the database is archived periodically. See the below figure,

iPDC_DBServer.jpg
  • Script db.sql gives the DDL statements to create the schema. In the MySQL database named openPDC will be created. There are 9 tables namely,
    • MAIN CFG TABLE
    • SUB CFG TABLE
    • PHASOR
    • ANALOG
    • DIGITAL
    • PHASOR MEASUREMENTS
    • ANALOG MEASUREMENTS
    • FREQUENCY MEASUREMENTS
    • DIGITAL MEASUREMENTS
  • Figure below shows the functional dependencies of the tables.
iPDC_DBTables.jpg

Last edited May 29, 2012 at 5:56 AM by PanditNitesh, version 3

Comments

No comments yet.