Seth Grimes on Text Mining

Sunday, November 30th, 2003 by Mark Rittman

“Text analytics provide concept discovery, automated classification, and innovative displays for volumes of unstructured documents.” writes Seth Grimes in another good IntelligentEnterprise article.

Pete Finnigan On Oracle Row Level Security

Sunday, November 30th, 2003 by Mark Rittman

Oracle security specialist Pete Finnigan, author of the ‘Detecting SQL Injections In Oracle’ article, has recently published a new paper on implementing row level security on Oracle.
According to Pete’s website, “Part one discusses the reasons to use RLS and uses a simple example to show how some simple business rules could be constructed” whilst “Part […]

Information on Oracle Embedded Data Warehouse

Tuesday, November 25th, 2003 by Mark Rittman

“I am trying to find information about Oracle EDW, which is supposed to be a datawarehouse out of the box for Oracle applications. Only thing that pops up at Oracle is the warehouse builder FAQ and that is no help. Please send me link to any documentation.”

If you’ve got access to Metalink, there’s a section […]

Dealing With “Cannot Get List Of Connections” 9iAS Discoverer Error

Monday, November 24th, 2003 by Mark Rittman

Just came across an interesting error when plugging a new Discoverer mid-tier instance into an existing 9iAS Farm. The Discoverer server was running on Windows 2000, the server on Unix.
When I tried to create the first public connection (to check that Discoverer portlets work), I got the error message “Cannot get a list of connections. […]

Tom Kyte On Data Warehousing vs OLTP, and Oracle 9i New DW Features

Monday, November 24th, 2003 by Mark Rittman

There’s a couple of good questions just appeared on asktom.com:
The first concerns the differences between data warehouses and OLTP systems, particularly with regard to developer and DBA skills;

“How is a data warehousing database different from a regular database? I usually find that data warehousing is seen as a separate skill. Why ? What are the […]

Oracle OLAP User Privileges Explained

Friday, November 21st, 2003 by Mark Rittman

A recent poster on the OTN OLAP Forum asked the question “What are the minimum privileges needed by an Oracle user when viewing BI Beans reports against an analytic workspace?”. This was a question I was thinking about as well, so I decided to do a bit of investigation.
There are three main Oracle roles that […]

Is Oracle Flexible Architecture Still A Sensible Approach?

Tuesday, November 18th, 2003 by Mark Rittman

“I am new to Oracle and am preparing to install on a Linux box.  Is Optimal Flexible Architecture (OFA) commonly used?” asks a recent poster on comp.databases.oracle.server.

Combining Embedded Total and Unsolved Dimensions In A Single Cube

Tuesday, November 18th, 2003 by Mark Rittman

There’s an interesting thread on the OTN OLAP Forum at the moment. 

“I am trying to define a cube using the cwm2_olap packages, where not all dimensions have embedded totals.
Dimension A is Time with a hierarchy of Day>Month>Year and I want embedded totals for that. Dimension B only has a very small tree (three levels, 10 lowest level […]

Slashdot reviews “Softwar: An Intimate Portrait Of Larry Ellison”

Tuesday, November 18th, 2003 by Mark Rittman

One of the new Larry Ellison / Oracle books recently published, “Softwar: An Intimate Portrait Of Larry Ellison” has just been featured in Slashdot’s book review section.
Oracle’s always an interesting subject for the Slashdot crowd because;

Oracle are a big supporter of Linux and the standards process
You can download all of the software for development purposes […]

New BPEL and Web Services Blog By Mike Lehmann

Tuesday, November 18th, 2003 by Mark Rittman

Mike Lehmann, who works at Oracle on their BPEL and Web Services technology, has started a new blog. Being a RadioUserLand blog, you can also subscribe to the RSS feed here.