Data loader for handling imperfect data and supporting multiple servers and data sources

• US 20030061226A1
• Filed: 09/25/2002
• Published: 03/27/2003
• Est. Priority Date: 09/25/2001
• Status: Abandoned Application

• Current Assignee: Virtual Strategy, Inc.
• Original Assignee: Virtual Strategy, Inc.
• Inventors: DE Veau, Jason, Ahmed, Diar, Bowman, David M., Fuller, Ryan, DiPasquale, Nicholas
• Application Number:
  US10/254,899
• Publication Number:
  US 20030061226A1
• Time in Patent Office: Days
• US Class Current: 707/100
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/30 of unstructured textual data document management systems G06F16/93
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A data storage and analysis system for modeling complex systems and the outcome of decisions and potential alternatives. The system employs a hierarchical hybrid data model with high volumes of data organized in many dimensions, such as models of organization and business operations. A “wizard-based” data loader handles imperfect data and supports multiple servers and data sources. The structures that represent the hierarchical model for the data are defined and created as the backbone for the model using spreadsheets, multiple relational database tables, and other sources of data that may reside on one or more servers. The hierarchical hybrid data model that is built also supports the linking of many different sources of data to the model'"'"'s hierarchies. Analytics generators called “microCubes™” generate answers to ‘questions’ based on the server model as they are requested. Scenario management tools are provided for creating alternate scenarios linked to hierarchical hybrid data model to provide ‘what if’ analysis.

Claims

1. A data storage and analysis system comprising, in combination,

means for storing data organized into a hierarchical structure establishing parent-child relationships between data objects,

one or more data storage servers for storing a plurality of data sources including relational database tables,

a data loader responsive to user inputs for transferring data from specified ones of said sources of data to specified ones of said data objects, said data loader further including means for defining additional data objects in said hierarchical substructure, and means for defining links between data objects within said hierarchical data structure,

means for verifying the validity of specified items of data from said sources of data, and

means for transferring any invalid data identified by said means for verifying into a predetermined storage location in said hierarchical structure.