data warehouse vs regular database??
Hi all, I have been working with Oracle 92. I have no experience with Oracle Warehouse. In my current company, I was told the database is a warehouse. I can connect to it using sql plus or pl/sql developer. The warehouse looks the same as the database I worked with before. How do I tell if a database is a warehouse or just a regular database. What's the big difference between the two? Could someone send me some link about data warehouse? Thank you! Janet __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 vs regular database??
prank If you enter the following query select 'Data Warehouse' from dual; and if the database responds with 'Data Warehouse', then your database is a DW database. /prank Data warehouses can be distinguished from their less noble cousins, the OLTP databases, by the way they're accessed and by their business purpose. If the purpose of the database is to support the ongoing business process and to record and support ongoing business transactions (includes a lot of inserts, updates and deletes which happen all the time) then you have an OLTP database. If the database is used for reporting and trend research purposes and the data is added once a month and never deleted, then you have a data warehouse database. If the database is refreshed at least once a month and re-created as a copy of an OLTP database, with bitmap indexes and material views added for reporting purposes you have something called operational data store, which is used for generating statements, printing checks, large data extractions and B2B communication (based on HIPAA, for instance). I have to advise reading of the Gospel By Jonathan for you too. Gospel by Jonathan is also known as Practical Oracle 8i: Building Efficient Databases and can be purchased from Barnes Noble, Border Books or Bookpool. On 01/07/2004 12:04:25 PM, Janet Linsy wrote: Hi all, I have been working with Oracle 92. I have no experience with Oracle Warehouse. In my current company, I was told the database is a warehouse. I can connect to it using sql plus or pl/sql developer. The warehouse looks the same as the database I worked with before. How do I tell if a database is a warehouse or just a regular database. What's the big difference between the two? Could someone send me some link about data warehouse? Thank you! Janet __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 vs regular database??
Janet, A data warehouse is a database. Now if the data warehouse has all of the data structures of the OLTP database and people are using those tables like one would expect, then your just using the same instance for both purposes, which is a recipe for disaster in my opinion. A data warehouse is characterized by several large (both in width and depth) tables with somewhat demoralized and static data and/or a number of star schemas that have very deep fact tables. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 12:04 PM To: Multiple recipients of list ORACLE-L Hi all, I have been working with Oracle 92. I have no experience with Oracle Warehouse. In my current company, I was told the database is a warehouse. I can connect to it using sql plus or pl/sql developer. The warehouse looks the same as the database I worked with before. How do I tell if a database is a warehouse or just a regular database. What's the big difference between the two? Could someone send me some link about data warehouse? Thank you! Janet __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 vs regular database??
The Ralph Kimball answer: A DW is a collection of data marts. A Data mart is typically a fact table surrounded by a collection of dimension tables. The Bill Inmon answer: A DW is a system designed to collect data from an enterprise for the purpose of creating data marts. It is not normally queried by end users, that is what the DM's are for. Regardless of which viewpoint you hold, both are characterized by data being time sensitive: facts are stored with date. Then again, there are databases that do not really resemble either of these, but are nonetheless used as a DW. Where does your database get its data from? If it comes from other databases and/or systems, then it is likely a DW. Google for data warehouse institute, Ralph Kimball and Bill Inmon, and you will find plenty of info. If you want to learn about DW, Kimball's The Data Warehouse Toolkit is a good place to start. HTH Jared On Wed, 2004-01-07 at 09:04, Janet Linsy wrote: Hi all, I have been working with Oracle 92. I have no experience with Oracle Warehouse. In my current company, I was told the database is a warehouse. I can connect to it using sql plus or pl/sql developer. The warehouse looks the same as the database I worked with before. How do I tell if a database is a warehouse or just a regular database. What's the big difference between the two? Could someone send me some link about data warehouse? Thank you! Janet __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 vs regular database??
otn.oracle.com read the oracle data warehouse guide. btw, its kind of ignorant to post the same question here that is on lazydba. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 12:04 PM Hi all, I have been working with Oracle 92. I have no experience with Oracle Warehouse. In my current company, I was told the database is a warehouse. I can connect to it using sql plus or pl/sql developer. The warehouse looks the same as the database I worked with before. How do I tell if a database is a warehouse or just a regular database. What's the big difference between the two? Could someone send me some link about data warehouse? Thank you! Janet __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).