Enterprise information management system and methods

US6668253B1 · kind B1 · utility

Assignee

• THE REYNOLDS AND REYNOLDS COMPANY

Inventors

• Michael Thompson · Xenia, US
• Tal D. Burkhart · Kettering, US
• Lisa D. Smith · Kettering, US
• Gregory P. Niehoff · Miamisburg, US
• Jamie A. Ward · Kettering, US
• Julie L. Horan · Dayton, US
• Mark Jung · Lewisville, US
• Rayapa S. Datla · Dayton, US
• Safdar R. Syed · Dayton, US
• Satya Sarika Sunkara · Sangareddy, IN
• Carol M. Hergenrather · Dayton, US
• Mary J. Matthews · Dayton, US
• Teresa J. Johnston · Miamisburg, US
• Elizabeth E. Campbell-Kaminski · Dayton, US

Key dates

• Filing date: Aug 30, 2000
• Grant date: Dec 23, 2003
• Expiry date: Nov 8, 2021

Classification

• Technology area (CPC G): Physics
• CPC primary: G06Q10/06
• WIPO field: IT methods for management
• WIPO sector: Electrical engineering

Abstract

A system for enterprise information management includes a data warehouse server; a transformation and staging server connected to the data warehouse server for providing transformed and cleansed data to the data warehouse server; a data source application connected to the transformation and staging server to provide data to the transformation and staging server, wherein the transformation and staging server obtains data from the data source application via requests and places the data into temporary staging tables to prepare for the transformation and cleansing process prior to movement of the data to the data warehouse server; a financial consolidation application connected to the transformation and staging server for performing consolidation and reporting of financial data; a web server connected to the data warehouse server; and a plurality of clients connectable to the web server for accessing data from the data warehouse server via the web server.