|
Switching Data Modeling Tools? Ouch! |
|
Bert
|
Monday, June 25, 2007 7:52 AM
|
|
|
|
Probably the single most painful task in data modeling (or any modeling for that matter) is switching tools. Forget the high direct costs like purchasing licenses and the obvious indirect costs of retraining your staff, because it’s the migration of all your meta-data from one tool to the other that looms large on t ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
|
Quest Recursive SQL Transformation Technology |
|
RichardTo
|
Wednesday, June 20, 2007 4:58 AM
|
|
|
|
Quest Recursive SQL Transformation technology is an innovative AI technology that simulates human SQL transformation technique. It incorporates a set of transformation rules to transform SQL statements on a section-by-section basis. This replaces the trial and error method used by human to rewrite the syntax of a SQL statement. Each t ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
Can You Take a Hint? |
|
MikeA
|
Thursday, June 14, 2007 10:14 AM
|
|
|
|
Hints in Oracle have been around since version 8. Hints are like compiler directives that tell Oracle what path to take when optimizing a SQL statement (generally speaking.) However, Oracle will ignore the hint if it can’t do it or it is formatted poorly.
|
|
|
|
|
Read More...
|
|
|
|
The Cost of Poor Database Design |
|
MikeA
|
Wednesday, May 30, 2007 9:32 AM
|
|
|
|
I’ve been searching for a definitive answer to the question: “What is the cost of poor database design?” No doubt you have all seen the cost/benefit graphs for fixing application problems and the pyramid showing how up to 90 percent of performance issues in a running database are SQL and ind ...
|
|
|
|
|
Read More...
|
|
|
|
Feuerstein in Buenos Aires and Magic Tricks |
|
StevenFeuersteinTW
|
5/9/2007 11:24 AM
|
|
|
|
It is Wednesday, May 09, 2007 and I am sitting in the Admiral's Club at the Buenos Aires airport. I just finished two days in this lovely city. My first day was spent enjoying the chilly, but very sunny afternoon, walking for four hours around the city. It is a busy, busy place with many buses throwing way too much gritty exhaust into the air (hey, ...
|
|
|
|
Comments (3)
|
Read More...
|
|
|
Using Cross-Instance Parallel Query |
|
MikeA
|
Friday, May 04, 2007 11:23 AM
|
|
|
|
With the use of RAC on the rise it is time to talk about the use of a feature very under-utilized in Oracle. This feature I refer to is cross-instance parallel query. Many times on site visits I see people using single-instance parallel query, but no one whose system I reviewed has used cross-instance parallel. Some weren’t aware it was available ...
|
|
|
|
|
Read More...
|
|