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

1. 发明授权

US07246115B2 Materialized view signature and efficient identification of materialized view candidates for queries 失效
标题翻译：物化视图签名和有效识别用于查询的物化视图候选
公开(公告)号：US07246115B2
公开(公告)日：2007-07-17
申请号：US10324800
申请日：2002-12-19
申请人： Guogen Zhang , Irene Ching-Hua Liu , Ding-Wei Chieh , Lee-Chin Hsu Liu , Yao-Ching Stephen Chen , Hsuiying Yen Cheng , Brian Thinh-Vinh Tran , Yun Wang , Ruiping Li
发明人： Guogen Zhang , Irene Ching-Hua Liu , Ding-Wei Chieh , Lee-Chin Hsu Liu , Yao-Ching Stephen Chen , Hsuiying Yen Cheng , Brian Thinh-Vinh Tran , Yun Wang , Ruiping Li
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942 , Y10S707/99943
摘要： A method and system for efficiently identifying materialized view candidates for queries filters materialized views using certain criteria, using the materialized view signatures. This filtering rejects some of the unqualified materialized views prior to the performance of the query rewrite matching algorithm, resulting in a group of materialized view candidates. The query rewrite matching algorithm is then performed on the materialized view candidates. By first filtering the materialized views based on their signatures, the number of materialized views on which the query rewrite matching algorithm is performed is significantly reduced, improving performance.
摘要翻译：用于有效地识别用于查询的物化视图候选的方法和系统使用特定的视图签名使用特定标准过滤物化视图。该过滤在执行查询重写匹配算法之前拒绝一些不合格的物化视图，导致一组物化视图候选。然后对物化视图候选进行查询重写匹配算法。通过首先根据其签名过滤物化视图，大大减少了执行查询重写匹配算法的物化视图数量，从而提高了性能。

2. 发明授权

US08543614B2 Packing nodes into records to store XML XQuery data model and other hierarchically structured data 失效
标题翻译：将节点包装到记录中以存储XML XQuery数据模型和其他分层结构化数据
公开(公告)号：US08543614B2
公开(公告)日：2013-09-24
申请号：US11209997
申请日：2005-08-22
申请人： Yao-Ching Stephen Chen , Yue Huang , Fen-Ling Lin , Brian Thinh-Vinh Tran , Guogen Zhang
发明人： Yao-Ching Stephen Chen , Yue Huang , Fen-Ling Lin , Brian Thinh-Vinh Tran , Guogen Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30917 , G06F17/30911
摘要： A storage of nodes of hierarchically structured data uses logical node identifiers to reference the nodes stored within and across record data structures. A node identifier index is used to map each logical node identifier to a record identifier for the record that contains the node. When a sub-tree is stored in a separate record, a proxy node is used to represent the sub-tree in the parent record. The mapping in the node identifier index reflects the storage of the sub-tree nodes in the separate record. Since the references between the records are through logical node identifiers, there is no limitation to the moving of records across pages, as long as the indices are updated or rebuilt to maintain synchronization with the resulting data pages. This approach is highly scalable and has a much smaller storage consumption than approaches that use explicit references between nodes.
摘要翻译：分级结构化数据节点的存储使用逻辑节点标识符来引用存储在记录数据结构内和跨记录数据结构的节点。节点标识符索引用于将每个逻辑节点标识符映射到包含节点的记录的记录标识符。当子树存储在单独的记录中时，代理节点用于表示父记录中的子树。节点标识符索引中的映射反映了子树节点在单独记录中的存储。由于记录之间的引用是通过逻辑节点标识符，只要索引被更新或重建以维持与所得到的数据页的同步，就不限于跨页面的记录移动。这种方法具有高度可扩展性，并且比使用节点之间的明确引用的方法具有更小的存储消耗。

3. 发明授权

US5930795A Supporting dynamic tables in SQL query compilers 失效
标题翻译：在SQL查询编译器中支持动态表
公开(公告)号：US5930795A
公开(公告)日：1999-07-27
申请号：US786603
申请日：1997-01-21
申请人： Yao-Ching Stephen Chen , Jyh-Herng Chow , Roberta Jo Cochrane , Gene Y.C. Fuh , Nelson Mendonca Mattos , Mir Hamid Pirahesh , Jeffrey D. Richey , Brian Thinh-Vinh Tran , Tuong Chanh Truong
发明人： Yao-Ching Stephen Chen , Jyh-Herng Chow , Roberta Jo Cochrane , Gene Y.C. Fuh , Nelson Mendonca Mattos , Mir Hamid Pirahesh , Jeffrey D. Richey , Brian Thinh-Vinh Tran , Tuong Chanh Truong
IPC分类号： G06F17/30
CPC分类号： G06F17/30421 , G06F17/30474
摘要： A framework for a query compiler and run-time environment for resolving a table reference to a dynamic table that is first identified at run-time but is initially unknown at compile-time. A parser parses the table reference and creates a parsed representation for the table that identifies the type of dynamic table. A code generator creates executable plans containing run-time table object representations (TAOB), from the parsed representations, that contain the type of dynamic table. The TAOB is also extended to provide for parameters that are definable at run-time, including a table ID of the actual table entity being referenced. A routine is embedded in a run-time routine that checks the type of dynamic table in the TAOB and dispatches control to one of a plurality of corresponding routines, depending upon the type of dynamic table. The corresponding routines use the extended TAOB to dynamically link the table reference to the dynamic table, depending upon the type of dynamic table. Once the dynamic table has been linked to the table reference, query processing continues as if that table were a base or derived table.
摘要翻译：用于查询编译器和运行时环境的框架，用于解析对运行时首先标识但最初在编译时未知的动态表的表引用。解析器解析表引用，并创建用于标识动态表类型的表的解析表示。代码生成器从解析的表示形式创建包含运行时表对象表示（TAOB）的可执行计划，其中包含动态表的类型。 TAOB还被扩展以提供在运行时可定义的参数，包括被引用的实际表实体的表ID。例程被嵌入到运行时程序中，该运行时程序检查TAOB中的动态表的类型，并根据动态表的类型将控制调度到多个相应的例程之一。相应的例程使用扩展TAOB来动态地将表引用动态链接到动态表，这取决于动态表的类型。一旦将动态表链接到表引用，查询处理将继续进行，就像该表是基类或派生表一样。

4. 发明授权

US07937413B2 Self-adaptive prefix encoding for stable node identifiers 失效
标题翻译：用于稳定节点标识符的自适应前缀编码
公开(公告)号：US07937413B2
公开(公告)日：2011-05-03
申请号：US10709415
申请日：2004-05-04
申请人： Brian Thinh-Vinh Tran , Guogen Zhang
发明人： Brian Thinh-Vinh Tran , Guogen Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30908
摘要： A variable-length binary string is utilized to encode node identifiers in a tree for an XML document object model. A general prefix encoding scheme is followed; a node identifier is generated by the concatenation of encodings at each level of a tree along a path from a root node to another particular node. Arbitrary insertions are supported without change to existing node identifier encodings. In addition, the method provides for document order when unsigned binary string comparison is used to compare encoded node identifiers. In support of sub-document concurrency control, prefix encoding provides a way to derive ancestor-descendant relationships among nodes in a tree. Lastly, the encoding method provides a natural pre-order clustering sequence, also known as depth-first clustering. If a prefix is applied to an encoding with a level number, starting with zero at the root, width-first clustering will result. A mixed clustering can also be supported.
摘要翻译：使用可变长度的二进制字符串来编码用于XML文档对象模型的树中的节点标识符。遵循一般的前缀编码方案; 通过沿着从根节点到另一个特定节点的路径的树的每个级别的编码的级联来生成节点标识符。支持任意插入，而不改变现有的节点标识符编码。此外，当使用无符号二进制字符串比较来比较编码节点标识符时，该方法提供了文档顺序。为了支持子文档并发控制，前缀编码提供了一种在树中节点之间派生祖先 - 后代关系的方法。最后，编码方法提供了一种自然的预购聚类序列，也称为深度优先聚类。如果将前缀应用于具有级号的编码，则从根开始为零，将导致宽度优先聚类。也可以支持混合群集。

5. 发明授权

US06253196B1 Generalized model for the exploitation of database indexes 失效
标题翻译：数据库索引利用的广义模型
公开(公告)号：US06253196B1
公开(公告)日：2001-06-26
申请号：US09112307
申请日：1998-07-09
申请人： Gene Y. C. Fuh , Michelle Mei-Chiou Jou , Kamilla Kazimierowicz , Brian Thinh-Vinh Tran , Yun Wang
发明人： Gene Y. C. Fuh , Michelle Mei-Chiou Jou , Kamilla Kazimierowicz , Brian Thinh-Vinh Tran , Yun Wang
IPC分类号： G06F1730
CPC分类号： G06F17/30312 , G06F17/30483 , G06F17/30492 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936 , Y10S707/99943 , Y10S707/99953
摘要： A method, apparatus, and article of manufacture for computer-implemented exploitation of database indexes. A statement is executed in a database stored on a data storage device connected to a computer. The database contains data. A model based on pattern matching for a user-defined predicate and selection of an index exploitation rule based on a matched user-defined predicate is provided to be used for exploiting an index to retrieve data from the database.
摘要翻译：计算机实现数据库索引利用的方法，装置和制造。在存储在连接到计算机的数据存储设备上的数据库中执行语句。数据库包含数据。提供了基于用户定义谓词的模式匹配和基于匹配的用户定义谓词的索引利用规则的选择的模型，用于利用索引从数据库检索数据。

6. 发明授权

US06266663B1 User-defined search using index exploitation 失效
标题翻译：使用索引开发的用户定义搜索
公开(公告)号：US06266663B1
公开(公告)日：2001-07-24
申请号：US09113976
申请日：1998-07-09
申请人： Gene Y. C. Fuh , Michelle Mei-chiou Jou , Daniel T. Lee , Ping Li , Hsin Pan , Shahrokh Talmoud , Brian Thinh-Vinh Tran , Yun Wang
发明人： Gene Y. C. Fuh , Michelle Mei-chiou Jou , Daniel T. Lee , Ping Li , Hsin Pan , Shahrokh Talmoud , Brian Thinh-Vinh Tran , Yun Wang
IPC分类号： G06F1730
CPC分类号： G06F17/30471 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A method, apparatus, and article of manufacture for a computer-implemented model for user-defined search in Relational Database Management Systems. A statement is executed in a database stored on a data storage device connected to a computer. Data that is qualified by user-defined functions is located based on a model that supports user-defined search.
摘要翻译：用于关系数据库管理系统中用户定义搜索的计算机实现模型的方法，装置和制造。在存储在连接到计算机的数据存储设备上的数据库中执行语句。由用户定义的功能限定的数据基于支持用户定义搜索的模型。

7. 发明授权

US06285996B1 Run-time support for user-defined index ranges and index filters 失效
标题翻译：运行时支持用户定义的索引范围和索引过滤器
公开(公告)号：US06285996B1
公开(公告)日：2001-09-04
申请号：US09113802
申请日：1998-07-09
申请人： Michelle Mei-Chiou Jou , Daniel Tsunfang Lee , Ping Li , Hsin Pan , Brian Thinh-Vinh Tran , Yun Wang
发明人： Michelle Mei-Chiou Jou , Daniel Tsunfang Lee , Ping Li , Hsin Pan , Brian Thinh-Vinh Tran , Yun Wang
IPC分类号： G06F1730
CPC分类号： G06F17/30312 , G06F17/30483 , G06F17/30492 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： A method, apparatus, and article of manufacture for run-time support for user-defined index ranges and index filters. A statement is executed in a database stored on a data storage device, which is connected to a computer. The database contains data. A search range is generated based on a user-defined range function associated with a user-defined index.
摘要翻译：用于用户定义的索引范围和索引过滤器的运行时支持的方法，设备和制造。在存储在连接到计算机的数据存储设备上的数据库中执行语句。数据库包含数据。基于与用户定义的索引相关联的用户定义的范围函数生成搜索范围。

8. 发明授权

US6065013A Optimal storage mechanism for persistent objects in DBMS 失效
标题翻译： DBMS中持久对象的最佳存储机制
公开(公告)号：US6065013A
公开(公告)日：2000-05-16
申请号：US914394
申请日：1997-08-19
申请人： Gene Y. C. Fuh , Bruce Gilbert Lindsay , Nelson Mendonca Mattos , Brian Thinh-Vinh Tran , Yun Wang
发明人： Gene Y. C. Fuh , Bruce Gilbert Lindsay , Nelson Mendonca Mattos , Brian Thinh-Vinh Tran , Yun Wang
IPC分类号： G06F17/30
CPC分类号： G06F17/30607 , Y10S707/99944
摘要： A method, apparatus, and article of manufacture for a computer implemented storage mechanism for persistent objects in a database management system. A statement is executed in a computer. The statement is performed by the computer to manipulate data in a database stored on a data storage device connected to the computer. It is determined that an object is to be stored in an inline buffer. When the object can be entirely stored in the inline buffer, the object is stored in the inline buffer. When the object cannot be entirely stored in the inline buffer, a selected portion of the object is stored in the inline buffer and the remaining portion of the object is stored as a large object.
摘要翻译：一种用于数据库管理系统中用于持久对象的计算机实现的存储机制的方法，装置和制品。在计算机中执行语句。该语句由计算机执行以操作存储在连接到计算机的数据存储设备上的数据库中的数据。确定一个对象要存储在一个内联缓冲区中。当对象可以完全存储在内联缓冲区中时，对象被存储在内联缓冲区中。当对象不能完全存储在内联缓冲区中时，对象的选定部分被存储在内联缓冲区中，并且对象的剩余部分被存储为大对象。

9. 发明授权

US06389425B1 Embedded storage mechanism for structured data types 失效
标题翻译：结构化数据类型的嵌入式存储机制
公开(公告)号：US06389425B1
公开(公告)日：2002-05-14
申请号：US09112464
申请日：1998-07-09
申请人： Linda Gail DeMichiel , Gene Y. C. Fuh , Bruce Gilbert Lindsay , Nelson Mendonca Mattos , Brian Thinh-Vinh Tran , Yun Wang
发明人： Linda Gail DeMichiel , Gene Y. C. Fuh , Bruce Gilbert Lindsay , Nelson Mendonca Mattos , Brian Thinh-Vinh Tran , Yun Wang
IPC分类号： G06F1730
CPC分类号： G06F17/30607 , Y10S707/99932 , Y10S707/99933 , Y10S707/99943 , Y10S707/99944
摘要： A method, apparatus, and article of manufacture for a computer-implemented embedded storage mechanism for structured data types. A statement is stored in a database stored on a data storage device connected to a computer. At compile-time, specific methods for a structured data type are mapped to generic methods using parse trees. At run-time, an in-memory representation of the structured data type is generated using information conveyed in the parse trees. Then, linearization of the generated in-memory representation is performed.
摘要翻译：一种用于结构化数据类型的计算机实现的嵌入式存储机制的方法，装置和制品。语句存储在存储在与计算机连接的数据存储设备上的数据库中。在编译时，结构化数据类型的具体方法使用解析树映射到通用方法。在运行时，使用解析树中传达的信息生成结构化数据类型的内存中表示。然后，执行生成的存储器内表示的线性化。

10. 发明授权

US06278994B1 Fully integrated architecture for user-defined search 失效
标题翻译：用于用户定义搜索的完全集成架构
公开(公告)号：US06278994B1
公开(公告)日：2001-08-21
申请号：US09112302
申请日：1998-07-09
申请人： Gene Y. C. Fuh , Nelson Mendonca Mattos , Brian Thinh-Vinh Tran , Yun Wang
发明人： Gene Y. C. Fuh , Nelson Mendonca Mattos , Brian Thinh-Vinh Tran , Yun Wang
IPC分类号： G06F1730
CPC分类号： G06F17/30471 , G06F17/30342 , Y10S707/99934 , Y10S707/99943
摘要： A method, apparatus, and article of manufacture for a computer-implemented integrated architecture for user-defined search. A statement is executed in a database stored on a data storage device connected to a computer, and the database contains data. Under control of the database, a statement is received that requests manipulation of the data. The statement includes a user-defined function. An index of a user-defined index type is used to access the data. The user-defined function is processed with the accessed data.
摘要翻译：用于用户定义搜索的用于计算机实现的集成架构的方法，装置和制品。在存储在连接到计算机的数据存储设备上的数据库中执行语句，并且数据库包含数据。在数据库的控制下，接收到要求操纵数据的语句。该语句包括用户定义的函数。用户定义的索引类型的索引用于访问数据。用访问的数据处理用户定义的函数。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式