Rittman Mead - Delivered Intelligence

If you followed the recent colourful debates on comp.databases.oracle.server on tuning using ratios vs. tuning using extended trace, sizing the buffer cache, calibrating the cost-based optimizer, and rebuilding indexes, read Cary Millsap’s book on Optimising Oracle Performance, Niall Litchfield’s Five Great Oracle Myths presentation, or read Richard Foote’s paper on Index Internals, you’ll be interested [...]

The other week I was working for a client who was putting together a type 2 slowly changing dimension (a.k.a. ‘SCD2′) to hold details of their customers. A customer could (for example) move over time, and the type 2 dimension tracked all changes to their postcode over time. When a transaction was recorded in the [...]

GMAILFS – GMail Filesystem: "GmailFS provides a mountable Linux filesystem which uses your Gmail account as its storage medium. GmailFS is a Python application and uses the FUSE userland filesystem infrastructure to help provide the filesystem, and libgmail to communicate with Gmail. GmailFS supports most file operations such as read, write, open, close, stat, symlink, [...]

Analytic Functions In Oracle Warehouse Builder: "Analytic Functions are an important feature of the Oracle database that allows the users to enhance SQL’s analytical processing capabilities. These functions enable the user to calculate rankings and percentiles, moving window calculations, lag/lead analysis, top-bottom analysis, linear regression analytics and other similar calculation-intense data processing. This whitepaper describes [...]

"BI on the Linux platform picked up even more traction last week as a trio of BI vendors announced product support for the open source operating system." writes Stephen Swoyer for Enterprise Systems. "Cognos Inc., Actuate Corp., and Siebel Systems Inc. all trumpeted Linux-related announcements in conjunction with the LinuxWorld Conference and Expo, which took [...]