FACETED INTERACTION INTERFACE TO OBJECT RELATIONAL DATA

摘要

A method, system and computer program product to generate selected tabular data from an object relational data model using a faceted interaction interface may include providing a faceted interaction interface to specify a faceted query to provide the selected tabular data from the object relational data model. The faceted query may include at least one facet and at least one facet condition. The method may also include constructing an object relational graph from a plurality of input object tables of the object relational data model. The method may also include selecting each object in the object relational graph which contains at least one facet and identifying each object in the object relational graph on which at least one facet condition applies. The method may additionally include generating at least one object group from the object relational graph. Each object group may include a path from a top level object which contains at least one facet in the object relational graph to an object which contains at least one facet and which does not have any children in the object relational graph. The method may further include generating an object table for each object group, wherein the object table comprises selected tabular data from the object relational data model.