Changeset 12468 for branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql

Timestamp:

06/18/15 11:58:58 (9 years ago)

Author:

dglaser

Message:

#2388:
HeuristicLab.Services.Hive.DataAccess-3.3:

• Added PersistenceManager with corresponding daos
• Updated SQL Scripts
• Fixed folder structure (interfaces, manager)
• Removed duplicated IHiveDao and HiveDao (the HiveDao/OptimizedHiveDao that is actually used is located in HeuristicLab.Services.Hive)

HeuristicLab.Service.Hive-3.3:

• Added PersistenceManager to the ServiceLocater
• Updated and improved the HiveStatisticsGenerator
• Updated HiveJanitor

File:

• branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql (modified) (3 diffs)

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

@@ -239 +239 @@
     [TotalMemory]           INT              NOT NULL,
     [CpuUtilization]        FLOAT (53)       NOT NULL,
-  [SlaveState]      VarChar(15)    NOT NULL,
+    [SlaveState]      VarChar(15)    NOT NULL,
     [TotalTimeIdle]         FLOAT (53)       NOT NULL,
     [TotalTimeCalculating]  FLOAT (53)       NOT NULL,
@@ -260 +260 @@
     [MemoryRequired]     INT              NOT NULL,
     [Priority]           INT              NOT NULL,
-    [LastClientId]       UNIQUEIDENTIFIER NOT NULL,
+    [LastClientId]       UNIQUEIDENTIFIER NULL,
     [JobId]              UNIQUEIDENTIFIER NOT NULL,
     [StartTime]          DATETIME         NOT NULL,
     [EndTime]            DATETIME         NULL,
-  [TaskState]          VARCHAR (30)     NOT NULL,
-  [Exception]      VARCHAR (MAX)    NULL,
+    [TaskState]          VARCHAR (30)     NOT NULL,
+    [Exception]      VARCHAR (MAX)    NULL,
     CONSTRAINT [PK_FactTask] PRIMARY KEY CLUSTERED ([TaskId] ASC),
     CONSTRAINT [FK_FactTask_DimClient] FOREIGN KEY ([LastClientId]) REFERENCES [statistics].[DimClient] ([Id]),
@@ -273 +273 @@
 );
 
-INSERT INTO [HeuristicLab.Hive-3.3].[statistics].[DimClient] ([Id] ,[Name] ,[ResourceId])
-VALUES ('00000000-0000-0000-0000-000000000000' ,'NULL' ,'00000000-0000-0000-0000-000000000000')
+/* dummy for nullable userIds in FactClientInfo */
+INSERT INTO [statistics].[DimUser] ([UserId], [Name])
+VALUES ('00000000-0000-0000-0000-000000000000', 'NULL');