Patent ID: 9442862
Filing Date: 2016-09-13
CPC Classification: G06F

Claim Text:
1. A method for managing a database in a data-processing system, the method comprising: providing a polymorph table and a mapping table for a set of virtual tables, each virtual table comprising a plurality of virtual columns having one or more data types, wherein each of the plurality of virtual columns has a corresponding data type of the one or more of data types; wherein the polymorph table comprises: wherein the mapping table is configured to map each virtual column of the set of virtual tables to a corresponding polymorph column of the plurality of polymorph columns in the polymorph table, wherein the corresponding polymorph column of each virtual column has the same data type as the virtual column; receiving from a user a virtual access request for accessing at least part of the virtual tables, the virtual access request being based on at least a selected virtual column of the plurality of virtual columns of at least a selected virtual table of the set of virtual tables; retrieving from the mapping table selected mapping information mapping the selected virtual column to a selected polymorph column of the plurality of polymorph columns in the polymorph table, wherein one or more other virtual columns, of the plurality of virtual columns of the set of virtual tables, in addition to the selected virtual column map to the selected polymorph column; converting the virtual access request into a polymorph access request for the polymorph table according to the identifier of said at least one selected virtual table and the selected polymorph column; accessing the polymorph table according to the polymorph access request; and returning to the user a result of accessing the polymorph table according to the polymorph access request.