In IBM Data Warehousing, Michael Gonzales shows how to exploit IBM technologies — including everything from SMP and MPP technical architectures to DB2 UDB and DB2 OLAP Server — to get the most from data warehouse investments.
Other News
Automating ETL Using Oracle Warehouse Builder – Part 1
Prototyping is one of the best-suggested approaches in mitigating the adverse effects of unforeseen problems in the data warehouse development cycle. In this series, Nandeep Nagarkar focuses on prototyping the ETL stage of the data warehouse life cycle using Oracle WareHouse Builder.
Generating ALPHANUMERIC Sequence Using Decode
by Biswabijay Bhattacharya – Referring to Tip of the Week from 05/11/2003 by Romer L. Vinuya, here is another way to write the same trigger with less coding and also handle exceptions.
A Different Setup
By Itzik Ben-Gan – When your query needs to find items with certain relationships, you can use relational division, or you can try these new tricks.
IBM Takes On Microsoft: Smaller Businesses Win
By Paul McDougall – Companies gain more choices to help them build adaptive, real-time infrastructures.
Shaping Relational Data with XSLT and .NET
Although XML continues to gain popularity throughout the world, companies still store much of their data in relational databases. This can present a problem when the relational data needs to be converted into a hierarchical structure in order to be used in an application. Several different technique
Searching an XML File with XSL and ASP
by Michael Qualls – This article is the final installment in a series of articles on manipulating XML data with ASP. So far we have learned to add, append, and edit records in XML files using ASP. This article puts on the finishing touches in order to tie all of these processes together.
Jing gets Schematron, W3C XML Schema, enhanced namespace support
James Clark has released a new version of his Jing validator for Relax NG, adding support for validating document instances against Schematron and W3C XML schemas, and also implementing support for the Namespace Routing Language (NRL).
Is a Temporary Table Really Necessary?
You will find articles on this site as well as others advising you to avoid the use of temporary tables to maximize the performance of your queries. I agree with the articles, but would like to add that sometimes you cannot avoid the use of a temporary table.
Importing and Indexing Microsoft Word Documents Using SQL Server
Q. I want to import Microsoft Word documents into SQL Server and then index the documents so I can use them in relational queries. How can I import and index the documents? A. SQL Server allows you to import Word documents in several ways. Let’s look at the most common methods.