(Moira Casey) PHP (PHP:Hypertext Processor) is an open source scripting language for building Web pages. With PHP and Open Database Connectivity (ODBC) you can dynamically generate Web pages from data stored in IBM Cloudscape and Apache Derby databases. In this paper, determine how to install and co
Other News
What Color is Your Schema?
(Bogdan Blaszczak) There is no doubt that the World Wide Web Consortium (W3C) XML Schemas enjoy quite a success. They are used in many major software environments and are applied to many domains, from finance to the Search for Extra Terrestrial Intelligence (SETI).
How to Misuse SQL’s FROM Clause
(Stéphane Faroult) FROM what? It may seem surprising to state it so, but the FROM clause of SQL statements seems to be one of the most often misused parts of SQL queries. Misused? How is that possible? We put into the FROM clause all the tables to join together in a query, don’t we? Well, well
Web Analytics Using Oracle Application Server Discoverer
(Timothy Cambier and Brian Carr) If you are responsible for managing your company’s website or administrating the web servers on which it reside, then you are most likely reporting site usage statistics to management. Analyzing the information found in the log files generated from your web serve
Gathering Space Usage Statistics
(Gregory A. Larsen) As a DBA, you will need to perform a number of different tasks to keep your databases and servers up and running. One of those DBA tasks you will need to perform is disk space capacity planning. You need to make sure there is enough disk space, so when one of your databases n
Lady and the Tramp
(Edd Dumbill) This week’s XML Deviant is a tale of two specifications. One, a scruffy ragtag affair that barely seems to do the job. The other, a well-heeled, aristocratic sort of document, groomed for longevity. You know what’s coming next, of course. The tramp of which I speak, the unlikely RSS, g
INF: MDX: How to Test for the Top Most Level in a Hierarchy
When you traverse a dimension through a Multidimensional Expressions (MDX), you may have to determine if you are at the top most level of the hierarchy. This article shows you four MDX expressions that allow you to find out if you are at the top most level of the hierarchy.
Using a full-text search engine as a driver for native XML databases
(Dr. Hans Henseler) Native XML databases can be used to store XML document collections. Documents can be retrieved from such a database if their filepath is known. To enable contentbased document retrievel, each document should be loaded in an XML parser to check if the contents meet the specified
Writing Better SQL Using Regular Expressions
(Alice Rischert) A new feature of Oracle Database 10g vastly improves your ability to search and manipulate character data. This feature, regular expressions, is a notation for describing textual patterns. It has long been available in many programming languages and a number of UNIX utilities.
Database Normalization for the Real World
(April Wells) Why is normalization important? Many databases today are still denormalized for many reasons. This article, by April Wells, addresses some of the reasons and normalizes a claim table through the different normal forms for an insurance company. The changes in the table and the addit