(Paul Kimmel) My first article on this topic demonstrated database reads-to-entities. Reads are relatively easy. Just read one or more result sets and build objects; you don’t need transactions. This article demonstrates database writes. The write part of managing a data access layer (DAL) is where
Author: SSWUG Research
The Trial-and-Error Method for Data Architecture
(Rick Sherman) As a coach of my sons’ soccer teams, I’ve noticed something that occasionally holds back the ambitious players. Rather than focusing on basics, such as learning good ball control, they are seduced by the lure of scoring. But without good basic skills, they don’t have the ability to sc
Introduction to XSLT
(Nicholas Chase) The need to transform XML is so common that Extensible Stylesheet Language Transformations (XSLT) is considered one of the basic XML specifications. This tutorial explains how to create XSLT stylesheets. It also covers the basics of XPath, which enables you to select specific parts
Practical applications of AJAX in WebSphere Portal
(Bikramjit Naha, Brian DeLuca and Tony Efremenko) This article tells you how to use AJAX with IBM WebSphere Portal Version 5.1.3 for Multiplatforms to quickly meet a few of the basic expectations in your portlet applications that users have come to expect from using sophisticated, graphically-based
Analyze your managed .NET code with FxCop
(Tony Patton) I have never met a programmer who doesn’t make a coding mistake from time to time. Tracking down and addressing these issues can be one of the most important aspects of your job. The next time you need to analyze your managed .NET code, I recommend using Microsoft’s FxCop tool to track
AJAX Test Automation
(James McCaffrey) The popularity of Web applications that use AJAX (Asynchronous JavaScript And XML) technology has increased steadily over the past year. When written correctly, AJAX can yield significant improvements in performance and user experience compared with non-AJAX Web applications. Howev
DB2 Version 8 CPU regression… my conclusions
(Willie Favero) The cry heard round the world of late has been "How much CPU is DB2 Version 8 going to use?" OK, that may be a little over the top. However, whether you call it CPU consumption, CPU regression, or simply CPU usage, this seems to be a big question on everyone’s mind today. For some, i
OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4
(Hernando Bedoya, Jaime Gaug, James Kerl, Ser Ser NG and Jose Cardoso dos Santos) The goal of database performance tuning is to minimize the response time of your queries. It is also to optimize your server’s resources by minimizing network traffic, disk I/O, and CPU time. (pdf)
What’s New in Prototype 1.5?
(Scott Raymond) The latest release of Ruby on Rails, version 1.2, was announced last week to great fanfare. But the announcement might have overshadowed news of a simultaneous release: version 1.5 of Prototype, the popular JavaScript library. Despite the synchronization and developer overlap between
How to make MySQL replication reliable
(Xaprb) MySQL statement-based replication is widely discussed, but I haven’t seen much about how to design a replication setup for low downtime and easy administration. Statement-based replication has inherent shortcomings experienced MySQL users know to avoid, but rarely write about. This article e