Tuesday, October 21st, 2003 by Mark Rittman
Frank Bouma’s a .Net developer who normally works with Microsoft SQL Server. However, he’s recently had to support Oracle 9i for a project he’s working on, and his verdict: “Oracle 9i is amazing”. According to Frank,
“What impressed me was Oracle’s feature set. Looking at that feature-set you can only conclude: what Oracle 9i offers […]
Tuesday, October 21st, 2003 by Mark Rittman
“No one would confuse Microsoft with Oracle. The two software juggernauts have carved out distinctly different markets. So it’s not surprising that the companies have differing policies on releasing information about security vulnerabilities.” writes Edward Hurley in this searchsecurity.com article. “Microsoft tends to release more technical details about its vulnerabilities and put out patches faster. […]
Monday, October 20th, 2003 by Mark Rittman
“Ease of use and accessibility are essential to widespread acceptance of BI, but simplicity has unfortunately come at the cost of analytic depth.” argues Seth Grimes in this IntelligentEnterprise Article. “BI’s online analytic processing (OLAP) focus has meant neglect of valuable approaches to problems that involve nonlinearity, uncertainty, indeterminacy, and time complexities.”
Nigel Pendse, of The […]
Monday, October 20th, 2003 by Mark Rittman
Eric S. Raymond, he of “The Cathedral And The Bazaar” and “The New Hackers Dictionary” (good), as well as holder of some mad pro-gun and libertarian views (not so good), has a new book out called “The Art Of Unix Programming”. According to the book’s web page;
“The Art of Unix Programming attempts to capture the engineering wisdom […]
Sunday, October 19th, 2003 by Mark Rittman
I had an email through the other day from Guy Mortenson, who I used to work with at Plus Consultancy before he left to find his fortune elsewhere. Guy pointed me in the direction of “Scrum”, a metholodology that his new employers are using to manage Oracle development projects.
According to the Scrum website;
“Scrum is an […]
Sunday, October 19th, 2003 by Mark Rittman
The following question came up on comp.databases.olap:
“I realise that Oracle Personal Express v5 is hopelessly old, but we are trying to replace the app that it runs off. Unfortunately we need to get the data out of the existing database and I can find zero documentation on how to do this. When I had a […]
Sunday, October 19th, 2003 by Mark Rittman
“Prior to Oracle9i, there are two popular methods to extract metadata from data dictionary. The first method involves querying the data dictionary using SQL statements. The second method involves running Export with ROWS=N, then running Import with SHOW=Y. Oracle9i introduces a new Metadata API (DBMS_METADATA package). It allows database users to easily retrieve complete database […]
Wednesday, October 15th, 2003 by Mark Rittman
UPDATE 19/10/2003 : According to this article by Sanjay Mishra, the feature discussed in this posting (using SQL expressions in Direct Path mode) is only available from Oracle 9i upwards. It therefore won’t work for Jon’s particular problem, although it would work on an Oracle 9i database. Sorry for any confusion.
Jon Mead came up with […]
Tuesday, October 14th, 2003 by Mark Rittman
I had the following response to a recent posting on comp.databases.olap regarding Oracle 10g OLAP New Features;
“thanks for the links concerning Oracle 10g. Is the software for 10g already available (evaluation, beta …)? I can’t find downloads in technet. Do I need to have a “10g DB” or can I run a 10g Discoverer on […]
Thursday, October 9th, 2003 by Mark Rittman
“Tom Kyte swears that if you properly analyze your table, the CBO is at the point where you never need hints. I find I still need them ‘occasionally’, though not very often. Anyone else have opinions? anyone who beta tested 10g see an improvement in the CBO? IT tends to get a little better with […]
