An effective (though uncommon) approach to database design
In database design a lot of effort is spent on ensuring that database designs are perfectly normalized and slated for great performance. But there is one aspect that, though even more important, tends to get a lot less attention: correctness. If a database is completely normalized and performs brilliantly, but won't store the data that the business needs, or allows modification that should be rejected as violating business rules - what use is it?
In this precon, Hugo Kornelis presents a method that enables the database designer to find out exactly what the business needs are. Common pitfalls, such as miscommunications due to abstraction and jargon are avoided because the method relies completely on using concrete examples in the jargon of the business. The method presented tells you exactly what questions to ask, how to ask them, and how the answers to your question should be incorporated in your data model.
At the end of this day, you'll be able to make a conceptual data model for every application, and to transform that data model into a (completely normalized) logical database design.
Sorry, there are no downloads available for this session.
Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server.
In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. For his contributions to the SQL Server community, Microsoft has given him the MVP award in 2006, and every year since.
The video is not available to view online.