公开(公告)号：US10002160B2

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

申请号：US14579697

申请日：2014-12-22

申请人： Teradata US, Inc.

发明人： Heng Yuan ,  Daniel Wong ,  Congnan Luo ,  Guilian Wang

IPC分类号： G06F17/30

CPC分类号： G06F16/2456 ,  G06F16/2246 ,  G06F16/29

摘要： Statistics for a Relational Database Management System (RDBMS) set of tables are normalized and a grid computed. A particular grid cell having above threshold number of entries from the tables is determined and an R-Tree is dynamically constructed for that grid cell for use when performing a geospatial join operation against the tables.

公开(公告)号：US09910623B2

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

申请号：US14215405

申请日：2014-03-17

申请人： TERADATA US, INC.

发明人： Liuxi Yang ,  Jeremy L. Branscome

IPC分类号： G06F15/18 ,  G06F3/06 ,  G06F13/16 ,  G11C29/02 ,  G11C5/04 ,  G11C11/401

CPC分类号： G06F3/0671 ,  G06F13/1689 ,  G11C5/04 ,  G11C11/401 ,  G11C29/022 ,  G11C29/028 ,  G11C2207/2254

摘要： Storage devices and components, including memory components (e.g., non-volatile memory) can be trained by executable code that facilitates and/or performs reads and/or write requests to one or more storage sub-modules of a storage component (e.g., memory configured on a memory channel) made up of multiple storage components (e.g., DIMMs). The executable code can also train multiple storage components at the same time and/or in parallel.

公开(公告)号：US20180052877A1

公开(公告)日：2018-02-22

申请号：US15797188

申请日：2017-10-30

申请人： Teradata US, Inc.

发明人： Frederick S. Kaufmann ,  Rajendran Kolandasamy ,  Philip Jason Benton ,  Paul Laurence Sinclair ,  Donald Raymond Pederson ,  Louis Martin Burger

IPC分类号： G06F17/30

摘要： An order (or priority) for reassigning data portions of a database from a first map to a second map can be determined. It should be noted that the first map assigns the data portions to a first configuration of processors for processing the data portions, and the second map assigns the data portions to a second configuration of processors, different than the first configuration, for processing the data portions in a database system and/or environment. The order can be determined by grouping the data in multiple groups and ordering the groups in accordance with a determined priority for reassignment In doing so, one or more relationships between the data portions and/or cost of use for each one the groups can be considered.

公开(公告)号：US20180039664A1

公开(公告)日：2018-02-08

申请号：US15788857

申请日：2017-10-20

申请人： Teradata US, Inc.

发明人： Frederick S. Kaufmann ,  Paul Laurence Sinclair

IPC分类号： G06F17/30

摘要： The number of processors that store data can be limited for some data in order to improve efficiency in database system that uses multiple processing units to process data. For example, a map can be provided for one or more sparse database tables (or tables) that are relatively small in view of the number of processors that are available. The map can effectively assign distinct portions of the data, e.g., rows of a database, for processing only to a limited number of processers (or processing units). The database system can use the map to process data accordingly.

公开(公告)号：US09805121B2

公开(公告)日：2017-10-31

申请号：US14183029

申请日：2014-02-18

申请人： TERADATA US, INC.

发明人： Douglas P. Brown ,  Michael G. Coutts ,  Sergio Ferragut

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30864

摘要： A database request can be processed at least partly based on one or more differences between multiple database systems and/or environments. The differences can, for example, include differences between one or more database capabilities respectively provided by the multiple database systems, differences between the representation of data in the multiple database systems, and differences in the interfaces for accessing the multiple database systems.

公开(公告)号：US09720966B2

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

申请号：US13721901

申请日：2012-12-20

申请人： TERADATA US, INC.

发明人： Ahmad Said Ghazal ,  Dawit Seid

IPC分类号： G06F17/30

CPC分类号： G06F17/30463

摘要： An execution plan for executing one or more iterations of recursive database queries can be generated in accordance with one aspect of the invention. For example, in accordance with one embodiment of the invention, one or more cardinalities (results or size of results, including intermediate results) associated with one or more iterations can be estimated. This estimation can, for example, by performed by using a sampling or sampling-based algorithm.In addition, a plan generated for execution of one or more iteration of a recursive query can be modified or replaced by comparing the actual cardinality with its estimation. As a result, the first one or more iterations may be executed using a first plan but the subsequent one or more iterations may use a modified or different execution plan.

公开(公告)号：US09703505B2

公开(公告)日：2017-07-11

申请号：US14573781

申请日：2014-12-17

申请人： TERADATA US, INC.

发明人： Wayne R. Boyle ,  Philip J. Benton ,  Donald Pederson

IPC分类号： G06F12/08 ,  G06F12/12 ,  G06F3/06 ,  G06F12/122 ,  G06F12/0866 ,  G06F12/121

CPC分类号： G06F3/0655 ,  G06F3/065 ,  G06F12/0866 ,  G06F12/121 ,  G06F12/122

摘要： Techniques for management of data in multi-storage systems allow managing storage of data in a first storage of multiple storages in a multi-storage system based on the temperature of the data (or data temperature) obtained for a second storage of the multiple storages in a multi-storage system. For example, in a multi-storage system that includes at least one non-volatile storage (e.g., one or more HDDs) and at least one volatile storage (e.g., a cache memory device), the storage of a particular data portion (e.g., a storage unit of data) for the at least one volatile storage can be managed based on a temperature of the data determined for the non-volatile storage. By way of example, persistent temperatures used for management of data in a non-volatile storage system (e.g., a multi-tier storage of a database system) can be used to effectively manage the storage of the data in a cache memory that is typically provided for improving performance by keeping data that is likely to be used in the cache memory. As a result, overall performance of a system can be further enhanced by allowing persistent temperature measurements to be used in managing cache memory, instead of solely relying on conventional techniques for caching data which typically do not take into account persistent temperatures associated with a non-volatile storage environment.

公开(公告)号：US20170193014A1

公开(公告)日：2017-07-06

申请号：US15377380

申请日：2016-12-13

申请人： Teradata US, Inc.

发明人： Sanjib Mishra ,  Rama Krishna Korlapati

IPC分类号： G06F17/30

CPC分类号： G06F16/211 ,  G06F16/2282 ,  G06F16/2456

摘要： Disclosed are systems and methods for dynamic joining of database tables. The systems and methods can include: selecting a first table from a plurality of tables; selecting a second table from the plurality of tables; joining the first table and the second table to create a temporary table; and storing, in a memory of a computing device, the temporary table and the temporary skew value. The first table can have a first skew value. The second table can have a second skew value. The second skew value can be similar to the first skew value. The temporary table can have a temporary skew value.

公开(公告)号：US20170177642A1

公开(公告)日：2017-06-22

申请号：US15391394

申请日：2016-12-27

申请人： Teradata US, Inc.

发明人： Louis Martin Burger ,  Frederick S. Kaufmann

IPC分类号： G06F17/30

摘要： Data of a database (e.g., database tables) can be reassigned from a first map to a second map in a database system that uses maps to assign data for processing to multiple processing units of a database system in accordance with one or more distributions schemes. Data portions can be selected in groups and moved in the selected groups in an efficient manner. The selection and/or movement of the data portions can be automated without requiring input for users of database systems.

公开(公告)号：US09477704B1

公开(公告)日：2016-10-25

申请号：US14135515

申请日：2013-12-19

申请人： Teradata US, Inc

发明人： Rajeswara R. Kottu ,  Joshua D. Anderson ,  Harold R. Lee ,  Ara Yapejian

IPC分类号： G06F17/30

CPC分类号： G06F17/30386

摘要： A sentiment-scoring system may include a storage device configured to store a plurality of keywords, keyword groups, and a keyword group hierarchy. Each keyword may be associated with at least one of the keyword groups. The keyword hierarchy may include a hierarchy associated with each keyword group. The system may further include a processor in communication with the storage device. The processor may be configured to locate a plurality of sentiment expressions and identify a plurality of keywords present in the plurality of sentiment expressions. The processor may be further configured to determine at least one respective keyword group associated with each identified keyword and determine a sentiment score for each sentiment expression with respect to the associated keyword group within the keyword hierarchy. The processor may be further configured to provide at least one sentiment score to a display. A method and computer-readable medium may also be implemented.

摘要翻译： 情感评分系统可以包括被配置为存储多个关键字，关键字组和关键字组层次结构的存储设备。 每个关键字可以与至少一个关键字组相关联。 关键字层级可以包括与每个关键字组相关联的层次结构。 系统还可以包括与存储设备通信的处理器。 处理器可以被配置为定位多个情绪表达并且识别存在于多个情绪表达中的多个关键字。 处理器可以进一步被配置为确定与每个识别的关键字相关联的至少一个相应的关键字组，并且针对关键字层次结构内的关联关键字组确定每个情绪表达的情绪评分。 处理器可以被进一步配置为向显示器提供至少一个情绪评分。 还可以实现方法和计算机可读介质。