Provision of data for data warehousing applications

US7480671B2 · kind B2 · utility

Assignee

• SAP AG · DE

Inventors

• Karsten Bruening · Portola Valley, US
• Georg Dopf · Schwetzingen, DE
• Stefan Gauger · Heidelberg, DE
• Danny Pannicke · Heidelberg, DE
• Rolf Schumann · Annaberg-Buchholz, DE
• Peter Schwarz · Speyer, DE
• Juergen Alfred Seyfried · Walldorf, DE
• Andreas Reccius · Walldorf, DE

Key dates

• Filing date: Sep 2, 2004
• Grant date: Jan 20, 2009
• Expiry date: Feb 7, 2026

Classification

• Technology area (CPC Y): Emerging Cross-Sectional Technologies
• CPC primary: Y10S707/99953
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

A computer network architecture for making procurement-related information that has been generated on a transaction level available to data warehousing techniques is described. The network includes a transaction processing layer with at least one accounting component with a general ledger data base for centrally storing information contained in accounted-related data sets, a data warehousing layer and an additional data sourcing layer. A duplicator receives the data sets that will be or have been stored in the general ledger data base and delivers duplicates of those data sets that fulfill a predefined criteria in a procurement context. A source data base stores the duplicated data sets on a data line level. An extractor of the data sourcing layer interfaces with the data warehousing layer and selectively moves data contained in data lines or sets of data lines from the source data base to the data warehousing layer.