Klarman, SMeyer, T2014-10-092014-10-092014-06Klarman, S and Meyer, T. 2014. Querying temporal databases via OWL 2 QL. In: International Conference on Web Reasoning and Rule Systems, June 2014http://link.springer.com/chapter/10.1007%2F978-3-319-11113-1_7http://www.cair.za.net/sites/default/files/outputs/KlaMeyRR14_0.pdfhttp://hdl.handle.net/10204/7708International Conference on Web Reasoning and Rule Systems, June 2014SQL:2011, the most recently adopted version of the SQL query language, has unprecedentedly standardized the representation of temporal data in relational databases. Following the successful paradigm of ontology-based data access, we develop a practical approach to querying the SQL:2011-based temporal data model via the semantic layer of OWL 2 QL. The interval-based temporal query language (TQL), which we propose for this task, is based on naturally characterizable combinations of temporal logic with conjunctive queries. As the central contribution, we present rules for sound and complete rewriting of TQL queries into two-sorted first-order logic, and consequently, into corresponding SQL queries, which can be evaluated in any existing relational database management system compliant with the SQL:2011 temporal data model. Importantly, the proposed rewriting is based on the direct reuse of the standard rewriting techniques for conjunctive queries under OWL 2 QL. This renders our approach modular and easily implementable. As a notable corollary, we show that the data complexity of TQL query answering remains in AC0, i.e., as in the usual, non-temporal case.enSQL query languageOntology-based data accessTemporal query languageTQLConference PresentationKlarman, S., & Meyer, T. (2014). Querying temporal databases via OWL 2 QL. Springer. http://hdl.handle.net/10204/7708Klarman, S, and T Meyer. "Querying temporal databases via OWL 2 QL." (2014): http://hdl.handle.net/10204/7708Klarman S, Meyer T, Querying temporal databases via OWL 2 QL; Springer; 2014. http://hdl.handle.net/10204/7708 .TY - Conference Presentation AU - Klarman, S AU - Meyer, T AB - SQL:2011, the most recently adopted version of the SQL query language, has unprecedentedly standardized the representation of temporal data in relational databases. Following the successful paradigm of ontology-based data access, we develop a practical approach to querying the SQL:2011-based temporal data model via the semantic layer of OWL 2 QL. The interval-based temporal query language (TQL), which we propose for this task, is based on naturally characterizable combinations of temporal logic with conjunctive queries. As the central contribution, we present rules for sound and complete rewriting of TQL queries into two-sorted first-order logic, and consequently, into corresponding SQL queries, which can be evaluated in any existing relational database management system compliant with the SQL:2011 temporal data model. Importantly, the proposed rewriting is based on the direct reuse of the standard rewriting techniques for conjunctive queries under OWL 2 QL. This renders our approach modular and easily implementable. As a notable corollary, we show that the data complexity of TQL query answering remains in AC0, i.e., as in the usual, non-temporal case. DA - 2014-06 DB - ResearchSpace DP - CSIR KW - SQL query language KW - Ontology-based data access KW - Temporal query language KW - TQL LK - https://researchspace.csir.co.za PY - 2014 T1 - Querying temporal databases via OWL 2 QL TI - Querying temporal databases via OWL 2 QL UR - http://hdl.handle.net/10204/7708 ER -