Time series in BI revisited

Wednesday, May 16th, 2007 by Peter Scott

But before that:
Why are recruitment companies so unnecessarily secretive ?
I have just seen an ad for a senior role at a leading Global BI vendor that goes out of its way to hide the name of the company recruiting - it’s a bit sad though that they mentioned part of the role is to “help […]

Month start odds and ends

Wednesday, May 2nd, 2007 by Peter Scott

Yet more consolidation in the BI product space. Every so often one of the major vendors disappears into a larger vendor. Proclarity has been absorbed by Microsoft and no sooner than Oracle had digested a main course of Sibel and its amazing BI tool, it was on to Hyperion for desert; it even had a […]

Pattern matching

Wednesday, April 4th, 2007 by Peter Scott

Tom Kyte posts an interesting paper and invites comment. It is not an easy read, and really needs a reasonable understanding of analytic functions, but persevere if you can.
To my mind the best place to find patterns is as close to the data as possible. I know that some vendors have developed “real time analytics” […]

So what do you call large databases?

Sunday, March 11th, 2007 by Peter Scott

I have written recently about the trend towards ever larger databases. But what should we call these VLDB systems?
A few years back a set of terms seem to fit well, DSS, MIS, data warehouse, datamart; sometimes the distinction between them was very blurred. But by and large we were dividing the reporting from the transactional. […]

Writing it large and reading it big

Saturday, March 10th, 2007 by Peter Scott

Yesterday I ungraciously forgot to mention Nuno Souto’s blog piece from January where he was talking about just the same sort of issues with access to massive databases. Please go and read Noons’ work, it is well worth it.
I mentioned two challenges yesterday, putting the data into the database and finding it again. Systems that […]

Where to buy your data warehouse in 2010

Friday, March 9th, 2007 by Peter Scott

As we have all seen there has been significant consolidation with in the BI tool space in the past 18 months or so. Some of the bigger players have been (or soon will be) assimilated into the other vendors’ product portfolios. In the main it has been the database vendors who have been shopping, but […]

Dimensions on the side

Tuesday, March 6th, 2007 by Peter Scott

It is quite a while since I blogged the mini-series on data warehouse design (it started here) and was proceeded by a series with the grand title of DW Wisdom - where I strayed into talking about parallel queries, RAID5 and massive disks. But I did not really write much about dimensions. So to make […]

End of week catch up

Friday, February 23rd, 2007 by Peter Scott

A somewhat slow week blogwise; loads of events that are not blog worthy, or just unusable for confidentiality reasons. Some may be written about later, but others will be locked away for ever.
At long last one of my customers is going to upgrade the Oracle version of there multi-terabyte DW. When I designed it I […]

Not such good ideas

Friday, January 26th, 2007 by Peter Scott

One of our consultants dropped by my desk to ask me some Oracle questions around data life cycle management. One of his customers is moving a store based system to a central system and like a lot of systems in the UK needs to keep 7 years of transactional data available. I explained all of […]

Just to reinforce the idea…

Monday, January 22nd, 2007 by Peter Scott

… that the hot topic in BI is “intelligence to the masses”. Cognos have just acquired a dashboard and operational reporting vendor, Celequest. Interestingly, Celequest also market a BI appliance product, a bit of a departure from the traditional Cognos world
I somehow doubt this will be the only vendor purchase this year. What were the […]