公开(公告)号：US07260569B1

公开(公告)日：2007-08-21

申请号：US10081079

申请日：2002-02-21

申请人： Rolf Günter Erich Stegelmann ,  Jeetendra Chaware

发明人： Rolf Günter Erich Stegelmann ,  Jeetendra Chaware

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

CPC分类号： G06F8/31 ,  Y10S707/955 ,  Y10S707/99934

摘要： A database system includes components for executing stored procedures that include at least one of a conditional expression, assignment expression, and dynamic database query language (e.g., SQL) statement. For each such expression, a predetermined type of code is generated and inserted into the object code corresponding to the stored procedure. When executing the stored procedure object code, the predetermined type of code is evaluated directly without having to generate a separate database query language statement.

摘要翻译： 数据库系统包括用于执行包括条件表达式，分配表达式和动态数据库查询语言（例如，SQL）语句中的至少一个的存储过程的组件。 对于每个这样的表达式，生成预定类型的代码并将其插入到对应于存储过程的目标代码中。 当执行存储过程对象代码时，直接评估预定类型的代码，而不必生成单独的数据库查询语言语句。

公开(公告)号：US06374236B1

公开(公告)日：2002-04-16

申请号：US09454729

申请日：1999-12-04

申请人： James Chen ,  Chi Kim Hoang ,  Mark Anthony Hodgens ,  Frederick Stuart Kaufmann ,  Rolf Günter Erich Stegelmann

发明人： James Chen ,  Chi Kim Hoang ,  Mark Anthony Hodgens ,  Frederick Stuart Kaufmann ,  Rolf Günter Erich Stegelmann

IPC分类号： G06F1730

CPC分类号： G06F17/30445 ,  G06F17/3051 ,  Y10S707/99932

摘要： A method, apparatus, and article of manufacture for accessing a subject table in a computer system. The subject table is partitioned across a plurality of processing units of the computer system. A trigger is defined for the subject table, such that when a triggering event occurs on the subject table, a triggered action is performed. Both the triggering event and triggered action can be performed in parallel by the computer system. A spool table is generated for each partition of the subject table, wherein the spool table stores one or more necessary records accessed from the subject table by the triggering event. In this manner, triggered actions that refer to these necessary rows need not access the subject table again.

摘要翻译： 一种用于访问计算机系统中的主题表的方法，装置和制品。 主题表在计算机系统的多个处理单元之间被划分。 为主题表定义了触发器，使得当主体表上发生触发事件时，执行触发动作。 触发事件和触发动作都可以由计算机系统并行执行。 为主题表的每个分区生成假脱机表，其中假脱机表存储通过触发事件从主题表访问的一个或多个必要记录。 以这种方式，引用这些必要行的触发动作不需要再次访问主题表。

公开(公告)号：US07051051B1

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

申请号：US09729806

申请日：2000-12-05

申请人： Rolf Günter Erich Stegelmann

发明人： Rolf Günter Erich Stegelmann

IPC分类号： G06F12/00

CPC分类号： G06F11/1474 ,  G06F2201/80 ,  Y10S707/99953

摘要： In a database system, when an operation (a request or a transaction) that modifies one or more rows of a table is performed, multiple images of the row that is being modified (e.g., added, deleted, or updated) is stored in the table. State identifiers are provided to identify the state of each row, such as a “before image” row and an “after image” row. A before image row represents a row before a modification or “mutation” operation is performed. An after image row represents the latest row as processed by a current modification operation. A before image row is retained in each table as long as the transaction that created or updated the row is active. As soon as the transaction commits successfully, the before image rows become reusable and can be reused by another request or transaction. The state identifier associated with each row can also indicate that a “mutation” is not being performed on a row; that is, an operation that modifies the contents of the row is not currently being performed.

摘要翻译： 在数据库系统中，当执行修改表的一行或多行的操作（请求或事务）时，将修改（例如，添加，删除或更新）的行的多个映像存储在 表。 提供状态标识符以识别每行的状态，例如“前图像”行和“后图像”行。 前图像行表示执行修改或“突变”操作之前的一行。 后续图像行表示由当前修改操作处理的最新行。 只要创建或更新行的事务处于活动状态，每个表中就保留一个前一个图像行。 一旦事务成功提交，之前的图像行就可以重用，可以被另一个请求或事务重用。 与每一行相关联的状态标识符也可以指示一行中没有执行“突变”; 也就是说，修改行的内容的操作当前没有被执行。

公开(公告)号：US06772155B1

公开(公告)日：2004-08-03

申请号：US09825906

申请日：2001-04-04

申请人： Rolf Günter Erich Stegelmann

发明人： Rolf Günter Erich Stegelmann

IPC分类号： G06F1730

CPC分类号： G06F17/30362 ,  Y10S707/99938 ,  Y10S707/99942 ,  Y10S707/99953

摘要： A database system includes a storage module containing a table having plural portions (e.g., rows). A lock manager places a table-level lock on the table for a first transaction, the first transaction updating a first row of the table. The lock manager converts the table-level lock to a lower level lock to lock the first table portion if a second transaction requests an access of the first portion of the table.

摘要翻译： 数据库系统包括存储模块，该存储模块包含具有多个部分（例如行）的表格。 锁定管理器在表上放置表级锁定用于第一个事务，第一个事务更新表的第一行。 如果第二个事务请求访问表的第一部分，则锁管理器将表级锁定转换为较低级别的锁来锁定第一表部分。

公开(公告)号：US06438558B1

公开(公告)日：2002-08-20

申请号：US09471736

申请日：1999-12-23

申请人： Rolf Günter Erich Stegelmann

发明人： Rolf Günter Erich Stegelmann

IPC分类号： G06F1730

CPC分类号： G06F17/30575 ,  Y10S707/99934 ,  Y10S707/99943

摘要： A method, apparatus, and article of manufacture for replicating modifications made to a subject table from a primary system to a subscriber system. A subject table is partitioned across a plurality of processors in both the primary and subscriber systems, wherein each of the processors manages at least one partition of the subject table. Change row messages are generated for each modification made to a subject table, wherein the change row message identifies the processor in the primary system making the modification, and includes a sequence number for the processor in the primary system. The processor in the primary system identified in the change row message is re-mapped to a new processor in the subscriber system and the sequence number for the processor in the primary system identified in the change row message is re-mapped to a new sequence number for the new processor in the subscriber system, so that the modifications are applied in a correct order on the subscriber system.

摘要翻译： 一种用于将主题表从主系统复制到用户系统的修改的方法，装置和制品。 主表和主用户系统中的多个处理器分割主题表，其中每个处理器管理主题表的至少一个分区。 为对主题表进行的每个修改生成更改行消息，其中改变行消息标识在进行修改的主系统中的处理器，并且包括用于主系统中的处理器的序列号。 在更改行消息中识别的主系统中的处理器被重新映射到订户系统中的新处理器，并且将在更改行消息中标识的主系统中的处理器的序列号重新映射到新的序列号 对于订户系统中的新处理器，使得修改在订户系统上以正确的顺序应用。