Syntax Validation of the SQL Conditional Expression Based on Postfix-Expression Evaluation

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/).

Download article (PDF)

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  -