公开(公告)号：US20070233439A1

公开(公告)日：2007-10-04

申请号：US11278124

申请日：2006-03-30

申请人： MATTHEW CARROLL ,  Christian Garcia-Arellano ,  Sam Lightstone ,  Bruce Lindsay ,  Adam Storm ,  Daniele Zilio ,  Adriana Zubiri

发明人： MATTHEW CARROLL ,  Christian Garcia-Arellano ,  Sam Lightstone ,  Bruce Lindsay ,  Adam Storm ,  Daniele Zilio ,  Adriana Zubiri

IPC分类号： G06G7/48

CPC分类号： G06F17/5022

摘要： Methods and systems are provided for executing a simulation of an operation in a data processing system. In one implementation, the method includes executing an operation under a first set of conditions, determining a characteristic associated with the execution of the operation under the first set of conditions, and executing a simulation of the operation under a second set of conditions different from the first set of conditions. The simulation of the operation is constrained by the determined characteristic. The method can further include determining a cost/benefit of executing the operation under a set of conditions different from the first set of conditions based at least in part on the simulation.

摘要翻译： 提供了用于执行数据处理系统中的操作的模拟的方法和系统。 在一个实现中，该方法包括在第一组条件下执行操作，确定与第一组条件下的操作的执行相关联的特性，以及在与第二组条件不同的第二组条件下执行操作的模拟 第一套条件。 操作的模拟受到确定的特性的约束。 该方法还可以包括至少部分地基于模拟来确定在与第一组条件不同的一组条件下执行操作的成本/益处。

公开(公告)号：US20060218206A1

公开(公告)日：2006-09-28

申请号：US11423653

申请日：2006-06-12

申请人： Serge Bourbonnais ,  Elizabeth Hamel ,  Bruce Lindsay ,  Chengfei Liu ,  Jens Stankiewitz ,  Tuong Truong

发明人： Serge Bourbonnais ,  Elizabeth Hamel ,  Bruce Lindsay ,  Chengfei Liu ,  Jens Stankiewitz ,  Tuong Truong

IPC分类号： G06F17/30

CPC分类号： G06F16/2379 ,  G06F11/1471 ,  Y10S707/99942 ,  Y10S707/99953

摘要： A globally unique transaction identifier for each transaction is recorded in log entries pursuant to a two-phase commit protocol, wherein multiple log entries in multiple database recovery logs that correspond to one transaction have a same globally unique transaction identifier. A causally ordered, ascending timestamp value is maintained in the log entries pursuant to the two-phase commit protocol. For each of the multiple database recovery logs, all the log entries related to a single transaction are marked identically with a mark unique to the single transaction in a given one of the database recovery logs. Global changes are identified for the single transaction from the log entries in the multiple database recovery logs based on the marking and the globally unique transaction identifier for each transaction by reading log entries based on the causally ordered, ascending timestamp value.

摘要翻译： 每个事务的全局唯一事务标识符根据两阶段提交协议记录在日志条目中，其中对应于一个事务的多个数据库恢复日志中的多个日志条目具有相同的全局唯一事务标识符。 根据两阶段提交协议，在日志条目中维护因果秩序的升序时间戳值。 对于每个多个数据库恢复日志，与单个事务相关的所有日志条目在给定的一个数据库恢复日志中与单个事务唯一的标记相同地标记。 基于标记和每个事务的全局唯一事务标识符，通过基于因果排序的升序时间戳值读取日志条目，从多个数据库恢复日志中的日志条目中识别出单个事务的全局更改。

公开(公告)号：US20050193024A1

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

申请号：US10788556

申请日：2004-02-27

申请人： Kevin Beyer ,  Elizabeth Hamel ,  Bruce Lindsay ,  Clarence Pruet

发明人： Kevin Beyer ,  Elizabeth Hamel ,  Bruce Lindsay ,  Clarence Pruet

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30566 ,  G06F17/30286 ,  G06F17/30578

摘要： A method and system for providing convergence of data copies in asynchronous data replication in a database system, includes: labeling rows of a plurality of table copies with a monotonic number, a copy identification, and propagation controls; asynchronously capturing at least one labeled change to any row of any of the plurality of table copies from a database recovery log; determining that the captured change is to be communicated to others of the plurality of table copies; communicating the captured change to the others of the plurality of table copies; and applying the communicated change to the others of the plurality of table copies, where the plurality of table copies converge to a same state. In applying the communicated changes, conflicting changes are identified and resolved. In this manner, convergence of data copies in asynchronous data replication is provided, and processing and storage costs are significantly reduced.

摘要翻译： 一种用于在数据库系统中异步数据复制中提供数据副本的收敛的方法和系统，包括：用单调数，复制标识和传播控制标记多个表副本的行; 从数据库恢复日志中异步地将至少一个标记的更改捕获到多个表副本中的任一个的任何行的任何行; 确定所捕获的改变将被传送到所述多个表副本中的其他人; 将所捕获的改变传达给所述多个表格副本中的其他更改; 以及将所传送的改变应用于所述多个表副本中的其他表，其中所述多个表副本收敛到相同的状态。 在应用传达的更改时，会发现和解决冲突的变化。 以这种方式，提供异步数据复制中的数据副本的收敛，并且显着地减少处理和存储成本。

公开(公告)号：US20060020605A1

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

申请号：US10896154

申请日：2004-07-20

申请人： Petrus Chan ,  Miroslaw Flasza ,  Dieu La ,  Bruce Lindsay ,  William O'Connell

发明人： Petrus Chan ,  Miroslaw Flasza ,  Dieu La ,  Bruce Lindsay ,  William O'Connell

IPC分类号： G06F7/00

CPC分类号： G06F17/3051 ,  G06F17/30312 ,  G06F17/30371 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945

摘要： Disclosed is a data processing system, a data processing system-implemented method and an article of manufacture for providing general user availability while integrity processing of rolled-in data is deferred and performed incrementally. The data processing system includes a data warehouse administration module for administering a data warehouse to include a table dividable into portions for containing rows of rolled-in data, a first and a second delimiter delimiting the start and the end respectively of each portion, a metadata element having an entry corresponding to the start and end delimiters delimiting each portion, a third delimiter for delimiting, between the first delimiter and the third delimiter, a sub-portion of the portion, and an operations management module having operation mechanisms for performing operations on the data warehouse responsive to the delimiters.

摘要翻译： 公开了一种数据处理系统，数据处理系统实现的方法和用于提供一般用户可用性的制品，并且递推数据的完整性处理被延迟并执行。 数据处理系统包括数据仓库管理模块，用于管理数据仓库以将可分割的表分成用于包含滚动数据行的部分，分隔每个部分的开始和结束的第一和第二定界符，元数据 元素，其具有对应于限定每个部分的开始和结束分隔符的条目，用于在第一定界符和第三分隔符之间划分第三分隔符的第三分隔符，该部分的子部分，以及具有用于执行操作的操作机制的操作管理模块 数据仓库响应分隔符。

公开(公告)号：US20050193041A1

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

申请号：US10789775

申请日：2004-02-27

申请人： Serge Bourbonnais ,  Elizabeth Hamel ,  Bruce Lindsay ,  Stephen Todd

发明人： Serge Bourbonnais ,  Elizabeth Hamel ,  Bruce Lindsay ,  Stephen Todd

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30578 ,  G06F17/30345 ,  Y10S707/99938

摘要： An improved method for providing parallel apply in asynchronous data replication in a database system is disclosed. The improved method and system provides a high speed parallel apply of transactional changes to a target node such that the parallel nature of the application of changes does not compromise the integrity of the data. The method and system detects, tracks, and handles dependencies between transaction messages to be applied to the target node. If a transaction message has a dependency on one or more preceding transaction messages whose applications have not yet completed, that transaction message is held until the application completes. In addition, the method and system requires significantly less overhead than conventional approaches.

摘要翻译： 公开了一种用于在数据库系统中异步数据复制中并行应用的改进方法。 改进的方法和系统提供对目标节点的事务性改变的高速并行应用，使得应用改变的并行性质不损害数据的完整性。 该方法和系统检测，跟踪和处理要应用于目标节点的事务消息之间的依赖关系。 如果事务消息对应用程序尚未完成的一个或多个先前的事务消息具有依赖性，那么该事务消息将保持到应用程序完成为止。 此外，与常规方法相比，该方法和系统需要明显更少的开销。

公开(公告)号：US20060101011A1

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

申请号：US10982441

申请日：2004-11-05

申请人： Bruce Lindsay ,  Linqi Liu ,  Robert Neugebauer ,  Mir Pirahesh ,  David Sharpe ,  Nattavut Sutyanyong ,  Calisto Zuzarte

发明人： Bruce Lindsay ,  Linqi Liu ,  Robert Neugebauer ,  Mir Pirahesh ,  David Sharpe ,  Nattavut Sutyanyong ,  Calisto Zuzarte

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30454 ,  Y10S707/99932 ,  Y10S707/99933

摘要： Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for executing a query having a union operator. A data processing system implemented method direct the data processing system to execute a query against a database having data objects. The query has sub-queries and having a union operator. The union operator is operable on sub-queries associated with the query. The database is operatively coupled to the data processing system. The data processing system implemented method including grouping the sub-queries of the union operator according to identified structural similarities, the identified structural similarities being based on an analysis of the sub-queries, grouping the data objects of the database according to the grouped sub-queries, replacing the grouped data objects and any sub-queries associated with the grouped data objects with a reference to a representative data object and a representative sub-query, and accessing at least one member of the grouped data objects, the accessing of the at least one member of the grouped data object being based on the reference.

公开(公告)号：US20060101001A1

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

申请号：US10982337

申请日：2004-11-05

申请人： Bruce Lindsay ,  Linqi Liu ,  Robert Neugebauer ,  Mir Pirahesh ,  David Sharpe ,  Nattavut Sutyanyong ,  Calisto Zuzarte

发明人： Bruce Lindsay ,  Linqi Liu ,  Robert Neugebauer ,  Mir Pirahesh ,  David Sharpe ,  Nattavut Sutyanyong ,  Calisto Zuzarte

IPC分类号： G06F17/30

CPC分类号： G06F17/30454 ,  Y10S707/99933 ,  Y10S707/99934

摘要： Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for executing a query having a union operator. The data processing system implemented method directs the data processing system to process a query against data objects. The data objects are operatively coupled to the data processing system. The query includes a parent operator. The parent operator references a union operator. The union operator references sub-queries. The sub-queries reference the data objects. The data processing system implemented method includes noting a set of partitionings for the union operator, the noted set of partitionings being based on the sub-queries and being based on the data objects reference by the sub-queries, and executing the query having the union operator, the execution of the query being based on the noted set of partitionings and the parent operator.

摘要翻译： 公开了一种用于执行具有联合运算符的查询的数据处理系统实现方法，数据处理系统和制品。 数据处理系统实现的方法指导数据处理系统处理对数据对象的查询。 数据对象可操作地耦合到数据处理系统。 该查询包括父操作符。 父操作员引用联合运算符。 联合运算符引用子查询。 子查询引用数据对象。 所述数据处理系统实现的方法包括注意用于联合运算符的一组分区，所述一组分区基于子查询，并且基于由子查询引用的数据对象，并且执行具有联合的查询 操作员，查询的执行是基于所述的一组分区和父操作符。

公开(公告)号：US20050193037A1

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

申请号：US10789656

申请日：2004-02-26

申请人： Nicolas Adiba ,  Jaime Anaya ,  Elizabeth Hamel ,  Yat Lau ,  Siqun Li ,  Bruce Lindsay

发明人： Nicolas Adiba ,  Jaime Anaya ,  Elizabeth Hamel ,  Yat Lau ,  Siqun Li ,  Bruce Lindsay

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30578 ,  G06F11/1425 ,  G06F11/1479 ,  Y10S707/99953

摘要： A method and system for member initialization to and deactivation from an asynchronous data replication group in a database system is disclosed. The method and system allows new members to be added to the replication group or existing members to be removed from the replication group, without requiring the halting of the asynchronous replication of data. The performance advantages of asynchronous replication are still realized during member initialization or deactivation.

摘要翻译： 公开了一种用于在数据库系统中从异步数据复制组成员初始化和停用成员的方法和系统。 该方法和系统允许将新成员添加到要从复制组中删除的复制组或现有成员，而不需要暂停数据的异步复制。 在成员初始化或停用期间，异步复制的性能优势仍然可以实现。

公开(公告)号：US20070288537A1

公开(公告)日：2007-12-13

申请号：US11771801

申请日：2007-06-29

申请人： Serge BOURBONNAIS ,  Elizabeth Hamel ,  Bruce Lindsay ,  Stephen Todd

发明人： Serge BOURBONNAIS ,  Elizabeth Hamel ,  Bruce Lindsay ,  Stephen Todd

IPC分类号： G06F12/00

CPC分类号： G06F17/30578 ,  G06F17/30345 ,  Y10S707/99938

摘要： A method for handling transaction messages in asynchronous data replication in a database system, in which the database system includes a source node and a target node, and each transaction message has information concerning a row change to a table copy at the source node. The method includes determining whether a first transaction message has a dependency on a preceding non-completed transaction message. Responsive to the first transaction message having a dependency on the preceding non-completed transaction, the method further includes holding the first transaction message, completing the preceding non-completed transaction message including applying the row change associated with the preceding non-completed transaction message to the table copy at the target node, and responsive to completing the preceding non-completed transaction message, releasing the first transaction message and applying the row change associated with the first transaction message to the table copy at the target node.

摘要翻译： 一种用于在数据库系统中处理异步数据复制中的事务消息的方法，其中数据库系统包括源节点和目标节点，并且每个事务消息具有关于在源节点处的表副本的行更改的信息。 该方法包括确定第一交易消息是否具有对先前未完成的交易消息的依赖性。 响应于对先前未完成的交易具有依赖性的第一交易消息，该方法还包括保存第一交易消息，完成前述未完成交易消息，包括将与先前未完成的交易消息相关联的行变更应用于 在目标节点处的表副本，并且响应于完成上述未完成的交易消息，释放第一交易消息并将与第一交易消息相关联的行变更应用于目标节点处的表副本。

公开(公告)号：US20070085285A1

公开(公告)日：2007-04-19

申请号：US11253512

申请日：2005-10-19

申请人： Bruce Lindsay

发明人： Bruce Lindsay

IPC分类号： B62B3/00

CPC分类号： B62B3/001 ,  B62B5/065

摘要： A cart with a manually operated steering mechanism comprising a base coupled to a frame and a cart body with a steering column and steering mechanism. The base further comprises several mechanical steering linkages including a steering push rod, push rod slat, and tie rod; a rack and gear assembly where the gear is coupled to the steering column and the rack is coupled to the steering push rod; and a rack and pinion assembly where the rack is coupled to the tie rod and the pinion is coupled to a pinion shaft whereby a first end engages the rack and a second end is coupled to the steering column through a miter gear assembly. The mechanical linkages are supported by and coupled to the base by support braces and the steering column also capable of being telescopically adjustable.

摘要翻译： 具有手动操作的转向机构的推车包括联接到框架的底座和具有转向柱和转向机构的推车主体。 基座还包括几个机械转向连杆，包括转向推杆，推杆板条和拉杆; 齿轮和齿轮组件，其中齿轮联接到转向柱并且齿条联接到转向推杆; 以及齿条和小齿轮组件，其中齿条联接到拉杆并且小齿轮联接到小齿轮轴，由此第一端接合齿条，并且第二端通过斜切齿轮组件联接到转向柱。 机械连杆由支撑支架支撑并连接到底座，转向柱还能够可伸缩地调节。