Simplified definition of the automated dimensional model utilizes the discovery type analysis (analysisheuristics) and construction system for a method and apparatus

摘要

The present invention leverages interrelationships of a relational schema by utilizing simplified analysis heuristics to define and build dimensional models automatically. A user can also participate interactively in both the definition and building processes to influence an outcome. The relational schema is comprised of relational databases and the like. The dimensional models are comprised of OLAP objects and the like such as ROLAP and MOLAP objects. A means is also provided for allowing a user to initiate via a single user action, such as a single computer mouse click, defining a dimensional model, building a dimensional model, and/or both defining and building a dimensional model.