基于EXCEL服务器的设备管理系统设计与开发
毕业设计说明书（论文）外文摘要
Title Design and Development Of Equipment Management System Based On Excel Server
Abstract
With in-depth research on the basis of the equipment management business, this paper provides suggestions for improvement by analyzing the main operation processes, management processes and information management issues. Based on the background of information technology, it discusses the method of using Excel server to develop equipment management information system as well as its feasibility, applies the knowledge of software engineering, especially the structured analysis method, and then develops preliminary design plan combining with the demand analysis results. This paper plots data flow diagram to show the data flow, writes the data dictionary to explain the data structure; draws the ER diagram and database tables to display the database entity-relationship. Six modules are built and system functional flow charts are drawn by piding the functions, including basic data, equipment management, spare parts, equipment accidents, maintenance and repair. Finally, this paper uses the application of the open source Excel Server 2007-based platform, takes the MS Office Excel as a design tool and the MS SQL Server 2005 as its database, designs an Equipment Management System (EAM) software at the operating environment of MS Office Excel and ESWEB, in order to lay the foundation for enterprise equipment management practices.
Keywords Equipment management system Excel server Data flow Business process Database design
目 次
1 绪论 1
1.1 课题背景及来源 1
1.2 相关概念及国内外研究综述 2
1.3 课题意义及研究趋势 4
1.4 总体思路和总体方案 7
1.5 本论文的主要内容 9
2 基于EXCEL服务器的EAM系统需求分析 11
2.1 企业设备管理业务流程调研和分析 11
2.2 系统目标需求 12
2.3 系统功能需求 14
2.4 系统性能需求 15
2.5 系统环境需求 15
2.6 本章小节 16
3 设备管理系统数据流分析 17
3.1 数据流图概述 17
3.2 系统数据流图设计 20
3.3 系统数据词典 25
上一篇：Java社区综合服务系统设计实现