Oracle 10g Data Warehousing by Lilian Hobbs PhD, Susan Hillson MS in CIS Boston

By Lilian Hobbs PhD, Susan Hillson MS in CIS Boston University, Visit Amazon's Shilpa Lawande Page, search results, Learn about Author Central, Shilpa Lawande, , Pete Smith

Oracle 10g facts Warehousing is a advisor to utilizing the information Warehouse positive aspects within the most modern model of Oracle -Oracle Database 10g. Written by means of humans at the Oracle improvement workforce that designed and applied the code and via individuals with adventure enforcing warehouses utilizing Oracle expertise, this completely up to date and prolonged version presents an insider's view of the way the Oracle Database 10g software program is better used in your application.It presents an in depth examine the recent positive factors of Oracle Database 10g and different Oracle items and the way those are utilized in the knowledge warehouse. This publication will provide help to installation the Oracle database and properly use the recent Oracle Database 10g good points in your information warehouse. It comprises walkthroughs and examples on the way to use instruments reminiscent of Oracle Discoverer and stories to question the warehouse and generate stories that may be deployed over the net and achieve greater perception into your business.This how-to consultant offers step-by-step directions together with reveal captures to provide help to layout, construct and optimize functionality of the knowledge warehouse or facts mart. it's a 'must have' reference for database builders, directors and IT pros who are looking to get to paintings now with the entire most recent beneficial properties of Oracle Database 10g. It presents a close examine the hot gains of Oracle Database 10g and different Oracle items and the way those are utilized in the knowledge warehouse, including:* tips to use the precis administration good points, together with Materialized perspectives and question rewrite, to most sensible influence to greatly increase question functionality* tips to installation company intelligence to the net to meet modern altering and critical enterprise requisites* utilizing Oracle OLAP and knowledge Mining strategies* tips to comprehend the warehouse setting and the way it's utilized by new good points within the database together with tips on how to enforce a excessive availability warehouseenvironment* utilizing the new administration infrastructure in Oracle Database 10g and the way this lets you deal with your warehouse surroundings

Show description

Read or Download Oracle 10g Data Warehousing PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle varieties, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication allow real-time details entry and knowledge sharing throughout your allotted framework utilizing the professional details during this Oracle Press advisor. Oracle Streams 11g facts Replication explains the best way to organize and administer a unified company information sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program show four Recipes presents an example-based method of studying software exhibit - the ground-breaking, fast software improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply wishes an exceptional instance or to kick begin their considering and get pointed within the correct path.

Extra info for Oracle 10g Data Warehousing

Example text

Limit the scope, and plan for enhancements every three to six months. 4 Enterprise Data Warehouse with Dependent Data Marts Reporting, Query, and Analysis Tools Became Browser Based In 1995, Larry Ellison, the founder and CEO of Oracle, first introduced his vision of the network computer: a small, inexpensive device that makes it easy to run applications that access information via the Internet. Although the network computer never gained significant market share, the vision of internet-centric business computing accelerated the rapid price decline of PCs, meeting the demand for cheaper, simpler desktop computing.

75. Businesses are storing more and more data for longer periods of time. Data is stored multiple times for different purposes. Indexes and materialized views are created to improve query performance, but these access structures require additional storage space, further increasing the size of the database. Unstructured data can be integrated with traditional business intelligence applications. Storing multimedia data increases the database size. To store one hour of video requires about 1GB of storage.

Also, the dimension tables tend to contain more textual fields, which describe the dimension object, whereas fact tables tend to contain more numeric measures. , the time dimension could have as few as 52 rows if data was stored weekly for one year). Or a region dimension could contain only 15 rows, if the country had only 15 regions. Dimensions don’t have to be small in size, because you could sell 50,000 products or have a customer dimension with 5 million rows. All of these are examples of valid dimensions.

Download PDF sample

Rated 4.82 of 5 – based on 49 votes