Manage database complexity with modules
- Subject areas,
- Application modules,
Databases get more comprehensible
It's easy to create tables, views, stored procedures etc. It's much harder to delete them as you never know if they are needed. Most databases grow over time in terms of number of objects and those objects are created for different purposes, applications, projects etc. and it's really hard sometimes to find specific objects and figure out what a specific object is used for.
Defining modules and assigning objects to them will help you answer those questions and make large database more manageable.
Title, description, ERD and database objects
In Dataedo, a module consists of a title, description using rich text editor, a list of assigned database objects and an ER Diagram.
Easy to assign
It's easy to assign objects to module. You just go through the list of objects and drag and drop to a module or choose it from the dropdown list.