tag:blogger.com,1999:blog-8884584404576003487.post5573568035251178279..comments2024-02-29T09:43:12.251-05:00Comments on ORACLENERD: What's the Purpose of a Datawarehouse?oraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8884584404576003487.post-32878050804259836982009-03-18T09:41:00.000-04:002009-03-18T09:41:00.000-04:00I read a white paper that described a Datamart lik...I read a white paper that described a Datamart like this: The datawarehouse is ... a "data warehouse". OK, that's not very informative, is it? The idea is that the "warehouse" is where rough copies of all data are "stored" (in line with the warehouse metaphor). The datamart is that ETL'd, refined architecture'd, tuned engine'd, etc. version of the warehouse. Of course, all the ETL'ing, refining and tuning takes place in the warehouse, out of the customers' sight. So to be painfully explicit, I guess it's like a furniture store that has its showroom out front where all the customers browse and the giant warehouse out back where other furniture is being retired from inventory, worked on or being put into the sales inventory cycle. I like this metaphor - it makes sense to me; but since I read about it only in one place I thought I'd ask a real-life data guy like yourself if the metaphor is used outside the world of white-paper academia and maybe a handful of hyper-mega-data shops (Federal repositories, Fortune 100 co's, etc.). Thanks for the insight on this topic from your point of view.Unknownhttps://www.blogger.com/profile/14401032504437933147noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-11581451764125457802009-03-17T22:12:00.000-04:002009-03-17T22:12:00.000-04:00We don't currently use the term Datamart but I hav...We don't currently use the term Datamart but I have read where it is interchangeable with datawarehouse. My understanding is that the Datamart is a subset of the Datawarehouse, more akin to a subject area. Hope that helps.oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-77371862479151022702009-03-17T12:21:00.000-04:002009-03-17T12:21:00.000-04:00OK, I just wanted to change one little thing in my...OK, I just wanted to change one little thing in my comment...and I got put through the wringer!! After about 10 min of trying to log on to something, recover a non-existent password...LOL...alright I'll stop whining.<BR/><BR/>Here was my comment (with the one-word change!!):<BR/><BR/>Hey Chet,<BR/>Do you also use the term "Datamart" in your environment? If so, how do you define it, specifically with respect to how it compares to your use of the term "Datawarehouse"? If not, do you think the term/concept has value? Thanks!!<BR/>-MikeOracle Mikehttps://www.blogger.com/profile/01760328824021012693noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-65957305204024003792009-03-17T12:12:00.000-04:002009-03-17T12:12:00.000-04:00This comment has been removed by the author.Unknownhttps://www.blogger.com/profile/14401032504437933147noreply@blogger.com