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

21. 发明授权

US07765211B2 System and method for space management of multidimensionally clustered tables 失效
标题翻译：多维集群表的空间管理系统和方法
公开(公告)号：US07765211B2
公开(公告)日：2010-07-27
申请号：US10425781
申请日：2003-04-29
申请人： Bishwaranjan Bhattacharjee , Leslie A. Cranston , Matthew A. Huras , Bruce G. Lindsay , Timothy R. Malkemus , Catherine S. McArthur , Sriram K. Padmanabhan , Michael J. Winer
发明人： Bishwaranjan Bhattacharjee , Leslie A. Cranston , Matthew A. Huras , Bruce G. Lindsay , Timothy R. Malkemus , Catherine S. McArthur , Sriram K. Padmanabhan , Michael J. Winer
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30592
摘要： An information retrieval system and method are provided for minimizing the number of blocks searched in a cell before recording a new record in the table and determining which block can be assigned if a table has space available to store a new record in the case an additional block should be associated with a cell. Dimensions for a table are identified, and at least one block in the table is associated with a dimension value for each dimension, where each block comprises contiguous storage pages. The block can be further associated with a cell; this associated cell has a unique combination of dimension values comprising an dimension value for each of the dimensions. A unique associated bit list for each dimension value for each dimension has a unique corresponding list entry for each block associated with that dimension value, and a unique associated bit list for each cell has a unique corresponding list entry for each block associated with that cell.
摘要翻译：提供了一种信息检索系统和方法，用于在记录表中的新记录之前最小化在小区中搜索的块的数量，并且如果在具有可用于存储新记录的空间的情况下确定可以分配哪个块的附加块应该与一个单元格相关联。识别表的尺寸，并且表中的至少一个块与每个维的维度值相关联，其中每个块包括连续的存储页。该块可以进一步与细胞相关联; 该相关联的单元格具有维度值的唯一组合，其包括每个维度的维度值。每个维度的每个维度值的唯一关联位列具有与该维度值相关联的每个块的唯一对应列表条目，并且每个单元的唯一关联位列表具有与该单元相关联的每个块的唯一对应列表条目。

22. 发明授权

US5416917A Heterogenous database communication system in which communicating systems identify themselves and convert any requests/responses into their own data format 失效
标题翻译：异构数据库通信系统，其中通信系统识别自身并将任何请求/响应转换成他们自己的数据格式
公开(公告)号：US5416917A
公开(公告)日：1995-05-16
申请号：US66323
申请日：1993-05-21
申请人： John G. Adair , Daniel J. Coyle, Jr. , Robert J. Grafe , Bruce G. Lindsay , Roger A. Reinsch , Robert P. Resch , Patricia G. Selinger , Melvin R. Zimowski
发明人： John G. Adair , Daniel J. Coyle, Jr. , Robert J. Grafe , Bruce G. Lindsay , Roger A. Reinsch , Robert P. Resch , Patricia G. Selinger , Melvin R. Zimowski
IPC分类号： G06F12/00 , G06F17/30 , G06F3/00 , G06F13/00
CPC分类号： G06F17/30569 , Y10S707/922 , Y10S707/99942 , Y10S707/99954
摘要： The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved, and data conversions can be minimized. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. Any data conversions that may be necessary are done only by the receiver of the data, and only at the point where it is necessary to have the data represented in the receiver's native format for processing. For sending and receiving systems which match, data conversion is completely avoided, even when the data may have been forwarded through intermediate DBMS systems which do not match. For sending and receiving systems which do not match, data conversion is minimized. The data conversion routines and tables in each system are also minimized by requiring conversion only INTO a system's native format, never FROM its native format into some other format.
摘要翻译：本发明建立了可以相互理解和保存不同关系数据库管理系统之间交换的数据的上下文，并且可以最小化数据转换。本发明通过建立隔离机器特性，支持软件级别和用户数据描述的描述信息层来实现这一点。通过在开发和执行数据库管理系统的不同时间处理不同的描述符级别来实现优化处理。在协作的数据库管理系统之间交换最小的描述信息。可能需要的任何数据转换只能由数据的接收者进行，并且只有在需要以接收方的本机格式表示的数据进行处理的时候才能进行。对于匹配的发送和接收系统，完全避免数据转换，即使数据可能已经通过不匹配的中间DBMS系统转发。对于不匹配的发送和接收系统，数据转换最小化。每个系统中的数据转换例程和表也通过仅将INTO转换为系统的本机格式，从而将其本机格式从其他格式转换为最小化。

23. 发明授权

US5278978A Method and system for describing and exchanging data between heterogeneous database systems with data converted by the receiving database system 失效
标题翻译：用异构数据库系统与接收数据库系统转换数据之间的数据进行描述和交换的方法和系统
公开(公告)号：US5278978A
公开(公告)日：1994-01-11
申请号：US499114
申请日：1990-03-26
申请人： Richard A. Demers , Bruce G. Lindsay , Roger A. Reinsch , Melvin R. Zimowski
发明人： Richard A. Demers , Bruce G. Lindsay , Roger A. Reinsch , Melvin R. Zimowski
IPC分类号： G06F12/00 , G06F17/30 , G06F12/06
CPC分类号： G06F17/30569 , Y10S707/922 , Y10S707/99942 , Y10S707/99952
摘要： The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. For systems which match, data conversion is completely avoided. For systems which do not match, data conversion is minimized.
摘要翻译：本发明建立了可以相互理解和保存不同关系数据库管理系统之间交换数据的上下文。本发明通过建立隔离机器特性，支持软件级别和用户数据描述的描述信息层来实现这一点。通过在开发和执行数据库管理系统的不同时间处理不同的描述符级别来实现优化处理。在协作的数据库管理系统之间交换最小的描述信息。对于匹配的系统，完全避免数据转换。对于不匹配的系统，数据转换最小化。

24. 发明授权

US07600149B2 Failure transparency for update applications under single-master configuration 有权
标题翻译：在单主机配置下的更新应用程序的故障透明度
公开(公告)号：US07600149B2
公开(公告)日：2009-10-06
申请号：US11231204
申请日：2005-09-20
申请人： Bruce G. Lindsay , Inderpal S. Narang , Vijayshankar Raman
发明人： Bruce G. Lindsay , Inderpal S. Narang , Vijayshankar Raman
IPC分类号： G06F11/00
CPC分类号： G06F11/1482
摘要： A method masking data failures, when a master copy of data is unavailable comprises storing a single master copy of data and a replica copy of the data; writing to the master using a middleware component; and reading from either the master or the replica using the middleware component, when the master copy is unavailable. When the master is unavailable, the writes are stored in a table located in the middleware component as stored write requests, in which the stored write requests comprise UDI's to be made to the master. The reads are also performed from the table and the replica when the master is unavailable. When the master becomes available, the stored write requests are propagated to the master. Thus, the middleware allows the writes to run during times when the master is unavailable.
摘要翻译：当数据的主副本不可用时，屏蔽数据故障的方法包括存储数据的单个主副本和数据的副本副本; 使用中间件组件向主人写信; 并且当主副本不可用时，使用中间件组件从主控或副本读取。当主机不可用时，写入存储在位于中间件组件中的表中作为存储的写入请求，其中所存储的写入请求包括将要写入主机的UDI。当主机不可用时，也从表和副本执行读取。当主机可用时，存储的写入请求被传播到主机。因此，中间件允许写入在主机不可用的时间内运行。

25. 发明授权

US07287043B2 System and method for asynchronous data replication without persistence for distributed computing 有权
标题翻译：异步数据复制的系统和方法，无需持续分布式计算
公开(公告)号：US07287043B2
公开(公告)日：2007-10-23
申请号：US10645221
申请日：2003-08-21
申请人： Bruce G. Lindsay , Inderpal S. Narang , Vijayshankar Raman
发明人： Bruce G. Lindsay , Inderpal S. Narang , Vijayshankar Raman
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30578
摘要： A system and method of lightweight asynchronous data replication that avoids the need for any persistent store at the replication source or communication channel, and is independent of the underlying data formats, wherein the method of data replication comprises replicating deltas from a source, embedding replication tracking information in the replicated deltas, wherein the tracking information comprises a timestamp and a sequence number, and applying deltas at a target. The tracking information is used to ensure that each delta is applied exactly once. In the event of a crash in the system, the target analyzes the tracking information to determine which deltas have been applied, and requests retransmission of replicated data from the source starting from the earliest unapplied delta. The source and target are treated as only delta producers and consumers, and as such the invention is applicable to replication between arbitrary data source formats.
摘要翻译：轻量级异步数据复制的系统和方法，避免了复制源或通信通道上任何持久存储的需要，并且独立于底层数据格式，其中数据复制的方法包括从源复制三角形，嵌入复制跟踪复制三角形中的信息，其中所述跟踪信息包括时间戳和序列号，以及在目标上应用三角形。跟踪信息用于确保每个增量都应用一次。在系统崩溃的情况下，目标分析跟踪信息以确定已应用哪些增量，并且从最早未应用的增量开始从源发送重传数据。源和目标仅被视为增量生成器和消费者，因此本发明适用于任意数据源格式之间的复制。

26. 发明授权

US5257366A Query language execution on heterogeneous database servers using a bind-file bridge between application and database languages 失效
标题翻译：使用应用程序和数据库语言之间的绑定文件桥接在异构数据库服务器上查询语言执行
公开(公告)号：US5257366A
公开(公告)日：1993-10-26
申请号：US500032
申请日：1990-03-27
申请人： John G. Adair , Richard A. Demers , Dusan Ecimovic , Robert J. Grafe , Robert D. Jackson , Bruce G. Lindsay , Michael E. Murphy , Roger A. Reinsch , Robert P. Resch , Richard R. Sanders , Patricia G. Selinger , Robert L. Sunday , Melvin R. Zimowski
发明人： John G. Adair , Richard A. Demers , Dusan Ecimovic , Robert J. Grafe , Robert D. Jackson , Bruce G. Lindsay , Michael E. Murphy , Roger A. Reinsch , Robert P. Resch , Richard R. Sanders , Patricia G. Selinger , Robert L. Sunday , Melvin R. Zimowski
IPC分类号： G06F12/00 , G06F17/30 , G03F9/44 , G03F15/20
CPC分类号： G06F17/30557 , Y10S707/99934 , Y10S707/99939
摘要： Application programs which are developed and scheduled within a first computing system environment are permitted to access relational data registered at a remote database management system (DBMS) operating in a second computing environment dissimilar to the first computing environment. Access to data through the DBMS from an application execution site remote from the DBMS is supported by a process, logically subordinate to the application program which maps application program data access requests to the DBMS.

27. 发明授权

US4631673A Method for refreshing multicolumn tables in a relational data base using minimal information 失效
标题翻译：使用最少信息在关系数据库中刷新多列表的方法
公开(公告)号：US4631673A
公开(公告)日：1986-12-23
申请号：US693500
申请日：1985-01-22
申请人： Laura M. Haas , Bruce G. Lindsay
发明人： Laura M. Haas , Bruce G. Lindsay
IPC分类号： G06F12/00 , G06F7/22 , G06F17/30 , G06F15/20
CPC分类号： G06F17/30595 , Y10S707/99939 , Y10S707/99952
摘要： A method for refreshing a relational data base snapshot manifest in the form of remote read-only copies of selected portions of a base table. The method takes advantage of the fact that each tuple of the base table has a unique identifier TID associated therewith from the time the record is inserted until it is deleted. The TID references the physical location of the tuple within its relation. Two system-maintained fields are added to the base table. These are PREVTID and update ID. One system-maintained column is required in the snapshot table, i.e. BASE TID. Lastly, a column in the catalog of the snapshot is also maintained, i.e. SNAPHIGH.When the refresh of the snapshot table is required, a single scan of the base relation, in ascending TID sequence, is performed on the base table. The scan produces a series of messages which contain the incremental changes required to update the snapshot table to the current state of the base relation. Upon receipt of the messages at the snapshot table site, a single skip sequential pass across the snapshot in BASE TID sequence is performed to apply the incremental changes. This refreshes the snapshot table to the required state.
摘要翻译：用于以基表的所选部分的远程只读副本的形式刷新关系数据库快照清单的方法。该方法利用了从插入记录直到被删除的时间之后，基表的每个元组具有与其相关联的唯一标识符TID的事实。 TID在其关系中引用元组的物理位置。两个系统维护的字段被添加到基表中。这些是PREVTID和更新ID。快照表中需要一个系统维护的列，即BASE TID。最后，还保留快照目录中的列，即SNAPHIGH。当需要刷新快照表时，在基表上执行以升序TID序列的基本关系的单次扫描。扫描产生一系列消息，其中包含将快照表更新为基本关系的当前状态所需的增量更改。在快照表站点接收到消息后，将执行BASE TID序列中快照的单次跳过顺序，以应用增量更改。将快照表刷新到所需状态。

28. 发明授权

US08775371B2 Synchronizing an auxiliary data system with a primary data system 失效
标题翻译：辅助数据系统与主数据系统同步
公开(公告)号：US08775371B2
公开(公告)日：2014-07-08
申请号：US12616679
申请日：2009-11-11
申请人： Ronald J. Barber , Harish Deshmukh , Ning Li , Bruce G. Lindsay , Sridhar Rajagopalan , Roger C. Raphael , Eugene J. Shekita
发明人： Ronald J. Barber , Harish Deshmukh , Ning Li , Bruce G. Lindsay , Sridhar Rajagopalan , Roger C. Raphael , Eugene J. Shekita
IPC分类号： G06F17/30
CPC分类号： G06F17/30578 , G06F17/30545
摘要： Techniques are disclosed for synchronizing a primary data system with an auxiliary data system that processes data for the primary data system. In one embodiment, how current the primary data system and the auxiliary data system are is determined. Requests sent from the primary data system that were not processed by the auxiliary data system are determined. The requests are resent to the auxiliary data system for processing.
摘要翻译：公开了用于使主数据系统与处理主数据系统的数据的辅助数据系统同步的技术。在一个实施例中，确定主数据系统和辅助数据系统的当前时间。确定从主数据系统发送的未被辅助数据系统处理的请求。请求重新发送到辅助数据系统进行处理。

29. 发明申请

US20120059823A1 INDEX PARTITION MAINTENANCE OVER MONOTONICALLY ADDRESSED DOCUMENT SEQUENCES 有权
标题翻译：索引分割维护在单个寻址的文档序列中
公开(公告)号：US20120059823A1
公开(公告)日：2012-03-08
申请号：US12875615
申请日：2010-09-03
申请人： Ronald J. Barber , Harish Deshmukh , Ning Li , Bruce G. Lindsay , Sridhar Rajagopalan , Roger C. Raphael , Eugene J. Shekita , Paul S. Taylor
发明人： Ronald J. Barber , Harish Deshmukh , Ning Li , Bruce G. Lindsay , Sridhar Rajagopalan , Roger C. Raphael , Eugene J. Shekita , Paul S. Taylor
IPC分类号： G06F17/30
CPC分类号： G06F17/30233 , G06F17/30584 , G06F17/30631
摘要： Provided are techniques for partitioning a physical index into one or more physical partitions; assigning each of the one or more physical partitions to a node in a cluster of nodes; for each received document, assigning an assigned-doc-ID comprising an integer document identifier; and, in response to assigning the assigned-doc-ID to a document, determining a cut-off of assignment of new documents to a current virtual-index-epoch comprising a first set of physical partitions and placing the new documents into a new virtual-index-epoch comprising a second set of physical partitions by inserting each new document to a specific one of the physical partitions in the second set using one or more functions that direct the placement based on one of the assigned-doc-id, a field value derived from a set of fields obtained from the document, and a combination of the assigned-doc-id and the field value.
摘要翻译：提供了用于将物理索引分割成一个或多个物理分区的技术; 将一个或多个物理分区中的每一个分配给节点簇中的节点; 对于每个接收到的文档，分配包括整数文档标识符的分配文档ID; 并且响应于将分配的文档ID分配给文档，确定新文档的分配到当前虚拟索引时期的截断，该当前虚拟索引时期包括第一组物理分区，并将新文档放入新的虚拟 - 指数 - 历元包括第二组物理分区，通过使用一个或多个基于所分配的文档ID中的一个来指导所述布局的功能，将每个新文档插入第二组中的特定一个物理分区从文档获得的一组字段中导出的值以及分配的doc-id和字段值的组合。

30. 发明授权

US07085751B2 Query execution in query processing systems 失效
标题翻译：在查询处理系统中查询执行
公开(公告)号：US07085751B2
公开(公告)日：2006-08-01
申请号：US09757427
申请日：2001-01-10
申请人： Ian R. Finlay , Bruce G. Lindsay , Guy M. Lohman , David C. Sharpe , Daniel C. Zilio
发明人： Ian R. Finlay , Bruce G. Lindsay , Guy M. Lohman , David C. Sharpe , Daniel C. Zilio
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30477 , Y10S707/954 , Y10S707/99931 , Y10S707/99933 , Y10S707/99943
摘要： A query processing system having a data manager, and a query manager also includes a buffer. The query manager calls the data manager to access data based on a query. Where there is no predicate check or consumption operation on the record accessed, the data manager will notionally return the record to the query manager. However, the data manager accomplishes the return by writing the relevant portions of the record to a buffer. The data manager maintains stabilization of the page containing the record while the buffer is being written to. The data manager continues to access records on the stabilized page and to write such records to the buffer where appropriate. The query manager retrieves the records from the buffer after the data manager has completed its operation resulting from the query manager call.
摘要翻译：具有数据管理器和查询管理器的查询处理系统还包括缓冲器。查询管理器根据查询调用数据管理器访问数据。在访问记录上没有谓词检查或消费操作的情况下，数据管理器将会将记录返回给查询管理器。然而，数据管理器通过将记录的相关部分写入缓冲器来完成返回。在缓冲区被写入时，数据管理器维护包含记录的页面的稳定性。数据管理器继续访问稳定页面上的记录，并在适当时将此类记录写入缓冲区。在数据管理器完成由查询管理器调用产生的操作之后，查询管理器从缓冲区中检索记录。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式