Search mechanism enhancement of ageodatabase for prompt data retrieval and business reporting

Abstract

The purpose of this paper is to present a system design that significantly improves the design and search mechanism of a geodatabase system in the oil and gas, exploration and production sector. The increasing exploration activities in our country require rich collection of related exploration data which need to be stored in a geodatabase in an organized fashion while maintaining integrity of the data with a consistent, accurate database and applying sophisticated rules and relationships to the data. Weconduct a study of the integration of a geodatabase model design with a metadata model design in the database tier. The application tier of the geodatabase contains a metadata search mechanism that enhances retrieval of data when a query is executed. We alsocompare the time taken to execute a query on a metadata search algorithm to one that has no algorithm implemented, and found that the performance of the metadata search indexing caused the search run four times faster. We give an in-depth modeling of the geodatabase and the inter-relationships between the objects identified in the cause of the research.