Changeset 2217 for branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database.SQLServerCompact

Timestamp:

07/31/09 12:11:41 (15 years ago)

Author:

mkommend

Message:

first part of performance improvements (ticket #712)

Location:

branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2

Files:

• DataObjects/Model.cs (modified) (2 diffs)
• DataObjects/ModelData.cs (added)
• DatabaseService.cs (modified) (7 diffs)
• HeuristicLab.Modeling.Database.SQLServerCompact-3.2.csproj (modified) (1 diff)
• ModelingDataContext.cs (modified) (1 diff)

branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DataObjects/Model.cs

@@ -14 +14 @@
     }
 
-    public Model(Variable targetVariable, Algorithm algorithm, byte[] data)
+    public Model(Variable targetVariable, Algorithm algorithm)
       : this() {
       this.targetVariableId = targetVariable.Id;
       this.algorithmId = algorithm.Id;
-      this.Data = data;
     }
 
@@ -26 +25 @@
       get { return this.id; }
       private set { this.id = value; }
-    }
-
-    private byte[] data;
-    [Column(Storage = "data", DbType = "image", CanBeNull = false)]
-    public byte[] Data {
-      get { return this.data; }
-      set { this.data = value; }
     }
 

branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs

@@ -45 +45 @@
 
       using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
-        model = new Model(target, algo, PersistenceManager.SaveToGZip(algorithm.Model.Data));
+        model = new Model(target, algo);
         model.TrainingSamplesStart = trainingSamplesStart;
         model.TrainingSamplesEnd = trainingSamplesEnd;
@@ -59 +59 @@
 
       using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
+        ctx.ModelData.InsertOnSubmit(new ModelData(model, PersistenceManager.SaveToGZip(algorithm.Model.Data)));
+      }
+
+      using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
         foreach (string inputVariable in algorithm.Model.InputVariables) {
-          ctx.InputVariables.InsertOnSubmit(new InputVariable(model, variables[inputVariable]));          
+          ctx.InputVariables.InsertOnSubmit(new InputVariable(model, variables[inputVariable]));
         }
         ctx.SubmitChanges();
@@ -194 +198 @@
 
     public IEnumerable<IResult> GetAllResultsForInputVariables() {
-      using(ModelingDataContext ctx = new ModelingDataContext(connection) ){
-        return (from ir in ctx.InputVariableResults  select ir.Result).Distinct().ToList().Cast<IResult>();
+      using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
+        return (from ir in ctx.InputVariableResults select ir.Result).Distinct().ToList().Cast<IResult>();
       }
     }
@@ -205 +209 @@
       ModelingDataContext ctx = new ModelingDataContext(connection);
       DataLoadOptions dlo = new DataLoadOptions();
-      dlo.LoadWith<ModelResult>(mr => mr.Model);
       dlo.LoadWith<ModelResult>(mr => mr.Result);
       ctx.LoadOptions = dlo;
@@ -214 +217 @@
       return results.ToList().Cast<IModelResult>();
     }
+
+    public void GetAllModelResults() {
+      ModelingDataContext ctx = new ModelingDataContext(connection);
+      DataLoadOptions dlo = new DataLoadOptions();
+      dlo.LoadWith<ModelResult>(mr => mr.Result);
+      dlo.LoadWith<ModelResult>(mr => mr.Model);
+      ctx.LoadOptions = dlo;
+
+      var results = from result in ctx.ModelResults
+                    select result;
+      results.ToList();     
+
+    }
     #endregion
 
@@ -221 +237 @@
       DataLoadOptions dlo = new DataLoadOptions();
       dlo.LoadWith<InputVariableResult>(ir => ir.Variable);
-      dlo.LoadWith<InputVariableResult>(ir => ir.Result);
-      dlo.LoadWith<InputVariableResult>(ir => ir.Model);
+      dlo.LoadWith<InputVariableResult>(ir => ir.Result);      
       ctx.LoadOptions = dlo;
 
@@ -241 +256 @@
       return ctx.Models.ToList().Cast<IModel>();
     }
+
+    public byte[] GetModelData(IModel model) {
+      using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
+        var data = (from md in ctx.ModelData
+                    where md.Model == model
+                    select md);
+        if (data.Count() == 0)
+          return null;
+        return data.Single().Data;
+      }
+    }
     #endregion
 

branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/HeuristicLab.Modeling.Database.SQLServerCompact-3.2.csproj

@@ -122 +122 @@
     <Compile Include="DataObjects\InputVariableResult.cs" />
     <Compile Include="DataObjects\Model.cs" />
+    <Compile Include="DataObjects\ModelData.cs" />
     <Compile Include="HeuristicLabModelingDatabaseSQLServerCompactPlugin.cs" />
     <Compile Include="ModelingDataContext.cs" />

branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/ModelingDataContext.cs

@@ -33 +33 @@
     }
 
+    public Table<ModelData> ModelData {
+      get { return GetTable<ModelData>(); }
+    }
+
     public Table<InputVariableResult> InputVariableResults {
       get { return GetTable<InputVariableResult>(); }