价格监测预警信息系统

题目：价格监测预警信息系统

——数据模块的设计与实现

价格监测预警信息系统

——数据模块的设计与实现

摘要

纵观国内价格监测现状，政府投入大量人力、物力来监测市场价格，但却未达到高效、快捷、准确的目标，给各级政府价格监管和宏观调控带来了极大考验。

本文在深入开展了对物价系统中各监测机构的现状、实际业务调查的基础上，针对数据模块（其中包括数据采集、分析、预警）业务需求，详细阐述了该模块的需求分析和系统设计，并讲述了利用J2EE架构、B/S结构、SQL Server2005数据库、Excel控件、Ajax、FusionCharts 等技术进行开发维护的实践过程。

本文着重阐述系统数据模块中数据采集部分，详细描述了从原始数据收集到最终形成汇总数据的流转过程，且对整个研发过程中碰到的有较大影响问题及其相应的解决方案进行了总结。

系统采用螺旋生命周期模型进行开发，在与客户交流中不断完善。目前该系统已经过两个月的用户试运行和两个月的正式运行，运行稳定，客户反应有效提升工作效率，能够快速及时掌握价格变动和整体的变化趋势。

关键词：价格监测预警，J2EE，SQL Server2005，Excel，Ajax

DESIGN AND IMPLEMENTATION OF DATA MODULE AMONG MONITORING AND WARNING INFORMATION SYSTEM

ABSTRACT

Throughout the status of domestic prices monitoring, government has invested a great deal of manpower and material resources to monitor the market prices. while it doesn’t meet the high-performance, fast and accurate target, which brings the great test of price monitoring and macro-control to all levels of government.

Based on the deeply study on the status of various monitoring institutions and the actual business investigation in the price system, formed three parties of business requirement(data collection, data analysis, data early warning),this paper gives the detail system design by the analysis of business requirement, using J2EE frame, B/S Structure, SQL Server 2005、Excel component 、Ajax、FusionCharts and so on, selected eclipse as the IDE to develop software until to use.

This paper describes the system data module part of the data

acquisition from the original data entry to the final form of the circulation process of aggregate data. And they Summed up of a greater impact on the problems and corresponding solutions had encountered in the course of the research and development.

The system is developed by using a spiral development life cycle model, and improves a lot by communicating with the customers. After it passed a two-month trial run, as well as two-month official operation stably, the customer has given a positive confirmation of the efficiency, prompt and ability to control the overall pricing fluctuation and trends.

Key Words: price monitoring and warning,j2ee,sql server2005,excel,ajax

目录

摘要 (1)

ABSTRACT (2)

第一章绪论 (3)

1.1 价格监测预警系统的建设背景 (3)

1.2 国内外价格监测预警系统的发展现状 (3)

1.3 研究的目的和意义 (4)

第二章价格监测预警系统相关技术综述 (6)

2.1 J2EE技术架构 (6)

2.2 数据报表方案 (7)

2.2.1 基本原理 (7)

2.2.2 对比分析 (11)

2.2.3 实际采用方案 (11)

2.3 SQL Server 2005简介及优点 (12)

2.4 相关技术介绍 (13)

2.4.1 J2EE分布式对象开发技术 (13)

2.4.2 XML(Standard Markup Language) (13)

2.4.3 Ajax技术 (15)

2.4.4 缓存技术 (16)

第三章价格监测预警系统数据模块的需求分析 (17)

3.1 业务需求 (17)

3.1.1 监测数据采集模块 (17)

3.1.1.1 定点单位 (19)

3.1.1.2 市/县监测机构 (19)

3.1.1.3 省监测中心 (20)

3.1.2 监测数据分析模块 (21)

3.1.3 监测数据预警模块 (21)

3.2 功能需求 (21)

3.2.1 监测数据采集模块 (22)

3.2.2 监测数据分析模块 (30)

3.2.3 监测数据预警模块 (34)

3.2.4 模块总体 (35)

3.3 权限需求 (36)

3.3.1 监测数据采集模块 (37)

3.3.2 监测数据分析模块 (37)

3.3.3 监测数据预警模块 (37)

第四章价格监测预警系统数据模块的设计 (38)

4.1 系统总体结构设计 (38)

4.2 数据库设计 (39)

4.3 重要模板结构 (40)

4.4 模块功能设计 (44)