智能土石方调配系统的数据库设计

Database Design for Intelligent Earth-rock Volumes Allocation System

智能土石方调配系统对工程数据、生产数据和地理空间数据进行数字化,存入数据库服务器,根据工程进度计划,利用动态线性规划算法,生成任意时间跨度的土石方调配方案。由于大型工程数据量巨大,影响土石方调配方案的边界条件众多,且实际施工现场数据处于动态变化之中,因此智能土石方调配系统的数据库设计的好坏,直接关系到整个土石方调配平衡方案的可信度、可操作性和运行质量。通过需求分析,设计了数据库结构,开发了智能土石方调配系统并应用到世界最高的面板坝的土石方调配方案优化分析中,数据库运行状况良好,提高了土石方调配方案的准确性和可操作性。

Earth-rock volumes allocation scheme in any time range can be generated using dynamic linear planning algorithm by an intelligent earth-rock volumes allocation system, which collects all project data and geographical data and digitizes them into database server. The reliability, feasibility and quality of operation of the generated scheme is influenced by database structure because of tremendous data of the project which change frequently. By analyzing requirements, a database structure is designed and an intelligent earth-rock volumes allocation system is developed and the system is successfully applied in the highest rock-fill dam in the world currently and the database system runs well. The results of computer simulation based on project data and historical construction data are technically feasible and better than those of traditional construction management ways.