Example #1
0
        public static void RunQueriesFromFiles()
        {
            var InMemoryQueryEngine = new InMemoryQueryEngine();

            InMemoryQueryEngine.Init(LuceneDirectoryDefaults.EntityIndexPath, LuceneDirectoryDefaults.PropertyIndexPath);
            var queryBenchmarks = new List <QueryBenchmark>();
            var path            = @"C:\Users\admin\Desktop\DCC\SparqlforHumans\SparqlForHumans.Benchmark\Queries\";
            var files           = Directory.EnumerateFiles(path, "*.sparql");

            foreach (var file in files)
            {
                Console.WriteLine(); Console.WriteLine(); Console.WriteLine(); Console.WriteLine();
                Console.WriteLine($"File: {file}");
                Console.WriteLine(); Console.WriteLine(); Console.WriteLine(); Console.WriteLine();
                var text      = File.ReadAllText(file);
                var converter = new SparqlToGraphConverter();
                var rdfGraph  = converter.ConvertToGraph(text);

                var graphs = rdfGraph.GetGraphVariations();

                foreach (var rdfExplorerGraph in graphs)
                {
                    Console.WriteLine("####################################################################################");
                    var graph = new QueryGraph(rdfExplorerGraph)
                    {
                        EntitiesIndexPath   = LuceneDirectoryDefaults.EntityIndexPath,
                        PropertiesIndexPath = LuceneDirectoryDefaults.PropertyIndexPath
                    };

                    //Do not run if there are no variables to query.
                    if (graph.Edges.Select(x => x.Value).All(x => x.IsConstant))
                    {
                        continue;
                    }

                    var endpoint = new WikidataEndpointQueryRunner(graph).RunBenchmark();
                    endpoint.Print();
                    var local = new LocalQueryRunner(graph).RunBenchmark();
                    local.Print();
                    queryBenchmarks.Add(endpoint);
                    queryBenchmarks.Add(local);
                }
            }

            queryBenchmarks.SerializeJson(@"benchmark.json");

            foreach (var benchmark in queryBenchmarks)
            {
                benchmark.Print();
            }
        }
Example #2
0
        public static void RunQueriesFromProperties()
        {
            var InMemoryQueryEngine = new InMemoryQueryEngine();

            InMemoryQueryEngine.Init(LuceneDirectoryDefaults.EntityIndexPath, LuceneDirectoryDefaults.PropertyIndexPath);
            var queryBenchmarks = new List <QueryBenchmark>();

            var propertiesList = new List <string> {
                "P17",
                "P19",
                "P21",
                "P31",
                "P50",
                "P102",
                "P106",
                "P112",
                "P127",
                "P131",
                "P135",
                "P138",
                "P150",
                "P155",
                "P156",
                "P159",
                "P180",
                "P184",
                "P276",
                "P279",
                "P287",
                "P301",
                "P361",
                "P364",
                "P413",
                "P421",
                "P511",
                "P527",
                "P531",
                "P611",
                "P641",
                "P682",
                "P710",
                "P793",
                "P805",
                "P807",
                "P873",
                "P910",
                "P915",
                "P921",
                "P971",
                "P1204",
                "P1344",
                "P1423",
                "P1424",
                "P1433",
                "P1435",
                "P1445",
                "P1464",
                "P1478",
                "P1889",
                "P2156",
                "P2239",
                "P2522",
                "P2614",
                "P2860",
                "P2894",
                "P3092",
                "P3096",
                "P3259",
                "P3919",
                "P3985",
                "P4000",
                "P4224",
                "P4599",
                "P4809",
                "P4878",
            };

            foreach (var property in propertiesList)
            {
                Console.WriteLine(); Console.WriteLine(); Console.WriteLine(); Console.WriteLine();
                Console.WriteLine($"Property: {property}");
                Console.WriteLine(); Console.WriteLine(); Console.WriteLine(); Console.WriteLine();

                var text1     = $"SELECT * WHERE {{?v1 wdt:{property} ?v2 . ?v1 ?p1 ?v3 . }} ";
                var converter = new SparqlToGraphConverter();
                var rdfGraph1 = converter.ConvertToGraph(text1);


                Console.WriteLine("####################################################################################");
                var graph = new QueryGraph(rdfGraph1)
                {
                    EntitiesIndexPath   = LuceneDirectoryDefaults.EntityIndexPath,
                    PropertiesIndexPath = LuceneDirectoryDefaults.PropertyIndexPath
                };

                //Do not run if there are no variables to query.
                if (graph.Edges.Select(x => x.Value).All(x => x.IsConstant))
                {
                    continue;
                }

                var endpoint = new WikidataEndpointQueryRunner(graph).RunBenchmark();
                endpoint.Print();
                var local = new LocalQueryRunner(graph).RunBenchmark();
                local.Print();
                queryBenchmarks.Add(endpoint);
                queryBenchmarks.Add(local);

                var text2 = $"SELECT * WHERE {{?v1 wdt:{property} ?v2 . ?v2 ?p1 ?v3 . }} ";
                converter = new SparqlToGraphConverter();
                var rdfGraph2 = converter.ConvertToGraph(text2);

                Console.WriteLine("####################################################################################");
                graph = new QueryGraph(rdfGraph2)
                {
                    EntitiesIndexPath   = LuceneDirectoryDefaults.EntityIndexPath,
                    PropertiesIndexPath = LuceneDirectoryDefaults.PropertyIndexPath
                };

                //Do not run if there are no variables to query.
                if (graph.Edges.Select(x => x.Value).All(x => x.IsConstant))
                {
                    continue;
                }

                endpoint = new WikidataEndpointQueryRunner(graph).RunBenchmark();
                endpoint.Print();
                local = new LocalQueryRunner(graph).RunBenchmark();
                local.Print();
                queryBenchmarks.Add(endpoint);
                queryBenchmarks.Add(local);

                var text3 = $"SELECT * WHERE {{?v1 wdt:{property} ?v2 . ?v3 ?p1 ?v1 . }} ";
                converter = new SparqlToGraphConverter();
                var rdfGraph3 = converter.ConvertToGraph(text3);

                Console.WriteLine("####################################################################################");
                graph = new QueryGraph(rdfGraph3)
                {
                    EntitiesIndexPath   = LuceneDirectoryDefaults.EntityIndexPath,
                    PropertiesIndexPath = LuceneDirectoryDefaults.PropertyIndexPath
                };

                //Do not run if there are no variables to query.
                if (graph.Edges.Select(x => x.Value).All(x => x.IsConstant))
                {
                    continue;
                }

                endpoint = new WikidataEndpointQueryRunner(graph).RunBenchmark();
                endpoint.Print();
                local = new LocalQueryRunner(graph).RunBenchmark();
                local.Print();
                queryBenchmarks.Add(endpoint);
                queryBenchmarks.Add(local);

                var text4 = $"SELECT * WHERE {{?v1 wdt:{property} ?v2 . ?v3 ?p1 ?v2 . }} ";
                converter = new SparqlToGraphConverter();
                var rdfGraph4 = converter.ConvertToGraph(text4);

                Console.WriteLine("####################################################################################");
                graph = new QueryGraph(rdfGraph4)
                {
                    EntitiesIndexPath   = LuceneDirectoryDefaults.EntityIndexPath,
                    PropertiesIndexPath = LuceneDirectoryDefaults.PropertyIndexPath
                };

                //Do not run if there are no variables to query.
                if (graph.Edges.Select(x => x.Value).All(x => x.IsConstant))
                {
                    continue;
                }

                endpoint = new WikidataEndpointQueryRunner(graph).RunBenchmark();
                endpoint.Print();
                local = new LocalQueryRunner(graph).RunBenchmark();
                local.Print();
                queryBenchmarks.Add(endpoint);
                queryBenchmarks.Add(local);
            }

            queryBenchmarks.SerializeJson(@"benchmark.json");

            foreach (var benchmark in queryBenchmarks)
            {
                benchmark.Print();
            }
        }