Andy Hayler on Federated Data Warehousing Apart from atalent for producing criminal geniuses [http://www.rittman.net/archives/2006/05/mary_ann_davidson_the_british.html], the UK seems to be good at producing data warehousing experts, and Kalido's Andy Hayler is one of my favourites. His blog is always a good read, and
Taking Delivery of my New Apple Macbook Ijoked the other day [http://www.rittman.net/archives/2006/05/the_only_thing_better_than_spu.html] that I was so pleased that Arsenal lost the Champions League final to Barcelona, I was going to order one of the thosenew Macbooks [http://www.apple.com/macbook/macbook.html] -
Data Warehousing Learn by play Today was a playday. I spent the day having a go with the new Enterprise Edition of Oracle’s BI suite. I found some of the tools very easy use and as a person with a database rather than a user-tool background I didn’t have that baggage of saying
OWB 10g Release 2 Now Available For Download Oracle Warehouse Builder 10g Release 2, previously known by the codename "Paris", is now available for download [http://www.oracle.com/technology/products/warehouse/index.html] on OTN. This is the long-awaited release that adds support for things such as pluggable mappings, slowly changing dimensions, data modelling of
Data Warehousing Rollup the sub partitions In data warehouse there is often the need to summarise, aggregate, or roll-up (the three terms often being used interchangeably) fact data. This is either achieved at query time within the query or in advance by the use of pre-built summaries. As I blogged yesterday [https://www.rittmanmead.com/blog/
Summaries David Aldridge, aka the OracleSponge [http://oraclesponge.blogspot.com/] has recently blogged [http://oraclesponge.blogspot.com/2006/05/three-pillars-of-oracle-data.html] on the three ‘P’s of Data Warehousing. David commented that the “pseudo P”, summarisation, was perhaps the most important. Well, I must say that I agree with him there.
UKOUG BI & Analytics Special Event, London LikeLisa Dobson [http://newbiedba.blogspot.com/2006/05/ukoug-bi-and-analytics-event.html] and Peter Scott [http://pjs-random.blogspot.com/2006/05/uk-oug-bi-special-event-day.html], I went along to theUKOUG BI & Analytics Special Event [http://www.ukoug.org/calendar/show_events.jsp?year=2006&month=05&day=16] at the Grange
The Only Thing Better Than Spurs Winning the Champions League ... Is watching Arsenallose it [http://news.bbc.co.uk/sport1/hi/football/europe/4773353.stm]. Still, at least Thierry Henrygot to meet some of his new team-mates [http://soccernet.espn.go.com/news/story?id=366400&cc=5739]. I'm so happy I think I'll go
XML Publisher 5.6.2 Available for Download If you read my articles earlier this year on XML Publisher 5.6 RC2, you'll be interested to know that the full production version, now known as XML Publisher 5.6.2, is available for download from http://edelivery.oracle.com. It's a bit of a
An Oracle Answers and Oracle Dashboard Walkthrough If you read my article the other day on the architecture of OracleBI Suite Enterprise Edition, here's a walkthrough of creating a simple report and dashboard. It's using the Siebel version of the tools as the Oracle branded versions aren't available yet on OTN,
Participate in the OLAP Survey 2006 The OLAP Survey 2006 is now looking for participants, with this message from Gordon Laver: [http://www.survey.com/olap6sur8.html] "We would very much welcome your participation in The OLAP Survey 6. This is the largest independent survey of business intelligence users worldwide. The Survey will obtain input
Technical An interesting case Tuning data warehouse queries is not always easy; when you take into account complications such as parallel query, bitmap indexes, star transforms, and query rewrite then there is a lot going on to confuse the picture. This is further complicated by the sort of SQL generated by query tools, especially
A Guide to OracleBI Suite Enterprise Edition Oracle Business Intelligence Suite Enterprise Edition is Oracle's "next generation" business intelligence platform. Centred around Oracle BI Analytic Server, a business intelligence "application server", Oracle BI Suite Enterprise Edition comes with a range of ad-hoc, presentation and delivery tools and supports connectivity to a
Data Warehousing I like SQL Developer One of our customers sent in some SQL that took ages to run. On the face of it was not doing anything difficult, it just inserted the results of an aggregate query into another table. The select part of the query joined two large partitioned tables on the partition key
Data Warehousing Debating Earlier this year Mark Rittman and I briefly discussed the concept of a matching pair of conference papers on aggregation in Business Intelligence. Mark would look at the use of Oracle OLAP as an aggregation technique and I would do something similar on conventional (and maybe less conventional) relational techniques.
Honest consulting On a follow-up to my last post Beth [http://www.blogger.com/profile/20798882] wrote: It's been my experience that clients appreciate honest (yet tactful) discussions with the techies when making their decisions. She is absolutely right. I can remember at least two occasions where customers specifically asked
Final Day at Collaborate’06, and Setting Up Siebel Analytics Well that's it for me now at Collaborate'06. We did our last presentation yesterday and afterwards, I went along to the IOUG closing debate, on commercial Unix vs. Linux. As you would have expected, the argument came down to commoditisation of hardware and software, and the
Tuesday and Wednesday at Collaborate’06 It's been a busy couple of days at Collaborate, hence the lack of updates since Monday. We've been giving presentations over the last couple of days, and coupled with trying to attend a few of the sessions, there's been little time for blogging. Most
Agenda Change for “Best Practices for the OLAP Option to Oracle Database 10g” Presentation If you're at Collaborate'06 and were looking to come along to my Best Practices for the OLAP Option to Oracle Database 10g talk on Wednesday, it's been moved now to Tuesday, 4.45pm in Cheekwood C. It should be in the agenda changes leaflet
Monday at Collaborate’06 First of all, just to repeat : If you were looking to come along to my Best Practices for the OLAP Option to Oracle Database 10g talk on Wednesday, it's been moved now to Tuesday, 4.45pm in Cheekwood C. It should be in the agenda changes leaflet in
Sunday at Collaborate’06 Yesterday was the first day proper for Collaborate'06 with some all-day education sessions going on over at the main conference venue. I was hoping to pop into Don Burleson's Predictive Modelling session but I couldn't get in in the end, so I took the
Arrived at Collaborate’06, Nashville I've arrived at the Collaborate'06 [http://www.collaborate06.com/]hotel now and it's about a quarter to seven in the morning. I flew in to Nashville around 4 o'clock yesterday and got down to the venue, about an hour later. You can
Big, bad disk. Over on Doug Burn’s blog there is a link [http://www.pythian.com/blogs/170/750g-disks-are-bahd-for-dbs-a-call-to-arms] to an interesting piece on large disks. Some people would think that the data warehousing community would welcome large disks. But probably for the majority (those of us that use conventional relational databases)
Presenting at Collaborate’06, Nashville I'm going to be presenting next week at theCollaborate'06 [http://www.collaborate06.com/] event in Nashville, Tennessee. Collaborate'06 is a joint conference between the IOUG, OAUG and Quest Direct and is being held at the Gaylord Opryland Hotel, Nashville, from April 23rd through to
Data Warehousing Big game hunting The last DW post talked about dates and times within a data warehouse. The time that a sale or some other transaction occurs can usually be recorded by an Oracle DATE value in the data warehouse; some DW may need to use timestamps, but to-the-second times would normally be adequate.
