Data modelling a general-purpose petroleum geological database
Kenneth J. Chew · Geological Society London Special Publications · 1995
Abstract Experience gained while modelling a petroleum geological database can be summarized as follows. General-purpose database models should reflect the real world, complete with imperfections, and avoid being application-oriented in design. In geological database modelling it is necessary to separate the recording of descriptive features (empirical data) from that of geological processes (concepts). Detailed analysis reveals that many geological relationships assumed to be inherently hierarchical are in fact many-to-many. Ambiguity and inconsistency in definitions should be avoided, if necessary by adopting a definition at variance with industry norms. Use of generic entities simplifies the modelling exercise and can benefit the end-user.