公开(公告)号：US11347794B2

公开(公告)日：2022-05-31

申请号：US15386049

申请日：2016-12-21

申请人： Teradata US, Inc.

发明人： Yu Long ,  Judy Wu ,  Preeti Javaji ,  Gregory Howard Milby ,  Steven B. Cohen

IPC分类号： G06F16/00 ,  G06F16/81 ,  G06F16/22

摘要： Various embodiments herein each include at least one of systems, methods, and software for generating, storing, and using non-unique secondary indexes of semi-structured data in database tables. One method embodiment includes creating and storing a non-unique secondary index (NUSI) for a database table based on column data stored in rows of the database table. The NUSI in some such embodiments identifying an offset to specific data included in the column data of at least some rows of the database table where the specific data is located. Other embodiments include building a NUSI index that includes values embedded therein.

公开(公告)号：US11544236B2

公开(公告)日：2023-01-03

申请号：US16234666

申请日：2018-12-28

申请人： Teradata US, Inc.

发明人： Douglas Paul Brown ,  Preeti Javaji

IPC分类号： G06F16/00 ,  G06F16/21 ,  G06F16/2453 ,  G06N5/04 ,  G06N20/00

摘要： A machine-learning driven Database Management System (DBMS) is provided. One or more machine-learning algorithms are trained on the database constructs and execution plans produced by a database optimizer for queries. The trained machine-learning algorithms provide predictors when supplied the constructs and plans for a given query. The predictors are processed by the DBMS to make resource, scheduling, and Service Level Agreement (SLA) compliance decisions with respect to the given query.

公开(公告)号：US20200210387A1

公开(公告)日：2020-07-02

申请号：US16234666

申请日：2018-12-28

申请人： Teradata US, Inc

发明人： Douglas Paul Brown ,  Preeti Javaji

IPC分类号： G06F16/21 ,  G06N20/00 ,  G06N5/04 ,  G06F16/2453

摘要： A machine-learning driven Database Management System (DBMS) is provided. One or more machine-learning algorithms are trained on the database constructs and execution plans produced by a database optimizer for queries. The trained machine-learning algorithms provide predictors when supplied the constructs and plans for a given query. The predictors are processed by the DBMS to make resource, scheduling, and Service Level Agreement (SLA) compliance decisions with respect to the given query.

公开(公告)号：US20170235845A1

公开(公告)日：2017-08-17

申请号：US15386049

申请日：2016-12-21

申请人： Teradata US, Inc.

发明人： Yu Long ,  Judy Wu ,  Preeti Javaji ,  Gregory Howard Milby ,  Steven B. Cohen

IPC分类号： G06F17/30

CPC分类号： G06F16/81 ,  G06F16/22

摘要： Various embodiments herein each include at least one of systems, methods, and software for generating, storing, and using non-unique secondary indexes of semi-structured data in database tables. One method embodiment includes creating and storing a non-unique secondary index (NUSI) for a database table based on column data stored in rows of the database table. The NUSI in some such embodiments identifying an offset to specific data included in the column data of at least some rows of the database table where the specific data is located. Other embodiments include building a NUSI index that includes values embedded therein.