From GEANT2-JRA1 Wiki

MA in Perl

The MA implementation in Perl is exploring a reference implementation in Perl, as well as investigating use of "generic" SQL schema.

Reference Implementation

Generic SQL Schema

The idea behind a generic SQL schema for an MA is that most data types can be mapped to a simple format.

• Simple Schema
  • ID
    • This is a key from a metadata store
  • Timestamp
    • Numeric format, native SQL format, or text
  • eventType
    • identify the metric, measurement or event of this datum
  • Value
    • Here there could be variants for integers and reals. Thus, there might be a version for integer values and one for reals
  • Misc
    • This can be a string that is measurement-specific. It could be a simple vector of information. In the case of traceroute, it could hold the hop+ttl