公开(公告)号：US09471444B2

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

申请号：US14104198

申请日：2013-12-12

申请人： TERADATA US, INC.

发明人： Mohit Aron ,  Diwaker Gupta

IPC分类号： G06F3/048 ,  G06F11/14 ,  G06F11/20 ,  G06F11/18

CPC分类号： G06F11/1471 ,  G06F11/187 ,  G06F11/2028 ,  G06F11/2041 ,  G06F11/2048 ,  G06F11/2097

摘要： Several methods and a system of a replicated service for write ahead logs are disclosed. In one embodiment, a method includes persisting a state of a distributed system through a write ahead log (WAL) interface. The method also includes maintaining a set of replicas of a WAL through a consensus protocol. In addition, the method includes providing a set of mechanisms for at least one of detection and a recovery from a hardware failure. The method further includes recovering a persistent state of a set of applications. In addition, the method includes maintaining the persistent state across a set of nodes through the hardware failover. In one embodiment, the system may include a WAL interface to persist a state of a distributed system. The system may also include a WAL replication servlet to maintain and/or recover a set of replicas of a WAL.

摘要翻译： 公开了用于写入提前日志的多种方法和复制服务的系统。 在一个实施例中，一种方法包括通过写入提前日志（WAL）接口来保持分布式系统的状态。 该方法还包括通过协商协议维护一组WAL的副本。 此外，该方法包括提供用于从硬件故障中检测和恢复中的至少一个的一组机制。 该方法还包括恢复一组应用程序的持久状态。 另外，该方法还包括通过硬件故障切换来保持跨越一组节点的持久状态。 在一个实施例中，系统可以包括用于保持分布式系统的状态的WAL接口。 系统还可以包括维护和/或恢复WAL的一组副本的WAL复制servlet。

公开(公告)号：US09330159B2

公开(公告)日：2016-05-03

申请号：US13728361

申请日：2012-12-27

申请人： TERADATA US, INC.

发明人： Donald R. Pederson ,  Paul Sinclair

IPC分类号： G06F17/30

CPC分类号： G06F17/30584 ,  G06F17/30483

摘要： Techniques for finding a column with column partitioning are provided. Metadata for a container row is expanded to include information for searching ranges of partitioned column values. The metadata identifies offsets to specific ranges and specific columns within a specific range. The offsets also identify where compressed data for a desired column resides. Thereby, permitting partitioned columns having compressed data to be located without being decompressed and decompressed on demand as needed.

摘要翻译： 提供了用于查找具有列分区的列的技术。 扩展容器行的元数据以包含搜索分区列值的范围的信息。 元数据标识特定范围内的偏移量和特定范围内的特定列。 偏移量还会识别所需列的压缩数据所在的位置。 从而，允许具有压缩数据的分区列被定位，​​而不需要根据需要进行解压缩和解压缩。

公开(公告)号：US09298506B2

公开(公告)日：2016-03-29

申请号：US14499544

申请日：2014-09-29

申请人： TERADATA US, INC.

发明人： Sorana Rabinovici ,  Venu Gopal Joshi

IPC分类号： G06F9/45 ,  G06F9/50 ,  G06F9/48

CPC分类号： G06F9/5011 ,  G06F9/4881 ,  G06F9/5077

摘要： A computer running a database system receives one or more queries, each query comprised of parallel threads of execution working towards the common goal of completing a user request. These threads are grouped into a schedulable object called a task group. The task groups are placed within a specific multiple tier hierarchy, and database system resources allocated to the task groups according to their placement within the hierarchy. Beginning with the top tier of the hierarchy, resources remaining after allocations to each task group within a tier are passed to the next lower tier for allocation.

摘要翻译： 运行数据库系统的计算机接收一个或多个查询，每个查询包括并行执行线程，朝向完成用户请求的共同目标。 这些线程被分组成一个称为任务组的可调度对象。 将任务组放置在特定的多层次层次结构中，并将数据库系统资源根据其在层次结构中的位置分配给任务组。 从层次结构的顶层开始，在分配到一个层中的每个任务组之后剩余的资源将被传递到下一个较低层进行分配。

公开(公告)号：US09244792B1

公开(公告)日：2016-01-26

申请号：US13731532

申请日：2012-12-31

申请人： TERADATA US, INC.

发明人： Matthew James Fischer ,  Scott Eymann Stucky

IPC分类号： G06F11/00 ,  G06F11/26

CPC分类号： G06F11/1088 ,  G06F2211/1088

摘要： A disk-error detection system may include a storage array having a plurality of storage disks configured to store data. The disk-error detection system may include a processor in communication with the storage disks. The processor may detect presence of a media error in a storage disk from the plurality of storage disks during a read operation of the data stored on the storage disk. The processor may perform a media-error detection scan of a predetermined portion of the storage disk in response to the detection of the media error. The location on the storage disk of the predetermined portion of the storage disk may be based on location of the media error on the storage disk. A method and computer-readable medium may also implement disk-error detection.

摘要翻译： 磁盘错误检测系统可以包括具有被配置为存储数据的多个存储盘的存储阵列。 磁盘错误检测系统可以包括与存储盘通信的处理器。 在存储在存储盘上的数据的读取操作期间，处理器可以从多个存储盘检测存储盘中的介质错误。 响应于媒体错误的检测，处理器可以执行存储盘的预定部分的媒体错误检测扫描。 存储盘的预定部分的存储盘上的位置可以基于介质错误在存储盘上的位置。 方法和计算机可读介质也可以实现磁盘错误检测。

公开(公告)号：US20150178352A1

公开(公告)日：2015-06-25

申请号：US14579697

申请日：2014-12-22

申请人： Teradata US, Inc.

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

IPC分类号： G06F17/30

CPC分类号： G06F17/30498 ,  G06F17/30241 ,  G06F17/30327

摘要： 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.

摘要翻译： 关系数据库管理系统（RDBMS）表的统计信息被归一化并计算了一个网格。 确定具有来自表格的阈值数量的特定网格单元，并且为该网格单元动态构造R-Tree，以在对该表执行地理空间连接操作时使用。

公开(公告)号：US20140280218A1

公开(公告)日：2014-09-18

申请号：US14041719

申请日：2013-09-30

申请人： Teradata US, Inc.

发明人： Thomas Kevin Ryan ,  Achal Patel ,  Neelesh Bansode ,  Arvind Kumar ,  Anand Louis

IPC分类号： G06F17/30

CPC分类号： G06F17/30569

摘要： Techniques for data integration are provided. Source attributes for source data are interactively mapped to target attributes for target data. Rules define how records from the source data are merged, selected, and for duplication detection. The mappings and rules are recorded as a profile for the source data and processed against the source data to transform the source attributes to the target attributes.

摘要翻译： 提供数据集成技术。 源数据的源属性被交互地映射到目标数据的目标属性。 规则定义如何合并，选择和重复检测来自源数据的记录。 映射和规则被记录为源数据的配置文件，并根据源数据进行处理，以将源属性转换为目标属性。

公开(公告)号：US20140279831A1

公开(公告)日：2014-09-18

申请号：US14039197

申请日：2013-09-27

申请人： Teradata US, Inc.

发明人： Thomas Kevin Ryan ,  Anand Louis

IPC分类号： G06F17/30

CPC分类号： G06F16/254

摘要： Techniques for data modeling are provided. Enterprise data is organized into reference data for entities that an enterprise wants to track and monitor. Relationship data is created that establishes relationships among the various entities within the enterprise data. The reference data and the relationship data are published within an enterprise data warehouse for accessing the enterprise data.

摘要翻译： 提供数据建模技术。 企业数据被组织为企业想要跟踪和监视的实体的参考数据。 创建关系数据，其建立企业数据内各种实体之间的关系。 参考数据和关系数据在企业数据仓库内发布，用于访问企业数据。

公开(公告)号：US20140222787A1

公开(公告)日：2014-08-07

申请号：US14218160

申请日：2014-03-18

申请人： TERADATA US, INC.

发明人： Yu Xu ,  Olli Pekka Kostamaa

IPC分类号： G06F17/30

CPC分类号： G06F17/30424 ,  G06F17/30584

摘要： Techniques for accessing a parallel database system via an external program using vertical and/or horizontal partitioning are provided. An external program to a database management system (DBMS) configures external mappers to process a specific portion of query results on specific access module processors of the DBMS that are to house query results. The query is submitted by the external program to the DBMS and the DBMS is directed to organize the query results in a vertical or horizontal manner. Each external mapper accesses its portion of the query results for processing in parallel on its designated AMP or set of AMPS to process the query results.

摘要翻译： 提供了通过使用垂直和/或水平分区的外部程序访问并行数据库系统的技术。 数据库管理系统（DBMS）的外部程序配置外部映射器，以处理要存放查询结果的DBMS的特定访问模块处理器上的查询结果的特定部分。 该查询由外部程序提交给DBMS，并且指导DBMS以垂直或水平方式组织查询结果。 每个外部映射器访问其部分查询结果，以便在其指定的AMP或一组AMPS上并行处理以处理查询结果。

公开(公告)号：US20240220501A1

公开(公告)日：2024-07-04

申请号：US18089833

申请日：2022-12-28

申请人： Teradata US, Inc.

发明人： Ming Zhang ,  Sanjay Nair

IPC分类号： G06F16/2453 ,  G06F11/34 ,  G06F16/22

CPC分类号： G06F16/24544 ,  G06F11/3419 ,  G06F16/2272 ,  G06F16/24539

摘要： An apparatus, method and computer program product for query optimization in a Relational Database Management System (RDBMS), wherein an optimizer accesses a query expression repository (QER) storing planning and execution information for QEs from previous queries, wherein the QEs comprise table relations, intermediate results and/or final results of operations in the previous queries. Additionally, dynamic join indexes representing QE results are created for high-value QEs selected from the QER and maintained within a DJI repository. During query plan creation for a current or subsequent query, the optimizer searches the QER and DJI repository for DJIs created for high-value QEs corresponding to QEs contained in the current or subsequent query. DJIs corresponding to the matching QEs are used in the query planning phase to rewrite the current or subsequent user query so that stored QE results are used to answer QEs contained in the current or subsequent query.

公开(公告)号：US20240220341A1

公开(公告)日：2024-07-04

申请号：US18525325

申请日：2023-11-30

申请人： Teradata US, Inc.

发明人： Michael George Coutts ,  Mark Andrew Sandan ,  John Douglas Frazier

IPC分类号： G06F9/54

CPC分类号： G06F9/543 ,  G06F9/544

摘要： A system may include a storage device. The storage device may store a plurality of user-defined functions (“UDFs”). Each of the plurality of UDFs may be containerized to allow each UDF to be executed using content unshared with other UDFs. The storage device may also include a plurality of data objects. The system may further include a plurality of processing nodes. At least one processing node may receive a call to execute one of the plurality of UDFs on at least one of the plurality of data objects. The at least one processing node may execute the called UDF on the at least one of the plurality of data objects. A method and computer-readable medium are also disclosed.