基于Sqlserver2008数据库下的报表服务方案探析

An Analysis of Reporting Service Scheme Based on Sqlserver2008

随着信息化的推广和普及,数据库系统的应用范围和业务覆盖面也越来越广,数据基础信息量成几何级数倍增,业务复杂度逐渐升高。各种业务统计分析报表的数量和复杂度随之加大,如何建立一个跨系统、分布式、异构和高效率的统计报表服务就成为难题。本文结合业务系统与SQLServer2008数据库的特点,提出和测试报表服务方案,来提高系统的报表分析汇总性能。

With the development and popularization of information technology,database application system is being used more and more widely,making the amount of the basic data information increases rapidly. And the gradually more and more complex businesses result in the increase of the amount and the complexity of statistical analysis reports of all kinds of businesses. How to build a cross-system,distributed,heterogeneous and efficient statistical reporting service becomes a key problem. Based on the characteristics of the business system and SQLServer2008 database,this paper puts forward and tests the reporting service realization to improve the reporting analysis and summary performance of the system.