AAH Pharmaceuticals deploys Ingres Database

AAH has several business critical applications to ensure smooth, beneficial relationships with manufacturers and suppliers. The tech-savvy pharmaceutical company has seven databases for internal and external use to manage data on stock, sales, invoicing, and customer service. Thanks to the ease of management and robust performance of Ingres, AAH is now able to run mission critical applications seamlessly every day, on a future-proof platform.

“With Ingres, we have lowered our operation costs by as much as 50 percent compared to three years ago because we aren’t locked into licensing anymore, but rather a subscription model where we pay per chip we use,” said Richard David, database administrator, AAH.

In addition, AAH has improved the speed and flexibility of its databases. The higher availability and significantly better response time of the new system means that AAH can do more in much less time.

“Our users are able to run ad-hoc queries that simply couldn’t be run before, due to limitations on performance and functionality,” said Geraint Jones, product manager, AAH. “The scalability of the new systems means we’re able to leave our databases up for longer and have shaved just over an hour off our overnight batches.”

“The finance department is able to run reports that they could never think of running before,” added David. “Reports that once took hours are now taking a matter of minutes.”

The Ingres team worked along with AAH’s in-house database administrator to deploy Ingres Database across seven main production databases, totaling nearly 600 gigabytes of data. To ensure minimal downtime, each database was rolled out individually. The switch to open source also allowed AAH the flexibility to choose virtually any operating system and integrate with AAH’s commodity Linux servers.

“AAH Pharmaceuticals represents another success story for Ingres,” said Steve Shine, executive vice president of worldwide operations, Ingres. “More and more organizations are realizing that open source is the way to save money and effectively manage all the mission critical applications to keep the business running smoothly on a day-to-day basis.”