Oracle Database 10g’s Automatic Storage Management (ASM) delivers previously unattainable levels of storage management efficiency through highly automated, application-centric rules and policies that reduce many hands-on tasks to the point of elimination. Oracle customers shared their experiences wi
Other News
You may receive an ‘OLE DB provider ‘‘ supplied inconsistent metadata for a column’ error message when you issue an SQL query statement against a DB2 table in Host Integration Server
In Microsoft Host Integration Server, you may receive an error message that is similar to the following when you issue an SQL query statement: Server: Msg 7356,Level 16,State 1,Line 1 OLE DB provider ‘Provider Name’ supplied inconsistent metadata for a column. Metadata information was changed at
Loading, Parsing, and Generating XML using C# and the System.XML Namespace
(Jesse Smith) I’ve been working with Web services lately. After writing a bunch of code, I found a way to trick the .NET compiler into treating an XML stream as HTML. Doing so makes managing XML data a lot easier, as you can feed data returned from the web service right into your .Net script without
Using foreign keys and referential integrity in MySQL
Referential integrity is an important concept in database design. The term refers to a state when all the references in a database are valid and no invalid links exist between the various tables that make up the system. When referential integrity exists, any attempt to link to a record which does no
DB2 and open source: Put yourself on the map with Google Maps API, DB2/Informix, and PHP on Linux
(Marty Lurie and Aron Y. Lurie) The recent explosion of information has spawned many new technologies that help digest all these gigabytes. Most humans do best with graphical representations when trying to absorb lots of information. Geographic data, in this case from the US Census, can be visualize
Highly Available Architectures and Capacity Planning with WebSphere Remote Server V5.1.2.1
(Chris McCollum, Byron Braswell, Ryan Brown, Ivor Castelino, Kevin Collins, Maria Koshkina, Anant Kumar and Chris Li) IBM WebSphere Remote Server V5.1.2.1 delivers a fully integrated platform that helps manage remote environments such as retail stores and branch offices. It is a key component of the
Message-level declarative security using WSE 3.0
(Pietros Ghebremicael) Web Services Enhancement version 3.0 (WSE 3.0) is a SOAP extension managed API (Microsoft.Web.Services3.dll) compatible with the .Net Framework 2.0; it ships with a design time tool (WSE Settings 3.0) that fully integrates with Visual Studio 2005. WSE 3.0 simplifies the creati
Utilities to maintain a surrogate key architecture
(Brian Walker) This article offers some additional commentary about the use of SQL Server IDENTITY values as surrogate keys. I will describe several utility routines to help maintain a surrogate key database. I will also provide six stored procedures to implement the utility functionality. (R)
SAP vs. Oracle: Users speak out
(Robert Westervelt and Mark Brunelli) The ongoing fight for business applications supremacy between Oracle Corp. and SAP has technology professionals taking sides. (R)
Ten of the Biggest Mistakes Developers Make With Databases
(Mike Gunderloy) Although fashions come and go in software development, some things stay remarkably constant. One of these is the use of databases. You may be wonderfully up-to-date with an AJAX Web interface or the latest whizbang Windows user interface, but under the covers, you’re probably still