动态报表生成服务的研究与实现

发布时间：2018-03-11 01:10

本文选题：动态报表　切入点：SOA　出处：《北京邮电大学》2013年硕士论文　论文类型：学位论文

【摘要】：报表系统在各行各业中都有很广泛的应用,使数据能够以特定的样式展现,并进行格式转化等处理。尤其是在信息管理,交通,银行,物流等行业的系统中,按照一定的需求生成不同数据,不同样式的报表有着广泛的需求。但实际中,需要面临数据源可能来自不同数据库,数据形式也可能多样变化,报表的样式随着业务的变化也会有相应的改变等情况,报表系统的开发通常需要面临如何提高系统面对数据源变化,报表样式变化的能力,提高系统的通用性和灵活性等问题。在一些开发系统中的报表控件由于不是开发环境的主体,在制作横纵报表,多级报表时通常需要嵌套子表和复杂的数据绑定,不能应用不同模板,有些方法不能提供某些特定报表样式的实现,或者不能很好的使用多数据源,以及一些报表工具需要特定的集成环境,商用成本高,不适合轻量级系统等问题。本文就针对以上报表系统开发中可能出现的问题进行研究。本文通过对动态报表服务相关系统和技术的研究,设计了一种数据和样式分离的可提供灵活样式选择的系统,并改进了模块的可重用性和通用性。论文首先应用SOA思想,对报表系统进行系统框架设计,运用SOMA方法论对报表系统进行分层设计,服务鉴别和划分。然后比较了几种报表生成解决方案的优劣势和不足之处,提出采用XML和XSLT技术的解决方案和相关实现。利用XML数据格式的通用性,使不同的数据源,如数据库中数据和Excel应用中的数据能够得到统一的转化,并增加了对转化后数据的有效性和正确性验证。利用XSLT在报表格式方面定义的灵活性,为用户提供能够设计复杂报表样式的方法,并使报表数据和报表样式定义分离,在运行时再进行相应的动态数据载入。通过分层设计,服务划分定义和数据转化与样式定义的分离,使开发的解决方案具有更好的通用性,可重用性和可移植性。
[Abstract]:The report system is widely used in all kinds of industries, so that the data can be displayed in a particular style, and the data can be processed by format transformation, especially in the information management, transportation, banking, logistics and other industries, especially in the information management, transportation, banking, logistics and other industries. Producing different data according to certain requirements, different styles of reports have a wide range of requirements. But in practice, the data sources may come from different databases, and the data forms may vary. The style of the report will change with the change of the business. The development of the report system usually needs to face how to improve the ability of the system to face the change of the data source and the change of the style of the report. Because the report control in some development systems is not the main body of the development environment, when making horizontal and vertical reports and multilevel reports, the nested subtables and complex data binding are usually required. You can't apply different templates, some methods can't provide implementations of specific report styles, or you can't use multiple data sources very well, and some reporting tools require a specific integration environment, and it's expensive to do business. It is not suitable for lightweight systems and so on. In this paper, the possible problems in the development of the above report system are studied. Based on the research of dynamic report service related system and technology, this paper designs a flexible style selection system, which can provide flexible style selection by separating data and style, and improves the reusability and versatility of the module. Firstly, the paper applies the idea of SOA. This paper designs the system framework of the report system, designs the report system by using the SOMA methodology, and then compares the advantages and disadvantages of several report generation solutions, including the hierarchical design, the service identification and the division of the report system, and then compares the advantages and disadvantages of several kinds of report generation solutions. This paper puts forward a solution and related implementation using XML and XSLT technology. By using the generality of XML data format, different data sources, such as data in database and data in Excel application, can be unified transformed. It also increases the validity and correctness of the transformed data. By using the flexibility of XSLT in the definition of report format, it provides users with a way to design complex report style, and separates the report data from the report style definition. Through hierarchical design, service partition definition and separation of data transformation and style definition, the developed solution has better generality, reusability and portability.
【学位授予单位】：北京邮电大学
【学位级别】：硕士
【学位授予年份】：2013
【分类号】：F49;TP393.09

【参考文献】