Re: semsheets

I can also mention the SKOS Play generic XLS to RDF converter :
https://skos-play.sparna.fr/play/convert and separate lib project here :
https://github.com/sparna-git/xls2rdf
Online or command-line, free, documented, example provided, no external
mapping file required (mapping is expressed through a "magic-line" in the
Excel sheet). Works with online Google Sheets, too. It also have a (for the
moment not documented) API so you can get a direct link to an RDF
representation of online Google Sheets http://
...api...xls2rdf/convert?urlhttp://myExcelFileOrGoogleSheet
Handy for manual migration of tabular data, or to create Excel templates to
manually define e.g. SKOS hierarchies, SHACL definitions, even simple OWL
ontologies, etc.
Used for some years in the creation of fairly complex knowledge graphs.

I think YARRRML, already mentioned, is the closest to what you are looking
for as a generic mapping language.

CSV on the Web (CSVW) also defines a mapping language :
https://www.w3.org/TR/tabular-data-primer/, but lacking proper
implementations ATM, I think.

Thomas

Le mer. 23 févr. 2022 à 13:07, David Chaves <dchaves@fi.upm.es> a écrit :

> Hi,
>
> Under the W3C Community Group on Knowledge Graph Construction (
> https://w3id.org/kg-construct), we are making the effort to collect all
> these tools/languages specifications/resources for performing these kinds
> of tasks (currently, it is mainly based on R2RML and its extensions but of
> course, it's open to any other tool).
>
> You should visit https://github.com/kg-construct/awesome-kgc-tools to
> have an overview of all of them, and we are open to receive updates/PR from
> anyone! Additionally, for more detailed information on each resource, you
> may also take a look at https://github.com/kg-construct/resources
>
> Best regards,
> David
>
> [image: UNIVERSIDAD POLITÉCNICA DE MADRID] <https://www.upm.es/>
>
> David Chaves-Fraga
> Postdoctoral Researcher
> Escuela Técnica Superior de Ingenieros Informáticos
> Ontology Engineering Group
> Calle de Los Ciruelos S/N.
> 28660, Boadilla del Monte, Madrid SPAIN
> ✉ david.chaves@upm.es
> ✆ +34 627 31 72 15 <+34-627-31-72-15>
> Aviso / Disclaimer <https://www.upm.es/disclaimer> 🌳 🌳 Piensa antes de
> imprimir.
>
> On 23 Feb 2022, at 12:27, Martynas Jusevičius <martynas@atomgraph.com>
> wrote:
>
> Hi,
>
> For CSV, in addition to TARQL there's also CSV2RDF which uses a
> slightly different processing model and query forms:
> https://github.com/AtomGraph/CSV2RDF
>
> For XML, definitely XSLT, version 3.0 if it's available to you. With
> it you can even do streaming transformations, which is pretty much
> impossible otherwise.
>
> Martynas
> atomgraph.com
>
> On Wed, Feb 23, 2022 at 12:22 PM Christian Chiarcos
> <christian.chiarcos@web.de> wrote:
>
>
> Hi,
>
> as far as CSV data is concerned, TARQL (https://tarql.github.io/) is a
> great tool as it allows you to do transformations with SPARQL, and whatever
> relational data you have, it can be trivially exported to CSV. In that
> case, no specific standard (other than SPARQL) needed.
>
> For tree/XML, I guess most people just resort to XSL. It is possible, of
> course, to use a generic XSL template to just encode the XML data model in
> RDF and then run SPARQL updates over that. But this isn't ideal because the
> raw RDF dump is too raw, so I guess we won't have a fully generic
> alternative to resource-specific XSL scripts any time soon.
>
> For tree/JSON, JSON-LD contexts are more or less what you're asking for.
> Wrt. XML conversion, you can also convert XML to JSON and then provide the
> contexts.
>
> For plain text, there are some extractor frameworks, but an easy
> stylesheet isn't feasible, as you need to configure language-specific
> processing modules.
>
> NB: We are currently in the process of bundling a number of converter
> frameworks and subsequent SPARQL transformations into compact workflows,
> see https://github.com/Pret-a-LLOD/Fintan (still in progress, final
> release by end of June this year). Our specific goal is to apply this to
> data in NLP, but general-purpose converters are included as well, so you
> can at least run the XSL+SPARQL and TARQL/CSV+SPARQL transformations.
>
> Best,
> Christian
>
> Am Mi., 23. Feb. 2022 um 08:10 Uhr schrieb Hans-Jürgen Rennau <
> hjrennau@gmail.com>:
>
>
> Hello,
>
> I am interested in the transformation of non-RDF data into RDF data and I
> am puzzled, nay, haunted by a simple analogy. We have stylesheets for
> defining visual representation of data in a convenient, standardized way.
> Could we not have "semsheets" for defining semantic representation of data
> in a convenient, standardized way?
>
> I admit the oversimplification: CSS stylesheets are designed to work with
> HTML, a scope sufficient for practical purposes. Whereas "non-RDF data" is
> by definition a broad spectrum of media types, so the uniformity of a
> single "semsheet language" may not be attainable. But how about approaching
> the goal, based on an appropriate partitioning of data sources? For example:
>
> (1) Relational data
> (2) Tree-structured data
> (3) Other
>
> Tree-structured data comprises most structured data except for graph data
> - JSON, XML, HTML, CSV, .... And concerning "other", what comes to my mind
> is (i) unstructured text and (ii) non-RDF graph data.
>
> So keeping this partitioning in mind, how about standards, frameworks,
> tools enabling customized mapping of data to RDF?
>
> What I am aware of is very little:
>
> (1) relational data: R2RML [1], ?
> (2) tree-structured data: RML [2], ?
> (3) other: ?
>
> Note that I did not mention RDFa, as it is about embedding, rather than
> writing mapping documents, nor GRDDL, as it is about finding a mapping
> document, not its content.
>
> I am convinced that there are quite a few other standards, frameworks and
> tools which should be listed above, replacing the "?".
>
> Can you help me to find them? Any links, thoughts, comments highly
> appreciated. (And should you think the partitioning is faulty, please share
> your criticism. The same applies to the very quest for common, standardized
> mapping languages.)
>
> Thank you! With kind regards,
> Hans-Jürgen Rennau
>
> [1] https://www.w3.org/TR/r2rml/
> [2] https://rml.io/specs/rml/
>
>
>
>

-- 

*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