Want to read Slashdot from your mobile device? Point it at m.slashdot.org and keep reading!

 



Forgot your password?
typodupeerror

Comment: You've got one shot to store your data (Score 1) 147

by clenhart (#48353429) Attached to: Ask Slashdot: Choosing a Data Warehouse Server System?

When a piece of data come in, store it everywhere you need it. This might be aggregated tables (if you don't use indexed views) or whatever you may need. If you have background processes like ETL, you'll use a lot of your hardware for processing at the expense of queries.

Avoid ETL. You've got one shot to store your data everywhere.

In the sciences, we are now uniquely priviledged to sit side by side with the giants on whose shoulders we stand. -- Gerald Holton

Working...