{"id":73359,"date":"2011-11-16T13:30:02","date_gmt":"2011-11-16T13:30:02","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/uncategorized\/sql-developer-data-modeler-quick-tip-use-subviews\/"},"modified":"2021-07-14T13:08:06","modified_gmt":"2021-07-14T13:08:06","slug":"sql-developer-data-modeler-quick-tip-use-subviews","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/sql-developer-data-modeler-quick-tip-use-subviews\/","title":{"rendered":"SQL Developer Data Modeler Quick Tip: Use SubViews"},"content":{"rendered":"<p>Modeling is cute when you\u2019re in a class and the sample application is for a rotisserie league for fantasy football, or you need a shopping cart ordering system for online retail. You spend a few hours and might come up with several dozen tables.<\/p>\n<p>But what about in the real world when you are trying to wrap your head around something with several thousand (or more!) objects?<\/p>\n<h2>Enter the SubView<\/h2>\n<p>SubViews allow the user to take a group of entities or objects from the main model area and place them in a separate space. It\u2019s always easier to break down really big problems into smaller, easier to digest pieces. So instead of having the ENTIRE list of VIEWS from SYS in 11gR2, I might only be looking at the views that the SCHEDULER depends on. There\u2019s only 30 or so of those objects.<\/p>\n<p>There are 2 ways to add an object to a SubView<\/p>\n<ul>\n<li>Drag the object from the tree into an existing SubView diagram space<\/li>\n<li>Multi-select the objects from the model space, and choose \u2018Create SubView from selected<\/li>\n<\/ul>\n<p>To get an idea of why this might be necessary, check out how far out I need to zoom to just see all the objects in my model.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2011\/11\/model_subview1.png\" alt=\"\" title=\"\" width=\"623\" height=\"639\" class=\"alignnone size-full wp-image-1261\" \/><\/p>\n<h2>Create the SubView<\/h2>\n<p>Since my objects are all over the model, I need to drag them from the tree to an existing SubView. So I need to create the SubView first. Easiest way to do that is mouse-right-click on the &#8216;SubView&#8217; tree parent node and choose &#8216;New SubView.&#8217; Once it\u2019s created, you\u2019ll see a new model space on the right. If you don\u2019t see it, simply select the new SubView in the tree and mouse-right-click and choose &#8216;Show Diagram&#8217;.<\/p>\n<p>You can find out how to add the objects to the new SubView by reading the the full article at <a href=\"http:\/\/www.thatjeffsmith.com\/archive\/2011\/11\/sql-developer-data-modeler-quick-tip-use-subviews\/\" target=\"blank\">That Jeff Smith.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Modeling is cute when you\u2019re in a class and the sample application is for a rotisserie league for fantasy football, or you need a shopping cart ordering system for online retail. You spend a few hours and might come up with several dozen tables. But what about in the real world when you are trying to wrap your head around&hellip;<\/p>\n","protected":false},"author":316194,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143533],"tags":[],"coauthors":[],"class_list":["post-73359","post","type-post","status-publish","format-standard","hentry","category-oracle-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/316194"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=73359"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73359\/revisions"}],"predecessor-version":[{"id":91798,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73359\/revisions\/91798"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=73359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=73359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=73359"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=73359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}