专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US06735605B2 Method and apparatus for synchronizing not-logged application temporary tables in a multi-node relational database management system 失效
标题翻译：用于在多节点关系数据库管理系统中同步未记录的应用程序临时表的方法和装置
公开(公告)号：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.
摘要翻译：提供了一种多节点关系数据库管理系统，其可以用于管理具有与各个软件应用程序相关联的声明临时表的数据库的软件。该系统包括多个节点。节点包括用于维护与任何应用相关联的声明临时表的标识符列表的目录节点; 用于应用程序的协调器节点; 用于所述应用的至少一个下级节点，所述下级节点具有所述申请的已声明临时表的至少一个分区; 以及声明的临时表管理器，用于使协调器节点为应用程序维护已声明的临时表的列表。

2. 发明授权

US07934220B2 Method and system for optimizing file table usage 失效
标题翻译：优化文件表使用的方法和系统
公开(公告)号：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操作系统的可扩展性改进。

3. 发明授权

US07844974B2 Method and system for optimizing file table usage 失效
标题翻译：优化文件表使用的方法和系统
公开(公告)号：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操作系统的可扩展性改进。

4. 发明授权

US07373647B2 Method and system for optimizing file table usage 失效
标题翻译：优化文件表使用的方法和系统
公开(公告)号：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操作系统的可扩展性改进。

5. 发明授权

US06839732B1 Efficient use of domain socket pairs in communication for tightly coupled transactions 失效
标题翻译：在紧密耦合的事务通信中有效使用域套接字对
公开(公告)号：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.

6. 发明申请

US20080189710A1 Method and System for Optimizing File Table Usage 失效
标题翻译：用于优化文件表使用的方法和系统
公开(公告)号：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操作系统的可扩展性改进。

7. 发明授权

US08583756B2 Dynamic configuration and self-tuning of inter-nodal communication resources in a database management system 有权
标题翻译：数据库管理系统中节点间通信资源的动态配置和自调整
公开(公告)号：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.
摘要翻译：一种数据库管理系统，其中多个节点形成数据库实例，每个节点包括用于动态配置节点间通信资源的通信管理器。通信管理器从客户端接收通信资源分配请求或自调整算法。资源自整定机制实时分配或解除分配用于通信资源元素的存储块，而不需要循环实例。通过将关联的通信资源元素放置在隔离中，直到与存储器块相关联的所有通信资源元素被隔离，才能异步地分配内存块。

8. 发明授权

US07433945B2 Dynamic configuration and self-tuning of inter-nodal communication resources in a database management system 失效
标题翻译：数据库管理系统中节点间通信资源的动态配置和自调整
公开(公告)号：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.
摘要翻译：一种数据库管理系统，其中多个节点形成数据库实例，每个节点包括用于动态配置节点间通信资源的通信管理器。通信管理器从客户端接收通信资源分配请求或自调整算法。资源自整定机制实时分配或解除分配用于通信资源元素的存储块，而不需要循环实例。通过将关联的通信资源元素放置在隔离中，直到与存储器块相关联的所有通信资源元素被隔离，才能异步地分配内存块。

9. 发明授权

US07512625B2 Method, system and program for joining source table rows with target table rows 失效
标题翻译：将源表行与目标表行连接的方法，系统和程序
公开(公告)号：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.
摘要翻译：公开了一种与数据处理系统一起使用的数据处理系统实现方法，数据处理系统和制造物品。数据处理系统实现的方法用于指导数据处理系统连接与源表的列相关联的行，该行与目标表的列相关联。数据处理系统包括包含源表并包括目标表的目标节点的源节点。该方法包括生成与源表的列相关联的所选行的缩小表示，以及生成目标表的列的表示，通过生成的对源表的列相关联的所选行的过滤生成的缩小表示目标表的列的表示，被筛选的生成的缩小表示，标识不必与目标表连接的源表行，并且将与加入目标表的列相关联的行加入到行中与源表的列减去所筛选的生成的所选行的缩小表示相关联。

10. 发明申请

US20080270590A1 DYNAMIC CONFIGURATION AND SELF-TUNING OF INTER-NODAL COMMUNICATION RESOURCES IN A DATABASE MANAGEMENT SYSTEM 失效
标题翻译：数据库管理系统内部通信资源的动态配置与自我调整
公开(公告)号：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.
摘要翻译：一种数据库管理系统，其中多个节点形成数据库实例，每个节点包括用于动态配置节点间通信资源的通信管理器。通信管理器从客户端接收通信资源分配请求或自调整算法。资源自整定机制实时分配或解除分配用于通信资源元素的存储块，而不需要循环实例。通过将关联的通信资源元素放置在隔离中，直到与存储器块相关联的所有通信资源元素被隔离，才能异步地分配内存块。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式