lumii-syslab / viziquer Goto Github PK

View Code? Open in Web Editor NEW

12.0 7.0 4.0 14.26 MB

Tool for Search in Structured Semantic Data

Home Page: http://viziquer.lumii.lv/

License: MIT License

CSS 0.78% JavaScript 87.13% HTML 9.04% Dockerfile 0.01% PEG.js 3.05%

rdf sparql sparql-query-builder graphical query-builder query-language triplestore linked-data linkeddata virtuoso

viziquer's Introduction

ViziQuer

The aim of the ViziQuer project is to provide visual/diagrammatic environment for ontology-based data query definition and execution.

See https://viziquer.lumii.lv for the tool description.

See the ViziQuer wiki for information on getting started and using ViziQuer.

Acknowledgements

The ViziQuer tool has been developed at Institute of Mathematics and Computer Science, University of Latvia, https://lumii.lv, with partial support from Latvian Science Council project lzp-2021/1-0389 "Visual Queries in Distributed Knowledge Graphs" (since 2022).

Context

For the use with the data shape server (DSS), the DSS server needs to be installed/accessible, as well (put the link in .env file, following the pattern given in sample.env).

See https://github.com/LUMII-Syslab/data-shape-server

The DSS shall need a link to a PostgreSQL database, holding the data schemas for the endpoints to be queried.

The sample schemas are available; means for their creation are described at https://viziquer.lumii.lv

Installation

You can choose between running ViziQuer locally (from source) and running ViziQuer within a Docker environment (upcoming for the DSS version)

To setup ViziQuer locally

Download and install Meteor framework, follow instructions: https://www.meteor.com/install
Perform git clone for this repository.
Change to the ./viziquer/app directory.
Execute the command meteor npm ci to install the required node packages.
Now to run the ViziQuer tool, type meteor in the ViziQuer directory. To run on a specific port, type, for example, meteor --port 4000.
Open the web browser and type localhost:3000 (default port: 3000) or with the specified port localhost:4000

Configuration for the first use

The first user that signs up to the tool instance shall get administrator rights (the rights to manage tool configurations)

Docker Environment Notes (currently applies to ViziQuer/web classic only)

To run ViziQuer within a Docker environment on MacOs or Linux

Download, install and start Docker: https://docs.docker.com/install/
Start the tool by docker-compose -f docker-compose-public.yml up.
Open browser and type localhost:80.

To run ViziQuer within a Docker environment on Windows

Download, install and start Docker: https://docs.docker.com/install/
Create a volume for Mongo DB before the first use: docker volume create --name=vqdata (to avoid issues of Mongo DB not working from a shared Windows folder).
Start the tool by docker-compose -f docker-compose-windows.yml up.
Open browser and type localhost:80.

viziquer's People

Contributors

Stargazers

Watchers

Forkers

istinkevics mikehenrichs voicis dmitry-kosarevsky99

viziquer's Issues

Can't create a diagram with a Docker image

I run the app as described here,
opened the localhost, signed up and logged in,
created and opened a project.

And at this point, I don't see how I should create a diagram. Is it a bug or am I missing something?

Browsers: Firefox 68.0.2 and Google Chrome 76.0.3809.132

Test issue environment

This is to test the issue environment

Wikidata Q12 is buggy

https://viziquer.lumii.lv/examples/wikidata2022/SPARQL_to_ViziQuer_wikidata.pdf

# ID = 12,
# Question = Recent events
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?event ?date ?eventLabel WHERE{
 ?event wdt:P31/wdt:P279* wd:Q1190554.
 OPTIONAL{?event wdt:P585 ?date.}
 OPTIONAL{?event wdt:P580 ?date.}
 OPTIONAL{?event rdfs:label ?eventLabel. FILTER(LANG(?eventLabel) = 'en')}
 BIND(NOW()-?date AS ?distance)
 FILTER(BOUND(?date) && DATATYPE(?date) =xsd:dateTime)
 FILTER(0 <= ?distance && ?distance < 31) }
LIMIT 10

This query is buggy:

it will skip events that have both wdt:P585 and wdt:P580 but they disagree
if an event has multiple values for the date fields (and none is Deprecated nor Preferred), it will be returned multiple times same. See the query below (/wdt:P279* removed because it causes a timeout)

select ?event ?eventLabel ?date1 ?date2 {
   ?event wdt:P31 wd:Q1190554.
   ?event wdt:P585 ?date1,?date2.
   filter(?date1<?date2)
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} limit 10

The bugs come from the original WD query

Viziquer integration with FAAS

FAAS stands for "Fast Approximate Autocompletion for SPARQL" and it is thoroughly explained under the page at https://aidanhogan.com/docs/sparql-autocompletion.pdf.

The aim of this ticket:

integrate Viziquer with FAAS
take "dss-based-schemata" branch as a starting point
in the initial stage it is acceptable to make a call to FAAS directly from Viziquer without involving data-shape-server
in the initial stage only Wikidata endpoints is targeted. Optionally DBpedia to be included
expected functionality:
- query instances by class name
- query instance by incoming and outgoing attributes
- query properties by property

Creating the first account don't work and Viziquer cannot be used locally

Hi, I have tried to start Viziquer locally

I used the docker-compose-public.yml file as instructed in the README, I run Ubuntu 20.04, with Docker version 20.10.8

I entered my email when signing up as the first user, it is now asking for email confirmation, but it did not send an email tot he address I entered. It was quite surprising to meet this step, since there is no public instance of this service, and even the demos I saw were using local deployment of Viziquer (and I have never seen a service deployed locally that also requires to confirm email)

Unfortunately I did not received any email (I also checked my junks folder, but I guess I need to configure a local email server so that the local Viziquer can send an email for the confirmation.)

How can this email verification be disabled or fixed? Note that ultimately the goal is to be able to deploy and use Viziquer