Rittman Mead - Delivered Intelligence

“Hi Mark. Do you know where I can find a comparison between the Discoverer Client/Server versus the Discoverer Intranet versions?”

If you’re interested, i’ve put together an explanation of the differences between the different Oracle Discoverer client tools, which you can take a look at here.

There’s a good discussion going on at asktom.oracle.com at the moment concerning star queries; take a look if you get a chance.

“Everytime I do a web search for anything to do with OLAP, I always seem to be directed to your web-site!So I have a query for you, having viewed your presentation on BI Beans. The Oracle9i Release 2 OLAP option appears to allow us to store both relational and multi-dimensional OLAP data within the Oracle […]

The 9.2.0.4.1 release of Oracle OLAP introduces a new concept known as

I

Arup Nanda has written an article for dbazine.com on the various methods for implementing partitioning for existing Oracle tables. Arup goes through a number of different options, including

Creating the partitioned table from scratch, using CREATE TABLE … AS SELECT to select from the original table
Creating the table, then populating it from the original table using INSERT […]

Garry Robinson has put together a useful guide to iSQL*Plus, a version of SQL*Plus introduced from Oracle 9iR2 that is delivered through a web browser. It talks you through setting up the tool, configuring it to work with Apache, defining which instances it can connect to, and points out a patch that should be applied […]

“Oracle has again extended maintenance support for customers of its 8i database on many major platforms, this time until 2005, giving firms another year to migrate to 9i or 10g.” reports vnunet.com. “The database giant has extended Error Correction Support (ECS) on the Oracle 8i database version 8.1.7 and 8.1.7.x until 31 December, 2004 for […]

Ralph Kimball, author of The Data Warehouse Lifecycle Toolkit, has put together a new article on reviewing data warehouse data models. Ralph was an early advocate of dimensional data warehouses, and the modelling techniques detailed in his books and articles are the recommended way that Oracle data warehouses are designed. According to the article;

“People often engage us […]

If you’ve ever had to port a Microsoft SQL Server or Access database over to Oracle, you’ve probably come across the different way joins are put together for these databases. For example,you might come across a query looking like this;

SELECT pub_name, title FROM publishers INNER JOIN titles ON publishers.pub_id = titles.pub_id

At first you might think […]