US 12,135,718 B1
Wildcard character support in location path of foreign table to enable pattern matching
Srinivas Bijigiri, Bijigiri Sharief (IN); and Rama Krishna Venkata Tirunagari, Bangalore (IN)
Assigned to Teradata US, Inc., San Diego, CA (US)
Filed by Teradata US, Inc, San Diego, CA (US)
Filed on Sep. 7, 2023, as Appl. No. 18/243,484.
Int. Cl. G06F 16/24 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 16/248 (2019.01)
CPC G06F 16/24553 (2019.01) [G06F 16/2282 (2019.01); G06F 16/248 (2019.01)] 15 Claims
OG exemplary drawing
 
1. A method comprising:
a database system receiving a query that includes a reference to a foreign table,
wherein the foreign table is used to access an Object Store (OS) outside the database system,
wherein the OS stores objects, wherein the objects have path names, which are pointers to the objects, and
wherein when the foreign table was created one or more wildcards were used to specify the path names for the objects in the OS to be accessed by the query;
the database system directing the OS to provide a list containing the path names of the objects in the OS by:
the database system requesting the OS to identify containers owned by the database system, and
for each container owned by the database system, requesting path names of the objects in the container and making an additional request for path names of the objects in the container after the OS provides a maximum number of path names;
the database system receiving the list and applying the one or more wildcards to identify the path names of the objects to be accessed by the query; and
the database system producing a result by executing the query by accessing the objects in the OS identified by the path names of the objects to be accessed by the query.