RE: Data Warehouse experts, a simple question for you| Outdated?
Dang, he found out my nefarious plot to so twist your minds that you would all become my slaves. I am far from expert on Oracle in general. On data warehousing I am the merest of newbies. Pass that tequila bottle this way if you're done with it sir! Rachel --- Jack Silvey [EMAIL PROTECTED] wrote: can't resist asking ... since *this* answer advises us not to trust your answers, aren't you in fact saying that we should not trust this answer, which of course means that your answers *are* in fact trustworthy? The everything I say is a lie scenario that Kirk used in that one Star Trek episode to confuse the robot until it blew up? (might be time to put away the tequilla now and go to bed, Jack) ;) /jack --- Rachel Carmichael [EMAIL PROTECTED] wrote: you can ask... and if you actually TRUST the answers I give, well, you are insane --- [EMAIL PROTECTED] wrote: And that means we can all now ask Rachel our Datawarehousing questions and not RTFM :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23-05-2002 11:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms
RE: Data Warehouse experts, a simple question for you| Outdated?
Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in front of management such that nobody knew what anybody was talking about. - And the DBAs said that creating a data warehouse or data mart was not nearly as hard as figuring out what to call it. The moral of the story is to figure out what you need to do and be aware that different authors use the same terms for different purposes and coin their own terms. Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Outdated? Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated. There is so much good information in that book though, that it's still worth its weight in gold. You won't find too many publications for $60 that will take you step by step through building an entire data warehouse, including the infrastructure. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? I am new to his books, three chapters in. The first release of the Data Warehouse Toolkit defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized structure which stores information from various sources. We build data marts with structures optimized for querying; e.g., star schemas, from the warehouse. Kimball writes of the warehouse itself being based on a star schema. The term data warehouse has not been immutable over the years. It was probably defined exactly as he has done when the book was first written. Do his new books redefine data warehouse? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:16 PM To: Multiple
RE: Data Warehouse experts, a simple question for you| Outdated?
Is there such a thing as being TOO knowledgable and well-read? I don't think so! /jack Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in front of management such that nobody knew what anybody was talking about. - And the DBAs said that creating a data warehouse or data mart was not nearly as hard as figuring out what to call it. The moral of the story is to figure out what you need to do and be aware that different authors use the same terms for different purposes and coin their own terms. Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Outdated? Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated. There is so much good information in that book though, that it's still worth its weight in gold. You won't find too many publications for $60 that will take you step by step through building an entire data warehouse, including the infrastructure. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? I am new to his books, three chapters in. The first release of the Data Warehouse Toolkit defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized === message truncated === __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services
RE: Data Warehouse experts, a simple question for you| Outdated?
everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Outdated? Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated. There is so much good information in that book though, that it's still worth its weight in gold. You won't find too many publications for $60 that will take you step by step through building an entire data warehouse, including the infrastructure. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? I am new to his books, three chapters in. The first release of the Data Warehouse Toolkit defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized structure which stores information from various sources. We build data marts with structures optimized for querying; e.g., star schemas, from the warehouse. Kimball writes of the warehouse itself being based on a star schema. The term data warehouse has not been immutable over the years. It was probably defined exactly as he has done when the book was first written. Do his new books redefine data warehouse? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:16 PM To: Multiple recipients of list ORACLE-L I second Jared's opinion. Ralph's books are clear and easy to read. This is the fundamentals of data warehousing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate === message truncated === __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you| Outdated?
Oh yeah...oh yeah!! Oracle Data Warehousing 101 coming up -Original Message- Sent: Thursday, May 23, 2002 9:13 AM To: Multiple recipients of list ORACLE-L Outdated? Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in front of management such that nobody knew what anybody was talking about. - And the DBAs said that creating a data warehouse or data mart was not nearly as hard as figuring out what to call it. The moral of the story is to figure out what you need to do and be aware that different authors use the same terms for different purposes and coin their own terms. Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Outdated? Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated. There is so much good information in that book though, that it's still worth its weight in gold. You won't find too many publications for $60 that will take you step by step through building an entire data warehouse, including the infrastructure. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? I am new to his books, three chapters in. The first release of the Data Warehouse Toolkit defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized structure which stores information from various sources. We build data marts with structures optimized for querying; e.g., star schemas, from the warehouse. Kimball writes of the warehouse itself being based on a star schema. The term data warehouse has not been immutable over the years. It was probably defined exactly as he has done when the book was first written. Do his new
RE: Data Warehouse experts, a simple question for you| Outdated?
read my electrons here: I AM NOT WRITING ANOTHER BOOK. --- Grabowy, Chris [EMAIL PROTECTED] wrote: Oh yeah...oh yeah!! Oracle Data Warehousing 101 coming up -Original Message- Sent: Thursday, May 23, 2002 9:13 AM To: Multiple recipients of list ORACLE-L Outdated? Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in front of management such that nobody knew what anybody was talking about. - And the DBAs said that creating a data warehouse or data mart was not nearly as hard as figuring out what to call it. The moral of the story is to figure out what you need to do and be aware that different authors use the same terms for different purposes and coin their own terms. Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Outdated? Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated. There is so much good information in that book though, that it's still worth its weight in gold. You won't find too many publications for $60 that will take you step by step through building an entire data warehouse, including the infrastructure. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? I am new to his books, three chapters in. The first release of the Data Warehouse Toolkit defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized structure which stores information from various sources. We build data marts with structures optimized for querying; e.g
Re: Data Warehouse experts, a simple question for you| Outdated?
That's not panicking, just common sense. Too many data warehouse projects went down the drain so you need to learn all you can before starting such project. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 3:13 PM Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in front of management such that nobody knew what anybody was talking about. - And the DBAs said that creating a data warehouse or data mart was not nearly as hard as figuring out what to call it. The moral of the story is to figure out what you need to do and be aware that different authors use the same terms for different purposes and coin their own terms. Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Outdated? Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated. There is so much good information in that book though, that it's still worth its weight in gold. You won't find too many publications for $60 that will take you step by step through building an entire data warehouse, including the infrastructure. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? I am new to his books, three chapters in. The first release of the Data Warehouse Toolkit defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized structure which stores information from various sources. We build data marts with structures optimized for querying; e.g., star
RE: Data Warehouse experts, a simple question for you| Outdated?
Dennis, We are active participants in the process. We are also making an offer to someone with an extensive background in developing data warehouses, which will help me to sleep much more comfortably at night :) Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Rachel - Glad Inmon's book is working for you. I have only read (or more correctly attempted to read) his articles, which can be found at http://www.datawarehousing.com/, or at least they previously were available. - Just be aware that when you switch from reading Inmon or one of his followers to Kimball or one of his followers, that the meaning of some terms change. - The oldest Kimball articles at http://www.intelligententerprise.com/ports/search_webhouse.shtml are the best to start with because they describe the fundamentals of data warehouse design. - I still think the email list is one of the best resources. For help with list commands, send a message to mailto:[EMAIL PROTECTED] with the word help in the body of the message. (I'm listing these for the benefit of others on this list) Not to discourage you, but companies often take the approach of yours, and hire consultants to build the site. They tend to go into a corner and develop it and then unveil it when they are finished, collect their check and leave. If you ask questions, it is easy for them to blow past you because they are the experts. So from that standpoint, don't panic, just go along for the ride and what you can learn. But it is good to read up on warehousing so you can ask intelligent questions and don't sound like a dinosaur by asking questions like whaddya mean it isn't normalized?. In DW, the real participants are the ones that interview the potential users and try to locate data the users will find useful. The DBA tends to be the one that gets ordered to load 100-gig of data every night. DW work is like a lot of other DBA work, but quite different in some respects. At least with the email list, if something sounds odd, you can ask some real people for some input. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 23, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Outdated? Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in
RE: Data Warehouse experts, a simple question for you|
Rachel, This was just received from the SearchDatabase email and I thought it might be of interest to you. . TODAY'S BI STRATEGY: Placement of the data warehouse (Part 2) By William McKnight, SearchCRM Expert Another question I received [last week at the Data Warehousing Institute World Conference] had to do with placement of the data warehouse and the potential myriad of other databases (staging, data marts, ODS, etc.) in the data warehouse architecture. The recommended approach by the questioner's management was to place them all on the same DBMS instance -- the same instance that the main operational source system was on... Read the rest of this strategy at: http://www.searchCRM.com/tip/1,289483,sid11_gci825543,00.html Read the first part of this strategy at: http://searchcrm.techtarget.com/tip/1,289483,sid11_gci824982,00.html?FromTaxonomy=/pr/288366 Ron ROR mª¿ªm [EMAIL PROTECTED] 05/23/02 01:43PM Dennis, We are active participants in the process. We are also making an offer to someone with an extensive background in developing data warehouses, which will help me to sleep much more comfortably at night :) Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you|
ron, Even without reading the rest of the article, my first instinct is to scream NOO and, after reading the article, it appears the author agrees with me. I have a sane boss. an intelligent boss. He is management, not damagement he has the same concerns about what the end user wants and what the consultants say they/we can accomplish in the time we have. Rachel --- Ron Rogers [EMAIL PROTECTED] wrote: Rachel, This was just received from the SearchDatabase email and I thought it might be of interest to you. . TODAY'S BI STRATEGY: Placement of the data warehouse (Part 2) By William McKnight, SearchCRM Expert Another question I received [last week at the Data Warehousing Institute World Conference] had to do with placement of the data warehouse and the potential myriad of other databases (staging, data marts, ODS, etc.) in the data warehouse architecture. The recommended approach by the questioner's management was to place them all on the same DBMS instance -- the same instance that the main operational source system was on... Read the rest of this strategy at: http://www.searchCRM.com/tip/1,289483,sid11_gci825543,00.html Read the first part of this strategy at: http://searchcrm.techtarget.com/tip/1,289483,sid11_gci824982,00.html?FromTaxonomy=/pr/288366 Ron ROR mª¿ªm [EMAIL PROTECTED] 05/23/02 01:43PM Dennis, We are active participants in the process. We are also making an offer to someone with an extensive background in developing data warehouses, which will help me to sleep much more comfortably at night :) Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you| Outdated?
Dennis Williams wrote: Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. No, it's not just you. I can't read him either. It's like taking a walk through a briar patch without a machete. Check Amazon, a lot of people feel the same way. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you|
Rachel, Having the same backup problems as talked about in the article, I can agree with the views and opinions of the author. The second part of the article dealt with the placement of the data and type of operation on the data in the same instance. I have mixed emotions about that idea. With the proper horse power and memory and the published features of 9i, why can't the two co-exist happily on the same instance? The 9i features allow for multi database block size and auto tune is provided that should handle the data-mart and OLTP processes quite well. Partitioning is tunable by combining it with the LMT, and you can set the size parameters in LMT to make optimal use of the disks. The updating of the data from the current process to the datamart would be fast because the data resides on the same server and the backup procedure would automatically provide the archive data in 2 places, the archivelogs and the original source table. After backup of the warehoused data you could systematically delete the partition and create new ones for the new data. On the other side of the coin, if the server dies nothing at all works. At what price does the cost of the needed horse power and disks out weigh the possible advantages of one instance? The author talked about mirrored drives and splitting the mirrors to perform backups. I would rather use hot backups but I do not know the volume of data activity he was talking about. I do not think it was the datamart data he was talking about. That would be a large amount of data activity to not use hot backups. Could the archivelogs be that large if you use hot backups compared to the archivelogs generated during normal processing and split mirrors? Just a few thoughts. Good luck with your project, Ron ROR mª¿ªm [EMAIL PROTECTED] 05/23/02 03:40PM ron, Even without reading the rest of the article, my first instinct is to scream NOO and, after reading the article, it appears the author agrees with me. I have a sane boss. an intelligent boss. He is management, not damagement he has the same concerns about what the end user wants and what the consultants say they/we can accomplish in the time we have. Rachel --- Ron Rogers [EMAIL PROTECTED] wrote: Rachel, This was just received from the SearchDatabase email and I thought it might be of interest to you. . TODAY'S BI STRATEGY: Placement of the data warehouse (Part 2) By William McKnight, SearchCRM Expert Another question I received [last week at the Data Warehousing Institute World Conference] had to do with placement of the data warehouse and the potential myriad of other databases (staging, data marts, ODS, etc.) in the data warehouse architecture. The recommended approach by the questioner's management was to place them all on the same DBMS instance -- the same instance that the main operational source system was on... Read the rest of this strategy at: http://www.searchCRM.com/tip/1,289483,sid11_gci825543,00.html Read the first part of this strategy at: http://searchcrm.techtarget.com/tip/1,289483,sid11_gci824982,00.html?FromTaxonomy=/pr/288366 Ron ROR mª¿ªm [EMAIL PROTECTED] 05/23/02 01:43PM Dennis, We are active participants in the process. We are also making an offer to someone with an extensive background in developing data warehouses, which will help me to sleep much more comfortably at night :) Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
RE: Data Warehouse experts, a simple question for you| Outdated?
Jared - Hmmm. . . if Rachel finds him very readable, does that mean: a) she will shortly explain Inmon to the rest of us dumb DBAs. b) she will become incomprehensible to the rest of us. Sorry Rachel, couldn't resist. Actually, I am hoping for option A. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 23, 2002 3:03 PM To: Multiple recipients of list ORACLE-L Outdated? Dennis Williams wrote: Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. No, it's not just you. I can't read him either. It's like taking a walk through a briar patch without a machete. Check Amazon, a lot of people feel the same way. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you| Outdated?
I have NOT read his articles. Nor have I gotten all THAT far into the book however, the prep work I did before starting his book (reading the Oracle docs, reading some Kimball articles, searching the web) may be the reason I find him readable. Of course, it could just be that I am smarter than all of you. :) NOT!!! --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Jared - Hmmm. . . if Rachel finds him very readable, does that mean: a) she will shortly explain Inmon to the rest of us dumb DBAs. b) she will become incomprehensible to the rest of us. Sorry Rachel, couldn't resist. Actually, I am hoping for option A. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 23, 2002 3:03 PM To: Multiple recipients of list ORACLE-L Outdated? Dennis Williams wrote: Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. No, it's not just you. I can't read him either. It's like taking a walk through a briar patch without a machete. Check Amazon, a lot of people feel the same way. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you| Outdated?
And that means we can all now ask Rachel our Datawarehousing questions and not RTFM :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23-05-2002 11:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in front of management such that nobody knew what anybody was talking about. - And the DBAs said that creating a data warehouse or data mart was not nearly as hard as figuring out what to call it. The moral of the story is to figure out what you need to do and be aware that different authors use the same terms for different purposes and coin their own terms. Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Outdated? Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated
RE: Data Warehouse experts, a simple question for you| Outdated?
you can ask... and if you actually TRUST the answers I give, well, you are insane --- [EMAIL PROTECTED] wrote: And that means we can all now ask Rachel our Datawarehousing questions and not RTFM :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23-05-2002 11:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in front of management such that nobody knew what anybody was talking about. - And the DBAs said that creating a data warehouse or data mart was not nearly as hard as figuring out what to call it. The moral of the story is to figure out what you need to do and be aware that different authors use the same terms for different purposes and coin their own terms. Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L
RE: Data Warehouse experts, a simple question for you| Outdated?
can't resist asking ... since *this* answer advises us not to trust your answers, aren't you in fact saying that we should not trust this answer, which of course means that your answers *are* in fact trustworthy? The everything I say is a lie scenario that Kirk used in that one Star Trek episode to confuse the robot until it blew up? (might be time to put away the tequilla now and go to bed, Jack) ;) /jack --- Rachel Carmichael [EMAIL PROTECTED] wrote: you can ask... and if you actually TRUST the answers I give, well, you are insane --- [EMAIL PROTECTED] wrote: And that means we can all now ask Rachel our Datawarehousing questions and not RTFM :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23-05-2002 11:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in front of management such that nobody knew what anybody was talking about
RE: Data Warehouse experts, a simple question for you| Outdated?
Any comments on the book 'Oracle 8i Data Warehousing' by Michael Corey, Michael Abbey, Ian Abramson and Ben Taub (Oracle Press) ? Thanks and Regards Madhu From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Data Warehouse experts, a simple question for you| Outdated? Date: Thu, 23 May 2002 07:33:26 -0800 Rachel - Glad Inmon's book is working for you. I have only read (or more correctly attempted to read) his articles, which can be found at http://www.datawarehousing.com/, or at least they previously were available. - Just be aware that when you switch from reading Inmon or one of his followers to Kimball or one of his followers, that the meaning of some terms change. - The oldest Kimball articles at http://www.intelligententerprise.com/ports/search_webhouse.shtml are the best to start with because they describe the fundamentals of data warehouse design. - I still think the email list is one of the best resources. For help with list commands, send a message to mailto:[EMAIL PROTECTED] with the word help in the body of the message. (I'm listing these for the benefit of others on this list) Not to discourage you, but companies often take the approach of yours, and hire consultants to build the site. They tend to go into a corner and develop it and then unveil it when they are finished, collect their check and leave. If you ask questions, it is easy for them to blow past you because they are the experts. So from that standpoint, don't panic, just go along for the ride and what you can learn. But it is good to read up on warehousing so you can ask intelligent questions and don't sound like a dinosaur by asking questions like whaddya mean it isn't normalized?. In DW, the real participants are the ones that interview the potential users and try to locate data the users will find useful. The DBA tends to be the one that gets ordered to load 100-gig of data every night. DW work is like a lot of other DBA work, but quite different in some respects. At least with the email list, if something sounds odd, you can ask some real people for some input. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhusudhanan Sampath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you
Has anyone got that jokey review of a new wonder storage/retrieval format .book ? Simon Fox Room 308, CRH 0161 601 8723 -Original Message- Sent: 22 May 2002 03:58 To: Multiple recipients of list ORACLE-L Mladen, That IS what I do with the documentation CD. But Jack and I were talking about REAL books here, you know, those things that are made of paper, have printing on the pages, words, diagrams all that sort of stuff Rachel --- Gogala, Mladen [EMAIL PROTECTED] wrote: No, no, no and no! You are supposed to eat your documentation CD, preferably with fajitas or spaghetti and lots of Tabasco sauce. There are some versions of habanera sauce which can prepare your mouth to such extent that it becomes impossible to tell oracle documentation CD and a chicken wing apart. Make sure that you have few gallons of water at hand, though. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Data Warehouse experts, a simple question for you gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you
Try running: select 'IT DOES' from dual where 2 = '02'; I guess that SQLPlus is doing an implicit data conversion. Paula_Stankus @doh.state.flTo: Multiple recipients of list ORACLE-L .us [EMAIL PROTECTED] Sent by: rootcc: Subject: RE: Data Warehouse experts, a simple question for you 05/21/2002 08:28 PM Please respond to ORACLE-L Okay you guys are silly. I have probably a stupid basic question to ask. How important is it to store data (let's say state codes, county codes with leading zeroes as character versus numeric). What is the standard out there? Does '02' mean the same thing as 2 for state code if you are consistent throughout your warehouse or do we need to consider other datasets out there that might be linked maybe sometime in the future? Can I leave it as is numeric and create materialized views with it padded or should I bite the bullet and reload into char/varchar2 datatypes? -Original Message- Sent: Tuesday, May 21, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Yeah, that's a common misconception. You actually have to prop the book on your forehead since English flows to the left and downwards. I have heard that Chinese flows from right to left and upwards or something though - you might consider taking it up as a new language if you are set on the underpillow method of knowledge transfer. /jack --- Rachel Carmichael [EMAIL PROTECTED] wrote: gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) --- Jack Silvey [EMAIL PROTECTED] wrote: I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2
RE: Data Warehouse experts, a simple question for you| Outdated?
Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated. There is so much good information in that book though, that it's still worth its weight in gold. You won't find too many publications for $60 that will take you step by step through building an entire data warehouse, including the infrastructure. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? I am new to his books, three chapters in. The first release of the Data Warehouse Toolkit defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized structure which stores information from various sources. We build data marts with structures optimized for querying; e.g., star schemas, from the warehouse. Kimball writes of the warehouse itself being based on a star schema. The term data warehouse has not been immutable over the years. It was probably defined exactly as he has done when the book was first written. Do his new books redefine data warehouse? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:16 PM To: Multiple recipients of list ORACLE-L I second Jared's opinion. Ralph's books are clear and easy to read. This is the fundamentals of data warehousing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
Re: Data Warehouse experts, a simple question for you
If you take of the where clause, you get the same result. I don't think this answers the question. SQLWKS select 'IT DOES' from dual 2 3 'ITDOES --- IT DOES 1 row selected. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 10:38 AM Try running: select 'IT DOES' from dual where 2 = '02'; I guess that SQLPlus is doing an implicit data conversion. Paula_Stankus @doh.state.flTo: Multiple recipients of list ORACLE-L .us [EMAIL PROTECTED] Sent by: rootcc: Subject: RE: Data Warehouse experts, a simple question for you 05/21/2002 08:28 PM Please respond to ORACLE-L Okay you guys are silly. I have probably a stupid basic question to ask. How important is it to store data (let's say state codes, county codes with leading zeroes as character versus numeric). What is the standard out there? Does '02' mean the same thing as 2 for state code if you are consistent throughout your warehouse or do we need to consider other datasets out there that might be linked maybe sometime in the future? Can I leave it as is numeric and create materialized views with it padded or should I bite the bullet and reload into char/varchar2 datatypes? -Original Message- Sent: Tuesday, May 21, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Yeah, that's a common misconception. You actually have to prop the book on your forehead since English flows to the left and downwards. I have heard that Chinese flows from right to left and upwards or something though - you might consider taking it up as a new language if you are set on the underpillow method of knowledge transfer. /jack --- Rachel Carmichael [EMAIL PROTECTED] wrote: gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) --- Jack Silvey [EMAIL PROTECTED] wrote: I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child
RE: Data Warehouse experts, a simple question for you| Outdated?
And politics. --- [EMAIL PROTECTED] wrote: Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated. There is so much good information in that book though, that it's still worth its weight in gold. You won't find too many publications for $60 that will take you step by step through building an entire data warehouse, including the infrastructure. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? I am new to his books, three chapters in. The first release of the Data Warehouse Toolkit defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized structure which stores information from various sources. We build data marts with structures optimized for querying; e.g., star schemas, from the warehouse. Kimball writes of the warehouse itself being based on a star schema. The term data warehouse has not been immutable over the years. It was probably defined exactly as he has done when the book was first written. Do his new books redefine data warehouse? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:16 PM To: Multiple recipients of list ORACLE-L I second Jared's opinion. Ralph's books are clear and easy to read. This is the fundamentals of data warehousing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- === message truncated === __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
Re: Data Warehouse experts, a simple question for you
your fields should be consistent across tables, otherwise, you risk losing the ability for your queries to use an index if necessary. If state code is char in one and num in the other, consider conversion on one of them, otherwise, oracle may do an implicit conversion on one of them during your queries. For instance, if you write a query that says SELECT * FROM tab_a, tab_b where tab_a.state_code = tab_b.state_code; and these columns are two different datatypes, Oracle will actually run code similiar to the following: SELECT * FROM tab_a, tab_b where to_num(tab_a.state_code) = tab_b.state_code; and the use of this function in the where clause will disable the availability of an index on that column. The reason is that the index will be in characters and the value you are seeking will be a number. You can use function based indexes to work around, but probably just better to store it the same in the first place. hth, /jack Paula_Stankus @doh.state.flTo: Multiple recipients of list ORACLE-L .us [EMAIL PROTECTED] Sent by: rootcc: Subject: RE: Data Warehouse experts, a simple question for you 05/21/2002 08:28 PM Please respond to ORACLE-L Okay you guys are silly. I have probably a stupid basic question to ask. How important is it to store data (let's say state codes, county codes with leading zeroes as character versus numeric). What is the standard out there? Does '02' mean the same thing as 2 for state code if you are consistent throughout your warehouse or do we need to consider other datasets out there that might be linked maybe sometime in the future? Can I leave it as is numeric and create materialized views with it padded or should I bite the bullet and reload into char/varchar2 datatypes? __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you
If the data does not contain characters, AND NEVER WILL, it should be stored as a number. This prevents alphabetic O's from being stored with the data. If you really have to prefix the numbers with zeroes then do it on output. If the field itself is character and left padded with zeroes then you are going to see a lot of queries along the lines of where padded_field like '%significant_portion_of _number%' this won't use and index even though it might identify a unique record. A function-based index will not help here. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 1:46 PM To: Multiple recipients of list ORACLE-L your fields should be consistent across tables, otherwise, you risk losing the ability for your queries to use an index if necessary. If state code is char in one and num in the other, consider conversion on one of them, otherwise, oracle may do an implicit conversion on one of them during your queries. For instance, if you write a query that says SELECT * FROM tab_a, tab_b where tab_a.state_code = tab_b.state_code; and these columns are two different datatypes, Oracle will actually run code similiar to the following: SELECT * FROM tab_a, tab_b where to_num(tab_a.state_code) = tab_b.state_code; and the use of this function in the where clause will disable the availability of an index on that column. The reason is that the index will be in characters and the value you are seeking will be a number. You can use function based indexes to work around, but probably just better to store it the same in the first place. hth, /jack Paula_Stankus @doh.state.flTo: Multiple recipients of list ORACLE-L .us [EMAIL PROTECTED] Sent by: rootcc: Subject: RE: Data Warehouse experts, a simple question for you 05/21/2002 08:28 PM Please respond to ORACLE-L Okay you guys are silly. I have probably a stupid basic question to ask. How important is it to store data (let's say state codes, county codes with leading zeroes as character versus numeric). What is the standard out there? Does '02' mean the same thing as 2 for state code if you are consistent throughout your warehouse or do we need to consider other datasets out there that might be linked maybe sometime in the future? Can I leave it as is numeric and create materialized views with it padded or should I bite the bullet and reload into char/varchar2 datatypes? __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Warehouse experts, a simple question for you
Try select 'IT DOES' from dual where 0=1; It doesn't. Ruth GramoliniTo: Multiple recipients of list ORACLE-L rgramolini [EMAIL PROTECTED] @tax.state.vtcc: .us Subject: Re: Data Warehouse experts, a simple Sent by: rootquestion for you 05/22/2002 04:03 PM Please respond to ORACLE-L If you take of the where clause, you get the same result. I don't think this answers the question. SQLWKS select 'IT DOES' from dual 2 3 'ITDOES --- IT DOES 1 row selected. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 10:38 AM Try running: select 'IT DOES' from dual where 2 = '02'; I guess that SQLPlus is doing an implicit data conversion. Paula_Stankus @doh.state.flTo: Multiple recipients of list ORACLE-L .us [EMAIL PROTECTED] Sent by: rootcc: Subject: RE: Data Warehouse experts, a simple question for you 05/21/2002 08:28 PM Please respond to ORACLE-L Okay you guys are silly. I have probably a stupid basic question to ask. How important is it to store data (let's say state codes, county codes with leading zeroes as character versus numeric). What is the standard out there? Does '02' mean the same thing as 2 for state code if you are consistent throughout your warehouse or do we need to consider other datasets out there that might be linked maybe sometime in the future? Can I leave it as is numeric and create materialized views with it padded or should I bite the bullet and reload into char/varchar2 datatypes? -Original Message- Sent: Tuesday, May 21, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Yeah, that's a common misconception. You actually have to prop the book on your forehead since English flows to the left and downwards. I have heard that Chinese flows from right to left and upwards or something though - you might consider taking it up as a new language if you are set on the underpillow method of knowledge transfer. /jack --- Rachel Carmichael [EMAIL PROTECTED] wrote: gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) --- Jack Silvey [EMAIL PROTECTED] wrote: I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL
RE: Data Warehouse experts, a simple question for you| Outdated?
Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in front of management such that nobody knew what anybody was talking about. - And the DBAs said that creating a data warehouse or data mart was not nearly as hard as figuring out what to call it. The moral of the story is to figure out what you need to do and be aware that different authors use the same terms for different purposes and coin their own terms. Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Outdated? Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated. There is so much good information in that book though, that it's still worth its weight in gold. You won't find too many publications for $60 that will take you step by step through building an entire data warehouse, including the infrastructure. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? I am new to his books, three chapters in. The first release of the Data Warehouse Toolkit defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized structure which stores information from various sources. We build data marts with structures optimized for querying; e.g., star schemas, from the warehouse. Kimball writes of the warehouse itself being based on a star schema. The term data warehouse has not been immutable over the years. It was probably defined exactly as he has done when the book was first written. Do his new books redefine data warehouse? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:16 PM To: Multiple recipients of list ORACLE-L I second Jared's opinion. Ralph's books are clear and easy to read. This is the fundamentals of data warehousing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK
Re: Data Warehouse experts, a simple question for you
Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Warehouse experts, a simple question for you
it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Warehouse experts, a simple question for you
I second that emotion. the guy that wrote it is a PhD and owns Red Brick or something. totally knows what he is talking about. One of my top five books, best warehousing book by far I have ever read. /jack silvey --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Warehouse experts, a simple question for you
I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) === message truncated === __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
Re: Data Warehouse experts, a simple question for you
gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) --- Jack Silvey [EMAIL PROTECTED] wrote: I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be === message truncated === __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Data Warehouse experts, a simple question for you
No, no, no and no! You are supposed to eat your documentation CD, preferably with fajitas or spaghetti and lots of Tabasco sauce. There are some versions of habanera sauce which can prepare your mouth to such extent that it becomes impossible to tell oracle documentation CD and a chicken wing apart. Make sure that you have few gallons of water at hand, though. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Data Warehouse experts, a simple question for you gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you
I second Jared's opinion. Ralph's books are clear and easy to read. This is the fundamentals of data warehousing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Warehouse experts, a simple question for you
Yeah, that's a common misconception. You actually have to prop the book on your forehead since English flows to the left and downwards. I have heard that Chinese flows from right to left and upwards or something though - you might consider taking it up as a new language if you are set on the underpillow method of knowledge transfer. /jack --- Rachel Carmichael [EMAIL PROTECTED] wrote: gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) --- Jack Silvey [EMAIL PROTECTED] wrote: I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may === message truncated === __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail
RE: Data Warehouse experts, a simple question for you
And these CD's.are you supposed to eat them one byte at a time? insert rimshot here Thank you, thank you, tip your waiters and waitresses, I will be here all week! /jack --- Gogala, Mladen [EMAIL PROTECTED] wrote: No, no, no and no! You are supposed to eat your documentation CD, preferably with fajitas or spaghetti and lots of Tabasco sauce. There are some versions of habanera sauce which can prepare your mouth to such extent that it becomes impossible to tell oracle documentation CD and a chicken wing apart. Make sure that you have few gallons of water at hand, though. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Data Warehouse experts, a simple question for you gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Warehouse experts, a simple question for you
Title: RE: Data Warehouse experts, a simple question for you Okay you guys are silly. I have probably a stupid basic question to ask. How important is it to store data (let's say state codes, county codes with leading zeroes as character versus numeric). What is the standard out there? Does '02' mean the same thing as 2 for state code if you are consistent throughout your warehouse or do we need to consider other datasets out there that might be linked maybe sometime in the future? Can I leave it as is numeric and create materialized views with it padded or should I bite the bullet and reload into char/varchar2 datatypes? -Original Message- From: Jack Silvey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Data Warehouse experts, a simple question for you Yeah, that's a common misconception. You actually have to prop the book on your forehead since English flows to the left and downwards. I have heard that Chinese flows from right to left and upwards or something though - you might consider taking it up as a new language if you are set on the underpillow method of knowledge transfer. /jack --- Rachel Carmichael [EMAIL PROTECTED] wrote: gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) --- Jack Silvey [EMAIL PROTECTED] wrote: I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail
RE: Data Warehouse experts, a simple question for you| Outdated?
I am new to his books, three chapters in. The first release of the Data Warehouse Toolkit defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized structure which stores information from various sources. We build data marts with structures optimized for querying; e.g., star schemas, from the warehouse. Kimball writes of the warehouse itself being based on a star schema. The term data warehouse has not been immutable over the years. It was probably defined exactly as he has done when the book was first written. Do his new books redefine data warehouse? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:16 PM To: Multiple recipients of list ORACLE-L I second Jared's opinion. Ralph's books are clear and easy to read. This is the fundamentals of data warehousing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send
RE: Data Warehouse experts, a simple question for you
Mladen, That IS what I do with the documentation CD. But Jack and I were talking about REAL books here, you know, those things that are made of paper, have printing on the pages, words, diagrams all that sort of stuff Rachel --- Gogala, Mladen [EMAIL PROTECTED] wrote: No, no, no and no! You are supposed to eat your documentation CD, preferably with fajitas or spaghetti and lots of Tabasco sauce. There are some versions of habanera sauce which can prepare your mouth to such extent that it becomes impossible to tell oracle documentation CD and a chicken wing apart. Make sure that you have few gallons of water at hand, though. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Data Warehouse experts, a simple question for you gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Warehouse experts, a simple question for you
HEBREW flows right to left dear --- Jack Silvey [EMAIL PROTECTED] wrote: Yeah, that's a common misconception. You actually have to prop the book on your forehead since English flows to the left and downwards. I have heard that Chinese flows from right to left and upwards or something though - you might consider taking it up as a new language if you are set on the underpillow method of knowledge transfer. /jack --- Rachel Carmichael [EMAIL PROTECTED] wrote: gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) --- Jack Silvey [EMAIL PROTECTED] wrote: I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel --- [EMAIL PROTECTED] wrote: Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Data Warehouse experts, a simple question for you looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists === message truncated === __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: Data Warehouse experts, a simple question for you
calendar_date calendar_month calendar_qtrcalendar_year 200201011 1 2002 200301011 1 2003 Mh... The calendar_date(or changed to calendar_day) should be just the day of the month since you already have calendar_year. It seems that you are storing everyday's day. Or get rid of calendar_year and calendar_month since calendar_date contains month, and year? -Original Message- Sent: Monday, May 20, 2002 4:08 PM To: Multiple recipients of list ORACLE-L Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Warehouse experts, a simple question for you
Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Warehouse experts, a simple question for you
looks like published aug of 98 for that book?, like $60? joe [EMAIL PROTECTED] wrote: Joe, Add a generated PK to the time dimension. The PK is stored as an FK in the fact table. That way you can select from the time dimension by year, day, qtr, whatever, and easily pick out the correct fact table rows. The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns. Very good book, can't recommend it enough. Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 04:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse experts, a simple question for you Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null); insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003); 2 rows nice and simple trying to validate the dimension comes up with an error, my guess is because of the design of the table where basically calendar_date is child of calendar_month is child of calendar_qtr is child of calendar_year, wont validate. - the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok. Was the design of dm_time just dont wrong or am i missing something here. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).