- 专利标题: Maintaining cardinality of rows while joining worksheets from a database
-
申请号: US17682866申请日: 2022-02-28
-
公开(公告)号: US12118005B2公开(公告)日: 2024-10-15
- 发明人: Jason D. Frantz , Max H. Seiden , James L. Gale , Kenneth Truong
- 申请人: SIGMA COMPUTING, INC.
- 申请人地址: US CA San Francisco
- 专利权人: SIGMA COMPUTING, INC.
- 当前专利权人: SIGMA COMPUTING, INC.
- 当前专利权人地址: US CA San Francisco
- 主分类号: G06F15/16
- IPC分类号: G06F15/16 ; G06F16/23 ; G06F16/2455
摘要:
Maintaining cardinality of rows while joining worksheets from a database including receiving a request to join, to a first worksheet, a second worksheet from the database; for each row in the first worksheet: generating a join row for data from the second worksheet on the database; in response to determining that there is at least one matching row in the second worksheet on the database: compare a maximum value and a minimum value for each column in each row of the at least one matching row; if the maximum value and the minimum value match, store a matching value in a corresponding column of the join row; and if the maximum value and the minimum value do not match, store a multiple value indication in the corresponding column of the join row; and presenting the join row adjacent to a corresponding row in the first worksheet.
公开/授权文献
信息查询