BNZ division slims database
- 23 May, 2002 22:00
BNZ Investments and Insurance expects its use of data archiving technology to markedly reduce the size of its databases.
Active Archive should make day-to-day operations faster because it will reduce out-of-date and irrelevant material, says senior business solutions analyst Moyeen Kabir. The tool, from US-based Princeton Softech, will also speed backups and disaster recovery.
The bank’s investments and insurance division is currently implementing the technology to sit over its Sybase database. Database shrinkage of 15–30% could be achieved, says Talisman systems team leader James Dobson. However he emphasises that the achievability of this target has not been tested in practice. The unit acquired Active Archive on the strength of a third-party recommendation and a cost comparison with developing similar software in-house, he says.
The distinguishing feature of Active Archive is that it can take interconnected portions of a relational database and conserve the relations among the fields on the archive record. That means table rows relating to a particular customer or event can be easily replaced in the main database if needed again.
Talisman, the insurance and investment software suite used by the division, was developed by the locally headquartered Tacit Group. The local agent for Active Archive is Wellington-based ITB.