(Arup Nanda) In the Part 1 of this series, I described how to build a Fine-Grained Auditing (FGA) system to audit select statements, capturing the statements depending on certain conditions—a task impossible in regular auditing or though the use of DML triggers and the Log Miner tool. In addition to
Other News
Magic with Merlin: Formatting numbers and currency
(John Zukowski) Internationalizing your applications requires both text messages and displayed numbers to be formatted for the appropriate language and style of the user’s domain. With the Merlin release of the J2SE platform, formatting integers has gotten simpler, and you can now find out the ISO 4
Star Join Optimization DB2 UDB for z/OS and OS/390
(Terry Purcell) Since the introduction of the Star Join access method in Version 6 of DB2 UDB for z/OS and OS/390, there have been many additional enhancements to improve the detection of star schema queries to determine the most efficient access path, and also to minimize regression of non-star sch
DB2 parallel operations and query performance
(Eric Garrigue Vesely) Parallelism can be employed in static and dynamic queries, local and remote data access, queries using single table scans and multi-table joins, access via an index or table scan, or list prefetch, sort, and inserts. Most parallel operations can be used on either partitioned o
OO versus XML + agile programming languages?
(Uche Ogbuji) Kimbro Staken skewers a terribly contrived example of OO-to-the-max. It’s great fun at first glance, but in the end I find the treatment somewhat troubling. I’ve myself undergone a conversion from mainstream OO orthodoxy to what I consider post-OO programming sensibility, and I hav
.NET and Oracle Java Stored Procedures—Bridging the Gap with XML
(Jeff Hilts) Using Oracle as your database in the .NET environment is relatively simple, except when returning JDBC ResultSets from Java stored procedures. The Microsoft and Oracle .NET data provider drivers allow for easy access to data from SQL queries and PL/SQL stored procedures. There is not, h
A First Look at Execution Plan Costs in Yukon Beta 1
(Joe Chang) Many of us are interested in the features and changes in Yukon. A quick look shows some changes in the execution plan cost formulas for Yukon Beta 1. It is quite likely that more changes will be made between beta 1 and the final release. Most of the cost formulas appear not to have ch
SQLWays – Microsoft SQL Server Functions and Expressions
This chapter describes functions and expressions that can be used in Microsoft SQL Server SQL statements and Transact SQL programs.
DB2 Query Patroller 101
(Paul Zikopoulos) You may not know a lot about DB2 Query Patroller, but if you are an administrator responsible for the resource management of a Decision Support System (DSS), you are definitely familiar with the following: –erratic query response times –dissatisfied users –unnecessary exp
Put Your Sensitive DB2 Data Under Lock and Key
(Kulvir Singh Bhogal) Hackers are trying to find some way to get into your database. If you think they’re not, you’re just deluding yourself. The news stories about compromised credit card numbers are proof that the best way to lose face with your customers is to let a hacker steal their sensitive d