Patent ID: 8010909
Filing Date: 2011-08-30
Classification: G06F

Abstract:
1. A method for creating derived hierarchies for visualization and editing of data stored in a relational database, comprising: accessing a relational data model that is stored within the relational database; determining a plurality of data entities and relationships of the relational data model; maintaining a plurality of information on a structure of the relational database within a schema of control tables in the relational database; using same graphical user interface, interactively defining the derived hierarchies to impose on the relational data model stored in the relational database, wherein each of the defined derived hierarchies comprises levels that are interactively defined in either one of: a top to bottom manner and a bottom to to manner using the graphical user interface and wherein after an entity for each level is defined, displaying and restricting in the graphical user interface, choices for entities at a next level based on an attribute relationship of the data entities of the relational data model with the defined entity for each level; storing definition information for the defined derived hierarchies within the schema of control tables, wherein each of the defined derived hierarchies is usable to present a different hierarchical visualization of data of the relational data model stored in the relational database without duplication of data of the relational data model that is shared between multiple ones of the defined derived hierarchies; presenting one of the hierarchical visualizations of data of the relational data model stored in the relational database on a user interface display using any one of the defined derived hierarchies; and automatically editing data of the relational data model stored in the relational database by editing of the hierarchical visualization of data presented on the user interface display.