(Rick Grehan) A typical PDA’s limited memory, storage, and computing power might tempt one to conclude that such devices can’t accommodate databases beyond elementary phone and to-do lists. But as PDA power improves, higher mobile-database-tools will evolve. One recent and welcome entry is IBM’s
Other News
Put XHTML 1.0 Strict and Transitional to work
(Shawn Morton) As its name suggests, XHTML—which is considered the successor to HTML 4—is a combination of HTML and XML. By combining the power of XML and HTML, XHTML makes Web content more accessible to devices such as phones, handhelds, and televisions. XHTML 1.0 is broken up into what the W3C ref
Log4plsql: Open-Source Tool for PL/SQL Logging
(Guillaume Moulard) The implementation of logs is a significant element in development strategy: exhaustive yet concise logs are required to enable code debugging and the tracing of functional events. At the same time, however, in this era of diminishing resources it is necessary to minimize the wor
Slammer lessons remain valid a year later
(Mia Shopis) This weekend marks the one-year anniversary of the SQL Slammer worm outbreak that brought down critical applications and services, including ATMs, emergency services, networks and even some airline services. Slammer broke shortly after midnight Jan. 25, 2003, exploiting a security flaw
Transferring SQL Server Statistics From One Database to Another
(Joe Chang) Many production databases today are in the tens or hundreds of gigabytes in size. That size is not a problem for production hardware. However, developers generally like to work on their personal computers, including notebooks with limited disk capacity, so a 10-100GB database size is an
XAML – Putting XML to Work
(Mahesh Chand) XAML becoming a new HOT wave in Microsoft Windows Longhorn programming model. XAML syntactically inherited from XML is a scripting programming language used to write applications that covers both Windows and Web worlds. Microsoft is well-known and a proven expert in evolving new t
Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2
(Bishwaranjan Bhattacharjee, Sriram Padmanabhan, Timothy Malkemus, Tony Lai, Leslie Cranston and Matthew Huras) IBM’s DB2 Universal Database version 8 for Unix, Windows, and open platforms introduces a new feature called Multi-Dimensional Clustering (MDC). Multi-Dimensional Clustering provides a fl
Why Convert Documents into XML?
(Rizwan Virk) XML has become a buzzword that’s so over-used that it’s difficult to understand when it might and when it might not be appropriate. In general, the main reason for XML’s popularity is that it provides an underlying technology that gives “portability” of information across platforms,
Safety in Numbers
(Shari Caudron) Every hour of every day, in countries all around the world, people work in hazardous environments. They dive deep below the surface of the ocean on salvage expeditions. They descend into mines, clean toxic waste, and fight fires—or try to prevent them. These people know their jobs ar
Cloning a Oracle Database
Cloning a database means creating an identical copy of a database, either on the same machine as the original, or on a different one. Additonally, it means changing the database name, and the Instance name. But those are both optional steps if the clone is being created on a different machine. Ev