| Publisher | Oracle | ||
|---|---|---|---|
| Format | HTML | Date added | 01 Apr 2007 |
| Topics | Programming Languages, Database Management, Business Intelligence - Data Warehousing | ||
| Downloads | 91 | ||
This paper discusses the hybrid design and provides a fully functional reference implementation. The system runs on Oracle Database 10g. It contains all code needed to build the database schemas, generate sample data, load it into the schemas, build the indexes and materialized views, run the sample queries, capture the runtimes, and provide statistics on the runtimes. The hybrid model is not a one-size-fits-all solution. Many projects are best served by either using only one of the traditional models or using both models separately with a feed between them. But if the objective is to create a single database that can both store data in its properly normalized form and run aggregation queries with good performance, the hybrid model is a design pattern to consider.
Did you find this white paper useful?
5 out of 10 users found this white paper useful
Related white papers
PSD-to-HTML Conversion Services: How to Get the Most Out of Them?
In web development projects when it comes to turn .psd, .ai, etc designs into xHTML/CSS code, a common option will be to use PSD-to-HTML slicing services. And a natural question...
Managing risk through financial processes: Embedding governance, risk and compliance
Managing risk through ?nancial processes is an Economist Intelligence Unit report sponsored by SAP. The Economist Intelligence Unit bears sole responsibility for this report. The Economist Intelligence Unit's editorial team conducted...
MSDN Webcast: RESTful Services With WCF 3.5 SP1 (Part 1 of 2): Concepts and Introduction (Level 200)
This webcast is for one who has been looking for an overview of REpresentational State Transfer (REST) and gaining an understanding about the REST support of Windows Communication Foundation (WCF)...
Do More with Less: Merging Enterprise Applications with Desktop Tools
Find out what Aberdeen Group has to say about tools for business users. This report examines key trends for enterprises seeking to improve end user productivity, including the integration of...
MSDN Webcast: geekSpeak: Accessibility and WPF With Robert Altland (Level 200)
The presenter of this webcast explores how to write accessible applications using Microsoft Windows Presentation Foundation (WPF) and Microsoft Silverlight. The presenter provides a quick review of UI automation, the...
A Better Alternative: An Improved Approach to Facilities Management
Real estate is typically the second largest corporate expense after personnel, so why do so many organizations remain unchanged in the way they manage their facilities? Shouldn't they, and you,...
Complex Bank Business Intelligence Solution Developed in Just Eight Months
National Savings Bank of Serbia (NSBS) was founded in early 2002 to serve the retail banking market and create a safe haven for 2.5 million customers of failed Serbian banks....
