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 to know that Don Burleson has just
published an interesting article [...]

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
fact table, the fact [...]

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, link,
unlink, truncate and rename. [...]

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 how to use some
of these [...]

"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 place last week in San
Francisco."