In some specific cases, DB2 either modifies some predicates, or generates extra predicates. Although these modifications are transparent to you, they have a direct impact on the access path selection and your PLAN_TABLE results. This is because DB2 always uses an index access path when it is cos
Author: SSWUG Research
Using Oracle Data Mining to Analyze Sequence Data
Sequence alignment is without doubt one of the most commonly performed bioinformatics tasks. The most widely used sequence alignment algorithm is BLAST (Basic Local Alignment Search Tool). BLAST is a method for rapid sequence comparison that was introduced in 1990 by Stephen Altschul. It is typi
Converting an EJB 2.0 Entity Bean to EJB 3.0
(Deepak Vohra) The Enterprise JavaBeans (EJB) 3.0 specification has facilitated the development of EJBs, by providing an annotations-based API in which the remote/local and home/local home interfaces are not required. The deployment descriptors that form the basis of an EJB 2.0 entity bean are also
FIX: An access violation occurs and the Analysis Services service unexpectedly quits during the Startup process in Microsoft SQL Server 2000 Analysis Services
In Microsoft SQL Server 2000 Analysis Services, an access violation occurs and the Analysis Services service unexpectedly quits during the Startup process. This problem occurs after you install SQL Server 2000 Analysis Services hotfix build 8.0.1028 or SQL Server 2000 Analysis Services hotfix build
2006 XML.com Reader Survey
(Kendall Grant Clark) If you’ve been paying attention to XML.com this year, you’ll have noticed that we’re in the midst of an editorial transition. We think–and most industry observers seem to agree–that the era of core XML development is more or less over. We’ve got sensible ways to handle XML fr
Virtual Web Application using ASP.NET Whidbey
(Saravana Kumar) Virtual web application is a sample applicatoin created to demonstrate the capabilities of ASP.NET 2.0. In this application i have used following new features of ASP.NET 2.0 –File System Provider [VirtualPathProvider] –Master Page –Client Callback Feature –Login and Mem
Working With Temporary Views Using Common Table Expression in SQL Server 2005
When working with SQL 2005, there are times when you need to perform several aggregate functions, or to define a view that needs to be stored only during the execution of a particular query. A Common Table Expression (CTE) does just that; it helps in the definition and manipulation of query related
Multi-tier DB2 database applications in Delphi 2005
(Bob Swart) In this article, we will use the Borland Data Provider for ADO.NET, which is part of Borland’s C#Builder, Delphi 8 for .NET, Delphi 2005, and the newly released Delphi 2006. The later two have both Win32 and .NET personalities, but in this article I want to focus specifically on the .NET
User-defined Interfaces in PHP 5: Building a Page Generator
(Alejandro Gervasio) Here we are again. Welcome to the last part of the series “User-defined interfaces in PHP5.” Although the subject is certainly thorough enough to be the topic of a complete book chapter, this series has hopefully served as an introduction to learning the basics of interfaces, as
Usage-Based Optimization in Analysis Services 2005
(William Pearson) In this lesson, we revisit usage-based optimization, a subject that we undertook in my article MSAS Administration and Optimization: Simple Cube Usage Analysis, in September of 2003, and MSAS Administration and Optimization: Toward More Sophisticated Analysis in October of 2003. In