Since I want to build a role-based security system, a database might prove useful. Furthermore, instead of blathering on and on about what the database looks like, how about a shapshot of the dataset? Ok, I'm blathering. if the image to the left is a little small, click on it for an enlarged version.
posted by Darrell Hawley at
6:15 PM
Darrell Hawley is a C# developer working with both web and windows applications. Currently, he is working in the automotive sector with a team of engineers and software developers solving complex engineering problems using the .NET Framework. During a four year stay at a Farmington Hills, MI advertising company, he streamlined business processes and acted as the company SQL Server administrator. He has also worked with WCF, WSE, Web Services, VB6, VBA, VBScript and ASP. He recently has been researching Python and IronPython and is actively involved in the Ann Arbor .NET Developers Group.
3 Comments:
Darrell,
What too are you using for the data modeling, and how is it that the function calls are integrated with the db? Is this all .net stuff. The graphic reminds me of access.
By
Dave Halliwill, at Fri Sep 22, 09:46:00 AM
The graphic in the post depicts a Dataset in Visual Studio 2005. Since this closely resembles a class diagram, any number of UML tools could do the same job. I personally use Enterprise Architect whenever I do any modeling. I stumbled across the My Little UML (Tools) Page which has quite a list of UML tools that you may want to investigate. Hope this helps.
By
Darrell Hawley, at Fri Sep 22, 10:11:00 AM
A point I would like to make about using Visual Studio 2005 for "data modeling". This isn't really modeling. It's a graphic representation of a Dataset, which in turn is a reflection of a portion of a database, which, of course, I modeled using a UML tool (Enterprise Architect). This designer is meant to reduce the amount of code you are writing, not model. To model, you would want to use a modeling tool (VS2005 comes with a UML tool in one of the editions, I forget which one).
I also realized that I did not cover all of Dave's question(s). If you are not up on your UML, The diagram that you are looking at in this post would be considered a "class diagram". Class diagrams contain classes (not database tables, though class diagrams are incredibly useful for putting together your database). A class is designated as a "partitioned" rectangle. The top partition contains the name, the middle partition contains the attributes or properties and the bottom partition contains the operations. Honestly this is one of my favorite types of diagrams in all of UML. It was the first one that I learned and, I feel, the easiest to implement. Describe a project you are working on and then write-down every noun you say. these are your classes. Then try to describe how they are related to one another. This will reveal your primary and foreign keys. Now start arranging them and describing the things that they do or properties they have. Naturally, if you talk to some UML folks that may have some different ideas. Martin Schumaker will extol the virtues of the 5-step UML process which I have sloppily, yet successfully implemented in the past. Both Scott Ambler and Martin Fowler are considered leaders in the field.
By
Darrell Hawley, at Fri Sep 22, 10:56:00 AM
Post a Comment
<< Home