Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

System and method to logically ROLLUP/ROLLDOWN Entities intelligently in a logical data model in real time at any level using a relationships

IP.com Disclosure Number: IPCOM000202310D
Publication Date: 2010-Dec-13
Document File: 2 page(s) / 73K

Publishing Venue

The IP.com Prior Art Database

Abstract

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.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 56% of the total text.

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...