Data Quality Monitoring Reports - Revision history

Cfuerber: /* Example 1.1: Missing Properties / Values (OWL Full Design) */

2012-07-01T16:11:24Z

Example 1.1: Missing Properties / Values (OWL Full Design)

← Older revision		Revision as of 16:11, 1 July 2012
Line 21:		Line 21:
	\|'''Output:'''\|\|All instances with missing properties and values		\|'''Output:'''\|\|All instances with missing properties and values
	\|}		\|}
−	<syntaxhighlight lang="~~sparql~~">	+	<syntaxhighlight lang="n3">
	SELECT ?dqr ?i		SELECT ?dqr ?i
	WHERE {		WHERE {

Cfuerber: /* Example 1.1: Missing Properties / Values (OWL Full Design) */

2012-05-16T19:41:04Z

Example 1.1: Missing Properties / Values (OWL Full Design)

← Older revision		Revision as of 19:41, 16 May 2012
Line 21:		Line 21:
	\|'''Output:'''\|\|All instances with missing properties and values		\|'''Output:'''\|\|All instances with missing properties and values
	\|}		\|}
−	<syntaxhighlight lang="n3">	+	<syntaxhighlight lang="sparql">
	SELECT ?dqr ?i		SELECT ?dqr ?i
	WHERE {		WHERE {

Cfuerber: /* Example 1.1: Missing Properties / Values (OWL Full Design) */

2012-03-28T14:58:04Z

Example 1.1: Missing Properties / Values (OWL Full Design)

← Older revision		Revision as of 14:58, 28 March 2012
Line 21:		Line 21:
	\|'''Output:'''\|\|All instances with missing properties and values		\|'''Output:'''\|\|All instances with missing properties and values
	\|}		\|}
−	<syntaxhighlight lang="~~sparql~~">	+	<syntaxhighlight lang="n3">
	SELECT ?dqr ?i		SELECT ?dqr ?i
	WHERE {		WHERE {
Line 31:		Line 31:
	{		{
	?i a ?tclass .		?i a ?tclass .
−	NOT EXISTS{	+	FILTER NOT EXISTS{
	?i ?tprop ?value .		?i ?tprop ?value .
	}		}

Cfuerber: /* Example 1.1: Missing Properties / Values (OWL Full Design) */

2012-03-28T12:25:31Z

Example 1.1: Missing Properties / Values (OWL Full Design)

← Older revision		Revision as of 12:25, 28 March 2012
Line 21:		Line 21:
	\|'''Output:'''\|\|All instances with missing properties and values		\|'''Output:'''\|\|All instances with missing properties and values
	\|}		\|}
−	<syntaxhighlight lang="n3">	+	<syntaxhighlight lang="sparql">
	SELECT ?dqr ?i		SELECT ?dqr ?i
	WHERE {		WHERE {

Cfuerber: /* Example 1.1: Missing Properties / Values (OWL Full Design) */

2012-03-28T12:25:00Z

Example 1.1: Missing Properties / Values (OWL Full Design)

← Older revision		Revision as of 12:25, 28 March 2012
Line 21:		Line 21:
	\|'''Output:'''\|\|All instances with missing properties and values		\|'''Output:'''\|\|All instances with missing properties and values
	\|}		\|}
−	<syntaxhighlight lang="~~sparql~~">	+	<syntaxhighlight lang="n3">
	SELECT ?dqr ?i		SELECT ?dqr ?i
	WHERE {		WHERE {

Admin: /* Functional Dependency Violations (2 Reference Properties, OWL DL Design) */

2011-11-26T16:28:50Z

Functional Dependency Violations (2 Reference Properties, OWL DL Design)

← Older revision		Revision as of 16:28, 26 November 2011
Line 493:		Line 493:


−	===Functional Dependency Violations (2 Reference Properties, OWL DL Design)===	+	===Example 13: Functional Dependency Violations (2 Reference Properties, OWL DL Design)===

	{\|class="wikitable"		{\|class="wikitable"

Admin: /* Example 12: Duplicate Instance Rule (3 Properties, OWL DL Design) */

2011-11-26T16:28:32Z

Example 12: Duplicate Instance Rule (3 Properties, OWL DL Design)

← Older revision		Revision as of 16:28, 26 November 2011
Line 490:		Line 490:
	}		}
	GROUP BY ?dqr		GROUP BY ?dqr
−	</~~sytnaxhighlight~~>	+	</syntaxhighlight>

Admin: /* Example 12: Duplicate Instance Rule (3 Properties, OWL DL Design) */

2011-11-26T16:27:53Z

Example 12: Duplicate Instance Rule (3 Properties, OWL DL Design)

← Older revision		Revision as of 16:27, 26 November 2011
Line 493:		Line 493:


−	==Functional Dependency Violations (2 Reference Properties, OWL DL Design)==	+	===Functional Dependency Violations (2 Reference Properties, OWL DL Design)===

	{\|class="wikitable"		{\|class="wikitable"
Line 502:		Line 502:
	\|'''Output:'''\|\|All instances that have violating dependencies between the two tested property values.		\|'''Output:'''\|\|All instances that have violating dependencies between the two tested property values.
	\|}		\|}
		+
	<syntaxhighlight lang="sparql">		<syntaxhighlight lang="sparql">
	PREFIX dqm:<http://purl.org/dqm-vocabulary/v1.1/dqm#>		PREFIX dqm:<http://purl.org/dqm-vocabulary/v1.1/dqm#>

Admin: /* Example 12: Duplicate Instance Rule (3 Properties, OWL DL Design) */

2011-11-26T16:27:08Z

Example 12: Duplicate Instance Rule (3 Properties, OWL DL Design)

← Older revision		Revision as of 16:27, 26 November 2011
Line 491:		Line 491:
	GROUP BY ?dqr		GROUP BY ?dqr
	</sytnaxhighlight>		</sytnaxhighlight>
		+
		+
		+	==Functional Dependency Violations (2 Reference Properties, OWL DL Design)==
		+
		+	{\|class="wikitable"
		+	\|'''Scenario:'''\|\|Find functional dependency violations between two property values.
		+	\|-
		+	\|'''Input:'''\|\|Functional dependency reference rules with 2 tested properties.
		+	\|-
		+	\|'''Output:'''\|\|All instances that have violating dependencies between the two tested property values.
		+	\|}
		+	<syntaxhighlight lang="sparql">
		+	PREFIX dqm:<http://purl.org/dqm-vocabulary/v1.1/dqm#>
		+	PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
		+	SELECT ?dqr ?i
		+	WHERE {
		+	?dqr a dqm:FuncDepReferenceRule .
		+	?dqr dqm:assessment "true"^^xsd:boolean .
		+	?dqr dqm:testedClass ?tclass .
		+	?tclass dqm:hasURI ?tclassreal .
		+	BIND (IRI(str(?tclassreal)) AS ?tclassURI) .
		+	?dqr dqm:testedProperty1 ?tprop1 .
		+	?tprop1 dqm:hasURI ?tpropreal1 .
		+	BIND (IRI(str(?tpropreal1)) AS ?tpropURI1) .
		+	?dqr dqm:testedProperty2 ?tprop2 .
		+	?tprop2 dqm:hasURI ?tpropreal2 .
		+	BIND (IRI(str(?tpropreal2)) AS ?tpropURI2) .
		+	?dqr dqm:referenceClass ?trefclass .
		+	?trefclass dqm:hasURI ?trefclassreal .
		+	BIND (IRI(str(?trefclassreal)) AS ?trefclassURI) .
		+	?dqr dqm:referenceProperty1 ?trefprop1 .
		+	?trefprop1 dqm:hasURI ?trefpropreal1 .
		+	BIND (IRI(str(?trefpropreal1)) AS ?trefpropURI1) .
		+	?dqr dqm:referenceProperty2 ?trefprop2 .
		+	?trefprop2 dqm:hasURI ?trefpropreal2 .
		+	BIND (IRI(str(?trefpropreal2)) AS ?trefpropURI2) .
		+	?i a ?tclassURI .
		+	?i ?tpropURI1 ?value1 .
		+	?i ?tpropURI2 ?value2 .
		+	BIND(STRDT(str(?value1),xsd:string) AS ?value11 )
		+	BIND(STRDT(str(?value2),xsd:string) AS ?value12 )
		+	NOT EXISTS{
		+	?i2 a ?trefclassURI .
		+	?i2 ?trefpropURI1 ?value11 .
		+	?i2 ?trefpropURI2 ?value12 .
		+	}
		+	}
		+	</syntaxhighlight>

Admin: /* Example 11: Outdated / Not Updated Values (OWL DL Design) */

2011-11-26T13:59:46Z

Example 11: Outdated / Not Updated Values (OWL DL Design)

← Older revision		Revision as of 13:59, 26 November 2011
Line 452:		Line 452:

	[[Create Data Requirements#Example 11: Update Rule (OWL DL)\|Click here to learn how to define a data requirement for this report]]		[[Create Data Requirements#Example 11: Update Rule (OWL DL)\|Click here to learn how to define a data requirement for this report]]
		+
		+	===Example 12: Duplicate Instance Rule (3 Properties, OWL DL Design)===
		+
		+	{\|class="wikitable"
		+	\|'''Scenario:'''\|\|Find duplicate instances.
		+	\|-
		+	\|'''Input:'''\|\|Duplicate instance rules with 3 tested properties.
		+	\|-
		+	\|'''Output:'''\|\|All instances that have identical values for the 3 tested properties.
		+	\|}
		+	<syntaxhighlight lang="sparql">
		+	PREFIX dqm:<http://purl.org/dqm-vocabulary/v1.1/dqm#>
		+	PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
		+	SELECT ?dqr ?i
		+	WHERE {
		+	?dqr a dqm:DuplicateInstanceRule .
		+	?dqr dqm:testedClass ?tclass .
		+	?tclass dqm:hasURI ?tclassreal .
		+	BIND (IRI(str(?tclassreal)) AS ?tclassURI) .
		+	?dqr dqm:testedProperty1 ?tprop1 .
		+	?tprop1 dqm:hasURI ?tpropreal1 .
		+	BIND (IRI(str(?tpropreal1)) AS ?tpropURI1) .
		+	?dqr dqm:testedProperty2 ?tprop2 .
		+	?tprop2 dqm:hasURI ?tpropreal2 .
		+	BIND (IRI(str(?tpropreal2)) AS ?tpropURI2) .
		+	?dqr dqm:testedProperty3 ?tprop3 .
		+	?tprop3 dqm:hasURI ?tpropreal3 .
		+	BIND (IRI(str(?tpropreal3)) AS ?tpropURI3) .
		+	?i a ?tclassURI .
		+	?i ?tpropURI1 ?value11 .
		+	?i2 ?tpropURI1 ?value12 .
		+	?i ?tpropURI2 ?value21 .
		+	?i2 ?tpropURI2 ?value22 .
		+	?i ?tpropURI3 ?value31 .
		+	?i2 ?tpropURI3 ?value32 .
		+	FILTER(?i!=?i2 && str(?value11) = str(?value12) && str(?value21) = str(?value22) && str(?value31) = str(?value32))
		+	}
		+	GROUP BY ?dqr
		+	</sytnaxhighlight>