(Mark Johnson) Jon Bosak, considered by many to be “the father of XML,” remains one of XML’s guiding lights. In this interview with JavaOne Today reporter and JavaWorld XML columnist Mark Johnson, Bosak expresses his hopes and concerns about the future of XML, discusses his views on the creation of
Other News
Introduction to Oracle Index Tuning Wizard
The Oracle Index Tuning wizard is a software application that identifies tables with inefficient indexes and makes recommendations which will improve access to those tables. The Index Tuning wizard: –Identifies tables in need of index changes –Presents its findings in reports –Implement
Getting started with DB2 application tuning
(John Irwin) This article looks into some of the steps necessary to locate and tune DB2 application performance problems. It will: –Discuss the tools and structures needed for DB2 tuning. –Address the identification of DB2 performance problems, and the initial reports and processes used for t
SQL Server 2000 DTS Part 10 – DTS Designer Tasks – The Data Driven Query Task
(Marcin Policht) In the arsenal of DTS Designer Tasks, the one that leads in terms of versatility (and complexity) is the Data Driven Query Task. Its most distinctive feature, distancing it from other tasks, is its ability to not only handle inserts of rows during transformation, but also process an
IBM DB2 Content Manager V8 Implementation on DB2 Universal Database: A Primer
(Kenneth Chen, Peter He, Tawei Hu, Ed Gallagher) The inevitability of e-business is a reality. Today, as e-business evolves, it is more than Websites that offer e-Commerce transactions. Instead it represents an entire business process transformation, from back office to front office, requiring not o
Face-off: Oracle vs. SQL Server
(Robyn Lorusso and Tim DiChiara) Can a SQL Server fan be converted to Oracle DBMS? Not easily. The loyalty which database administrators feel for their database vendor borders on the fanatical. It’s a love-hate relationship, where only those using Oracle, for example, are allowed to complain about O
Tutorial: About the Simple XML Based Content Management Application
The Simple XML Based Content Management Application (referred to as CMSXDB from here on) provides users with an easy to use interface to interact with the Oracle XML DB Repository and perform various content management operations. This tutorial gives an overview of the CMSXDB, describes how to insta
Review of Lumigent Entegra
(Haidong Ji) In a nutshell, Entegra is a SQL Server auditing tool without triggers. If you have sensitive data, such as personnel information, salary data, etc, and you want to keep an audit trail of changes to those data (DML statements, such as INSERT, UPDATE, and DELETE), in many cases, you will
DB2’s DATE data type
(Peter Gulutzan and Trudy Pelzer) This article describes how IBM implemented the DATE data type for DB2 and discusses what calendar is used, what the JULIAN_DAY function really does, why date arithmetic is random, how to calculate birthdays, and how to find month ends using DB2. (R)
START WITH and CONNECT BY in Oracle SQL
The start with connect by clause can be used to select data that has a hierarchical relationship (usually some sort of parent->child (boss->employee or thing->parts). It is also being used when an sql execution plan is explained.