Faceted interaction interface to object relational data

A system to generate selected tabular data from an object relational data model using a faceted interaction interface, the system comprising:

• a processor;
• a module, operating on the processor, to generate selected tabular data from an object relational data model using a faceted interaction interface, the module comprising:
• a module to provide a faceted interaction interface to specify a faceted query to provide the selected tabular data from the object relational data model, wherein the faceted query comprises at least one facet and at least one facet condition;
• a module for constructing an object relational graph from a plurality of input object tables of the object relational data mode, wherein constructing the object relational graph comprises creating a node of the object relational graph corresponding to each input object table;
• a module for selecting each object in the object relational graph which contains the at least one facet;
• a module for identifying each object in the object relational graph on which the at least one facet condition applies;
• a module for generating at least one object group from the object relational graph, each object group comprising a path from a top level object or node which contains the at least one facet in the object relational graph to an object or node which contains the at least one facet and which does not have any children in the object relational graph;
• and a module for generating an object table for each object group, wherein the object table comprises selected tabular data from the object relational data model.

A computer program product to generate selected tabular data from an object relational data model using a faceted interaction interface, the computer program product comprising:

• a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
• computer readable program code configured to provide a faceted interaction interface to specify a faceted query to provide the selected tabular data from the object relational data model, wherein the faceted query comprises at least one facet and at least one facet condition;
• computer readable program code configured to construct an object relational graph from a plurality of input object tables of the object relational data model, wherein
• constructing the object relational graph comprises creating a node of the object relational graph corresponding to each input object table;
• computer readable program code configured to select each object in the object relational graph which contains the at least one facet;
• computer readable program code configured to identify each object in the object relational graph on which the at least one facet condition applies;
• computer readable program code configured to generate at least one object groups from the object relational graph, each object group comprising a path from a top level object which contains the at least one facet in the object relational graph to an object which contains the at least one facet and which does not have any children in the object relational graph;
• and
• computer readable program code configured to generate an object table for each object group, wherein the object table comprises selected tabular data from the object relational data model.