海量数据迁移和报表自动生成的研究和实现-软件工程专业论文.docxVIP

海量数据迁移和报表自动生成的研究和实现 海量数据迁移和报表自动生成的研究和实现 海量数据迁移和报表自动生成的研究和实现 海量数据迁移和报表自动生成的研究和实现 PAGE PAGE IV Lotus Notes 的源数据库的结构，设计了基于 DB2 的目标数据库结构。然后着重 对 Web 报表生成子系统及其关键模块（包括基础报表模板、报表数据检索器、 报表生成器）进行了详细设计。 目前 MassReporter 系统已通过功能测试和性能测试，在 IBM 进行了应用。 初步实施表明，该系统实现了报表的集中管理，统一了企业内报表的风格、布 局和操作，有效节省了客户需求沟通和开发人员报表维护所花的大量时间，达到 了预期的目标。 关键词 海量数据迁移，报表模板，报表引擎, 报表数据检索，Web 报表生成 RESEARCH AND IMPLEMENTATION OF MASS DATA MIGRATION AND REPORT AUTOMATIC GENERATION ABSTRACT Report is the foundation measure and path for enterprise management. It is the basic business needs for the enterprise and it is the foundation to implement BI strat- egy. Report can help enterprise access data, format data, and show the data informa- tion to customer using a reliable and safe way. It can help user understand the Enter- prise operating conditions deeply and it is very powerful to help enterprise grown. But most of the reporting systems currently implemented in most companies are closely related with platforms and the business logic, with high complexity in updat- ing and maintenance. Data source is also lack of central management and the data format is variety. How can we extract the useful information from the distributed data become a question for us. In addition a lot of popular report development platform don’t work very well on the requirements. A corporate hope to have such a reporting system: easy to develop, maintain, flexible to adapt report requirement variability, easy to migrate and integrate with the customized report engine. Base on the background we talked above, in this paper we investigate how to ex- tract information from mass data which is stored in Lotus Notes text database and how to design a light web report engine. On that basis we has designed and developed a light web report automatic generation system--MassReporter which is met general requirements for enterprise. In this paper, Firstly, we looked into the various techniques to help mass data migration from Lotus notes to relational da