## page was renamed from Aqqu
= Aqqu =

== Description ==

Question answering from Freebase as described in the [[http://ad-publications.informatik.uni-freiburg.de/CIKM_freebase_qa_BH_2015.pdf|CIKM 2015]] publication. 

== Code ==

Public !GitHub repository: https://github.com/elmar-haussmann/aqqu .

Internal git repository (contains work after publication, mainly neural net and performance improvements): https://bitbucket.org/elmar-haussmann/aqqu .

Internal git repository for the web-UI (we didn't put that public): https://bitbucket.org/elmar-haussmann/aqqu-webserver .

== Demo ==

=== Aqqu instance ===

2016-06-30: runs under http://metropolis.informatik.uni-freiburg.de:5455

Start as follows on metropolis:

{{{
sudo su haussmae
cd /home/haussmae/demos/aqqu-demo
source activate aqqu
PYTHONPATH=$(pwd):$PYTHONPATH python
webserver/translation_webserver.py
}}}

=== Virtuoso instance ===

2016-06-30: Virtuoso instance for Aqqu runs unter http://metropolis.informatik.uni-freiburg.de:9000/sparql .

Start it as follows (kill old process manually):

{{{
ssh metropolis
sudo su haussmae
cd /home/haussmae/keyword-translation
make start-varnish
}}}

Grant access rights via the ISQL tool as follows:

{{{
data/virtuoso/install/bin/isql localhost:1112 dba dba
grant execute on SPARQL_INSERT_DICT_CONTENT to SPARQL_UPDATE;
grant execute on SPARQL_INSERT_DICT_CONTENT to "SPARQL”;
grant execute on SPARQL_DELETE_DICT_CONTENT to SPARQL_UPDATE;
grant execute on SPARQL_DELETE_DICT_CONTENT to "SPARQL”;
}}}

Complex example SPARQL query from "Programmieren in C++, SS 2016, Ü10 (all action or animation movie with their release date, genre, director, production company, and rating):

{{{
PREFIX fb: <http://rdf.freebase.com/ns/>
 SELECT DISTINCT ?fn, ?y, ?gn, ?dn, ?pn, ?rn where {
 ?f fb:type.object.type fb:film.film .
 ?f fb:film.film.initial_release_date ?y .
 ?f fb:film.film.genre ?g .
 ?f fb:film.film.directed_by ?d .
 ?f fb:film.film.production_companies ?p .
 ?f fb:film.film.rating ?r .
 ?f fb:type.object.name ?fn .
 ?g fb:type.object.name ?gn .
 ?d fb:type.object.name ?dn .
 ?p fb:type.object.name ?pn .
 ?r fb:type.object.name ?rn
 FILTER(lang(?fn)='en')
 FILTER(lang(?gn)='en')
 FILTER(lang(?dn)='en')
 FILTER(lang(?pn)='en')
 FILTER(lang(?rn)='en')
 FILTER(?gn='Action Film'@en OR ?gn='Animation'@en)
}
}}}