Rittman Mead Blog - Oracle Database Technology

Tagged

Oracle Database

A collection of 141 posts

Oracle BI Suite EE

Real-time BI: EDW with a Real-time Component

I apologize for the long delay in getting this last portion of the Real-time discussion in place. Since I wrote the first two installments, we've had the BI Forum (US and UK versions), plus a flurry of activity around Rittman Mead in the US, followed up by KScope11.

Business Insights

Real-time BI: Federated OLTP/EDW Reporting

The typical approach in Federated OLTP/EDW reporting environments is to use a BI tool such as OBIEE to do horizontal federation. This means combining data from multiple sources at the same grain in a single logical table. One note of clarification: my use of the word "federated"

Oracle BI Suite EE

Real-time BI: An Introduction

Discussing real-time data warehousing is difficult because the meaning of real-time is dependent on context. A CIO of an organization that has weekly batch refresh processes might view an up-to-the-day dashboard as real-time, while another organization that already has daily refresh cycles might be looking for something closer to up-to-the-hour.

Oracle BI Suite EE

Oracle Data Warehouse Global Leaders Webcast

I'm honored to be delivering a webcast for the Oracle Data Warehouse Global Leaders Program on Tuesday, March 22 at Noon EST. This is an elite program for key global data warehousing customers and is managed by the Oracle data warehousing product management team. It also provides a

Transcend Part 2: Dimensions

In the last post [https://www.rittmanmead.com/blog/2010/12/01/transcend-part-1-mappings/], I described the concept of a "Mapping" entity in Transcend as a bundling of pre- and post-mapping processes that can be executed with a single call. The "Dimension" entity is very similar. In

Transcend Part 1: Mappings

If you read the blog regularly, then you know that Rittman Mead offers a product called Transcend that is designed to interact with the Oracle Database to make some of the heavy-lifting in ETL mappings very simple. Because we recently released version 2.5 of Transcend, I thought I'

Partitioning Fact Tables, Part 1

I'm dogmatic about certain aspects of data warehousing. For instance, fact tables should be range partitioned by DATE. I tell my clients all the time: you will have a very difficult time persuading me otherwise. But they always try: they argue about all the attributes that are more

Oracle OLAP 11g - Reporting in Excel using Simba MDX OLE-DB Provider

If you had looked at my blog entry here [https://www.rittmanmead.com/blog/2010/04/19/oracle-epm-11-1-1-3-oracle-olap-11g-reporting-on-oracle-olap-using-essbase-excel-add-insmartview-xolap/] , i would have shown a way of reporting on Oracle OLAP 11g using the newly introduced Essbase XOLAP. As mentioned there, one of the biggest advantages of using Essbase is its tight

Realtime Data Warehouses

In a little over two weeks I will be giving my Real Time Data Warehousing talk at Collaborate [http://collaborate10.ioug.org/Education/BIWATrainingDays/tabid/83/Default.aspx] 10 in Las Vegas. I will cover a variety of techniques and not just change data capture. However, in my opinion, CDC

Transcend and Segment-Switching

As you read this most recent post on the capabilities of Transcend, I'd like to pose a question to you: would you consider using Transcend in your environment if it was open-sourced? Currently, we implement Transcend as part of the Rittman Mead Rapid Deployment Framework for our clients,

Thoughts on Change Data Capture

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 [http://collaborate10.ioug.org/Education/BIWATrainingDays/tabid/83/Default.aspx#view] . Rittman Mead will be

Oracle 11g Pivot

One of the things that I often come across is the "up-dateable fact", that is a fact that starts life "incomplete" and changes overtime. Examples include things such as support calls that start life as "open" then progress through "responded", "resolved&

Data Warehouse Fault Tolerance Part 3: Restoring

Hopefully you've read the introduction [https://www.rittmanmead.com/blog/2010/02/02/data-warehouse-fault-tolerance-an-introduction/], Part 1 [https://www.rittmanmead.com/blog/2010/02/08/data-warehouse-fault-tolerance-part-1-resuming/], and Part 2 [https://www.rittmanmead.com/blog/2010/02/10/data-warehouse-fault-tolerance-part-2-restarting/]. Those posts detailed methods for building fault-tolerant ETL code, with a

Data Warehouse Fault Tolerance Part 2: Restarting

In my last post [https://www.rittmanmead.com/blog/2010/02/08/data-warehouse-fault-tolerance-part-1-resuming/], I described the First "R" in data warehouse fault tolerance: Resuming. As I mentioned in the introduction [https://www.rittmanmead.com/blog/2010/02/02/data-warehouse-fault-tolerance-an-introduction/] to this series, my goal is a triage approach

Data Warehouse Fault Tolerance Part 1: Resuming

In the introduction [https://www.rittmanmead.com/blog/2010/02/02/data-warehouse-fault-tolerance-an-introduction/] to this series of posts, I spoke briefly about data warehouse fault tolerance and the unique challenges resulting from high data volumes combined the batch load window required to create them. I then defined the goal: a layered

Data Warehouse Fault Tolerance: An Introduction

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

Oracle Database Resource Manager and OBIEE

When putting together an OBIEE system, one common requirement from clients is to provide an enhanced level of service for particular groups of users. For example, you might want to define a "standard" group for regular OBIEE users, and a "management" group that gets allocated more

Capturing Change (Part 2)

In the previous [https://www.rittmanmead.com/blog/2009/12/08/capturing-change-part-1/] part I outlined the business need for writing our own CDC routines and started to outline some of the issues we would need to resolve. Here I shall outline the approach we took and describe how to go

Transcend and Constraint Maintenance

In this [https://www.rittmanmead.com/blog/2009/12/21/transcend-and-index-maintenance/] posting, I explained the Transcend product as a new offering here at Rittman Mead, and I went on to demonstrate it's use with index maintenance. Now, I'd like to demonstrate another staple of data warehouse

Transcend and Index Maintenance

Before joining up with the guys across the pond, I ran my own consulting company based in Atlanta called Transcendent Data. With each new data warehouse I built, I realized I was engineering the same processes over and over again with each client. So I developed a framework of best-practices

Regular Expressions in OBIEE

When reporting against an OLTP system, in many ways, OBIEE works like an ETL tool, transforming the source system data and presenting it as a star schema. After years of writing ETL code, if there's one thing I hate to be without, it's regular expressions. So,

Capturing Change (Part 1)

Shortly after I joined Rittman Mead I wrote a small article [http://www.rittmanmead.com/files/DataW_Getting_Real.pdf] on real-time Business Intelligence , there is also a link to it on our "Articles" tab [http://www.rittmanmead.com/articles/]. One of the techniques I mentioned in passing

OWB 11gR2 Workspace Creation Issues

First of all, I'd like to thank David Allan of the OWB Product Team for helping me solve the problem I discuss below... and also for identifying what he thinks to be the cause. A few days after Oracle Database 11gR2 was available, I went about building my

Upgrading an OWB Project to 11gR2

Mark has been out front and center in demonstrating the new features of OWB 11gR2, both in the OWB Unconference [https://www.rittmanmead.com/blog/2009/10/13/calling-all-owb-developers-oow-2009/] and in numerous blog postings [http://www.rittmanmead.com/category/oracle-warehouse-builder/] over the last few months. But one thing we haven&

OLAP 10gR2 and Dense Looping

I'd like to take a moment to express my appreciation to several of the folks at the OLAP product team for their assistance with the project mentioned below, including A.A. Hopeman, Jameson White, Marty Gubar, and especially David Greenfield. The sky's the limit for Oracle