公开(公告)号：US07512625B2

公开(公告)日：2009-03-31

申请号：US11095619

申请日：2005-04-01

申请人： Josep L. Lariba-Pey ,  Victor Muntés-Mulero ,  Hebert W. Pereyra ,  Josep Aguilar-Saborit ,  Calisto P. Zuzarte

发明人： Josep L. Lariba-Pey ,  Victor Muntés-Mulero ,  Hebert W. Pereyra ,  Josep Aguilar-Saborit ,  Calisto P. Zuzarte

IPC分类号： G06F17/30

CPC分类号： G06F17/30466 ,  G06F17/30498 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99943

摘要： Disclosed is a data processing system implemented method, a data processing system, and an article of manufacturing for use with the data processing system. The data processing system implemented method is used for directing the data processing system to join rows associated with a column of a source table with rows associated with a column of a target table. The data processing system includes a source node containing the source table and including a target node containing the target table. The method includes generating a reduced representation of selected rows associated with the column of the source table, and generating a representation of the column of the target table, filtering the generated reduced representation of selected rows associated with the column of the source table through the generated representation of the column of the target table, the filtered generated reduced representation of selected rows identifying source table rows that do not have to be joined with the target table, and joining, to the rows associated with the column of the target table, the rows associated with the column of the source table minus the filtered generated reduced representation of selected rows.

摘要翻译： 公开了一种与数据处理系统一起使用的数据处理系统实现方法，数据处理系统和制造物品。 数据处理系统实现的方法用于指导数据处理系统连接与源表的列相关联的行，该行与目标表的列相关联。 数据处理系统包括包含源表并包括目标表的目标节点的源节点。 该方法包括生成与源表的列相关联的所选行的缩小表示，以及生成目标表的列的表示，通过生成的对源表的列相关联的所选行的过滤生成的缩小表示 目标表的列的表示，被筛选的生成的缩小表示，标识不必与目标表连接的源表行，并且将与加入目标表的列相关联的行加入到行中 与源表的列减去所筛选的生成的所选行的缩小表示相关联。

公开(公告)号：US06735605B2

公开(公告)日：2004-05-11

申请号：US09796843

申请日：2001-02-28

申请人： Paul M. Bird ,  Yuk Kuen Chan ,  Jesse Lee ,  Hebert W. Pereyra ,  Yeung-Kuen See ,  Michael J. Snowbell ,  Catharina K. Wong

发明人： Paul M. Bird ,  Yuk Kuen Chan ,  Jesse Lee ,  Hebert W. Pereyra ,  Yeung-Kuen See ,  Michael J. Snowbell ,  Catharina K. Wong

IPC分类号： G06F1730

CPC分类号： G06F17/30371 ,  Y10S707/99943 ,  Y10S707/99956

摘要： A multi-node relational database management system is provided that can be embodied in software for managing a database having declared temporary tables associated with respective software application programs. The system comprises a plurality of nodes. The nodes include a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for the application, the subordinate node having at least one partition of the declared temporary tables of the application; and a declared temporary table manager for causing the coordinator node to maintain for the application a list of declared temporary tables.

摘要翻译： 提供了一种多节点关系数据库管理系统，其可以用于管理具有与各个软件应用程序相关联的声明临时表的数据库的软件。 该系统包括多个节点。 节点包括用于维护与任何应用相关联的声明临时表的标识符列表的目录节点; 用于应用程序的协调器节点; 用于所述应用的至少一个下级节点，所述下级节点具有所述申请的已声明临时表的至少一个分区; 以及声明的临时表管理器，用于使协调器节点为应用程序维护已声明的临时表的列表。

公开(公告)号：US08583756B2

公开(公告)日：2013-11-12

申请号：US12243101

申请日：2008-10-01

申请人： Jack Hon Wai Ng ,  Jeffrey J. Goss ,  Hebert W. Pereyra ,  Kaarel Truuvert ,  Xun Xue

发明人： Jack Hon Wai Ng ,  Jeffrey J. Goss ,  Hebert W. Pereyra ,  Kaarel Truuvert ,  Xun Xue

IPC分类号： G06F15/167

CPC分类号： G06F9/5016

摘要： A database management system in which a plurality of nodes form a database instance, each node including a communication manager for dynamically configuring inter-nodal communication resources. The communication manager receives communication resource allocation requests from clients or a self-tuning algorithm. A resource self-tuning mechanism allocates or de-allocates memory blocks used for communication resource elements dynamically in real time without cycling the instance. Memory blocks are de-allocated asynchronously by placing associated communication resource elements in quarantine until all communication resource elements associated with the memory block are quarantined.

摘要翻译： 一种数据库管理系统，其中多个节点形成数据库实例，每个节点包括用于动态配置节点间通信资源的通信管理器。 通信管理器从客户端接收通信资源分配请求或自调整算法。 资源自整定机制实时分配或解除分配用于通信资源元素的存储块，而不需要循环实例。 通过将关联的通信资源元素放置在隔离中，直到与存储器块相关联的所有通信资源元素被隔离，才能异步地分配内存块。

公开(公告)号：US07433945B2

公开(公告)日：2008-10-07

申请号：US10410856

申请日：2003-04-09

申请人： Jack Hon Wai Ng ,  Jeffrey J. Goss ,  Hebert W. Pereyra ,  Kaarel Truuvert ,  Xun Xue

发明人： Jack Hon Wai Ng ,  Jeffrey J. Goss ,  Hebert W. Pereyra ,  Kaarel Truuvert ,  Xun Xue

IPC分类号： G06F15/173

CPC分类号： G06F9/5016

摘要： A database management system in which a plurality of nodes form a database instance, each node including a communication manager for dynamically configuring inter-nodal communication resources. The communication manager receives communication resource allocation requests from clients or a self-tuning algorithm. A resource self-tuning mechanism allocates or de-allocates memory blocks used for communication resource elements dynamically in real time without cycling the instance. Memory blocks are de-allocated asynchronously by placing associated communication resource elements in quarantine until all communication resource elements associated with the memory block are quarantined.

摘要翻译： 一种数据库管理系统，其中多个节点形成数据库实例，每个节点包括用于动态配置节点间通信资源的通信管理器。 通信管理器从客户端接收通信资源分配请求或自调整算法。 资源自整定机制实时分配或解除分配用于通信资源元素的存储块，而不需要循环实例。 通过将关联的通信资源元素放置在隔离中，直到与存储器块相关联的所有通信资源元素被隔离，才能异步地分配内存块。

公开(公告)号：US20080189710A1

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

申请号：US12105032

申请日：2008-04-17

申请人： David C. Kalmuk ,  Jon A. Lind ,  Hebert W. Pereyra ,  Xun Xue

发明人： David C. Kalmuk ,  Jon A. Lind ,  Hebert W. Pereyra ,  Xun Xue

IPC分类号： G06F9/46

CPC分类号： G06F9/544

摘要： An operating system directed to using special properties of a common inter-process communications mechanism (IPC), namely UNIX domain socket-pairs or stream-pipes alternatively as a storage medium for file-descriptors of UNIX processes. When a file-descriptor is written into a socket-pair, and closed in the UNIX process, the file remains open, but occupies no space in the process' file-table. The file-descriptor may later be read out of the socket-pair to reestablish it in the file-table, and access it. This property is implemented in an IPC mechanism of UNIX operating system whereby a process such as a dispatcher may manage more connections and processes than its file-table size allow. This provides scalability improvements of the UNIX operating system.

摘要翻译： 针对使用通用进程间通信机制（IPC）的特殊属性（即UNIX域套接字对或流管道）的操作系统作为UNIX进程的文件描述符的存储介质。 当文件描述符写入套接字对并在UNIX进程中关闭时，该文件保持打开，但在进程'file-table中不占用空间。 文件描述符可以稍后从套接字对中读出，以在文件表中重新建立文件描述符，并访问它。 该属性在UNIX操作系统的IPC机制中实现，其中诸如调度程序的进程可以管理比其文件表大小允许的更多的连接和进程。 这提供了UNIX操作系统的可扩展性改进。

公开(公告)号：US07934220B2

公开(公告)日：2011-04-26

申请号：US12049991

申请日：2008-03-17

申请人： David C. Kalmuk ,  Jon A Lind ,  Hebert W. Pereyra ,  Xun Xue

发明人： David C. Kalmuk ,  Jon A Lind ,  Hebert W. Pereyra ,  Xun Xue

IPC分类号： G06F9/44 ,  G06F15/16

CPC分类号： G06F9/544

摘要： An operating system directed to using special properties of a common inter-process communications mechanism (IPC), namely UNIX domain socket-pairs or stream-pipes alternatively as a storage medium for file-descriptors of UNIX processes. When a file-descriptor is written into a socket-pair, and closed in the UNIX process, the file remains open, but occupies no space in the process' file-table. The file-descriptor may later be read out of the socket-pair to reestablish it in the file-table, and access it. This property is implemented in an IPC mechanism of UNIX operating system whereby a process such as a dispatcher may manage more connections and processes than its file-table size allow. This provides scalability improvements of the UNIX operating system.

摘要翻译： 针对使用通用进程间通信机制（IPC）的特殊属性（即UNIX域套接字对或流管道）的操作系统作为UNIX进程的文件描述符的存储介质。 当文件描述符写入套接字对并在UNIX进程中关闭时，该文件保持打开，但在进程'file-table中不占用空间。 文件描述符可以稍后从套接字对中读出，以在文件表中重新建立文件描述符，并访问它。 该属性在UNIX操作系统的IPC机制中实现，其中诸如调度程序的进程可以管理比其文件表大小允许的更多的连接和进程。 这提供了UNIX操作系统的可扩展性改进。

公开(公告)号：US07844974B2

公开(公告)日：2010-11-30

申请号：US12105032

申请日：2008-04-17

申请人： David C. Kalmuk ,  Jon A. Lind ,  Hebert W. Pereyra ,  Xun Xue

发明人： David C. Kalmuk ,  Jon A. Lind ,  Hebert W. Pereyra ,  Xun Xue

IPC分类号： G06F9/44

CPC分类号： G06F9/544

摘要： An operating system directed to using special properties of a common inter-process communications mechanism (IPC), namely UNIX domain socket-pairs or stream-pipes alternatively as a storage medium for file-descriptors of UNIX processes. When a file-descriptor is written into a socket-pair, and closed in the UNIX process, the file remains open, but occupies no space in the process' file-table. The file-descriptor may later be read out of the socket-pair to reestablish it in the file-table, and access it. This property is implemented in an IPC mechanism of UNIX operating system whereby a process such as a dispatcher may manage more connections and processes than its file-table size allow. This provides scalability improvements of the UNIX operating system.

摘要翻译： 针对使用通用进程间通信机制（IPC）的特殊属性（即UNIX域套接字对或流管道）的操作系统作为UNIX进程的文件描述符的存储介质。 当文件描述符写入套接字对并在UNIX进程中关闭时，该文件保持打开，但在进程'file-table中不占用空间。 文件描述符可以稍后从套接字对中读出，以在文件表中重新建立文件描述符，并访问它。 该属性在UNIX操作系统的IPC机制中实现，其中诸如调度程序的进程可以管理比其文件表大小允许的更多的连接和进程。 这提供了UNIX操作系统的可扩展性改进。

公开(公告)号：US07373647B2

公开(公告)日：2008-05-13

申请号：US10427385

申请日：2003-04-30

申请人： David C. Kalmuk ,  Jon A Lind ,  Hebert W. Pereyra ,  Xun Xue

发明人： David C. Kalmuk ,  Jon A Lind ,  Hebert W. Pereyra ,  Xun Xue

IPC分类号： G06F9/44

CPC分类号： G06F9/544

摘要： An operating system directed to using special properties of a common inter-process communications mechanism (IPC), namely UNIX domain socket-pairs or stream-pipes alternatively as a storage medium for file-descriptors of UNIX processes. When a file-descriptor is written into a socket-pair, and closed in the UNIX process, the file remains open, but occupies no space in the process' file-table. The file-descriptor may later be read out of the socket-pair to reestablish it in the file-table, and access it. This property is implemented in an IPC mechanism of UNIX operating system whereby a process such as a dispatcher may manage more connections and processes than its file-table size allow. This provides scalability improvements of the UNIX operating system.

摘要翻译： 针对使用通用进程间通信机制（IPC）的特殊属性（即UNIX域套接字对或流管道）的操作系统作为UNIX进程的文件描述符的存储介质。 当文件描述符写入套接字对并在UNIX进程中关闭时，该文件保持打开，但在进程'file-table中不占用空间。 文件描述符可以稍后从套接字对中读出，以在文件表中重新建立文件描述符，并访问它。 该属性在UNIX操作系统的IPC机制中实现，其中诸如调度程序的进程可以管理比其文件表大小允许的更多的连接和进程。 这提供了UNIX操作系统的可扩展性改进。

公开(公告)号：US06839732B1

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

申请号：US09617637

申请日：2000-07-17

申请人： Tim J. Vincent ,  Xun Xue ,  Hebert W. Pereyra ,  Peter K. L. Shum ,  Jon A. Lind

发明人： Tim J. Vincent ,  Xun Xue ,  Hebert W. Pereyra ,  Peter K. L. Shum ,  Jon A. Lind

IPC分类号： H04L29/06 ,  H04L29/08 ,  G06F15/16 ,  G06F17/30

CPC分类号： H04L67/325 ,  H04L29/06 ,  H04L67/10 ,  H04L67/14 ,  H04L67/42 ,  H04L69/08 ,  H04L69/329

摘要： A gateway provides communication of tightly coupled XA transactions to a server hosting a DBMS and makes efficient use of domain socket pairs to implement demultiplexing in the gateway. The gateway includes a TCP/IP listener process which accepts connection requests from a transaction manager. Logical agents represent the application connection and are managed by a logical agent scheduler and are passed within the gateway using domain socket pairs. Gateway agents are dedicated to identified tightly coupled XA transactions to provide tightly coupled XA transaction support for DBMS systems which do not provide such support directly. The domain socket pairs in the gateway are assigned to logical agent schedulers and are available in a domain socket pool. A wait queue is provided to buffer logical agents when connection to the server is not available or where there are no domain socket pairs available in the domain socket pool. The wait queue is itself implemented as a domain socket pair.

公开(公告)号：US20080270590A1

公开(公告)日：2008-10-30

申请号：US12166316

申请日：2008-07-01

申请人： Jack Hon Wai Ng ,  Jeffrey J. Goss ,  Hebert W. Pereyra ,  Kaarel Truuvert ,  Xun Xue

发明人： Jack Hon Wai Ng ,  Jeffrey J. Goss ,  Hebert W. Pereyra ,  Kaarel Truuvert ,  Xun Xue

IPC分类号： G06F15/173

CPC分类号： G06F9/5016

摘要： A database management system in which a plurality of nodes form a database instance, each node including a communication manager for dynamically configuring inter-nodal communication resources. The communication manager receives communication resource allocation requests from clients or a self-tuning algorithm. A resource self-tuning mechanism allocates or de-allocates memory blocks used for communication resource elements dynamically in real time without cycling the instance. Memory blocks are de-allocated asynchronously by placing associated communication resource elements in quarantine until all communication resource elements associated with the memory block are quarantined.

摘要翻译： 一种数据库管理系统，其中多个节点形成数据库实例，每个节点包括用于动态配置节点间通信资源的通信管理器。 通信管理器从客户端接收通信资源分配请求或自调整算法。 资源自整定机制实时分配或解除分配用于通信资源元素的存储块，而不需要循环实例。 通过将关联的通信资源元素放置在隔离中，直到与存储器块相关联的所有通信资源元素被隔离，才能异步地分配内存块。