here is what you have:
- main diagram containing all objects - if you are going to have large model then don't touch it
- subview - you can put set of objects on it related to specific area
- display - contains the same set of objects belonging to subview - idea is to have different presentation of objects on displays - details level, to hide some elements, to change color (for that display)
In subview you can hide relationships/foreign keys.
You can create a network of "overview" subviews - you can use drag&drop on browser and drop one subview in another subview; you'll get icon representing the source subview - in context menu you can select to be "Composite view" and you'll get diagram (can enlarge it) and can select which display to be represented. Then using "View diagram" you can go to represented subview. There you can use "Go to diagram" (in context menu of diagram) and to navigate back .
Thanks Philip. Your idea is brilliant and that is what I have thought. The problem is that I can't create that tree of subviews in Oracle Data Modeler.
Could you please be more specific? I try to drag one subview into another subview (both at the same level) in the Logic model but Oracle Data Modeler (versión 3 or 4) doesn't allow it. All the subviews I have created are at the same level, which is a complete mess to handle a model of a big database.
I have searched much information but no clues. I really appreciate very much your help.