公开(公告)号：US09542426B2

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

申请号：US14095551

申请日：2013-12-03

Applicant: TERADATA US, INC.

Inventor： James Shau

IPC: G06F17/30

CPC classification number: G06F17/30321

Abstract: Data can be stored in a memory for an in-memory processing system such the data is available for processing as soon as it is needed to be processed. A first portion and a second portion of the data can be stored in the memory of the in-memory processing system for processing by the in-memory processing system, such that the second portion of the data is stored in the memory before the in-memory processing system completes the processing of the first portion of the data, thereby allowing the in-memory processing system to process the second portion of the data when the processing system is able to process the second portion of the data.

Abstract translation: 数据可以存储在用于存储器内处理系统的存储器中，这样数据可以在需要处理时立即进行处理。 数据的第一部分和第二部分可以被存储在存储器处理系统的存储器中，以便由存储器内处理系统进行处理，使得数据的第二部分被存储在存储器中， 存储器处理系统完成数据的第一部分的处理，从而当处理系统能够处理数据的第二部分时允许存储器内处理系统处理数据的第二部分。

公开(公告)号：US09542442B2

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

申请号：US14248566

申请日：2014-04-09

Applicant: TERADATA US, INC.

Inventor： Krishnan Meiyyappan ,  Liuxi Yang ,  Jeremy Branscome ,  Michael Paul Corwin ,  Ravindran Krishnamurthy ,  Kapil Laxmikant Surlaker ,  James Shau ,  Joseph Irawan Chamdani

IPC: G06F17/30

CPC classification number: G06F17/30442 ,  G06F17/30094 ,  G06F17/30315 ,  G06F17/30492 ,  G06F17/30504

Abstract: Embodiments of the present invention provide hardware-friendly indexing of databases. In particular, forward and reverse indexing are utilized to allow for easy traversal of primary key to foreign key relationships. A novel structure known as a hit list also allows for easy scanning of various indexes in hardware. Group indexing is provided for flexible support of complex group key definition, such as for date range indexing and text indexing. A Replicated Reordered Column (RRC) may also be added to the group index to convert random I/O pattern into sequential I/O of only needed column elements.

Abstract translation: 本发明的实施例提供数据库的硬件友好索引。 特别地，正向和反向索引被用于允许轻松地遍历主键到外键关系。 被称为命中列表的新颖结构还允许在硬件中容易地扫描各种索引。 提供组索引，用于复杂组密钥定义的灵活支持，如日期范围索引和文本索引。 还可以将复制的重新排列（RRC）添加到组索引中以将随机I / O模式转换为仅需要的列元素的顺序I / O。

公开(公告)号：US11243958B2

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

申请号：US15058590

申请日：2016-03-02

Applicant: Teradata US, Inc.

Inventor： Xin Tang ,  James Shau ,  Robert Wehrmeister ,  Daniel T. Yu

IPC: G06F17/00 ,  G06F16/2457 ,  G06F16/2458

Abstract: Disclosed are systems and methods for implementing contract-based polymorphic and parallelizable user-defined scalar and aggregate functions. The systems and methods can include receiving a query including a plurality of user-defined functions, parsing the query into a plurality of nodes (e.g., basic operation unit or atomic operator), generating an execution plan that minimizes data transfer between the plurality of nodes, and executing the plan in a distributed environment. Each of the plurality of user-defined functions can correspond to one of a plurality of nodes.