Ask the Expert

Data warehousing resources

Can you recommend some good literature on data warehousing? I am a DBA and our organization is going to be looking into data warehousing in the next year for our historical financial/project data. I will be looking into Oracle training for data warehousing for the spring of 2005. I would like to start reading and getting some ideas on how to set up, administer and use reporting tools on a DW. Any info would be a great help.
There

    Requires Free Membership to View

are lots of great books and articles on data warehousing and Oracle Data Warehousing.

For a general data warehouse perspective, I would encourage you to read books by Ralph Kimball and Bill Inmon. They look at warehousing from a design perspective, which will form your foundation for success.

For Oracle information, there are a number of books from people like Gorman and Dodge. These books review how to get the most from Oracle in a data warehouse. I would also encourage you to use resources at the various user groups, like the IOUG, as well as Oracle itself. All of these resources will provide you with detailed technical information that will get you going as well as to help you improve your database over time.

Now business intelligence is a tougher nut to crack. There are not that many books on the subject, so you are limited there. You can also join user groups and other resources that allow you to share with other users.

Data warehousing and business intelligence is a very wide and deep topic. There are many resources and opinions out there. Read and learn as much as you can to find the solution that is right for you.

This was first published in October 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: