(Boris Milrud) Perform the massive DELETE operation as a swap delete with parallel execution. This technique can offer significant performance gains over a straight or in-place delete operation.
Other News
Oracle’s Customer Crusade
(Charles Babcock) The struggle for the hearts, minds, and business of PeopleSoft’s vast installed base of customers is on.
Source Control: A Primer
(Scott) On April 30, 1999 U.S. taxpayers lost over 1.2 billion dollars due to a small mistake in software configuration management. It was on this day that a Titan IVB rocket was scheduled to put the U.S. Air Force’s most advanced communication satellite into orbit. The Titan rocket track record inc
Extreme Availability with IBM WebSphere and DB2
David W. Coleman and Charles F. Bowman) Availability has always been a key measure for IT infrastructures. Unfortunately, achieving high availability is quite difficult. Complicating any effort to attain high availability is that there is usually no simple stopping point — in almost all cases there
The Python comunity has too many deceptive XML benchmarks
(Uche Ogbuji) The Python/XML community has an unfortunately long tradition of dodgy benchmarks. I had a lot to say about probably the most egregious example in my article on PyRXP. PyRXP is called an XML parser, and its developers benchmark it as such against other Python/XML parsers. The problem is
Is IBM a BI vendor?
(Philip Howard) IBM, and especially the DB2 group, is referring to itself as a business intelligence vendor. How realistic is this and, even if it is realistic, how much will it take to persuade the market to think of IBM in this way?
The Integration of Unstructured Data into a Business Intelligence System
(William N. McCrosky) This article discusses the challenges of merging unstructured data into BI systems and provides an example of such a merge to solve an organziational problem.
SQL Server 2005 Part 1 – Security (Authentication)
(Marcin Policht) In this installment of our series covering new and improved functionality of SQL Server 2005 Beta 2, we will focus on the topic of security, which has been becoming increasingly prominent among the issues on every database and system administrator’s agenda. A new approach to softwar
An early look at sXBL
(Elliotte Rusty Harold) SVG’s XML Binding Language — sXBL — is an XML vocabulary being developed at the W3C as a means of mapping XML elements in arbitrary vocabularies to SVG pictures that represent those elements. For example, an XML Metadata Interchange (XMI) document can be turned into SVG cod
Exchanging XML with SQL Server 2000 and Reporting Services through the Web and Web Services
(Venkat Prasad) This article discusses some programming techniques for saving XML data from Microsoft SQL Servers, Web Servers, XML Web Services, and Microsoft SQL Reporting Servers. Topics include a comparison of traditional techniques used for saving XML streams, using ASP/ASPX and COM, with newer