You are here: silicon.com > Resources > White Papers > Software and Web Development > Software Development Tools > Programming Languages

Programming Languages White Papers

Building a Hybrid Data Warehouse Model

Tags:
programming languages

Overview 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.

Further White Paper Details
Publisher	Oracle	File Format	HTML
Date Published	April 2007	Downloads	270
Format	White Papers
Topics	Programming Languages, Database Management, Business Intelligence - Data Warehousing

Did you find this white paper useful? 29 out of 50 users found this white paper useful

Dell to ditch the floppy disk

It's smaller and lighter than a floppy drive, yet it has the ability to store more data than 10 or more standard 3.5-inch floppy disks, Dell representatives said. Computer giant Dell is to offer a storage alternative to the floppy disk in the form...

Channel:
Storage

Brunel University’s Business Class: Understanding your business

The power of the content, performance and knowledge model is that the performance and knowledge models feed into the business content, providing a context to give it meaning. Understanding these model-driven views should help organisations build...

Channel:
IT Director

Quocirca’s Straight Talking: What Europe’s CIOs really think of Linux

The main objective was to form a view of how the IT market is going to shape up generally during 2004 but a number of questions were included at the end of each interview to explore Linux related views and plans.

Channel:
Operating Systems

Leader: Is Tesco off its trolley to compete with iTunes?

So far Apple's strength is in the superior form factor of its iPod players and their easy integration with the iTunes store. Today Tesco announced plans to launch an online music store - and, like so many new entrants to the sector, is hoping it...

Channel:
WebWatch

Oracle eyes up apps providers

We'd love to get to a mode where we're looking at the number of employees served, the number of checks processed - you name it, some business metric - and take it out of the technology realm and tie our success to their success in terms of...

Channel:
Applications
Tags:
oracle

Peter Cochrane's Blog: The last CD

Secondly, a key element in their demise will be the deployment of real broadband at speeds greater than 100Mbps, which will see a hybrid world of thick and thin clients operating in fixed and mobile modes.

Live Webcast: Telecoms 2.0 - Where is telecoms heading?

In this webcast, our panel of experts will review where we are with next generation telecoms in the UK, working through the concept of 'Telecoms 2.0': - Realising the potential of Next Generation Networks - why it isn't just about the technology? - What attributes should firms be looking for in their telco partner? - Is the relationship between telco provider and customer changing? - What things need to happen to make next generation services a reality? - You say you want the supplier to change. Do you want to change too? - What is Telecoms 2.0?

Publisher:
ZDNet UK

Telecom 2.0: Mind over matter

ntl:Telewest Business believes that the role of the telco is evolving. Gone are the days when it was enough to simply focus on circuits and minutes, customers now need a far higher degree of interaction and look for suppliers who will talk business solutions with them.

Publisher:
ntl:Telewest Business

IBM Information Server Change Data Capture

In today's fast-paced world, access to real-time data has never been more important. To be successful, organizations need to be able to report and analyze corporate data quickly and easily, regardless of what applications created the data, what platform they're running on, or what database they're stored in.

Publisher:
IBM

An examination of server consolidation: the trends that can drive efficiencies and help businesses gain a competitive edge

This white paper provides a starting point for organizations contemplating server consolidation. It includes an overview of server consolidation concepts and techniques and provides guidance on methodologies. It also looks at the potential cost savings associated with server consolidation and offers information on how organizations can sustain the advantage they have gained by consolidating their servers.

Publisher:
IBM

Also on silicon.com

Site Navigation:

Programming Languages White Papers

Building a Hybrid Data Warehouse Model

Quick Sitemap Links:

About Us

Search

Blogs

Verticals

Advertising Features

CNET Networks in Europe

CNET Networks in the United States

CNET Networks in Asia Pacific