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

1. 发明授权

US06886012B1 Providing traditional update semantics when updates change the location of data records 有权
标题翻译：当更新更改数据记录的位置时，提供传统的更新语义
公开(公告)号：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.
摘要翻译：当更新更改数据库中记录的位置时，提供传统的更新语义。系统检测到对记录的更新将导致记录将数据库中的位置从原始位置更改到更新的位置。该系统选择性地防止在原始位置和更新位置之间的数据库中的活动，直到更新的记录已经将数据库中的位置从原始位置改变到更新的位置。

2. 发明授权

US06604097B2 Method, system, and program for using control data structures when performing operations with respect to a database 失效
公开(公告)号：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.

3. 发明授权

US06694305B2 Method, system, and program for processing modifications to data in tables in a database system 失效
标题翻译：用于处理数据库系统表中数据修改的方法，系统和程序
公开(公告)号：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.
摘要翻译：提供了一种用于使数据可用于应用程序的方法，系统，程序和数据结构。生成结果表，其中包括与基表中具有满足查询谓词子句的一个或多个列中的数据的行子集相对应的行。结果表对于每一行包括基表中相应行的位置标识符和查询选择列表中每列的列。访问结果表以将请求的数据从基表返回到应用程序。

4. 发明授权

US06754653B2 Method, system, and program for processing a fetch request for a target row in a table that precedes as current row 失效
标题翻译：用于处理在当前行之前的表中的目标行的提取请求的方法，系统和程序
公开(公告)号：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.
摘要翻译：提供了一种用于使数据可用于应用程序的方法，系统，程序和数据结构。生成结果表，其中包括与基表中具有满足查询谓词子句的一个或多个列中的数据的行子集相对应的行。结果表对于每一行包括基表中相应行的位置标识符和查询选择列表中每列的列。访问结果表以将请求的数据从基表返回到应用程序。

5. 发明授权

US6098075A Deferred referential integrity checking based on determining whether row at-a-time referential integrity checking would yield the same results as deferred integrity checking 失效
标题翻译：延迟引用完整性检查基于确定行一次性引用完整性检查是否会产生与延迟完整性检查相同的结果
公开(公告)号：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.
摘要翻译：一种用于计算机实现的数据管理器的方法，装置和制品。在计算机中执行语句。由计算机执行的语句是从存储在连接到计算机的数据存储设备上的数据库中访问数据。确定在执行语句时是否推迟引用完整性检查。当确定引用完整性检查被推迟时，处理在报表中指定的每个记录。每个记录被处理时存储选择记录的密钥。然后，在执行该语句之后，对所存储的键执行参照完整性检查。

6. 发明授权

US08572125B2 Scalable storage schemes for native XML column data of relational tables 有权
标题翻译：关系表的本机XML列数据的可扩展存储方案
公开(公告)号：US08572125B2
公开(公告)日：2013-10-29
申请号：US11209598
申请日：2005-08-22
申请人： Yao-Ching Stephen Chen , Fen-Ling Lin , Jerry Mukai , Kalpana Shyam , James Zu-Chia Teng , Guogen Zhang
发明人： Yao-Ching Stephen Chen , Fen-Ling Lin , Jerry Mukai , Kalpana Shyam , James Zu-Chia Teng , Guogen Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F17/30923
摘要： A method and system for providing a scalable storage scheme for native hierarchically structured data of relational tables, includes a base table with indicator columns with information pertaining to hierarchically structured data of a document, data tables for storing the hierarchically structured data corresponding to the indicator columns, and node identifier indexes corresponding to the data tables for mapping between the indicator columns and the hierarchically structured data in the data tables. In an embodiment, actual data for each hierarchically structured data (such as XML) column is stored in a separate data table, and each data table has a separate node identifier index. The node identifier index is searched with a key containing the document identifier and a logical node identifier is used, and a record identifier of a record in the data table containing the node assigned the logical node identifier is retrieved.
摘要翻译：提供用于关系表的本机分层结构化数据的可伸缩存储方案的方法和系统包括具有与文档的分层结构化数据有关的信息的指示符列的基表，用于存储对应于指示符列的分层结构化数据的数据表，以及与数据表对应的节点标识符索引，用于在指标列与数据表中的分层结构化数据之间进行映射。在一个实施例中，每个分级结构化数据（例如XML）列的实际数据被存储在单独的数据表中，并且每个数据表具有单独的节点标识符索引。使用包含文档标识符的密钥搜索节点标识符索引，并且使用逻辑节点标识符，并且检索包含分配有逻辑节点标识符的节点的数据表中的记录的记录标识符。

7. 发明授权

US06598041B1 Method, system, and program for processing modifications to data in tables in a database system 失效
标题翻译：用于在数据库中实现可滚动光标的方法，系统和程序
公开(公告)号：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.
摘要翻译：提供了一种用于使数据可用于应用程序的方法，系统，程序和数据结构。生成结果表，其中包括与基表中具有满足查询谓词子句的一个或多个列中的数据的行子集相对应的行。结果表对于每一行包括基表中相应行的位置标识符和查询选择列表中每列的列。访问结果表以将请求的数据从基表返回到应用程序。

8. 发明授权

US5897641A Application of log records to data compressed with different encoding scheme 失效
标题翻译：将日志记录应用于使用不同编码方案压缩的数据
公开(公告)号：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.
摘要翻译：主数据库的日志记录用于更新具有与日志记录和主数据库不同的编码方案的第二个数据库。该编码方案例如可以涉及压缩，加密或另一数据转换。首先，识别来自第二数据库的陈旧的编码数据记录。该数据记录是主数据库中对应的数据库已在主数据库中更新，并记录更新的数据。陈旧的数据记录被修改以反映其由第一编码方案而不是第二编码方案编码的内容。然后，应用记录的更改来更新修改的记录。然后对更新的记录进行解码，然后根据第二编码方案重新编码。然后将该记录存储在第二数据库中，代替陈旧的第二数据记录。

9. 发明授权

US06665678B2 Method, system, and program for optimistic concurrency control for scrollable cursors in a database 失效
公开(公告)号：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.

10. 发明授权

US07231385B2 Method, system, and program for positioning a cursor on rows of a result table 有权
标题翻译：用于将光标定位在结果表的行上的方法，系统和程序
公开(公告)号：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.
摘要翻译：提供了一种使数据可用于应用程序的方法，系统和程序。生成相对于结果表定位的游标，其中光标指定搜索条件，并且其中结果表包括来自基表的满足搜索条件的行。接收到提取请求，指示将光标定位在结果表的多行上。光标位于满足搜索条件的获取请求中指示的结果表的多行。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式