The Design And Research Of Semantic Object Report Tool

Report is an important application of database. It centers on transferring data into information which would be the foundation of decision-making. At the same time, report is also a vital means of information exchange. The former report module is developed by the programmers themselves according to the demand. It has such disadvantages as that the workload of programming and maintenance is very heavy and that it can not be used generally. With the widely use of various report tools, much work can be released by using of the API. But there are some defects in the traditional report tools, such as its high degree of specialty, low safety and inability to share data, etc. These defects result in the complicated operation and go against the application integration and data integration of the enterprises.In order to solve the above-mentioned problems, with the application of some concepts of OLAP, this thesis put forward a new framework of report application, that is, to establish a middle layer between the report tools and the data base. A series of data models including the data source model, the report model and the transformation model was established in the middle layer. Among them, the data source model describes the data source information of relevant fields by referring the knowledge of the users. The report model is derived from conclusion of the data source model and presents the analysis topic of report. The report model can be instantiated according to the report format. The transformation model show the mapping relationship between the report model and the bottom data base, and this relationship include row relationship and line relationship. Considering the general-purpose and the ability to be extended of the data model, the static model is described by XML document and the mobile model is, on the other hand, described by XSLT document. The middle layer protects the data base. The data model which is based on XML provide interface between application integration and the data integration. And the customized definition method enables the users to understand and operate more easily. Besides we also design a language which to the format of the report. By editing the attributes of the language, we can define the complex format of the China Reports.Based on this report application framework, we research an SOPT tool. The tool can control the access to data source by user's purview. At the same time, it can realize the definition of report model by access to data source model and form the report definition according to the format of the report. When producing the report data, the report tool will turn the report model into a query script by making use of the transformation model. It will acquire the relevant data collection from the data base, and present them to the users with a suitable report format. There is no necessary relationship between the report data produced by the tool and the report format. Other application system can access the relevant report data by the report model. This thesis also discusses the utilization of report data, the definition of query analysis model and some possible resolutions.