(John E. Simpson) As I explained last month, in my final XML Q&A column, my new monthly column will focus on the ways people use XML. The XML ocean is a big one, populated with a good number of whales (EDI, web services, RDF, and so on). But there are also plenty of pilot fish and guppies swimming a
Other News
Finding size of Table/Indexes in SQL Server 2005
(Vinod Kumar) This is an question that came up in the newsgroups to how fo we find the size of tables and indexes in the new version of SQL Server 2005. The solution to the same was using some of the DMVs (Dynamic Management Views) that have statistical information of objects. And for this case we u
RPG and DB2: The Future Is Now
(Joe Pluta) There has been much discussion recently of the demise of RPG and native DB2 and even of the IBM midrange itself. RPG’s detractors point to everything from the high number of Java programmers graduating from school to the infamous burger flipping ad to IBM’s Developer Roadmap, which h
Special Report: Inside IBM’s software plans
(Michael W. Bucken and Jack Vaughan) The IT industry is at the crossroads again. Yet some things are familiar. No one knows what “next big thing” is lurking around the corner, and corporate buyers are more selective than ever — but Big Blue is the player ahead on most lists. If it is not growin
SQL/XML Tutorial: SQL/XML, Xquery, and Native XML Programming Languages
Most web applications have connections to databases and use XML to transfer data from the database to the web application and vice versa. Every major database vendor has proprietary extensions for using XML with relational databases, but they take completely different approaches, and there is no int
PHP Database Programming with DB2
(Ian Hopkins) In the world of industry database management, there are three major players: IBM DB2, Microsoft SQL Server and Oracle. There is a lot of literature about using both Microsoft and Oracle’s products, but information on using DB2 specifically with PHP was difficult to find. I develope
SVG’s XML Binding Language (sXBL)
This working draft describes SVG’s XML Binding Language (sXBL). sXBL is a mechanism for defining the presentation and interactive behavior of elements described in a namespace other than SVG’s. sXBL is intended to be used to enable XML vocabularies (tag sets) to be implemented in terms of SVG ele
The Oracle 10g Scheduler, Part 1: Overview
(Jim Czuprynski) Oracle 10g’s new DBMS_SCHEDULER package offers significant improvements over DBMS_JOB for scheduling jobs and tasks. This article – the first in a series – provides an overview of the new functionalities that the Oracle Scheduler provides for DBAs.
SQL Server Log Shipping
(Baya Pavliashvili) Log shipping is one of the failover solutions offered by SQL Server 2000. In this context, failover means substituting primary server with a backup (sometimes also referred to as standby) server if the primary hardware becomes unusable. Failover solutions can also be used to prov
Using XSLT on Bioinformatic XML Data
(Philip Burton, Russel Bruhn and Gary A. Thompson) For the biologist, the bioinformatic analysis of genes requires the compilation of tables of gene characteristics. To do this, data is often taken manually out of databases in an ad hoc fashion. Different databases (TIGR, MIPS, BLAIR, and NCBI, for