About Models in Discovery
A Discovery model helps you easily view and understand the resources and relationships in your data resources. A model shows resource tables and views and their relationships to each other and lets you review, edit, and filter those relationships. Part of defining the data source in Discovery is running the indexing and relationship discovery process, which is when Discovery learns about these relationships. (See
Working with Data Domains in Discovery.) A relationship can be a discovered, it can be a foreign key relationship, or it can be manually defined.
You can use a Discovery model to:
• View and learn about the tables in a data source and their related views.
• Graphically explore relationships between resources, including tables, columns, and views.
• Graphically explore relationships between database schemas.
• Explore the details about relationships such as type and cardinality.
• Validate and invalidate discovered relationships.
• Add known relationships.
• Rearrange the model elements and print the model.
• Create a new view based on the tables and relationships displayed model
Overview of Working with Models
Working with models is an iterative process and the steps below are not necessarily sequential
1. Create a new model.
2. Add one or more data sources, catalogs, schemas, tables, or views to the model.
3. Explore the tables, views, and their relationships in the Model and Cross Schema diagrams.
4. Validate or invalidate relationships and modify relationship details.
5. Add relationships.
6. Print the model.