![]() ![]() Any network diagram quickly morphs into a birds-nest diagram if you try to do too much. Be wary about including too much in a diagram. Obviously, there is plenty more you can include but there is something to be said for having just one clear message to every diagram. …but you can of course use it with any other database object such as dbo.ufnGetContactInformation. …and copied the result from the results pane (use text mode and set the ‘ Query‘ ‘ Options‘ -> ‘Results’ -> ‘Text’ -> ‘Maximum number of characters displayed in each column‘ to 8192 or some other generous figure) All I did to do this was to use the text: Note that schemas have been represented as folders. 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 |