公开(公告)号：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.

公开(公告)号：US11593371B2

公开(公告)日：2023-02-28

申请号：US16996547

申请日：2020-08-18

申请人： Teradata US, Inc.

发明人： Wellington Marcos Cabrera Arevalo ,  Kassem Awada ,  Mahbub Hasan ,  Allen N. Diaz ,  Mohammed Al-Kateb ,  Awny Kayed Al-Omari

IPC分类号： G06F16/24 ,  G06F16/2453 ,  G06F17/16 ,  G06F16/28 ,  G06F16/25

摘要： A relational database management system (RDBMS) accepts a workload comprised of one or more queries against a relational database. The RDBMS evolves a default cost profile into a plurality of cost profiles using fixed or dynamic evolution, wherein each of the cost profiles captures one or more cost parameters for the workload. The cost profiles are represented by a multi-dimensional matrix that has one or more dimensions, and each of the dimensions represents one of the cost parameters. The RDBMS dynamically determines which of the cost profiles is an optimal cost profile for the workload by mapping the cost profiles to the workload using a random walk scoring algorithm or a biased walk scoring algorithm that searches the multi-dimensional matrix to identify the optimal cost profile. The RDBMS selects and performs one or more query execution plans for the workload based on the optimal cost profile for the workload.

公开(公告)号：US11468102B2

公开(公告)日：2022-10-11

申请号：US17034348

申请日：2020-09-28

申请人： Teradata US, Inc.

发明人： Mohamed Ahmed Yassin Eltabakh ,  Mahbub Hasan ,  Awny Kayed Al-Omari ,  Mohammed Al-Kateb

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

摘要： A relational database management system (RDBMS) optimizes limit queries over analytical functions, wherein the limit queries include an output clause comprising a LIMIT, TOP and SAMPLE clause with an expression specifying a limit that is a number K or a percentage α %. The optimizations of the limit queries include: (1) static compile-time optimizations, and (2) dynamic run-time optimizations, based on semantic properties of “granularity” and “input-to-output cardinality” for the analytical functions.

公开(公告)号：US20210382920A1

公开(公告)日：2021-12-09

申请号：US17034348

申请日：2020-09-28

申请人： Teradata US, Inc.

发明人： Mohamed Ahmed Yassin Eltabakh ,  Mahbub Hasan ,  Awny Kayed Al-Omari ,  Mohammed Al-Kateb

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

摘要： A relational database management system (RDBMS) optimizes limit queries over analytical functions, wherein the limit queries include an output clause comprising a LIMIT, TOP and SAMPLE clause with an expression specifying a limit that is a number K or a percentage α %. The optimizations of the limit queries include: (1) static compile-time optimizations, and (2) dynamic run-time optimizations, based on semantic properties of “granularity” and “input-to-output cardinality” for the analytical functions.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：US20210117422A1

公开(公告)日：2021-04-22

申请号：US16996547

申请日：2020-08-18

申请人： Teradata US, Inc.

发明人： Wellington Marcos Cabrera Arevalo ,  Kassem Awada ,  Mahbub Hasan ,  Allen N. Diaz ,  Mohammed AI-Kateb ,  Awny Kayed Al-Omari

IPC分类号： G06F16/2453 ,  G06F16/25 ,  G06F16/28 ,  G06F17/16

摘要： A relational database management system (RDBMS) accepts a workload comprised of one or more queries against a relational database. The RDBMS evolves a default cost profile into a plurality of cost profiles using fixed or dynamic evolution, wherein each of the cost profiles captures one or more cost parameters for the workload. The cost profiles are represented by a multi-dimensional matrix that has one or more dimensions, and each of the dimensions represents one of the cost parameters. The RDBMS dynamically determines which of the cost profiles is an optimal cost profile for the workload by mapping the cost profiles to the workload using a random walk scoring algorithm or a biased walk scoring algorithm that searches the multi-dimensional matrix to identify the optimal cost profile. The RDBMS selects and performs one or more query execution plans for the workload based on the optimal cost profile for the workload.