Reference Synthetic Dataset for Drilling Inventory Optimization
Authors: Abdelaziem O. E. , Khafagy R. M. , Darwish H. M. , Abdelrahman M. M. 
Published: September 2024

Summary
Data analytics holds immense importance in optimizing inventory management in the oilfield due to its significant business impact. However, the progress of research is limited by restrictions of sharing inventory data publicly, owing to privacy concerns. This paper introduces a novel synthetic dataset for drilling inventory systems in oil-integrated companies, which shall offer a valuable open-source reference for future studies. Additionally, diverse analytical approaches were employed to showcase their effectiveness in leveraging cost reductions.
Generating synthetic datasets involves the implementation of data-driven and process-driven methodologies. Given the inherent risk of endogeneity bias, a process-driven approach, combined with domain knowledge, was followed. Primarily, pre-defined criteria were established to govern dataset generation while accounting for various possible well templates. In essence, multiple constraints outlined the relationship among oil prices, expected annual drilling activities, timing and cost of item receipts, and the interdependence of item quantities and issuances. Next, controlled noise was introduced to account for irregularities and periodic inclusion of cutting-edge items. Ultimately, diverse inventory scenarios were subjected to analytics and optimization.
The introduced inventory dataset is characterized by randomness, rule-based procedure, and iterative process. It allows replicability and adaptability to divergent layouts by virtue of user-defined parameters. Overall, it possesses a history of transactions that extends over 20 years, exhibits an average asset value of 5 million USD, features around 500 unique stock keeping units (SKUs), and accommodates more than 15,000 transactions, such as receipts, issues, returns, sales, loans, inspections, and junks. Initial inventory volume was estimated based on the drilling activities of a hypothetical medium-sized oil company that operates an average of 10 drilling and workover wells per year. The generated dataset covers abundant specifications of multidisciplinary SKUs, covering tubular goods, drilling accessories, completion equipment, and wellhead materials. Items were selected delicately to represent diverse well configurations, encompassing sidetracks, slim holes, gravel-packed wells, artificially lifted wells, and dual producers. Furthermore, probable mistakes and human errors were taken into account, to improve the system’s reliability to closely mimic real-world conditions. Subsequently, and upon investigating various Key Performance Indicators (KPIs), it was observed that analytics and clustering techniques are promising in elucidating latent challenges, maximizing profits, and achieving cost savings up to 10% of the inventory’s total value.
This paper presents a novel, openly accessible synthetic dataset for drilling inventory systems in oil-integrated companies for the first time in literature, to the best of authors’ knowledge. The introduced dataset was meticulously designed to ensure scalability and minimize drift. Positioned as a reference for future research, this dataset aims to drive forward the advancement of research in analytics and machine learning, to deliver ingenious solutions for inventory management optimization in digital oilfields.