IBM announced outstanding performance results on a benchmark designed to test a system’s ability to handle complex business intelligence processing. One IBM configuration achieved the world record for the best non-clustered result in the TPC-H 100GB benchmark test. Another IBM configuration in the T
Other News
Partitioned table details
(Ravi Nookala) It is difficult to display all the details of a given partitioned table without repetition of column values. This PL/SQL block is useful because it saves you from searching for the tablenames where the datails are available and how to join the tables. It is embedded with unique coding
Installing PHP and the Oracle 10g Instant Client for Linux and Windows
(Christopher Jones) Oracle 10g Instant Client (free download available) is the easiest way for PHP to connect to a remote Oracle database, requiring installation of only three libraries. The Instant Client libraries used by PHP access Oracle’s current API, called OCI8. (This C interface takes it
SQL Server: A Practical Guide to Backup, Recovery & Troubleshooting
(Christopher Kempster) The role of DBA is undoubtedly an important one, but many DBAs tend to be somewhat blasé about backup and recovery. This e-book attempts to bridge the knowledge gap and provide working scenarios, policy/procedure and best practice for database backup and recovery. (pdf)
Windows Services for UNIX
(Simon Bisson) Servers based on Intel’s x86 architecture are a commodity: cheap to buy and cheap to run, they have become the life-blood of the data centre. Once a few high-end UNIX systems sat and ran your business; now they’re surrounded by humming racks of cheap x86 systems, and they’re coming to
Developing DB2 Applications: The Platform Choice is Yours (e-book)
(Paul Zikopoulos) When it comes to application development, Java junkies and .Net devotees may never see eye to eye. If they’re developing for DB2, they don’t have to. DB2 UDB v.8.2 shipped earlier this year with something for every developer, regardless of platform preference. This must-read e-book
Why EDI Must Die
(Jeremy Jones) Electronic Data Interchange (EDI), a data format used for inter-business messaging, has been partially responsible for reducing costs and increasing productivity in the manufacturing and services industries. Over the years, EDI has evolved into a mechanism for integrating back off
Working XML: UML, XMI, and code generation, Part 3
(Benoît Marchal) In the third article on UML modeling and XML, the author further refines the conversion stylesheet with the introduction of stereotypes and tags. These are extension mechanisms for UML that are used to store implementation information in the model.
DTS: Copy Objects Task
(Bruce Szabo) Microsoft has provided so many great tools and at times they have helped solve many issues. There are cases though where the tools do not behave exactly as one would expect. There is nothing more frustrating than finding a tool that is supposed to help, actually causing an error or beh
Views Work In MySQL 5.0
(Peter Gulutzan) On July 15 2004, Oleksandr Byelkin of Ukraine merged his “views” code into MySQL. I have verified that the MySQL version 5.0 Linux source download supports views. This report will interest people who know MySQL, who know what views are, and who have been waiting a long time for MySQ