Getting the most from today’s complex database systems is a challenge. Learn how self-managing capabilities in DB2 UDB v.8.2 do some of the work for you. (R)
Author: SSWUG Research
XML for Client-Side Computing
(Coach Wei) XML is a simple, flexible text format initially designed for large-scale electronic publishing. It is flexible, open, and human-readable, and can be learned easily. XML can also be generated, parsed, analyzed, and transformed easily. It’s no wonder that XML has been widely used for s
XML-to-SQL Query Translation Literature: The State of the Art and Open Problems
(Rajasekar Krishnamurthy, Raghav Kaushik, and Jeffrey F. Naughton) Recently, the database research literature has seen an explosion of publications with the goal of using an RDBMS to store and/or query XML data. The problems addressed and solved in this area are diverse. This diversity renders i
Adventures in Clustering on 8 Nodes
(Larry Chesnut) I imagine there are not too many of you out there who have the where-with-all to test out SQL 2005 Beta 2’s clustering abilities on an 8 node cluster. This is a new feature available to SQL 2005 and only when using Windows 2003 Enterprise or Datacenter editions.
The Bowling Challenge
(Andy Warren) I wrote an article recently (Is all code really code? One question from an interview) that discusses why I think developers look at TSQL as being "different" than "real" code. The article definitely provoked a good discussion, you may find it interesting just for that part alone. So wh
Oracle president addresses image, app software decline
(Robert Westervelt) Oracle Corp. president Charles E. Phillips Jr. addressed publicly for the first time the company’s souring public image amid his company’s 15-month battle to acquire application software vendor PeopleSoft Inc. In an interview with SearchOracle.com, Phillips acknowledged that t
Installation Cookbooks: Deploying Reports on the Web
(Steve Callan) In a previous article, I discussed a deployment framework for getting Forms on the Web. This article discusses the steps to get your Reports on the Web. I’ll cover the steps to use Reports-related built-in’s in your forms, how to “tell” your forms the name of your report server, h
Service-Oriented Architecture
(Bernhard Borges, Kerrie Holley and Ali Arsanjani) In many respects, SOA is an evolution of the fundamental tenets governing component-based development (CBD). It also represents a quantum leap in bringing business and information technology into closer alignment through a set of SOA services ground
INF: How to Overcome the 32 KB Limit for SQL Expressions
Analysis Services limits the length of SQL expressions to 32 KB. Some applications require complex SQL Case expressions to define member names and keys, which would exceed the 32 KB limit. This article explains how you can work around the 32 KB limit.
Getting the Most Out of SQL*Loader Direct Path Loads
(Richard Phillips) There are four SQL*Loader direct path load parameters that directly affect the elapsed time of direct path load operations: –READSIZE is the size of the buffer used to read data from input data files. –COLUMNARRAYSIZE is the number of rows in a two-dimensional array used