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]
^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
GenevaERS is an enterprise reporting system that currently executes in the IBM mainframe z/OS environment. It is similar to MapReduce or Apache Spark...
VSAM. Job Control Language (JCL) IBM mainframe utility programs ISAM GenevaERS Record Management Services, a similar system developed by Digital Equipment...
RightIndem, OSG, Aviva PLC, Chair of specialist Lloyd's of London motor insurer ERS, and chair of the Welsh Professional Rugby Board, a voluntary position. Blanc...
World through subordination to the West. TWAIL scholars (known as TWAIL-ers) seek to change what they identify as international law's oppressive aspects...
original on May 12, 2022. Retrieved May 12, 2022. Bank of Canada says #Bitcoin-ers lack financial literacy. This from the same people who promised we'd have...
non-invasive tumor with better prognosis.[citation needed] In 2011, the IASLC/ATS/ERS classification recommended discontinuing the BAC classification altogether...
coordination. INSARAG Secretariat is hosted in the Emergency Response Section (ERS) of the Response Support Branch (RSB) (which was called in the past "Field...
Masarykovo Square Jihlava Czech Republic 36,653 394,530 1270 Square of the 56-ers Budapest Hungary 36,500 393,000 Approx. 730 by 50 m (2,400 by 160 ft) (excluding...
original on 28 May 2018. Retrieved 6 April 2019. "Schedule of Train.No.12283/ERS-NZM-26A" (PDF). Railway Board. Indian Railways. October 2016. p. 192. Archived...
electrical equipment on-board a vehicle powered by a rail electric road system (ERS), CENELEC Technical Standard 50717, has been approved in late 2022. Following...
000 km (2,500 mi) before being replaced and have the KERS (now known as ERS-K) integrated into it. New penalty points system introduced, teams must nominate...
classification system in 2022 (with adaptations from the more recent ESC/ERS guidelines shown in italics) can be summarized as follows: WHO Group I –...
regardless of the duration of an assignment. Reliability Status, Enhanced (ERS) In addition to the Reliability Status, Standard checks, open-source checks...
Team for the co-development of the Power Unit's Energy Recovery System (ERS), including relocating several of their specialists to the Renault F1 Team's...
Service (ARS) National Agricultural Library (NAL) Economic Research Service (ERS) National Agricultural Statistics Service (NASS) National Institute of Food...
neurons also can stimulate GnRH-1 release. These GABA neurons also possess ERs and may be responsible for the GnRH-1 surge. Part of the inhibitory action...
certified organic farmland acreage, livestock numbers, and farm operations". ERS/USDA Data- Organic Production. Retrieved 2 March 2011. United States Department...
tellers at elections", The Scotsman, 19 April 2006 "Green light for DRS & ERS to deliver e-Count for 2007 Scottish Elections", press release, DRS Data...
S. honey bee colony numbers are stable". Economic Research Service. www.ers.usda.gov. United States Department of Agriculture. Retrieved 29 January 2019...
Degree of Rurality of County of Primary Work Site "USDA ERS - Rural-Urban Continuum Codes". Ers.usda.gov. Retrieved 2019-02-05. ""Malpractice Consult:...