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

11. 发明授权

US07076508B2 Method, system, and program for merging log entries from multiple recovery log files 失效
标题翻译：用于合并来自多个恢复日志文件的日志条目的方法，系统和程序
公开(公告)号：US07076508B2
公开(公告)日：2006-07-11
申请号：US10217707
申请日：2002-08-12
申请人： Serge Bourbonnais , Elizabeth Belva Hamel , Bruce G. Lindsay , Chengfei Liu , Jens Stankiewitz , Tuong Chanh Truong
发明人： Serge Bourbonnais , Elizabeth Belva Hamel , Bruce G. Lindsay , Chengfei Liu , Jens Stankiewitz , Tuong Chanh Truong
IPC分类号： G06F17/30
CPC分类号： G06F17/30377 , G06F11/1471 , Y10S707/99942 , Y10S707/99953
摘要： Provided are a method, system, and program for merging independent log entries in a multiple node shared nothing DBMS. Initially, log entries from multiple log entries are combined to form a single log entry sequence. Local transactions are generated from the single log entry sequence and stored in a local transactions structure. In particular, log entries with the same local transaction identifier form a local transaction. Then, local transactions having the same global identifier are merged to form global transactions.
摘要翻译：提供了一种方法，系统和程序，用于合并多个节点中的独立日志条目，不共享DBMS。最初，来自多个日志条目的日志条目被组合以形成单个日志条目序列。本地事务从单个日志条目序列生成并存储在本地事务结构中。特别地，具有相同本地事务标识符的日志条目形成本地事务。然后，具有相同全局标识符的本地事务被合并以形成全局事务。

12. 发明授权

US07552119B2 Apparatus and method for skipping XML index scans with common ancestors of a previously failed predicate 有权
标题翻译：用以前故障谓词的共同祖先跳过XML索引扫描的设备和方法
公开(公告)号：US07552119B2
公开(公告)日：2009-06-23
申请号：US11613757
申请日：2006-12-20
申请人： Edison Lao Ting , Tuong Chanh Truong
发明人： Edison Lao Ting , Tuong Chanh Truong
IPC分类号： G06F17/30
CPC分类号： G06F17/30938 , Y10S707/99936 , Y10S707/99943
摘要： An apparatus and method are disclosed for skipping XML index scans with common ancestors of a previously failed predicate. An XML index is scanned by an XML index scan to filter entries of the index matching at least one search value (predicate) of an XML query. When the XML index scan finds a matching entry, the entry is passed to an XPath evaluation component. The XPath evaluation component evaluates the entry against remaining predicates of the XML query for further qualification. When the XPath evaluation component disqualifies an entry, the XPath evaluation component provides feedback to the XML index scan to skip remaining entries comprising a common ancestor of the disqualified entry's path. The XML index scan can then efficiently skip index entries that will not qualify against the XML query.
摘要翻译：公开了一种用于跳过具有先前故障谓词的共同祖先的XML索引扫描的装置和方法。通过XML索引扫描扫描XML索引，以过滤与XML查询的至少一个搜索值（谓词）匹配的索引的条目。当XML索引扫描找到匹配的条目时，该条目将传递给XPath评估组件。 XPath评估组件根据XML查询的剩余谓词评估条目以进一步验证。当XPath评估组件取消条目资格时，XPath评估组件向XML索引扫描提供反馈，以跳过包含不合格条目路径的共同祖先的剩余条目。然后，XML索引扫描可以有效地跳过不符合XML查询条件的索引条目。

13. 发明申请

US20080154893A1 APPARATUS AND METHOD FOR SKIPPING XML INDEX SCANS WITH COMMON ANCESTORS OF A PREVIOUSLY FAILED PREDICATE 有权
标题翻译：用于将先前失败的预测的常规防御者拖放XML索引扫描的装置和方法
公开(公告)号：US20080154893A1
公开(公告)日：2008-06-26
申请号：US11613757
申请日：2006-12-20
申请人： Edison Lao Ting , Tuong Chanh Truong
发明人： Edison Lao Ting , Tuong Chanh Truong
IPC分类号： G06F17/30
CPC分类号： G06F17/30938 , Y10S707/99936 , Y10S707/99943
摘要： An apparatus and method are disclosed for skipping XML index scans with common ancestors of a previously failed predicate. An XML index is scanned by an XML index scan to filter entries of the index matching at least one search value (predicate) of an XML query. When the XML index scan finds a matching entry, the entry is passed to an XPath evaluation component. The XPath evaluation component evaluates the entry against remaining predicates of the XML query for further qualification. When the XPath evaluation component disqualifies an entry, the XPath evaluation component provides feedback to the XML index scan to skip remaining entries comprising a common ancestor of the disqualified entry's path. The XML index scan can then efficiently skip index entries that will not qualify against the XML query.
摘要翻译：公开了一种用于跳过具有先前故障谓词的共同祖先的XML索引扫描的装置和方法。通过XML索引扫描扫描XML索引，以过滤与XML查询的至少一个搜索值（谓词）匹配的索引的条目。当XML索引扫描找到匹配的条目时，该条目将传递给XPath评估组件。 XPath评估组件根据XML查询的剩余谓词评估条目以进一步验证。当XPath评估组件取消条目资格时，XPath评估组件向XML索引扫描提供反馈，以跳过包含不合格条目路径的共同祖先的剩余条目。然后，XML索引扫描可以有效地跳过不符合XML查询条件的索引条目。

14. 发明授权

US06996557B1 Method of optimizing SQL queries where a predicate matches nullable operands 有权
标题翻译：优化SQL查询的方法，其中谓词与可空操作数匹配
公开(公告)号：US06996557B1
公开(公告)日：2006-02-07
申请号：US09504086
申请日：2000-02-15
申请人： Ting Yu Leung , Tuong Chanh Truong
发明人： Ting Yu Leung , Tuong Chanh Truong
IPC分类号： G06F7/00
CPC分类号： G06F17/30454 , Y10S707/99934
摘要： An optimization technique for SQL queries, a program storage device storing the optimization program, and an apparatus for optimizing a query is provided. A query is analyzed to determine whether it includes a predicate for matching nullable operands and, if so, it is transformed to return TRUE when all operands are NULLs. If the DBMS supports this new function, the predicate is marked. If not, the predicate is re-written into a CASE expression having two SELECT clauses. The query is then executed in the computer to efficiently retrieve data from the relational database.
摘要翻译：提供了一种用于SQL查询的优化技术，存储优化程序的程序存储设备以及用于优化查询的设备。分析查询以确定它是否包含用于匹配可空操作数的谓词，如果是，则在所有操作数都为空时将其转换为TRUE。如果DBMS支持这个新功能，则会标记谓词。如果没有，则将谓词重新写入具有两个SELECT子句的CASE表达式。然后在计算机中执行查询以有效地从关系数据库检索数据。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式