Esempio n. 1
0
        private int storeExperiment2db(MethodPerformance performance, ExperimentOptions options)
        {
            StringBuilder query = new StringBuilder();

            query.Append("INSERT INTO " + Constants.ExperimentsTable + " (algorithm_id,population_group,algorithm_name,discounted,max_trust,pop,pou,pot,occupancy_pred_rate,occupancy_mse,trust_pred_rate,trust_mse,processing_time,random_rate,random_mse,pcc,scc,maxvote_rate,maxvote_mse,averagePenalties_pred,averagePenalties_maxvote,averagePenalties_random) VALUES (");

            string[] vals = new string[] {
                experimentMethodCode.ToString(),
                     experimentGroup.ToString(),
                "'" + experimentName + "'",
                     options.discounted ? "1" : "0",
                     options.maxTrust ? "1" : "0",
                     options.pop.ToString(),
                     options.pou.ToString(),
                     options.pot.ToString(),
                     performance.OccupancyTagVectorDifferencePerformance[0].rate.ToString(),
                     performance.OccupancyTagVectorDifferencePerformance[0].mse.ToString(),
                     performance.TrustPredictionVectorDifference[0].rate.ToString(),
                     performance.TrustPredictionVectorDifference[0].mse.ToString(),
                     performance.TotalProcessorTicks.ToString(),
                     performance.OccupancyTagVectorDifferencePerformance[2].rate.ToString(),
                     performance.OccupancyTagVectorDifferencePerformance[2].mse.ToString(),
                     performance.Pcc.ToString(),
                     performance.Scc.ToString(),
                     performance.OccupancyTagVectorDifferencePerformance[1].rate.ToString(),
                     performance.OccupancyTagVectorDifferencePerformance[1].mse.ToString(),
                     performance.OccupancyPenaltyPerformance[0].rate.ToString(),
                     performance.OccupancyPenaltyPerformance[1].rate.ToString(),
                     performance.OccupancyPenaltyPerformance[2].rate.ToString()
            };

            string values = string.Join(",", vals);

            query.Append(values + ")");
            string qstring = query.ToString();

            if (!db.ExecuteNonQuery(qstring))
            {
                Console.WriteLine("Failed");
            }
            else
            {
                int experiment_id = int.Parse(db.ExecuteQuery("select top 1 id from experiments order by timeOfCompletion desc")["id"][0]);
                //query.Clear();
                //foreach (var item in Occupancies)
                //{
                //    if(!item.IsTrainingDay)
                //        // store to simulated occupancies table
                //        query.Append(string.Format("INSERT INTO [dbo].[SimulatedOccupancies] ([experiment_id] ,[real_tag] ,[predicted_tag] ,[maxvote_tag], [hour], [weekday], [day], [section]) VALUES ('{0}',{1},{2},{3},{4}, {5}, {6}, {7});\n",
                //            experiment_id, item.OccupancyTag, item.PredictedOccupancyTag, item.MaxVoteOccupancyTag, item.Hour, item.Weekday, item.Day, item.Section));
                //}
                //qstring = query.ToString();
                //if (!db.ExecuteNonQuery(qstring))
                //    Console.WriteLine("Failed");
                //else
                return(experiment_id);
            }
            return(-1);
        }
Esempio n. 2
0
        public void run()
        {
            init();

            // delete already existing data from database
            db.ExecuteNonQuery("DELETE FROM " + Constants.ExperimentsTable + " WHERE algorithm_id = " + experimentMethodCode + " and population_group = " + experimentGroup);

            // At this stage we have everything we need to run the experiment
            // We should run the experiment on 5 different parameters mentioned in ExperimentInputParams
            var inputParams = new ExperimentInputParams();

            Users = new List <User>(50000);
            for (int i = 0; i < Users.Capacity; i++)
            {
                Users.Add(null);
            }

            foreach (var pop in inputParams.percentOfParticipants)
            {
                foreach (var pou in inputParams.percentOfUpdatesUsed)
                {
                    for (int i = 0; i < Users.Capacity; i++)
                    {
                        Users[i] = null;
                    }
                    UserTags = null;
                    GC.Collect();
                    GC.WaitForPendingFinalizers();

                    UserTags = (from tag in TotalReportedUserTags where tag.RandomUserValue <= pop && tag.RandomColumnValue <= pou select tag).ToList();
                    var usersids = (from tag in UserTags select new { id = tag.UserID, trust = tag.UserTrust }).Distinct().ToList();
                    for (int i = 0; i < usersids.Count; i++)
                    {
                        Users[usersids[i].id] = new User(usersids[i].id, usersids[i].trust, 50);
                    }

                    foreach (var dc in inputParams.discounted)
                    {
                        foreach (var mt in inputParams.maxTrust)
                        {
                            foreach (var pot in inputParams.percentOfTraining)
                            {
                                var options = new ExperimentOptions(dc, mt, pop, pou, pot, experimentMethodCode, experimentGroup);
                                if (UserTags.Count > 0)
                                {
                                    Method method = new Method(Occupancies, Users, UserTags, options);

                                    MethodPerformance performance = method.Execute();

                                    int experiment_id = storeExperiment2db(performance, options);
                                }
                            }
                        }
                    }
                }
            }
        }