Patent ID: 9116959
Filing Date: 2015-08-25
Classification: G06F,Y10S

Abstract:
1. A method of implementing behavior of a user defined type in a database management system comprising: providing a Cartesian product; generating a query having said Cartesian product so that said query is optimized with said Cartesian product after said Cartesian product has been formed; providing a database on a computer, said database having a data table with multiple rows; generating within said database a user defined type (UDT) table having only a single row; creating an instance of a UDT having persisted objects; storing said instance of said UDT having said persisted objects within said single row of said UDT table; and implementing on said computer said query having said Cartesian product to join said single row UDT table and said data table, whereby using said query having said Cartesian product behavior of said instance of said UDT is invoked on said single row UDT table and said data table to generate a resultant data table having an equivalent cardinality as said data table, said resultant data table being generated after formation of said Cartesian product.