I will be doing a make up session for the snowed out meeting last winter up at the Montreal Visual Studio User Group.
Conférencier: Stephen Forte, RD New-York, USANote: Cette présentation sera en anglais (yes my French sucks)
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.
2000 McGill College, 4th floor
Page rendered at Wednesday, August 12, 2020 11:55:39 PM (Eastern Daylight Time, UTC-04:00)
The opinions expressed herein are my own personal opinions and do not represent
my employer's view in anyway.