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

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.
摘要翻译：公开了一种使用未内置于数据库系统中的索引类型在数据库系统中处理查询的方法和装置。生成用于管理数据库系统不支持的索引结构的例程。标识例程的数据被提交给数据库系统，从而通过数据库系统“注册”索引类型。响应由客户端向数据库系统发出的语句，数据库系统调用例程，导致例程使用来自数据库中的数据容器的数据创建索引结构，并生成指示数据容器中的哪些数据的数据满足客户端发出的查询。注册索引类型的例程扩展了数据库系统的索引功能，并且可以向数据库系统注册一个或多个这样的索引类型。由例程管理的索引结构可以维护在数据库的段内，并且段可以作为仅索引表访问。使用仅索引表存储数据库中的一行数据涉及在叶节点中存储包含键值的索引条目以及数据行中的所有其他值。如果数据行超过预定的大小，则该数据行的一部分被存储在溢出区域中。从用户提供的密钥的仅索引表中检索一行数据涉及识别密钥的叶节点，并且当该行超过预定的值时从索引条目读取一行数据和来自溢出区域的剩余部分尺寸。

4. 发明授权

US06286015B1 Opaque types 有权
标题翻译：不透明类型
公开(公告)号：US06286015B1
公开(公告)日：2001-09-04
申请号：US09149889
申请日：1998-09-08
申请人： Rajagopalan Govindarajan , Viswanathan Krishnamurthy , Anil Nori
发明人： Rajagopalan Govindarajan , Viswanathan Krishnamurthy , Anil Nori
IPC分类号： G06F1730
CPC分类号： G06F17/30607 , Y10S707/99942 , Y10S707/99944 , Y10S707/99952
摘要： A method and apparatus are provided for handling within a database system data items that are associated with data types whose native structure is not known to the database system. The data items are stored within the database system in their native structure, even though it is not understood by the database system. To store the data items, the database system calls a pickling routine that is provided by the user, or by the runtime subsystem of the programming environment that is native to the data item. To retrieve the routine from storage, the database system calls an unpickling routine, also provided by the user or the appropriate runtime subsystem. Because the database maintains the data items in their native format, no conversions are required as the data items are passed between the database system and external routines that manipulate the data items. Techniques are also provided for declaring attributes of the data item that can be accessed within the database system. The user provides routines for the database system to call in order to access the declared attributes, which may be different than the actual attributes that the data item has in its native environment.
摘要翻译：提供了一种方法和装置，用于在数据库系统内处理与其本身结构对于数据库系统不知道的数据类型相关联的数据项。数据项以其本机结构存储在数据库系统中，即使数据库系统不了解。为了存储数据项，数据库系统调用由用户提供的酸洗程序，或者由数据项原生的编程环境的运行时子系统。要从存储中检索该例程，数据库系统调用由用户或适当的运行时子系统提供的unpickling例程。由于数据库以其本机格式维护数据项，因此数据项在数据库系统和操作数据项的外部例程之间传递时，不需要转换。还提供了用于声明可在数据库系统中访问的数据项的属性的技术。用户提供数据库系统调用的例程，以访问声明的属性，这可能与数据项在其本机环境中具有的实际属性不同。

5. 发明授权

US06470348B1 Opaque types 有权
标题翻译：不透明类型
公开(公告)号：US06470348B1
公开(公告)日：2002-10-22
申请号：US09629541
申请日：2000-07-31
申请人： Rajagopalan Govindarajan , Viswanathan Krishnamurthy , Anil Nori
发明人： Rajagopalan Govindarajan , Viswanathan Krishnamurthy , Anil Nori
IPC分类号： G06F1730
CPC分类号： G06F17/30607 , Y10S707/99942 , Y10S707/99944 , Y10S707/99952
摘要： A method and apparatus are provided for handling within a database system data items that are associated with data types whose native structure is not known to the database system. The data items are stored within the database system in their native structure, even though it is not understood by the database system. To store the data items, the database system calls a pickling routine that is provided by the user, or by the runtime subsystem of the programming environment that is native to the data item. To retrieve the routine from storage, the database system calls an unpickling routine, also provided by the user or the appropriate runtime subsystem. Because the database maintains the data items in their native format, no conversions are required as the data items are passed between the database system and external routines that manipulate the data items. Techniques are also provided for declaring attributes of the data item that can be accessed within the database system. The user provides routines for the database system to call in order to access the declared attributes, which may be different than the actual attributes that the data item has in its native environment.
摘要翻译：提供了一种方法和装置，用于在数据库系统内处理与其本身结构对于数据库系统不知道的数据类型相关联的数据项。数据项以其本机结构存储在数据库系统中，即使数据库系统不了解。为了存储数据项，数据库系统调用由用户提供的酸洗程序，或者由数据项原生的编程环境的运行时子系统。要从存储中检索该例程，数据库系统调用由用户或适当的运行时子系统提供的unpickling例程。由于数据库以其本机格式维护数据项，因此数据项在数据库系统和操作数据项的外部例程之间传递时，不需要转换。还提供了用于声明可在数据库系统中访问的数据项的属性的技术。用户提供数据库系统调用的例程，以访问声明的属性，这可能与数据项在其本机环境中具有的实际属性不同。

6. 发明授权

US6128610A Index with entries that store the key of a row and all non-key values of the row 有权
标题翻译：索引，其中存储行的键和行的所有非键值的条目
公开(公告)号：US6128610A
公开(公告)日：2000-10-03
申请号：US139526
申请日：1998-08-25
申请人： Jagannathan Srinivasan , Samuel De Fazio , Anil Nori , Souripriya Das , Chuck Freiwald , Jayanta Banerjee
发明人： Jagannathan Srinivasan , Samuel De Fazio , Anil Nori , Souripriya Das , Chuck Freiwald , Jayanta Banerjee
IPC分类号： G06F17/30
CPC分类号： G06F17/30321 , Y10S707/99932 , Y10S707/99933 , Y10S707/99943
摘要： A method and apparatus for efficiently storing and retrieving data in a database using index-only tables is disclosed. 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 a user specified 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.
摘要翻译：公开了一种使用仅索引表在数据库中有效地存储和检索数据的方法和装置。使用仅索引表存储数据库中的一行数据涉及在叶节点中存储包含键值的索引条目以及数据行中的所有其他值。如果该数据行超过预定大小，则该行数据的一部分被存储在用户指定的溢出区域中。从用户提供的密钥的仅索引表中检索一行数据涉及识别密钥的叶节点，并且当该行超过预定的值时从索引条目读取一行数据和来自溢出区域的剩余部分尺寸。

7. 发明授权

US07007037B2 Opaque types 有权
公开(公告)号：US07007037B2
公开(公告)日：2006-02-28
申请号：US10192411
申请日：2002-07-09
申请人： Rajagopalan Govindarajan , Viswanathan Krishnamurthy , Anil Nori
发明人： Rajagopalan Govindarajan , Viswanathan Krishnamurthy , Anil Nori
IPC分类号： G06F17/00
CPC分类号： G06F17/30607 , Y10S707/99933 , Y10S707/99942 , Y10S707/99943 , Y10S707/99944 , Y10S707/99945 , Y10S707/99948
摘要： A method and apparatus are provided for handling within a database system data items that are associated with data types whose native structure is not known to the database system. The data items are stored within the database system in their native structure, even though it is not understood by the database system. To store the data items, the database system calls a pickling routine that is provided by the user, or by the runtime subsystem of the programming environment that is native to the data item. To retrieve the routine from storage, the database system calls an unpickling routine, also provided by the user or the appropriate runtime subsystem. Because the database maintains the data items in their native format, no conversions are required as the data items are passed between the database system and external routines that manipulate the data items.

8. 发明申请

US20090313436A1 CACHE REGIONS 有权
标题翻译：缓存区域
公开(公告)号：US20090313436A1
公开(公告)日：2009-12-17
申请号：US12465667
申请日：2009-05-14
申请人： Muralidhar Krishnaprasad , Anil Nori , Subramanian Muralidhar , Sudhir Mohan Jorwekar , Lakshmi Suresh Goduguluru
发明人： Muralidhar Krishnaprasad , Anil Nori , Subramanian Muralidhar , Sudhir Mohan Jorwekar , Lakshmi Suresh Goduguluru
IPC分类号： G06F12/08 , G06F12/00
CPC分类号： G06F12/0802 , G06F12/0813
摘要： A cache region can be created in a cache in response to receiving a cache region creation request from an application. A storage request from the application can identify the cache region and one or more objects to be stored in the cache region. Those objects can be stored in the cache region in response to receiving the storage request.
摘要翻译：响应于从应用程序接收高速缓存区域创建请求，可以在高速缓存中创建高速缓存区域。来自应用的存储请求可以识别高速缓存区域和要存储在高速缓存区域中的一个或多个对象。响应于接收到存储请求，可以将这些对象存储在高速缓存区域中。

9. 发明申请

US20060123020A1 Computer file system allowing ambiguous names 审中-公开
标题翻译：计算机文件系统允许含糊的名称
公开(公告)号：US20060123020A1
公开(公告)日：2006-06-08
申请号：US11004933
申请日：2004-12-07
申请人： Andrew Bybee , Anil Nori , Balan Raman , Timothy McKee , Walter Smith
发明人： Andrew Bybee , Anil Nori , Balan Raman , Timothy McKee , Walter Smith
IPC分类号： G06F7/00
CPC分类号： G06F16/164
摘要： A file system that does not require unique item names, or any item name at all, is described herein. If an item has an ambiguous name, the file system performs a disambiguating procedure to provide the client (user or application) a conceptually unique name, including a fully qualified path. The file system provides usability features such that the file system maintains compatibility with legacy applications and systems, including creating a synthetic item name when the item has no name, and disambiguating two items having the same name by using a disambiguating character, such as a small integer or alphanumeric character.
摘要翻译：本文描述了不需要唯一项目名称或任何项目名称的文件系统。如果某个项目具有不明确的名称，则文件系统将执行消歧义过程，以向客户端（用户或应用程序）提供概念上唯一的名称，包括完全限定的路径。文件系统提供可用性特征，使得文件系统保持与遗留应用和系统的兼容性，包括当该项目没有名称时创建合成项目名称，以及通过使用消歧字符来消除具有相同名称的两个项目，例如小的整数或字母数字字符

10. 发明申请

US20050050537A1 Systems and method for representing relationships between units of information manageable by a hardware/software interface system 有权
标题翻译：用于表示由硬件/软件接口系统可管理的信息的单元之间的关系的系统和方法
公开(公告)号：US20050050537A1
公开(公告)日：2005-03-03
申请号：US10646645
申请日：2003-08-21
申请人： J. Thompson , Anil Nori
发明人： J. Thompson , Anil Nori
IPC分类号： G06F9/44
CPC分类号： G06F17/30067 , G06F8/24 , G06F17/30607 , Y10S707/99944
摘要： Various embodiments of the present invention are directed to a method for manipulating a plurality of discrete units of information (“Items”) in a hardware/software interface system for a computer system, said method comprising interconnecting said Items with a plurality of Relationships and managing said Relationships at the hardware/software interface system level. Each Relationship constitutes, at the hardware/software interface system level, a mapping between a pair of Items that said Relationship interconnects. Moreover, each Relationship may have properties of its own distinct and separate from the properties of the Items it interconnects.
摘要翻译：本发明的各种实施例涉及一种在用于计算机系统的硬件/软件接口系统中操纵多个离散信息单元（“项目”）的方法，所述方法包括将所述项目与多个关系互连并管理在硬件/软件界面系统层面说关系。每个关系在硬件/软件界面系统层面上构成了所述关系互连的一对项目之间的映射。此外，每个关系可以具有其自身的属性，与其互连的项目的属性不同。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式