About

Sparkle is a graphical SPARQL editor application used to help its users with creation and evaluation of SPARQL queries. The graphical SPARQL query editor is an interactive JavaFX open source application.

Sparkle main window.

Features

  • SPARQL 1.0 and 1.1 support
    • SELECT, ASK, CONSTRUCT, DESCRIBE
    • WITH-DELETE-INSERT-USING, INSERT DATA, DELETE DATA
    • BIND, GRAPH, FILTER, HAVING, OPTIONAL, UNION, VALUES
    • sub-query is supported for SELECT
      • the sub-query can be tested separately
      • sub-query is stored as a part of original query
    • SELECT DISTINCT or REDUCED,
    • GRAPH, OPTIONAL, UNION, MINUS, FILTER EXIST, FILTER NOT EXIST are implemented as group modifiers (first, create a group)
    • ORDER BY with variable or expression, ASC/DESC optional
    • functions support
    • LIMIT, OFFSET
    • aggregation functions AVG, COUNT, SUM, MIN, MAX, GROUP_CONCAT, SAMPLE
    • property paths
    • no support for the BASE keyword – instead you can use prefixes
  • property search
  • auto-fill property path (property search)
  • data/graph source:
    • file system (local)
    • OpenLink Virtuoso or Virtuoso Universal Server
    • Oracle Database with Semantic Technologies support – removed in 2015-02-12
    • SPARQL Endpoint -- work in progress
  • straight SPARQL evaluation
    • can cancel SPARQL evaluation (if data source this feature),
  • clean graph (data model)
    • remove all triples
  • can clean active graph or data model
  • visualization of the query results
    • sorting
    • full-text filter
  • configuration management
    • configuration on level
      • application
      • or query
    • configuration content
      • data types
      • functions
      • prefixes
      • resources

Input and output format support

  • import/export SPARQL from/to a text file
    • can contain comments (#, /* */),
  • save or open queries to/from the Sparkle's file
    • format Sparkle Query File (SQF)
    • it is useful for later use
    • with locally defined data types, functions, etc.
    • a proper way how to transfer and open to a different machine with e.g. prefixes for name spaces pre-defined.
  • import RDF data to the graph (data model)
    • RDF/XML (*.rdf, *.xml)
    • OWL (*.owl)
    • N3 (*.n3)
    • N-TRIPLE (*.nt)
    • TURTLE (*.ttl)
  • view and export (save) query output
    • SELECT
      • view as table with columns,
      • CSV (RFC 4180 CSV),
      • CSV (Microsoft Excel compatible),
    • CONSTRUCT and DESCRIBE
      • RDF/XML (*.rdf, *.xml),
      • OWL (*.owl),
      • N3 (*.n3),
      • N-TRIPLE (*.nt),
      • TURTLE (*.ttl).

Credits

  • Petr Vcelak, maintainer and developer from 2013,
  • Klara Hlavacova, developer from 2017,
  • Josef Kazak, developer from 2016 to 2017,
  • Michel Sobehart, developer from 2015 to 2016,
  • Jan Smucr, developer from 2013 to 2014.

Contact

You can contact Petr Vcelak for more information.

Acknowledgment

This research was supported by the project PUNTIS (LO1506) of the Ministry of Education, Youth and Sports of the Czech Republic.

This research was supported by the IGA NT13326 grant of Ministry of Health of the Czech Republic, 2012–2015.