(Bob DuCharme) I have several useful little stylesheets that I’ve never mentioned in this column because each is so short that describing it would make for a pretty short column. I recently realized, though, that by combining them I have enough to fill up two columns, so this month we’ll look at the
Other News
Joins Revisited: It’s All About Relationships
(Stephan Onisick) There are two primary ways to get to the View Design Tool: by right-clicking Views and choosing New View, or by right-clicking an existing view and choosing the Design option.
Deriving Business Insight From Multiple Data Sources Using MicroStrategy BI Platform And IBM DB2 Information Integrator
A federated database system is a special type of database management system(DBMS). IBM’s DB2 Information Integrator offers powerful facilities for building a federated database by combining information from multiple data sources. Users of DB2 Information Integrator can submit SQL queries over views,
Using DB2 Application Development Client with SQLJ
DB2 SQLJ support, provided by the DB2 Application Development Client, allows you to create, build, and run embedded SQL for Java applications, applets, stored procedures and user-defined functions. Because SQLJ uses static SQL, it carries the advantages of improved performance (because the SQL is bo
Constraints in DB2
The DB2 DBMS offers a useful suite of methods to ensure data consistency. Primary key constraints forbid duplicate values in one or more columns of a table. Foreign key constraints ensure consistency of tuple (row) references across tables. Table check constraints are conditions that are defined
State of the Union
(Daniel F. Savarese) In the past year or two, the Java platform has been criticized for lagging behind competing platforms in integrating with XML, and Sun Microsystems has been accused of deliberately dragging its feet to adopt XML as part of its distributed computing strategy. Whatever truth there
From P2P to Web Services: Trust
(Andy Oram) In last week’s article (“From P2P to Web Services: Identification and Addressing”), I examined the ways in which the development of web services might learn some lessons from the peer-to-peer phenomenon of a few years ago. I focused on identification and addressing. In this article I con
Oracle9i OLAP uncovered
(Mark Rittman and Jon Mead) Oracle Express has for many years been the industry’s leading OLAP server, offering unparalleled functionality, query performance and application support. With Oracle9i, Oracle has taken the best features of Oracle Express and embedded them in the database kernel. By
A simple XML database for your Windows applications
(Charles Sterling) I want to create a Windows Application that allows a user to enter/edit/access data that he or she creates without connecting to a remote database. I want all of the data accessing to be local. Is this possible? I was thinking maybe using XML files to store the data and read the
A simple VB.NET stress utility for SQL Server 2000
(Alberto Venditti) As any developer knows, the tuning phase of any data access application development implies the analysis of the database response time, possibly followed by a refinement of some database design aspects (i.e. reviewing some poorly coded stored procedures or the adopted indexing str