Syntax Validation of the SQL Conditional Expression Based on Postfix-Expression Evaluation
Authors
Lijun Wei, Yang Pan, Hao Wang, Yan Zhang
Corresponding Author
Lijun Wei
Available Online December 2015.
- DOI
- 10.2991/nceece-15.2016.166How to use a DOI?
- Keywords
- Conditional Expression; Syntactic Logic; Data Type; Postfix Expression; Syntax Validation
- Abstract
The SQL conditional expression is not a constant expression, making it impossible to judge its legitimacy through the final value. However, there exists one alternative way where the elements in expression should be identified first to obtain the corresponding postfix data type expression, and the algorithms of SQL data types should be set to evaluate the postfix expression, then we can judge the syntactic legitimacy of the conditional expression in accordance with the final results. Tests conducted in this research have proved that this method can effectively validate the legitimacy of the SQL conditional expression and significantly serve for custom query and data analysis patterns.
- Copyright
- © 2016, the Authors. Published by Atlantis Press.
- Open Access
- This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).
Cite this article
TY - CONF AU - Lijun Wei AU - Yang Pan AU - Hao Wang AU - Yan Zhang PY - 2015/12 DA - 2015/12 TI - Syntax Validation of the SQL Conditional Expression Based on Postfix-Expression Evaluation BT - Proceedings of the 2015 4th National Conference on Electrical, Electronics and Computer Engineering PB - Atlantis Press SP - 915 EP - 921 SN - 2352-5401 UR - https://doi.org/10.2991/nceece-15.2016.166 DO - 10.2991/nceece-15.2016.166 ID - Wei2015/12 ER -