公开(公告)号：US10860581B2

公开(公告)日：2020-12-08

申请号：US15839955

申请日：2017-12-13

申请人： Teradata US, Inc.

发明人： John Douglas Frazier ,  Prama Agarwal

IPC分类号： G06F17/00 ,  G06F16/2453 ,  G06F16/25 ,  G06F16/245

摘要： An apparatus is provided for facilitating a local database system to execute a query function at a foreign database system. The apparatus comprises a processor of the local database system and a storage device communicatively coupled with the processor. The processor is programmed to (i) receive a query request, (ii) retrieve query data associated with the query request, (iii) determine if the query request can be processed at the local database system, (iv) if the query request is unable to be processed at the local database system, connect to the foreign database system, (v) after the local database system is connected to the foreign database system, export the retrieved query data from the local database system to the foreign database system to allow the foreign database system to process the retrieved query data, (vi) after the retrieved query data has been exported from the local database system to the foreign database system, send the query request from the local database system to the foreign database system to allow the foreign database system to process the query request using the retrieved query data, and (vii) after the foreign database system has processed the query request using the query data, import a result dataset from the foreign database system.

公开(公告)号：US20240220341A1

公开(公告)日：2024-07-04

申请号：US18525325

申请日：2023-11-30

申请人： Teradata US, Inc.

发明人： Michael George Coutts ,  Mark Andrew Sandan ,  John Douglas Frazier

IPC分类号： G06F9/54

CPC分类号： G06F9/543 ,  G06F9/544

摘要： A system may include a storage device. The storage device may store a plurality of user-defined functions (“UDFs”). Each of the plurality of UDFs may be containerized to allow each UDF to be executed using content unshared with other UDFs. The storage device may also include a plurality of data objects. The system may further include a plurality of processing nodes. At least one processing node may receive a call to execute one of the plurality of UDFs on at least one of the plurality of data objects. The at least one processing node may execute the called UDF on the at least one of the plurality of data objects. A method and computer-readable medium are also disclosed.

公开(公告)号：US20240220330A1

公开(公告)日：2024-07-04

申请号：US18401598

申请日：2023-12-31

申请人： Teradata US, Inc.

发明人： John Douglas Frazier ,  Vimalraj Panneerselvam

IPC分类号： G06F9/50 ,  G06F16/2453

CPC分类号： G06F9/505 ,  G06F9/5072 ,  G06F16/2453 ,  G06F2209/501 ,  G06F2209/5014 ,  G06F2209/505

摘要： A system may include a storage device. The system may include a plurality of processing nodes. The plurality of processing nodes communicates with the storage device. At least one processing node schedules a group of compute nodes to be active during a selected time window. The at least one processing node receives a query and determines that the query is to be executed by one of the plurality of processing nodes and the group of compute nodes. The at least one processing node schedules the query to be executed by the determined one of the plurality of processing nodes or the group of compute nodes. A method and computer-readable medium are also disclosed.

公开(公告)号：US20180189328A1

公开(公告)日：2018-07-05

申请号：US15857061

申请日：2017-12-28

申请人： Teradata US, Inc.

发明人： John Douglas Frazier ,  Prama Agarwal ,  Eric John Scheie

IPC分类号： G06F17/30

CPC分类号： G06F16/27 ,  G06F16/25 ,  G06F16/254

摘要： A system for managing data access, processing, and data movement across disparate data sources in a heterogeneous analytical environment. Communication and access between multiple disparate data sources is provided by an interconnect mechanism includes connectors at data source nodes and links established between the connectors to form a fabric, i.e., a set of interconnected nodes, which organizes components into a discrete environment and enables communication between paired data sources of the same or differing type within the environment.

公开(公告)号：US20180173761A1

公开(公告)日：2018-06-21

申请号：US15839955

申请日：2017-12-13

申请人： Teradata US, Inc.

发明人： John Douglas Frazier ,  Prama Agarwal

IPC分类号： G06F17/30

CPC分类号： G06F16/24542 ,  G06F16/245 ,  G06F16/256

摘要： An apparatus is provided for facilitating a local database system to execute a query function at a foreign database system. The apparatus comprises a processor of the local database system and a storage device communicatively coupled with the processor. The processor is programmed to (i) receive a query request, (ii) retrieve query data associated with the query request, (iii) determine if the query request can be processed at the local database system, (iv) if the query request is unable to be processed at the local database system, connect to the foreign database system, (v) after the local database system is connected to the foreign database system, export the retrieved query data from the local database system to the foreign database system to allow the foreign database system to process the retrieved query data, (vi) after the retrieved query data has been exported from the local database system to the foreign database system, send the query request from the local database system to the foreign database system to allow the foreign database system to process the query request using the retrieved query data, and (vii) after the foreign database system has processed the query request using the query data, import a result dataset from the foreign database system.