1

As title, I always had a feeling that data warehouse should only support for data analysis or the like, but shouldn't be used in real time transactions. (eg. being a data source to provide a product info for a cart purchase about to happen).

Could anyone share any views?

closed as unclear what you're asking by Michael Green, Shanky, Philᵀᴹ, Tom V, Marian Apr 26 '16 at 8:48

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Google Analytics is essentially a data warehouse and supports "real time" data, such as current visits – Neil McGuigan Apr 25 '16 at 22:15
  • @NeilMcGuigan thank you for the example, but I think GA's "real time" data is an estimate, not accurate numbers, as for indication purpose. I might be wrong. – James Lin Apr 26 '16 at 2:29
0

You are correct. The reason for this is the current situation, in which the transactional database is usually separate from the analytical database, and therefore isn't up to date.
While up to date technologies like Data Vault could mean that you would use the same database for transaction and analytics, a situation in which you need to aggregate data from more than one data source could still means that you need ETL process, and therefore your analytical data isn't "up to date ". So: analytical database gives you changes accross time, but if you want to know what goes on right now, use transactional database.

Not the answer you're looking for? Browse other questions tagged or ask your own question.