(Neelima Vobugari) In today’s IT applications, typically a data element representing the same concept is named differently in different applications. In application integration scenarios, these interacting applications need interfaces or appropriate adaptors between them. These interfaces or ada
Author: SSWUG Research
Learn and Predict
(Ron Hardman) We predict potential outcomes based on actions every day. If I speed in my car, I have a much higher likelihood of being pulled over by the police than if I observe the speed limit. Choosing a burger and fries every day at lunch rather than a more nutritious meal is likely to lead to p
Take The Fast Train
(Rahul Kitchlu and Boris Bialek) On January 30, IBM announced the availability of DB2 Express-C, a no-charge DB2 you can use for development or production. You can even redistribute it as part of your own application bundle, part of an educational curriculum, or just to friends and colleagues (pleas
Set Functions: The DrillDownLevelTop() and DrillDownLevelBottom() Functions
(William Pearson) In this article, we will continue the examination of "MDX for drilling up and down" that we began in Set Functions: The DrillDownMember() Function. We have discussed the nature of drilling, in general, in previous articles of our sub-series, stating that it comprises an analytical
Boost performance and use less disk space with hash keys
(Arthur Fuller) A common SQL Server application requirement is to support searches based on one or more long strings. (In this article, we refer to anything with more than 20 characters as a long string.) Suppose that your front-end application wants to allow the user to supply two long strings; you
FIX: An access violation may occur when you try to run a Transact-SQL query in SQL Server 2000
When you try to run a Transact-SQL query from an application in Microsoft SQL Server 2000, an access violation may occur. This problem occurs when the following conditions are true: • The Transact-SQL query contains a UNION operator. • The Transact-SQL query uses a parallel execution plan.
Implementing File Compression and Encryption in Visual Basic 6 Using the Microsoft .NET Framework, Part II: Compression
(Scott Swigart) In this two-part article series, you’ll see how you can easily add encryption and data compression (ZIP) capabilities to existing Visual Basic 6 applications using the .NET Framework. While encryption and compression may not seem like related technologies, if you think about it, each
Creating Business Value with Operational Customer Data Integration and Management
Download this white paper to discover why organizations are turning to Customer Data Integration solutions to drive multiple strategic business initiatives, and why IBM’s WebSphere Customer Center has been proven as the leading solution available today. (R)
Meeting the Data Integration Performance Challenge with the Right ETL Tool
(Yves de Montcheuil) The process for selecting an ETL (extract, transform and load) software solution is typically a complex one requiring the evaluation of many features. However, one of the most critical factors to consider when assessing ETL products is determining how well the product will perfo
Make the most of Oracle Database 10g with these insider solutions (Sample Chapter)
(John Kanagaraj, Arun Kumar and Richard Stroupe) Many of the new features in Oracle Database 10g add new functionality, while others remove minor limitations that used to exist before or change the way a particular action was done. (pdf)