Manufacturing Execution Systems Intellectualization: Oil and Gas Implementation Sample Stepan Bogdan, Anton Kudinov, and Nikolay Markov Tomsk Polytechnic University, Lenin Avenue. 30, 634050 Tomsk, Russia {Bogdan,Kudinovav}@tpu.ru, [email protected] Abstract. Up-to-date trend in industrial automation is implementation of Manufacturing Execution Systems (MES) everywhere and in oil and gas industry. Conception of MES is constantly in progress. Many researches suppose that analytical features, available for low-end users (engineers, dispatchers, geologists, etc.) are necessary in manufacturing management, but today there is no ready-to-use framework applicable to make intelligent manufacturing systems for oil and gas industry. A model-driven approach of MES intellectualization and an original iMES framework proposed. iMES based on functions of the traditional MES (within MESA-11 model), business intelligence (BI)-methods (On-Line Analytical Processing & Data Mining) and production markup language (industrial data standard for oil and gas production). Case study of well tests results validation using iMES framework is considered. Keywords: Manufacturing Execution System, data mining in industry, Manufacturing Process Control, Intellectual Manufacturing Systems. 1 Introduction Continuous process manufacturing is a very sophisticated object to manage, especially if it is an oil & gas production industry. To improve controllability of production management automation and information systems are traditionally implemented. Computer integrated manufacturing (CIM) conception promulgates a fundamental strategy of integrating manufacturing facilities and systems in an enterprise through computers and its peripherals to control the entire production process [1]. According to Williams [2] there are three main architectures widely known: the CIMOSA, the reference model GRAI-GIM and the PERA. Despite selected architecture, according to CIM there are 5 hierarchical levels of information systems of manufacturing enterprise [2]. Zero and first levels are for automation such as sensors and measurement elements. Supervisory Control And Data Acquisition (SCADA), Manufacturing execution system (MES) and Enterprise Resource Planning (ERP) systems are placed on higher appropriate levels. MES market is rapidly growing [3] and lots of MES solutions are now implemented everywhere and in oil & gas production enterprises, but today MES implementation is still a problem [4]. L. Bellatreche and F. Mota Pinto (Eds.): MEDI 2011, LNCS 6918, pp. 170–177, 2011. © Springer-Verlag Berlin Heidelberg 2011 Manufacturing Execution Systems Intellectualization: Oil and Gas Implementation Sample 171 MES conception evolves from MESA-11 model to c-MES model [5]. Nowadays, according to Littlefield [6], MES has outlived its original definition and new conception of manufacturing operations management (MOM) software is the next generation of manufacturing systems. Nevertheless, mass of modern MES are made based on MESA-11 and c-MES models. Effect of MES implementation could be better when it is primarily focused on operational (main) business process management (production process management) [7]. In this article by the term management we mean planning and control plans execution [8]. This article is about enhancing MES by using BI technologies and meta-model based warehouse to fulfill modern oil and gas production management system requirements. 2 MES Intellectualization According to Van Dyk [9] software can provide all functions traditionally expected from MES, but if these functions are not integrated within business process, then such software cannot be counted as a MES. In oil and gas production companies main continuous operational process consist of four sequential parts: production, treatment, transportation and realization of hydrocarbon products. Management of this process crosses several time cycles (minutes, hours, days, months, years) and usually managed by process engineers (technologists), geologists and dispatchers by plans and monitoring systems. In “minutes/seconds” time zoom, fields dispatch units continuously get information from field automation and asynchronously from field production units. In “hour” time zoom a dispatching unit of every field making summary of production indicators to pass it to central dispatch unit. Every day the central dispatch unit distributes manufacturing summary to other organizational units including geological unit and makes daily mission plan to each of field dispatch unit. Geological unit can intervene in the management process if daily manufacturing summary indicates risk of disorder and monthly generates well operating practices plan. Process engineer unit acts like a global supervisor and every year generates a detailed production plan depending on factual wells operating plan execution. According to MES conception its functions cover only dispatching functions on hours/days time cycles of the management process. Production management process is not only data and document flow. Every stage of it involves complex sub-processes of complicated analytics. So there is a problem of the implementation such management process within classical CIM model [1, 2]: well operating practices and plan for production, treatment and realization of hydrocarbon products phases are off the borders of ERP (because of geological and process engineer units, their functions and used data are logically related to MES level) and MES (because of month and year planning periods and advanced analytics are not typical for MES [10]). Furthermore there is a problem of data integration because production data is usually used by different units in different way. There are also various naming styles; it demands a data integration tools implementation. Such solution associated with lots of negative effects such as high cost of solution, integration problems, low maintainability and so on. So general problems are: data integration, naming systems unification and advanced analytical processing. 172 S. Bogdan, A. Kudinov, and N. Markov There are two general approaches to solve these problems: enhancing ERP to work with month and year technological data and enhancing MES by adding BI-systems are usually used to solve analytical processing problem. Both of these approaches are generally based on Intellectual Manufacturing System (IMS) idea [11] and allow using advanced analytics to solve manufacturing tasks, but there is still data integration and naming systems unification problems unsolved. Enhancing ERP to include year planning and well operating practices generation entails transfer of a big part of industrial data to fifth level of CIM. It is contradicts with general idea of CIM where an industrial data stream narrows while moving up to next level [2]. Enhancing MES to include whole production process management in single MES seems as good solution. To use this approach there should be an appropriate framework. Unfortunately, state-of-art IMS theory does not describe an appropriate framework to use in oil and gas production management system design [11]. To solve this problem we propose an industry oriented approach based on MES intellectualization. Our thesis is: enhancing MES functions by using OLAP technologies, data mining techniques (solves analytical processing problems) and meta-model based data marts (solves data integration and naming system unification problems) can provide applicable solution for operational process management without unwanted negative effects listed above. Such enhanced MES we propose to call intellectual MES or iMES. Traditionally MES are based on Online Transaction Processing (OLTP) technologies which optimized to bulk load of real time data. Unfortunately OLTPbased MES are shows low performance for analytical processing. Traditionally business intelligence technologies are used on the higher level of CIM where ERP systems situated, but there are lots of analytical problems on this automation level [11]. For oil and gas production company data mining techniques are very useful especially on two upper levels of production management. Data mining techniques are used to solve some typical industrial analytical problems, but such solutions are usually isolated within specific software that does not come in everyday industrial management practice because of their low integration abilities [12]. iMES conception allows to easily implement any industrial analytics within single homogenous information space to reduce production management uncertainty, decrease human influences, help in finding factors problems and so on. Intellectualizing MES provides lots of possible profits for traditional MES functions. For convenience MES functions and data mining goals [13] were assembled into Table 1. Let consider some examples of data mining implementation in oil and gas industry on MES automation level. For oil and gas production companies clustering can be successfully used in dispatching to determine normal operating practices, anomalies and possible trends of controlled processes. Regression methods can be successfully used in maintenance management to find causes of breakdowns. Classification methods can be widely used all over industry. In oil and gas industry mining methods can be successfully used for well and reservoir modeling, oil and gas production transportation, component composition of hydrocarbon production forecasting, well tests analyzing etc [14]. Manufacturing Execution Systems Intellectualization: Oil and Gas Implementation Sample 173 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Sequence discovery Visualization + + + Regression + Forecasting + Clustering RAS (Resource Allocation and Status) ODS (Operations/Detail Scheduling) DPU (Dispatching Production Units) DOC (Document Control) DCA (Data Collection/Acquisition) LM (Labor Management) QM (Quality Management) PM (Process Management) MM (Maintenance Management) PTG (Product Tracking and Genealogy) PA (Performance Analysis) Classification MESA-11functions Association Table 1. Common data mining tasks in MES applications + + + + To let oil and gas specialists use the power of data mining in their daily work within MES context, iMES implementation needed. We propose iMES framework to make MES intellectualization easier and cheaper than providing solutions for every analytical problem that can appear in oil and gas production management. Proposed framework to enhance MES for oil and gas production is shown on Figure 1. Automatic control systems continuously obtain industrial data, which comes into production database by OPC1 protocol. After industrial data processing it loads in the common warehouse. Based on oil and gas industry data definition standards (PRODML, WITSML, RESQML2) data marts are based on common warehouse. These standards define hierarchical data models for most common oil and gas task groups. They are tightly connected with each other but intended for other purposes. This problem can be solved by OLAP implementation. Data mining models and analytic queries use general warehouse and/or data marts as data sources. Results of data mining can be presented to user by iMES client or other software. This framework is very useful: it consolidates and standardizes heterogeneous data needed on every stage of management of operational process; it allows making analytics of any complicity; it can be source of data for other applications (this is essential in manufacturing summary data population) etc. To improve an efficiency of the framework implementation we could highly recommend developing both OLTP and BI server parts of the iMES using integrated data management platform (like Oracle BI Suite, Microsoft SQL Server with Analysis Servises, etc.) 1 2 OLE for Process Control Production Markup Language, Wellsite Information Transfer Standard Markup Language, Reservoir Characterization Markup Language (www.energistics.org). 174 S. Bogdan, A. Kudinov, and N. Markov Fig. 1. iMES framework Next part of this article is a case study of solving practically significant problem for oil and gas industry using proposed industry oriented metamodel-driven approach to MES intellectualization (iMES framework). 3 Case Study: Well Test Validation As an example of practical usage of iMES well test validation problem was used. There are several different well test types; only production tests are considered in this article. There are 3 popular formal methods of data mining: KDD1, SEMMA2 and CRISP-DM3 [15]. To describe possible solution of this problem industry- and toolneutral data mining process model (CRISP-DM) was implemented. It involves next sequential phases: Business Understanding, Data Understanding, Data Preparation, Modeling, Evaluation and Deployment. Business Understanding, Data Understanding and Data Preparation. Well dynamics are very complicated. Analytical processing of well tests results is aimed to make more accurate well operating practices plans as an important phase of oil and gas production management [14]. There is a problem of classifying well test results as valid or invalid. This classification depends on lots of factors such as random distortion, features of field exploitation, production intensification activities, production management style and others. So in practice geologists use complex expert estimation to make a decision: to use or not to use well test result data in later calculations. To support such decision making statistical models can be implemented. The goal is to create a model which can automatically estimate well test results and suggest validity of them using their history with predictive accuracy at least 75% [14] for the most common test results. To solve such analytical problems iMES framework disposes data-mart level as a source of data to generate data models. For the well test validation PRODML-based Manufacturing Execution Systems Intellectualization: Oil and Gas Implementation Sample 175 data mart of iMES framework should be used. Actually PRODML is a hierarchical object model so to use it for online analysis it must be transformed to multidimensional model. This model in iMES framework consists of six tightly connected parts: Installed System (describes wells equipment), Measurements (contains history of different on-field measures), Product Operation (contains a history of on-field equipment usage), Product Flow (contains a history of product flow through nodes), Product Volume (contains a history of product volumes storage), Well Test (contains a factual information about different types of well tests performed). The data is collected by MES into production database and then filtered and validated it comes to common warehouse and goes to PRODML-based data mart. Well production test data of each test can be described by about 30-50 (depends on types of fluids) standard attributes such as test date, well head temperature, flowing pressure, flow line pressure, pOverZ, choke orifice size, gas oil ratio, fluid velocity, gas potential, gas volume, pressure drawdown, gas rate, gas density etc. As a base dataset we used gas well production tests history of JSC Vostokgazprom3 for a period of 1998-2011 years. All data was previously loaded from papers to database and verified by experts. Whole dataset is 3528 results of well tests. Only 2319 of dataset were classified by experts as valid and 1209 as invalid. For this dataset missing values in well tests attributive part are common so model should consider them correctly. Modeling. There are several types of classification methods such as clustering, neural networks, decision trees and others. Comparison of different modeling methods is out of the scope of this article. The article shows practical benefit of data mining application in MES level of oil and gas production company. To generate a statistical model for well test results Microsoft Decision Trees algorithm [16] algorithm was used. As result we have got a tree-structured model shown on Figure 3. Fig. 3. Tree-structured model of well test validity Values in circles mean amount of well tests estimated as valid (in percent). This model shows that hypothesis about well test estimation can be successfully done basing on gas rate and pressure drawdown is invalid on current dataset because 3 www.vostokgazprom.ru 176 S. Bogdan, A. Kudinov, and N. Markov obtained classifiers are annulus pressure, bottom hole temperature pressure drawdown and stratum type. According to proposed iMES framework tree-structured data model should be implemented within analytic module on appropriate level. Evaluation and Deployment. 82% of well test results were correctly classified by model. It is better than 75% stated as criteria above (other not boosted tree algorithms did not showed a significantly better accuracy). So this model can be used for preestimation of well test results validity and help geologist to make decision. From user side workflow of well test validation is very easy: every new well test substitutes from user interface and shows model based validity estimation. Geologist can agree or disagree with this recommendation. Each disagreement causes model recalculation. Further experience. Shown well test classification generously based on manually inputted data through user interface, but using iMES conception specialists can easily mix such manual data and automatically gathered data. A practical example of it is using iMES to identify features of defective equipment. From time to time on field automation marks sensor measured value as "bad". There are lots of possible reasons for this. Using data mining we can find features that can help experts to solve the problem of "bad" data. Automatically gathered data from thousands of sensors on fields of Vostokgazprom were processed on data preparation level of iMES and loaded on warehouse level (Fig. 1). Then were selected data sources of the most frequent "bad" marked values toward all data (gathering such statistics is resource-intensive for OLTP systems but easy for OLAP systems). After that obtained processed data was mixed with static data describing data sources on data mart level of iMES. Using Microsoft SQL Server Analysis Services data mining algorithms several mining models were built. As a result of subsequent querying general features of defective data sources were found. Analysis shown that defective data source is usually a pressure sensor set on pump of exact type, produced in 19982000 periods by a single manufacturer and installed outdoors. This mined knowledge saved resources of specialists to find the reason of "bad" data, and gave them useful analytical data to replace defective equipment. These samples show that iMES conception can be successfully used in oil and gas and possibly on other industries. Today most of organizational units in Vostokgazprom are involved in MES context, so deployment of this model should be made in tight connection with MES “Magistral-Vostok”4 implemented here. Before deployment of our model MES “Magistral-Vostok” was intellectualized as describe above. It allowed: to consolidate needed data for our model, to deploy our model on appropriate level of iMES between other possible data mining models and analytic functions, to make needed feedback for continuous model improvement, to easily use results of automatic well tests estimation at MES client-side etc. MES “Magistral-Vostok” made using Microsoft technologies (Microsoft SQL Server). Success of this solution has been proven by practical usage in Vostokgazprom for a several years [17]. 4 mes-magistral.ru Manufacturing Execution Systems Intellectualization: Oil and Gas Implementation Sample 177 4 Conclusion MES play a huge role in modern industry management. Despite the rapid evolution of MES conception, classical MESA-11 [12] is a common architecture for such systems. We stand for future intellectualization of MES. There are samples of IMS implementation in industry, but there are no actual frameworks which can be easily applied for oil and gas industry. We propose the meta-model driven approach to MES intellectualization and framework to design iMES. Shown example of MES intellectualization for oil and gas production company and its practical benefits let us assume that analogous approach can be implemented almost everywhere where MES is suitable. References 1. Nagalingam, S.V., Lin, G.C.I.: Latest developments in CIM. Robotics and Computer Integrated Manufacturing 15, 423–430 (1999) 2. AMICE Consortium: Open System Architecture for CIM, Research Report of ESPRIT Project 688, vol. 1. Springer-Verlag (1989) 3. Logica, MES Product Survey 2010. Logica 526 (2010) 4. Shaohong, J., Qingjin, M.: Jinan Research on MES Architecture and Application for Cement Enterprises. In: ICCA 2007, May 30-June 1, pp. 1255–1259. IEEE, Guangzhou (2007) 5. MESA International, http://www.mesa.org/en/modelstrategicinitiatives/MESAModel.asp 6. Littlefield, M., Shah, M.: Management Operation Systems. The Next Generation of Manufacturing Systems, Aberdeen Group, 19 (2008) 7. Hammer, M., Champy, J.: Reengineering the Corporation: A Manifesto for Business Revolution. Harper Business, New York (1994) 8. Kanter, J.: Management-Oriented Management Information Systems, 2nd edn., p. 484. Prentice Hall, Englewood Cliffs (1977) 9. Van Dyk, L.: Manufacturing execution systems. M.Eng. dissertation. University of Pretoria, Pretoria (1999) 10. ANSI/ISA-95.00.03-2005 Enterprise-Control System Integration, Part 3: Models of Manufacturing Operations Management 11. Christo, C., Cardeira, C.: Trends in Intelligent Manufacturing Systems. In: ISIE 2007, June 4-7, pp. 3209–3214. IEEE, Vigo (2007) 12. Hand, D.J., Mannila, H., Smyth, P.: Principles of Data Mining, Massachusetts Institute of Technology, 378 (2001) 13. Ngai, E., Xiu, L., Chau, D.: Application of data mining techniques in customer relationship management: A literature review and classification. Expert Systems with Applications 36(2), 2592–2602 (2009) 14. Al- Kaabi, A.U., Lee, J.W.: Using Artificial Neural Nets To Identify the Well – Test interpretation Model, SPE 28151 (1993) 15. Azevedo, A., Santos, M.P.: KDD, SEMMA and CRISP-DM: A parallel overview. In: IADIS European Conference Data Mining, Amsterdam, July 24-28, pp. 182–185 (2008) 16. Larson, B.: Delivering Business Intelligence With Microsoft SQL Server 2008, p. 792. McGraw-Hill Osborne Media, New York (2008) 17. Bogdan, S., Kudinov, A., Markov, N.: Example of implementation of MES MagistralVostok for oil and gas production enterprise. In: CEE-SECR 2009, October 28-29, pp. 131–136. IEEE, Moscow (2009)
© Copyright 2024