DataWarehouse
-
I was a lonely and perfectly satisfied programmer... until they decided to turn me and assign to a project of a datawarehouse! Damn it, I hate to study something new at my age... Hence, I'm spending my time reading about facts and dimensions... anyone got some interesting pointers into the literature though? :-D :-D :-D
A data warehouse maintains its functions in three layers: staging, integration and access. A principle in data warehousing is that there is a place for each needed function in the DW. The functions are in the DW to meet the users' reporting needs. Staging is used to store raw data for use by developers (analysis and support). The integration layer is used to integrate data and to have a level of abstraction from users. The access layer is for getting data out for users. Sathesh. Blessed is the season which engages the whole world in a conspiracy of love.
-
I was a lonely and perfectly satisfied programmer... until they decided to turn me and assign to a project of a datawarehouse! Damn it, I hate to study something new at my age... Hence, I'm spending my time reading about facts and dimensions... anyone got some interesting pointers into the literature though? :-D :-D :-D
-
I was a lonely and perfectly satisfied programmer... until they decided to turn me and assign to a project of a datawarehouse! Damn it, I hate to study something new at my age... Hence, I'm spending my time reading about facts and dimensions... anyone got some interesting pointers into the literature though? :-D :-D :-D
Start with Ralph Kimball's book: http://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247/ref=sr_1_1?ie=UTF8&qid=1290435158&sr=8-1[^] for general concepts. Then you can read a book on the specific technology.
-
Start with Ralph Kimball's book: http://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247/ref=sr_1_1?ie=UTF8&qid=1290435158&sr=8-1[^] for general concepts. Then you can read a book on the specific technology.
Thanks... I'm reading just now the "The Data Warehouse Toolkit" Second Edition, Dimensional Modeling by Ralph Kimball and Margy Ross Cheers
-
A data warehouse maintains its functions in three layers: staging, integration and access. A principle in data warehousing is that there is a place for each needed function in the DW. The functions are in the DW to meet the users' reporting needs. Staging is used to store raw data for use by developers (analysis and support). The integration layer is used to integrate data and to have a level of abstraction from users. The access layer is for getting data out for users. Sathesh. Blessed is the season which engages the whole world in a conspiracy of love.
Dude, wtf? :wtf:
Cheers, विक्रम (Got my troika of CCCs!) "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
-
Dude, wtf? :wtf:
Cheers, विक्रम (Got my troika of CCCs!) "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
You forgot Satips?
-
A data warehouse maintains its functions in three layers: staging, integration and access. A principle in data warehousing is that there is a place for each needed function in the DW. The functions are in the DW to meet the users' reporting needs. Staging is used to store raw data for use by developers (analysis and support). The integration layer is used to integrate data and to have a level of abstraction from users. The access layer is for getting data out for users. Sathesh. Blessed is the season which engages the whole world in a conspiracy of love.
-
You forgot Satips?
Not on your life, I'd merely forgotten the depths he can plumb. In fact, a certain CPian and I have this running inside joke that Satips is just a bot, written by... (dramatic pause) YOU!
Cheers, विक्रम (Got my troika of CCCs!) "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
-
Not on your life, I'd merely forgotten the depths he can plumb. In fact, a certain CPian and I have this running inside joke that Satips is just a bot, written by... (dramatic pause) YOU!
Cheers, विक्रम (Got my troika of CCCs!) "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
Vikram A Punathambekar wrote:
written by... (dramatic pause) YOU!
I wish I was that smart!
-
Start with Ralph Kimball's book: http://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247/ref=sr_1_1?ie=UTF8&qid=1290435158&sr=8-1[^] for general concepts. Then you can read a book on the specific technology.
Nice book indeed. I had that book as the textbook for Data Warehousing in my MS program, and I found it very readable. How did you know about it? Working in a related field?
Regards Senthil _____________________________ My Home Page |My Blog | My Articles | My Flickr | WinMacro
-
Nice book indeed. I had that book as the textbook for Data Warehousing in my MS program, and I found it very readable. How did you know about it? Working in a related field?
Regards Senthil _____________________________ My Home Page |My Blog | My Articles | My Flickr | WinMacro
Some years back I just had the habit to go to bookstores during lunch and read the books in the computer section (unrelated to my work) and buy them if they were good. This was once such book.
S. Senthil Kumar wrote:
Working in a related field?
No, I read books first and then try to make my work relate to that :).
-
Vikram A Punathambekar wrote:
written by... (dramatic pause) YOU!
I wish I was that smart!
Rama Krishna Vavilala wrote:
I wish I was that smart!
Smart? Have you read the drivel he posts?
Cheers, विक्रम (Got my troika of CCCs!) "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
-
Vikram A Punathambekar wrote:
written by... (dramatic pause) YOU!
I wish I was that smart!
Hell, if Satips were human after all, he might be the first to fail the Turing Test :laugh:
Cheers, विक्रम (Got my troika of CCCs!) "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
-
Hell, if Satips were human after all, he might be the first to fail the Turing Test :laugh:
Cheers, विक्रम (Got my troika of CCCs!) "We have already been through this, I am not going to repeat myself." - fat_boy, in a global warming thread :doh:
-
I was a lonely and perfectly satisfied programmer... until they decided to turn me and assign to a project of a datawarehouse! Damn it, I hate to study something new at my age... Hence, I'm spending my time reading about facts and dimensions... anyone got some interesting pointers into the literature though? :-D :-D :-D
If you want off of the project, just suggest they do the thing in Access.
I wasn't, now I am, then I won't be anymore.
-
If you want off of the project, just suggest they do the thing in Access.
I wasn't, now I am, then I won't be anymore.
Don't. Management might take him seriously, and he'll forever more be known as the guy who tried to make a datawarehouse work in Access.
I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be
Forgive your enemies - it messes with their heads