(Esther Schindler) The continuing DevSource Great Minds in Development video series has emphasized many of the “softer” issues of programming: usability, information access, and aesthetics. The rest of DevSource has plenty of hammer-and-nails “how-to” information, but it’s important, too, to conside
Author: SSWUG Research
Will Open Source Be One of Your BI Sources?
(Mike Schiff) The Open-Source movement has not been ignored by data warehouse and business intelligence vendors. While the Linux operating system and the Apache Web server have become the poster children for the open source community, the range of open-source products available today includes databa
FIX: Error message when you try to run a query on a linked server in SQL Server 2000
When you try to run a query on a linked server in Microsoft SQL Server 2000, you may receive the following error message: Server: Msg 7347, Level 16, State 1, Line 1 OLE DB provider ‘SQLOLEDB’ returned an unexpected data length for the fixed-length column ‘[LinkedServerName].[DBName].[OwnerName].
Develop custom client applications with IBM DB2 Content Manager C++ OOAPI, Part 2: A guided tour to designing and developing the ADClient application
(Xiao Li and Sheng Wei) The pClient and eClient, packaged with IBM DB2 Content Manager (CM), meet the client requirements of many Content Manager users. However, many others need to develop their own client applications to meet their special business needs and to integrate their own business with CM
Custom XPath Functions
(Mark Nischalke) XPath Expression are a powerful tool, however there are some limitations. Some things that you may need to do are not available yet in the specification, or you may need to do something slightly different from the specification, or there just isn’t any way to do it except for using
Virtual Memory and Demand Paging
(Joydip Kanjilal) One of the most important of all concepts related to Memory Management is Virtual Memory. Virtual Memory refers to the concept whereby a process with a larger size than available memory can be loaded and executed by loading the process in parts. The program memory is divided into
Mini-Tip #5: Coalesce()
(Lewis R Cunningham) I recently wrote about NVL2. A function much like NVL2 is coalesce.
Open source servers serve up challenges
(Paul Gillin) Open source software is certainly a wonderful evolution in computing, but even if you’re a savvy PC user with a lot of commercial software experience, the job of installing and running open source on a server can be a daunting experience. Here’s my own vignette. (R)
Multi-Dimensional Clustering Table Size Estimator for DB2
Many applications, OLAP and data warehousing in particular, usually consider several attributes as dimensions for processing and maintenance. Performance and scalability of queries in this type of environment can be slow using the traditional relational-database approach based on one-dimensional clu
Tuning MySQL for eZ publish
(Bård Farstad) This article explains how to tune a MySQL database for use with eZ publish. MySQL is a database engine used by eZ publish to store content. While other databases are supported by eZ publish (such as PostgreSQL and Oracle), for performance reasons we recommend MySQL. This article has s