Linux-based PL/SQL Compiler

The paper discusses the design and implement of SQL compiler for theLinux-based database. PL/SQL supported by PL/SQL compiler is a combination ofthe standard SQL and the third generation language. It can realize the processing SQLwhich is supported by almost popular DBMS nowaday.The paper describes the phases of compiler, explains how compiler wasdeveloped. Based on the principle of compiler, the framework of PL/SQL compiler isbrought up. One important point of the compiler is dealing with SQL and ProcessingLanguage separately. Then the paper discusses several modules of the compiler indetail, such as the module of generation and administration of symbol table ,etc.Specially LEX & YACC, which embedded in Linux, are used in the design of lexicalanalysis module and semantic analysis module. The paper talks about LEX & YACCfrom the basic principles ,which include regular expression, Finite Automata and soon, to the actual use.