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

1. 发明授权

US06738782B2 Method and mechanism for extending native optimization in a database system 有权
标题翻译：在数据库系统中扩展本机优化的方法和机制
公开(公告)号：US06738782B2
公开(公告)日：2004-05-18
申请号：US10096008
申请日：2002-03-11
申请人： Nipun Agarwal , Dinesh Das , Viswanathan Krishnamurthy , Ravi Murthy , Anil Nori , Jagannathan Srinivasan
发明人： Nipun Agarwal , Dinesh Das , Viswanathan Krishnamurthy , Ravi Murthy , Anil Nori , Jagannathan Srinivasan
IPC分类号： G06F1730
CPC分类号： G06F17/30471 , Y10S707/99932 , Y10S707/99933 , Y10S707/99943
摘要： A method and system for optimizing the execution of database statement is described. Optimization of database statements having non-boolean predicates is disclosed. Also disclosed is the determination and use of different granularity levels of information for submitting database statement predicates to optimizer-related functions.
摘要翻译：描述了优化数据库语句执行的方法和系统。公开了具有非布尔谓词的数据库语句的优化。还披露了将数据库语句谓词提交给优化器相关函数的不同粒度级别的信息的确定和使用。

2. 发明授权

US06370522B1 Method and mechanism for extending native optimization in a database system 有权
标题翻译：在数据库系统中扩展本机优化的方法和机制
公开(公告)号：US06370522B1
公开(公告)日：2002-04-09
申请号：US09272691
申请日：1999-03-18
申请人： Nipun Agarwal , Dinesh Das , Viswanathan Krishnamurthy , Ravi Murthy , Anil Nori , Jagannathan Srinivasan
发明人： Nipun Agarwal , Dinesh Das , Viswanathan Krishnamurthy , Ravi Murthy , Anil Nori , Jagannathan Srinivasan
IPC分类号： G06F1730
CPC分类号： G06F17/30471 , Y10S707/99932 , Y10S707/99933 , Y10S707/99943
摘要： A method and system for optimizing the execution of database statement is described. An aspect is related to providing a framework for the creation, association, and use of optimizer-related functions to calculate the cost of execution plans involving non-native database entities. Examples of these optimizer-related functions include selectivity, statistics, and costs functions. Another aspect is related to the optimization of database statements having non-boolean predicates. Yet another aspect is related to the determination and use of different granularity levels of information for submitting database statement predicates to optimizer-related functions. Optimizer-related functions can also be defined for system-supplied objects and entities.
摘要翻译：描述了优化数据库语句执行的方法和系统。一方面涉及为创建，关联和使用与优化器相关的函数提供框架，以计算涉及非本地数据库实体的执行计划的成本。这些优化器相关功能的示例包括选择性，统计和成本函数。另一方面涉及具有非布尔谓词的数据库语句的优化。另一方面涉及确定和使用不同粒度级别的信息，以将数据库声明谓词提交给优化器相关的功能。还可以为系统提供的对象和实体定义与优化器相关的功能。

3. 发明授权

US06816853B1 Method and system for efficiently evaluating a query against partitioned data 有权
标题翻译：用于有效评估对分区数据的查询的方法和系统
公开(公告)号：US06816853B1
公开(公告)日：2004-11-09
申请号：US09872887
申请日：2001-05-31
申请人： Nipun Agarwal , Ravi Murthy , Jagannathan Srinivasan
发明人： Nipun Agarwal , Ravi Murthy , Jagannathan Srinivasan
IPC分类号： G06F1730
CPC分类号： G06F17/30545 , G06F17/30501 , Y10S707/99932 , Y10S707/99933 , Y10S707/99936 , Y10S707/99943 , Y10S707/99944
摘要： A method and mechanism to execute a query against a partitioned database object. Data processed or created for an earlier partition is maintained even after further processing is performed against a subsequent partition. A shared data object, such as a context object, is maintained to store data from processing the partitions of a partitioned table. Rather than discarding or overwriting the shared data object after processing each partition, the data from a subsequent partition is instead appended to the shared data object.
摘要翻译：对分区数据库对象执行查询的方法和机制。即使在针对后续分区执行进一步处理之后，仍保留对较早分区进行处理或创建的数据。维护诸如上下文对象的共享数据对象以存储来自处理分区表的分区的数据。在处理每个分区之后，不是丢弃或覆盖共享数据对象，而是将来自后续分区的数据替换为附加到共享数据对象。

4. 发明授权

US06421666B1 Mechanism for sharing ancillary data between a family of related functions 有权
标题翻译：在一系列相关功能之间共享辅助数据的机制
公开(公告)号：US06421666B1
公开(公告)日：2002-07-16
申请号：US09436046
申请日：1999-11-08
申请人： Ravi Murthy , Jagannathan Srinivasan , Nipun Agarwal
发明人： Ravi Murthy , Jagannathan Srinivasan , Nipun Agarwal
IPC分类号： G06F700
CPC分类号： G06F17/30545 , G06F17/30501 , Y10S707/99932 , Y10S707/99933 , Y10S707/99936 , Y10S707/99943 , Y10S707/99944
摘要： A method and apparatus are provided for accessing ancillary data, and for generating and accessing ancillary data more efficiently. Ancillary data is generated during execution of the operator routine of a primary operator. The ancillary data is stored in a shared content and may be accessed through ancillary operators associated with the primary operator. Metadata is used to define a primary operator and ancillary operators associated with the primary operator. A DBMS, for example, receives a statement that includes a primary and at least one of its ancillary operators, and executes routines that implement the primary operator and the ancillary operator. During execution of the routine the implements the primary operator, ancillary data is generated and stored in shared content. During the execution of the routine that implements the ancillary operator, the ancillary data is retrieved from the shared content and is used. This mechanism enables efficient execution of a family of related functions over all the records in a dataset. The sharing of context avoids redundant computation and enables use of ancillary data.
摘要翻译：提供了一种用于访问辅助数据以及更有效地生成和访问辅助数据的方法和装置。在主操作员的操作员程序的执行期间生成辅助数据。辅助数据存储在共享内容中，并且可以通过与主操作符相关联的辅助运算符来访问。元数据用于定义与主运营商关联的主运营商和辅助运营商。例如，DBMS接收包含主要和至少其中一个辅助运算符的语句，并执行实现主操作符和辅助运算符的例程。在执行例程期间，实现主操作员，辅助数据生成并存储在共享内容中。在执行辅助运算符的例程执行期间，辅助数据从共享内容中检索并被使用。该机制使得能够在数据集中的所有记录上有效地执行相关功能的一系列。上下文的共享避免了冗余计算，并且能够使用辅助数据。

5. 发明授权

US07096224B2 Mechanism for mapping XML schemas to object-relational database systems 有权
公开(公告)号：US07096224B2
公开(公告)日：2006-08-22
申请号：US10259278
申请日：2002-09-27
申请人： Ravi Murthy , Muralidhar Krishnaprasad , Sivasankaran Chandrasekar , Eric Sedlar , Viswanathan Krishnamurthy , Nipun Agarwal
发明人： Ravi Murthy , Muralidhar Krishnaprasad , Sivasankaran Chandrasekar , Eric Sedlar , Viswanathan Krishnamurthy , Nipun Agarwal
IPC分类号： G06F17/00 , G06F7/00
CPC分类号： G06F17/30595 , G06F17/30917 , Y10S707/99931 , Y10S707/99933 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945
摘要： A method and system are provided for allowing users to register XML schemas in a database system. The database system determines, based on a registered XML schema, how to store within the database system XML documents that conform to the XML schema. This determination involves mapping constructs defined in the XML schema to constructs supported by the database system. Such constructs may include datatypes, hierarchical relationship between elements, constraints, inheritances, etc. Once the mapping has been determined, it is stored and used by the database system to determine how to store subsequently received XML documents that conform to the registered XML schema.

6. 发明授权

US06360228B1 Transactional framework for executing statements involving non-native code 有权
标题翻译：用于执行涉及非本地代码的语句的事务框架
公开(公告)号：US06360228B1
公开(公告)日：2002-03-19
申请号：US09324605
申请日：1999-06-02
申请人： Seema Sundara , Ravi Murthy , Nipun Agarwal , Jagannathan Srinivasan
发明人： Seema Sundara , Ravi Murthy , Nipun Agarwal , Jagannathan Srinivasan
IPC分类号： G06F1730
CPC分类号： G06F17/30371 , Y10S707/99931 , Y10S707/99943 , Y10S707/99953
摘要： Described herein is a framework for providing statement atomicity for DDL statements. The framework allows the ability to perform, as multiple transactions, the DDL operations specified by a DDL statement. To begin execution of a DDL statement, a DBMS, for example, updates a flag to indicate that DDL operations have commenced. While the flag is set to this state, the DBMS prevents execution of operations that depend on the DDL statement being executed as an atomic unit. If the DDL operations are aborted, the flag is set to a state that indicates that the execution of the DDL operations did not complete, and the DBMS continues to disallow dependent operations that depend on the atomicity of the DDL statement. Because the flag is used to provide statement atomicity, DDL operations may be performed as multiple transactions. For a DML statement, a mechanism described herein preserves the transactional context of a DML statement. When, for example, a DBMS is executing a transaction and generates a callout, the DBMS prevents operations that may change the transactional context of work performed in response to the callout.
摘要翻译：这里描述的是为DDL语句提供语句原子性的框架。该框架允许作为多个事务执行由DDL语句指定的DDL操作的功能。要开始执行DDL语句，例如，DBMS会更新一个标志，以指示DDL操作已经开始。当标志设置为此状态时，DBMS将阻止执行依赖于作为原子单元执行的DDL语句的操作。如果DDL操作被中止，则该标志被设置为指示执行DDL操作未完成的状态，并且DBMS继续禁止依赖于DDL语句的原子性的依赖操作。因为该标志用于提供语句原子性，所以DDL操作可以被执行为多个事务。对于DML语句，本文所述的机制保留DML语句的事务上下文。例如，当DBMS正在执行事务并生成标注时，DBMS会防止可能改变响应于标注执行的工作的事务上下文的操作。

7. 发明授权

US5893104A Method and system for processing queries in a database system using index structures that are not native to the database system 失效
标题翻译：在数据库系统中使用非本地数据库系统的索引结构来处理查询的方法和系统
公开(公告)号：US5893104A
公开(公告)日：1999-04-06
申请号：US677159
申请日：1996-07-09
申请人： Jagannathan Srinivasan , Ravi Murthy , Chin Hong , Samuel DeFazio , Anil Nori
发明人： Jagannathan Srinivasan , Ravi Murthy , Chin Hong , Samuel DeFazio , Anil Nori
IPC分类号： G06F17/30 , E06F17/30
CPC分类号： G06F17/30321 , Y10S707/99932 , Y10S707/99933 , Y10S707/99943
摘要： A method and apparatus for processing a query in a database system using index types that are not built into the database system are disclosed. Routines for managing an index structure that is not supported by a database system are generated. Data that identifies the routines are submitted to the database system, thereby "registering" the index types with the database system. In response to statements issued to the database system by a client, the database system calls the routines, causing the routines to create an index structure using data from a data container in the database, and to generate data that indicates which data in the data container satisfies a query issued by the client. The routines of the registered index type extend the indexing capabilities of the database systems and one or more such index types can be registered with the database system. The index structure managed by the routines may be maintained within segments of the database, and the segments may be accessed as index-only tables. Storing a row of data in a database using index-only tables involves storing in a leaf node an index entry that includes a key value along with all other values in the row of data. If the row of data exceeds a predetermined size, then a portion of the row of data is stored in an overflow area. Retrieving a row of data from an index-only table for a user-supplied key involves identifying a leaf node for the key, and reading a row of data from the index entry and any remaining portion from the overflow area when the row exceeds the predetermined size.
摘要翻译：公开了一种使用未内置于数据库系统中的索引类型在数据库系统中处理查询的方法和装置。生成用于管理数据库系统不支持的索引结构的例程。标识例程的数据被提交给数据库系统，从而通过数据库系统“注册”索引类型。响应由客户端向数据库系统发出的语句，数据库系统调用例程，导致例程使用来自数据库中的数据容器的数据创建索引结构，并生成指示数据容器中的哪些数据的数据满足客户端发出的查询。注册索引类型的例程扩展了数据库系统的索引功能，并且可以向数据库系统注册一个或多个这样的索引类型。由例程管理的索引结构可以维护在数据库的段内，并且段可以作为仅索引表访问。使用仅索引表存储数据库中的一行数据涉及在叶节点中存储包含键值的索引条目以及数据行中的所有其他值。如果数据行超过预定的大小，则该数据行的一部分被存储在溢出区域中。从用户提供的密钥的仅索引表中检索一行数据涉及识别密钥的叶节点，并且当该行超过预定的值时从索引条目读取一行数据和来自溢出区域的剩余部分尺寸。

8. 发明授权

US09367642B2 Flexible storage of XML collections within an object-relational database 有权
标题翻译：将XML集合灵活存储在对象关系数据库中
公开(公告)号：US09367642B2
公开(公告)日：2016-06-14
申请号：US11246039
申请日：2005-10-07
申请人： Abhyudaya Agrawal , Sivasankaran Chandrasekar , Ravi Murthy , Nipun Agarwal , Eric Sedlar
发明人： Abhyudaya Agrawal , Sivasankaran Chandrasekar , Ravi Murthy , Nipun Agarwal , Eric Sedlar
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30923 , G06F7/00
摘要： A database server determines, on an element-level of granularity, what form of VARRAY storage to map collections of elements defined by a XML schema. A collection element may be mapped to an in-line VARRAY or an out-of-line VARRAY. The determination may based on a variety of factors, including the database type mapped to the collection element, database limitations that limit the form storage for certain database types, and annotations (“mapping annotations”) embedded within that XML schema that specifying a database type for database representation of a collection element or a form of VARRAY storage.
摘要翻译：数据库服务器根据粒度级别确定使用什么形式的VARRAY存储来映射由XML模式定义的元素集合。集合元素可以被映射到串联的VARRAY或者行外的VARRAY。确定可以基于各种因素，包括映射到集合元素的数据库类型，限制某些数据库类型的表单存储的数据库限制，以及嵌入在指定数据库类型的XML模式中的注释（“映射注释”）用于收集元素或VARRAY存储的形式的数据库表示。

9. 发明授权

US08209352B2 Method and mechanism for efficient storage and query of XML documents based on paths 有权
标题翻译：基于路径高效存储和查询XML文档的方法和机制
公开(公告)号：US08209352B2
公开(公告)日：2012-06-26
申请号：US12352757
申请日：2009-01-13
申请人： Ravi Murthy , Nipun Agarwal , Eric Sedlar
发明人： Ravi Murthy , Nipun Agarwal , Eric Sedlar
IPC分类号： G06F17/30
CPC分类号： G06F17/30914
摘要： A method, mechanism, and computer program product for storing, accessing, and managing XML data is disclosed. The approach supports efficient evaluation of XPath queries and also improves the performance of data/fragment extraction. The approach can be applied to schema-less documents. The approach is applicable to all database systems and other servers which support storing and managing XML content. In addition, the approach can be applied to store, manage, and retrieve other types of unstructured or semi-structured data in a database system.
摘要翻译：公开了一种用于存储，访问和管理XML数据的方法，机制和计算机程序产品。该方法支持对XPath查询的高效评估，并且还提高了数据/片段提取的性能。该方法可以应用于无模式文档。该方法适用于支持存储和管理XML内容的所有数据库系统和其他服务器。此外，该方法可以应用于在数据库系统中存储，管理和检索其他类型的非结构化或半结构化数据。

10. 发明授权

US07921101B2 Index maintenance for operations involving indexed XML data 有权
标题翻译：涉及索引XML数据的操作的索引维护
公开(公告)号：US07921101B2
公开(公告)日：2011-04-05
申请号：US12173323
申请日：2008-07-15
申请人： Ravi Murthy , Sivasankaran Chandrasekaran , Ashish Thusoo , Nipun Agarwal , Eric Sedlar
发明人： Ravi Murthy , Sivasankaran Chandrasekaran , Ashish Thusoo , Nipun Agarwal , Eric Sedlar
IPC分类号： G06F17/30
CPC分类号： G06F17/30917 , G06F17/2241 , G06F17/2247 , G06F17/30911 , Y10S707/99942 , Y10S707/99952
摘要： A method and system are provided for maintaining an XML index in response to piece-wise modifications on indexed XML documents. The database server that manages the XML index determines which nodes are involved in the piece-wise modifications, and updates the XML index based on only those nodes. Index entries for nodes not involved in the piece-wise modifications remain unchanged.
摘要翻译：提供了一种方法和系统，用于响应于对索引的XML文档的分段修改来维护XML索引。管理XML索引的数据库服务器确定哪些节点涉及分段修改，并仅基于这些节点更新XML索引。不参与分段修改的节点的索引条目保持不变。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式