Within the oil and gas exploration and production industry, larger engineering applications use various unit systems to help maintain data storage according to geographical preferences. This large amount of data requires significant manual effort to manage, which can cause potential human errors during data input and validation. Currently, the industry lacks such a system or tool to help design and validate the unit system preferred for any engineering application.

The solution this paper proposes for advanced unit system data management helps provide data entry and validation through a grid-like structure. The solution is provided in the form of executable/desktop application and web services for interoperability between multiple clients by means of a server system. This tool is intended to provide multiple data entries where the user can import Microsoft® Excel formats and save them directly into the relational database management system (RDBMS) (SQL Server E-Book 2011). The user should be able to copy and paste from Microsoft Excel into the tool user interface (UI) grid (fixed schema being the only limitation). However, it can also provide the flexibility to add single data entries where the user can add/update a field into RDBMS with the necessary information. During multiple or single data entry, the user can save them directly into RDBMS or generate XML or SQL scripts or XML data for interoperability (Bosworth et al. 2003). This solution contains another capability of performing the data validation around the existing data.

This paper discusses the solution for unit data system management. Additionally, discussed are the application, merits, and limitations of this solution. This solution can significantly help improve the efficiency of validating the complex data structure of the unit system metadata information, thus potentially saving a significant amount of manual effort, thereby saving man-hours and eventually associated costs.

You can access this article if you purchase or spend a download.