(Boris Milrud) There are times when database data manipulation requires extracting DDL (Data Definition Language) commands for various objects, such as database tables, indexes, constraints, triggers, etc.
Author: SSWUG Research
Hacking XML
(Michael Fitzgerald) Among my favorite hacks in XML Hacks are two that use an SGML package called SP to do some clever tricks. James Clark’s SP is a free, open-source SGML-parser package that includes an SGML parser called nsgmls and an SGML-to-XML converter called sx. The first hack excerpted b
An Introduction to Java Map Collection Classes
(Jack Shirazi) The collection classes in java.util include some of the most commonly used classes in Java. The most commonly used collection types are List and Map. Concrete implementations of List include ArrayList and Vector, which are variable size lists ideal for building, storing and manipulati
Design patterns for information architecture with DITA map domains
(Erik Hennum, Don Day, John Hunt and Dave A. Schell) The Darwin Information Typing Architecture (DITA) provides maps for assembling topics into deliverables. By specializing the map elements, you can define a formal information architecture for your deliverables. This architecture provides guida
Validating date using SQL
(Craig Mullins) Is there a way to validate a date using DB2 SQL? I have a date field from a file (COBOL is the programming language), and I need to determine if it is a valid date. (R)
Index on multiple columns for performance
(Arthur Fuller) SQL Server allows only one clustered index per table because a clustered index reorders the table, arranging the data according to the index key. This results in wonderful performance–when you only have to worry about one particular column.
Introduction to MSSQL Server 2000 Analysis Services: Basic Storage Design
(William Pearson) Optimization of MSAS requires an in-depth knowledge of many factors, including the manner in which MSAS executes queries within the client/server architecture that embodies it. From the perspective of the cubes that MSAS produces, our primary concerns, from a performance standp
IBM’s Jones: ‘Stinger’ Targets Enterprises with Automation, Price Freeze
(Lisa Vaas) Jeff Jones, director of strategy for IBM’s DB2 Universal Database, says IBM is wielding affordability and automation as it prepares for battle in the new world of second-generation databases. As the company prepares to unleash Stinger, code name for DB2 UDB 8.2, he took time out to c
Patterns: Information Aggregation and Data Integration with DB2 Information Integrator
(Nagraj Alur) This IBM Redbook documents and prototypes the role of DB2 Information Integrator technologies and architecture in IBM’s Patterns for e-business using a typical customer insight e-business scenario. It is aimed at an audience of IT architects and data integration professionals responsib
Oracle security patches causing headaches
(Robert Westervelt) Oracle security expert Arup Nanda said Oracle’s latest alert is frustrating to DBAs since very little information was released with each patch. With little information to go on, many enterprises are being forced to take entire systems out of production, Nanda said. (R)