Wednesday, April 21st, 2004 by Mark Rittman
Much of my work involves designing and reviewing dimensional data models, and
an interesting issue that often comes up is how to deal with data items such as
invoice number, order number and so on, that are not strictly facts - you’re not
going to want to add them up, or average them, or perform any other maths […]
Thursday, April 15th, 2004 by Mark Rittman
Niall Litchfield has
started a site on working with the Oracle database. I met Niall at the last
UKOUG conference and he seems like an all-round nice guy;
check it out when you
get a chance.
Wednesday, April 14th, 2004 by Mark Rittman
More news on the Oracle 9i 9.2.0.5 patchset, and it’s suitability for Oracle
OLAP users.
Anthony Waite confirms in an OTN
OLAP Forum posting that the 9.2.0.5 patchset contains all of the
functionality in the previous 9.2.0.4 patchset, and the 9.2.0.4.1 OLAP-specific
patchset. As there are no API changes in the 9.2.0.5 release, existing tools
such as the Analytic Workspace Manager […]
Thursday, April 8th, 2004 by Mark Rittman
"Larry Ellison, CEO of Redwood Shores, Calif.-based Oracle, and
Michael Dell, chairman and CEO of hardware giant Dell, joined forces during a
conference call with journalists and analysts Tuesday to announce that Dell will
offer Oracle’s Standard Edition One database prepackaged on Dell PowerEdge 2600
or 2650 servers running on Linux and Microsoft Windows. Dell customers can order
the PowerEdge […]
Tuesday, April 6th, 2004 by Mark Rittman
Even if you have done a superb job in installing and configuring Oracle9iAS,
if the system is not always available or if the performance is poor, then you
need to start looking at tuning and optimising your 9iAS instance. Being
complex, an Oracle9iAS environment has a huge amount of tuning
opportunities, which essentially boil down to
Tuning the backend 9iAS […]
Tuesday, April 6th, 2004 by Mark Rittman
Arup Nanda gives
us the lowdown on the Oracle 10g 10.1 release of SQL*Plus. And the good
news? "Contrary to some widespread rumors,
the COPY command is still available, although it will be obsolete in a
future release. (Hmm…didn’t we hear that in Oracle9i?) If you have scripts
written with this command, don’t lose heart; it’s not only available but
supported […]
Thursday, April 1st, 2004 by Mark Rittman
“Although Oracle has yet to officially announce its upcoming Oracle Certified Professional (OCP) 10g certification track, some details are starting to emerge” writes Becky Nagel for certcities.com.
