(Michael M. David) This two-part article will change your view and understanding of standard SQL and its ability to integrate naturally and fully with native XML. The perceived problem with achieving full SQL-based integration of XML is that relational data is flat while XML data is hierarchical, pr
Other News
HP Readies Smart Paper Introduction
(Mark Hachman) Hewlett-Packard Co. will introduce a “smart paper” technology as a part of a forms management solution for enterprise customers. Slated for announcement at Comdex Las Vegas 2003, the HP scheme could cut forms costs by as much as a third, sources said. HP will introduce its Forms A
Best Practices in Data Archiving
(Drew Robb) Databases usually have two things in common. They have grown far larger than envisioned by their creators and they are filled with unneeded data. Many companies, therefore, are seeking to pare them down to the essentials and archive little used content. But what should you archive, how s
Introduction to Oracle Text
Oracle Text is a tool that enables you to build text query applications and document classification applications. Oracle Text provides indexing, word and theme searching, and viewing capabilities for text.
DTS Basics
Many organizations need to centralize data to improve corporate decision-making. However, their data may be stored in a variety of formats and in different locations. Data Transformation Services (DTS) addresses this vital business need by providing a set of tools that lets you extract, transform, a
Oracle SQL tricks
This page is a great collection of tips and tricks for Oracle – from online links to the user manuals to query exeucution details to how to enable constraints with locking tables and much more. This is one article not to miss!
Pass Recordsets in N-Tier Applications
(Richard Campbell) There are three popular techniques for passing multiple records from the middle-tier to the client-tier. The most common approach is the one you mention – variant arrays. Typically the array has two dimensions: The first is the field name, and the second is the value. Because the
Quick and Dirty RDBMS Tuning
(Steven Hauser) Oracle tuning. Informix tuning. DB2 tuning. PostgreSQL tuning. It doesn’t matter which database you use — RDBMS tuning is all pretty much the same, because database software is all pretty much the same these days. All major relational database systems have an engine, an optimize
DOM Vs SAX What is best?
(Ravikiran Muvva) In today’s world XML is the popular medium for exchanging data. To make use of that XML Data, it is very important for the sender and receiver to understand and manipulate data. Currently the most popular APIs available for manipulating the XML Documents are DOM and SAX. In this ar
Installing Oracle, PHP, and Apache on Linux
(Robert Clevenger) Are you ready to start using PHP to talk to an Oracle Database? Let’s walk through the steps required to install the Oracle Database, Apache HTTPD Server, and PHP as an Apache module on Linux. Check out the OTN Linux Center to see what versions of Linux are certified for use with