(Steve K Speicher, Jan J. Kratky and Kevin E. Kelly) With XForms technology, you can provide a lightweight editor for an existing collection of XForms. Explore an approach to form authoring for simple, quick changes that improve the effectiveness of data collected. Typical form editing requires a se
Other News
Introducing DB2 Viper, Part 2: Table partitioning in DB2 Viper
(Rav Ahuja) Management of large databases and tables has its own challenges. As tables grow in size, it sometimes becomes easier to manage their data in chunks or by limited ranges, rather than operate on all of the data in those large tables in their entirety. This methodology of managing data is a
Data Modeling,Breaking & Fixing 1NF
(James F. Koopmann) It has been my observation that a lot of us lack the basic skills required to model the simplest of database objects. This article will explore some of the common mistakes and fixes to the breaking of 1NF.
Using the system function fn_listextendedproperty of SQL Server 2005 for .NET applications: Part II
(Michael Livshitz) In Part 1 of this article we compared the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000, wrote a few queries for SQL Server 2005 to test the function. In part 2, I am going to describe using the function for .NET applicatio
Asked & Answered
(Robert Catterall) We’re implementing a Web services-based application that uses the Distributed Data Facility (DDF). Initial monitoring analysis shows very high CPU enclave consumption, which limits the number of users we can support without degrading the performance of other critical online applic
Build a Menu Framework
(Tony Jedlinski) Developers often use Oracle Application Express (formerly Oracle HTML DB) to rapidly develop simple, non-business-critical applications—to replace spreadsheet-based applications, for example, or to automate paper-based or other manual systems. Given Oracle Application Express’ s
Introducing the MySQL Sandbox
(Giuseppe Maxia) Installing a side instance of MySQL for testing purpose is a task that many administrators can perform without breaking a sweat. If you need to do that only once in a while, you need just to read the manual carefully, or to have some experience in this matter, and the task is accomp
XML Matters: Up and Atom
(Dethe Elza and David Mertz) As a syndication format, Atom grew out of experience with the various flavors of RSS (of which there are many), not to create something entirely new, but to tighten up places where the specification of RSS was too vague to be useful (for instance, RSS does not specify wh
Maximize the performance of WebSphere Information Integrator with Materialized Query Tables
(Anjali Betawadkar-Norwood, Valer-Alin Crisan and Eileen Lin) A materialized query table (MQT) is a table that materializes the pre-computed result of a query involving one or more tables or nicknames. After the MQT is created and populated, an arbitrary subsequent query may be satisfied by the MQT
Powerful, Flexible Text-Formatting Solutions in SQL Server
(Alex Kozak) Removing extra empty spaces is a pretty common task that seems very simple, but in reality it is not as trivial as you may assume. The first impulsive solution that many programmers try is replacing two empty spaces with one, which works as long as the number of empty spaces doesn’t exc