Our second big challenge requires a clear and precise definition of the elements in each schema.
There are many different modeling vendors and products that effectively manage disparate sources of metadata.
In addition, there are many different modeling standards to display the metadata relationships such as IDEF1X, UML, IE, and Barker notations.
There are also many different types of metadata. There is metadata that relates to definition and meaning, structure and format, as well as management and policy. And there are many different types of metadata models that capture this information. There are conceptual models, logical models, physical models, relational models, rules models, etc. that capture specific metadata views.
The content of these metadata models is very different depending on whether you are a technical metadata consumer or a business metadata consumer and the various models reflect this level of detail.
These modeling tools and methodologies were developed to meet the unique requirements initially presented by relational databases. These models are well suited to manage the relational database. They are NOT models designed for integration.
JUMP provides a methodology for capturing all of this relevant detail in a single consolidated view.