Store card provider implements Oracle 10g system to ensure around-the-clock service

PrePay Technologies, which runs prepaid debit card, gift card and travel card schemes for retailers, has implemented an Oracle 10g database.

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



Enjoy the benefits of CW+ membership, learn more and join.

Read more on Privacy and data protection



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:




  • Dissecting the Hack

    In this excerpt from chapter three of Dissecting the Hack: The V3RB0TEN Network, authors Jayson E. Street, Kristin Sims and Brian...

  • Digital Identity Management

    In this excerpt of Digital Identity Management, authors Maryline Laurent and Samia Bousefrane discuss principles of biometrics ...

  • Becoming a Global Chief Security Executive Officer

    In this excerpt of Becoming a Global Chief Security Executive Officer: A How to Guide for Next Generation Security Leaders, ...