{"queryCatalog":[{"user":"admin","sparqlQuery":{"queryID":"EditiondPerMonthYear","queryDescription":"","queryCode":"PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX time: <http://www.w3.org/2006/time#>\nPREFIX swrlb: <http://www.w3.org/2003/11/swrlb#>\nPREFIX swrl: <http://www.w3.org/2003/11/swrl#>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\nPREFIX : <http://www.obdasystems.com/books/>\n\nselect (count(?x) as ?tot) ?d_year ?m_year where {\n  select ?x (year(?d) as ?d_year) (month(?d) as ?m_year) where {\n    ?x a :Edition.\n    ?x :dateOfPublication ?d.\n  }\n}\ngroup by ?d_year ?m_year","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"AudioBooksDuration","queryDescription":"","queryCode":"PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX time: <http://www.w3.org/2006/time#>\nPREFIX swrlb: <http://www.w3.org/2003/11/swrlb#>\nPREFIX swrl: <http://www.w3.org/2003/11/swrl#>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\nPREFIX : <http://www.obdasystems.com/books/>\n\nselect \n\t?ab \n\t?t\n\t?s\n\t(floor(?s / 3600) as ?hour)\n\t(floor((?s - floor(?s / 3600) * 3600) / 60) as ?minutes)\n\t(?s - (floor(?s / 3600) * 3600) - (floor((?s - floor(?s / 3600) * 3600) / 60) * 60) as ?seconds)\n\n{\n  ?ab :durationInSeconds ?s.\n  ?ab ^:hasEdition ?b.\n  ?b :title ?t.\n}","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"AllBooks","queryDescription":"","queryCode":"PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX time: <http://www.w3.org/2006/time#>\nPREFIX swrlb: <http://www.w3.org/2003/11/swrlb#>\nPREFIX swrl: <http://www.w3.org/2003/11/swrl#>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\nPREFIX : <http://www.obdasystems.com/books/>\n\nSELECT distinct ?x {\n  ?x a :Book.\n}","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"PenName","queryDescription":"","queryCode":"PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX time: <http://www.w3.org/2006/time#>\nPREFIX swrlb: <http://www.w3.org/2003/11/swrlb#>\nPREFIX swrl: <http://www.w3.org/2003/11/swrl#>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\nPREFIX : <http://www.obdasystems.com/books/>\n\nselect distinct ?x ?t ?n ?penName {\n  ?x a :Book;\n     :title ?t;\n     :writtenBy ?a.\n  ?a ^:actAsAuthor ?p.\n  ?p :name ?n.\n  optional{?a :penName ?penName.}\n}","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"LenzeriniLastRevisions","queryDescription":"","queryCode":"PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX time: <http://www.w3.org/2006/time#>\nPREFIX swrlb: <http://www.w3.org/2003/11/swrlb#>\nPREFIX swrl: <http://www.w3.org/2003/11/swrl#>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\nPREFIX : <http://www.obdasystems.com/books/>\n\nselect distinct ?lastRevisionDate ?t ?topic {\n  ?b :hasBookRevision ?rev1.\n  ?b :hasBookRevision ?rev2.\n  ?b :scientificTopic ?topic.\n  ?rev1 :scientificBookRevisionDate ?lastRevisionDate.\n  ?rev2 :scientificBookRevisionDate ?previousRevisionDate.\n  ?b :writtenBy ?a.\n  ?b :title ?t.\n  ?a ^:actAsAuthor ?p.\n  ?p :name \"Maurizio Lenzerini\".\n  filter(?lastRevisionDate > ?previousRevisionDate)\n}","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"all_books_S_CQ","queryDescription":"CQ - 31 results","queryCode":"PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX : <http://www.obdasystems.com/books/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\n\nselect ?x where {?x a :Book}","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"all_books_S_EQL","queryDescription":"EQL - 31","queryCode":"PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX : <http://www.obdasystems.com/books/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\n\nselect (COUNT(?x) as ?count) where {?x a :Book}","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"all_books_C_CQ","queryDescription":"CQ - 31 triples","queryCode":"PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX : <http://www.obdasystems.com/books/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\n\nconstruct {?x a :Books} \nwhere {?x a :Book}","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":true},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"all_books_C_EQL","queryDescription":"EQL - 1 triple","queryCode":"PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX : <http://www.obdasystems.com/books/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\n\nconstruct {: :hasBooks  ?count}\nwhere {\nselect (COUNT(?x) as ?count)\nwhere { ?x a :Book}\n}","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":true},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"books_per_author_S_EQL","queryDescription":"CQ - 18 results","queryCode":"PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX : <http://www.obdasystems.com/books/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\n\nselect ?ath (COUNT(?bk) as ?count)\nwhere { \n  ?ath a :Author. \n  ?ath :name ?ath_name. \n  ?bk :writtenBy ?ath.}\ngroup by ?ath","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"average_books_per_author_S_EQL","queryDescription":"EQL - 18 results","queryCode":"PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX : <http://www.obdasystems.com/books/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\n\nselect ?ath (avg(COUNT(?bk)) as ?avg)\nwhere { \n  ?ath a :Author. \n  ?ath :name ?ath_name. \n  ?bk :writtenBy ?ath.}\ngroup by ?ath","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"books_per_author_C_EQL","queryDescription":"EQL - 18 triples","queryCode":"PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX : <http://www.obdasystems.com/books/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\n\nconstruct {?ath :hasWritten ?count}\nwhere {    \n    select ?ath (COUNT(?bk) as ?count)\n    where { \n  \t\t?ath a :Author. \n  \t\t?ath :name ?ath_name. \n  \t\t?bk :writtenBy ?ath.}\n    group by ?ath \n}","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":true},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"economic_editions_S_CQ","queryDescription":"CQ - 7 results","queryCode":"PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX : <http://www.obdasystems.com/books/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\n\nSELECT ?x \nWHERE {?x a :EconomicEdition }","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"economic_ed_publicationDate_S_CQ","queryDescription":"CQ - 7 results","queryCode":"PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX : <http://www.obdasystems.com/books/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\n\nSelect ?titolo ?datPub\nWhere { ?x a :PrintedBook.\n        ?x :title ?titolo.\n       ?x :hasEdition ?y.\n       ?y a :EconomicEdition.\n       ?y :dateOfPublication ?datPub}","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null},{"user":"admin","sparqlQuery":{"queryID":"audio_books_S_CQ","queryDescription":"CQ - 5 results","queryCode":"PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX : <http://www.obdasystems.com/books/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\n\nSelect ?titolo ?autore ?genere\nWhere { ?x :title ?titolo.\n        ?x :genre ?genere.\n        ?x a :AudioBook.\n        ?x :writtenBy ?y.\n        ?y :name ?autore }","constructResultsRDFSyntax":"TURTLE","mappingParameters":null,"semantics":"cq","constructCode":null,"queryTags":[],"selectedMappingIds":null,"virtualEntityQueryInfos":null,"languages":null,"chartConfiguration":null,"entryCreation":0,"entryLastModification":0,"creator":null,"publicationRequestDate":0,"publicationResponseDate":0,"public":false,"construct":false},"queryGraph":null}]}