(Toby Jacob Rhodes) GRML is a markup language for browsing the web. It has the data definition features of character-delimited files and XML, with the hyperlinking and form support of HTML. The purpose of this article is to show why GRML exists and how it complements HTML, XML, RSS, and characte
Author: SSWUG Research
Introducing GRML
(Toby Jacob Rhodes) GRML is a markup language for browsing the web. It has the data definition features of character-delimited files and XML, with the hyperlinking and form support of HTML. The purpose of this article is to show why GRML exists and how it complements HTML, XML, RSS, and characte
Document Management, Using WebSphere Portal V5.0.2 and DB2 Content Manager V8.2
(John Ganci) This IBM Redbook and sample code provide IT architects, IT specialists, and developers with the critical knowledge to design, develop, deploy and manage a portal based document management system using IBM WebSphere Portal V5.0.2 and IBM DB2 Content Manager V8.2. (pdf)
Automated Selection of Materialized Views and Indexes for SQL Databases
(Sanjay Agrawal, Surajit Chaudhuri and Vivek Narasayya) Automatically selecting an appropriate set of materialized views and indexes for SQL databases is a non-trivial task. A judicious choice must be cost-driven and influenced by the workload experienced by the system. Although there has been
Oracle/PLSQL: Sequences (Autonumber)
In Oracle, you can create an autonumber field by using sequences. A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.
DB2 parallel operations and query performance
(Eric Garrigue Vesely) Parallelism can be employed in static and dynamic queries, local and remote data access, queries using single table scans and multi-table joins, access via an index or table scan, or list prefetch, sort, and inserts. Most parallel operations can be used on either partitioned o
Save Your Password
(Dinesh Asanka) How often have we seen password is saved in plain text? After doing all kinds of security arrangements still we keep the password in plain text. This short article will discuss about how to keep the passwords in somewhat secure way. (R)
Investigating Reporting
(Scot J. Reagin) If you’re like many IT professionals, designing and managing reports isn’t likely to make your list of “top 10 ways I’d like to spend my day.” The continuous maintenance and modification tasks inherent in reporting can be a significant strain on already stretched resources, and y
Wrestling HTML
(Uche Ogbuji) Lately I’ve seen HTML parsing problems everywhere. One project needed a web crawler with specialized features provided through Python code that processed arbitrary HTML. There have also been several threads on mailing lists I frequent (including XML-SIG) featuring discussions of mechan
SQL procedure tracing
(Serge Rielau) This article describes an API that allows for transparent tracing of SQL procedures as well as explicit tracing of non-SQL procedures in DB2 Universal Database (UDB) V8.2 for LUW. An example SQL interface to this API is provided, as well.