专利快速检索-快速检索全球专利，免费商用专利数据库-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. 发明授权

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接收包含主要和至少其中一个辅助运算符的语句，并执行实现主操作符和辅助运算符的例程。在执行例程期间，实现主操作员，辅助数据生成并存储在共享内容中。在执行辅助运算符的例程执行期间，辅助数据从共享内容中检索并被使用。该机制使得能够在数据集中的所有记录上有效地执行相关功能的一系列。上下文的共享避免了冗余计算，并且能够使用辅助数据。

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. 发明授权

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.
摘要翻译：描述了优化数据库语句执行的方法和系统。一方面涉及为创建，关联和使用与优化器相关的函数提供框架，以计算涉及非本地数据库实体的执行计划的成本。这些优化器相关功能的示例包括选择性，统计和成本函数。另一方面涉及具有非布尔谓词的数据库语句的优化。另一方面涉及确定和使用不同粒度级别的信息，以将数据库声明谓词提交给优化器相关的功能。还可以为系统提供的对象和实体定义与优化器相关的功能。

5. 发明授权

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会防止可能改变响应于标注执行的工作的事务上下文的操作。

6. 发明授权

US06351742B1 Method and mechanism for database statement optimization 有权
标题翻译：数据库语句优化的方法和机制
公开(公告)号：US06351742B1
公开(公告)日：2002-02-26
申请号：US09272627
申请日：1999-03-18
申请人： Nipun Agarwal , Dinesh Das , Jagannathan Srinivasan
发明人： Nipun Agarwal , Dinesh Das , Jagannathan Srinivasan
IPC分类号： G06F1730
CPC分类号： G06F17/30463 , G06F17/30469 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： A method and system for optimizing the execution of database statements are described. An aspect is directed to the generation of an execution plan for a database statement, wherein the database statement contains a predicate having one or more arguments whose values are not known at the time the execution plan is generated (e.g., at compile time). A feature of this aspect involves passing a description of the argument(s) to the optimizer. An example of such a description includes the argument type of the predicate argument.
摘要翻译：描述了优化数据库语句执行的方法和系统。一方面涉及生成数据库语句的执行计划，其中数据库语句包含具有一个或多个参数的谓词，其值在生成执行计划时（例如，在编译时），其值不为已知。此方面的一个特点涉及将参数的描述传递给优化器。这种描述的示例包括谓词参数的参数类型。

7. 发明授权

US06401083B1 Method and mechanism for associating properties with objects and instances 有权
标题翻译：将属性与对象和实例相关联的方法和机制
公开(公告)号：US06401083B1
公开(公告)日：2002-06-04
申请号：US09275896
申请日：1999-03-18
申请人： Nipun Agarwal , Viswanathan Krishnamurthy , Jagannathan Srinivasan
发明人： Nipun Agarwal , Viswanathan Krishnamurthy , Jagannathan Srinivasan
IPC分类号： G06F1730
CPC分类号： G06F17/30463 , G06F17/30469 , G06F17/30536 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933
摘要： A method and system for associating properties in a computer system is described. An aspect relates to a mechanism for dynamically determining the value of a property for an instance or object, which can override the property defined for the class or object type. Another aspect relates to a mechanism for dynamically changing at run-time the set of properties associated with system structures, such as classes, object types, instances, or objects. Yet another aspect relates to a mechanism that can associate or disassociate an entire set of properties at the same time, rather than having to separately associate or disassociate each property within a set of properties. A further aspect relates to a mechanism for allowing particular instances or objects to explicitly not inherit properties of its familial class or object type.
摘要翻译：描述了一种用于关联计算机系统中的属性的方法和系统。一个方面涉及用于动态地确定实例或对象的属性的值的机制，其可以覆盖为类或对象类型定义的属性。另一方面涉及用于在运行时动态地改变与诸如类，对象类型，实例或对象之类的系统结构相关联的属性的集合的机制。另一方面涉及可以同时将整个属性集合关联或取消关联的机制，而不是必须在一组属性中单独地关联或取消关联每个属性。另一方面涉及允许特定实例或对象显式地不继承其家族类或对象类型的属性的机制。

8. 发明授权

US07617235B2 Method and system for creating a domain index 有权
标题翻译：用于创建域索引的方法和系统
公开(公告)号：US07617235B2
公开(公告)日：2009-11-10
申请号：US11104718
申请日：2005-04-12
申请人： Jagannathan Srinivasan , Seema Sundara , Nipun Agarwal , Ying Hu , Timothy Chorma
发明人： Jagannathan Srinivasan , Seema Sundara , Nipun Agarwal , Ying Hu , Timothy Chorma
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , G06F17/30339 , Y10S707/99943
摘要： A domain index for a partitioned database can be created using a user-defined indexing scheme. Partition maintenance operations performed on the partitioned database objects cause corresponding partition maintenance operations to be performed on the domain indexes. The user-supplied partitioning code is partition operation-unaware.
摘要翻译：可以使用用户定义的索引方案创建分区数据库的域索引。对分区数据库对象执行的分区维护操作会导致对域索引执行相应的分区维护操作。用户提供的分区代码是分区操作 - 不知道。

9. 发明申请

US20050182762A1 Method and system for creating a domain index 有权
标题翻译：用于创建域索引的方法和系统
公开(公告)号：US20050182762A1
公开(公告)日：2005-08-18
申请号：US11104718
申请日：2005-04-12
申请人： Jagannathan Srinivasan , Seema Sundara , Nipun Agarwal , Ying Hu , Timothy Chorma
发明人： Jagannathan Srinivasan , Seema Sundara , Nipun Agarwal , Ying Hu , Timothy Chorma
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , G06F17/30339 , Y10S707/99943
摘要： A domain index for a partitioned database can be created using a user-defined indexing scheme. Partition maintenance operations performed on the partitioned database objects cause corresponding partition maintenance operations to be performed on the domain indexes. The user-supplied partitioning code is partition operation-unaware.
摘要翻译：可以使用用户定义的索引方案创建分区数据库的域索引。对分区数据库对象执行的分区维护操作会导致对域索引执行相应的分区维护操作。用户提供的分区代码是分区操作 - 不知道。

10. 发明授权

US06920460B1 Systems and methods for managing partitioned indexes that are created and maintained by user-defined indexing schemes 有权
标题翻译：用于管理由用户定义的索引方案创建和维护的分区索引的系统和方法
公开(公告)号：US06920460B1
公开(公告)日：2005-07-19
申请号：US10159360
申请日：2002-05-29
申请人： Jagannathan Srinivasan , Seema Sundara , Nipun Agarwal , Ying Hu , Timothy Chorma
发明人： Jagannathan Srinivasan , Seema Sundara , Nipun Agarwal , Ying Hu , Timothy Chorma
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , G06F17/30339 , Y10S707/99943
摘要： Domain indexes (indexes created and maintained by user-defined indexing schemes) are managed on partitioned database objects that store data using a system-managed approach. Partition maintenance operations performed on the partitioned database objects cause corresponding partition maintenance operations to be performed on the domain indexes. Partition maintenance operations are performed on both the database objects and the indexes by a system-supplied partition manager. Changes in the partition maintenance operations or partitioning methods supplied by the database management system do not affect user-supplied code which is provided by the user-defined indexing scheme. User-supplied code is therefore partition operation-unaware.
摘要翻译：域索引（由用户定义的索引方案创建和维护的索引）在使用系统管理方法存储数据的分区数据库对象上进行管理。对分区数据库对象执行的分区维护操作会导致对域索引执行相应的分区维护操作。由系统提供的分区管理器对数据库对象和索引执行分区维护操作。由数据库管理系统提供的分区维护操作或分区方法的更改不会影响由用户定义的索引方案提供的用户提供的代码。因此，用户提供的代码是分区操作 - 不知道。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式