How does it work?
For example, an organisation creating a data warehouse needs to move massive amounts of data from its mainframe to the data warehouse server. The IT manager faces three hurdles: preparing the data on the mainframe; transferring it; and loading it into the data warehouse tables.
The first hurdle can be overcome by using programs to extract data from the database. Secondly, FTP can be used to transfer the data to the data warehouse server, and the third part is handled by data warehouse software.
Typically, the time-consuming element lies in transmitting the data, shortening this leg requires that the data is compressed first and then decompressed when it arrives at the data warehouse server.
The table below shows the times taken to transmit raw data compared to that required to compress it up front using InfoZip's zip utility for S/390 and ZIPDITTO.
for more information on this product.