(Kevin Conlon) Use of parallel operations with Oracle Database is well known, with the feature first having arrived in version 7.1. The ability to execute SQL statements in parallel on traditional UNIX-based symmetric multiprocessor (SMP) architectures greatly increased utilization of the server
Other News
Taming The Wild West, Part 1
(Michael Dougherty) Using Web content management can marshal Web sites, intranets, and portals into a force for productivity Behind every successful portal is a Web content management (WCM) system. Yet — even in the IT world — few realize the advantages of combining portals and Web content manage
IBM DB2 Data Archiving Clinic: Put Your Data In It’s Place! Learn ways to manage inactive DB2 data
Do you have inactive data you can’t live without–but your database has a hard time living with? Want tips on how to archive that inactive data to improve performance and reduce I/O processing? Join IBM’s Rajesh Ramachandran, lead developer of DB2 Data Archive Expert, for an exploration of data
Validate Inside Your Program with Schemas
(Elliotte Rusty Harold) Rigorously testing preconditions is an important characteristic of robust, reliable software. Schemas make it very easy to define the preconditions for XML documents you parse and the postconditions for XML documents you write. Even if the document itself does not have a sche
The Best of Both Worlds: Combining XPath with the XmlReader
(Dare Obasanjo and Howard Hao) This article discusses the XPathReader, which provides the ability to filter and process large XML documents in an efficient manner using an XPath-aware XmlReader. With the XPathReader, one can sequentially process a large document and extract an identified sub-tree m
Using ASP and XMLHTTP to Talk to Authorize.Net
(Dan Hounshell) Recently I found myself putting together an Authorize.Net implementation for a client. For those who do not know, Authorize.Net is a payment processing gateway similar to Verisign’s Payflow Pro or the almost completely departed CyberCash’s CashRegister. Authorize.Net offers sever
MDX Essentials: Basic Set Functions: Subset Functions: The Head() Function
(William Pearson) In this lesson, we will begin a “triptych” of articles that expose set functions that deal specifically with subsets – that is, each function returns a subset of a larger set as part of its operation. We will introduce the Head() function in this article, then follow it with th
DB2 Operation: The Challenge to Provide 24×365 Availability
Talk to the database administration group in any major corporation these days, and you’ll experience an atmosphere of controlled chaos as DBAs scramble to address a variety of needs ranging from the design of new applications to keeping business-critical applications operational. As more busines
5 Steps to customize the SAP Data Retention Tool for DB2 CommonStore
(Stephan C. Kammerer) The SAP Data Retention Tool (DaRT) is used to help meet legal requirements for data retention and reporting. Learn how to customize this tool to run with IBM DB2 CommonStore for SAP and DB2 Content Manager.
Transferring Operating System Files from within Oracle
(James Koopmann) Within Oracle 10g we are given the opportunity to move operating system files without ever ‘physically’ logging into the operating system itself. This in itself provides us, as DBAs, many options when doing common database administrative tasks that we will typically do. These tasks