Review Of 2004, Part Two

Friday, December 31st, 2004 by Mark Rittman

Concluding my review of 2004, today going from July through to December.
July
July started with
an explanation of Oracle’s
new Information Architecture, "a model that describes how Oracle’s
products can be used to create a ‘modern, real-time enterprise’. It uses the new
10g server technology (database, application server) together with the
e-Business Suite and the new Customer Data Hub, with application […]

Review Of 2004, Part One

Thursday, December 30th, 2004 by Mark Rittman

It’s traditional at this time to do a "review of the year", so here’s a look back at this blog
during 2004, starting today with January through to June.
January
January started
off with an article by Seth Grimes that compared XML/A and JOLAP, the two
competing standards for OLAP querying. According to Seth, "I believe that
JOLAP will prove a […]

Merry Christmas & A Happy New Year

Tuesday, December 21st, 2004 by Mark Rittman

It’s
almost that time of year again, and in a couple of days we’ll be off to Ireland
for the Christmas break to stay with Janet’s family (Note to burglars - the
house has an alarm and the neighbours are in next door)
As I’ll be banned from taking the laptop (and no doubt my

"Oracle10g OCP New Features For […]

Merry Christmas & A Happy New Year

Tuesday, December 21st, 2004 by Mark Rittman

It’s
almost that time of year again, and in a couple of days we’ll be off to Ireland
for the Christmas break to stay with Janet’s family (Note to burglars - the
house has an alarm and the neighbours are in next door)
As I’ll be banned from taking the laptop (and no doubt my

"Oracle10g OCP New Features For […]

Nicholas Goodman On The OWB “Paris” Data Profiler

Saturday, December 18th, 2004 by Mark Rittman

Nicholas Goodman is
running another article in his

Oracle Warehouse Builder "Paris" early review series, this time on the

data profiling feature within "Paris".

It’s a pretty in-depth look at the profiling feature, and also comes with a
number of screenshots that show off the new Oracle Business Intelligence 10g
"look and feel". According to the article, "The new Data
Profiling features […]

Lucas Jellema On Enterprise Planning & Budgeting

Friday, December 17th, 2004 by Mark Rittman

Lucas Jellema has put together an informative Amis Blog article on a
private session he’d
recently on Enterprise Planning & Budgeting. A lot of what’s in it I covered
in my previous "Under The
Covers With Enterprise Planning & Budgeting" article but there’s some
interesting new points that Lucas comes up with:

"The benefits an organisation will get from using EPB […]

Lucas Jellema On Enterprise Planning & Budgeting

Friday, December 17th, 2004 by Mark Rittman

Lucas Jellema has put together an informative Amis Blog article on a
private session he’d
recently on Enterprise Planning & Budgeting. A lot of what’s in it I covered
in my previous "Under The
Covers With Enterprise Planning & Budgeting" article but there’s some
interesting new points that Lucas comes up with:

"The benefits an organisation will get from using EPB […]

Introduction To Java Stored Procedures

Friday, December 17th, 2004 by Mark Rittman

"Oracle and
Java Stored Procedures", Michael Klaene : "Beginning with version 8i, the
Oracle database includes a fully functional Java Virtual Machine, Oracle JVM.
Out of this close relationship between Oracle and Java emerges an important
technology for Oracle developers: Java stored procedures. With Java stored
procedures, developers have the ability to harness the power of Java when
building database applications. […]

Doug Burns On Tuning Parallel Execution

Friday, December 17th, 2004 by Mark Rittman

The other week I wrote an article on a
database tuning engagement
I’d been on, and one of the things that I looked at during the visit was a
SELECT statements that was being executed in parallel. After running the
statement with an event 10046 trace, the TKPROF output looked like this:

SELECT [list of account fields]
FROM ACCOUNTS WHERE CUSTOMERID […]

BI Dashboards Using Discoverer “Drake” And BI Beans

Wednesday, December 15th, 2004 by Mark Rittman

If you came along to the Open Word Discoverer "Drake" presentations, or had a
look at the presentations and papers available for download, you’ll probably
have noticed that a major theme for Drake is the provision of BI "Dashboards".
Built using Oracle Portal and the Discoverer "Drake" Portlet Provider, these
dashboards integrate OLAP and relational reporting, display the results […]