公开(公告)号：US20200183921A1

公开(公告)日：2020-06-11

申请号：US16704802

申请日：2019-12-05

申请人： Teradata US, Inc

发明人： B. Anantha Subramanian ,  Mohamed Yassin Eltabakh ,  Mahbub Hasan ,  Robert Matthew Wehrmeister ,  Awny Kayed Al-Omari ,  Sanjay Sukumaran Nair ,  Kashif Abdullah Siddiqui

IPC分类号： G06F16/242 ,  G06F16/21 ,  G06F16/27 ,  G06F16/182

摘要： A database system receives a request from a user. The request invokes a data set function (DSF) and uses a property to be provided by the DSF. The database system determines that a function descriptor is available for the DSF. The function descriptor is expressed as markup language instructions. The function descriptor defines the property of the DSF. The database system uses the function descriptor to define a property for the DSF.

公开(公告)号：US20200183935A1

公开(公告)日：2020-06-11

申请号：US16704934

申请日：2019-12-05

申请人： Teradata US, Inc

发明人： Christina Pavlopoulou ,  Mahbub Hasan ,  B. Anantha Subramanian ,  Mohammed Al-Kateb ,  Awny Kayed Al-Omari ,  Kashif Abdullah Siddiqui ,  Robert Matthew Wehrmeister ,  Mohamed Yassin Eltabakh

IPC分类号： G06F16/2453 ,  G06N5/04

摘要： Execution of a query invoking an analytical function (AF) is optimized. The query includes a join operation between an AF table and an AuxiliaryTable and includes determining that the AF includes a plurality of AF properties. Query-level properties about the query are inferred. It is determined to change an order of the join operation from the plurality of AF properties and query-level properties.

公开(公告)号：US20220215024A1

公开(公告)日：2022-07-07

申请号：US17563757

申请日：2021-12-28

申请人： Teradata US, Inc.

发明人： Kapil Kedar Lanka ,  Nobul Reddy Goli ,  B. Anantha Subramanian ,  Veerendra Kumar Achanta

IPC分类号： G06F16/2453 ,  G06F16/2455

摘要： Improved techniques for management of memory (or memory management) for computing systems and environments are disclosed. The improved techniques are especially well suited for computing systems that operate in highly complex and/or demanding computing environments (e.g., massively parallel database systems that may be required to process many complex database queries in parallel. Memory can be managed dynamically at run time to determine and designate one of multiple memories that are available for execution of executable components (e.g., database queries, Opcodes of a Virtual Machine). In addition, memory can be managed dynamically at run time to effectively reuse memory locations of a memory (e.g., stack memory) being used for execution of one or more executable components (e.g., Opcodes of a Virtual Machine) at run time when the memory is being actively used to execute the one or more executable components.

公开(公告)号：US11526505B2

公开(公告)日：2022-12-13

申请号：US16704802

申请日：2019-12-05

申请人： Teradata US, Inc

发明人： B. Anantha Subramanian ,  Mohamed Yassin Eltabakh ,  Mahbub Hasan ,  Robert Matthew Wehrmeister ,  Awny Kayed Al-Omari ,  Sanjay Sukumaran Nair ,  Kashif Abdullah Siddiqui ,  Mohammed Yassin Al-Kateb

IPC分类号： G06F16/00 ,  G06F16/242 ,  G06F16/182 ,  G06F16/27 ,  G06F16/21

摘要： A database system receives a request from a user. The request invokes a data set function (DSF) and uses a property to be provided by the DSF. The database system determines that a function descriptor is available for the DSF. The function descriptor is expressed as markup language instructions. The function descriptor defines the property of the DSF. The database system uses the function descriptor to define a property for the DSF.

公开(公告)号：US11409745B2

公开(公告)日：2022-08-09

申请号：US16704934

申请日：2019-12-05

申请人： Teradata US, Inc

发明人： Christina Pavlopoulou ,  Mahbub Hasan ,  B. Anantha Subramanian ,  Mohammed Al-Kateb ,  Awny Kayed Al-Omari ,  Kashif Abdullah Siddiqui ,  Robert Matthew Wehrmeister ,  Mohamed Yassin Eltabakh

IPC分类号： G06F16/2453

摘要： Execution of a query invoking an analytical function (AF) is optimized. The query includes a join operation between an AF table and an AuxiliaryTable. A determination is made that the AF includes a plurality of AF properties. Query-level properties about the query are inferred. A determination is made to change an order of the join operation from the plurality of AF properties and query-level properties.