(MS Sridhar) Oracle does not have a mechanism by which you directly change column names. But this workaround is quick and efficient.
Author: SSWUG Research
Partitioning with Dates in MySQL 5.1
(Robin Schumacher) Many of you have responded very positively on the first and second partitioning articles that I wrote some time back. It’s clear that a lot of you are excited about the upcoming MySQL 5.1 release, and in particular, the new data partitioning feature that’s being offered. That’s no
Oracle and Java Performance Management: An Executive View
This Confio white paper posits that database administrators need to be more concerned about Wait-Time than any other performance metric as they strive to meet stringent Service Level Agreements (SLAs). It builds a compelling case for using time-based analysis to rapidly identify the root causes of p
Getting to know the .NET collections
(Lamont Adams) Collections provide a way to store arbitrary objects in a structured fashion, and we all know how useful they are in everyday programming. The .NET class library offers an embarrassment of collection riches—a bewildering selection of collection objects, each with a somewhat specialize
DB2 9: pureXML Overview and Fast Start
(Cynthia M. Saracco, Don Chamberlin and Rav Ahuja) Services Oriented Architectures (SOA) are an integral part of building an agile enterprise capable of making decisions quickly, and responding rapidly to new products and services opportunities, as well as to competitive threats. The explosive growt
Populating a TreeView Control from the Database
(azamsharp) ASP.NET 2.0 came out with tons of new controls which help developers to speed up development. Among all the new controls, the TreeView control stands out as one of the most important and useful controls. The TreeView control enables you to display data in a hierarchical form. The TreeVie
E-Commerce Tip: Programmatically Validate Credit Card Numbers
(Eric Smith) Before I accept any credit card number into my application, I run a simple numerical validation against it. All major credit cards (American Express, Discover, MasterCard, and Visa) use the Luhn algorithm to validate the numbers—why not you? Although this function doesn’t go the extra s
DWR makes interportlet messaging with Ajax easy
(Sami Salkosuo) Portlets are Java platform-based applications for Web portals. JSR-168, a Java Community Process standard for developing portlet applications, addresses portlet lifecycle management, portlet container contracts, packaging, deployment, and other aspects related to portals.
Logging using the Composite Pattern
(mikeperetz) In this article I will explain how I solved a common problem I used to have regarding logging within my business layer. Normally, I would have a function call from my presentation layer to my business layer, however once in the business layer; I had no access to the presentation layer a
Streaming Techniques for XML Processing – Part 2
(Tobias Trapp) In the first part of bis blog series I introduced Steaming Transformations for XML (in short STX). Now I want to present a complex STX transformation that uses buffers to cache nodes that are needed later for output generation. The linear nature of serial transformations are the reaso