System and method to logically ROLLUP/ROLLDOWN Entities intelligently in a logical data model in real time at any level using a relationships
Publication Date: 2010-Dec-13
The IP.com Prior Art Database
Disclosed is a system and method to logically ROLLUP/ROLLDOWN entities intelligently in a logical data model at any logical level using any logical model relationship (Generalizations/Mandatory/Non mandatory relationships). The desired relationships a user is interested in and logical levels are configurable using the user interface.The entity (attributes) can be RolledUp/RollDown and simultaneously configured to a desired entity Level.
Page 01 of 2
System and method to logically ROLLUP /ROLLDOWN Entities intelligently in a logical data model in real time at any level using a relationships
A Data Modeller should be able to define roll up and down simultaneously on entities in a logical data model at a logical level in real time. For example, for an entity - in context, a transform property Rollup/Rolldown and a level, numerical value from 1..n can be defined using a user interface. All the unique attributes inherited from the super/sub type entities at the configured level would be visualised in real time chosen entity in context. The advantage of this is , if searching for a particular attribute say "Credit Limit" for an "Arrangement" entity , It might be the case that "Credit Limit" is defined in the entity "Credit Limit Arrangement" which might be hidden in the context, if the focus is "Arrangement" entity because "Credit Limit Arrangement" entity might be deeply nested in a sub/super type relationship hierarchy , It would be make data model development more efficient to see from the context of "Arrangement" entity that an attribute "Credit Limit" is already defined as part of "Credit Facility Arrangement" entity and how "Arrangement" entity and "Credit Facility Arrangement" entity are linked together. It is also possible to trace attributes down from "Arrangement" not specifically using the Super/Sub type but any Relationship in general at any level defined by the user.
Fig 1 below shows a snippet of a typical logical data model. Note, the Super/Sub Type entity relati...