MongoDB数据库在电力工程行业的应用

Application of MongoDB Database in Power Engineering Industry

[目的]为了贯彻落实国资委《关于加快推进国有企业数字化转型工作的通知》,国有企业面临着数字化转型压力与挑战,很多电力工程企业都在探索数字化转型的方向,利用云大物移智等数字化技术,解决工程项目全生命周期数据的管理是一个重要的前提条件。[方法]针对电力工程项目全生命周期数据的大量性、多样性、复杂性,分析了关系型数据库在大部分场景的不适用性,采用NoSQL数据库MongoDB解决数据量大和数据多样性、复杂性的问题。[结果]作者以MongoDB为核心数据库进行设计构建,完成工程大数据平台建设,实现了电力工程项目过程数据的灵活建模与管理,并作为工程项目全过程的数字化产品的数据底座。[结论]实践应用证明了MongoDB数据库相比于关系型数据库更加适合数据量大、数据多样性、复杂性的场景,存储效率更高,数据查询统计能力更强。

[Introduction]In order to implement the"Notice on Accelerating the Digital Transformation of State-owned Enterprises"issued by the State-owned Assets Supervision and Administration Commission,state-owned enterprises are facing the pressure and challenge of digital transformation.Many power engineering enterprises are exploring the direction of digital transformation,and it is an important prerequisite to solve the management of engineering project life cycle data by using digital technologies such as cloud computing,big data,Internet of Things,mobile Internet,artificial intelligence.[Method]In view of the large volume,diversity and complexity of the whole life cycle data of power engineering projects,this paper analyzed the inapplicability of relational databases in most scenarios,and used the MongoDB,the NoSQL database,to solve the problems of large volume,diversity and complexity of data.[Result]The author designs and constructs engineering big data platform using MongoDB as the core database,which realizes the flexible modeling and management of the process data of power engineering projects,and serves as the data base of the digital products in the whole process of the engineering project.[Conclusion]The research has proved that MongoDB database is more suitable for scenarios with large data volume,data diversity,and complexity than relational database,with higher storage efficiency and stronger data query and statistical capabilities in practical applications.