Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Data Modeling tools that support "submodels"? Expand / Collapse
Posted Thursday, June 27, 2013 1:20 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, October 12, 2016 8:11 PM
Points: 891, Visits: 916
Complicated databases have complicated ERDs. Too complicated usually and hard for others to know where to start understanding the database. I am looking for a product that supports information "hiding" in the same way that modern programming languages hide info in functions\subroutines. All that remains in the main source code is a call(s) to the functions\subroutines. From a modeling perspective I would like the option to create my model as usual than create submodels containing related groups of tables. The main model would contain only a "hyperlink" like structure that I click to display\edit the submodel contents in a new window. Get it? The submodel holds the related details and the actual tables are visually removed from the main model (unless I specifically want all tables to be displayed on the main model.) This is more than just using the same color background for related tables. This is information hiding (encapsulation). So, can you recommend any third party products that support this approach?


Post #1468311
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse