Oracle and HP set a new world-record Transaction Processing Council TPC-C benchmark of over one million transactions per minute on a cluster of Linux servers. The result was achieved Oracle Database 10g, HP Integrity servers with Intel Itanium 2 processors and Red Hat Enterprise Linux AS 3.0. Th
Other News
Listing Content Manager Version 8 Item-Type View Definitions
(Bryan Daniel) This sample program demonstrates how to use the Information Integrator for Content Version 8 C++ APIs to list the item-type views and their attributes which are accessible to the current user. Item-Type views are defined by the Content Manager System Administrator to restrict what ite
How to implement index extensions for non-traditional data
(Magnus Pierre) This document provides all you need in order to understand and develop index extensions, including what pieces are involved and how the fit together.It also addresses what you need to do in order to successfully build an index extension.
Maximizing MATCHCOLS when using Simple Subquery (DB2 OS/390 V6)
(Steve Mills) The technique described below is one that I have seen and used many times in recent years (and you may have too) but I have never seen it make quite the impact it did in this scenario. In this instance the addition of a COALESCE function produced a 50% reduction in CPU time and an even
Global Variables and Stored Procedure Parameters
(Darren Green) One of the benefits of the SQL Server 2000 is that the SQL tasks support mapping of global variables to parameter placeholders within the SQL. This means you can use the global variable as an input parameter for your stored procedure.
Faking arrays in T-SQL stored procedures
It is a very common requirement among the SQL Server developer community, how to pass multi-value strings to a stored procedure. As we all know multi-values are totally against the basic foundation of relational model and hence in T-SQL there are certain tricks you can apply to get them done. Note t
Reporting Services: It’s De-lightful
(Brian Larson and Martin Voegele) With apologies to composer Cole Porter, this is the song that Microsoft might be singing about its new SQL Server Reporting Services product. Slated for release by the end of 2003, Reporting Services handles the complete reporting life cycle—from a report’s design,
Embedded Analytics in IBM DB2 Universal Database for Information on Demand
Finding the needle of competitive advantage in a haystack of data. One of the major business insights of our time is that information can be more valuable than capital assets in helping your firm stay competitive and profitable. Today’s technology can deliver more bits of information about your co
Designing an Open, Standards-Based Reporting System – XML meets the challenges and design goals of a business reporting system
(Joe Marini) As XML has grown more prevalent as a data delivery mechanism, so too has the need to use it for presentation in a wide variety of reporting formats. XML is useful for more than just the delivery of information, however. It can be used to help solve a wide range of problems encountered w
Developing Applications on Oracle Collaboration Suite
(Jason Davis) Oracle Collaboration Suite provides an integrated set of communication and content-management applications that allow customers to work more effectively together. It is unique in the market in that it is built on the secure and reliable foundations of the Oracle 10g Database and 10g A