Patent ID: 8868496

Claim:
A computer-implemented data processing system, comprising: a memory device storing: a relational database comprising database tables and relationships, the database tables comprising data belonging to a plurality of entities, and further comprising primary and foreign keys, wherein the primary and foreign keys define relationships between database tables, the relationships constituting one or more relationship paths, each relationship path having a root; instructions of a first program; and instructions of a second program; a first processor executing the instructions of the first program to: display a list of the entities; receive a user selection of one of the entities; and process data belonging to the user-selected entity; and a second processor executing the instructions of the second program to: store a mapping table, wherein the mapping table assigns a main table to the user-selected entity, the main table including a portion of the data belonging to the user-selected entity, wherein the main table is the root of relationship paths among related tables that relate to the user-selected entity; generate a self-contained temporary table by reading the main table assigned to the user-selected entity, resolving the relationship paths between database tables that contain data of the user-selected entity, and reading the related tables, wherein the self-contained temporary table contains data of the user-selected entity, and wherein the primary and foreign keys are omitted from the self-contained temporary table; and provide the temporary table to the first program, wherein the first program processes self-contained tabular input; and the instructions of the second program comprise instructions for implementing an object oriented model.