Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Null vs. Zero for Primary Key
Message
De
22/01/2011 00:24:37
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
01496573
Message ID:
01496978
Vues:
69
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform