基于Access的工程造价基础数据平台原型的设计与开发  

Design and development of basic data platform prototype of engineering cost based on access

作　　者：周小溪[1] 易升[1] 关宗印[1] Zhou Xiaoxi;Yi Sheng;Guan Zongyin(China Renewable Energy Engineering Institute, Beijing 100120, China)

机构地区：[1]水电水利规划设计总院,北京100120

出　　处：《工程造价管理》2018年第1期73-79,共7页Engineering Cost Management

摘　　要：大数据的兴起为工程造价专业的发展提供了新的契机。为顺应大数据的发展潮流以及传统水电行业相关企业业务结构调整和转型升级的发展趋势,充分利用工程造价基础数据资料,文章首先确立了数据平台的研究内容,即以水电、风电及光伏发电为基本骨架,在横向上向建筑、交通、市政及水务等行业领域拓展,在纵向上向工程建设全过程进行延伸。同时,为体现工程造价的层次性和系统性,围绕上述行业领域,对其造价体系进行系统分析,提炼出基础价格、设备价格、主要单位造价指标以及主要技术经济指标四项内容。然后从功能、数据结构和界面等方面,对具有基础数据资料共享、查询及分析等功能的数据平台进行了设计,并基于Access建立了一个软件原型。测试结果表明,该原型在功能和存储容量方面,已满足初步使用的要求,可作为数据平台下阶段开发的基础。同时,数据平台基于大数据的动态分析功能可应用于价格指数测算工作。文章的研究成果也可为类似软件的设计、开发提供参考。The rise of big data provides a new chance for the development of engineering cost. In order to comply with the develop- merit trend of big data, business structure adjustment and upgrading of the traditional hydropower enterprises, and fully utilize engi- neering cost basic data, research contents of the data platform were established firstly with hydropower, wind power, photovoltaic power as the basic skeleton, and in the horizontal direction research contents was expanded to the construction, transportation, mu- nicipal engineering, water utilities and other areas, while in the vertical direction research contents was extended to the whole process of engineering construction. In order to reflect the hierarchy and systematicness of engineering cost, the cost system of the above ar- eas were analyzed systematically, and the basic price, the equipment price, the main unit cost index, the main technical and economic ndex was extracted. Then the function, data structures and interface of the data platform which possesses the function of data shar- ing, retrieval and analysis were designed, and a software prototype was finally built based on Access. Test results show that the proto- type meets the requirements of the preliminary application in the aspect of function and storage capacity, and it could provide a thor- ough grounding for the development of the data platform for the next phase. The dynamic analysis function of the data platform based on big data could be applied to the price index measurement work. The research results of this paper could also provide a reference for the design and development of similar software

关 键 词：工程造价 数据平台 ACCESS 大数据 

分 类 号：F426[经济管理—产业经济]