![]() I’ve always been caught out by views so it would be nice to see those objects in the database that a view references. Let’s look at AdventureWorks, just so we can try things out. Data Modelling With Unified Modelling Language (UML) ![]() We’ll just stick to showing a subset of your database objects and the dependencies between them. PlantUML uses simple text-based instructions to render UML diagrams and these can be generated from SQL to show you such things as the intricacies of your database permission system, the foreign-key dependencies, or the details of your indexing strategy for a table. You can use your favourite editor via a command-line interface as well. I use AsciiDocFx, which installs the prerequisites for you (though you may need to set the path to your GraphViz install. If you want to use PlantUML from the command-line, there are install instructions here. If you use DocuWiki for documentation, there is an add-in for PlantUML, which is handy for teams since there is nothing to install on your machine then. There are several Atom packages that add PlantUML integration. Chrome has an Add-in that runs PlantUML called the UML Diagram Editor. With that, and the PlantUML manual, you should be well away with using this interesting application. To get you started, there is a little browser application here on the PlantUML site that allows you to type in PlantUML code and view the results. I will use TSQL code to create the PlantUML code directly. In this article I’m going to show how it can be used to easily generate class diagrams for database objects. ![]() For a relational database person who winces at the terms ‘class’ and ‘persistence’, even UML modelling has its uses as a way of communicating ideas and designs. Although you may have little urge to use UML diagrams in your everyday work, PlantUML is versatile enough to provide for a range of requirements.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |