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
Author: SSWUG Research
Tip: Convert Excel data to XML
(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
SQL users: Microsoft must do more on security
(Marc L. Songini) Microsoft Corp appears to be trying to make the security of its SQL Server database more watertight, but it still has a ways to go, according to users. That was the message from SQL Server database administrators here at the Professional Association for SQL Server Community Sum
Using TIMESTAMP Columns Versus DATE and TIME Columns
(Craig S. Mullins) A frequent requirement of applications is to store date and time information in the of a DB2 table. The date and time data may be required for any number of reasons, such as: –To record the date and time the row was added to the table –To act as the primary key for the row
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
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.
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
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.
Taking Up Collections
During its lifetime, Oracle PL/SQL has become faster, easier to use, and richer in its feature set. Oracle Database 10g continues this PL/SQL tradition of speed, ease, and feature growth by offering a useful array of enhancements, including: –Dramatically faster excution speed, thanks to transp
How to Build a Metadata Bridge for DB2 Cube Views
(John Poelman) The target audience for this article are technical managers and staff who are interested in developing or integrating OLAP applications on top of IBM® DB2® Universal Database™ V8 (UDB) using the DB2 Cube Views application programming interface (API). The information is especially rele