(Brian Benz) According to an August 2003 IDC report, the XML server market grew 163.8% between 2000 and 2003. IDC also estimates that the market for XML servers, which includes XML-enabled databases, native XML database servers, XML application servers and XML content servers, will exceed $3.5 billi
Other News
XML Data-Binding Powers Up in ASP.NET 2.0
(Thiru Thangarathinam) XML data is generally used to represent semi-structured or hierarchal data. Using XML documents as your data source allows you to receive XML documents from other sources and format the XML data to be compatible with your application. ASP.NET 1.0 let you use XML data sources,
Applying Distributed XML to The Open Source Paradigm Shift
(Steve Mallett) Tim O’Reilly has written and spoken often on what he coins “The Open Source Paradigm Shift”. I’ve heard Tim give this speech a few times, and read it a few to boot. The one major point that sticks with me is that the software we “use” is no longer just on your desktop/laptop, but
Part 1: Simplify performance management and tuning with DB2 Performance Expert
(Werner Schuetz) DB2 Performance Expert is a tool for monitoring, analyzing, and tuning the performance of DB2 Universal Database (DB2 UDB) and its applications. Part 1 of this article introduces the tool and covers its basic functions. Part 2 walks you through some practical scenarios so you can se
Oracle9i Analytic SQL Features, Part 1
(Brad Cowdrey) This is a series of articles on the SQL analytic features of Oracle9i. At first glance, they seem foreign and overly complex; however, once the features are demystified, they become very powerful tools in the business intelligence and reporting environments. Part 1 explores the rollup
Unicode Performance in DB2 for z/OS
(Jeffrey Berger and Kyoko Amano) DB2 for OS/390 and z/OS supports three types of encoding schemes: EBCDIC, ASCII and UNICODE. Traditionally IBM mainframes have been based on EBCDIC, and Unix and Windows applications based on ASCII. To handle larger character sets, which are absolutely necessary in A
Another Way to Find the Wait
(Wolfgang Genser) This tip provides an alternate way to get the name of the file, segment, or resource that’s causing a wait, with times.
Optimize Your Text Retrieval
(Ron Hardman) Next to its employees, information is a company’s biggest asset. How company data is managed can provide strategic advantage or put a company at a huge disadvantage against competitors. Information retrieval (IR) focuses on accurately and efficiently managing data, turning it into usef
Back Doors with a View
(Itzik Ben-Gan) Back doors are undocumented features of an application that let you do things the application wasn’t intended to support. With this article, I conclude my series on T-SQL back doors by discussing three back doors to SQL Server views: rolling your own INFORMATION_SCHEMA views, cre
Seven Showplan Red Flags
(Joseph Sack) Do you use Query Analyzer’s Graphical Showplan, SHOWPLAN_ALL, or SHOWPLAN_TEXT to performance tune your query statements? Most DBAs use one or all of these tools for troubleshooting query performance. But what do most DBAs look for when they examine the query execution plan results