Research & Implementation Of Content Query Language For Content Management System

With the development of the Enterprise Information Technology, more and more data are generated from day-to-day business operation. According to statistic, only 15% of the data are structured, while 85% of the data are unstructured. Such a large amount of data is distributed across the enterprise. How to efficiently make use of the data is a problem. Content management system (CMS) is designed for the enterprise managing and using the unstructured data. But CMS is new to the market and it is not perfect. Corporate customers will continue to introduce new CMS needs and the application based on the CMS will be more and more complicated. On the other hand, in the implementation of CMS, fast and flexible to meet the needs of customers is required. And customization should be simple, short cycle, and with high efficiency. Systems itself should be easy to maintain. For CMS, this is a big challenge.This paper analyzes the development path of the CMS and points out the development trend and critical technologies for the CMS. Later, an object/content mapping framework was proposed, in this framework, an object oriented CMS data model and an object persistent solution are designed. Based on CMS data model, the focus of this paper Content Query Language (CQL) is presented. This language can operate on the ojects in CMS directly. The syntax of the language was presented and the compiler program which explains how to compile the CQL into SQL is also designed in this paper. The design and Implementation of CQL is based on the compiler theory, O/R Mapping,JSR-170, ANTLR etc.In this paper, the following research has been done:1. An object/content mapping framework was proposed. In this framework, the research of the object-oriented technology and O/R Mapping related theory is done. A CMS data model is built based on object-oriented technology, and an object persistent solution is proposed. XML is introduced to describe the CMS data model. A JSR-170 compliant standard CM API implemetation is proposed.2. The syntax of CQL is presented. The compiler related theory is researched. Combined with CM data model and based on ANTLR tool, the theory and design of CQL is proposed. The design includes Lexer, CQL tree construction, intermediate SQL tree construction and SQL generation.3. Based on standard J2EE platform, the CQL compiler is implemented. By using CQL and CM API, a simple CMS prototype was implemented to demonstrate the application of CQL in the actual project. And the effects of CQL in system maintenance and applications development are analyzed. The results of the research can be used to enhance the flexibility and scalability of the application of the CMS. Reduce the complex of the CMS maintenance. Improve the efficiency for the customization of CMS.