Time votes

Friday, October 21st, 2005 by Peter Scott

Yesterday my thoughts returned to the topic of time, not in the Stephen Hawkin sense but the more prosaic "Data Warehouse" sense. Three questions popped up, and although I hold firm views about the answers I think there are others out there with the opposite view and indeed a lot with the 'it depends' view.
Firstly, […]

Temporal Databases

Friday, October 21st, 2005 by Mark Rittman

If you were following the replies to the Column-based Databases, Sybase IQ and SAND Technologies thread last week, here’s another concept that’ll get your head spinning : Temporal Databases.
I’ve been following this idea since a couple of weeks ago, when Doug Burns reported on a presentation Oracle’s Rob Squire gave on […]

Temporal Databases

Friday, October 21st, 2005 by Mark Rittman

If you were following the replies to the
Column-based Databases,
Sybase IQ and SAND Technologies thread last week, here’s another concept
that’ll get your head spinning : Temporal Databases.
I’ve been following this idea since a couple of weeks ago, when

Doug Burns reported on a presentation Oracle’s Rob Squire gave on the
subject (slides
here, but you need UKOUG membership […]

Table Booked for the UKOUG Bloggers’ Dinner

Tuesday, October 18th, 2005 by Mark Rittman

I’ve booked the restaurant now for the UKOUG bloggers’ dinner on the 31st October 2005, during the conference. We’re going to Tin Tin’s Chinese Restaurant, in the Brindleyplace development just over from the ICC, and so far there’s sixteen of us going.
The list of attendees so far is myself, Niall Litchfield, Pete […]

New CASE Expression Paper by Doug Burns

Tuesday, October 18th, 2005 by Mark Rittman

Doug Burns has just published a new paper about CASE expressions, which replaces an earlier paper he wrote on DECODE. If you’ve read Doug’s parallel query paper this one is of the same high quality, if you use DECODE for any ETL, calculations or so forth I’d thoroughly recommend popping over […]

New CASE Expression Paper by Doug Burns

Tuesday, October 18th, 2005 by Mark Rittman

Doug Burns has
just
published a new paper about CASE expressions, which replaces an earlier
paper he wrote on DECODE. If you’ve read Doug’s parallel query paper this one is
of the same high quality, if you use DECODE for any ETL, calculations or so
forth I’d thoroughly recommend popping over to Doug’s site and downloading it
now. Good stuff.

Table Booked for the UKOUG Bloggers’ Dinner

Tuesday, October 18th, 2005 by Mark Rittman

I’ve booked the restaurant now for the
UKOUG bloggers’ dinner
on the 31st October 2005, during the conference. We’re going to

Tin Tin’s Chinese Restaurant, in the Brindleyplace development just over
from the ICC, and so far there’s sixteen of us going.
The list of attendees so far is myself, Niall Litchfield, Pete Finnigan, Doug
Burns, Peter Scott, Tom Kyte, […]

Token databases

Monday, October 17th, 2005 by Peter Scott

Mark Rittman recently posted on the subject of column orientated databases such Sybase IQ and various SAND Technology Inc products. One aspect Mark mentioned was the use of tokens to store attribute data.
In a previous role (before moving back into the mainstream world of Oracle data warehouses) I worked on 'free-text' information systems and in […]

SAND, Sybase IQ and Column-Based Databases

Sunday, October 16th, 2005 by Mark Rittman

Several months ago a reader contacted me about about a new data warehousing technology he’d come across:
“Mark,I have been reading a quite enthralling document (sounds nerdy I know), about how to actually achieve ROI on Data Warehousing.The article is http://www.it-director.com/research.php?productid=748.Its done by Bloor, and to be honest is really pitching you to use SAP. I’m […]

SAND, Sybase IQ and Column-Based Databases

Sunday, October 16th, 2005 by Mark Rittman

Several months ago a reader contacted me about about a new data warehousing technology he’d come across:
“Mark,
I have been reading a quite enthralling document (sounds nerdy I know), about how to actually achieve ROI on Data Warehousing.
The article is http://www.it-director.com/research.php?productid=748.
Its done by Bloor, and to be honest is really pitching you to […]