数据服务在工程数据中心的设计与实现

Design and implementation of data services in engineering data center

随着业务数据种类、数量的增加,系统之间互联互操作复杂性随之增加,为了使庞大的业务数据发挥更大的价值,需要对数据进行综合治理。系统使用SAP主数据模型思想,定义了主表、枚举表、层次表、分类属性表和组合关系表五种数据模型,根据定义的主数据模型生成主数据创建服务和主数据查询服务。通过对建设管理、运维等平台的数据进行梳理后使用模型创建服务和ETL工具web kettle把数据汇集到模型中,通过模型查询服务把梳理好的主数据以API服务的方式提供给其他项目使用。

With the increase of the type and quantity of business data,the interconnection,interoperability and complexity be-tween systems are increased.In order to make the huge business data play a greater value,it is necessary to comprehensively man-age the data.In this system,the idea of SAP master data model is used to establish five data models:master table,enumeration table,hierarchy table,classification attribute table and combination relationship table,and generate master data create service and master data query service according to the defined model.By combing the data of the construction management and operation and maintenance platform,use the model creation service API and ETL tool web kettle to collect the data into the model,and then pro-vide the sorted data to other projects in the form of service through the model query service.