(Sergo Grigalashvili and Sanjeev Malik) Today’s enterprise-wide systems are becoming increasingly sophisticated with a variety of operating systems and software development platforms. This presents the constant challenge of integration, which requires creative ways of configuring products from multi
Other News
Create tables and indexes more efficiently in IDS 9.4
(Jianing Fan) If you are an Informix DBA, do you want to know how to create tables and indexes more efficiently? In order to achieve better performance, you need to think of the physical aspect of your database before you create tables and indexes. The author elaborates on each of those consideratio
Data Definition Language, Part 1 (Sample Chapter)
(Paul Dubois) This chapter covers the following exam topics: –General database and table properties –Storage engines and table types –Limits on number and size of database components –Identifier syntax –The CREATE DATABASE and DROP DATABASE statements –The CREATE TABLE, ALTER TABLE, an
LEO: An autonomic query optimizer for DB2
(V. Markl, G. M. Lohman and V. Raman) Structured Query Language (SQL) has emerged as an industry standard for querying relational database management systems, largely because a user need only specify what data are wanted, not the details of how to access those data. A query optimizer uses a mathema
Function: Export a Dataset to Microsoft Excel without the use of com objects
(Xodiak) This Function takes in a DataSet and File Name, and writes the dataset to an excel worksheet. The code is pretty straightfoward. Great thing about this function is that its technically an XML file that is saved as a XLS file, so it can be used as either file format. No more leading zero tru
Slew of Fears Slows Open-Source Uptake
(Darryl K. Taft) The biggest question facing open-source developers is, after Linux, what can be done to spur efforts toward complete open-source software stacks?
XML Options in Microsoft SQL Server 2005
Three options for handling XML data in the Visual Studio 2005/SQL Server 2005 environment are discussed, including usage scenarios and guidelines to help you choose between them.
Partitioned Tables and Indexes in SQL Server 2005
(Kimberly L. Tripp) Table-based partitioning features in SQL Server 2005 provide flexibility and performance to simplify the creation and maintenance of partitioned tables. Trace the progression of capabilities from logically and manually partitioning tables to the latest partitioning features, and
Daffodil Replicator Released with support for DB2
(Rohit Malhotra) Daffodil Software, a Java database and replication technology company, has released Daffodil Replicator v1.6 (an open source data replication tool), equipped with the much awaited IBM DB2 support. This version also provides for increased performance and high data availability.
Reviewing the Architecture of the World Wide Web
(Harry Halpin) The most significant networked application development yet is the World Wide Web, which has made the the personal computer a must-have item, and a web address as crucial as a phone number for a successful business. This is only the beginning; from web services to the Semantic Web, the