公开(公告)号：DE10028688A1

公开(公告)日：2001-06-28

申请号：DE10028688

申请日：2000-06-09

Applicant: IBM

Inventor： CHEN STEPHEN YAO CHING ,  MALONE PATRICK MICHAEL ,  MUKAI JERRY ,  RUGGLES JEFFREY RALPH ,  SAMPATRAI DESAI PARAMESH ,  WANG YUN ,  ZHANG GUOGEN

IPC: G06F17/30

Abstract: 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

公开(公告)号：DE10028688B4

公开(公告)日：2010-02-04

申请号：DE10028688

申请日：2000-06-09

Applicant: IBM

Inventor： CHEN STEPHEN YAO CHING ,  MALONE PATRICK MICHAEL ,  MUKAI JERRY ,  RUGGLES JEFFREY RALPH ,  SAMPATRAI DESAI PARAMESH ,  WANG YUN ,  ZHANG GUOGEN

IPC: G06F17/30

Abstract: Disclosed is a method, system, and program for performing a join operation on a multi-column table and at least two satellite tables having a join condition. Each satellite table is comprised of multiple rows and at least one join column. The multi-column table is comprised of multiple rows and at least one column corresponding to the join column in each satellite table. A join operation is performed on the rows of the satellite tables to generate concatenated rows of the satellite tables. One of the concatenated rows is joined to the multi-column table and a returned entry from the multi-column table is received. A determination is then made as to whether the returned entry matches the search criteria. If so, a determination is made as to whether one of the satellite tables has duplicates of values in the join column of the returned matching entry or the multi-column table has duplicate entries in the join columns. Returned matching entries are generated for each duplicate value in the satellite tables and duplicate entry in the multi-column table.