PrePay Technologies, which runs prepaid debit card, gift card and travel card schemes for retailers, has implemented an Oracle 10g database.
From its two UK datacentres the company supports major programmes and manages several million card accounts for retailers such as Debenhams, Comet, Arcadia and Laura Ashley.
To be certified by Mastercard, PrePay needed to ensure its database system would run around the clock. Any unscheduled downtime would result in PrePay making penalty payments Mastercard.
To ensure this the company implemented Oracle Database 10g and Real Application Clusters (RAC). Data held in RAC is mirrored at PrePay Technologies' second datacentre, which operates as a disaster recovery site.
RAC, implemented in conjunction with Network Centric Solutions, is Oracle's cluster database designed to overcome the limitations of traditional approaches to data storage and provide scalable, high-availability databases for business applications.
Garry Comley, chief technology officer at PrePay Technologies, said, "Oracle's grid infra- structure will provide us with the additional strengths required for our datacentres and the performance and the reliability that we need."
The project involved bringing together PrePay's disparate IT systems using Oracle 10g running on Sun V440 hardware.
The primary datacentre runs Oracle 10g configured with Oracle RAC using a two-node Sun V440 server. The second site runs one V440 database cluster. Storage is provided through a Sun Storedge 3550 Fibre Channel array.
David Austin, production support team leader at PrePay Technologies, who led the Oracle implementation project, said, "We are using Oracle Streams to replicate data between the two sites."
The project took eight months to develop and went live in time for Christmas. The system holds information on 20 million card accounts.
Terry Lomax, database administrator at PrePay Technologies, said, "Over Christmas our two major clients put through 12 transactions per second between them."
The company is now planning to update from Oracle version 10.1.04g to 10.2g.
This was first published in January 2006