Thursday, October 21st, 2004 by Mark Rittman
A reader asks:
“I am new to OLAP and Oracle OLAP and I have a question. I have an Oracle 10g Database with relational tables in it. I want to create dimensions and cubes from that data. Do I need to create separate dimension and fact tables from that relational data, or do I just use […]
Thursday, October 21st, 2004 by Mark Rittman
A reader asks:
"I am new to OLAP and Oracle OLAP and I have a question. I have an
Oracle 10g Database with relational tables in it. I want to create dimensions
and cubes from that data. Do I need to create separate dimension and fact
tables from that relational data, or do […]
Tuesday, October 19th, 2004 by Mark Rittman
I was looking through Steve Adams’ Ixora
site the other day and I came across
this presentation that
talks about another approach to Oracle tuning.
Entitled "Tuning By Layers",
it’s a couple of years old now but puts forward the idea that a system consists
of a number of layers, with each layer putting a load on the layer beneath it.
According […]
Monday, October 18th, 2004 by Mark Rittman
Dashboard Design: Why Design is Important : "Effective design is crucial
for dashboards. A good information design will clearly communicate key
information to users and makes supporting information easily accessible.
Dashboards and visualization are cognitive tools that improve your "span of
control" over a lot of business data. These tools help people visually identify
trends, patterns and anomalies, reason about […]
Friday, October 15th, 2004 by Mark Rittman
The
Register : "Sharp to ship world’s first HDD-based PDA"
Ooh, this looks really nice …
"Sharp will next month ship its latest Zaurus PDA into the Japanese
market, the consumer electronics company announced this week. The device will be
the first PDA to sport a hard drive.The Linux-based SL-C3000 adopts the
clamshell casing of Sharp’s other Japanese PDAs, with a […]
Wednesday, October 13th, 2004 by Mark Rittman
Business Activity Monitoring (BAM) - The Future of Business Intelligence :
"The demand for solutions that provide more complete and timely visibility
into business operations has increased year after year but has yet to be focused
on the business manager. The next wave of information access, analysis and
response solutions will enable what is now known as Business activity […]
Sunday, October 10th, 2004 by Mark Rittman
Oracle’s 10g Undo Advisor : "As a DBA, you are always
faced with the critical question of whether the undo that you have created is in
fact sufficient for the transaction mix on your database system. Oracle has now
given us an Undo Advisor in Oracle 10g to help simplify the answer."
Sunday, October 10th, 2004 by Mark Rittman
A couple of good articles by Jonathan
Lewis. "How much
does an update cost ?" looks at what the true cost of an update is when it
just sets a column to the same value. This often happens when a generic bit of
application code updates all of the columns in a set of tables, rather than just
updating those […]
Thursday, October 7th, 2004 by Mark Rittman
John
Garmany : Application Server Backup & Recovery Tool : "When Oracle
released Application Server 10g, it provided a backup tool that has gotten
little press. In the Oracle Press book, Oracle Application Server 10g
Administration Handbook I only mentioned the tool but did not discuss how to use
it. That was because I was working on the AS10g Beta […]
Thursday, October 7th, 2004 by Mark Rittman
John
Garmany : Application Server Backup & Recovery Tool : "When Oracle
released Application Server 10g, it provided a backup tool that has gotten
little press. In the Oracle Press book, Oracle Application Server 10g
Administration Handbook I only mentioned the tool but did not discuss how to use
it. That was because I was working on the AS10g Beta […]
