基于Web的工程项目管理软件数据平台设计

发布时间：2018-04-29 21:06

本文选题：工程项目管理软件 + 数据平台　；参考：《电子科技大学》2014年硕士论文

【摘要】：自从工程项目管理软件的应用引入工程领域以来,人们不再需要做很多繁杂重复的工作,并且使得工程项目管理的水平得到了不断提高,同样工程项目管理的工作效率也得到了进一步提高。工程项目管理软件需要对工程项目管理中的数据进行实时的处理,这些数据量特别大,对它们的处理一定要是全面并且准确的。因此建立一个良好的数据平台显得尤为重要。本文研究的便是为一家电力工程公司设计的基于Web的工程项目管理软件数据平台的设计。本文工程项目管理软件基于ASP.NET平台,采用B/S结构进行设计,采用ADO.NET数据访问技术进行数据访问。本文研究的数据平台采用三层架构的模式进行开发。数据平台确保该工程项目管理软件成功实现需求分析所提出的功能需求,比如工程项目进度管理,用户权限管理,物资管理以及消息系统等。文中首先对需求分析进行了概述,在此基础上提出了功能需求,并且对总体设计方案进行了概述。针对工程项目管理软件所涉及的数据种类繁多,数据量庞大,数据不规范等问题,本文对数据的来源进行了分析,同时对数据进行了分类,并且完成了对数据的编码。数据平台采用关系型数据库进行设计,数据库的设计采用Power Designer数据库设计工具进行建模,分别是概念数据模型CDM和物理数据模型PDM。具体数据库的建立由Power Designer工具自动生成的SQL脚本在Microsoft SQL Server 2005中创建。另外还对数据驱动进行了探讨,封装了DBAccess类进行对数据库最底层的访问,对三层架构中的每一层实现也选取了一部分进行介绍。同时对数据库的安全以及备份做了分析,并且详细说明了数据库数据的自动复制。最后完成测试,并且对功能实现进行部分展示。
[Abstract]:Since the application of engineering project management software has been introduced into the engineering field, people no longer need to do a lot of complicated and repetitive work, and the level of engineering project management has been continuously improved. The work efficiency of project management has also been further improved. The engineering project management software needs to process the data in the project management in real time. The data amount is very large, so the processing must be comprehensive and accurate. Therefore, the establishment of a good data platform is particularly important. This paper studies the design of project project management software data platform based on Web for a power engineering company. In this paper, the project management software is designed based on ASP.NET platform, using B / S structure and ADO.NET data access technology. The data platform studied in this paper adopts three-tier architecture to develop. The data platform ensures that the project management software successfully implements the functional requirements of the requirements analysis, such as project schedule management, user authority management, material management and message system. In this paper, the requirement analysis is summarized firstly, and then the functional requirements are put forward, and the overall design scheme is summarized. In view of the problems of various kinds of data, huge amount of data, non-standard data and so on, this paper analyzes the source of the data, classifies the data at the same time, and completes the coding of the data. The data platform is designed by relational database, and the database is modeled by Power Designer database design tool, which is the conceptual data model CDM and the physical data model PDM respectively. The establishment of concrete database is created by SQL script generated automatically by Power Designer tool in Microsoft SQL Server 2005. In addition, the paper also discusses the data drive, encapsulates the DBAccess class to access the bottom layer of the database, and introduces the implementation of each layer in the three-tier architecture. At the same time, the security and backup of database are analyzed, and the automatic replication of database data is explained in detail. Finally, the test is completed, and the implementation of the function is partially demonstrated.
【学位授予单位】：电子科技大学
【学位级别】：硕士
【学位授予年份】：2014
【分类号】：TP311.52;TP393.09

【参考文献】