Entity-Relationship Diagram
ER Diagram
Here is the ER diagram for the database.
Schema
This is our schema:
ProgramPoints(ppname Blob, numargs int, vnames Blob,
vtypes Blob, vcomparables Blob)
Info(name Blob not null, value Blob)
<PPNAME>values(timestamp Bigint not null auto_increment,
index (timestamp),
count Bigint not null,
value0 TYPE,
mod0 Int,
...
valueN TYPE,
modN Int)
TYPE is either Bigint or Blob.
The ProgramPoints and Info tables each have a fixed schema
like most databases.
ppname in the ProgramPoints table is a column of
program point names.
However, the schema <PPNAME>values is really a
specification for a set of schemas, one for each program
point.
Each program point has its own schema and its own table.
<PPNAME> is a placeholder for the program point name.
Also, each program point table has a certain number of variables,
but the number of variables (and therefore the number of columns)
varies among tables.
Back to top
|