The multidimensional analysis engine data management platform is constructed using big data distributed storage and parallel computing,data warehouse modeling technology,realizing the optimal management and instant qu...The multidimensional analysis engine data management platform is constructed using big data distributed storage and parallel computing,data warehouse modeling technology,realizing the optimal management and instant query of distributed oil and gas production dynamic big data.The centralized management and quick response of the production data of more than 36×10^4 oil,gas and water wells is realized.Multidimensional analysis subject model of oil,gas and water well production is built to pretreat the relevant data.At the level of China National Petroleum Corporation(CNPC),the rapid analysis and applications such as oil and gas production tracking,early production warning of key oilfields,analysis of low production wells and long shutdown wells,classification of reservoir development laws have been realized,and the processing time has been shortened from 1 d to 5 s.The basic unit of oil and gas production analysis is refined from oilfield to single well,making the production management more detailed.The process can be traced step by step according to CNPC,oil field company,field,block and single well,and the oil and gas production performance of each unit can be mastered in real time.展开更多
Workflow logs that record the execution of business processes offer very valuable data resource for real-time enterprise performance measurement. In this paper, a novel scheme that uses the technology of data warehous...Workflow logs that record the execution of business processes offer very valuable data resource for real-time enterprise performance measurement. In this paper, a novel scheme that uses the technology of data warehouse and OLAP to explore workflow logs and create complex analysis reports for enterprise performance measurement is proposed. Three key points of this scheme are studied: 1) the measure set; 2) the open and flexible architecture for workflow logs analysis system; 3) the data models in WFMS and data warehouse. A case study that shows the validity of the scheme is also provided.展开更多
针对我国当前业务型的水利信息管理系统难以获取隐含信息的问题,提出基于数据仓库技术和OLAP技术设计开发水利工程信息管理系统的解决方案。系统使用Java作为开发语言,后台数据库采用SQL Server 2005系统,使用SQL Server中的数据仓库工...针对我国当前业务型的水利信息管理系统难以获取隐含信息的问题,提出基于数据仓库技术和OLAP技术设计开发水利工程信息管理系统的解决方案。系统使用Java作为开发语言,后台数据库采用SQL Server 2005系统,使用SQL Server中的数据仓库工具建立数据仓库。根据需求分析,系统确定获取渠道、科室和资金3个主题的隐含信息,并采用查询效率较高的星型模型作为概念模型,通过事实表设计和维度表设计来完成3个主题设计的具体实现。展开更多
基金Supported by the China National Science and Technology Major Project(2016ZX05016-006).
文摘The multidimensional analysis engine data management platform is constructed using big data distributed storage and parallel computing,data warehouse modeling technology,realizing the optimal management and instant query of distributed oil and gas production dynamic big data.The centralized management and quick response of the production data of more than 36×10^4 oil,gas and water wells is realized.Multidimensional analysis subject model of oil,gas and water well production is built to pretreat the relevant data.At the level of China National Petroleum Corporation(CNPC),the rapid analysis and applications such as oil and gas production tracking,early production warning of key oilfields,analysis of low production wells and long shutdown wells,classification of reservoir development laws have been realized,and the processing time has been shortened from 1 d to 5 s.The basic unit of oil and gas production analysis is refined from oilfield to single well,making the production management more detailed.The process can be traced step by step according to CNPC,oil field company,field,block and single well,and the oil and gas production performance of each unit can be mastered in real time.
文摘Workflow logs that record the execution of business processes offer very valuable data resource for real-time enterprise performance measurement. In this paper, a novel scheme that uses the technology of data warehouse and OLAP to explore workflow logs and create complex analysis reports for enterprise performance measurement is proposed. Three key points of this scheme are studied: 1) the measure set; 2) the open and flexible architecture for workflow logs analysis system; 3) the data models in WFMS and data warehouse. A case study that shows the validity of the scheme is also provided.
文摘针对我国当前业务型的水利信息管理系统难以获取隐含信息的问题,提出基于数据仓库技术和OLAP技术设计开发水利工程信息管理系统的解决方案。系统使用Java作为开发语言,后台数据库采用SQL Server 2005系统,使用SQL Server中的数据仓库工具建立数据仓库。根据需求分析,系统确定获取渠道、科室和资金3个主题的隐含信息,并采用查询效率较高的星型模型作为概念模型,通过事实表设计和维度表设计来完成3个主题设计的具体实现。
