(Edd Dumbill) In this week’s column, I cover two debates that consider the cost of XML. In the first discussion, the cost is that of file size and processing overhead. In the second, it’s actual dollars charged for access to a web service. Also, watch out for the special twilight zone moment as we f
Other News
Navicat Review
(Blane Warrene) MySQL has become one of the central benchmarks for open source software that has crossed the bridge from exploratory to serious corporate player. During that time period, not only has an entire cottage industry of MySQL-related tools and services emerged, but several top-tier, commer
J.C. Whitney updates order management system
(Linda Rosencrance) J.C. Whitney Inc., one of the nation’s largest direct marketers of automotive accessories and parts, has chosen a retail system created jointly by IBM and CommercialWare Inc. to replace a 35-year-old homegrown system that could no longer effectively connect customer orders with i
Experiences with Oracle 10g Database on Linux for zSeries
(Kathryn Arrell, Dennis Dutcavich, Bruce Frank, Ollie Jones, Tom Russell and Barton Robinson) This IBM Redbook describes experiences gained while installing and testing Oracle10g for Linux on zSeries, such as: – Setting up the development systems at Oracle for the Linux on zSeries environment
Add RSS feeds to your Web site with Perl XML::RSS
You’ve probably already heard of RSS, the XML-based format which allows Web sites to publish and syndicate the latest content on their site to all interested parties. RSS is a boon to the lazy Webmaster, because (s)he no longer has to manually update his or her Web site with new content.
Data Warehouse Design Best Practices, Part 3
(Shimant Das) Design has always been the single most important and contentious phase in any software development program and, hence, attracts the maximum number of arguments and debates. In data warehousing projects, it is even more so. Unlike other typical software development projects, data wareho
Creating Cross Tab Queries in SQL Server
(Michael Schmalz) Before I started using Microsoft Access heavily, I did analysis work with PivotTables in Excel. Moving over to Microsoft Access, I found that using cross tab queries allowed me to do similar work but not to the same degree of detail. When I made the next leap to SQL Server, I w
Custom String Functions
(Chris Cathers) When I got done reading Stephen Lasham’s article Extracting a String Within Delimiters – Part 2, I thought that I would share with the community, some functions I had just written a couple weeks earlier. I have found that I do a lot of string parsing where I work. It turns out that I
Reporting Services 101
(Rick Dobson) SQL Server 2000 Reporting Services, the SQL Server-based enterprise reporting solution Microsoft released in January 2004, is positioned to become one of the most popular SQL Server components. Nearly all organizations need to produce reports from their data, and with Reporting Service
Oracle JDeveloper 10g: New Coding Features
The latest release of JDeveloper 10g offers a host of new features. This tutorial introduces some of those that are of particular interest to the Java developer: productivity improvements in the Code Editor, using CVS for team development, unit testing with JUnit, and using Apache Ant buildfiles in