-
公开(公告)号：US20220207052A1
公开(公告)日：2022-06-30
申请号：US17137580
申请日：2020-12-30
申请人： Teradata US, Inc.
IPC分类号： G06F16/25 , G06F16/22 , G06F16/2455 , G06F16/242 , G06F16/901
摘要： A method and apparatus for optimizing a query in a relational database management system (RDBMS) when a predicate on a data column in the query has a correlation to a partitioning attribute of a partitioning column in data retrieved from a cloud-based store, wherein the optimizing uses the correlation between the data column in the query to the partitioning column in the data retrieved from the cloud-based store for data elimination when processing the query. The correlation is defined in a formula or lookup data structure that maps or range-maps from the data column to the partitioning column.
-
公开(公告)号：US11775546B2
公开(公告)日：2023-10-03
申请号：US17137580
申请日：2020-12-30
申请人： Teradata US, Inc.
IPC分类号： G06F7/00 , G06F16/25 , G06F16/22 , G06F16/901 , G06F16/242 , G06F16/2455
CPC分类号： G06F16/252 , G06F16/221 , G06F16/2433 , G06F16/24554 , G06F16/9017
摘要： A method and apparatus for optimizing a query in a relational database management system (RDBMS) when a predicate on a data column in the query has a correlation to a partitioning attribute of a partitioning column in data retrieved from a cloud-based store, wherein the optimizing uses the correlation between the data column in the query to the partitioning column in the data retrieved from the cloud-based store for data elimination when processing the query. The correlation is defined in a formula or lookup data structure that maps or range-maps from the data column to the partitioning column.
-
公开(公告)号：US11113283B2
公开(公告)日：2021-09-07
申请号：US15844685
申请日：2017-12-18
申请人： Teradata US, Inc.
IPC分类号： G06F7/02 , G06F16/00 , G06F16/2453 , G06F16/2455 , G06F16/28
摘要： A query having a Union All view is identified. A logical join between Union AH view/derived table and other tables is broken down into multiple physical joins. The physical joins are pushed to the branches. Cost-based processing statistics are obtained for the branches. An optimal plan for the joins is selected based on the statistics; representing an optimal query execution for the query. The optimal query execution plan is provided to a database engine for executing the optimal query execution plan against a data warehouse.
-
公开(公告)号：US20210382920A1
公开(公告)日：2021-12-09
申请号：US17034348
申请日：2020-09-28
申请人： Teradata US, Inc.
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.
-
6.发明申请公开(公告)号：US20200151575A1
公开(公告)日：2020-05-14
申请号：US16681630
申请日：2019-11-12
申请人： Teradata US, Inc.
发明人： Wellington Marcos Cabrera Arevalo , Anandh Ravi Kumar , Mohammed Al-Kateb , Sanjay Nair , Sandeep Singh Sandha
摘要： An apparatus, method and computer program product for neural network training over very large distributed datasets, wherein a relational database management system (RDBMS) is executed in a computer system comprised of a plurality of compute units, and the RDBMS manages a relational database comprised of one or more tables storing data. One or more local neural network models are trained in the compute units using the data stored locally on the compute units. At least one global neural network model is generated in the compute units by aggregating the local neural network models after the local neural network models are trained.
-
7.发明申请公开(公告)号：US20160179886A1
公开(公告)日：2016-06-23
申请号：US14574347
申请日：2014-12-17
申请人： Teradata US, Inc.
IPC分类号： G06F17/30
CPC分类号： G06F17/30498
摘要： A query optimizer identifies a condition that supports a remote nested join. A first Access Module Processor (AMP) is sent the condition to obtain a first set of rows that satisfy the condition from a first table and the first AMP is instructed to perform the remote nested join with a second remote AMP to acquire a second set of rows that satisfy the condition from a second table. The first AMP joins the first set of rows and the second set of rows as a join result, which is returned to the query optimizer.
摘要翻译： 查询优化器标识支持远程嵌套连接的条件。 发送第一接入模块处理器（AMP）的条件以获得满足来自第一表的条件的第一组行，并且指示第一AMP与第二远程AMP执行远程嵌套连接以获取第二组 满足第二个表格条件的行。 第一个AMP将第一组行和第二组行连接为连接结果，返回给查询优化器。
-
公开(公告)号：US11709891B2
公开(公告)日：2023-07-25
申请号：US17139057
申请日：2020-12-31
申请人： TERADATA US, INC.
IPC分类号： G06F16/00 , G06F16/835 , G06N20/00 , G06F16/242
CPC分类号： G06F16/8365 , G06F16/242 , G06N20/00
摘要： In some examples, a system receives function descriptors for different types of functions to be used when processing database queries, each function descriptor of the function descriptors comprising information relating to a respective function of the different types of functions. The system computes, based on a first function descriptor for a first function of the different types of functions, an estimate of a runtime metric associated with execution of the first function for processing a database query.
-
公开(公告)号：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.
-
公开(公告)号：US20220207084A1
公开(公告)日：2022-06-30
申请号：US17139057
申请日：2020-12-31
申请人： TERADATA US, INC.
IPC分类号： G06F16/835 , G06F16/242 , G06N20/00
摘要： In some examples, a system receives function descriptors for different types of functions to be used when processing database queries, each function descriptor of the function descriptors comprising information relating to a respective function of the different types of functions. The system computes, based on a first function descriptor for a first function of the different types of functions, an estimate of a runtime metric associated with execution of the first function for processing a database query.
-
-
-
-
-
-
-
-
-
搜索结果
23 条记录 (耗时 0.017 秒)
