GenevaERS is an enterprise reporting system that currently executes in the IBM mainframe z/OS environment.[1] It is similar to MapReduce or Apache Spark but predates their development by a decade. It has been used as a data warehousing ETL, reporting, and application development platform.[2] It was designed to support business systems using William McCarthy's theory of Resources, Events, Agents.[3]
GenevaERS was created by PricewaterhouseCoopers Consulting as part of their practice.[4] (IBM acquired PwC Consulting in 2002.)[5] IBM renamed GenevaERS IBM's Scalable Architecture for Financial Reporting (SAFR), marketing and licensing it through its IBM Global Services division, typically with customer-specific services. The product solves business intelligence problems for large operational databases, especially in insurance and financial industries.[6] GenevaERS is also popular among SAP and other ERP system users, including manufacturing companies, with large databases and significant reporting needs.[7] (Despite the SAFR name, GenevaERS is not confined to financial industry roles.) In July 2020, IBM contributed the SAFR code base to the Linux Foundation's Open Mainframe Project,.[8]
GenevaERS uses a "single pass" I/O approach and takes advantage of the IBM mainframe's parallelism to create multiple reports concurrently. The software is CPU-efficient, with an internal capability to execute report queries using generated, high-performance IBM Z assembler code. Most GenevaERS users run reports daily, overnight, during a batch window, but jobs can run at any time, including concurrently and without disruption to online workloads. IBM continues to offer a commercial version of GenevaERS under the SAFR name which is able to exploit zIIPs
Additional GenevaERS performance optimizations include in-memory join processing, either direct access or through a technical called Common Key Buffer joins for very large dimensional tables, piping from one process to another, and Extract-Phrase Record Aggregation] to immediately collapse data for summary outputs.
Although GenevaERS can access multiple types of mainframe-based data, including Db2 and VSAM, like MapReduce, GenevaERS's higher performance comes with the use of sequential files. GenevaERS processes are called VIEWSs, and any number of VIEWs can be run in one pass of the data. These VIEWS can be defined through the graphical user interface termed the Workbench.[9]
See also
editReferences
edit- ^ Practical s/390 Parallel Processing Option for Data Warehouses Archived 2021-03-01 at the Wayback Machine, Price Waterhouse Published White Paper November 8, 1995 by Richard K. Roth, Principal Price Waterhouse LLP, Sacramento, California.
- ^ Platform Assignment Principles for Decision Support Systems and Data Warehouses in Manufacturing Systems, Chilton Publications, February, 1996 by Richard K. Roth, Principal, Price Waterhouse LLP and Eric L. Denna, Ph.D., Warnick/Deloitte & Touche Faculty Fellow, Brigham Young University, Marriott School of Management
- ^ The REA Accounting Model: Intellectual Heritage and Prospects for Progress. Dunn, Cheryl & Mccarthy, William. (1997) Information Systems Journal - ISJ. 11.
- ^ Geneva ViewBuilder Archived 2021-04-17 at the Wayback Machine Price Waterhouse Announcement, 1994
- ^ IBM to acquire PwC Consulting for $3.5 billion By Linda Rosencrance, Computerworld, Jul 30, 2002 12:00 AM PST
- ^ Exploiting IBM SAFR to Solve Financial Accounting Challenges An IBM Redguide publication, Published 29 September 2010, updated 18 August 2011, Alex Louwe Kooijmans, et al. p. 9 – 13
- ^ SAP High-Volume Operational Reporting/Data Warehousing: Summary of Sizing Concepts and Architectural Alternatives Archived 2021-03-01 at the Wayback Machine Price Waterhouse Published Whitepaper by Richard K. Roth September 15, 1996
- ^ Open Mainframe Project Welcomes New Project Tessia, HCL Technologies and Red Hat to its Ecosystem News Release: Dec. 17, 2020
- ^ Exploiting IBM SAFR to Solve Financial Accounting Challenges An IBM Redguide publication, Published 29 September 2010, updated 18 August 2011, Alex Louwe Kooijmans, et al. p. 13-15, 21