(Dennis Sosnoski) XML is a text markup format designed for clarity and ease of use, without concern for conciseness. Because of these design choices, text XML can be costly in terms of both document size and processing overhead. Part 1 of this two-part article shows you some of the issues involv
Other News
Putting ISBNs to Work
(Kendall Grant Clark) In this and next month’s column, I’m going to design and implement just such a tool in Python, isbn2lccn. More specifically, in this column I’ll look at ISBNs, including how we might use ISBNs in RDF, and consider some of the sources of bibliographic information available on th
Automatically Create All Missing Synonyms in an Oracle Database
Synonyms are used in place of schema objects in professional database applications because the application user is typically different from the object owner schema. The script below creates synonyms for all the relevant objects in your schema—if they dont exist automatically. This saves you from
Surviving a Database Disaster with RMAN Backups
(Siva Muthuraman) When we were in the process of implementing RMAN backups for our databases, we felt that there were not many articles or real stories on how someone survived a real disaster. This article walks through a real disaster we recently had in our company and how we survived it using
Control of Flow with TSQL
(Don Schlichting) Transact SQL statements are usually executed in sequential order. When a long stored procedure or statement is created, line 1 will run, followed by line 2, followed by line 3. In many cases, we will want to interrupt this normal flow. Special processing may be needed depending
More scripting with DB2 UDB for Windows
(Chris Fierros) This article is the third in a series of articles covering the topic of IBM DB2 Universal Database (UDB) and Windows scripting. In this article we continue to explore in detail more scripting options including Object REXX and PerlScript with Windows Script Host (WSH) and DB2 UDB V8 f
SQL Server 2000 Windows CE Edition frequently asked questions
Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) is the compact database for rapidly developing applications that extend enterprise data management capabilities to devices. This article discusses questions and answers for frequently asked questions (FAQs) about SQL Server 2000 Windows
Automated Standby for SQL Servers
Today’s business critical applications and customer requirements demand high-availability of company data. Database Administrators (DBAs) are challenged to make the database systems available 24×7 and provide fast database response time. Utilizing a standby server provides a high level of data prote
DB2’s Virtual Time
(Marin Komadina) The time problem occupied my attention, during a recent recovery situation. On the SUN Solaris machine, the system time jumped forward unexpectedly. This situation raised questions about system and database time interaction, the time drift influence on the backup and recovery and ma
More Investors Think Oracle Will Win
(Michael Liedtke) It’s still early, but some investors already are betting that Oracle Corp. will prevail in an antitrust trial contesting its $7.7 billion bid for rival business software maker PeopleSoft Inc.