In little over a month I will be in Las Vegas speaking at Collaborate 10. There is a lot of BI / DW talks this year and for the first time with BIWA Training Days branding. Rittman Mead will be there at the conference giving talks on each of the conference days. If you are [...]
With over 3 million customers shopping in its supermarkets every day, Giant Eagle requires a data warehouse that can support millions of point-of-sale transactions on a daily basis. Steve Mitterder, Technical Services Database Manager from Giant Eagle, discusses how Oracle Exadata has enabled Giant Eagle to dramatically increase its query performance by 25 times.
Link [...]
LGR Telecommunications supplies custom telecom data warehouses to some of the largest telecommuncaitions companies in the world. To maintain its competitive edge, its data warehouses must be able to deliver extremely fast query response times for very large databases. Learn from Paul Hartley, General Manager, how LGR has been able to address this challenge with [...]
RL Polk is in the business of collecting and interpreting data for the automotive industry. Hear about their experience running Oracle Partitioning, Oracle Real Application Clusters, Oracle ASM, and thoughts on Oracle Exadata.
Link to the original site
Hopefully you’ve read the introduction, Part 1, and Part 2. Those posts detailed methods for building fault-tolerant ETL code, with a strong bias in favor of using Oracle Database features. Now I’ll drill into the backup and recovery aspect of data warehousing fault tolerance, and tackle the age-old question of whether to ARCHIVELOG or NOARCHIVELOG [...]
With so much of the blog devoted to OBIEE, OWB and Essbase lately, I felt like it was time to do a few database-related postings. In the past, when I’ve posted database content to the blog, I usually gravitate toward ETL-related features: those that waffle between database administration and ETL development. But this time I’m [...]
Oracle Warehouse Builder (OWB) Public Views is a relational public interface to OWB repository. It helps users to have a direct access to OWB metadata by using SQL. The Warehouse Builder provides a set of pre-built views for both the design and runtime environments. Compared to other OWB public access methods, such as Scripting Command [...]
Oracle Warehouse Builder (OWB) Public Views is a relational public interface to OWB repository. It helps users to have a direct access to OWB metadata by using SQL. The Warehouse Builder provides a set of pre-built views for both the design and runtime environments. Compared to other OWB public access methods, such as Scripting Command [...]
I had a wonderful discussion with Wouter van Aerle of Cap Gemini, about the need for information governance. He pointed out that this is taken care of very well, when it is about financial information, but often surprisingly poorly managed for non-financial information. This is concerning, because required external reporting increasingly consists of non-financial information.
Non-financial [...]
In the previous post, I mentioned how a reader reacted, asking some questions about the architectural consequences on not routing general ledger information to the data warehouse, but directly to the financial consolidation tool.
Freddy Holwerda comments that I didn’t address the full question. He writes:
In the readers reaction, the real problem seems to [...]