“The world has gone crazy with XML and then Web services,” writes Sun’s senior IT architect Victoria Livschitz, in an article currently to be found on the official Sun Web site.
Other News
A Practical Guide to Data Warehousing in Oracle – Part 3
(Dave Aldridge) One feature that is almost ubiquitous in Oracle data warehousing is the use of the Partitioning Option. Over the past few major releases the feature set associated with partitioning has increased to cover four different partitioning types and improvements in the manageability of part
Just the Stats, Ma’am – Part 2
(Robert Catterall) A DB2 statistics report can be the key to better performance. In my previous column, I wrote about DB2 for OS/390 and z/OS monitor statistics detail reports. I ended the column after covering data set open/close activity; in this column, I pick up the story with a quick look a
Over the Top Performance
(Martin Hubel) When I speak to user groups on DB2-related topics, I pretend to confide a DB2 secret: There will be performance improvements in the next version of DB2. Since 1986, I’ve never been wrong. And DB2 Universal Database (UDB) for z/OS version 8 certainly keeps my prediction streak alive. I
XML and Web Services: Connecting Information Islands
(Kevin Migliozzi) The Web has become the world’s greatest repository of information on anything and everything. It’s extremely useful – as long as you can find what you’re looking for.
How to export all tables in a database
(Darren Green) This is a very short article as it is really a demonstration of concepts explained elsewhere, although quite a useful implementation in it’s own right. The export itself is done with the Bulk Export Task, and this is wrapped in a recordset driven loop as covered in the article How to
UDM: The Best of Both Worlds
(Paul Sanders) The next release of Analysis Services, coming in SQL Server Yukon, will combine the best aspects of traditional OLAP-based analysis and relational reporting into one dimensional model—the Unified Dimensional Model (UDM)—that covers both sets of needs. Compared to direct access of a re
DB2 ASP.NET input validation with Delphi for .NET and C#Builder
(Bob Swart) This article demonstrates several ways to perform data entry input validation in ASP.NET applications on top of IBM DB2 UDB database tables.
Microsoft previews InfoPath update
(Joris Evers) Microsoft Corp. is giving users a chance to test enhancements to its InfoPath XML forms manager. Microsoft plans to deliver those enhancements as part of Service Pack 1 (SP1) for its Office 2003 products in late June.
A Lookup Strategy Defined
(David Sumlin) Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. (I’ll use these two terms interchangeably) These tables are those small tables that you maintain your list of States, or CustomerTypes or JobStatus or any number of valid domain values