公开(公告)号：US20040249838A1

公开(公告)日：2004-12-09

申请号：US10646522

申请日：2003-08-22

Applicant: Netezza Corporation

Inventor： Foster D. Hinshaw ,  Craig S. Harris ,  Sunil K. Sarin

IPC: G06F017/00

CPC classification number: G06F17/30356 ,  Y10S707/99934 ,  Y10S707/99943 ,  Y10S707/99953

Abstract: A multi-version database system controls visibility of data during transaction processing. A transaction includes a transaction identifier that identifies the transaction and an invisibility list of transactions whose effects are invisible to the transaction. Changes made by other transactions are visible to the transaction based on the isolation level of the transaction. Records are visible to a transaction based on a creator identifier stored in the record that identifies the transaction that created the record.

Abstract translation: 多版本数据库系统在事务处理期间控制数据的可见性。 交易包括识别交易的交易标识符和其交易不可见的交易的不可见性列表。 根据事务的隔离级别，其他事务所做的更改对事务是可见的。 根据存储在记录中的标识创建记录的事务的创建者标识，事务可以看到记录。

公开(公告)号：US20040205110A1

公开(公告)日：2004-10-14

申请号：US10667128

申请日：2003-09-18

Applicant: Netezza Corporation

Inventor： Foster D. Hinshaw

IPC: G06F015/16 ,  G06F003/00 ,  G06F013/00

CPC classification number: G06F17/30477 ,  G06F17/30578 ,  Y10S707/99944

Abstract: In a preferred embodiment, the present invention is an asymmetric data processing system having two or more nullcsh6nullgroups of processors that have attributes that are optimized for their assigned functions. A first processor group, which may be SMP machines, are responsible for interfacing with applications and/or end users to obtain queries, and for planning query execution. A second processor group consists of many streaming record-oriented processors called Job Processing Units (JPUs), typically arranged as an MPP structure. The JPUs carry out the bulk of the data processing required to implement the logic of a query, running autonomously and asynchronously from other processors in the system. The JPUs preferably use a multi-tasking operating system that permits multiple tasks to run at a given instant in time, in either an absolute-priority-based or a weighted-priority-based demand scheduling environment.

Abstract translation: 在优选实施例中，本发明是具有两个或更多个具有针对其分配的功能被优化的属性的处理器组的非对称数据处理系统。 可能是SMP机器的第一处理器组负责与应用程序和/或最终用户进行接口以获取查询以及规划查询执行。 第二处理器组由许多面向流记录的处理器称为作业处理单元（JPU），通常被布置为MPP结构。 JPU执行实现查询逻辑所需的大量数据处理，从系统中的其他处理器自动和异步运行。 JPU优选地使用多任务操作系统，其允许多个任务在给定的时刻在基于绝对优先级或基于加权优先级的请求调度环境中运行。

公开(公告)号：US20040148420A1

公开(公告)日：2004-07-29

申请号：US10668113

申请日：2003-09-18

Applicant: Netezza Corporation

Inventor： Foster D. Hinshaw ,  David L. Meyers ,  Barry M. Zane

IPC: G06F015/16

CPC classification number: G06F17/30477 ,  G06F17/30578 ,  Y10S707/99944

Abstract: A data processing system having two or more groups of data processors that have attributes that are optimized for their assigned functions. A first group consists of one or more host computers responsible for interfacing with applications and/or end users to obtain queries and for planning query execution. A second processor group consists of many streaming record-oriented processors called Job Processing Units (JPUs), preferably arranged as an MPP structure. The JPUs typically carry out the bulk of the data processing required to implement the logic of a query. Each of the JPUs typically include a general purpose microcomputer, local memory, one or more mass storage devices, and one or more network connections. Each JPU also has a special purpose programmable processor, referred to herein as a Programmable Streaming Data Processor (PSDP). The PSDP serves as an interface between the CPU of a JPU and the mass storage device, to offload functions from the CPU of the JPU.

Abstract translation: 具有两组或更多组数据处理器的数据处理系统具有针对其分配的功能进行了优化的属性。 第一组包括一个或多个主机，负责与应用程序和/或最终用户进行接口以获取查询和规划查询执行。 第二处理器组由许多流记录导向处理器（称为作业处理单元（JPU））组成，优选地被布置为MPP结构。 JPU通常执行实现查询逻辑所需的大量数据处理。 每个JPU通常包括通用微型计算机，本地存储器，一个或多个大容量存储设备以及一个或多个网络连接。 每个JPU还具有专用可编程处理器，这里称为可编程流数据处理器（PSDP）。 PSDP作为JPU的CPU和大容量存储设备之间的接口，从JPU的CPU卸载功能。

公开(公告)号：US20040117037A1

公开(公告)日：2004-06-17

申请号：US10666729

申请日：2003-09-18

Applicant: Netezza Corporation

Inventor： Foster D. Hinshaw ,  Sanjay G. Dixit ,  John K. Metzger ,  David L. Meyers ,  Venkannababu Tammisetti ,  Premanand Yerabothu ,  Barry M. Zane

IPC: G05B019/18 ,  G05B013/02

CPC classification number: G06F17/30477 ,  G06F17/30578 ,  Y10S707/99944

Abstract: An asymmetric data record processor and method includes host computers and job processing units (JPU's) coupled together on a network. Each host computer and JPU forms a node on the network. A plurality of software operators allow each node to process streams of records. For each operator in a given sequence within nodes and across nodes, output of the operator is input to a respective succeeding operator. Data processing follows a logical data flow based on readiness of a record. As soon as a record is ready it is passed for processing from one part to a next part in the logical data flow. The flow of records during data processing is substantially continuous and of a streaming fashion.

Abstract translation: 非对称数据记录处理器和方法包括在网络上耦合在一起的主计算机和作业处理单元（JPU）。 每个主机和JPU在网络上形成一个节点。 多个软件操作者允许每个节点处理记录流。 对于节点内和节点之间的给定序列中的每个运算符，运算符的输出被输入到相应的后续运算符。 数据处理遵循基于记录准备的逻辑数据流。 一旦记录准备就绪，它将被传递到逻辑数据流中的一个部分到下一个部分进行处理。 在数据处理期间记录的流程是基本上连续的并且是流媒体的方式。

公开(公告)号：US20040133565A1

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

申请号：US10667203

申请日：2003-09-18

Applicant: Netezza Corporation

Inventor： Foster D. Hinshaw ,  Raymond A. Andraka ,  David L. Meyers ,  Sharon L. Miller ,  Michael Sporer ,  William K. Stewart ,  Barry M. Zane

IPC: G06F007/00

CPC classification number: G06F17/30477 ,  G06F17/30578 ,  Y10S707/99944

Abstract: A programmable streaming data processor that can be programmed to recognize record and field structures of data received from a streaming data source such as a mass storage device. Being programmed with, for example, field information, the unit can locate record and field boundaries and employ logical arithmetic methods to compare fields with one another or with values otherwise supplied by general purpose processors to precisely determine which records are worth transferring to memory of the more general purpose distributed processors. The remaining records arrive and are discarded by the streaming data processor or are tagged with status bits to indicate to the more general purpose processor that they are to be ignored. In a preferred embodiment, the streaming data processor may analyze and discard records for several reasons. The first reason may be an analysis of contents of the field. Other reasons for record blocking may have to do with tagging records that are to be visible to particular users depending upon a series of concurrent transactions.

Abstract translation: 可编程流式数据处理器，其可以被编程以识别从诸如大容量存储设备的流数据源接收的数据的记录和场结构。 通过例如场信息进行编程，该单元可以定位记录和场边界，并采用逻辑运算方法将场相互比较，或者由通用处理器提供的值精确地确定哪些记录值得转移到 更通用的分布式处理器。 剩余的记录到达并被流式数据处理器丢弃，或者被标记为状态位，以向更通用的处理器指示它们被忽略。 在优选实施例中，流数据处理器可以由于几个原因来分析和丢弃记录。 第一个原因可能是对该领域内容的分析。 记录阻止的其他原因可能与标记根据一系列并发事务对特定用户可见的记录有关。

公开(公告)号：US20040078379A1

公开(公告)日：2004-04-22

申请号：US10653453

申请日：2003-09-02

Applicant: Netezza Corporation

Inventor： Foster D. Hinshaw ,  Craig S. Harris ,  Sunil K. Sarin

IPC: G06F007/00

CPC classification number: G06F17/30348 ,  Y10S707/99938 ,  Y10S707/99942

Abstract: A mechanism controls concurrency among database transactions through the use of serial ordering relations. The ordering relations are computed dynamically in response to patterns of use. An embodiment of the present invention serializes a transaction that accesses a resource before a transaction that modifies the resource, even if the accessor starts after the modifier starts or commits after the modifier commits. A method of concurrency control for a database transaction in a distributed database system stores an intended use of a database system resource by the database transaction in a serialization graph. A serialization ordering is asserted between the database transaction and other database transactions based on the intended use of the database system resource by the database transaction. The serialization ordering is then communicated to a node in the distributed database system that needs to know the serialization ordering to perform concurrency control. Cycles in the serialization graph are detected based on the asserted serialization order and in order to break such cycles and ensure transaction serializability a database transaction is identified that is a member of a cycle in the serialization graph.

Abstract translation: 一种机制通过使用串行排序关系来控制数据库事务之间的并发性。 排序关系是根据使用模式动态计算的。 本发明的一个实施例即使在修改器开始之后启动或在修饰符提交之后提交时，序列化在修改资源的事务之前访问资源的事务。 分布式数据库系统中的数据库事务的并发控制方法通过数据库事务在序列化图中存储数据库系统资源的预期用途。 基于数据库事务对数据库系统资源的预期用途，在数据库事务和其他数据库事务之间断言序列化排序。 然后将序列化顺序传送到分布式数据库系统中需要知道串行化排序以执行并发控制的节点。 序列化图中的循环根据断言的序列化顺序进行检测，为了打破这样的循环，并确保事务序列化，数据库事务被识别为序列化图中循环的成员。

公开(公告)号：US20040064439A1

公开(公告)日：2004-04-01

申请号：US10653455

申请日：2003-09-02

Applicant: Netezza Corporation

Inventor： Foster D. Hinshaw ,  Craig S. Harris ,  Sunil K. Sarin

IPC: G06F007/00

CPC classification number: G06F17/30348 ,  Y10S707/99938 ,  Y10S707/99942

Abstract: A mechanism controls concurrency among database transactions through the use of serial ordering relations. The ordering relations are computed dynamically in response to patterns of use. An embodiment of the present invention serializes a transaction that accesses a resource before a transaction that modifies the resource, even if the accessor starts after the modifier starts or commits after the modifier commits. A method of concurrency control for a database transaction in a distributed database system stores an intended use of a database system resource by the database transaction in a serialization graph. A serialization ordering is asserted between the database transaction and other database transactions based on the intended use of the database system resource by the database transaction. The serialization ordering is then communicated to a node in the distributed database system that needs to know the serialization ordering to perform concurrency control. Cycles in the serialization graph are detected based on the asserted serialization order and in order to break such cycles and ensure transaction serializability a database transaction is identified that is a member of a cycle in the serialization graph.

Abstract translation: 一种机制通过使用串行排序关系来控制数据库事务之间的并发性。 排序关系是根据使用模式动态计算的。 本发明的一个实施例即使在修改器开始之后启动或在修饰符提交之后提交时，序列化在修改资源的事务之前访问资源的事务。 分布式数据库系统中的数据库事务的并发控制方法通过数据库事务在序列化图中存储数据库系统资源的预期用途。 基于数据库事务对数据库系统资源的预期用途，在数据库事务和其他数据库事务之间断言序列化排序。 然后将序列化顺序传送到分布式数据库系统中需要知道串行化排序以执行并发控制的节点。 序列化图中的循环根据断言的序列化顺序进行检测，为了打破这样的循环，并确保事务序列化，数据库事务被识别为序列化图中循环的成员。

公开(公告)号：US20040268179A1

公开(公告)日：2004-12-30

申请号：US10776031

申请日：2004-02-10

Applicant: Netezza Corporation

Inventor： William K. Stewart

IPC: H02H003/05

CPC classification number: G06F11/2087 ,  G11B20/1879 ,  G11B2020/183 ,  G11B2220/2516 ,  G11B2220/415

Abstract: A technique for read error failover processing in a mirrored disk system such as a Redundant Array of Inexpensive Disks (RAID) system, where individual disk units perform Logical Block Address (LBA) remapping. A read error causes a disk controller to report an nullunrecoverablenull read error to a RAID controller. After receiving this report of an unrecoverable read error, rather than simply switching over to a mirror, the RAID controller first checks to see whether the disk that caused the error can successfully reassign an LBA. In particular, the RAID controller can retrieve the data that was associated with the failed LBA from the mirror, and then write that data to the offending disk. The disk controller for that disk will then perform its standard LBA remapping, and write the data to a new, good sector. Only if this process does not succeed is the offending disk then treated by the RAID controller as having failed sufficiently to require failover to the mirror.

公开(公告)号：US20030161118A1

公开(公告)日：2003-08-28

申请号：US10090116

申请日：2002-02-28

Applicant: Netezza Corporation

Inventor： Eric T. Bovell

IPC: H05K005/00 ,  H05K005/04 ,  H05K005/06

CPC classification number: G11B33/122 ,  G11B33/124 ,  H05K7/1409 ,  H05K7/1411

Abstract: A front panel for a circuit sled module performs several functions. The panel serves as the front panel to the circuit sled module, the panel comprises one or more hooks for engaging a catch on the tray when in a closed position, and the panel serves as an extraction lever when in the open position for removing the circuit sled module from the tray.

Abstract translation: 电路板模块的前面板执行几个功能。 该面板用作电路滑板模块的前面板，该面板包括一个或多个钩子，用于在处于关闭位置时与托盘上的卡扣接合，并且当处于打开位置时，该面板用作抽出杆，用于移除电路 雪橇模块从托盘。

公开(公告)号：US20030161116A1

公开(公告)日：2003-08-28

申请号：US10090119

申请日：2002-02-28

Applicant: Netezza Corporation

Inventor： Eric T. Bovell

IPC: H05K005/00 ,  H05K005/04 ,  H05K005/06

CPC classification number: G11B33/126 ,  G11B33/128

Abstract: An adjustable circuit sled module for a mass storage device has a housing, a mass storage device, a circuit board, a cover and spacers. The spacers position the mass storage device to align the power and data interface ports of the mass storage device with corresponding power and data interface connectors of the circuit board. The resulting sled module can be adjusted to accommodate a variety of brands and sizes of mass storage devices.

Abstract translation: 用于大容量存储装置的可调节电路滑块模块具有壳体，大容量存储装置，电路板，盖和间隔件。 间隔件定位大容量存储装置，以将大容量存储装置的电源和数据接口端口与电路板的相应电源和数据接口连接器对准。 所得到的滑板模块可以调节以适应各种品牌和大小的大容量存储设备。