Combining operation in multi-column table and at least two satellite tables in relational database management system, involves generating returned values or entries for every double value in both tables

摘要

Rows of dimension table are combined to generate linked-up rows which are then combined with facts table. Returned entry received from fact table is verified to determine whether it meets search criteria. If it meets criteria, it is determined whether both tables have double values or entries in the combining columns and the returned values or entries are generated for every double value in both tables. Independent claims are also included for the following: (a) Facts and dimension column table combining system; (b) Program for connecting facts and dimension table