Invention Grant
- Patent Title: Wildcard character support in location path of foreign table to enable pattern matching
-
Application No.: US18243484Application Date: 2023-09-07
-
Publication No.: US12135718B1Publication Date: 2024-11-05
- Inventor: Srinivas Bijigiri , Rama Krishna Venkata Tirunagari
- Applicant: Teradata US, Inc
- Applicant Address: US CA San Diego
- Assignee: Teradata US, Inc
- Current Assignee: Teradata US, Inc
- Current Assignee Address: US CA San Diego
- Agent Howard Speight
- Main IPC: G06F16/24
- IPC: G06F16/24 ; G06F16/22 ; G06F16/2455 ; G06F16/248

Abstract:
A database system receives a query that includes a reference to a foreign table. The foreign table is used to access an Object Store (OS) outside the database system. The OS stores objects. The objects have path names, which are pointers to the objects. 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. 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. The database system producing a result by executing the query, accessing the objects in the OS identified by the path names of the objects to be accessed by the query.
Information query