Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
06/04/13 13:18:10 (12 years ago)
Author:
pfleck
Message:

#2063:
Task statistics contains only current state and no change history.
Statistics calculation is no longer based on increment updates.
TaskId is primary key in task statistics and EndTime is nullable.
Added TaskState to Task statistics.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql

    r9571 r9578  
    267267    [JobId]              UNIQUEIDENTIFIER NOT NULL,
    268268    [StartTime]          DATETIME         NOT NULL,
    269     [EndTime]            DATETIME         NOT NULL,
    270     CONSTRAINT [PK_FactTask] PRIMARY KEY CLUSTERED ([TaskId] ASC, [LastClientId] ASC, [JobId] ASC, [StartTime] ASC, [EndTime] ASC),
     269    [EndTime]            DATETIME         NULL,
     270  [TaskState]          VARCHAR (30)     NOT NULL,
     271    CONSTRAINT [PK_FactTask] PRIMARY KEY CLUSTERED ([TaskId] ASC),
    271272    CONSTRAINT [FK_FactTask_DimClient] FOREIGN KEY ([LastClientId]) REFERENCES [statistics].[DimClient] ([Id]),
    272273    CONSTRAINT [FK_FactTask_DimJob] FOREIGN KEY ([JobId]) REFERENCES [statistics].[DimJob] ([JobId]),
Note: See TracChangeset for help on using the changeset viewer.