(Muthusamy Anantha Kumar) Microsoft introduces new operators PIVOT and UNPIVOT in SQL Server 2005. Traditionally we create queries using the CASE statement and aggregate function in order to produce cross-tab reports. This article illustrates the usage of the new operators, PIVOT and UNPIVOT.
Other News
The Business Value of DB2 UDB for z/OS
(Paolo Bruni, Paul Bartak, Rick Butler, Sreeni Janaki and John Pashley) DB2 continues to deliver rich functionality for scalable and highly available data for enterprise-scale, on demand applications. Combine the power and capacity of IBM zSeries and the high performance and high availability o
Browsing and Editing Data
(Steve Muench) In past columns, I have shown the various components Oracle ADF provides to simplify the process of building database-centric business services. The application module provides the transactional component clients use to browse and modify view object data, the view object performs
The future is open source
(Danny Bradbury) Like many developments in the IT sector, open source seemed to come out of nowhere. Linux was first developed in 1991, and since it began to be taken seriously as a commercial product a few years later, the industry has been caught up in a whirlwind that saw developing business mode
SAP claims success in seducing Oracle customers
(Colin Barker) PeopleSoft and JD Edwards customers unhappy at being acquired by Oracle are heading over to SAP in significant numbers according to SAP’s head of customer solutions, Leo Apotheker.
Recovering from hardware upgrade problems with SQL
(Arthur Fuller) As Martha Stewart might say, hardware upgrades are a good thing—that is, until stuff that used to work just fine suddenly breaks for no apparent reason. In moments like this, you invariably end up looking bad, and must drop everything else to find and fix the problems immediately.
Cross-platform Builds Made Easy: From Microsoft Visual Studio to ARMCC Using Ant and XSL
(Ray Rischpater, Aaron Wood and Aleatha Parker-Wood)One of the challenges of cross-platform development is managing your build environment. With so many platforms these days using the combination of Microsoft Visual Studio and an emulator to facilitate rapid development and frequent cross-compilatio
Composition
(Micah Dubinko) This week’s column takes a look at two new specifications that are winding through the W3C Recommendation Track, xml:id as a Proposed Recommendation and XLink 1.1 as a Last Call Working Draft. These two specifications share an important common trait: neither is a standalone vocab
IBM’s Database Queen to Retire
(Lisa Vaas) After a tenure of 31 years during which she carved DB2 into a sharp Oracle competitor, Janet Perna is retiring as general manager of data management solutions for the IBM Software Group, an IBM spokesperson told eWEEK.com.
A Practical Look at the MySQL Query Cache
(Robin Schumacher) All robust relational database management systems utilize memory caching to help improve the overall responsiveness of their underlying engine. While certainly not free, accessing application data, query plans, or database metadata in RAM is normally much quicker than repetitively