(Frank Nimphius and Duncan Mills) In a very short time, J2EE Web technologies have evolved from a static content serving environment to a reliable platform for dynamic business applications that run on the intranet and the internet. The promise of the Web is that in the future the browser is the onl
Other News
Develop wireless apps with XHTML Mobile Profile
(Hany Saleeb) The focus of most mobile technology applications developers is to build new wireless technologies that conform to varying bandwidth and memory limitations. With XHTML Mobile Profile, you can build apps that adhere to hardware requirements for users on different devices and render on mu
Data Warehouse ETL Performance Tuning – Case Studies
(Tao Zheng) As production data warehouse extract, transform and load (ETL) can be a very time-consuming and resource-intensive task, plus the fact that the ETL window has become increasingly shortened while data size is exploding, there is always pressure on data warehouse developers and managers to
‘Wouldn’t it be Nice’ (start humming the old Beach Boy’s song)
(Willie Favero) In 1966 “the Beach Boys” coined the phrase “Wouldn’t it be Nice” in one of their hit singles. Everyone has a “Wouldn’t it be Nice” list in the back of their mind for something. Some even have a list for stuff they would like to see someday in DB2. So, I thought an entry talking about
Enable OLAP report globalization feature using DB2 Alphablox with DB2 Cube Views
(Jin Ji Wen and Shen Yu) Today, many exciting business events take place in non-English speaking regions. For example, Arabs are leading in the petroleum business and the Chinese are leading in the textile space. Merchants from these countries or regions feel more at ease when communicating in their
Asked & Answered
(Roger E. Sanders) Q: In your recent column on split mirroring [Distributed DBA, Quarter 4, 2005], you write that the SET WRITE RESUME command must be executed from the same database connection that has executed the SET SUSPEND command. What do you do when this session has abended? (The same problem
Faster Batch Processing
(Mark Rittman) When you need to load millions of rows of data into a table, the most efficient way is usually to use an INSERT, UPDATE, or MERGE statement to process your data in bulk. Similarly, if you want to delete thousands of rows, using a DELETE statement is usually faster than using procedura
SQL and XML: Use XML to Invoke and Return Stored Procedures Over the Web
(Dave Grundgeiger, Anson Goldade and Varon Fugman) Like many developers, we are finding that our n-tier line-of-business projects are evolving from traditional Windows-based clients to generic browser-based ones. Such systems use Microsoft Internet Information Services (IIS) and ASP for Web page del
Cleaner Page Loads with AJAX
(Marshall Lager) What can companies do when they need granularity in their dashboards? The answer is, clean them up with AJAX. Most companies already have experienced AJAX (Asynchronous JavaScript and XML), with Google Maps or the photo-sharing service FlickR. The rich Internet application (RIA) ref
Oracle unveils free SQL Developer: Has Toad met its match?
(Mark Brunelli) Oracle’s free SQL Developer could mean trouble for Quest Software Inc.’s widely used Toad for Oracle software. (R)