公开(公告)号：US20060080345A1

公开(公告)日：2006-04-13

申请号：US11286873

申请日：2005-11-22

申请人： Ravi Murthy ,  Sivasankaran Chandrasekar ,  Eric Sedlar ,  Nipun Agarwal

发明人： Ravi Murthy ,  Sivasankaran Chandrasekar ,  Eric Sedlar ,  Nipun Agarwal

IPC分类号： G06F17/30

CPC分类号： G06F17/30938 ,  G06F17/2205 ,  G06F17/2229 ,  G06F17/2247 ,  G06F17/30321 ,  G06F17/30911 ,  G06F17/30917

摘要： A method and apparatus for efficiently maintaining XML index structures in a database system is provided. Instead of immediately synchronizing the XML index structures for every change submitted to the database, the changes are stored in a PENDING table. The XML index structures are periodically synchronized, based on certain criteria or at a user's discretion. Between synchronizations, the XML index structures may be in stale mode or current mode. If in stale mode, a request to access indexed information will use the XML index structures to find the desired indexed information without checking the PENDING table. If in current mode, a request to access indexed information will search the XML index structures and also check the PENDING table to determine 1) whether the indexed information has been updated or deleted, and 2) whether information relevant to the request has been inserted or updated.

公开(公告)号：US20050228828A1

公开(公告)日：2005-10-13

申请号：US11059612

申请日：2005-02-15

申请人： Sivasankaran Chandrasekar ,  Ashish Thusoo ,  Ravi Murthy ,  Nipun Agarwal ,  Eric Sedlar ,  Sreedhar Mukkamalla

发明人： Sivasankaran Chandrasekar ,  Ashish Thusoo ,  Ravi Murthy ,  Nipun Agarwal ,  Eric Sedlar ,  Sreedhar Mukkamalla

IPC分类号： G06F17/00 ,  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片段。

公开(公告)号：US20050228791A1

公开(公告)日：2005-10-13

申请号：US11059665

申请日：2005-02-15

申请人： Ashish Thusoo ,  Sivasankaran Chandrasekar ,  Ravi Murthy ,  Nipun Agarwal ,  Eric Sedlar ,  Sreedhar Mukkamalla ,  Reema Koo

发明人： Ashish Thusoo ,  Sivasankaran Chandrasekar ,  Ravi Murthy ,  Nipun Agarwal ,  Eric Sedlar ,  Sreedhar Mukkamalla ,  Reema Koo

IPC分类号： G06F7/00

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文档的索引路径的方法和系统。 使用用户指定的路径子集规则构建有限状态机。 使用给定的路径遍历有限状态机。 如果在遍历有限状态机期间达到任何接受状态，则确定给定路径以匹配路径子集规则。

公开(公告)号：US09953103B2

公开(公告)日：2018-04-24

申请号：US11601118

申请日：2006-11-16

申请人： Bhushan Khaladkar ,  Sivasankaran Chandrasekar ,  Ravi Murthy ,  Nipun Agarwal

发明人： Bhushan Khaladkar ,  Sivasankaran Chandrasekar ,  Ravi Murthy ,  Nipun Agarwal

IPC分类号： G06F17/30 ,  G06F17/22 ,  H03M7/30

CPC分类号： G06F17/30914 ,  G06F17/2217 ,  H03M7/30

摘要： Techniques are provided for encoding/decoding binary XML data in a client program before sending/receiving the XML to/from a database server. By encoding the binary XML at the client, the overhead of parsing the XML text is avoided by the database server, thus improving database server scalability. Also, the XML data is sent by the server to the client in the binary form, and the binary format is decoded by the client program to perform the necessary operations.

公开(公告)号：US09069878B2

公开(公告)日：2015-06-30

申请号：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

摘要： 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.

公开(公告)号：US08554789B2

公开(公告)日：2013-10-08

申请号：US11246001

申请日：2005-10-07

申请人： Abhyudaya Agrawal ,  Ravi Murthy ,  Nipun Agarwal ,  Sivasankaran Chandrasekar ,  Eric Sedlar

发明人： Abhyudaya Agrawal ,  Ravi Murthy ,  Nipun Agarwal ,  Sivasankaran Chandrasekar ,  Eric Sedlar

IPC分类号： G06F17/30 ,  G06F12/00

CPC分类号： G06F17/2247 ,  G06F17/30917

摘要： A database system automatically detects a cyclic construct in a XML schema, determines a database representation for the cyclic construct, and maps the XML schema and elements involved in the cyclic construct to the database representation.

摘要翻译： 数据库系统自动检测XML模式中的循环结构，确定循环结构的数据库表示，并将循环结构中涉及的XML模式和元素映射到数据库表示。

公开(公告)号：US08510292B2

公开(公告)日：2013-08-13

申请号：US11442106

申请日：2006-05-25

申请人： Asha Tarachandani ,  Sivasankaran Chandrasekar ,  Man-Hay Tam ,  Anh-Tuan Tran ,  Ravi Murthy ,  Nipun Agarwal ,  Eric Sedlar

发明人： Asha Tarachandani ,  Sivasankaran Chandrasekar ,  Man-Hay Tam ,  Anh-Tuan Tran ,  Ravi Murthy ,  Nipun Agarwal ,  Eric Sedlar

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30011 ,  G06F17/2229 ,  G06F17/2247 ,  G06F17/30908

摘要： A mechanism is provided for detecting and disregarding application specific nodes contained in shared XML documents. The techniques described involve determining one or more application specific nodes within XML documents and performing path expression evaluations of the XML documents as if the nodes are not present. In one embodiment, a mechanism is provided by which a user may specify the criterion that determines which subset of nodes in XML documents are to be ignored from path expression evaluations. A query that specifies a path operation based on a path is evaluated ignoring said identified nodes when evaluating said path operation.

摘要翻译： 提供了一种用于检测和忽略包含在共享XML文档中的应用程序特定节点的机制。 所描述的技术涉及确定XML文档内的一个或多个应用特定节点，并且如同节点不存在一样执行XML文档的路径表达式评估。 在一个实施例中，提供了一种机制，用户可以通过该机制指定确定XML文档中的节点的哪个子集将被从路径表达式评估中被忽略的标准。 在评估所述路径操作时，忽略指定基于路径的路径操作的查询，忽略所述标识的节点。

公开(公告)号：US08180791B2

公开(公告)日：2012-05-15

申请号：US11937357

申请日：2007-11-08

申请人： Ning Zhang ,  Thomas Baby ,  Sivasankaran Chandrasekar ,  Nipun Agarwal

发明人： Ning Zhang ,  Thomas Baby ,  Sivasankaran Chandrasekar ,  Nipun Agarwal

IPC分类号： G06F7/00

CPC分类号： G06F17/30932 ,  G06F17/30935

摘要： A query is rewritten to combine streaming evaluation and XML index evaluation. The query is rewritten to include a streaming operator (e.g. function) that, when executed, uses streaming evaluation. Further, the query is rewritten so that XML index evaluation of a path expression also produces location information that identifies the location of a node within an XML document. The streaming operator is able to exploit the location information to begin and end scanning rather than scanning the entire XML document.

摘要翻译： 重写查询以组合流评估和XML索引评估。 该查询被重写以包括流执行器（例如，功能），当被执行时，使用流评估。 此外，重写该查询，使得路径表达式的XML索引评估还产生标识XML文档中的节点的位置的位置信息。 流操作员能够利用位置信息开始和结束扫描，而不是扫描整个XML文档。

公开(公告)号：US20110295817A1

公开(公告)日：2011-12-01

申请号：US12791337

申请日：2010-06-01

申请人： Sivasankaran Chandrasekar ,  Nipun Agarwal

发明人： Sivasankaran Chandrasekar ,  Nipun Agarwal

IPC分类号： G06F17/30

CPC分类号： H03M7/30 ,  G06F17/30914

摘要： A method and apparatus for XXX is provided.

摘要翻译： 提供了一种用于XXX的方法和装置。

公开(公告)号：US07991768B2

公开(公告)日：2011-08-02

申请号：US11937268

申请日：2007-11-08

申请人： Thomas Baby ,  Ning Zhang ,  Sivasankaran Chandrasekar ,  Nipun Agarwal ,  Asha Tarachandani

发明人： Thomas Baby ,  Ning Zhang ,  Sivasankaran Chandrasekar ,  Nipun Agarwal ,  Asha Tarachandani

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30911 ,  G06F17/30935

摘要： Techniques for processing a query that includes a path expression are provided. A query processor determines whether an XML index may be used to execute the query instead of having to scan multiple XML documents. The query is parsed and normalized, which results in multiple normalized path expressions that are based on the original path expression. If the XML index is a path-subsetted index, then the query processor generates annotated path expressions based on the normalized path expressions. The query processor determines whether each of the annotated path expressions is satisfiable by the path-subsetted XML index. If so, then the XML index is used to process the query.

摘要翻译： 提供了处理包含路径表达式的查询的技术。 查询处理器确定是否可以使用XML索引来执行查询，而不必扫描多个XML文档。 查询被解析和归一化，这导致基于原始路径表达式的多个标准化路径表达式。 如果XML索引是路径子集索引，则查询处理器将根据归一化的路径表达式生成带注释的路径表达式。 查询处理器确定每个注释路径表达式是否由路径子集的XML索引满足。 如果是这样，则使用XML索引来处理查询。