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

1. 发明申请

WO2005101245A1 EFFICIENT QUERY PROCESSING OF XML DATA USING XML INDEX 审中-公开
标题翻译：使用XML索引对XML数据进行有效的查询处理
公开(公告)号：WO2005101245A1
公开(公告)日：2005-10-27
申请号：PCT/US2005/011762
申请日：2005-04-06
申请人： ORACLE INTERNATIONAL CORPORATION , THUSOO, Ashish , MURTHY, Ravi , CHANDRASEKAR, Sivasankaran , AGARWAL, Nipun , SEDLAR, Eric
发明人： THUSOO, Ashish , MURTHY, Ravi , CHANDRASEKAR, Sivasankaran , AGARWAL, Nipun , SEDLAR, Eric
IPC分类号： 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的规则。

2. 发明申请

WO2005101246A1 INDEX FOR ACCESSING XML DATA 审中-公开
标题翻译：用于访问XML数据的索引
公开(公告)号：WO2005101246A1
公开(公告)日：2005-10-27
申请号：PCT/US2005/011763
申请日：2005-04-06
申请人： ORACLE INTERNATIONAL CORPORATION , CHANDRASEKAR, Sivasankaran , MURTHY, Ravi , THUSOO, Ashish , TRAN, Anh-Tuan , MUKKAMALLA, Sreedhar , SEDLAR, Eric , AGARWAL, Nipun
发明人： CHANDRASEKAR, Sivasankaran , MURTHY, Ravi , THUSOO, Ashish , TRAN, Anh-Tuan , MUKKAMALLA, Sreedhar , SEDLAR, Eric , AGARWAL, Nipun
IPC分类号： G06F17/30
CPC分类号： G06F17/30911
摘要： Techniques are provided for indexing XML documents. According to one embodiment, a PATH table created for storing one row for each indexed node of the XML documents. The PATH table row for a node includes (1) information for locating the XML document that contains the node, (2) information that identifies the path of the node, and (3) information that identifies the position of the node within the hierarchical structure of the XML document that contains the node. If the node is associated with the value, then the PATH table row for the node may also include the value. Use of the PATH table to answer XPath queries is facilitated by secondary indexes.
摘要翻译：提供技术用于索引XML文档。根据一个实施例，创建用于为XML文档的每个索引节点存储一行的PATH表。节点的PATH表行包括（1）用于定位包含节点的XML文档的信息，（2）标识节点路径的信息，以及（3）标识分层结构中节点位置的信息的包含节点的XML文档。如果节点与该值相关联，则该节点的PATH表行也可能包含该值。辅助索引便于使用PATH表来回答XPath查询。

3. 发明申请

WO2006009664A1 EFFICIENT EXTRACTION OF XML CONTENT STORED IN A LOB 审中-公开
标题翻译：有效提取存储在LOB中的XML内容
公开(公告)号：WO2006009664A1
公开(公告)日：2006-01-26
申请号：PCT/US2005/020795
申请日：2005-06-13
申请人： ORACLE INTERNATIONAL CORPORATION , CHANDRASEKAR, Sivasankaran , THUSOO, Ashish , MURTHY, Ravi , AGARWAL, Nipun , SEDLAR, Eric , MUKKAMALLA, Sreedhar
发明人： CHANDRASEKAR, Sivasankaran , THUSOO, Ashish , MURTHY, Ravi , AGARWAL, Nipun , SEDLAR, Eric , MUKKAMALLA, Sreedhar
IPC分类号： G06F17/30
CPC分类号： G06F17/30914 , G06F17/30911 , G06F17/30929 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945 , Y10S707/99948
摘要： A method and system are provided for extracting a valid, self-contained fragment for a node in a XML document stored in a database management system. An XML index is used to identify a location in which XML fragment data corresponding to the node is located. Ancestors of the node are identified and examined for any information needed for the proper interpretation of the fragment. If an ancestor node contains such needed information, this information is patched into the XML fragment to ensure that the fragment is a valid, self-contained XML fragment.
摘要翻译：提供了一种用于提取存储在数据库管理系统中的XML文档中的节点的有效的，独立的片段的方法和系统。 XML索引用于标识与节点对应的XML片段数据所在的位置。识别和检查节点的祖先，以便适当解释片段所需的任何信息。如果祖先节点包含这些所需的信息，则将该信息修补到XML片段中，以确保该片段是有效的，独立的XML片段。

4. 发明申请

WO2006009666A1 EFFICIENT QUERIBILITY AND MANAGEABILITY OF AN XML INDEX WITH PATH SUBSETTING 审中-公开
标题翻译： XML索引与路径优化的有效查询和可管理性
公开(公告)号：WO2006009666A1
公开(公告)日：2006-01-26
申请号：PCT/US2005/020802
申请日：2005-06-13
申请人： ORACLE INTERNATIONAL CORPORATION , THUSOO, Ashish , CHANDRASEKAR, Sivasankaran , MURTHY, Ravi , AGARWAL, Nipun , SEDLAR, Eric , MUKKAMALLA, Sreedhar , KOO, Reema
发明人： THUSOO, Ashish , CHANDRASEKAR, Sivasankaran , MURTHY, Ravi , AGARWAL, Nipun , SEDLAR, Eric , MUKKAMALLA, Sreedhar , KOO, Reema
IPC分类号： G06F17/30
CPC分类号： G06F17/30911 , G06F17/30935 , G06F17/30938 , Y10S707/99932 , Y10S707/99942
摘要： A method and system are provided for determining whether a given path is an indexed path of XML documents stored in a database management system. A finite state machine is built using the path subsetting rules specified by a user. The finite state machine is traversed using the given path. If any accepting states are reached during the traversal of the finite state machine, the given path is determined to matching the path subsetting rules.
摘要翻译：提供了一种用于确定给定路径是否存储在数据库管理系统中的XML文档的索引路径的方法和系统。使用用户指定的路径子集规则构建有限状态机。使用给定的路径遍历有限状态机。如果在遍历有限状态机期间达到任何接受状态，则确定给定路径以匹配路径子集规则。

5. 发明申请

WO2005026990A1 HANDLING DOCUMENT OPERATION REQUESTS ON DOCUMENTS HAVING LARGE COLLECTIONS WITH CONSTRAINED MEMORY 审中-公开
标题翻译：有约束内存的大型收藏品的文件处理文件操作要求
公开(公告)号：WO2005026990A1
公开(公告)日：2005-03-24
申请号：PCT/US2004/028735
申请日：2004-09-03
申请人： ORACLE INTERNATIONAL CORPORATION , THUSOO, Ashish , CHANDRASEKAR, Sivasankaran , MURTHY, Ravi , SEDLAR, Eric , AGARWAL, Nipun
发明人： THUSOO, Ashish , CHANDRASEKAR, Sivasankaran , MURTHY, Ravi , SEDLAR, Eric , AGARWAL, Nipun
IPC分类号： G06F17/30
CPC分类号： G06F17/30011 , Y10S707/99931 , Y10S707/99932 , Y10S707/99953
摘要： A method and system of handling document operation requests on documents with large collections and constrained memory is disclosed. In some embodiments, when one or more collection elements of a document are required to be in memory for a document operation, each of the one or more required collection elements not already in the memory are loaded into a collection partition in the memory before the document operation is executed.
摘要翻译：公开了一种处理文档操作请求的方法和系统，该文档操作请求具有大的集合和约束的内存的文档。在一些实施例中，当文档的一个或多个收集元素被要求在用于文档操作的存储器中时，尚未在存储器中的一个或多个所需的收集元件中的每一个都将被加载到存储器中的收集分区中执行操作。

6. 发明申请

WO2005022415A1 IN-PLACE EVOLUTION OF XML SCHEMAS IN DATABASES 审中-公开
标题翻译：数据库中XML方案的演进
公开(公告)号：WO2005022415A1
公开(公告)日：2005-03-10
申请号：PCT/US2004/027464
申请日：2004-08-23
申请人： ORACLE INTERNATIONAL CORPORATION , IDICULA, Sam , CHANDRASEKAR, Sivasankaran , AGARWAL, Nipun , MURTHY, Ravi
发明人： IDICULA, Sam , CHANDRASEKAR, Sivasankaran , AGARWAL, Nipun , MURTHY, Ravi
IPC分类号： G06F17/30
CPC分类号： G06F17/30297 , G06F17/30908
摘要： A method and system for the in-place evolution of XML schemas is disclosed. To automatically evolve an existing XML schema, a schema evolver receives both an existing XML schema and an XML document as input. The XML document indicates changes to be made to the existing XML schema. Based on the existing XML schema and the XML document, the schema evolver evolves the existing XML schema into a new XML schema that incorporates the changes indicated in the XML document. According to one aspect, the schema evolver generates one or more SQL statements based on the new XML schema. The SQL statements, when executed by a database server, cause the database server to evolve database structures that were based on the formerly existing XML schema so that the database structures conform to the new XML schema. This is accomplished "in place," without copying the data in the database structures.
摘要翻译：公开了一种用于XML模式的就地演化的方法和系统。为了自动演进现有的XML模式，架构演进程序接收现有的XML模式和XML文档作为输入。 XML文档指示对现有XML模式进行的更改。基于现有的XML架构和XML文档，架构演进者将现有的XML架构演变为新的XML架构，其中包含XML文档中指示的更改。根据一个方面，模式演进者基于新的XML模式生成一个或多个SQL语句。 SQL语句在由数据库服务器执行时，会导致数据库服务器发展基于以前存在的XML模式的数据库结构，以便数据库结构符合新的XML模式。这完成了“到位”，而不复制数据库结构中的数据。

7. 发明申请

WO2007078479A3 METHOD AND MECHANISM FOR LOADING XML DOCUMENTS INTO MEMORY 审中-公开
公开(公告)号：WO2007078479A3
公开(公告)日：2007-07-12
申请号：PCT/US2006/045700
申请日：2006-11-29
申请人： ORACLE INTERNATIONAL CORPORATION , CHANDRASEKAR, Sivasankaran , AGARWAL, Nipun , JAIN, Namit , MURTHY, Ravi
发明人： CHANDRASEKAR, Sivasankaran , AGARWAL, Nipun , JAIN, Namit , MURTHY, Ravi
IPC分类号： G06F17/22
摘要： A method and apparatus for loading an XML document into memory is provided. A client loads one or more array elements into a first partition of an array that is maintained in memory. Each array element represents an XML element of an XML document. Upon determining that an amount of data maintained in the first partition exceeds a first threshold, the client subsequently loads array elements into a new partition of the array. Upon determining that an amount of data maintained in the memory of the client exceeds a second threshold, the array elements of the least recently used partition are persistently stored in a database without persistently storing the entire XML document. When the last XML element of the XML document is loaded into a partition of the array, that partition is persistently stored in the database, thereby causing the entire XML document to be stored in the database.

8. 发明申请

WO2007136507A1 EFFICIENT PIECE-WISE UPDATES OF BINARY ENCODED XML DATA 审中-公开
标题翻译：二进制编码XML数据的有效性更新
公开(公告)号：WO2007136507A1
公开(公告)日：2007-11-29
申请号：PCT/US2007/010163
申请日：2007-04-24
申请人： ORACLE INTERNATIONAL CORPORATION , CHANDRASEKAR, Sivansankaran , GUPTA, Nitin , MURTHY, Ravi , AGARWAL, Nipun , SEDLAR, Eric
发明人： CHANDRASEKAR, Sivansankaran , GUPTA, Nitin , MURTHY, Ravi , AGARWAL, Nipun , SEDLAR, Eric
IPC分类号： 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文档实现为相应的文本形式。考虑到文档编码的二进制形式的性质，确定实际需要更改的字节，包括识别二进制表示中需要进行相应实际更改的位置。

9. 发明申请

WO2005024670A1 METHOD AND MECHANISM FOR EFFICIENT STORAGE AND QUERY OF XML DOCUMENTS BASED ON PATHS 审中-公开
标题翻译：基于PATHS的XML文档的有效存储和查询的方法和机制
公开(公告)号：WO2005024670A1
公开(公告)日：2005-03-17
申请号：PCT/US2004/029070
申请日：2004-09-03
申请人： ORACLE INTERNATIONAL CORPORATION , MURTHY, Ravi , AGARWAL, Nipun , SEDLAR, Eric
发明人： MURTHY, Ravi , AGARWAL, Nipun , SEDLAR, Eric
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. 发明申请

WO2006065269A1 TECHNIQUES FOR PROVIDING LOCKS FOR FILE OPERATIONS IN A DATABASE MANAGEMENT SYSTEM 审中-公开
标题翻译：在数据库管理系统中提供文件操作的锁的技术
公开(公告)号：WO2006065269A1
公开(公告)日：2006-06-22
申请号：PCT/US2005/015033
申请日：2005-04-28
申请人： ORACLE INTERNATIONAL CORPORATION , IDICULA, Sam , JAIN, Namit , PANNALA, Syam , KRISHNASWAMY, Vasudha , SEDLAR, Eric , AGARWAL, Nipun , SINHA, Bipul , MURTHY, Ravi
发明人： IDICULA, Sam , JAIN, Namit , PANNALA, Syam , KRISHNASWAMY, Vasudha , SEDLAR, Eric , AGARWAL, Nipun , SINHA, Bipul , MURTHY, Ravi
IPC分类号： G06F17/30
CPC分类号： G06F17/30171
摘要： A method and apparatus for performing file system operation locks at a database server is provided. A request to perform a file operation on a portion of a file managed by a database server is received at the database server. In response to receiving the request, the database server grants a lock that covers only a portion of the file that is involved in the file operation. For example, the database server may grant a lock that covers a range of bytes on the file, where the range of bytes is less than the entire file. Thereafter, the database server performs the file operation on the file. The file operation may be a NFS operation.
摘要翻译：提供了一种用于在数据库服务器执行文件系统操作锁定的方法和装置。在数据库服务器处接收对由数据库服务器管理的文件的一部分执行文件操作的请求。响应于接收到该请求，数据库服务器授予仅覆盖文件操作中涉及的文件的一部分的锁。例如，数据库服务器可以授予覆盖文件范围的字节的锁，其中字节的范围小于整个文件。此后，数据库服务器对文件执行文件操作。文件操作可能是NFS操作。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式