Performance index - new approach.

This patch constitutes a slightly different and also simpler
approach to computing the performance index.

The hierarchical index structure is gone for now,
and the index is computed essentially like this:

1: Specify a base timestamp BT.
2: Specify a set of evaluation timestamps ET.
3: Specify a window size for median smoothing.
4: Specify a set of filters to effectively narrow
   down the set of result histories that may contribute
   to the index (there are currently five separate filters:
   metric, platform, host, branch, and test case.
   Zero or more values may be specified for each one).
5: Evaluate the index at a given evaluation timestamp ET(i) by
   taking the arithmetic mean of the differences between the
   values at ET(i) and BT for the individual result histories.
   Both values are median-smoothed using a right-aligned window.

1 files changed, 0 insertions, 25 deletions

diff --git a/src/bmserver/main.cpp b/src/bmserver/main.cpp
index dd57b96..dbc4d59 100644
--- a/src/bmserver/main.cpp
+++ b/src/bmserver/main.cpp
@@ -117,25 +117,6 @@ static bool initDatabase(const QString &dbfile, QString *error)
         ", UNIQUE(bmcontextId, snapshotId));");
     Q_ASSERT(ok);
 
-    // index_
-    ok = query.exec(
-        "CREATE TABLE index_(id INTEGER PRIMARY KEY AUTOINCREMENT"
-        ", parentId INTEGER REFERENCES index_(id)"
-        ", resultId INTEGER REFERENCES result(id)"
-        ", name TEXT"
-        ", description TEXT NOT NULL"
-        ", timestamp INTEGER NOT NULL"
-        ", weight REAL NOT NULL"
-        ", historyConstant REAL"
-        ", UNIQUE(name));");
-    Q_ASSERT(ok);
-
-    // indexOptions
-    ok = query.exec(
-        "CREATE TABLE indexOptions("
-        "  medianWinSize INTEGER NOT NULL);");
-
-    Q_ASSERT(ok);
 
     // *** Create indexes ***
     ok = query.exec("CREATE INDEX index_metric_name ON metric(name);");
@@ -184,12 +165,6 @@ static bool initDatabase(const QString &dbfile, QString *error)
         "CREATE INDEX index_result_bmcontextId_snapshotId ON result(bmcontextId, snapshotId);");
     Q_ASSERT(ok);
 
-    ok = query.exec("CREATE INDEX index_index_name ON index_(name);");
-    Q_ASSERT(ok);
-
-    ok = query.exec("CREATE INDEX index_index_timestamp ON index_(timestamp);");
-    Q_ASSERT(ok);
-
     return true;
 }