公开(公告)号：US06604097B2

公开(公告)日：2003-08-05

申请号：US09915867

申请日：2001-07-26

申请人： San Yu Phoenix ,  Kalpana Shyam ,  James Zu-Chia Teng ,  Stephen Walter Turnbaugh ,  Julie Ann Watts

发明人： San Yu Phoenix ,  Kalpana Shyam ,  James Zu-Chia Teng ,  Stephen Walter Turnbaugh ,  Julie Ann Watts

IPC分类号： G06F1730

CPC分类号： G06F17/30595 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99953

摘要： Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.

公开(公告)号：US06886012B1

公开(公告)日：2005-04-26

申请号：US09193966

申请日：1998-11-18

申请人： San Yu Phoenix ,  Kalpana Shyam ,  James Zu-Chia Teng ,  Julie Ann Watts ,  Jay A. Yothers

发明人： San Yu Phoenix ,  Kalpana Shyam ,  James Zu-Chia Teng ,  Julie Ann Watts ,  Jay A. Yothers

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

CPC分类号： G06F17/30336 ,  G06F17/30504 ,  Y10S707/99938 ,  Y10S707/99952 ,  Y10S707/99953

摘要： Traditional update semantics are provided when updates change the location of records in a database. The system detects that an update to a record will cause the record to change locations in a database from an original location to an updated location. The system selectively prevents activity in the database between the original location and update location until the updated record has changed locations in the database from the original location to the updated location.

摘要翻译： 当更新更改数据库中记录的位置时，提供传统的更新语义。 系统检测到对记录的更新将导致记录将数据库中的位置从原始位置更改到更新的位置。 该系统选择性地防止在原始位置和更新位置之间的数据库中的活动，直到更新的记录已经将数据库中的位置从原始位置改变到更新的位置。

公开(公告)号：US06694305B2

公开(公告)日：2004-02-17

申请号：US09915866

申请日：2001-07-26

申请人： Margaret Ann Bernal ,  Christopher John Crone ,  San Yu Phoenix ,  Kalpana Shyam ,  James Zu-Chia Teng ,  Julie Ann Watts

发明人： Margaret Ann Bernal ,  Christopher John Crone ,  San Yu Phoenix ,  Kalpana Shyam ,  James Zu-Chia Teng ,  Julie Ann Watts

IPC分类号： G06F1730

CPC分类号： G06F17/30595 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99953

摘要： Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.

摘要翻译： 提供了一种用于使数据可用于应用程序的方法，系统，程序和数据结构。 生成结果表，其中包括与基表中具有满足查询谓词子句的一个或多个列中的数据的行子集相对应的行。 结果表对于每一行包括基表中相应行的位置标识符和查询选择列表中每列的列。 访问结果表以将请求的数据从基表返回到应用程序。

公开(公告)号：US06754653B2

公开(公告)日：2004-06-22

申请号：US09915868

申请日：2001-07-26

申请人： Charles Roy Bonner ,  San Yu Phoenix ,  Kalpana Shyam ,  Julie Ann Watts

发明人： Charles Roy Bonner ,  San Yu Phoenix ,  Kalpana Shyam ,  Julie Ann Watts

IPC分类号： G06F1730

CPC分类号： G06F17/30595 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99953

摘要： Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.

摘要翻译： 提供了一种用于使数据可用于应用程序的方法，系统，程序和数据结构。 生成结果表，其中包括与基表中具有满足查询谓词子句的一个或多个列中的数据的行子集相对应的行。 结果表对于每一行包括基表中相应行的位置标识符和查询选择列表中每列的列。 访问结果表以将请求的数据从基表返回到应用程序。

公开(公告)号：US6098075A

公开(公告)日：2000-08-01

申请号：US991291

申请日：1997-12-16

申请人： Richard Vincent Becraft, Jr. ,  Robert William Engles, deceased ,  Claire Louise Willey McFeely ,  San Yu Phoenix ,  Kalpana Shyam ,  Julie Ann Watts

发明人： Richard Vincent Becraft, Jr. ,  Robert William Engles, deceased ,  Claire Louise Willey McFeely ,  San Yu Phoenix ,  Kalpana Shyam ,  Julie Ann Watts

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99932 ,  Y10S707/99952

摘要： A method, apparatus, and article of manufacture for a computer implemented data manager. A statement is executed in a computer. The statement being performed by the computer to access data from a database stored on a data storage device connected to the computer. A determination is made as to whether to defer referential integrity checking when executing the statement. When it is determined that referential integrity checking is to be deferred, each record is processed that is specified in the statement. Keys for select records are stored as each record is processed. Then, after executing the statement, referential integrity checking is performed on the stored keys.

摘要翻译： 一种用于计算机实现的数据管理器的方法，装置和制品。 在计算机中执行语句。 由计算机执行的语句是从存储在连接到计算机的数据存储设备上的数据库中访问数据。 确定在执行语句时是否推迟引用完整性检查。 当确定引用完整性检查被推迟时，处理在报表中指定的每个记录。 每个记录被处理时存储选择记录的密钥。 然后，在执行该语句之后，对所存储的键执行参照完整性检查。

公开(公告)号：US06754656B1

公开(公告)日：2004-06-22

申请号：US08735168

申请日：1996-10-22

申请人： Karelle Lynne Cornwell ,  Barbara Tanya Couch ,  Robert William Lyle ,  James Zu-Chia Teng ,  Julie Ann Watts

发明人： Karelle Lynne Cornwell ,  Barbara Tanya Couch ,  Robert William Lyle ,  James Zu-Chia Teng ,  Julie Ann Watts

IPC分类号： G06F1730

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

摘要： A system and a method are described for selectively locking the partitions of a partitioned table in a relational database. The database system locks only those partitions of the table that are accessed by an application. Other partitions are available for concurrent access by other applications, regardless of the strength of the lock needed.

摘要翻译： 描述了用于选择性地将分区表的分区锁定在关系数据库中的系统和方法。 数据库系统仅锁定应用程序访问的表的那些分区。 其他分区可用于其他应用程序的并发访问，无论所需锁的强度如何。

公开(公告)号：US06665678B2

公开(公告)日：2003-12-16

申请号：US09750543

申请日：2000-12-28

申请人： Stephen Yao Ching Chen ,  Jerry Wayne Goldsmith ,  Kalpana Shyam ,  Julie Ann Watts

发明人： Stephen Yao Ching Chen ,  Jerry Wayne Goldsmith ,  Kalpana Shyam ,  Julie Ann Watts

IPC分类号： G06F1730

CPC分类号： G06F17/30595 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99953

摘要： Provided is a method, system, and program for performing a cursor operation. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. A command is received to perform a cursor operation with respect to a subject row in the result table. A lock is obtained on a row in the base table corresponding to the subject row in the result table. An operation specified in the received command is performed with respect to the subject row after obtaining the lock. The lock on the row in the base table is released after performing the operation.

公开(公告)号：US07231385B2

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

申请号：US10624964

申请日：2003-07-21

申请人： Margaret Ann Bernal ,  Christopher John Crone ,  Claire Willey McFeely ,  Kalpana Shyam ,  Julie Ann Watts

发明人： Margaret Ann Bernal ,  Christopher John Crone ,  Claire Willey McFeely ,  Kalpana Shyam ,  Julie Ann Watts

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

CPC分类号： G06F17/245 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99942

摘要： Provided are a method, system, and program for making data available to an application program. A cursor is generated positioned with respect to a result table, wherein the cursor specifies a search criteria, and wherein the result table includes rows from a base table that satisfy the search criteria. A fetch request is received indicating to position the cursor on a plurality of rows of the result table. The cursor is positioned on the plurality of rows of the result table indicated in the fetch request that satisfy the search criteria.

摘要翻译： 提供了一种使数据可用于应用程序的方法，系统和程序。 生成相对于结果表定位的游标，其中光标指定搜索条件，并且其中结果表包括来自基表的满足搜索条件的行。 接收到提取请求，指示将光标定位在结果表的多行上。 光标位于满足搜索条件的获取请求中指示的结果表的多行。

公开(公告)号：US06598041B1

公开(公告)日：2003-07-22

申请号：US09656558

申请日：2000-09-07

申请人： Margaret Ann Bernal ,  Christopher John Crone ,  Paramesh Desai ,  Georgia Carroll Fuller ,  Peter Hoa ,  Eric Naoto Katayama ,  William Y. Kyu ,  Kalpana Shyam ,  Julie Ann Watts ,  Jennifer Wha-Yuh Ou

发明人： Margaret Ann Bernal ,  Christopher John Crone ,  Paramesh Desai ,  Georgia Carroll Fuller ,  Peter Hoa ,  Eric Naoto Katayama ,  William Y. Kyu ,  Kalpana Shyam ,  Julie Ann Watts ,  Jennifer Wha-Yuh Ou

IPC分类号： G06F1730

CPC分类号： G06F17/30595 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99953

摘要： Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.

摘要翻译： 提供了一种用于使数据可用于应用程序的方法，系统，程序和数据结构。 生成结果表，其中包括与基表中具有满足查询谓词子句的一个或多个列中的数据的行子集相对应的行。 结果表对于每一行包括基表中相应行的位置标识符和查询选择列表中每列的列。 访问结果表以将请求的数据从基表返回到应用程序。

公开(公告)号：US5897641A

公开(公告)日：1999-04-27

申请号：US854937

申请日：1997-05-13

申请人： James Alan Ruddy ,  Kalpana Shyam ,  Gary H. Sockut ,  Julie Ann Watts

发明人： James Alan Ruddy ,  Kalpana Shyam ,  Gary H. Sockut ,  Julie Ann Watts

IPC分类号： G06F17/30

CPC分类号： G06F17/30368 ,  Y10S707/99942 ,  Y10S707/99953

摘要： A primary database's log records are used to update a second database that has a different encoding scheme than the log record and the primary database. This encoding scheme, for example, may involve compression, encryption, or another data transformation. First, a stale encoded data record from the second database is identified. This data record is one whose counterpart in the primary database has been updated in the primary database and where update has been logged. The stale data record is modified to reflect its contents as encoded by the first encoding scheme rather than the second. Then, the logged change is applied to update the modified record. The updated record is then decoded and subsequently re-encoded according to the second encoding scheme. This record is then stored in the second database replacing the stale second data record.

摘要翻译： 主数据库的日志记录用于更新具有与日志记录和主数据库不同的编码方案的第二个数据库。 该编码方案例如可以涉及压缩，加密或另一数据转换。 首先，识别来自第二数据库的陈旧的编码数据记录。 该数据记录是主数据库中对应的数据库已在主数据库中更新，并记录更新的数据。 陈旧的数据记录被修改以反映其由第一编码方案而不是第二编码方案编码的内容。 然后，应用记录的更改来更新修改的记录。 然后对更新的记录进行解码，然后根据第二编码方案重新编码。 然后将该记录存储在第二数据库中，代替陈旧的第二数据记录。