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

61. 发明授权

US07051033B2 Providing a consistent hierarchical abstraction of relational data 有权
公开(公告)号：US07051033B2
公开(公告)日：2006-05-23
申请号：US10260384
申请日：2002-09-27
申请人： Nipun Agarwal , Eric Sedlar , Ravi Murthy , Namit Jain
发明人： Nipun Agarwal , Eric Sedlar , Ravi Murthy , Namit Jain
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06F17/30595 , G06F17/30917 , Y10S707/99931 , Y10S707/99933 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945
摘要： A hierarchy may be explicitly or implicitly reflected in existing data maintained external to hierarchy structures. Such hierarchies are referred to herein as a “pre-existing hierarchies”. Techniques are described herein for capturing a pre-existing hierarchy in hierarchy structures. After a pre-existing hierarchy has been captured, there exist two independent sets of data that reflect the hierarchy: the external hierarchy definition and the internal hierarchy definition. Changing either hierarchy definition changes the hierarchy. Therefore, to maintain a consistent reflection of the hierarchy, the internal hierarchy definition must be modified in response to changes made to the external hierarchy definition, and the external hierarchy definition must be modified in response to changes made to the internal hierarchy definition. Various techniques are described for maintaining consistency between the two hierarchy definitions.

62. 发明申请

US20060101041A1 Providing a consistent hierarchical abstraction of relational data 有权
公开(公告)号：US20060101041A1
公开(公告)日：2006-05-11
申请号：US11315835
申请日：2005-12-21
申请人： Nipun Agarwal , Eric Sedlar , Ravi Murthy , Namit Jain
发明人： Nipun Agarwal , Eric Sedlar , Ravi Murthy , Namit Jain
IPC分类号： G06F7/00
CPC分类号： G06F17/30595 , G06F17/30917 , Y10S707/99931 , Y10S707/99933 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945
摘要： A hierarchy may be explicitly or implicitly reflected in existing data maintained external to hierarchy structures. Such hierarchies are referred to herein as a “pre-existing hierarchies”. Techniques are described herein for capturing a pre-existing hierarchy in hierarchy structures. After a pre-existing hierarchy has been captured, there exist two independent sets of data that reflect the hierarchy: the external hierarchy definition and the internal hierarchy definition. Changing either hierarchy definition changes the hierarchy. Therefore, to maintain a consistent reflection of the hierarchy, the internal hierarchy definition must be modified in response to changes made to the external hierarchy definition, and the external hierarchy definition must be modified in response to changes made to the internal hierarchy definition. Various techniques are described for maintaining consistency between the two hierarchy definitions.

63. 发明授权

US06965903B1 Techniques for managing hierarchical data with link attributes in a relational database 有权
标题翻译：用于使用关系数据库中的链接属性来管理分层数据的技术
公开(公告)号：US06965903B1
公开(公告)日：2005-11-15
申请号：US10306485
申请日：2002-11-26
申请人： Nipun Agarwal , Fei Ge , Sivasankaran Chandrasekar , Ravi Murthy , Eric Sedlar
发明人： Nipun Agarwal , Fei Ge , Sivasankaran Chandrasekar , Ravi Murthy , Eric Sedlar
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945 , Y10S707/99948
摘要： Techniques for managing hierarchical data include managing a link table in a relational database. The hierarchical data includes data about a hierarchy of nodes related by multiple links. The link table includes first information, second information and link information, for each link. First information indicates a first node in the hierarchical data. Second information indicates a second node that is associated with the first node by the link. Link information indicates values for link attributes of the link between the first node and the second node, and does not indicate a value for any attribute of the first node alone or any attribute of the second node alone. The techniques support directing a single SQL statement to a path database object, constructed based on the link table, in order to obtain paths that satisfy a search on link attributes.
摘要翻译：用于管理分级数据的技术包括管理关系数据库中的链接表。层次数据包括关于多个链路相关节点的层次结构的数据。链路表包括每个链路的第一信息，第二信息和链路信息。第一信息表示层次数据中的第一节点。第二信息指示通过链路与第一节点相关联的第二节点。链接信息指示第一节点和第二节点之间的链接的链接属性的值，并且不指示单独的第一节点的任何属性或仅第二节点的任何属性的值。这些技术支持将单个SQL语句定向到基于链接表构建的路径数据库对象，以便获得满足链接属性搜索的路径。

64. 发明申请

US20050240624A1 Cost-based optimizer for an XML data repository within a database 有权
标题翻译：数据库中XML数据存储库的基于成本的优化器
公开(公告)号：US20050240624A1
公开(公告)日：2005-10-27
申请号：US10830211
申请日：2004-04-21
申请人： Fei Ge , Sivasankaran Chandrasekar , Nipun Agarwal , Ravi Murthy , Eric Sedlar
发明人： Fei Ge , Sivasankaran Chandrasekar , Nipun Agarwal , Ravi Murthy , Eric Sedlar
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30935
摘要： Cost-based optimizer functionality for an XML database repository provides means for optimizing the execution of database queries that access XML resources in the database repository. Statistics about XML resources that are stored in the database repository are gathered, stored and utilized by a query optimizer to compute computational costs associated with each of multiple methods of accessing particular XML resources requested in a database query. Hence, the optimizer is able to select the most efficient query execution plan based on the costs of possible access paths. In one embodiment, specific statistics about the hierarchical structure of XML resources stored in the XML database repository are gathered, stored in a relational table in the database management system, and used to compute the selectivity of query predicates and the index cost associated with traversing one or more indexes to access requested XML resources.
摘要翻译：用于XML数据库的基于成本的优化器功能提供了优化访问数据库存储库中的XML资源的数据库查询的执行的方法。存储在数据库存储库中的关于XML资源的统计信息由查询优化器收集，存储和利用，以计算与访问数据库查询中请求的特定XML资源的多种方法中的每一种相关联的计算成本。因此，优化器能够基于可能的访问路径的成本来选择最有效的查询执行计划。在一个实施例中，收集存储在XML数据库存储库中的XML资源的层次结构的具体统计信息，存储在数据库管理系统中的关系表中，并用于计算查询谓词的选择性和与遍历一个相关联的索引成本或更多的索引来访问所请求的XML资源。

65. 发明申请

US20050229158A1 Efficient query processing of XML data using XML index 有权
标题翻译：使用XML索引对XML数据进行高效查询处理
公开(公告)号：US20050229158A1
公开(公告)日：2005-10-13
申请号：US10944170
申请日：2004-09-16
申请人： Ashish Thusoo , Ravi Murthy , Sivasankaran Chandrasekar , Nipun Agarwal , Eric Sedlar
发明人： Ashish Thusoo , Ravi Murthy , Sivasankaran Chandrasekar , Nipun Agarwal , Eric Sedlar
IPC分类号： G06F9/44 , G06F17/21 , G06F17/22 , G06F17/30
CPC分类号： G06F17/30914 , G06F17/2205 , G06F17/2229 , G06F17/2247 , G06F17/30911 , Y10S707/99932 , Y10S707/99935 , Y10S707/99945
摘要： A method and apparatus is provided for translating queries, such as path expressions and SQL/XML constructs, into SQL statements to be executed against an XML index, which improves processor time as opposed to applying path expressions directly to the original XML documents to extract the desired information. Simple path expressions, filter expressions, descendant axes, wildcards, logical expressions, relational expressions, literals, and other path expressions are all translated into SQL for efficient querying of an XML index. Similarly, rules for translating SQL/XML constructs into SQL are provided.
摘要翻译：提供了一种方法和装置，用于将诸如路径表达式和SQL / XML结构之类的查询转换为针对XML索引执行的SQL语句，这样可以提高处理器时间，而不是将路径表达式直接应用于原始XML文档来提取所需信息。简单的路径表达式，过滤器表达式，后代轴，通配符，逻辑表达式，关系表达式，文字和其他路径表达式都被转换为SQL，以便有效地查询XML索引。同样，提供了将SQL / XML结构转换为SQL的规则。

66. 发明授权

US06947950B2 Techniques for managing multiple hierarchies of data from a single interface 有权
标题翻译：用于从单个界面管理数据的多个层次结构的技术
公开(公告)号：US06947950B2
公开(公告)日：2005-09-20
申请号：US10305990
申请日：2002-11-26
申请人： Ravi Murthy , Eric Sedlar , Nipun Agarwal
发明人： Ravi Murthy , Eric Sedlar , Nipun Agarwal
IPC分类号： G06F17/30
CPC分类号： G06F17/30067 , Y10S707/99944
摘要： Techniques for managing multiple hierarchies of data from a single native hierarchy include registering a set of routines for each foreign hierarchy. The set of routines performs a set of operations on data in the hierarchy associated with a node. A user request is received, which indicates a particular operation on particular data that does not correspond to a node of the native hierarchy. Based on the user request, a first operation on a first set of one or more nodes of a first hierarchy that is not the native hierarchy is determined. A particular routine that corresponds to the first operation is selected from a first set of routines registered for the first hierarchy, and is invoked. These techniques allow a user to employ a consistent interface with the native hierarchy to reach data in any of the hierarchies.
摘要翻译：用于管理来自单个本机层次的数据的多个层次结构的技术包括为每个外部层级注册一组例程。该集合的例程对与节点相关联的层级中的数据执行一组操作。接收到用户请求，其指示对与本机层次结构的节点不对应的特定数据的特定操作。基于用户请求，确定不是本机层次的第一层次的一个或多个节点的第一组的第一操作。从第一层次注册的第一组例程中选择对应于第一操作的特定例程，并且被调用。这些技术允许用户使用与本机层次结构一致的接口来达到任何层次结构中的数据。

67. 发明申请

US20050050058A1 Direct loading of opaque types 有权
标题翻译：直接加载不透明类型
公开(公告)号：US20050050058A1
公开(公告)日：2005-03-03
申请号：US10648577
申请日：2003-08-25
申请人： Namit Jain , Ellen Batbouta , Nipun Agarwal , Ravi Murthy , Paul Reilly , James Stenoish
发明人： Namit Jain , Ellen Batbouta , Nipun Agarwal , Ravi Murthy , Paul Reilly , James Stenoish
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30286
摘要： Techniques and systems are disclosed for storing instances of an opaque type in a database according to a direct path loading approach. According to one aspect, an opaque type implementor registers, with a loader application, routines that the opaque type implementor implements. In response, the loader application associates the opaque type with the routines. The loader application reads data that comprises instances of the opaque type. The loader application determines which routines are associated with the opaque type. The loader application invokes the routines, which create an array for storing instances of the opaque type and populate the array with values specified in the data. The loader application converts the array into a data stream that conforms to the format of the database's data blocks. The loader application then streams the data to a database server, which writes the data directly into data blocks in the database.
摘要翻译：公开了根据直接路径加载方法在数据库中存储不透明类型的实例的技术和系统。根据一个方面，不透明类型的实现者使用加载器应用程序来注册不透明类型实现者实现的例程。作为响应，加载程序应用程序将不透明类型与例程相关联。加载程序应用程序读取包含不透明类型实例的数据。加载程序应用程序确定哪些程序与不透明类型相关联。加载程序应用程序调用例程，它创建一个数组来存储不透明类型的实例，并使用数据中指定的值填充数组。加载程序应用程序将阵列转换为符合数据库数据块格式的数据流。然后，加载器应用程序将数据流传输到数据库服务器，数据库服务器将数据直接写入数据库中的数据块。

68. 发明授权

US06795817B2 Method and system for improving response time of a query for a partitioned database object 有权
标题翻译：用于改进对分区数据库对象的查询的响应时间的方法和系统
公开(公告)号：US06795817B2
公开(公告)日：2004-09-21
申请号：US09872670
申请日：2001-05-31
申请人： Nipun Agarwal , Ravi Murthy
发明人： Nipun Agarwal , Ravi Murthy
IPC分类号： G06F1730
CPC分类号： G06F17/30445 , Y10S707/99932 , Y10S707/99936 , Y10S707/99937
摘要： A method and mechanism to improve the response time of a query that is executed against a partitioned database object. Only a subset or portion of the partitions are accessed during each pass through the partitions, in which only the retrieved portions of the partitions are processed, and in which results can be immediately returned for the query. Processing only a subset of a partition in a given pass permits each partition to be processed multiple times, rather than requiring a first partition to be entirely processed before processing a second partition. In one approach, the query includes a statement to order the result set for a query against a partitioned database object that contains a local index.
摘要翻译：一种改进针对分区数据库对象执行的查询的响应时间的方法和机制。在每次通过分区期间只访问分区的子集或部分，其中仅处理所检索的分区的部分，并且可以立即为查询返回哪些结果。在给定通过中仅处理分区的子集允许每个分区被多次处理，而不是要求在处理第二个分区之前完全处理第一个分区。在一种方法中，查询包括一个语句，用于针对包含本地索引的分区数据库对象对查询的结果集进行排序。

69. 发明授权

US09460064B2 Efficient piece-wise updates of binary encoded XML data 有权
标题翻译：二进制编码的XML数据的高效分片更新
公开(公告)号：US09460064B2
公开(公告)日：2016-10-04
申请号：US11437512
申请日：2006-05-18
申请人： Sivansankaran Chandrasekar , Nitin Gupta , Ravi Murthy , Nipun Agarwal , Eric Sedlar
发明人： Sivansankaran Chandrasekar , Nitin Gupta , Ravi Murthy , Nipun Agarwal , Eric Sedlar
IPC分类号： G06F17/00 , G06F17/24 , G06F17/22 , G06F17/30
CPC分类号： G06F17/24 , G06F17/22 , G06F17/2247 , G06F17/2264 , G06F17/30911 , G06F17/30917
摘要： An XML document can be represented in a compact binary form that maintains all of the features of XML data in a useable form. In response to a request for a modification (e.g., insert, delete or update a node) to an XML document that is stored in the compact binary form, a certain representation of the requested modification is computed for application directly to the binary form of the document. Thus, the requested modification is applied directly to the persistently stored binary form without constructing an object tree or materializing the XML document into a corresponding textual form. Taking into account the nature of the binary form in which the document is encoded, the bytes that actually require change are identified, including identifying where in the binary representation the corresponding actual changes need to be made.
摘要翻译： XML文档可以以紧凑的二进制形式表示，以可用的形式维护XML数据的所有功能。响应于以紧凑二进制形式存储的XML文档的修改（例如，插入，删除或更新节点）的请求，对所请求的修改的特定表示被直接计算到二进制形式的文件。因此，所请求的修改直接应用于永久存储的二进制形式，而不构造对象树或将XML文档实现为相应的文本形式。考虑到文档编码的二进制形式的性质，确定实际需要更改的字节，包括识别二进制表示中需要进行相应实际更改的位置。

70. 发明授权

US08078611B2 Query modes for translation-enabled XML documents 有权
标题翻译：支持翻译的XML文档的查询模式
公开(公告)号：US08078611B2
公开(公告)日：2011-12-13
申请号：US11648950
申请日：2007-01-03
申请人： Nipun Agarwal , Sanket Malde , Bhushan Khaladkar , Ravi Murthy , Sivasankaran Chandrasekar
发明人： Nipun Agarwal , Sanket Malde , Bhushan Khaladkar , Ravi Murthy , Sivasankaran Chandrasekar
IPC分类号： G06F17/30
CPC分类号： G06F17/30938 , G06F17/30932
摘要： Systems, methods, and other embodiments associated with providing query modes for translation-enabled XML documents are described. One method embodiment includes receiving an XPath query to an XML document that may store a translation for a data element. The method embodiment may also include automatically selecting a query mode for the XPath query. The method embodiment may also include querying the XML document using the XPath query and the selected query mode. The query mode may control, at least in part, the operation of an XML database logic.
摘要翻译：描述了与为支持翻译的XML文档提供查询模式相关联的系统，方法和其他实施例。一种方法实施例包括：向可能存储数据元素的翻译的XML文档接收XPath查询。方法实施例还可以包括自动选择XPath查询的查询模式。方法实施例还可以包括使用XPath查询和所选择的查询模式查询XML文档。至少部分地，查询模式可以控制XML数据库逻辑的操作。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式