SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Technology Stocks : Oracle Corporation (ORCL)
ORCL 191.97+6.6%Dec 19 9:30 AM EST
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: lml who wrote (6852)4/8/1998 7:25:00 PM
From: Brian Moore  Read Replies (3) of 19080
 
OK, here's a clear description of what a data warehouse is:

Most Oracle databases are used by "worker bees," who enter single pieces of information into the database. Example: Someone takes your reservation to stay at a hotel -- it goes into an Oracle database.

But what if a senior manager wants to see a one page summary of millions of pieces of information? Example: Which hotel had the greatest increase in sales last month?

Well, here's what happens.... The worker bee's Oracle database was made by programmers to be very efficient -- for the worker bees, who put in one record at a time. But the manager's report requires pulling together and summarizing millions of records. It might take hours to do this, and it will slow down the database for all the worker bees too.

The solution is to create a second Oracle database on a new computer. Every night data from the worker bee's database is poured in. Next morning the manager can run that report using this new database (called a Data Warehouse). It's fast because it is specifically programmed to sort through millions of records and produce a summary. And because it is on a separate computer it does not interfere with the work of the worker bees.

Data warehouses are great for Oracle. They get to sell another database to the company.

And Data Marts? That's the same idea as a data warehouse, except that instead of attempting to contain all information for the company like a Data Warehouse, a Data Mart is smaller, containing only the information of interest to one department.
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News