Other News

Community

Up Start

(Kim Moutsos) Fred Sobotka spent his formative years coloring on the back of the used punch cards his father brought home from his job at UNIVAC. By junior high, he had a self-described “obsession” with programming, even teaching himself how to code in 6502 assembly language from magazine articles.

Community

DB2 predicate manipulation

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

Community

An inside look at how XML works

(Preston Gralla) In my previous column, I explained the underlying architecture of how Web services work and demystified how all of its underlying components work together. This column kicks off a series looking at how each of those elements work. We’ll start off the series by examining the basis of

Community

Data Modeling

(Philip Greenspun) Data modeling is the hardest and most important activity in the RDBMS world. If you get the data model wrong, your application might not do what users need, it might be unreliable, it might fill up the database with garbage. Why then do we start a SQL tutorial with the most challe