The formation of SQL sentence in Chinese query system of GIS
Aiping Xu · 2006
Because of the big difference between Chinese query sentence of GIS and the sentence of SQL,it is difficult to change from Chinese query sentence to SQL directly.So a certain middle logic formal language is needed.In this paper,the sentence pattern of Chinese query language of GIS and its stack middle language structure has been analyzed at first.Then the transform from middle language into SQL has been studied.The estimation policy of SQL sentences' query condition segment,goals and groups segment has been researched.The difficulty is the judgement of nested structure.The transform is done by middle relation.The transform algorithm is designed and tested.The experiment show that it can translate a majority of Chinese query sentence of GIS into SQL.It has established a foundation for future research.