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 [...]

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 [...]

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 [...]

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. [...]

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 [...]

Website Design & Build: tymedia.co.uk