Securing Data Warehouses with Advanced Security, OID and VPD

Thursday, September 18th, 2003 by Mark Rittman

Once the domain of a small group of knowledge workers within an organization, data warehouses are increasingly becoming a critical part of an overall  I.T. infrastructure. Organizations have come to depend on the information held in data warehouses and data marts, and often the warehouse is the only source of information within an organization that [...]

The SQL MODEL Clause

Tuesday, September 16th, 2003 by Mark Rittman

Apart from the announcement that a future version of Discoverer will fully support Oracle OLAP multidimensional queries, the most important new business intelligence feature of Oracle 10G is the ‘SQL Model Clause’. Outlined in Tom Kyte’s recent white paper at Oracleworld, the SQL Model clause allows users to embed ‘spreadsheet-like’ models in a SELECT statement, [...]

Oracle 10g – A Self Managing Database?

Tuesday, September 16th, 2003 by Mark Rittman

One of the most interesting new features of Oracle Database 10g is the new ‘self-managing’ framework outlined in this white paper by Sushil Kumar, available on the Oracleworld site. Automatic maintenance and tuning has always been one of the key product differentiators for Microsoft SQL Server and with Oracle 10g, features that meet and match [...]

Installing Oracle 9iR2 on Red Hat 9

Saturday, September 13th, 2003 by Mark Rittman

Keen to run Oracle on Red Hat 9 but having problems with libraries and kernel parameters? This article over at ITToolbox gives you step-by-step instructions on installing Oracle 9i Release 2 on Red Hat 9, including the installation of the backward-compatability and software development packages required to get the installation up and running first-time.

Oracle 10g OLAP New Features

Wednesday, September 10th, 2003 by Mark Rittman

Bud Endress has written an excellent paper on Oracle 10g OLAP new features which is currently available for download from the Oracleworld website. Some of the new features for the 10g OLAP option look pretty exciting, and the benefits of integration with the traditional relational Oracle engine are starting to become apparent. First up is [...]

Website Design & Build: tymedia.co.uk