Author: SSWUG Research

Community

Server Databases Clash

By Timothy Dyck – For four weeks last month and early this month, eWEEK and sister publication PC Magazine carried out a comprehensive benchmark of the latest available versions of five server databases. These tests showed us on a level playing field which database performed best when used with a J

Community

Using XML in iTV development

The dream of using your remote control to interact with television broadcast shows has finally become a reality, thanks to interactive television (iTV). Here, John Papageorge explores the opportunities and challenges of creating applications for the set-top box platforms (such as OpenTV, AOLTV, and

Community

Fine-Grained SQL Formulation

This tip comes from Eric T. Schmidt – Oracle 8.1.6 introduced 26 Analytic Functions that extend SQL in powerful and creative ways. With this new query formulation technique, it is easy to represent fine-grained control of complex queries without using complex sub queries, correlated queries, or PL/S

Community

DML Statements

by Jason Price – This third column in my Learning SQLJ series explores how to add SQLJ statements to your Java programs that use embedded SQL Data Manipulation Language (DML) statements. DML statements may be used to retrieve and modify the contents of database tables. In this article, you will also