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

1. 发明申请

US20070299834A1 Techniques of rewriting descendant and wildcard XPath using combination of SQL OR, UNION ALL, and XMLConcat() construct 有权
标题翻译：使用SQL OR，UNION ALL和XMLConcat（）构造的组合重写后代和通配符XPath的技术
公开(公告)号：US20070299834A1
公开(公告)日：2007-12-27
申请号：US11474038
申请日：2006-06-23
申请人： Zhen Hua Liu , Muralidhar Krishnaprasad , Hui Joe Chang , Anand Manikutty , James W. Warner , Vikas Arora , Susan Kotsovolos
发明人： Zhen Hua Liu , Muralidhar Krishnaprasad , Hui Joe Chang , Anand Manikutty , James W. Warner , Vikas Arora , Susan Kotsovolos
IPC分类号： G06F17/30
CPC分类号： G06F17/30935
摘要： A method for processing queries is provided. A first representation of a query is generated, where the query includes a certain operator that is to be performed based on an XPath expression that is expandable into multiple location paths. The first representation of the query is rewritten into a second representation that corresponds to an equivalent query, where rewriting the first representation includes expanding the XPath expression into the plurality of location paths and, based on the certain operator, including a plurality of operators in the second representation, where the plurality of operators include: a first set of operators that is to be performed based on each of the plurality of location paths, and a second set of operators that is to be performed based on data returned from at least one operator included in the first set of operators. The query may thereafter be executed based on the second representation. The second representation may be further rewritten to third representation depending on the physical storage of XML.
摘要翻译：提供了一种处理查询的方法。生成查询的第一个表示形式，其中查询包含一个基于可扩展到多个位置路径的XPath表达式执行的某个运算符。查询的第一表示被重写成对应于等效查询的第二表示，其中重写第一表示包括将XPath表达式扩展到多个位置路径中，并且基于特定运算符，包括多个运算符第二表示，其中所述多个运算符包括：将基于所述多个位置路径中的每一个来执行的第一组运算符，以及将基于从至少一个运算符返回的数据来执行的第二组运算符包含在第一组运算符中。此后可以基于第二表示来执行查询。取决于XML的物理存储，第二表示可以进一步重写为第三表示。

2. 发明授权

US07730080B2 Techniques of rewriting descendant and wildcard XPath using one or more of SQL OR, UNION ALL, and XMLConcat() construct 有权
标题翻译：使用SQL OR，UNION ALL和XMLConcat（）构造中的一个或多个重写后代和通配符XPath的技术
公开(公告)号：US07730080B2
公开(公告)日：2010-06-01
申请号：US11474038
申请日：2006-06-23
申请人： Zhen Hua Liu , Muralidhar Krishnaprasad , Hui Joe Chang , Anand Manikutty , James W. Warner , Vikas Arora , Susan Kotsovolos
发明人： Zhen Hua Liu , Muralidhar Krishnaprasad , Hui Joe Chang , Anand Manikutty , James W. Warner , Vikas Arora , Susan Kotsovolos
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30935
摘要： A method for processing queries is provided. A first representation of a query is generated, where the query includes a certain operator that is to be performed based on an XPath expression that is expandable into multiple location paths. The first representation of the query is rewritten into a second representation that corresponds to an equivalent query, where rewriting the first representation includes expanding the XPath expression into the plurality of location paths and, based on the certain operator, including a plurality of operators in the second representation, where the plurality of operators include: a first set of operators that is to be performed based on each of the plurality of location paths, and a second set of operators that is to be performed based on data returned from at least one operator included in the first set of operators. The query may thereafter be executed based on the second representation. The second representation may be further rewritten to third representation depending on the physical storage of XML.
摘要翻译：提供了一种处理查询的方法。生成查询的第一个表示形式，其中查询包含一个基于可扩展到多个位置路径的XPath表达式执行的某个运算符。查询的第一表示被重写成对应于等效查询的第二表示，其中重写第一表示包括将XPath表达式扩展到多个位置路径中，并且基于特定运算符，包括多个运算符第二表示，其中所述多个运算符包括：将基于所述多个位置路径中的每一个来执行的第一组运算符，以及将基于从至少一个运算符返回的数据来执行的第二组运算符包含在第一组运算符中。此后可以基于第二表示来执行查询。取决于XML的物理存储，第二表示可以进一步重写为第三表示。

3. 发明授权

US07739219B2 Techniques of optimizing queries using NULL expression analysis 有权
标题翻译：使用NULL表达式分析优化查询的技术
公开(公告)号：US07739219B2
公开(公告)日：2010-06-15
申请号：US11517969
申请日：2006-09-08
申请人： Zhen Hua Liu , Muralidhar Krishnaprasad , Hui Joe Chang , Anand Manikutty , James W. Warner , Vikas Arora , Susan Kotsovolos
发明人： Zhen Hua Liu , Muralidhar Krishnaprasad , Hui Joe Chang , Anand Manikutty , James W. Warner , Vikas Arora , Susan Kotsovolos
IPC分类号： G06F17/30
CPC分类号： G06F17/30454
摘要： A method for optimizing queries is described. A query, which includes a first expression for determining whether each of a set of values evaluates to NULL or NOT NULL, is received. At compile-time, a first representation of the query is generated, where the first representation indicates that the query is to be performed based on the first expression. Based on the first expression, a second expression is determined. The second expression is such that the first expression would evaluate to any NOT NULL value if and only if the second expression would evaluate to any NOT NULL value. The second expression, when evaluated, is much more computationally efficient compared with the evaluation of the first expression. Based on the first representation, a second representation of the query is generated, where the second representation indicates that the query is to be performed based on the second expression. Thereafter, the query is executed based on the second representation.
摘要翻译：描述用于优化查询的方法。一个查询，其中包含一个第一表达式，用于确定一组值中的每一个是否计算为NULL或NOT NULL。在编译时，生成查询的第一个表示，其中第一个表示指示要根据第一个表达式执行查询。基于第一个表达式，确定第二个表达式。第二个表达式使得当且仅当第二个表达式计算为任何NOT NULL值时，第一个表达式将求值为任何NOT NULL值。第二个表达式与评估第一个表达式相比，计算效率要高得多。基于第一表示，生成查询的第二表示，其中第二表示指示将基于第二表达式执行查询。此后，基于第二表示执行查询。

4. 发明申请

US20080065674A1 Techniques of optimizing queries using NULL expression analysis 有权
标题翻译：使用NULL表达式分析优化查询的技术
公开(公告)号：US20080065674A1
公开(公告)日：2008-03-13
申请号：US11517969
申请日：2006-09-08
申请人： Zhen Hua Liu , Muralidhar Krishnaprasad , Hui Joe Chang , Anand Manikutty , James W. Warner , Vikas Arora , Susan Kotsovolos
发明人： Zhen Hua Liu , Muralidhar Krishnaprasad , Hui Joe Chang , Anand Manikutty , James W. Warner , Vikas Arora , Susan Kotsovolos
IPC分类号： G06F17/00
CPC分类号： G06F17/30454
摘要： A method for optimizing queries is described. A query, which includes a first expression for determining whether each of a set of values evaluates to NULL or NOT NULL, is received. At compile-time, a first representation of the query is generated, where the first representation indicates that the query is to be performed based on the first expression. Based on the first expression, a second expression is determined. The second expression is such that the first expression would evaluate to any NOT NULL value if and only if the second expression would evaluate to any NOT NULL value. The second expression, when evaluated, is much more computationally efficient compared with the evaluation of the first expression. Based on the first representation, a second representation of the query is generated, where the second representation indicates that the query is to be performed based on the second expression. Thereafter, the query is executed based on the second representation.
摘要翻译：描述用于优化查询的方法。一个查询，其中包含一个第一表达式，用于确定一组值中的每一个是否计算为NULL或NOT NULL。在编译时，生成查询的第一个表示，其中第一个表示指示要根据第一个表达式执行查询。基于第一个表达式，确定第二个表达式。第二个表达式使得当且仅当第二个表达式计算为任何NOT NULL值时，第一个表达式将求值为任何NOT NULL值。第二个表达式与评估第一个表达式相比，计算效率要高得多。基于第一表示，生成查询的第二表示，其中第二表示指示将基于第二表达式执行查询。此后，基于第二表示执行查询。

5. 发明授权

US09760647B2 Techniques for automatically exposing, as web services, procedures and functions stored in a database 有权
公开(公告)号：US09760647B2
公开(公告)日：2017-09-12
申请号：US11008425
申请日：2004-12-08
申请人： Rohan Angrish , James W. Warner , Zhen Hua Liu , Muralidhar Krishnaprasad , Anand Manikutty , Vikas Arora , Susan M. Kotsovolos
发明人： Rohan Angrish , James W. Warner , Zhen Hua Liu , Muralidhar Krishnaprasad , Anand Manikutty , Vikas Arora , Susan M. Kotsovolos
IPC分类号： G06F7/00 , G06F17/30 , G06F9/54
CPC分类号： G06F17/3089 , G06F9/547
摘要： A database server that manages a database retrieves metadata that is stored, within the database, in association with a procedure that is stored in the database. Based on the metadata, a Web service definition is automatically constructed to describe the procedure as a Web service. The WSDL definition can be referenced to construct SOAP messages with the appropriate arguments and in the appropriate format which, when received, are converted to a suitable format for invoking execution of the procedure by the database server.

6. 发明授权

US07908286B2 Techniques for providing XQuery access using web services 有权
标题翻译：使用Web服务提供XQuery访问的技术
公开(公告)号：US07908286B2
公开(公告)日：2011-03-15
申请号：US11007894
申请日：2004-12-08
申请人： Muralidhar Krishnaprasad , Zhen Hua Liu , Karuna Muthiah , Ying Lu , James W. Warner , Rohan Angrish , Vikas Arora , Anand Manikutty
发明人： Muralidhar Krishnaprasad , Zhen Hua Liu , Karuna Muthiah , Ying Lu , James W. Warner , Rohan Angrish , Vikas Arora , Anand Manikutty
IPC分类号： G06F17/30
CPC分类号： G06F17/30923 , G06F17/30861
摘要： An XQuery access API is described, for providing access to XML data from a data source, using the XQuery language. A requestor can request, from a server, performance of an operation on XML data, wherein request messages and response messages conform to the Simple Object Access Protocol (SOAP). Request and response messages can be transmitted using Hypertext Transfer Protocol (HTTP) or Hypertext Transfer Protocol over Secure Socket Layer (HTTPS). The format of the request and response messages is specified in a definition of a Web service, where the definition conforms to the Web Service Description Language (WSDL).
摘要翻译：描述了一个XQuery访问API，用于使用XQuery语言提供从数据源访问XML数据。请求者可以从服务器请求执行对XML数据的操作，其中请求消息和响应消息符合简单对象访问协议（SOAP）。请求和响应消息可以使用超文本传输协议（HTTP）或超文本传输协议通过安全套接字层（HTTPS）传输。请求和响应消息的格式在Web服务的定义中指定，其中定义符合Web服务描述语言（WSDL）。

7. 发明授权

US07685150B2 Optimization of queries over XML views that are based on union all operators 有权
标题翻译：基于联合所有运算符优化基于XML视图的查询
公开(公告)号：US07685150B2
公开(公告)日：2010-03-23
申请号：US11237286
申请日：2005-09-27
申请人： Anand Manikutty , Muralidhar Krishnaprasad , Zhen Hua Liu , Vikas Arora , James W. Warner , Rohan Angrish , Hui Zhang
发明人： Anand Manikutty , Muralidhar Krishnaprasad , Zhen Hua Liu , Vikas Arora , James W. Warner , Rohan Angrish , Hui Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30935 , Y10S707/99943
摘要： Optimization is provided for database statements involving XML data, e.g., XPath and XQuery, which operate over views that use aggregate set operators, e.g., UNION ALL. As part of a “view merge” stage of query transformation, the query that operates over the view is merged with a query that defines the view. One or more expressions (e.g., operators, predicates, virtual table constructs) from the query that operates over the view are then “pushed down” to operate on the individual underlying XML data constructs. “Branch elimination” is performed based on the structure of the view and the query acting over the view, based on which it is possible to determine whether any of the sub-queries, if executed, would result in the return of zero rows. If so, then such branches are eliminated from the transformed query, leaving a reduced set of data containers on which to execute the query.
摘要翻译：针对涉及XML数据的数据库语句（例如，XPath和XQuery）提供优化，该数据库语句对使用聚合集合运算符（例如UNION ALL）的视图进行操作。作为查询转换的“视图合并”阶段的一部分，通过视图操作的查询与定义视图的查询合并。然后，通过视图操作的查询中的一个或多个表达式（例如，运算符，谓词，虚拟表结构）被“推下”以对各个底层XML数据结构进行操作。基于视图的结构和在视图上执行的查询执行“分支消除”，基于此可以确定是否任何子查询（如果被执行）将导致返回零行。如果是这样，则从转换的查询中消除这样的分支，留下一组减少的数据容器来执行查询。

8. 发明申请

US20110113061A1 TECHNIQUES FOR PROVIDING XQUERY ACCESS USING WEB SERVICES 有权
标题翻译：使用WEB服务提供XQUERY ACCESS的技术
公开(公告)号：US20110113061A1
公开(公告)日：2011-05-12
申请号：US13009712
申请日：2011-01-19
申请人： Muralidhar KRISHNAPRASAD , Zhen Hua Liu , Karuna Muthiah , Ying Lu , James W. Warner , Rohan Angrish , Vikas Arora , Anand Manikutty
发明人： Muralidhar KRISHNAPRASAD , Zhen Hua Liu , Karuna Muthiah , Ying Lu , James W. Warner , Rohan Angrish , Vikas Arora , Anand Manikutty
IPC分类号： G06F17/30
CPC分类号： G06F17/30923 , G06F17/30861
摘要： An XQuery access API is described, for providing access to XML data from a data source, using the XQuery language. A requestor can request, from a server, performance of an operation on XML data, wherein request messages and response messages conform to the Simple Object Access Protocol (SOAP). Request and response messages can be transmitted using Hypertext Transfer Protocol (HTTP) or Hypertext Transfer Protocol over Secure Socket Layer (HTTPS). The format of the request and response messages is specified in a definition of a Web service, where the definition conforms to the Web Service Description Language (WSDL).
摘要翻译：描述了一个XQuery访问API，用于使用XQuery语言提供从数据源访问XML数据。请求者可以从服务器请求执行对XML数据的操作，其中请求消息和响应消息符合简单对象访问协议（SOAP）。请求和响应消息可以使用超文本传输协议（HTTP）或超文本传输协议通过安全套接字层（HTTPS）传输。请求和响应消息的格式在Web服务的定义中指定，其中定义符合Web服务描述语言（WSDL）。

9. 发明授权

US07685137B2 Technique of using XMLType tree as the type infrastructure for XML 有权
标题翻译：使用XMLType树作为XML类型基础设施的技术
公开(公告)号：US07685137B2
公开(公告)日：2010-03-23
申请号：US11044472
申请日：2005-01-26
申请人： Zhen Hua Liu , Muralidhar Krishnaprasad , Vikas Arora , James W. Warner , Anand Manikutty
发明人： Zhen Hua Liu , Muralidhar Krishnaprasad , Vikas Arora , James W. Warner , Anand Manikutty
IPC分类号： G06F7/00
CPC分类号： G06F17/2247
摘要： A universal format is used to create a type representation of XMLType instances that are generated in various ways from various sources. An XMLType Type Tree is represented as a hierarchy of nodes, including leaf item node, composite item node, operator node, aggregate node, referred to herein as an XMLType Type Tree. An XMLType Type Tree serves as a digest of the type structure of XMLType, no matter the source of the XMLType instance or its manner of its generation and it creates one uniform abstraction of the type structure of XMLType for the data-typing analysis of XPath and XQuery during query compile time.
摘要翻译：通用格式用于创建以各种方式生成的XMLType实例的类型表示形式。 XMLType类型树被表示为节点的层次结构，包括叶项目节点，复合项目节点，运营商节点，聚合节点，这里称为XMLType类型树。 XMLType类型树作为XMLType的类型结构的摘要，无论XMLType实例的来源或其生成方式如何，它都会为XPath的数据类型分析创建XMLType类型结构的一个统一抽象，查询编译期间的XQuery。

10. 发明授权

US07523131B2 Techniques for efficiently storing and querying in a relational database, XML documents conforming to schemas that contain cyclic constructs 有权
标题翻译：在关系数据库中高效存储和查询的技术，符合包含循环结构的模式的XML文档
公开(公告)号：US07523131B2
公开(公告)日：2009-04-21
申请号：US11056312
申请日：2005-02-10
申请人： James W. Warner , Abhyudaya Agrawal , Hui Zhang , Muralidhar Krishnaprasad , Ravi Murthy , Zhen Hua Liu , Nipun Agarwal , Vikas Arora , Susan M. Kotsovolos , Anand Manikutty , Rohan Angrish
发明人： James W. Warner , Abhyudaya Agrawal , Hui Zhang , Muralidhar Krishnaprasad , Ravi Murthy , Zhen Hua Liu , Nipun Agarwal , Vikas Arora , Susan M. Kotsovolos , Anand Manikutty , Rohan Angrish
IPC分类号： G06F17/00
CPC分类号： G06F17/30917 , Y10S707/99934 , Y10S707/99943
摘要： To associate XML data objects (“child objects”), stored in rows of relational or object-relational tables, with the appropriate XML data objects (“parent objects”) from which the child objects descend, tables that contain child objects (“out-of-line” tables) are constructed with an additional column. In one embodiment, this column stores values that identify the root objects, in the appropriate table, from which the respective child objects descend. Hence, the root object from which any given object descends is traceable by following the respective value back to the corresponding root object. In one embodiment, this column stores values that identify the complete XML hierarchical path, through multiple tables, back to the root object from which the respective child objects descend. Consequently, XML query language queries against XML documents stored in such tables can be rewritten as SQL queries against the data in the tables, even in the presence of cyclic constructs.
摘要翻译：将存储在关系关系表或对象关系表行中的XML数据对象（“子对象”）与子对象所属的相应XML数据对象（“父对象”）相关联，包含子对象的表（“out” -line“表）用另外的列构造。在一个实施例中，该列存储识别相应子对象下降的适当表中的根对象的值。因此，通过将相应的值追溯到相应的根对象，可以追溯任何给定对象下降的根对象。在一个实施例中，该列将通过多个表标识完整的XML分层路径的值存储回到相应子对象从其下降的根对象。因此，即使在存在循环结构的情况下，存储在这些表中的XML文档的XML查询语言查询可以重写为表中数据的SQL查询。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式