by Anunaya Shrivastava and Steve Bobrowski – In my experience working with legacy systems, tables often store redundant data due to limitations in the system’s data model. For example, consider a file in a legacy system that stores information about the collector’s call history associated with a par
Other News
Finding the Database OS and OS Version with Java
This tip comes from Krishna Sarabu – The following script helps you to find out the current database’s operating system & its version using java stored function(s).
XML database doubts
By Timothy Dyck – As XML becomes an increasingly important data interchange format, it makes sense to look at new ways of storing information directly in XML and using XML-based tools for data query and manipulation. However, what those tools will look like is still very much up in the air.
Fat protocols slow Web services
Last time around, I told you that if you wanted to support Web services you could look forward to upgrading your old servers and adding new ones. And, indeed, that will go a long way to making Web services fast enough to keep your users happy. But that's only part of the story.
An Introduction to the XML:DB API
by Kimbro Staken – In my last article, Introduction to dbXML, I provided an example that used the XML:DB API to access the dbXML server. This time around we'll take a more detailed look at the XML:DB API in order to get a better feel for what the API is about and how it can help you build applic
Power Partitioning Made Easy
By Eric Yen – Oracle9i’s new list-partitioning feature lets you organize large data sets more naturally, usefully, and easily.So, let’s step through our examples and get going. You can simply read along, or—if you have Oracle9i up and running and your user account has Create Table privileges
Don’t Let Referential Integrity Degrade Your Database Performance
By Boris Milrud – Oracle databases provide a powerful mechanism for enforcing business rules, called referential integrity (RI), which is implemented either via a declaration of foreign key (FK) constraints (“declarative RI”) or via triggers. It is almost impossible to find an Oracle database with n
Populating an HTML Template with XML Data
By Yehuda Shiran – To convert an XML file to HTML, you start by writing the skeleton of the HTML file, specifying all tags such as <BODY> and <H1>. The content between each pair of tags is selected by XML directives. Take a look at the following line:
Compiling the paths and automating tests
By Benoit Marchal – Work on HC, the SAX ContentHandler compiler, continues. This month, our columnist discusses the compilation algorithm. He also invests a bit of time automating tests with JUnit.
The Euro-Savvy Database
By Gilles Briard – Oracle has made sure to adhere closely to ISO (International Standards Organization) standards regarding the Euro character, so Oracle customers can rest assured that database versions released since the standards were set (8.1 and above) can handle the Euro character properly. Ho