The Design And Implementation Of The DSQL Based On The Domain Data Model

With the wide spread of database applications and the evolution of specific-purpose data models, a new data model, called Domain Data Model(DDM), which is used especially for enterprise MIS development, is emerged. However, currently, no DDM query language is available. This paper presents the design and implementation of the DSQL based on the current research in the DDM field. The DSQL is a domain database query language used in the DDM.This paper first introduces the fundamental concepts of the DDM and focuses on the descriptions of the Domain, Entity, Relation, and Access Control Method in the DDM. By combining with the research methods of other query languages for specific-purpose database systems, this paper presents the fundamental concepts and principles of the DSQL.After the introduction, this paper describes the design goal and function categorization of the DSQL, which is divided into two parts, DDDL and DDML. Then, the design and implementation of the DSQL interpreter and executer are presented based on the logically layered model. This paper also provides lexical & syntax analysis, transformation method of the DSQL, and optimization plans against the implementation technologies for the DSQL. Last, by using two concrete application examples, we verify the applicability and feasibility of the DSQL in the practical use, and summarize the advantages of the DSQL.The DSQL presented in this paper is not only an important component but also an improvement of the Domain Database Management System. The implementation of the DSQL further promotes the research of the development methods of MIS, and gives valuable reference to other query languages research for specific-purpose data models.