(Arup Nanda) Traditional Oracle Database auditing options let you track the actions users perform on objects at the macro level—for example, if you audit for SELECT statements on a table, you can track who selected data from the table. However, you don’t know what they selected. With data-manipu
Other News
Integration Models
(Brian Travis and Mae Ozkan) The integration models we have today are either loosely coupled or tightly coupled. They are message-based or method-based. They are synchronous or asynchronous. Putting these things together in an intelligent way is essential if you are going to archive the promise of w
Microsoft Windows Code Name
Well here we are, the moment we have all been waiting for. The PDC has finally [come and gone], and with it so has Longhorn Pre-Beta build 4051. There are many new things in this build that are worth checking out as well as a few disappointments we’d like to express. The main goal of this tweak guid
DB2 CommonStore and its Backend Archive Options – Understanding the Technical and Functional Differences
(Reinhold Engelbrecht) The DB2 CommonStore product family supports three different backend archives: Content Manager, Content Manager OnDemand, and Tivoli Storage Manager. Each of these archive options has a unique architecture and particular strengths. This article provides a comparison and a detai
XML in Unexpected Places
(Eugene Kuznetsov) It is a welcome sign of XML’s success that it increasingly appears in unexpected places and concerns an everbroadening set of people. Those of you who were involved with XML technology in the early days or who bravely pioneered XML in your organizations years ago may be bewildered
HOWTO: Specify an XSL File to Transform the XML Stream from a Query with SQL Server 2000
This article is based on the assumption that the reader is familiar with the configuration for SQL Server 2000’s virtual root and associated virtual names for templates and schema. The virtual root and virtual names are set up through the Configure SQL XML Support in IIS utility. For additional info
Who’s In Control Here?
Stefan Petry, Oracle’s senior director for product management in the systems management area, explains why and how Oracle Enterprise Manager has an expanded role in enterprise grid architecture.
Connecting to a data source using the DriverManager interface with the DB2 Universal JDBC Driver
A JDBC application can establish a connection to a data source using the JDBC DriverManager interface, which is part of the java.sql package. The Java application first loads the JDBC driver by invoking the Class.forName method. After the application loads the driver, it connects to a database s
Constraints and Triggers
Constraints are declarations of conditions about the database that must remain true. These include attributed-based, tuple-based, key, and referential integrity constraints. The system checks for the violation of the constraints on actions that may cause a violation, and aborts the action accordingl
HOW TO: Obtain a List of DTS Packages
You can store the Data Transformation Services (DTS) package in one of three places. The following code samples describe the three methods to obtain a list of packages for each storage method.