Patent ID: 9110935
Filing Date: 2015-08-18
Classification: G06F

Abstract:
1. An article of manufacture including a non-transitory computer readable storage medium to tangibly store instructions, which when executed by a computer, cause the computer to: determine a first pattern comprising a first table with one join and a one-to-many join relationship with a second table; based on the determined first pattern, generate a first attribute view with the first table and the second table; determine a second pattern comprising a fact table with more than two joins, more than one numeric field and a many-to-one join relationship with one or more adjoining tables in a star schema; based on the determined second pattern, generate an analytic view with the fact table and the one or more adjoining tables of the fact table; determine a fourth pattern comprising a fourth table with more than two joins and a many-to-one join relationship with a fifth table, wherein the fourth table is not the fact table; and based on the determined fourth pattern, generate a second attribute view with the fourth table and the fifth table.