{"title":"Translating Temporal SQL to Nested SQL","authors":"C. Dyreson, Venkata A. Rani","doi":"10.1109/TIME.2016.24","DOIUrl":null,"url":null,"abstract":"This paper presents a technique for weaving temporal semantics into an SQL query. We assume that a query writer programs a query and then annotates the query with some temporal semantics, such as sequenced or nonsequenced semantics. The annotation is a lightweight temporal statement modifier, it changes the semantics by which the query is evaluated. Annotations can be specified for a wide variety of semantics including sequenced and nonsequenced semantics. We give a denotational semantics for translating SQL queries with temporal annotations into Nested SQL. Nested SQL is SQL with some additional operations. We also describe how the translation is implemented using an ANTLR grammar for SQLite.","PeriodicalId":347020,"journal":{"name":"2016 23rd International Symposium on Temporal Representation and Reasoning (TIME)","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2016-10-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"4","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2016 23rd International Symposium on Temporal Representation and Reasoning (TIME)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/TIME.2016.24","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 4
Abstract
This paper presents a technique for weaving temporal semantics into an SQL query. We assume that a query writer programs a query and then annotates the query with some temporal semantics, such as sequenced or nonsequenced semantics. The annotation is a lightweight temporal statement modifier, it changes the semantics by which the query is evaluated. Annotations can be specified for a wide variety of semantics including sequenced and nonsequenced semantics. We give a denotational semantics for translating SQL queries with temporal annotations into Nested SQL. Nested SQL is SQL with some additional operations. We also describe how the translation is implemented using an ANTLR grammar for SQLite.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
