Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null vs. Zero for Primary Key
Message
From
22/01/2011 00:24:37
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
01496573
Message ID:
01496978
Views:
65
Really? Companies don't still make copies of their databases for analysis purposes?

Yes, but even then, they're populated incrementally - and sometimes very frequently. I don't know this for a fact, but I've been told by multiple people that the Chicago Transit Authority updates their analytic databases every five minutes. (That's a bit extreme.)

You could go into 10 different companies using SQL Server both for OLTP and OLAP (or OLAP-style) functionality, and find 7-8 different storage and update approaches.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform