W3C home > Mailing lists > Public > semantic-web@w3.org > August 2017

Re: Schema (ontology) for describing database records

From: Thomas Francart <thomas.francart@sparna.fr>
Date: Wed, 30 Aug 2017 13:00:40 +0200
Message-ID: <CAPugn7UZO-C5LR9KiE=MkHzvHA1WU+SeWQaQLh2AW__o9a1AdA@mail.gmail.com>
To: Mikael Pesonen <mikael.pesonen@lingsoft.fi>
Cc: Semantic Web <semantic-web@w3.org>
Hello Mikael

An approach I have used in a project with the similar problematic is the
following (basically you have 2 ressources, 1 to identify the file, 1 to
identify the record, connected with a foaf:primaryTopic - the idea is to
say that the file is the primary topic of the record) :

# record with date of insert in the triplestore
_:Record1 a foaf:Document .
_:Record1 dcterms:created "2017-02-03" .
_:Record1 dcterms:creator "user of the system" .
_:Record1 foaf:primaryTopic _:File1 .
# file with date of creation of the file
_:File1 a foaf:Document .
_:File1 foaf:name "document1.docx" .
_:File1 dcterms:created "2010-08-01" .
_:File1 dcterms:creator "author of the file" .


Online example : record : https://www.nakala.fr/page/resource/11280/c7fb4f7d,
file https://www.nakala.fr/page/data/11280/c7fb4f7d.

Hope this helps
Thomas




2017-08-29 16:40 GMT+02:00 Mikael Pesonen <mikael.pesonen@lingsoft.fi>:

> Hi,
>
> hope this is a correct forum to ask for help.
>
> We are using Dublin Core and NEPOMUK schemas to describe files of a
> Windows network drive (document1.docx, image1.jpg...). Metadata is stored
> in a triplestore.
>
> Anyone know if there is a schema to describe the records in the
> triplestore? Or should we model the data in a way that Dublin Core can be
> used to describe both the files and the records containing the metadata of
> the files?
>
> For example:
>
> We are using dcterms:created to describe the date when a text document was
> created. So we we would need a some-schema:created to describe when the
> metadata of that document was stored in the triplestore.
>
> Br,
>
> --
> Lingsoft - 30 years of Leading Language Management
>
> www.lingsoft.fi
>
> Speech Applications - Language Management - Translation - Reader's and
> Writer's Tools - Text Tools - E-books and M-books
>
> Mikael Pesonen
> System Engineer
>
> e-mail: mikael.pesonen@lingsoft.fi
> Tel. +358 2 279 3300
>
> Time zone: GMT+2
>
> Helsinki Office
> Eteläranta 10
> FI-00130 Helsinki
> FINLAND
>
> Turku Office
> Kauppiaskatu 5 A
> FI-20100 Turku
> FINLAND
>
>
>
>


-- 

*Thomas Francart* -* SPARNA*
Web de *données* | Architecture de l'*information* | Accès aux
*connaissances*
blog : blog.sparna.fr, site : sparna.fr, linkedin :
fr.linkedin.com/in/thomasfrancart
tel :  +33 (0)6.71.11.25.97, skype : francartthomas
Received on Wednesday, 30 August 2017 11:01:33 UTC

This archive was generated by hypermail 2.3.1 : Wednesday, 30 August 2017 11:01:40 UTC