摘要
报表作为一种信息组织和展示的有力手段，是企业信息系统的重要组成部分，是进行信息浏览、分析、打印的有利工具。然而传统的报表生成系统在不同程度上都存在生成报表种类固定，格式不统一，程序升级维护困难等问题。越来越多的企业希望能够有一种基于高水平的查询语言的报表系统。XQuery规范的推出，使得设计一种基于标准的解决方案来实现在全异数据源之间进行查询成为可能。因此，基于XQuery规范的报表系统成为了技术上的研究热点。
本文基于XQuery查询语言的优势和报表系统的基本要求，设计了一个基于XQuery规范的报表系统，在设计和实现方面做了以下有意义的尝试：
1．XQuery的数据模型由扩充的XML信息集和简单类型值以及它们之上的一些操作构成，为XQuery的执行提供底层的数据支持和基本操作支持。
2．使用扩展的Qizx做为XQuery的实现引擎，将各种数据源中的数据集成到一个XML文件中，方便的实现了数据集成和交互，并很好的保证了集成后数据的实时性。
3．本文提出了使用Report Templates和XQuery的新的报表框架，能够在不影响应用程序其余部分的前提下轻松实现对报表模板的修改，从而使系统维护问题更少而生产效率更高。
本文设计的报表系统已经被应用于某银行风险管理系统中，在财务分析、统计报表、科目分析等功能模块中得到了很好的应用。
As a powerful measure of information organization and revelation, report forms are the important component part of the enterprise information system and advantaged tool of information browse, analysis and print. While there are some problems about the traditional report forms system more or less, such as singleness of report forms kinds, disunity of the format, be difficult to upgrade and maintenance the application program and so on. More and more enterprise wishes that there is a kind of report forms system which is based on high level query language. The appearance of the XQuery criterion makes it possible that design a resolve scheme based on criterion to implement query among totally different data sources. Therefore, the research in the report forms system based on the XQuery criterion becomes the technical hotspot.
Based on the advantage of XQuery and the basic requirements of report forms system, a design of report forms system based on the XQuery criterion is conceived.
There are a few meaningful attempts in this article on both designing and implementing:
1. XQuery data model is made up of extensible XML information set, simple type value and some operations about them. The data model provides bottom data support and basic operation support to XQuery performance.
2. This system uses extensible Qizx as XQuery implementing engine. It can collect data from all kinds of data sources to a XML file, implement data collection and interaction conveniently, and assure the real time of the collected data.
3. In this article, there is a new report forms frame using report templates and XQuery. This frame can modify the report forms template easily but don't affect other parts of the application program. So, the system will have less maintenance problems and higher produce efficiency.
This report forms system has been applied to the risk management system in which it performs the analysis of financing, statistic report forms, analysis of subjects and so on.
引文
[1] World Wide Web Consortium. Extensible Markup Language (XML) [EB/OL]. http://www.w3.org/XML/
[2] World Wide Web Consortium. Hyper Text Markup Language (HTML) [EB/OL]. http://www.w3.org/MarkUp/
[3] ISO8879. Standard Generalize Markup Language (SGML) [EB/OL]. http://www.iso.ch/cate/d6387.html
[4] Henry S.Thompson, David Beech, Noah Mendelsohn. XML Schema Part 1: Structures Second Edition
[5] Biron P V, Malhotra A. XML Schema Part 2: Datatypes. http://www.w3.org/TR/xmlschema-2
[6] World Wide Web Consortium. XQuery1.0 and XPath2.0 Data Model[EB/OL]. http://www.w3.org/TR/query-datamodel/
[7] M.Murata, D.Lee, and M.Mani. Taxonomy of XML Schema Languages using Formal Language Theory [J], Extreme Markup Languages, Montreal, Canada, 2001
[8] V.Christrophides, SAbiteboul, S.Cluet, M.Scholl. From Structured Documents to Novel Query Facilities. In SIGMOD'94, May 1995,313-324
[9] S. Abiteboul, D. Quass, J. McHugh, J. Widom, J. Wiener. The Lorel Query Language for Semistructured Data [J]. International Journal on Digital Libraries, 1997,1(1): 68-88
[10] H.Schoning.Tamino. A DBMS designed for XML [J]. Proc, of the ICDE Conf., Heidelberg, Germany, Apr. 2001,149-154
[11] W3C Working Group. XQuery 1.0: An XML Query Language (04 April, 2005). http://www.w3.org/TR/2005/WD-xquery-20050404
[12] W3C Working Group. Xavier C. Franc's Qizx/Open. Java, open-source. http://www.xfra.net/qizxopen/
[13] W3C Working Group. XQuery 1.0 and XPath 2.0 Formal Semantics (04 April, 2005). http://www.w3.org/TR/xquery-semantics/
[14] W3C Working Group. XQuery 1.0 and XPath 2.0 Functions and Operators. http ://www. w3 .org/TR/xquery-operators/
[15] W3C Recommendation 23 January 2007. XML Path Language (XPath) 2.0. http://www.w3.org/TR/2007/REC-xpath20-20070123/
[16] W3C Working Draft. XQuery 1.0 and XPath 2.0 Data Model. 29 October, 2004. http://www.w3.org/TR/xpath-datamodel
[17] 段晓娟，徐长海，孙宁．Xpath技术解析[J]．应用技术，2003，第9期，p27-29
[18] 阎宏著．Java与模式．北京：电子工业出版社，2002
[19] 冯大鹰，晋玉星．通用报表的XML描述．计算机应用与软件，2005．8
[20] 王华麟，杨育普．使XML构建协作式WEB解决方案．计算机工程，2000．9
[21] 杨芳，陶世群．基于XML异构数据库系统的集成设计．计算机工程与设计，2005．7
[22] 蔡飞，贝佳，陶列骏等．基于关系数据库的XQuery查询的实现．计算机科学，2004．5
[23] 熊家治，王飞乐，丁祥武等．基于XML的异构数据源—XQuery查询．计算机应用与软件，2004．2
[24] 方翔，袁国栋，李伟生．建立特殊索引实现XML文档优化[J]．计算机工程，2002．3
[25] (美)Natanya Pitts著．徐晓梅，龚志翔，王晓云等译．XML技术内幕．北京：机械工业出版社，2002
[26] Michael Morrison著．陆新华，陆新宇译．XML揭秘——入门 应用 精通[M]．北京：清华大学出版社，2001
[27] (美) Annette Harper著．黄开枝译．基于Oracle的Crystal Reports9数据报表高级开发．北京：清华大学出版社，2004
[28] 齐金山．基于XQuery的XML查询．福建电脑，2006，第11期
[29] 蒋艳．一种XQuery的表示模型．科技广场，2005．12
[30] 谢荣传，谢铉洋．XQuery语言的实现．安徽大学学报(自然科学版)，2005．1
[31] 李智芳，蒋芝山．基于J2EE架构的WEB报表系统．计算机系统应用，2006，第5期
[32] 林琴，谭骏珊．基于Struts框架的WEB报表展示的设计与实现．计算机系统应用，2006，第11期
[33] 刘德红，刘恩，马晓贤．证券投资学．北京：清华大学出版社，北京交通大学出版社，2006．2
[34] 陈信华．金融衍生工具．上海：上海财经大学出版社，2004．2
[35] 刘少波．证券投资学．暨南大学出版社，2004．7
[36] 蔡建宇，杨树强．关系数据库语义缓存的研究进展．计算机工程与科学，2005，27(10)：61-64
[37] Qun Ren. Semantic caching and query processing. IEEE Trans on Knowledge and Data Engineering. 2003, 15 (1): 192-210
[38] 塔娜，冯建华，李国良等．纯XML数据库语义缓存中视图的快速查找算法[A]．NDBC 2006[C]．2006
[39] HEBS, LUO Q, CHO IB. Cache-conscious automata for XML filtering [A]. ICDE 2005 [C]. 2005
[40] LICHEN. Semantic caching for XML queries [EB/OL]. http://www.wpi.edu/Pubs/ETD/Available/etd-0129104-174457, 2006