>Hi,
>Can anybody explain or show me some resources about data warehouse? The concept is not lomited to SQL server, but VFP could do so either. Am I correct? Any further info?
>
>Thank you
While I am no expert on this topic, it is my understanding that a data warehouse is a version of your data which is optimized for reporting, and not for updating data. The data warehouse doesn't need to be up-to-date; you might update it from your production data every day, or every week, depending on your needs.
Optimized for reporting means that you don't necessarily obey the usual normalization rules. For instance, you could have the client name stored together with an invoice, duplicated for several invoices that go for the same client; in your production data, client data would be stored in a separate client table, and no client name would be repeated. Having this structure in the data warehouse would simplify reporting; for instance, to get data from invoices, you (or your users, with special reporting tools) can now select invoice data from a single table instead of specifying complicated join conditions to combine several tables.
I hope I am not too way off, in my understanding of what a data warehouse is...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)