Stewart Bryson - Rittman Mead (Page 3)

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

RMOUG Training Days

The annual RMOUG Training Days [http://rmoug.org/training.htm] event takes place on February 17th and 18th in Denver, CO, with some additional university sessions taking place on February 16th. I am excited to be co-presenting with Mark Rittman on A DBA and Developers' Guide to Oracle Warehouse

Technical

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

Technical

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

Technical

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,

Technical

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

Technical

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&

Rittman Mead

The Start of Open World Day 3

While Mark and Venkat are keeping us all informed on the BI sessions going on at Open World, I wanted to take a minute to provide a quick update concerning what's going on in the exhibition hall. We're located at Booth 124, Moscone South, which is

Rittman Mead

Beginning Day 2 at Open World

As Mark pointed out this morning, the weather in San Francisco is terrible. Having endured the recent flooding conditions in the Atlanta area, I can't help but feel like I brought the rain with me. However, I'm inside a huge conference center, with tents between all

Technical

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

Technical

Using a Process Flow to loop through Months in a Table

I hate having to maintain the same ETL logic in two different places; it violates everything I know about good coding practices. When using Java, PL/SQL, or even shell script, a good developer will modularize particular bits of his or her code to make sure distinct business logic is

Technical

Hybrid SCDs using OWB and OBIEE

If you attended my ODTUG Kaleidoscope presentation on Oracle Warehouse Builder (feel free to view the presentation [http://www.rittmanmead.com/files/odtug_owb_considerations.pdf]), then you know that certain aspects of the product leave me scratching my head, especially as a follower of the dimensional modeling approach popularized

Gearing up for ODTUG

Currently, I'm flying toward Los Angeles for my connecting flight to Monterey, and with internet access (thanks Gogo [http://www.gogoinflight.com/]) and nothing but time, I decided to have a look at the technical sessions [http://www.technicalconferencesolutions.com/pls/caat/caat_abstract_reports.schedule?conference_id=

Technical

Materialized View and Partitioning "Gotchas", Part II

If you follow the blog, then you know that Mark recently posted about materialized views for aggregation, located here. [https://www.rittmanmead.com/blog/2009/04/18/materialized-view-and-partitioning-gotchas/] One of the issues he encountered was how to refresh materialized views based on tables loaded with partition exchanges... a common approach

Technical

Using a PARTITION BY JOIN to Fill In The Gaps

As a quick introduction, I'm Stewart Bryson, Technical Director for North America. It seems strange to be posting an entry on this blog after so many years of reading it, and learning from it. The momentum it has in the community is something I do not take lightly,