(Dan Tow) In a recent dialogue on the oracle-l@freelists.org mail group, I ran into a good prototype for a recurring class of SQL tuning problems. The coder had two versions of SQL getting dramatically different performance levels for a very frequent single-row query, and wanted to know the reason f
Other News
An Intro to Java Object Persistence with JDO
(Jeff Hanson) The ‘impedance mismatch’ between relational databases’ tabular orientation and object-oriented Java’s hierarchical one is a perennial problem for which the Java world has several good solution offerings. The third in a three-part series, this article examines the ways that JDO atte
IBM Buy Helps Clients Pinpoint Identity
(Clint Boulton) In a bid to augment its information management portfolio, IBM acquired SRD, a privately held identity resolution software maker, for an undisclosed sum.
Full Text Search on SQL 2000 Part 2
(Don Schlichting) In last month’s article, Full Text Searching was introduced as a way to query strings with more refinement than the usual TSQL “like” or equal operator statements. With Full Text Searching, a new file system structure is created, storing key words from selected fields into Catalogs
Converting VSAM calls to SQL
(Craig Mullins) I have a CICS/VSAM program where I am moving from VSAM to DB2 and replacing the VSAM data calls with the SQL queries. Can you please tell me what will be the equivalent for the READ FOR UPDATE in DB2 when it is a singleton select? Can I go for SELECT FOR UPDATE? (R)
The ASP.NET Web.config File Demystified
(Ruben Heetebrij) Applications of XML have been integrated into .NET to such an extent that XML is hardly a buzzword anymore. Microsoft, as you probably know, has taken XML into the core of its .NET framework. Not only is XML a generally accepted format for the exchange of data, it’s also used to st
E Pluriblog Unum: Merging RSS Feeds
(Kent Sharkey) This article describes one technique for merging multiple RSS feeds into a new RSS feed, which enables merging common data into a single source to make it easier for users to find the information they want.
Oracle Session Tracing Part IV
(James Koopmann) Part IV in our series will focus on determining which internal Oracle views hold the information to our enabled statistical gathering.
Classifying and representing data in SOAs
(Daniel L. Fox) Perhaps I’m just getting older, but in days gone by, the IT world was a simpler place. After all, when big iron ruled, the applications that the IT department developed shared a single data source, and all the clients for those applications shared the same code base and platform. The
Security Enhancements in the .NET Framework 2.0
(Keith Brown) As I write this column, version 2.0 of the Microsoft .NET Framework is at Beta 1. When I got my bits, I hacked together a little program to dump all of the public members of all public types in the entire Framework and ran it on version 1.1 as well as 2.0. I then used WINDIFF.EXE to co