US 12,461,913 B2
Building cross table index in relational database
Hong Mei Zhang, Beijing (CN); Shuo Li, Beijing (CN); Xiaobo Wang, Beijing (CN); and Sheng Yan Sun, BeiJing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Nov. 18, 2021, as Appl. No. 17/455,490.
Prior Publication US 2023/0153300 A1, May 18, 2023
Int. Cl. G06F 16/2453 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/24537 (2019.01) [G06F 16/2282 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
receiving a first query, wherein the first query is a standard query language (SQL) query, the first query is configured to perform a first command that accesses a first column of a first table and a second column of a second table in a first database, the first database includes a set of tables, and the first database is a relational database;
generating, based on the received first query, a hybrid index, wherein the hybrid index defines a connection between the first table and the second table of the set of tables and the connection is based on a common column in the first table and the second table, and the hybrid index is a unique data structure;
executing the first query using the hybrid index, wherein the first command is executed on the hybrid index; and
returning a set of results for the first query to a source of the query.