(Bruce Johnson) Last year, American corporations spent over $4 billion integrating heterogeneous applications (otherwise known as Enterprise Application Integration or EAI). Why? Because one of the best ways to squeeze more profits out of a company is to reduce the costs of doing business. Among the
Other News
SQL Server 2005 – SQL Server Integration Services – Part 9
(Marcin Policht) Following an extended review of various types of Foreach Loop enumerators in the SQL Server 2005 Integration Services, we are turning our attention to other types of package components, which either did not exist in the Data Transformation Services (SSIS predecessor present in earli
Open Source Java Reporting with JasperReports and iReport
(John Ferguson Smart) JasperReports, a powerful, flexible open-source reporting engine, is easy to integrate into Java enterprise applications, but it lacks an integrated visual report editor. So, if you want to use JasperReports directly, you need to manipulate its XML report structure—a relatively
Rapid Unload / Load Oracle data using WisdomForce FastReader
This technical white paper will discuss ways for rapid Oracle data unload, extract from large production tables into portable format and load / import this data back into the database. (pdf)
Accessing Your Database with C++ Is as Easy as DTL
(Victor Volkman) In the late 1980s, when I first learned to program in C, I cobbled together data structures and algorithms from books and pretended they were generic or they could be generalized, perhaps even by macros. Invariably, however, I would end up copying them or tweaking them for every new
MySQL Trouble
(Noel Davis) Welcome to Security Alerts, an overview of recent Unix and open source security advisories. In this column, we look at problems in MySQL, umount, KDE’s kcheckpass, GNOME Workstation Command Center, X.org, Squid, TWiki, ncompress, grip, Turquoise SuperStat, gtkdiskfree, and LessTif.
Playing With MODELs: Oracle 10g SQL Enhancements, Part 3
(Jim Czuprynski) The previous article in this series reviewed Oracle 10g’s enhancements to analytical functions, including the use of partitioned outer joins to “densify” data within multiple dimensions. As that article promised, I will now delve into the new MODEL clause that grants any Oracle deve
Implementing Remote Calling Without Using AJAX
(Rajesh Toleti) Right now the latest buzzword around town is AJAX. AJAX is an acronym for Asynchronous JavaScript and XML and is a method used to implement remote calling. "Remote calling" is the exchange of information between client and server without page reloading/refreshing. When you use remote
Performance-Conscious Thread Synchronization
(Jeffrey Richter) In my career, I have architected and implemented many thread synchronization techniques. This has provided me with a lot of experience that has shaped the way I now think about thread synchronization problems. In this new column about concurrency, I will discuss my way of thinking
DB2 memory and file cache performance tuning on Linux
(Monty Wright) Database systems running on the Linux platform have become a foundation for critical business applications. DB2 Universal Database (DB2 UDB) utilizes the Linux platform well by leveraging a designed feature set unique to this platform.