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

1. 发明授权

US06829616B2 Method, system, and program for implementing a database trigger 失效
标题翻译：用于实现数据库触发的方法，系统和程序
公开(公告)号：US06829616B2
公开(公告)日：2004-12-07
申请号：US09817501
申请日：2001-03-26
申请人： Yao Ching Stephen Chen , Karelle Lynne Cornwell , Tammie Dang , Beth Rivenes Moore , Kalpana Shyam
发明人： Yao Ching Stephen Chen , Karelle Lynne Cornwell , Tammie Dang , Beth Rivenes Moore , Kalpana Shyam
IPC分类号： G06F1730
CPC分类号： G06F17/3051 , G06F17/30318 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942 , Y10S707/99943
摘要： Provided is a method, system, and program for implementing a database trigger. Upon detecting a trigger event, a determination is made of at least one row in a base table affected by the trigger event. For each column in the base table of a data type that is referenced in a triggered action associated with the trigger event, a reference is generated referencing the data of the data type. The reference is inserted in a transition table column including data of the data type from the affected row in the base table referenced in the triggered action. The reference is used to access the data of the data type when performing the triggered action.
摘要翻译：提供了一种用于实现数据库触发的方法，系统和程序。在检测到触发事件时，确定受触发事件影响的基表中的至少一行。对于在与触发事件相关联的触发动作中引用的数据类型的基表中的每一列，生成引用数据类型数据的引用。引用被插入到转换表列中，包括在触发操作中引用的基表中的受影响行的数据类型的数据。该参考用于在执行触发动作时访问数据类型的数据。

2. 发明授权

US06721731B2 Method, system, and program for processing a fetch request for a target row at an absolute position from a first entry in a table 失效
标题翻译：用于处理来自表中第一条目的绝对位置处的目标行的提取请求的方法，系统和程序
公开(公告)号：US06721731B2
公开(公告)日：2004-04-13
申请号：US09915783
申请日：2001-07-26
申请人： Karelle Lynne Cornwell , San Yu Phoenix , Kalpana Shyam
发明人： Karelle Lynne Cornwell , San Yu Phoenix , Kalpana Shyam
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. 发明授权

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）列的实际数据被存储在单独的数据表中，并且每个数据表具有单独的节点标识符索引。使用包含文档标识符的密钥搜索节点标识符索引，并且使用逻辑节点标识符，并且检索包含分配有逻辑节点标识符的节点的数据表中的记录的记录标识符。

4. 发明授权

US06643637B2 Method, system, and program for using a fetch request to make data available to an application program 失效
公开(公告)号：US06643637B2
公开(公告)日：2003-11-04
申请号：US09915869
申请日：2001-07-26
申请人： Yao Ching Stephen Chen , Kalpana Shyam , Julie Ann Watts
发明人： Yao Ching Stephen Chen , 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. 发明申请

US20050027692A1 Method, system, and program for accessing data in a database table 审中-公开
标题翻译：用于访问数据库表中数据的方法，系统和程序
公开(公告)号：US20050027692A1
公开(公告)日：2005-02-03
申请号：US10629939
申请日：2003-07-29
申请人： Kalpana Shyam , Paramesh Desai , RamanaKumari Croisettier
发明人： Kalpana Shyam , Paramesh Desai , RamanaKumari Croisettier
IPC分类号： G06F17/30
CPC分类号： G06F16/24534 , G06F16/2228 , G06F16/24557
摘要： Provided are a method, system, and program for accessing data in a database table. A fetch request is received to fetch data from a base table that satisfies a query predicate, wherein rows of the base table are stored in table partitions and wherein there is one index partition for each determined table partition, wherein each index partition includes nodes, wherein each node in each index partition includes at least one key column value from a corresponding table row in the table partition associated with the index partition and a location identifier identifying the corresponding table row in the corresponding table partition. A determination is made of a set of nodes, one from each index partition, whose key column value satisfies the query predicate. One node from the set is selected and data is returned from the table row identified by the location identifier in the selected node in response to the fetch request.
摘要翻译：提供了一种用于访问数据库表中的数据的方法，系统和程序。接收到提取请求以从满足查询谓词的基表获取数据，其中基表的行存储在表分区中，并且其中每个确定的表分区存在一个索引分区，其中每个索引分区包括节点，其中每个索引分区中的每个节点包括与索引分区相关联的表分区中的相应表行的至少一个关键列值，以及标识相应表分区中的相应表行的位置标识符。确定一组节点，一个来自每个索引分区的节点，其关键字列值满足查询谓词。选择集合中的一个节点，并响应于提取请求从所选节点中的位置标识符标识的表行返回数据。

6. 发明授权

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

7. 发明授权

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.

8. 发明申请

US20050021505A1 Method, system, and program for positioning a cursor on rows of a result table 有权
标题翻译：用于将光标定位在结果表的行上的方法，系统和程序
公开(公告)号：US20050021505A1
公开(公告)日：2005-01-27
申请号：US10624964
申请日：2003-07-21
申请人： Margaret Bernal , Christopher Crone , Claire McFeely , Kalpana Shyam , Julie Watts
发明人： Margaret Bernal , Christopher Crone , Claire McFeely , Kalpana Shyam , Julie Watts
IPC分类号： G06F7/00
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.
摘要翻译：提供了一种使数据可用于应用程序的方法，系统和程序。生成相对于结果表定位的游标，其中光标指定搜索条件，并且其中结果表包括来自基表的满足搜索条件的行。接收到提取请求，指示将光标定位在结果表的多行上。光标位于满足搜索条件的获取请求中指示的结果表的多行。

9. 发明授权

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

10. 发明授权

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

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式