Topic: Database Design Patterns: Architecting the Right Data Model for the Right Application
Architecting an application starts with the database. Different applications need different data models. Fifth normal form is great for an OLTP database, but reporting databases need more of a flat denormalized structure and different Web sites need several different types of data models: eCommerce sites need different data models than traditional publishing sites. You need to optimize your data model for your application's performance needs. Concurrent users, data load, transactions per minute, report rendering, and query seek time all determine the type of data model you will need. See how different applications and different parts of an application can use different data models and how you can architect your database to fit into your application's needs—not the other way around. The presentation will include 5 demos that cover:
1. A Slowly Changing Dimension
2. Fact Tables
3. Horizontal Partitioning
4. Table and Index Partitioning
5. Vertical Partitioning
To find out how to design the right database structure for the right situation come to the meeting.
Presenter: Stephen Forte.
Stephen is the Chief Technology Officer (CTO) and co-founder of Corzen, Inc, a Manhattan (USA) based provider of online market research data for Wall Street Firms. Corzen was recently acquired by Wanted Technologies (TXV: WAN). Stephen is also the Microsoft Regional Director for the NY Metro region and speaks regularly at industry conferences around the world. He has written several books on database development including Programming SQL Server 2005 (MS Press) and is working on Programming SQL Server 2008 (MS Press). Prior to Corzen, Stephen served as the CTO of Zagat Survey in New York City and also was co-founder and CTO of the New York based software consulting firm The Aurora Development Group. He currently is the co-moderator and founder of the NYC .NET Developer User Group. Stephen is also an MBA candidate (June 2008) at the City University of New York (Baruch College).
Location: The meeting will be held at Microsoft, 1290 Avenue of the Americas on the 6th floor starting at 6PM. You must RSVP to wzack at microsoft.com in order to be admitted to the meeting and so that we will know how much pizza and soda to order. J
Sponsor: Our sponsor for the meeting will be Sogeti USA. If you know of any other companies who would like to sponsor a meeting in the future please let us know.