Speaking at the NYC SQL Server User Group tonight on Database Design Patterns, the popular TechEd Session. Click here to register.
Meeting Location:Microsoft New York City Office1290 Ave of the AmericasSixth FloorNew York, NY 10104
Meeting Time: 6pm.
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 and not the other way around.
Page rendered at Saturday, December 5, 2020 7:10:22 AM (Eastern Standard Time, UTC-05:00)
The opinions expressed herein are my own personal opinions and do not represent
my employer's view in anyway.