I’m proficient with ERwin and recently had the opportunity to try ER/Studio. I must say that I was impressed. ER/Studio is the best data modeling tool that I’ve seen to date. My experiments did not cover every aspect. But I did look at enough features to form a clear opinion.
picture by Alejandro via Flickr
Over the years we’ve seen a number of projects where application architects use a generic layer to hide a database. This is a common approach with object-oriented languages accessing a relational database. Application code accesses the layer which in turn accesses the database. The use of a generic layer can be a valuable technique, but it is overused. Some architects seem to be unaware that there are other possibilities.
picture by lili chin via Flickr
The UML is a popular notation for modeling software. Even though the UML was mostly developed for programming, it is also relevant for databases. This article takes a critical look at using the UML for databases.