公开(公告)号：US20080098346A1

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

申请号：US11545932

申请日：2006-10-10

Applicant: Rohan Angrish ,  Muralidhar Krishnaprasad

Inventor： Rohan Angrish ,  Muralidhar Krishnaprasad

IPC: G06F9/44

CPC classification number: G06F9/547 ,  G06F9/541

Abstract: Using a WSDL document to exchange an interface definition for back-end business logic includes automatically mapping various elements of the WSDL document to corresponding XQuery elements to generate an XQuery interface definition “skeleton”. From such an XQuery interface skeleton, an XQuery statement can be generated by filling in the body of the function that implements the logic. The XQuery statement serves as an interface definition for an interface to the function. Furthermore, at runtime a Web Service request that is based on the WSDL document can be translated into an XQuery call into an XQuery function that implements the logic defined in the WSDL document. From there, results are obtained from the XQuery function, translated into the appropriate return format defined in the WSDL, and returned.

Abstract translation: 使用WSDL文档交换后端业务逻辑的接口定义包括将WSDL文档的各种元素自动映射到相应的XQuery元素，以生成XQuery接口定义“骨架”。 通过这样的XQuery接口框架，可以通过填充实现逻辑的函数体来生成XQuery语句。 XQuery语句用作函数接口的接口定义。 此外，在运行时，基于WSDL文档的Web服务请求可以转换为XQuery调用，以实现实现WSDL文档中定义的逻辑的XQuery函数。 从那里，结果从XQuery函数获得，转换为在WSDL中定义的适当的返回格式，并返回。

公开(公告)号：US20060179068A1

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

申请号：US11056312

申请日：2005-02-10

Applicant: James Warner ,  Abhyudaya Agrawal ,  Hui Zhang ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Zhen Liu ,  Nipun Agarwal ,  Vikas Arora ,  Susan Kotsovolos ,  Anand Manikutty ,  Rohan Angrish

Inventor： James Warner ,  Abhyudaya Agrawal ,  Hui Zhang ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Zhen Liu ,  Nipun Agarwal ,  Vikas Arora ,  Susan Kotsovolos ,  Anand Manikutty ,  Rohan Angrish

IPC: G06F7/00

CPC classification number: G06F17/30917 ,  Y10S707/99934 ,  Y10S707/99943

Abstract: 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.

公开(公告)号：US20050065949A1

公开(公告)日：2005-03-24

申请号：US10984471

申请日：2004-11-08

Applicant: James Warner ,  Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  Rohan Angrish ,  Vikas Arora ,  Susan Kotsovolos

Inventor： James Warner ,  Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  Rohan Angrish ,  Vikas Arora ,  Susan Kotsovolos

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30917 ,  G06F17/30448 ,  G06F17/30938 ,  Y10S707/99943

Abstract: Techniques are described for executing queries that have XPath sections that specify unmappable paths. The techniques involve splitting the unmappable paths into (1) a mappable path fragment, and (2) an unmappable path fragment. After an unmappable path has been split into a mappable path fragment and an unmappable path fragment, the XPath section is replaced with a replacement XPath section. The replacement XPath section specifies two operations: a “mappable operation” that is based on the mappable path fragment, and an “unmappable operation” that is based on the unmappable path fragment. The portion of the replacement XPath section that specifies the mappable operation is rewritten to access underlying relational structures. Consequently, when the rewritten query is executed, a smaller amount of XML data needs to be materialized to evaluate the unmappable path fragment than would otherwise have been required to evaluate the original unmappable path.

Abstract translation: 描述了执行具有指定不可映射路径的XPath节的查询的技术。 这些技术涉及将不可映射的路径分解为（1）可映射路径片段，以及（2）不可映射的路径片段。 将不可映射路径分解为可映射路径片段和不可映射路径片段后，XPath节将替换为替换的XPath节。 替换XPath部分指定两个操作：基于可映射路径片段的“可映射操作”和基于不可映射路径片段的“不可映映操作”。 替换XPath部分指定可映射操作的部分被重写为访问基础关系结构。 因此，当执行重写的查询时，需要实现较少量的XML数据来评估不可映射的路径片段，而不是否则需要评估原始的不可映射路径。

公开(公告)号：US09330149B2

公开(公告)日：2016-05-03

申请号：US11959398

申请日：2007-12-18

Applicant: Rohan Angrish ,  James W. Warner ,  Zhen Hua Liu

Inventor： Rohan Angrish ,  James W. Warner ,  Zhen Hua Liu

IPC: G06F17/30

CPC classification number: G06F17/30569 ,  G06F17/30914

Abstract: In one embodiment, a database server receives a request from a spreadsheet application to open a file with spreadsheet data. The spreadsheet data is stored in one or more relational tables in one or more relational databases that are managed by the database server. In response to the request, the database server generates the file, where generating the file comprises retrieving the spreadsheet data from an XML view that is defined by an XQuery query. When executed, the XQuery query returns the spreadsheet data in an XML spreadsheet format that is understood by the spreadsheet application. The database server provides the generated file with the spreadsheet data directly to the spreadsheet application, where the spreadsheet data as retrieved from the XML view is formatted according to the XML spreadsheet format.

Abstract translation: 在一个实施例中，数据库服务器从电子表格应用程序接收请求以使用电子表格数据打开文件。 电子表格数据存储在由数据库服务器管理的一个或多个关系数据库中的一个或多个关系表中。 响应于该请求，数据库服务器生成文件，其中生成文件包括从由XQuery查询定义的XML视图检索电子表格数据。 执行时，XQuery查询将以电子表格应用程序所理解的XML电子表格格式返回电子表格数据。 数据库服务器将生成的文件直接提供给电子表格应用程序，其中根据XML电子表格格式格式化从XML视图检索的电子表格数据。

公开(公告)号：US20090158251A1

公开(公告)日：2009-06-18

申请号：US11959398

申请日：2007-12-18

Applicant: Rohan Angrish ,  James W. Warner ,  Zhen Hua Liu

Inventor： Rohan Angrish ,  James W. Warner ,  Zhen Hua Liu

IPC: G06F9/44 ,  G06F7/00

CPC classification number: G06F17/30569 ,  G06F17/30914

Abstract: In one embodiment, a database server receives a request from a spreadsheet application to open a file with spreadsheet data. The spreadsheet data is stored in one or more relational tables in one or more relational databases that are managed by the database server. In response to the request, the database server generates the file, where generating the file comprises retrieving the spreadsheet data from an XML view that is defined by an XQuery query. When executed, the XQuery query returns the spreadsheet data in an XML spreadsheet format that is understood by the spreadsheet application. The database server provides the generated file with the spreadsheet data directly to the spreadsheet application, where the spreadsheet data as retrieved from the XML view is formatted according to the XML spreadsheet format.

Abstract translation: 在一个实施例中，数据库服务器从电子表格应用程序接收请求以使用电子表格数据打开文件。 电子表格数据存储在由数据库服务器管理的一个或多个关系数据库中的一个或多个关系表中。 响应于该请求，数据库服务器生成文件，其中生成文件包括从由XQuery查询定义的XML视图检索电子表格数据。 执行时，XQuery查询以电子表格应用程序所理解的XML电子表格格式返回电子表格数据。 数据库服务器将生成的文件直接提供给电子表格应用程序，其中根据XML电子表格格式格式化从XML视图检索的电子表格数据。

公开(公告)号：US07305414B2

公开(公告)日：2007-12-04

申请号：US11099918

申请日：2005-04-05

Applicant: Anand Manikutty ,  Muralidhar Krishnaprasad ,  Zhen Hua Liu ,  James Warner ,  Rohan Angrish ,  Vikas Arora ,  Susan Kotsovolos ,  Ravi Murthy ,  Wesley Lin

Inventor： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Zhen Hua Liu ,  James Warner ,  Rohan Angrish ,  Vikas Arora ,  Susan Kotsovolos ,  Ravi Murthy ,  Wesley Lin

IPC: G06F17/30

CPC classification number: G06F17/30938 ,  Y10S707/99943

Abstract: A method and apparatus for rewriting a database command containing an embedded XML expression such that the rewritten database command recites a text function, in lieu of the embedded XML expression, is provided. Advantageously, a DBMS may take advantage of the efficiencies in storing XML data within the database, while avoiding the generation of unnecessary XML elements in processing the query when the XML elements contribute nothing to the outcome of the query. Cost-base or rule-based analysis may be performed to determine how to rewrite a received database command. The database server may functionally evaluate the text function or may use an index defined on a column of the database. The text function may function as a primary filter or may reference a column upon which an index is defined, wherein the index operates at the same or higher level than a column being referenced in the embedded XML expression.

Abstract translation: 提供一种用于重写包含嵌入式XML表达式的数据库命令的方法和装置，使得重写的数据库命令背景文本功能代替嵌入的XML表达。 有利地，DBMS可以利用在数据库中存储XML数据的效率，同时避免在XML元素对查询的结果没有贡献时在处理查询时生成不必要的XML元素。 可以执行基于成本或基于规则的分析来确定如何重写接收到的数据库命令。 数据库服务器可以在功能上评估文本功能，或者可以使用在数据库的列上定义的索引。 文本函数可以用作主过滤器，或者可以引用定义索引的列，其中索引在与嵌入式XML表达式中引用的列相同或更高的级别上操作。

公开(公告)号：US20060235840A1

公开(公告)日：2006-10-19

申请号：US11237286

申请日：2005-09-27

Applicant: Anand Manikutty ,  Muralidhar Krishnaprasad ,  Zhen Liu ,  Vikas Arora ,  James Warner ,  Rohan Angrish ,  Hui Zhang

Inventor： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Zhen Liu ,  Vikas Arora ,  James Warner ,  Rohan Angrish ,  Hui Zhang

IPC: G06F17/30

CPC classification number: G06F17/30935 ,  Y10S707/99943

Abstract: 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.

Abstract translation: 针对涉及XML数据的数据库语句（例如，XPath和XQuery）提供优化，该数据库语句对使用聚合集合运算符（例如UNION ALL）的视图进行操作。 作为查询转换的“视图合并”阶段的一部分，通过视图操作的查询与定义视图的查询合并。 然后，通过视图操作的查询中的一个或多个表达式（例如，运算符，谓词，虚拟表结构）被“推下”以对各个底层XML数据结构进行操作。 基于视图的结构和在视图上执行的查询执行“分支消除”，基于此可以确定是否任何子查询（如果被执行）将导致返回零行。 如果是这样，则从转换的查询中消除这样的分支，留下一组减少的数据容器来执行查询。

公开(公告)号：US20060122982A1

公开(公告)日：2006-06-08

申请号：US11007894

申请日：2004-12-08

Applicant: Muralidhar Krishnaprasad ,  Zhen Liu ,  Karuna Muthiah ,  Ying Lu ,  James Warner ,  Rohan Angrish ,  Vikas Arora ,  Anand Manikutty

Inventor： Muralidhar Krishnaprasad ,  Zhen Liu ,  Karuna Muthiah ,  Ying Lu ,  James Warner ,  Rohan Angrish ,  Vikas Arora ,  Anand Manikutty

IPC: G06F17/30

CPC classification number: G06F17/30923 ,  G06F17/30861

Abstract: 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).