(Robert Westervelt) Aaron Newman is co-author of the Oracle Security Handbook and co-founder of New York-based Application Security Inc. Recently he talked with SearchDatabase.com about ways Oracle DBAs can defend themselves against trouble, and he warned that the biggest threats are often closer th
Other News
Using JavaCC to build a user friendly boolean query language
(JoAnn Brereton) JavaCC is a very powerful “compiler compiler” tool that can be used to formulate context-free grammars. This article demonstrates how JavaCC can be used to allow end users to formulate simple boolean queries against a DB2 UDB database.
The Oracle Pathologist–sample chapter
(Chris Lawson) Now that we have identified what the problem is, and have quantified it, we are ready to find the root cause. In order to accomplish this, the tuning specialist takes off the hat of the detective, and dons the hat of the pathologist. As the Oracle pathologist, the tuning specialist
XML Report from the Microsoft PDC 2003
(Aaron Skonnard) This issue marks three years of The XML Files. As I reminisce over my personal XML journey and how simply it all began, I’m astonished at how firmly rooted XML is in today’s software development landscape. I always said “XML will change the world,” but only after reflection did I re
Oracle 10g Adds More to FORALL
(Steven Feuerstein) In my second article on PL/SQL enhancements in Oracle Database 10g, I will explore the new capability of using the FORALL statement with nonconsecutive driving indexes. While this might at first sound fairly esoteric, it is actually a key enhancement to the FORALL statement that
Migration Guide: Migrating to DB2 Replication Version 8
This document describes how to migrate an existing DB2 replication environment to Version 8 replication. DB2 replication is available for various systems. It is available as an integrated part of DB2 Universal Database for workstation operating-system environments, and as separately orderable produc
Oracle9iAS Web Services: SOAP
Oracle Web Services are facilities have been greatly enhanced for the Oracle9iAS delivery. They are based on the W3C SOAP Note as enhanced by the W3C SOAP with Attachments note. SOAP (Simple Object Access Protocol) was defined to address a number of objectives. In brief, these objectives were to
DB2 OLAP Server V8.1: Using Advanced Functions
(Corinne Baragoin) This IBM Redbook explores DB2 OLAP Server V8.1 enhancements and strengths in the areas of scalability, performance, high concurrency, high availability, and administration, and explains how to deploy them in a whole enterprise environment. We provide administrators and implemen
DB2 V8: Online Schema Evolution
(Craig S. Mullins) Making changes to database structures can be one of the biggest causes of database downtime. This is so because many of the most common changes require DBAs to create convoluted scripts that capture DDL from the system catalog, unload data, DROP objects, and then re-CREATE the obj
Chapter 8: Using Microsoft Data Transformation Services (DTS)
(Claude Seidman) As we saw in Chapters 1 and 2, one of the most important prerequisites for a successful data-mining effort is the preparation of the case data, which you need to do before you can begin mining any data. In many, if not most, cases the source of the training for your data-mining mode