Opened 12 years ago

Closed 12 years ago

Last modified 10 years ago

#712 closed enhancement (done)

Redesign database backend for HeuristicLab.Modeling

Reported by: mkommend Owned by: mkommend
Priority: medium Milestone: HeuristicLab 3.3.0
Component: ZZZ OBSOLETE: Modeling Version: 3.2
Keywords: Cc:

Description

use LinqToSql for database access instead of rdf queries

Change History (68)

comment:1 Changed 12 years ago by mkommend

  • Owner changed from gkronber to mkommend
  • Status changed from new to assigned

comment:2 Changed 12 years ago by mkommend

created branch for new HL.Modeling database backend r2169

comment:3 Changed 12 years ago by mkommend

added project template HL.Modeling.SQLiteBackend-3.2 r2170

comment:4 Changed 12 years ago by mkommend

forgot reference to HL.PluginInfrastructure in HL.Modeling.SQLiteBackend r2171

comment:5 Changed 12 years ago by mkommend

corrected handling of AssemblyInfo.cs r2172

comment:6 Changed 12 years ago by mkommend

added empty sqlite database file r2173

comment:7 Changed 12 years ago by mkommend

added project HeuristicLab.Modeling.SQLiteBackend r2175

comment:8 Changed 12 years ago by mkommend

adapted schema in database r2176

comment:9 Changed 12 years ago by mkommend

added foreign key constraints and changed id from guid to integer with autoincrement r2177

comment:10 Changed 12 years ago by mkommend

added first implementation of LinqToSql mapping r2178

comment:11 Changed 12 years ago by mkommend

implemented final prototyp of LinqToSql mapping r2179

comment:12 Changed 12 years ago by mkommend

added additional project for SQLServerCompact support r2180

comment:13 Changed 12 years ago by mkommend

added generated classes from DBLinq for sqlite support r2181

comment:14 Changed 12 years ago by mkommend

added HeuristicLab.SQLServerCompact project to deploy SQLServerCompact r2182

comment:15 Changed 12 years ago by mkommend

configured SQLServerCompactPlugin (copy assemblies, build configuration, build dependent deployment x86 or x64) r2183

comment:16 Changed 12 years ago by mkommend

changed access modifiers for Algorithm members r2184

comment:17 Changed 12 years ago by mkommend

  • Summary changed from Redesign SQLite backend for HeuristicLab.Modeling to Redesign database backend for HeuristicLab.Modeling

comment:18 Changed 12 years ago by mkommend

commit to synchronize with GK CAUTION: this changeset does not build r2185

comment:19 Changed 12 years ago by mkommend

moved data objects into own folder r2186

comment:20 Changed 12 years ago by mkommend

renamed SQLServerCompact to HeuristicLab.SQLServerCompact r2187

comment:21 Changed 12 years ago by gkronber

Added new project HL.Modeling.Database with interfaces for the data access layer with r2188.

comment:22 Changed 12 years ago by mkommend

added Properties directory for HL.SQLServerCompact r2189

comment:23 Changed 12 years ago by gkronber

Refactored CEDMA plugins to work with new modeling backend with r2190.

comment:24 Changed 12 years ago by gkronber

r2191: additional commit to r2190.

comment:25 Changed 12 years ago by gkronber

Added problem view for the cedma server with r2193.

comment:26 Changed 12 years ago by mkommend

adapted HeuristicLab.Modeling.Database and Database.SQLServerCompact r2194

comment:27 Changed 12 years ago by gkronber

Fixed compile errors with r2195.

comment:28 Changed 12 years ago by mkommend

updated copy assemblies in branch r2196

comment:29 Changed 12 years ago by mkommend

adapted connection string and explicitly implemented the defined interfaces in hl.modeling.database r2197

comment:30 Changed 12 years ago by gkronber

Fixed a few bugs in CEDMA dispatching with r2198.

comment:31 Changed 12 years ago by gkronber

Changed dispatcher to allow all variables as input or target variable with r2199.

comment:32 Changed 12 years ago by gkronber

Added statements to set the input variables of models in all regression engines with r2201.

comment:33 Changed 12 years ago by mkommend

corrected bugs in database sqlservercompact r2203

comment:34 Changed 12 years ago by mkommend

corrected behavior of dispatcher view to change checkbox with one click r2204

comment:35 Changed 12 years ago by mkommend

added functionality in database backend to query inputvariable results r2205

comment:36 Changed 12 years ago by mkommend

corrected bug in AlgortihmBase.Model. model was created for every call which results in duplicate variables in the bestvalidationsolutionscope => exception. therefore a caching mechanism was implemented. r2206

comment:37 Changed 12 years ago by mkommend

first stable version of CEDMA with new database backend r2207

comment:38 Changed 12 years ago by mkommend

removed obsolete usings in CEDMA.Core and CEDMA.Server r2208

comment:39 Changed 12 years ago by mkommend

removed AssemblyInfo.cs from HeuristicLab.SQLServerCompact r2209

comment:40 Changed 12 years ago by mkommend

corrected deployment of SQLServer compact r2213

comment:41 Changed 12 years ago by mkommend

removed SqlServerCe.Entity.dll r2214

comment:42 Changed 12 years ago by mkommend

first part of performance improvements r2217

comment:43 Changed 12 years ago by mkommend

performance improvements by reusing the datacontext r2221

comment:44 Changed 12 years ago by mkommend

reintegrated branch new heuristic.modeling database backend r2223

comment:45 Changed 12 years ago by mkommend

deleted branch modeling database backend r2224

comment:46 Changed 12 years ago by mkommend

added license information r2229

comment:47 Changed 12 years ago by mkommend

added last changes in CEDMA.Core r2230

comment:48 Changed 12 years ago by gkronber

Deleted unused files in HL.CEDMA plugins with r2238.

comment:49 Changed 12 years ago by gkronber

Removed obsolete CEDMA plugins with r2240.

comment:50 Changed 12 years ago by gkronber

r2258:

  • Reimplemented method to read a list of already executed algorithms and configurations from the results DB
  • Fixed a bug in the GridExecuter
  • Added a button in the dispatcher view to speed up configuration of input variables

comment:51 Changed 12 years ago by gkronber

Added properties for the separation in training/validation/test set to HL.Modeling.IModel with r2270.

comment:52 Changed 12 years ago by gkronber

Added a method to persist HL.Model.IModel instances with r2271.

comment:53 Changed 12 years ago by gkronber

Added functionality to open any database file to CEDMA console with r2273.

comment:54 Changed 12 years ago by gkronber

r2275:

  • Fixed bugs in the SQL comact backend for HL.Modeling.
  • Readded dispatching of stochastic algorithms in CEDMA dispatcher after it was deactivated unintentionally
  • Show algorithm name as model attribute in CEDMA results.

comment:55 Changed 12 years ago by mkommend

added method to get all algorithms r2278

comment:56 Changed 12 years ago by mkommend

added method to get IPredictor from Modeling.Database r2292

comment:57 Changed 12 years ago by mkommend

removed commented code r2293

comment:58 Changed 12 years ago by mkommend

added method to get IProblem from modeling database r2301

comment:59 Changed 12 years ago by mkommend

added check if problems.count == 0 in GetProblem method r2303

comment:60 Changed 12 years ago by mkommend

added problem methods to modeling database r2304

comment:61 Changed 12 years ago by mkommend

extended IModelingDatabase interface to return persisted model r2314

comment:62 Changed 12 years ago by mkommend

added name in IModel added update methods for IModel and ModelData r2326

comment:63 Changed 12 years ago by mkommend

corrected bug in updatedModel method r2329

comment:64 Changed 12 years ago by mkommend

added EmptyDatabase method in HL.Modeling.Database backend r2333

comment:65 Changed 12 years ago by mkommend

corrected connect, disconnect and deletedatabase behaviour r2339

comment:66 Changed 12 years ago by mkommend

  • Resolution set to fixed
  • Status changed from assigned to closed

comment:67 Changed 10 years ago by swagner

  • Milestone changed from Iteration 4 to Current

Milestone Iteration 4 deleted

comment:11 Changed 10 years ago by swagner

  • Milestone changed from Current to HeuristicLab 3.3.0

Milestone Current deleted

Note: See TracTickets for help on using tickets.