A new XML standard is being proposed that will enable the Homeland Security Department to communicate with various governmental agencies. EDXL, it is argued, is needed today since individual XML schemas continue to evolve, without any standardized framework ensuring their compatibility.
Other News
DB2 II: Performance Monitoring, Tuning and Capacity Planning Guide
(Nagraj Alur) This IBM Redbook provides an overview of DB2 Information Integrator V8.2 key performance drivers; best practices to achieve optimal performance; and guidelines for monitoring a DB2 Information Integrator environment for capacity planning, problem diagnosis, and problem resolution.
SOAP’s Alive: Try the New Native SOAP Extensions for PHP
(Laurence Moroney) In the world of Web development, two technologies have been very, very hot. These are Web services and PHP. The former because they allow big companies with big applications and big ideas to integrate easily; the latter because it is free, easy to use, and easy to learn. Their pat
Cursors with SQL 2000 Part 2
(Don Schlichting) This is the second article in the Cursors with SQL 2000 series. In the preceding article, cursor use and basic syntax were covered. A select cursor was created demonstrating the keywords DECLARE, OPEN, FETCH, @@FETCH_STATUS, and DEALLOCATE. These keywords guide basic cursor executi
Hacking iTunes
(Niel Bornstein) The iTunes music player and download service took the world by storm in 2003 and 2004, and promises to continue its popularity for the forseeable future. While the music is stored in simple files on disk, metadata — information about the music — is stored in a single XML file.
Using Virtual Private Database in an Oracle HTML DB Application
(Scott Spendolini, Sergio Leunissen and David Knox) Securing an application begins with applying proper access control rules at the database level. One of the ways the Oracle Database helps you implement access control rules is through Fine Grained Access (FGA) control or Virtual Private Database (V
Using PL/SQL from .NET (Sample Chapter)
(Mark Williams) In a sense, this chapter represents a slight shift in focus from the previous chapters; here, you step out of the .NET environment, to a degree, and delve more deeply into the database itself. The capabilities afforded by Oracle PL/SQL are often overlooked, especially when you’re us
Predictable Oracle applications tuning, part 1
(David Welch) We’ve been exposed to a good number of Oracle Applications / E-Business Suite installations with significant performance challenges. We have come to the conclusion that a significant improvement in performance improvements can indeed be expected from such installations. To state it dif
Managing Engineering Information
(Chris Randles) It’s virtually axiomatic: technology innovations first boost personal productivity then group productivity. The PC, for example, first helped individuals automate writing, accounting and personal organization functions, then spawned group productivity through networks, the Internet a
Accumulating Aggregations
(Itzik Ben-Gan) A data warehouse contains data that has been aggregated for data analysis. You aggregate measures (such as quantities and amounts) for different entities (such as employees, customers, and products). You also determine the time units (e.g., day, month, year) for the aggregations