The Office of Revenue Commissioners (Ireland) Commits to Actian Ingres Database
Company Size
1,000+
Region
- Europe
Country
- Ireland
Product
- Actian Ingres Database
Tech Stack
- Java
- SOA
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Productivity Improvements
Technology Category
- Application Infrastructure & Middleware - Database Management & Storage
Applicable Functions
- Business Operation
Services
- System Integration
About The Customer
The Office of the Revenue Commissioners (“Revenue”) is responsible for the assessment and collection of taxes and duties in the Republic of Ireland. It plays a broad and vital role in the Irish economy. In addition to collecting and administering almost all government-imposed taxes and duties (Exchequer Returns were c. €33 billion in 2009), Revenue is also responsible for the enforcement of import and export controls and the national administration of various European Union schemes, such as the exchange of VAT information between member states. It also carries out collection work for a number of other Irish government departments. As a public facing government institution, administering all personal and business taxes in the country, Revenue requires high availability and high performance for its mission-critical computer systems.
The Challenge
The Office of the Revenue Commissioners in Ireland, responsible for the assessment and collection of taxes and duties, required high availability and high performance for its mission-critical computer systems. It had adopted the Ingres database and the OpenROAD application development toolset in 1993 and had constantly upgraded to the latest versions to ensure a stable, manageable, and economical platform. However, the organization faced challenges in improving transaction processing as well as better batch and checkpoint performance. It was essential to move mission-critical systems to Actian Ingres database without any impact on live services. The organization had many databases in multiple Ingres installations, all of which support mission-critical applications either in production or at various stages of development. It was essential to have minimal downtime during the upgrade and to ensure that all applications, especially its large-scale batch applications, continued to run smoothly.
The Solution
Revenue’s upgrade to the latest open source version of Ingres for its core systems resulted in an uplift in application performance and the availability of a richer feature set. The upgrade enabled the organization to leverage improvements in performance and efficiency. Applications are now better positioned for further growth and run on a well-supported, highly-available and agile database, with emerging community contributions feeding into the Enterprise edition. Revenue has also benefited from the open source business model and more cost-efficient subscription terms. As well as its traditional transaction processing requirements, Revenue’s business model also demands increased use of business intelligence and analytics. Ability to link with a range of existing open and closed source packages, as well as ongoing technical developments such as Ingres VectorWise, have given Revenue confidence that the product will continue to evolve to meet its needs in this field.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
