Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Checkout

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag Great Britain
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Singapore
Country selected
country flag Hungary
Country selected
country flag Ukraine
Country selected
country flag Luxembourg
Country selected
country flag Estonia
Country selected
country flag Lithuania
Country selected
country flag South Korea
Country selected
country flag Turkey
Country selected
country flag Switzerland
Country selected
country flag Colombia
Country selected
country flag Taiwan
Country selected
country flag Chile
Country selected
country flag Norway
Country selected
country flag Ecuador
Country selected
country flag Indonesia
Country selected
country flag New Zealand
Country selected
country flag Cyprus
Country selected
country flag Denmark
Country selected
country flag Finland
Country selected
country flag Poland
Country selected
country flag Malta
Country selected
country flag Czechia
Country selected
country flag Austria
Country selected
country flag Sweden
Country selected
country flag Italy
Country selected
country flag Egypt
Country selected
country flag Belgium
Country selected
country flag Portugal
Country selected
country flag Slovenia
Country selected
country flag Ireland
Country selected
country flag Romania
Country selected
country flag Greece
Country selected
country flag Argentina
Country selected
country flag Netherlands
Country selected
country flag Bulgaria
Country selected
country flag Latvia
Country selected
country flag South Africa
Country selected
country flag Malaysia
Country selected
country flag Japan
Country selected
country flag Slovakia
Country selected
country flag Philippines
Country selected
country flag Mexico
Country selected
country flag Thailand
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

You're reading from   Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology Take your data warehousing and business intelligence to the next level with this practical guide to Oracle Database 11g. Packed with illustrations, tips, and examples, it has over 80 advanced recipes to fine-tune your skills and knowledge.

Arrow left icon
Product type Paperback
Published in Jul 2012
Publisher Packt
ISBN-13 9781849685481
Length 368 pages
Edition 1st Edition
Tools
Concepts
Arrow right icon
Author (1):
Arrow left icon
John Heaton John Heaton
Author Profile Icon John Heaton
John Heaton
John Heaton graduated top of his class with a Diploma in Information Technology from Technikon Witwatersrand in South Africa (equivalent to Bachelors in computer science). He has 10+ years with Oracle Corporation, including as a Practice Manager. John has been co-managing the North Business Intelligence and Warehouse Consulting practice delivering business intelligence solutions to Fortune 500 clients. During this time he has steadily added business skills and business training to his technical background. This experience gives John a great background and insight into the requirements of differing businesses and how to design and develop technical solutions enabling clients to realize their requirements. John’s strengths include the ability to communicate the benefits of introducing a business intelligence solution into a client’s architecture. He has consistently become a trusted advisor to our clients. John’s philosophy is based on responsibility and mutual respect. He relies on the unique abilities of individuals to ensure success in different areas and strives to foster a team environment of creativity and achievement. Today, John specializes as a Solution Architect assisting customers in designing large complex data warehouses. Through his years John has worked in numerous industries with differing technologies. This broad experience base allows John to bring a unique perspective and understanding when designing and developing a data warehouse. The strong business background, coupled with technical expertise and his professional certification in Project Management makes John a valued asset to any project or organization. John frequently presents at Business Intelligence conferences on a variety of subjects.
Read more
See other products by John Heaton
Arrow right icon
View More author details
Toc

Table of Contents (21) Chapters Close

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
1. Preface
1. Defining a Program FREE CHAPTER 2. Establishing the Project 3. Controlling the Project 4. Wrapping Up the Project 5. The Blueprint 6. Analyzing the Requirements 7. Architecture and Design 8. Analyzing the Sources 9. Analyzing the Data 10. Constructing the Data Model 11. Defining the ETL/ELT 12. Enhancing the Data 13. Optimizing the Access 14. Security

Chapter 10. Constructing the Data Model

This chapter outlines how to construct the data model with Oracle SQL Data Modeler (a free standalone product or embedded within Oracle SQL Developer from Oracle) using a top-down and bottom-up approach. Oracle SQL Data Modeler will be used to build your database logical and physical models. This can be used by Oracle Warehouse Builder and Oracle Data Integrator. Oracle Business Intelligence Enterprise Edition (OBIEE) will be used to map the physical database model to the the presentation data model used for reporting. The following recipes focus on the database logical and physical data models:

  • Connecting Oracle SQL Data Modeler to Subversion

  • Importing data models into Subversion

  • Checkout data models from Subversion

  • Synchronizing data model changes with Subversion

  • How to import data models

  • How to reverse engineer your relational data model to a logical data model

  • Creating your domains

  • Creating your glossary

  • Adding standard columns to your data model

  • How to...

lock icon The rest of the chapter is locked
arrow left Previous Section
Section 1 of 13
Next Section arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at $19.99/month. Cancel anytime

Authors (1)

Profile icon John Heaton
John Heaton
John Heaton graduated top of his class with a Diploma in Information Technology from Technikon Witwatersrand in South Africa (equivalent to Bachelors in computer science). He has 10+ years with Oracle Corporation, including as a Practice Manager. John has been co-managing the North Business Intelligence and Warehouse Consulting practice delivering business intelligence solutions to Fortune 500 clients. During this time he has steadily added business skills and business training to his technical background. This experience gives John a great background and insight into the requirements of differing businesses and how to design and develop technical solutions enabling clients to realize their requirements. John's strengths include the ability to communicate the benefits of introducing a business intelligence solution into a client's architecture. He has consistently become a trusted advisor to our clients. John's philosophy is based on responsibility and mutual respect. He relies on the unique abilities of individuals to ensure success in different areas and strives to foster a team environment of creativity and achievement. Today, John specializes as a Solution Architect assisting customers in designing large complex data warehouses. Through his years John has worked in numerous industries with differing technologies. This broad experience base allows John to bring a unique perspective and understanding when designing and developing a data warehouse. The strong business background, coupled with technical expertise and his professional certification in Project Management makes John a valued asset to any project or organization. John frequently presents at Business Intelligence conferences on a variety of subjects.
Read more
See other products by John Heaton
Banner background image

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Right arrow icon