POSC Specifications Version 2.2 Epicentre Logical Data Model

1096 How do you store marker picks

I wish to store marker picks from a wellbore. I can store these as vertexes (wellbore_point), and store the interval that they demarcate (wellbore_interval). I can now instantiate a relationship from the vertex to a feature boundary to say, for example, that the wellbore_pick ('pick 1') is the 'top of Stevens B', 'pick 2' is the 'top of Stevens C', and the wellbore_interval, 'interval 1' is the 'Stevens B sand'. Is this correct? What if I change my interpretation to say that the 'pick 1' is actually the 'top of Stevens A', and that 'interval 1' is the 'Stevens A sand and Stevens B sand'. It seems that I would be in trouble if I had originally instantiated the relationship to the feature_boundary and the geologic_feature. Another question: How do I say that the 'top of Stevens B' and 'top of Stevens C' are the top and base of the 'Stevens B sand'. On way to do this is to instantiate the many-to-many relationship between a geologic_feature and feature_boundary. Another way is to say that the feature_boundary's have a relationship to a face, which is part of a shell, and the shell is the shell that bounds the region, which is the formation. Are these two methods semantically equivalent? Which is preferred? If I do both, are there consistency rules that govern these relationships? And finally, how do I name these to allow a change of interpretation (the 'top of Stevens B' is the top of Stevens B, but the point I pick, and interpreted to be the top of Stevens B may change to be 'top of Stevens A'.)

Consolidated changes: (1095)

Expand relationships from geologic feature to boundary classification

Boundary classification relationships were augmented to allow the explicit association of a boundary to two objects, primary and secondary.

Added objects:
geologic_object (Entity)
geologic_object_association (Entity)
geologic_object_association.primary_geologic_object (Attribute)
geologic_object_association.secondary_geologic_object (Attribute)
geologic_object_association.ref_geologic_object_association (Attribute)
geologic_object.primary_geologic_object_association (Attribute)
geologic_object.secondary_geologic_object_association (Attribute)

Delete Relationships

Deleted the "represent the boundary of" relationships from Rock_feature to Feature_boundary and from Rock_fluid_feature to Fluid_feature_contact because they are redundant to the new Boundary_classification relationships.

Deleted objects:
rock_feature.feature_boundary (Attribute)
feature_boundary.rock_feature (Attribute)
fluid_feature_contact.rock_fluid_feature (Attribute)
rock_fluid_feature.fluid_feature_contact (Attribute)

Modify diagram

Modify the diagram to reflect the changes.

Modified objects:
EMG3:_Feature_Boundaries (Diagram)


Generated on Mon Dec 1 10:15:08 1997
© Copyright 1997 POSC. All rights reserved.