Historical data warehousing system

US7143099B2 · kind B2 · utility

Assignee

• AMDOCS SOFTWARE SYSTEMS LIMITED · IE

Inventors

• Ruth Lecheler-Moore · Rancho Murieta, US
• Tom Serio · Davis, US
• Kirven Dunham · Rancho Cordova, US
• Larry T. Riggs · Roseville, US

Key dates

• Filing date: Feb 8, 2001
• Grant date: Nov 28, 2006
• Expiry date: Mar 18, 2024

Classification

• Technology area (CPC Y): Emerging Cross-Sectional Technologies
• CPC primary: Y10S707/99945
• WIPO field: IT methods for management
• WIPO sector: Electrical engineering

Abstract

Utilizing change data capture methodology, a computer facilitated historical data warehousing system accepts transactional/operational data having no directly tied dates from a legacy source system and processes that data into a subject-oriented format that is optimized for analytical and query reports via a two step process comprised of pre-processing and transforming. The pre-processing step entails a serial modification of data with only the last modification being recorded. The transforming step involves linking related data by utilizing reusable primary keys and dates obtained from an RDBMS in an operation system of the legacy source system that supplied the transactional/operational data.