Mercurial > hg > semantic-sia

changeset 60:387439c076f9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
new
author stevenh
date Sat, 11 May 2013 17:56:37 +0100
parents 5d5bf6159c67
children 702bcf723979
files src/sparql/insert_datapoint_order_bar_one.sparql src/sparql/insert_datapoint_order_last_one.sparql src/sparql/insert_vte_order_bar_one.sparql src/sparql/insert_vte_order_last_one.sparql
diffstat 4 files changed, 207 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/sparql/insert_datapoint_order_bar_one.sparql	Sat May 11 17:56:37 2013 +0100
@@ -0,0 +1,54 @@
+PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
+PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
+PREFIX owl: <http://www.w3.org/2002/07/owl#>
+PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
+PREFIX abc: <http://example.org/abc#>
+PREFIX seq: <http://example.org/seq#>
+PREFIX sia: <http://example.org/sia#>
+
+INSERT { ?datapoint1 sia:orderedIndex ?orderedIndex;
+		 			 sia:memberOfOrderedSet ?dataset}
+			
+WHERE
+{
+	{
+		SELECT ?datapoint1 (COUNT (?datapoint2) AS ?numSmallerDatapoints) ?dataset
+		WHERE
+		{
+			?datapoint1 sia:dimVal ?dimVal1x .
+			?datapoint1 sia:memberOfDataset ?dataset .
+			?dimVal1x sia:dimension ?smallestDimensionMin .
+			?dimVal1x sia:value ?value1x .
+
+			?datapoint2 sia:dimVal ?dimVal2x .
+			?dimVal2x sia:dimension ?smallestDimensionMin .
+			?dimVal2x sia:value ?value2x .
+			
+			FILTER ( datatype(?value1x) = xsd:double && datatype(?value2x) = xsd:double )
+			FILTER (?value1x > ?value2x) .
+			{
+				SELECT ?datapoint1 ?datapoint2 (MIN(?dimension) AS ?smallestDimensionMin)
+				WHERE
+				{
+					?datapoint1 a sia:Datapoint .
+					?datapoint1 sia:memberOfDataset ?dataset .
+					?datapoint1 sia:dimVal ?dimVal1 .
+					?dimVal1 sia:dimension ?dimension .
+					?dimVal1 sia:value ?value1 .
+		
+					?datapoint2 a sia:Datapoint .
+					?datapoint2 sia:memberOfDataset ?dataset .
+					?datapoint2 sia:dimVal ?dimVal2 .
+					?dimVal2 sia:dimension ?dimension .
+					?dimVal2 sia:value ?value2 .
+		
+					FILTER ( datatype(?value1) = xsd:double && datatype(?value2) = xsd:double )
+					FILTER (?value1 != ?value2) .
+				}
+				GROUP BY ?datapoint1 ?datapoint2
+			}
+		}
+		GROUP BY ?datapoint1 ?dataset
+	}
+	BIND (?numSmallerDatapoints + 1 AS ?orderedIndex)
+}
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/sparql/insert_datapoint_order_last_one.sparql	Sat May 11 17:56:37 2013 +0100
@@ -0,0 +1,17 @@
+PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
+PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
+PREFIX owl: <http://www.w3.org/2002/07/owl#>
+PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
+PREFIX abc: <http://example.org/abc#>
+PREFIX seq: <http://example.org/seq#>
+PREFIX sia: <http://example.org/sia#>
+
+INSERT { ?datapoint sia:orderedIndex 1;
+		 			 sia:memberOfOrderedSet ?dataset}
+			
+WHERE
+{
+	?datapoint a sia:Datapoint .
+	?datapoint sia:memberOfDataset ?dataset .
+	FILTER NOT EXISTS {?datapoint sia:memberOfOrderedSet ?orderedSet}
+}
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/sparql/insert_vte_order_bar_one.sparql	Sat May 11 17:56:37 2013 +0100
@@ -0,0 +1,119 @@
+PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
+PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
+PREFIX owl: <http://www.w3.org/2002/07/owl#>
+PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
+PREFIX abc: <http://example.org/abc#>
+PREFIX seq: <http://example.org/seq#>
+PREFIX sia: <http://example.org/sia#>
+
+INSERT { ?vte1 sia:orderedIndex ?orderedIndex;
+			   sia:memberOfOrderedSet ?dataset}
+			
+WHERE
+{
+	?vte1 a sia:VectorTableElement .
+	?vte1 sia:memberOfDataset ?dataset .
+
+	{
+		SELECT ?vte1 (COUNT (DISTINCT(?vte2)) AS ?numSmallerVtes) ?dataset
+		WHERE	
+		{
+			{
+				SELECT ?vte1 ?vte2 ?dataset
+				WHERE
+				{
+					?vte1 sia:dimVal ?dimVal1x .
+					?vte1 sia:memberOfDataset ?dataset .
+					?vte1 a sia:VectorTableElement .
+					?dimVal1x sia:dimension ?smallestDimensionMin .
+					?dimVal1x sia:value ?value1x .
+				
+					?vte2 sia:dimVal ?dimVal2x .
+					?vte2 sia:memberOfDataset ?dataset .
+					?vte2 a sia:VectorTableElement .
+					?dimVal2x sia:dimension ?smallestDimensionMin .
+					?dimVal2x sia:value ?value2x .
+				
+					FILTER (?value1x > ?value2x) .
+				
+					{
+						{
+							SELECT ?vte1 ?vte2 (MIN(?dimension) AS ?smallestDimensionMin) ?dataset
+							WHERE
+							{
+								?vte1 a sia:VectorTableElement .
+								?vte1 sia:dimVal ?dimVal1 .
+								?vte1 sia:memberOfDataset ?dataset .
+								?dimVal1 sia:dimension ?dimension .
+								?dimVal1 sia:value ?value1 .
+					
+								?vte2 a sia:VectorTableElement .
+								?vte2 sia:dimVal ?dimVal2 .
+								?vte2 sia:memberOfDataset ?dataset .
+								?dimVal2 sia:dimension ?dimension .
+								?dimVal2 sia:value ?value2 .
+					
+								FILTER (?value1 != ?value2) .
+							}
+							GROUP BY ?dataset ?vte1 ?vte2
+						}
+					}
+				}
+			}
+			
+			UNION
+			
+			{
+				SELECT ?vte1 ?vte2 ?dataset
+				WHERE
+				{
+					?vte1 a sia:VectorTableElement .
+					?vte1 sia:memberOfDataset ?dataset .
+					?vte1 sia:fromDatapoint ?vte1FromDatapoint .
+					?vte1FromDatapoint sia:orderedIndex ?value1 .
+					
+					?vte2 a sia:VectorTableElement .
+					?vte2 sia:memberOfDataset ?dataset .
+					?vte2 sia:fromDatapoint ?vte2FromDatapoint .
+					?vte2FromDatapoint sia:orderedIndex ?value2 .
+					
+					FILTER (?value1 > ?value2) .
+				
+					{
+				
+						# These are vtes which are equal in all dimensions
+						SELECT ?vte1 ?vte2 ?dataset
+						WHERE
+						{
+							?vte1 a sia:VectorTableElement .
+							?vte1 sia:memberOfDataset ?dataset .
+							?vte2 a sia:VectorTableElement .
+							?vte2 sia:memberOfDataset ?dataset .
+						
+							MINUS
+							{
+								?vte1 a sia:VectorTableElement .
+								?vte1 sia:memberOfDataset ?dataset .
+								?vte1 sia:dimVal ?dimVal1 .
+								?dimVal1 sia:dimension ?dimension .
+								?dimVal1 sia:value ?value1 .
+						
+								?vte2 a sia:VectorTableElement .
+								?vte2 sia:memberOfDataset ?dataset .
+								?vte2 sia:dimVal ?dimVal2 .
+								?dimVal2 sia:dimension ?dimension .
+								?dimVal2 sia:value ?value2 .
+						
+								FILTER (?value1 != ?value2) .
+								FILTER (?vte1 != ?vte2) .
+							}
+						}
+						GROUP BY ?dataset ?vte1 ?vte2
+					}
+				}
+			}
+		}
+		GROUP BY ?dataset ?vte1
+	}
+	BIND (?numSmallerVtes + 1 AS ?orderedIndex)
+}
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/sparql/insert_vte_order_last_one.sparql	Sat May 11 17:56:37 2013 +0100
@@ -0,0 +1,17 @@
+PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
+PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
+PREFIX owl: <http://www.w3.org/2002/07/owl#>
+PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
+PREFIX abc: <http://example.org/abc#>
+PREFIX seq: <http://example.org/seq#>
+PREFIX sia: <http://example.org/sia#>
+
+INSERT { ?vte sia:orderedIndex 1;
+		 			 sia:memberOfOrderedSet ?dataset}
+			
+WHERE
+{
+	?vte a sia:VectorTableElement .
+	?vte sia:memberOfDataset ?dataset .
+	FILTER NOT EXISTS {?vte sia:memberOfOrderedSet ?orderedSet}
+}
\ No newline at end of file