Raw Data Ontology
EKGF Editor's Draft
1. Raw Data Ontology§
1.1 Overview§
Raw Data Ontology
| Identifier | Value |
|---|---|
| Ontology IRI / Namespace | https://ekgf.org/ontology/raw# |
| Prefix | ekg-raw |
The Raw Data Ontology is used by a "capture step" in an EKG DataOps pipeline to capture any data from any data source as RDF triples without mapping it to higher level ontologies. It is assumed that subsequent steps in a given EKG DataOps pipeline will transform the raw data to match with target ontologies.
1.2 Classes§
1.2.1 Column§
A physical field position in exactly one captured raw-data view, linked through isColumnInView or inverse hasColumn. Its identity is independent of its mapped predicate; source metadata and optional statistics describe the column.
ekg-raw:Column | |
https://ekgf.org/ontology/raw#Column | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:Class |
rdfs:label | Column |
rdfs:subClassOf | (rdf:type: owl:Restriction; owl:minCardinality: 1; owl:onProperty: ekg-raw:isColumnInView) |
1.2.2 CSV file§
A raw-data file source in comma-separated values format (RFC 4180). Every field is captured as text; the capture step does not infer datatypes.
ekg-raw:CsvFile | |
https://ekgf.org/ontology/raw#CsvFile | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:Class |
rdfs:label | CSV file |
rdfs:subClassOf | ekg-raw:File |
1.2.3 File§
A file used as a raw-data source during the capture step of a DataOps pipeline.
ekg-raw:File | |
https://ekgf.org/ontology/raw#File | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:Class |
rdfs:label | File |
rdfs:subClassOf | ekg-raw:Source |
1.2.4 Null value§
A captured value occurrence whose source explicitly reports null. It has no literalValue. Missing content metadata and empty strings do not imply this classification; the source reader must identify the null according to the source format or an explicit capture policy.
ekg-raw:NullValue | |
https://ekgf.org/ontology/raw#NullValue | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:Class |
rdfs:label | Null value |
rdfs:subClassOf | ekg-raw:Value |
rdfs:subClassOf | (rdf:type: owl:Restriction; owl:maxCardinality: 0; owl:onProperty: ekg-raw:literalValue) |
1.2.5 Parquet file§
A raw-data file source in the Apache Parquet columnar format. One file is one view whose columns are the schema's top-level fields; values keep the literal datatypes that the file's physical and logical types define.
ekg-raw:ParquetFile | |
https://ekgf.org/ontology/raw#ParquetFile | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:Class |
rdfs:label | Parquet file |
rdfs:subClassOf | ekg-raw:File |
1.2.6 Row§
A record encountered in exactly one raw-data view, retaining its source identifier, sequence position, and captured value occurrences. Each occurrence identifies this row through valueOf and its physical source column through forColumn.
ekg-raw:Row | |
https://ekgf.org/ontology/raw#Row | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:Class |
rdfs:label | Row |
rdfs:subClassOf | (rdf:type: owl:Restriction; owl:minCardinality: 1; owl:onProperty: ekg-raw:isRowInView) |
1.2.7 Source§
An input data source captured as RDF before transformation into higher-level domain ontologies. A source may expose several views.
ekg-raw:Source | |
https://ekgf.org/ontology/raw#Source | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:Class |
rdfs:label | Source |
1.2.8 TSV file§
A raw-data file source in tab-separated values format. Every field is captured as text; the capture step does not infer datatypes.
ekg-raw:TsvFile | |
https://ekgf.org/ontology/raw#TsvFile | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:Class |
rdfs:label | TSV file |
rdfs:subClassOf | ekg-raw:File |
1.2.9 Value§
Value identifies an occurrence of source data. Its literalValue contains
the source-supplied content as an RDF literal, retaining the available datatype
or language. Text stays text when the source supplies no type; the capture step
must not guess that a string such as "00123" denotes a number. Domain-specific
interpretation belongs to later transformation steps.
Use sourceText when the reader exposes an original textual representation.
For example, literal content 7 and source text "0007" preserve both the
source-supplied numeric value and its textual spelling. Do not fabricate source
text by formatting a parsed value. This field records reader-exposed text, not
the source file's bytes, quoting, or complete spreadsheet formatting.
An empty string, whitespace, zero, and false are values. Explicit source nulls
use NullValue and have no literalValue. A null may retain its source marker
in sourceText. Missing payload metadata is invalid, not an implicit null.
No string, including "NULL", becomes null without the source format or an
explicit capture policy establishing that interpretation. An omitted source
field is not automatically an explicit null occurrence.
ValueContentShape, in this ontology's shapes graph, checks this contract.
OWL models the alternatives and cardinalities; it does not supply missing
content or classify an incomplete occurrence as null.
Migration and scope
Existing Value resources need their captured content or an explicit
NullValue classification. Preserve their identities and references. Recover
content from the original source or the capture application's documented
representation; do not infer content from resource IRIs or reinterpret a
mapped row property as an occurrence without establishing the correspondence.
Each occurrence also requires one valueOf row and one forColumn column.
Rows identify their one view through isRowInView; columns identify theirs
through isColumnInView or inverse hasColumn. The two views must match.
ValueLocationShape, RowLocationShape, and ColumnLocationShape validate
these relationships and belong to the same shapes graph.
Recover column links from the source's physical structure or documented capture metadata. Do not join occurrences to columns by mapped predicate alone: different columns can share a mapping, including columns in different views. Validate the supplied capture context before OWL identity reasoning; functional relationships can equate conflicting owner IRIs rather than rejecting them.
Original headers and view names, view-to-source ownership validation, coordinate constraints, mapping-property semantics, and source-key identity remain separate modeling work.
See the raw-data guide for executable examples, validation, and the remaining work.
ekg-raw:Value | |
https://ekgf.org/ontology/raw#Value | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:Class |
rdfs:label | Value |
rdfs:subClassOf | (rdf:type: owl:Class; owl:unionOf: (ekg-raw:NullValue, (rdf:type: owl:Restriction; owl:minCardinality: 1; owl:onProperty: ekg-raw:literalValue))) |
rdfs:subClassOf | (rdf:type: owl:Restriction; owl:minCardinality: 1; owl:onProperty: ekg-raw:forColumn) |
rdfs:subClassOf | (rdf:type: owl:Restriction; owl:minCardinality: 1; owl:onProperty: ekg-raw:valueOf) |
1.2.10 View§
A tabular or record-oriented view within a captured source, organizing the rows and columns exposed by that source.
ekg-raw:View | |
https://ekgf.org/ontology/raw#View | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:Class |
rdfs:label | View |
1.2.11 XLSX file§
A raw-data file source in the Excel XLSX workbook format.
ekg-raw:XlsxFile | |
https://ekgf.org/ontology/raw#XlsxFile | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:Class |
rdfs:label | XLSX file |
rdfs:subClassOf | ekg-raw:File |
1.3 Properties§
1.3.1 25th percentile§
The 25th percentile of the numeric values of occurrences conforming to a numeric inferred datatype, interpolating linearly between the closest ranks (Hyndman and Fan type 7).
ekg-raw:25pct | |
https://ekgf.org/ontology/raw#25pct | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | 25th percentile |
rdfs:range | xsd:double |
1.3.2 Median§
The 50th percentile (median) of the numeric values of occurrences conforming to a numeric inferred datatype, interpolating linearly between the closest ranks (Hyndman and Fan type 7).
ekg-raw:50pct | |
https://ekgf.org/ontology/raw#50pct | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Median |
rdfs:range | xsd:double |
1.3.3 75th percentile§
The 75th percentile of the numeric values of occurrences conforming to a numeric inferred datatype, interpolating linearly between the closest ranks (Hyndman and Fan type 7).
ekg-raw:75pct | |
https://ekgf.org/ontology/raw#75pct | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | 75th percentile |
rdfs:range | xsd:double |
1.3.4 Column number§
1-based column index
ekg-raw:columnNumber | |
https://ekgf.org/ontology/raw#columnNumber | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Column number |
rdfs:range | xsd:integer |
1.3.5 Conforming value count§
The number of counted occurrences of this column conforming to its inferred datatype. Together with count it gives the share of the column that a later step can cast to that datatype, and identifies how many occurrences need attention.
ekg-raw:conformingCount | |
https://ekgf.org/ontology/raw#conformingCount | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Conforming value count |
rdfs:range | xsd:integer |
1.3.6 Value count§
The number of captured value occurrences for this column (raw:forColumn) that are not NullValue. Header cells are not occurrences and are not counted.
ekg-raw:count | |
https://ekgf.org/ontology/raw#count | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Value count |
rdfs:range | xsd:integer |
1.3.7 File name§
The name of the file as it was passed to the capture step
ekg-raw:fileName | |
https://ekgf.org/ontology/raw#fileName | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:File |
rdfs:label | File name |
rdfs:range | xsd:string |
1.3.8 For column§
Identifies the physical source column of a captured value occurrence. Each occurrence has exactly one column, belonging to the same view as its row. A shared predicate mapping does not establish column identity.
ekg-raw:forColumn | |
https://ekgf.org/ontology/raw#forColumn | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:FunctionalProperty |
rdf:type | owl:ObjectProperty |
rdfs:domain | ekg-raw:Value |
rdfs:label | For column |
rdfs:range | ekg-raw:Column |
1.3.9 For Predicate§
The predicate for which the given value was encountered
ekg-raw:forPredicate | |
https://ekgf.org/ontology/raw#forPredicate | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:ObjectProperty |
rdfs:domain | ekg-raw:Value |
rdfs:label | For Predicate |
1.3.10 Formula§
The spreadsheet formula that computes a captured value occurrence, verbatim in the source's A1 notation and without the leading '='. The value's literalValue is the result the source cached; an occurrence without a cached result is a NullValue that still records its formula.
ekg-raw:formula | |
https://ekgf.org/ontology/raw#formula | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Value |
rdfs:label | Formula |
rdfs:range | xsd:string |
1.3.11 Formula (R1C1)§
A spreadsheet formula in R1C1 notation, with references relative to the cell holding it. On a Value it is that occurrence's formula. On a Column it is the single relative formula shared by every formula occurrence in the column, a derivation rule for the column that later steps can translate into SPARQL or SHACL rules.
ekg-raw:formulaR1C1 | |
https://ekgf.org/ontology/raw#formulaR1C1 | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdfs:domain | (rdf:type: owl:Class; owl:unionOf: (ekg-raw:Value, ekg-raw:Column)) |
rdfs:label | Formula (R1C1) |
rdfs:range | xsd:string |
1.3.12 Most frequent value count§
The number of counted occurrences whose literalValue is the column's top value.
ekg-raw:freq | |
https://ekgf.org/ontology/raw#freq | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Most frequent value count |
rdfs:range | xsd:integer |
1.3.13 Git blob§
The git blob object id, as lowercase hexadecimal, of the captured bytes. It is computed from the content alone, so it is present whether or not the file is in a repository, and equals the id git would assign to the same bytes.
ekg-raw:gitBlob | |
https://ekgf.org/ontology/raw#gitBlob | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:File |
rdfs:label | Git blob |
rdfs:range | xsd:string |
1.3.14 Git commit§
The object id, as lowercase hexadecimal, of the HEAD commit of the repository whose work tree contained the file at capture time. Together with gitPath it locates the file in history; gitModified states whether the captured bytes are the bytes of that commit.
ekg-raw:gitCommit | |
https://ekgf.org/ontology/raw#gitCommit | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:File |
rdfs:label | Git commit |
rdfs:range | xsd:string |
1.3.15 Git modified§
Whether the captured bytes differ from the file at gitPath in gitCommit. True also when the file is untracked in that commit. False means the capture is reproducible from the repository history.
ekg-raw:gitModified | |
https://ekgf.org/ontology/raw#gitModified | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:File |
rdfs:label | Git modified |
rdfs:range | xsd:boolean |
1.3.16 Git path§
The path of the file relative to the root of the repository work tree, using '/' as separator, as git records it.
ekg-raw:gitPath | |
https://ekgf.org/ontology/raw#gitPath | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:File |
rdfs:label | Git path |
rdfs:range | xsd:string |
1.3.17 Git repository§
The fetch URL of the default remote of the git repository whose work tree contained the file at capture time, recorded verbatim. Scp-style remotes such as git@host:org/repo.git are not IRIs, so the URL is a string.
ekg-raw:gitRepository | |
https://ekgf.org/ontology/raw#gitRepository | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:File |
rdfs:label | Git repository |
rdfs:range | xsd:string |
1.3.18 Has column§
Lists a view's physical source columns. A view can contain multiple columns; each column belongs to exactly one view. Columns sharing a mapped predicate retain separate identities.
ekg-raw:hasColumn | |
https://ekgf.org/ontology/raw#hasColumn | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:InverseFunctionalProperty |
rdf:type | owl:ObjectProperty |
rdfs:domain | ekg-raw:View |
rdfs:label | Has column |
rdfs:range | ekg-raw:Column |
owl:inverseOf | ekg-raw:isColumnInView |
1.3.19 Has View§
One Source can have multiple Views
ekg-raw:hasView | |
https://ekgf.org/ontology/raw#hasView | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:InverseFunctionalProperty |
rdf:type | owl:ObjectProperty |
rdfs:domain | ekg-raw:Source |
rdfs:label | Has View |
rdfs:range | ekg-raw:View |
owl:inverseOf | ekg-raw:isViewIn |
1.3.20 Inferred datatype§
A datatype to which conformingCount of the column's counted occurrences conform: their literalValue has this datatype, or its lexical form is valid for it. Which datatypes are considered and what share of conforming occurrences is required are capture policy; conformingCount records the evidence. Captured values keep their source literals.
ekg-raw:inferredDatatype | |
https://ekgf.org/ontology/raw#inferredDatatype | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:FunctionalProperty |
rdf:type | owl:ObjectProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Inferred datatype |
rdfs:range | rdfs:Datatype |
1.3.21 Is column in view§
Identifies the one view containing a physical source column; inverse of hasColumn. Assert either direction or both consistently. Reusing a mapped property does not reuse the column across views.
ekg-raw:isColumnInView | |
https://ekgf.org/ontology/raw#isColumnInView | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:FunctionalProperty |
rdf:type | owl:ObjectProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Is column in view |
rdfs:range | ekg-raw:View |
1.3.22 Is Row In View§
The current row occurs in the given view.
ekg-raw:isRowInView | |
https://ekgf.org/ontology/raw#isRowInView | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:FunctionalProperty |
rdf:type | owl:ObjectProperty |
rdfs:domain | ekg-raw:Row |
rdfs:label | Is Row In View |
rdfs:range | ekg-raw:View |
1.3.23 Is View In§
This View occurs in the given Source
ekg-raw:isViewIn | |
https://ekgf.org/ontology/raw#isViewIn | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:FunctionalProperty |
rdf:type | owl:ObjectProperty |
rdfs:domain | ekg-raw:View |
rdfs:label | Is View In |
rdfs:range | ekg-raw:Source |
1.3.24 Legacy ID§
The values in the key-column in the given view will always be mapped to raw:legacyId
ekg-raw:legacyId | |
https://ekgf.org/ontology/raw#legacyId | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Row |
rdfs:label | Legacy ID |
rdfs:range | xsd:string |
1.3.25 Legacy Id In Iri§
The value of legacyId translated to an IRI-compliant lower kebab-case value
ekg-raw:legacyIdInIri | |
https://ekgf.org/ontology/raw#legacyIdInIri | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:label | Legacy Id In Iri |
1.3.26 Literal value§
The source-supplied content of a captured value occurrence, represented as one RDF literal with its datatype or language retained. An empty string is content; a source null is represented by NullValue without this property.
ekg-raw:literalValue | |
https://ekgf.org/ontology/raw#literalValue | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Value |
rdfs:label | Literal value |
rdfs:range | rdfs:Literal |
1.3.27 Local name§
The local name of the property that this Column is mapped to
ekg-raw:localName | |
https://ekgf.org/ontology/raw#localName | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Local name |
rdfs:range | xsd:string |
1.3.28 Maximum§
The greatest value, in the value space of the inferred datatype, among occurrences conforming to it, written as a literal of that datatype.
ekg-raw:max | |
https://ekgf.org/ontology/raw#max | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Maximum |
rdfs:range | rdfs:Literal |
1.3.29 Mean§
The arithmetic mean of the numeric values of occurrences conforming to a numeric inferred datatype.
ekg-raw:mean | |
https://ekgf.org/ontology/raw#mean | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Mean |
rdfs:range | xsd:double |
1.3.30 Minimum§
The least value, in the value space of the inferred datatype, among occurrences conforming to it, written as a literal of that datatype.
ekg-raw:min | |
https://ekgf.org/ontology/raw#min | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Minimum |
rdfs:range | rdfs:Literal |
1.3.31 Null count§
The number of captured value occurrences for this column that are NullValue.
ekg-raw:nullCount | |
https://ekgf.org/ontology/raw#nullCount | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Null count |
rdfs:range | xsd:integer |
1.3.32 Predicate§
The property that this Column is mapped to. A column is mapped to one property. It is an annotation property because its values are properties, which are not individuals.
ekg-raw:predicate | |
https://ekgf.org/ontology/raw#predicate | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:AnnotationProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Predicate |
rdfs:range | rdf:Property |
1.3.33 Source text§
The original text of a captured value as exposed by the source reader before value normalization, when such text is available. This optional string preserves lexical details independently of literalValue and may record a source's explicit null marker.
ekg-raw:sourceText | |
https://ekgf.org/ontology/raw#sourceText | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Value |
rdfs:label | Source text |
rdfs:range | xsd:string |
1.3.34 Standard deviation§
The sample standard deviation (divisor n - 1) of the numeric values of occurrences conforming to a numeric inferred datatype.
ekg-raw:std | |
https://ekgf.org/ontology/raw#std | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Standard deviation |
rdfs:range | xsd:double |
1.3.35 Most frequent value§
A literalValue occurring most often among the counted occurrences. When several occur equally often, the one whose N-Triples form sorts first by code point.
ekg-raw:top | |
https://ekgf.org/ontology/raw#top | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Most frequent value |
rdfs:range | rdfs:Literal |
1.3.36 Distinct value count§
The number of distinct RDF terms among the literalValue of the counted occurrences; literals with different datatypes or language tags are distinct. Absence means the measure was not computed, not that there are no values.
ekg-raw:unique | |
https://ekgf.org/ontology/raw#unique | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Column |
rdfs:label | Distinct value count |
rdfs:range | xsd:integer |
1.3.37 Value of§
Identifies the one source row at which a value occurrence was captured. The row and the occurrence's forColumn must belong to the same view.
ekg-raw:valueOf | |
https://ekgf.org/ontology/raw#valueOf | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:FunctionalProperty |
rdf:type | owl:ObjectProperty |
rdfs:domain | ekg-raw:Value |
rdfs:label | Value of |
rdfs:range | ekg-raw:Row |
1.3.38 View number§
The 1-based position of a view within its source in the order the source exposes its views, such as the worksheet order of a workbook. A view name is not a stable substitute: names can repeat across sources and change between captures.
ekg-raw:viewNumber | |
https://ekgf.org/ontology/raw#viewNumber | |
| RDF predicate | Value |
|---|---|
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:View |
rdfs:label | View number |
rdfs:range | xsd:integer |
1.3.39 View Row Number§
The 0-based sequence number of the Row in the given View as it was encountered in the Source
ekg-raw:viewRowNumber | |
https://ekgf.org/ontology/raw#viewRowNumber | |
| RDF predicate | Value |
|---|---|
dc:creator | http://orcid.org/0000-0003-2309-5068 |
dc:date | |
rdf:type | owl:DatatypeProperty |
rdf:type | owl:FunctionalProperty |
rdfs:domain | ekg-raw:Row |
rdfs:label | View Row Number |
rdfs:range | xsd:integer |
1.4 Shapes§
1.4.1 Column Location Shape§
Requires each physical source column to belong to one resource view. Counts both membership directions without requiring OWL inverse inference, and covers subclasses and untyped link endpoints.
ekg-raw:ColumnLocationShape | |
https://ekgf.org/ontology/raw#ColumnLocationShape | |
| RDF predicate | Value |
|---|---|
rdf:type | sh:NodeShape |
rdfs:label | Column Location Shape |
sh:nodeKind | sh:BlankNodeOrIRI |
sh:property | (sh:class: ekg-raw:View; sh:maxCount: 1; sh:message: A physical source column must belong to exactly one view, counting isColumnInView and inverse hasColumn together.; sh:minCount: 1; sh:nodeKind: sh:BlankNodeOrIRI; sh:path: (sh:alternativePath: (ekg-raw:isColumnInView, (sh:inversePath: ekg-raw:hasColumn)))) |
sh:targetClass | ekg-raw:Column |
sh:targetObjectsOf | ekg-raw:forColumn |
sh:targetObjectsOf | ekg-raw:hasColumn |
sh:targetSubjectsOf | ekg-raw:isColumnInView |
1.4.2 Column Profile Shape§
Validates a column profile: single-valued measures with precise datatypes, counts bounded by the value count, an inferred datatype together with its evidence, statistics only with an inferred datatype, and ordered extremes and percentiles.
ekg-raw:ColumnProfileShape | |
https://ekgf.org/ontology/raw#ColumnProfileShape | |
| RDF predicate | Value |
|---|---|
rdf:type | sh:NodeShape |
rdfs:label | Column Profile Shape |
sh:class | ekg-raw:Column |
sh:property | (sh:datatype: xsd:integer; sh:maxCount: 1; sh:minInclusive: 0; sh:path: ekg-raw:freq) |
sh:property | (sh:maxCount: 1; sh:nodeKind: sh:IRI; sh:path: ekg-raw:inferredDatatype) |
sh:property | (sh:datatype: xsd:integer; sh:maxCount: 1; sh:minInclusive: 0; sh:path: ekg-raw:unique) |
sh:property | (sh:maxCount: 1; sh:nodeKind: sh:Literal; sh:path: ekg-raw:max) |
sh:property | (sh:maxCount: 1; sh:nodeKind: sh:Literal; sh:path: ekg-raw:min) |
sh:property | (sh:datatype: xsd:double; sh:maxCount: 1; sh:path: ekg-raw:75pct) |
sh:property | (sh:datatype: xsd:double; sh:maxCount: 1; sh:path: ekg-raw:std) |
sh:property | (sh:datatype: xsd:double; sh:maxCount: 1; sh:path: ekg-raw:mean) |
sh:property | (sh:datatype: xsd:integer; sh:maxCount: 1; sh:minInclusive: 0; sh:path: ekg-raw:conformingCount) |
sh:property | (sh:maxCount: 1; sh:nodeKind: sh:Literal; sh:path: ekg-raw:top) |
sh:property | (sh:datatype: xsd:double; sh:maxCount: 1; sh:path: ekg-raw:25pct) |
sh:property | (sh:datatype: xsd:integer; sh:maxCount: 1; sh:minInclusive: 0; sh:path: ekg-raw:nullCount) |
sh:property | (sh:datatype: xsd:integer; sh:maxCount: 1; sh:minInclusive: 0; sh:path: ekg-raw:count) |
sh:property | (sh:datatype: xsd:double; sh:maxCount: 1; sh:path: ekg-raw:50pct) |
sh:sparql | (sh:message: inferredDatatype and conformingCount are stated together.; sh:select: SPARQL SELECT query 1) |
sh:sparql | (sh:message: min, 25pct, 50pct, 75pct and max must be in non-decreasing order.; sh:select: SPARQL SELECT query 2) |
sh:sparql | (sh:message: min, max, mean, std and percentiles describe conforming values and require an inferredDatatype.; sh:select: SPARQL SELECT query 3) |
sh:sparql | (sh:message: top and freq are stated together.; sh:select: SPARQL SELECT query 4) |
sh:sparql | (sh:message: unique, freq and conformingCount cannot exceed count.; sh:select: SPARQL SELECT query 5) |
sh:targetSubjectsOf | ekg-raw:25pct |
sh:targetSubjectsOf | ekg-raw:50pct |
sh:targetSubjectsOf | ekg-raw:75pct |
sh:targetSubjectsOf | ekg-raw:conformingCount |
sh:targetSubjectsOf | ekg-raw:count |
sh:targetSubjectsOf | ekg-raw:freq |
sh:targetSubjectsOf | ekg-raw:inferredDatatype |
sh:targetSubjectsOf | ekg-raw:max |
sh:targetSubjectsOf | ekg-raw:mean |
sh:targetSubjectsOf | ekg-raw:min |
sh:targetSubjectsOf | ekg-raw:nullCount |
sh:targetSubjectsOf | ekg-raw:std |
sh:targetSubjectsOf | ekg-raw:top |
sh:targetSubjectsOf | ekg-raw:unique |
1.4.2.1 SPARQL query 1§
inferredDatatype and conformingCount are stated together.
SELECT $this WHERE {
{ $this <https://ekgf.org/ontology/raw#inferredDatatype> ?t FILTER NOT EXISTS { $this <https://ekgf.org/ontology/raw#conformingCount> ?c } }
UNION
{ $this <https://ekgf.org/ontology/raw#conformingCount> ?c FILTER NOT EXISTS { $this <https://ekgf.org/ontology/raw#inferredDatatype> ?t } }
}
1.4.2.2 SPARQL query 2§
min, 25pct, 50pct, 75pct and max must be in non-decreasing order.
SELECT $this WHERE {
{ $this <https://ekgf.org/ontology/raw#min> ?a ; <https://ekgf.org/ontology/raw#25pct> ?b }
UNION
{ $this <https://ekgf.org/ontology/raw#25pct> ?a ; <https://ekgf.org/ontology/raw#50pct> ?b }
UNION
{ $this <https://ekgf.org/ontology/raw#50pct> ?a ; <https://ekgf.org/ontology/raw#75pct> ?b }
UNION
{ $this <https://ekgf.org/ontology/raw#75pct> ?a ; <https://ekgf.org/ontology/raw#max> ?b }
UNION
{ $this <https://ekgf.org/ontology/raw#min> ?a ; <https://ekgf.org/ontology/raw#max> ?b }
FILTER (?b < ?a)
}
1.4.2.3 SPARQL query 3§
min, max, mean, std and percentiles describe conforming values and require an inferredDatatype.
SELECT $this WHERE {
$this <https://ekgf.org/ontology/raw#min>|<https://ekgf.org/ontology/raw#max>|<https://ekgf.org/ontology/raw#mean>|<https://ekgf.org/ontology/raw#std>|<https://ekgf.org/ontology/raw#25pct>|<https://ekgf.org/ontology/raw#50pct>|<https://ekgf.org/ontology/raw#75pct> ?stat .
FILTER NOT EXISTS { $this <https://ekgf.org/ontology/raw#inferredDatatype> ?t }
}
1.4.2.4 SPARQL query 4§
top and freq are stated together.
SELECT $this WHERE {
{ $this <https://ekgf.org/ontology/raw#top> ?t FILTER NOT EXISTS { $this <https://ekgf.org/ontology/raw#freq> ?f } }
UNION
{ $this <https://ekgf.org/ontology/raw#freq> ?f FILTER NOT EXISTS { $this <https://ekgf.org/ontology/raw#top> ?t } }
}
1.4.2.5 SPARQL query 5§
unique, freq and conformingCount cannot exceed count.
SELECT $this WHERE {
$this <https://ekgf.org/ontology/raw#count> ?count .
$this <https://ekgf.org/ontology/raw#unique>|<https://ekgf.org/ontology/raw#freq>|<https://ekgf.org/ontology/raw#conformingCount> ?part .
FILTER (?part > ?count)
}
1.4.3 Formula R1C1 Shape§
Validates relative R1C1 formulas on value occurrences and the single shared derivation rule of a column.
ekg-raw:FormulaR1C1Shape | |
https://ekgf.org/ontology/raw#FormulaR1C1Shape | |
| RDF predicate | Value |
|---|---|
rdf:type | sh:NodeShape |
rdfs:label | Formula R1C1 Shape |
sh:message | formulaR1C1 belongs to a captured value occurrence or to a column whose formulas share one relative form. |
sh:or | ((sh:class: ekg-raw:Value), (sh:class: ekg-raw:Column)) |
sh:property | (sh:datatype: xsd:string; sh:maxCount: 1; sh:message: A value or column has at most one relative R1C1 formula, a string.; sh:path: ekg-raw:formulaR1C1) |
sh:targetSubjectsOf | ekg-raw:formulaR1C1 |
1.4.4 Formula Shape§
Validates verbatim spreadsheet formulas on captured value occurrences.
ekg-raw:FormulaShape | |
https://ekgf.org/ontology/raw#FormulaShape | |
| RDF predicate | Value |
|---|---|
rdf:type | sh:NodeShape |
rdfs:label | Formula Shape |
sh:class | ekg-raw:Value |
sh:property | (sh:datatype: xsd:string; sh:maxCount: 1; sh:message: A value has at most one formula: a non-empty string in A1 notation without the leading '='.; sh:path: ekg-raw:formula; sh:pattern: ^[^=]) |
sh:targetSubjectsOf | ekg-raw:formula |
1.4.5 Git Origin Shape§
Validates the git provenance of a captured file: object id syntax, a relative path, and that a commit is always accompanied by the path and modification state needed to reproduce the capture.
ekg-raw:GitOriginShape | |
https://ekgf.org/ontology/raw#GitOriginShape | |
| RDF predicate | Value |
|---|---|
rdf:type | sh:NodeShape |
rdfs:label | Git Origin Shape |
sh:message | A file in a repository records gitCommit, gitPath and gitModified together; gitRepository requires them. gitBlob alone is valid outside a repository. |
sh:or | ((sh:property: (sh:maxCount: 0; sh:path: ekg-raw:gitRepository); sh:property: (sh:maxCount: 0; sh:path: ekg-raw:gitPath); sh:property: (sh:maxCount: 0; sh:path: ekg-raw:gitModified); sh:property: (sh:maxCount: 0; sh:path: ekg-raw:gitCommit)), (sh:property: (sh:minCount: 1; sh:path: ekg-raw:gitPath); sh:property: (sh:minCount: 1; sh:path: ekg-raw:gitCommit); sh:property: (sh:minCount: 1; sh:path: ekg-raw:gitModified))) |
sh:property | (sh:datatype: xsd:string; sh:maxCount: 1; sh:message: gitBlob is one lowercase hexadecimal SHA-1 or SHA-256 object id.; sh:path: ekg-raw:gitBlob; sh:pattern: ^([0-9a-f]{40}|[0-9a-f]{64})$) |
sh:property | (sh:datatype: xsd:string; sh:maxCount: 1; sh:message: gitCommit is one lowercase hexadecimal SHA-1 or SHA-256 object id.; sh:path: ekg-raw:gitCommit; sh:pattern: ^([0-9a-f]{40}|[0-9a-f]{64})$) |
sh:property | (sh:datatype: xsd:string; sh:maxCount: 1; sh:message: gitPath is one work-tree-relative path using '/' separators.; sh:path: ekg-raw:gitPath; sh:pattern: ^[^/\\][^\\]*$) |
sh:property | (sh:datatype: xsd:string; sh:maxCount: 1; sh:path: ekg-raw:gitRepository) |
sh:property | (sh:datatype: xsd:boolean; sh:maxCount: 1; sh:path: ekg-raw:gitModified) |
sh:targetSubjectsOf | ekg-raw:gitBlob |
sh:targetSubjectsOf | ekg-raw:gitCommit |
sh:targetSubjectsOf | ekg-raw:gitModified |
sh:targetSubjectsOf | ekg-raw:gitPath |
sh:targetSubjectsOf | ekg-raw:gitRepository |
1.4.6 Row Location Shape§
Requires each supplied source row to identify one resource view, including subclasses and untyped row-link endpoints. Coordinate bounds and view-to-source ownership are separate constraints.
ekg-raw:RowLocationShape | |
https://ekgf.org/ontology/raw#RowLocationShape | |
| RDF predicate | Value |
|---|---|
rdf:type | sh:NodeShape |
rdfs:label | Row Location Shape |
sh:nodeKind | sh:BlankNodeOrIRI |
sh:property | (sh:class: ekg-raw:View; sh:maxCount: 1; sh:message: A source row must belong to exactly one view through isRowInView.; sh:minCount: 1; sh:nodeKind: sh:BlankNodeOrIRI; sh:path: ekg-raw:isRowInView) |
sh:targetClass | ekg-raw:Row |
sh:targetObjectsOf | ekg-raw:valueOf |
sh:targetSubjectsOf | ekg-raw:isRowInView |
1.4.7 Value Content Shape§
Validates the content of raw value occurrences, including subclasses and untyped resources using capture properties. Accepts typed and language-tagged literals and empty strings, distinguishes explicit source nulls, and checks optional original source text. Location constraints are enforced separately by ValueLocationShape, RowLocationShape, and ColumnLocationShape.
ekg-raw:ValueContentShape | |
https://ekgf.org/ontology/raw#ValueContentShape | |
| RDF predicate | Value |
|---|---|
rdf:type | sh:NodeShape |
rdfs:label | Value Content Shape |
sh:message | A captured value must have exactly one literalValue or be explicitly typed NullValue without a literalValue. Source text alone does not supply the content. |
sh:nodeKind | sh:BlankNodeOrIRI |
sh:property | (sh:datatype: xsd:string; sh:maxCount: 1; sh:path: ekg-raw:sourceText) |
sh:targetClass | ekg-raw:Value |
sh:targetSubjectsOf | ekg-raw:forColumn |
sh:targetSubjectsOf | ekg-raw:forPredicate |
sh:targetSubjectsOf | ekg-raw:literalValue |
sh:targetSubjectsOf | ekg-raw:sourceText |
sh:targetSubjectsOf | ekg-raw:valueOf |
sh:xone | ((sh:class: ekg-raw:NullValue; sh:property: (sh:maxCount: 0; sh:path: ekg-raw:literalValue)), (sh:not: (sh:class: ekg-raw:NullValue); sh:property: (sh:maxCount: 1; sh:minCount: 1; sh:nodeKind: sh:Literal; sh:path: ekg-raw:literalValue))) |
1.4.8 Value Location Shape§
Requires one resource row and one resource column for each captured value, including nulls, and rejects row/column view mismatches. Predicate mappings cannot substitute for physical column links.
ekg-raw:ValueLocationShape | |
https://ekgf.org/ontology/raw#ValueLocationShape | |
| RDF predicate | Value |
|---|---|
rdf:type | sh:NodeShape |
rdfs:label | Value Location Shape |
sh:nodeKind | sh:BlankNodeOrIRI |
sh:property | (sh:class: ekg-raw:Column; sh:maxCount: 1; sh:message: A captured value must identify exactly one physical source column through forColumn.; sh:minCount: 1; sh:nodeKind: sh:BlankNodeOrIRI; sh:path: ekg-raw:forColumn) |
sh:property | (sh:class: ekg-raw:Row; sh:maxCount: 1; sh:message: A captured value must identify exactly one source row through valueOf.; sh:minCount: 1; sh:nodeKind: sh:BlankNodeOrIRI; sh:path: ekg-raw:valueOf) |
sh:sparql | (sh:message: A captured value's row and column must belong to the same view.; sh:select: SPARQL SELECT query 1) |
sh:targetClass | ekg-raw:Value |
sh:targetSubjectsOf | ekg-raw:forColumn |
sh:targetSubjectsOf | ekg-raw:forPredicate |
sh:targetSubjectsOf | ekg-raw:literalValue |
sh:targetSubjectsOf | ekg-raw:sourceText |
sh:targetSubjectsOf | ekg-raw:valueOf |
1.4.8.1 SPARQL query 1§
A captured value's row and column must belong to the same view.
SELECT $this WHERE {
$this <https://ekgf.org/ontology/raw#valueOf>/<https://ekgf.org/ontology/raw#isRowInView> ?rowView .
$this <https://ekgf.org/ontology/raw#forColumn>/(<https://ekgf.org/ontology/raw#isColumnInView>|^<https://ekgf.org/ontology/raw#hasColumn>) ?columnView .
FILTER (?rowView != ?columnView)
}
1.4.9 View Number Shape§
Validates the 1-based position of a view within its source.
ekg-raw:ViewNumberShape | |
https://ekgf.org/ontology/raw#ViewNumberShape | |
| RDF predicate | Value |
|---|---|
rdf:type | sh:NodeShape |
rdfs:label | View Number Shape |
sh:property | (sh:datatype: xsd:integer; sh:maxCount: 1; sh:message: A view has at most one viewNumber, a positive xsd:integer.; sh:minInclusive: 1; sh:path: ekg-raw:viewNumber) |
sh:targetSubjectsOf | ekg-raw:viewNumber |