(Marc Hedlund) Bloglines announced a set of new web services APIs, allowing developers to write applications for reading RSS and Atom feeds by drawing data directly from the Bloglines databases. This is a very significant change in the landscape of RSS/Atom aggregators, the newsreading applicati
Author: SSWUG Research
Lookup Table Design
(Leo Peysakhovich) When I begin to design a new database for a client, one of the dilemmas facing me is how to construct lookup tables. When we say that a table is a lookup table for another main table, we mean that the lookup table contains values that will be used as the content of a column lo
Access Path Selection: Evolution and Revolution
(Frank J. Ingrassia) Access path selection (APS) is the optimizer’s primary function—to choose the most efficient access path for each SQL statement executed by DB2. Access paths can be indexed or non-indexed, matching one or more columns against those indexes and/or screening predicates against col
DB2 XML Extender, WORF, and WebSphere Application Developer
(Owen Cline) This article will show how to use XML technology efficiently in business applications, and explain how to integrate your applications with DB2 Universal Database, DB2 XML Extender, WORF, WebSphere Application Developer and the WebSphere Application Server. You will learn how to desi
FIX: Changes to Indexed View Article of a Transactional Publication Are Not Saved
When editing the properties of an indexed view article that is part of a transactional publication, changes made to the Replace INSERT commands with this stored procedure call, Replace UPDATE commands with this stored procedure call, and Replace DELETE commands with this stored procedure call check
Use Oracle VARRAY Through JDBC
(Vijayanandraj Amaladoss) This code snippet demonstrates how to use Oracle VARRAY through JDBC. The code does three things: –It creates VARRAYs of different lengths. –It contains a table to store data of above array type. –Stores the objects in an array, and inserts them into database
MSSQL Server 2000 Reporting Services: Master Chart Reports: Track Exchange Rates in a Line Chart
(William Pearson) In this article, our exploration of chart reports will move into an examination of the line chart. Line charts are another popular chart type, and are likely to be familiar to the majority of us, if not in the context of report authoring, then at least as an information consumer.
Sample Application: XML Form Generator, Part 2: Capturing User Input
(Andrew Mooney) Part 1 of this series demonstrated how to create an XML form using a DataGrid in a web page. The focus of this part is the display of the XML form using XSL to transform it; and then saving the user input to an XML file.
Controlling the order of elements during XML Serialization
(Mark Neustadt) Recently, I have been running into some problems with XML Serialization in VB.Net. I suppose this would apply to C# as well, but I don’t do that. Anyway, at work, we’ve been trying to get ourselves integrated with Amazon.com. We’re going to be selling our wares there. It’s very excit
Where In-Depth XML SKills Pay Off
(Vance McCarthy) Developers at Quadrix Solutions do their own XML hand-coding because, they say, XML is the best “applications glue” they’ve ever worked with.