Design and implementation for SQL parser based on ANTLR

Author

Cao, Danyang ; Bai, Donghui

Author_Institution

Coll. of Inf. Eng., North China Univ. of Technol., Beijing, China

Volume

4

fYear

2010

fDate

16-18 April 2010

Abstract

To solve the close relationship between the data query and interface design of management information system, the paper implements a SQL parser based on ANTLR. The SQL parser is composed of lexical analysis, syntax analysis and semantic checking. The SQL parser is successfully integrated with management information system and the query is implemented by the SQL parser to search the data from database. It solves the problem that the relationship between the data query and interface design of management information system is very close, and improves the reliability and reusability of the software.

Keywords

SQL; grammars; management information systems; programming language semantics; query processing; software reliability; software reusability; ANTLR; SQL parser; data query; database search; interface design; lexical analysis; management information system; semantic checking; software reliability; software reusability; syntax analysis; Data engineering; Databases; Design engineering; Educational institutions; Information analysis; Management information systems; Paper technology; Programming profession; Software reusability; Target recognition; ANTLR; SQL parser; lexical analysis; syntax analysis;

fLanguage

English

Publisher

ieee

Conference_Titel

Computer Engineering and Technology (ICCET), 2010 2nd International Conference on

Conference_Location

Chengdu

Print_ISBN

978-1-4244-6347-3

Type

conf

DOI

10.1109/ICCET.2010.5485593

Filename

5485593