公开(公告)号：US5884327A

公开(公告)日：1999-03-16

申请号：US719523

申请日：1996-09-25

Applicant: Curt Lee Cotner ,  Richard Anthony Crus ,  Brian Keith Howell ,  James Willis Pickel ,  David Joseph Wisneski

Inventor： Curt Lee Cotner ,  Richard Anthony Crus ,  Brian Keith Howell ,  James Willis Pickel ,  David Joseph Wisneski

IPC: G06F11/14 ,  G06F17/30 ,  G06F17/00

CPC classification number: G06F17/30377 ,  Y10S707/99938 ,  Y10S707/99952 ,  Y10S707/99953

Abstract: The system, method, and program of this invention allows a two-phase commit protocol to work properly, even when the client acting as the coordinator does not have a log to record two-phase state information. In a preferred embodiment, the client in a client/server distributed transaction processing system is a personal computer. The client, without a recovery log, acts as a coordinator of a commit process. The coordinator migrates, i.e., passes, responsibility for resynchronization, and any associated logging requirement, to a server, e.g., to any of the connected relational database management system (RDBMS) servers, which is a participant in the transaction. The server uses its own recovery log for use in satisfying the logging requirement.

Abstract translation: 本发明的系统，方法和程序允许两阶段提交协议正常工作，即使当作为协调器的客户端没有记录来记录两相状态信息时。 在优选实施例中，客户端/服务器分布式事务处理系统中的客户端是个人计算机。 没有恢复日志的客户端充当提交进程的协调器。 协调者迁移，即将重新同步的责任和任何关联的记录要求传递给服务器，例如，作为交易参与者的任何连接的关系数据库管理系统（RDBMS）服务器。 服务器使用自己的恢复日志来满足日志需求。

公开(公告)号：US06912714B1

公开(公告)日：2005-06-28

申请号：US09605779

申请日：2000-06-28

Applicant: Stephen James Cocks ,  Russell Ley Newcombe ,  Lori Milhans VanGulick ,  David Joseph Wisneski

Inventor： Stephen James Cocks ,  Russell Ley Newcombe ,  Lori Milhans VanGulick ,  David Joseph Wisneski

IPC: G06F9/46 ,  G06F15/163 ,  G06F17/30 ,  H04L29/08

CPC classification number: G06F9/465 ,  G06F2209/463 ,  G06Q10/00 ,  H04L67/10 ,  H04L69/329

Abstract: A method and implementing system are provided in which CORBA (Common Object Request Broker Architecture) Life Cycle Service factory finding capabilities are utilized by a CORBA Query Service query evaluator to find queriable collections using simple names. The Life Cycle Service, using the simple name, searches a distributed object oriented environment for both Home and non-Home collections. Means are also provided to make known to Life Cycle Services, the queriable collections which are not also Homes.

Abstract translation: 提供了一种方法和实现系统，其中CORBA（通用对象请求代理体系结构）生命周期服务工厂查找功能由CORBA查询服务查询评估器利用，以使用简单的名称查找可验证的集合。 生命周期服务使用简单的名称搜索面向对象的面向环境的家庭和非家庭收藏。 还提供了“生命周期服务”，“不可回收”的可验收集合的方法。

公开(公告)号：US06484181B2

公开(公告)日：2002-11-19

申请号：US10043076

申请日：2002-01-09

Applicant: Gopi Krishna Attaluri ,  David Joseph Wisneski

Inventor： Gopi Krishna Attaluri ,  David Joseph Wisneski

IPC: G06F1730

CPC classification number: G06F17/30595 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99953

Abstract: A method and system for handling foreign key database updates. The database includes one or more tables where each table includes at least one row and a primary key or foreign key. The method and system include evaluating a list of row operations for foreign key relationships. After evaluating the foreign key relationships, the tables determined to have acyclic foreign key relationships are grouped into a first set of tables and the tables determined to have cyclic foreign key relationships are grouped into a second set of tables. The method and system further include ordering the first set of tables into a list based on the foreign key relationships among the set of tables, such that a parent table will be processed before a child table. The row operations are then applied to each table in the list in the specified order.

Abstract translation: 用于处理外键数据库更新的方法和系统。 数据库包括一个或多个表，其中每个表包括至少一行和主键或外键。 方法和系统包括评估外键关系的行操作列表。 在评估外键关系之后，确定具有非循环外键关系的表被分组为第一组表，并且被确定为具有循环外键关系的表被分组为第二组表。 方法和系统还包括基于表集合中的外键关系将第一组表排序到列表中，使得父表在子表之前被处理。 行操作然后以指定的顺序应用于列表中的每个表。

公开(公告)号：US06466931B1

公开(公告)日：2002-10-15

申请号：US09364755

申请日：1999-07-30

Applicant: Gopi Krishna Attaluri ,  David Joseph Wisneski

Inventor： Gopi Krishna Attaluri ,  David Joseph Wisneski

IPC: G06F1730

CPC classification number: G06F17/30433 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

Abstract: A method and system for transparently caching and reusing database query execution plans. The method and system include caching a first query that contains a first constant. A first query is associated with an execution plan that represent the first constant with a parameter name. The method and system further include receiving a new query that contains a second constant and comparing the new query with the first query. A match is determined to exist even when the second constant fails to match the first constant. Upon a match, the first query execution plan is reused by substituting the parameter name in the query execution plan with the second constant from the new query, thereby avoiding generating a new query

Abstract translation: 一种透明缓存和重用数据库查询执行计划的方法和系统。 方法和系统包括缓存包含第一个常数的第一个查询。 第一个查询与表示具有参数名称的第一个常量的执行计划相关联。 所述方法和系统还包括接收包含第二常数并将新查询与第一查询进行比较的新查询。 即使第二个常数不能匹配第一个常数，也确定匹配存在。 匹配后，第一个查询执行计划通过使用新查询中的第二个常量替换查询执行计划中的参数名称，从而避免生成新查询

公开(公告)号：US06339777B1

公开(公告)日：2002-01-15

申请号：US09364671

申请日：1999-07-30

Applicant: Gopi Krishna Attaluri ,  David Joseph Wisneski

Inventor： Gopi Krishna Attaluri ,  David Joseph Wisneski

IPC: G06F1730

CPC classification number: G06F17/30595 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99953

Abstract: A method and system for handling foreign key database updates. The database includes one or more tables where each table includes at least one row and a primary key or foreign key. The method and system include evaluating a list of row operations for foreign key relationships. After evaluating the foreign key relationships, the tables determined to have acyclic foreign key relationships are grouped into a first set of tables and the tables determined to have cyclic foreign key relationships are grouped into a second set of tables. The method and system further include ordering the first set of tables into a list based on the foreign key relationships among the set of tables, such that a parent table will be processed before a child table. The row operations are then applied to each table in the list in the specified order.