Uses dynamic SQL to automatically create XML documents from a SQL query. Based on the same technology as WebDB, DBXML
the package we developed earlier to a single procedure call.
A PL/SQL implementation of the Document Object Model (DOM, the model used to create document trees) API that allows you to create, parse, and search XML documents.
Generates formatting instructions called
that control how the browser
an XML document.
You can download the PLSXML and its full documentation (it's
section, we'll look at a product that takes full advantage of XML.
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.
's Internet File System (
FS) has a built-in XML parser you can use to store XML documents directly in the database. As more and more
(including Microsoft, a big proponent of the XML standard) "XML-enable" their products, the
FS parser will become more and more useful. Widespread adoption of the XML format, as opposed to proprietary formats, will help alleviate the common, frustrating, and usually contentious problem of importing data from end
productivity tools into relational databases.
For instance, take spreadsheets. There is no
the fact that these wonderful tools can help even the most unsophisticated (at least in terms of computer experience) user perform meaningful and important
. An analyst might use a spreadsheet to solve a finance problem, a manager might use one to schedule the phases of a project, and an
might use one to do almost anything. Some companies even use spreadsheets to create client invoices. Because they are easy to use and widely available, spreadsheets have become primary business tools, perhaps second only to word processors. While spreadsheets have many benefits, however, they have also created difficult information management problems.
For example, companies have spent millions of dollars on relational databases only to see them circumvented by spreadsheets. End users complain, sometimes quite correctly, that systems developed by IS are too complex or time consuming. Consequently, users simply create their own offline versions out of a ragtag collection of spreadsheets. As a result, the critical business information these database systems are designed to collect is strewn
throughout hundreds of spreadsheets on dozens of machines. This data is decentralized, unanalyzed, and
To remedy this problem, many companies try to force users to adopt standards. However, as
who has worked in IS
, there are few issues that stir up more controversy than trying to replace a tool users like, such as a spreadsheet, with one that they don't like, such as a database. Any attempt to do so usually winds up in an "us versus them" battle. End users see IS taking away the tools they need to do their job, and IS sees end users wasting
company resources (time, money,
, etc.) by refusing to even consider the benefits of different approaches. In most cases, IS is on the losing end of these political
FS can help eliminate this problem. Once productivity tool vendors adopt XML (many of them are doing this as
as possible), you can use
FS to simply import the relevant portions of the documents directly into the database. Users can use their favorite tools, or at least new versions of these favorites, and you can treat their data as standard relational data. As Humphrey Bogart said at the end of
, "This could be the start of a beautiful friendship."