The Processing and Improvement of Multi-Statement Queries in Chiql

Chiql is a novel Chinese relational database query language for Chinese users.It supports procedural query style in which users can specify a complex database request in multiple simple statements.This facility renders Chiql simple-to-use and easy-to-remember.However,direct execution of multi-statemen Chiql rueries(i.e.statement by statement)is often inefficient as potential index-based operations(e.g.join) are by-passed.Furthermore,it often incurs additional database operations,such as scan and projection.To improve this situation,the SMA(Statement Merging Algorithm)is proposed.The goal of SMA is to merge as many dependent statments within Chiql query as possible to form a more efficient Chiql query.The ability in achieving improved effciency without sacrificing the simplicity of the language is the major advantage of this algorithm.

The processing and improvement of multi-statement queries in Chiql

Chiql is a novel Chinese relational database query language for Chinese users. It supports procedural query style in which users can specify a complex database request in multiple simple statements. This facility renders Chiql simple-to-use and easy-toremember. However, direct execution of multi-statement Chiql queries (i.e. statement by statement) is often inefficient as potential indexbased operations (e.g. join) are by-passed. Furthermore, it often incurs additional database operations, such as scan and projection. To improve this situation, the SMA (Statement Merging Algorithm) is proposed. The goal of SMA is to merge as many dependent statements within a Chiql query as possible to form a more efficient Chiql query. The ability in achieving improved efficiency without sacrificing the simplicity of the language is the major advantage of this algorithm.