A Formal Semantics of SQL Queries, Its Validation, and Applications
- Submitting institution
-
University of Edinburgh
- Unit of assessment
- 11 - Computer Science and Informatics
- Output identifier
- 58608450
- Type
- D - Journal article
- DOI
-
10.14778/3151113.3151116
- Title of journal
- Proceedings of the VLDB Endowment (PVLDB)
- Article number
- -
- First page
- 27
- Volume
- 11
- Issue
- 1
- ISSN
- 2150-8097
- Open access status
- Compliant
- Month of publication
- September
- Year of publication
- 2017
- URL
-
-
- Supplementary information
-
-
- Request cross-referral to
- -
- Output has been delayed by COVID-19
- No
- COVID-19 affected output statement
- -
- Forensic science
- No
- Criminology
- No
- Interdisciplinary
- No
- Number of additional authors
-
1
- Research group(s)
-
C - Foundations of Computation
- Citation count
- 9
- Proposed double-weighted
- No
- Reserve for an output with double weighting
- No
- Additional information
- First formal semantics of SQL queries that considers the real language and its multiset-based data-model with nulls. The proposed semantics is validated by extensive experiments on real systems and ISO committee have agreed to publish it as a technical report, which is currently in development. Also debunks the myth that three-valued logic is necessary for handling nulls and led to a follow-up grant (£100K) from the world-leading company in graph databases, Neo4j, to formalise their declarative query language, Cypher (contact: Team Lead, Query Languages Standards). Further grant (£100K, Huawei) was awarded to extend the semantics to additional features of SQL.
- Author contribution statement
- -
- Non-English
- No
- English abstract
- -