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 rend...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.展开更多
文摘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.
