(Uday Denduluri) This article exposes the concept of Full text search. It also explains the architecture of full-text search indexing along with the enhancements made to it in SQL Server 2005.
Other News
VTD-XML: A New Vision of XML
(Victor Volkman) VTD-XML is a suite of innovative XML processing technologies centered around a non-extractive XML parsing technique called Virtual Token Descriptor (VTD). VTD-XML provides interfaces for C, C#, and Java. VTD-XML solves a number of problems inherent with existing DOM and SAX models i
Revisiting DB2 Version 8 Bind one more time
(Willie Favero) Upgrades to DB2 for z/OS Version 8 are now moving along quite nicely. There are now (and have been for a while now) have more customers running on DB2 Version 8 than on DB2 Version 7. This is good news not only because V7 is going out of service in 6 months, but because Version 8 has
An Overview of what’s new in .NET 3.0
(Chris Sully) In this article I’ll look in a little more theoretical detail at the first 3 of these 4 new components. In later articles I hope to dig a little deeper into the practicalities of using these new technologies.
Integrate WebSphere Business Modeler and Rational Data Architect
(Mei Selvage, Ray W. Ellis and Daniel T. Chang) In an SOA world, business process and data modeling are closely related. Most business processes need to manipulate some sort of data. Data supports business processes to accomplish desired business results. When you use a Model-Driven Development (MDD
Procedure privileges
(Ronald) I came across a problem on site yesterday. In moving the development environment to a new server and creating more appropriate permissions for users (they were using ALL on *.*) I found that the Java application would crash with a NullPointerException. The permissions were standard, and cal
Working With PL/SQL Code
(Steven Feuerstein and Bill Pribyl) In this sixth part of a nine-part series on managing PL/SQL code, you will learn how to synchronize code with packaged constants, how to work with post-processed code, and more.
Bind peeking change in 10g
(yas) A new note called “10g Upgrade Companion” has been published in Metalink recently. The note talks about the upgrade from 9i to 10g and lists recommended patches, behavior changes and best practices. While I was going through it I saw something I was not aware of before. In the “behavior change
DB2 LUW Performance: I/O Read Times (ORMS)
(Scott Hayes) In the next few blog posts, we’ll take a look at formulas for time metrics so that we can understand “where the time goes” and uncover bottlenecks. Since both OLTP and Data Warehouse databases perform a great deal of I/O read activity, we’ll begin by looking at metrics for computing im
Oracle BI EE 10.1.3.3/2 – Working with Disconnected Analytics – sadis Utility
(Venkatakrishnan J) I came across a very interesting utility today. I am not sure how many are actually aware of it. It is called as sadis.exe. As you would know, BI EE has a very unique feature called as Disconnected Analytics. Now lets try to understand what disconnected analytics is and then late