(Benoit Marchal) Contrary to what you might think, not every document is initially written in XML. Actually, most documents are prepared with some other tool and later converted to XML. Many documents originate from relational databases such as DB2, or from Microsoft Office applications such as Word
Other News
Outer Join with Oracle SQL
A "normal" join finds values of two tables that are in a relation to each other. In most cases, this relation is equality (=), but it can also be all sorts of operations that either return true or false. The important thing is that a "normal" join only returns rows of both tables of which the compar
Take a Load Off: Archive Inactive Data
(Bryan F. Smith and Thomas A. Vogel) A data explosion threatens to bog down, fill up, slow, and generally complicate DBMSs. Archiving data that’s rarely accessed lets businesses hold on to the data they need while keeping DB2 performing at top speed.
From XML to DML the Java Way
(Rajendra Pande) With XML (eXtensible Markup Language) rapidly becoming a standard way to describe and transfer data on the Web—especially in B2B transactions—applications that can read XML data and incorporate it in a database are becoming more and more important. When your applications can handle
Yukon Getting Data Warehousing Overhaul
(Scott Bekker) The next version of Microsoft SQL Server, code-named “Yukon,” will have a completely rebuilt engine for extraction, transformation and loading of data from one source to another — a key element of data warehousing and business intelligence operations.
Connecting with Oracle: Finding and Setting a Configuration File Location
(Steve Callan) Last month’s “Connecting with Oracle” article dealt with properly configuring the tnsnames.ora file. Using a statistics-related analogy for a minute, you can have Type I and Type II errors with respect to your tnsnames.ora file. You can have a “good” tnsnames.ora file, but “reject” it
Replication Agent zaps for DB2 Versions 10.5
The Following four zaps should be applied to all versions of the Replication Agent for DB2 Versions 10.5 and below: (PDR10008) Abends0c9/abends0c4 in DRL@LOGX when trying to bring the PLATINUM Replication Extract back up after a DB2 crash. After a DB2 crash followed by a normal restart, DB2 w
Creating UNIQUE and PRIMARY KEY Constraints on Computed Columns
In SQL Server, the physical mechanism that UNIQUE and PRIMARY KEY constraints use to enforce uniqueness is a unique index. Because SQL Server 2000 supports indexes on computed columns, you can create UNIQUE and PRIMARY KEY constraints on computed columns.
XForms Building Blocks
(Micah Dubinko) Despite the name, XForms is being used for many applications beyond simple forms. In particular, creating and editing XML-based documents is a good fit for the technology. A key advantage of XML-based documents over, say, paper or word processor templates, is that an entirely elec
Tip: Output large XML documents, Part 2
(Brett McLaughlin) This tip begins to detail ways to handle large XML documents. You will learn what an XMLFilter is, and how it builds upon the core SAX API to offer advanced data filtering. This is the first piece in the puzzle of handling large datasets, allowing you to extract only relevant data