October 2005
Beginner to intermediate
576 pages
13h 35m
English
Content preview from Building the Data WarehouseBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 16. The Data Warehouse and the ODS
A data warehouse can never be accessed on a millisecond basis. Because of the nature of the data, the volume of the data, and the mixed workload that uses data from the data warehouse, the data warehouse is not geared to support OLTP types of processes. Guaranteed subsecond response for an access to the data warehouse is architecturally not a viable option.
But subsecond response time is, in fact, very valuable in many operations. Many businesses require very fast response time, and those businesses cannot have access to the data warehouse. When subsecond response time is required and integrated DSS data must be accessed, there is a structure known as an operational data store (ODS) that is the place to go to when high-performance processing must be done.
Unlike the data warehouse, the ODS is optional. Some organizations have an ODS and other organizations do not have an ODS. The need for an ODS depends entirely on the organization and the processing that is being done.
Complementary Structures
In many ways, the ODS and the data warehouse are complementary structures. Both reside outside of the operational environment. Both support DSS processing. Both use integrated data. For these reasons, the ODS and the data warehouse are often considered to be complementary. Data flows between the ODS and the data warehouse in a bidirectional manner. On some occasions, the ODS feeds the data warehouse. On other occasions, the data warehouse feeds the ODS. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.