公开(公告)号：US07499909B2

公开(公告)日：2009-03-03

申请号：US11481159

申请日：2006-07-03

申请人： Zhen Hua Liu ,  Muralidhar Krishnaprasad

发明人： Zhen Hua Liu ,  Muralidhar Krishnaprasad

IPC分类号： G06F17/30

CPC分类号： G06F17/30917 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99945

摘要： A method and apparatus for processing queries is provided. A query is received at a mid-tier node of a multi-tier system. The mid-tier node includes a mid-tier cache that is configured to cache relational tables from one or more databases managed by a database server in a database tier of the multi-tier system. At the mid-tier node, a determination is made whether the received query includes an operator for requesting data of an XML datatype from the database server, where the XML datatype is supported as a native datatype by the database server. If a determination is made that the query includes such operator, then one or more portions of one or more relational tables are retrieved from the database server and stored in the mid-tier cache. The one or more relational tables store, in the one or more portions, index information associated with the requested data of the XML datatype. The received query is rewritten into a relational query against at least the one or more portions of the one or more relational tables that are stored in the mid-tier cache.

摘要翻译： 提供了一种用于处理查询的方法和装置。 在多层系统的中间层节点处接收到查询。 中间层节点包括中间层缓存，其被配置为从多层系统的数据库层中的数据库服务器管理的一个或多个数据库缓存关系表。 在中间层节点，确定接收到的查询是否包括用于从数据库服务器请求数据类型的数据的操作员，其中数据库服务器将XML数据类型支持为本机数据类型。 如果确定查询包括这样的运算符，则从数据库服务器检索一个或多个关系表的一个或多个部分，并存储在中间层缓存中。 所述一个或多个关系表在一个或多个部分中存储与所述XML数据类型的所请求的数据相关联的索引信息。 所接收的查询根据至少存储在中间层高速缓存中的一个或多个关系表的一个或多个部分重写到关系查询中。

公开(公告)号：US20080098346A1

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

申请号：US11545932

申请日：2006-10-10

申请人： Rohan Angrish ,  Muralidhar Krishnaprasad

发明人： Rohan Angrish ,  Muralidhar Krishnaprasad

IPC分类号： G06F9/44

CPC分类号： G06F9/547 ,  G06F9/541

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

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

公开(公告)号：US20080040369A1

公开(公告)日：2008-02-14

申请号：US11502247

申请日：2006-08-09

申请人： James W. Warner ,  Zhen Hua Liu ,  Sundeep Abraham ,  Muralidhar Krishnaprasad ,  Geeta Arora ,  Ravi Murthy ,  Nimar Arora ,  Edwina Lu

发明人： James W. Warner ,  Zhen Hua Liu ,  Sundeep Abraham ,  Muralidhar Krishnaprasad ,  Geeta Arora ,  Ravi Murthy ,  Nimar Arora ,  Edwina Lu

IPC分类号： G06F7/00

CPC分类号： G06F17/30569

摘要： Instances of complex types are logically replicated. In general, the logical replication of complex types involves converting a complex type instance from its storage format into a logical representation written in a markup language, like XML. The logical representation is then propagated to a destination (or destinations), which converts the logical representation to a storage format used at the destination for that complex type.

摘要翻译： 复杂类型的实例在逻辑上被复制。 一般来说，复杂类型的逻辑复制涉及将复杂类型实例从其存储格式转换为以标记语言（如XML）编写的逻辑表示。 然后，逻辑表示被传播到目的地（或目的地），其将逻辑表示转换为用于该复合类型的目的地的存储格式。

公开(公告)号：US20080005093A1

公开(公告)日：2008-01-03

申请号：US11481159

申请日：2006-07-03

申请人： Zhen Hua Liu ,  Muralidhar Krishnaprasad

发明人： Zhen Hua Liu ,  Muralidhar Krishnaprasad

IPC分类号： G06F17/30

CPC分类号： G06F17/30917 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99945

摘要： A method and apparatus for processing queries is provided. A query is received at a mid-tier node of a multi-tier system. The mid-tier node includes a mid-tier cache that is configured to cache relational tables from one or more databases managed by a database server in a database tier of the multi-tier system. At the mid-tier node, a determination is made whether the received query includes an operator for requesting data of an XML datatype from the database server, where the XML datatype is supported as a native datatype by the database server. If a determination is made that the query includes such operator, then one or more portions of one or more relational tables are retrieved from the database server and stored in the mid-tier cache. The one or more relational tables store, in the one or more portions, index information associated with the requested data of the XML datatype. The received query is rewritten into a relational query against at least the one or more portions of the one or more relational tables that are stored in the mid-tier cache.

摘要翻译： 提供了一种用于处理查询的方法和装置。 在多层系统的中间层节点处接收到查询。 中间层节点包括中间层缓存，其被配置为从多层系统的数据库层中的数据库服务器管理的一个或多个数据库缓存关系表。 在中间层节点，确定接收到的查询是否包括用于从数据库服务器请求数据类型的数据的操作员，其中数据库服务器将XML数据类型支持为本机数据类型。 如果确定查询包括这样的运算符，则从数据库服务器检索一个或多个关系表的一个或多个部分，并存储在中间层缓存中。 所述一个或多个关系表在一个或多个部分中存储与所述XML数据类型的所请求的数据相关联的索引信息。 所接收的查询根据存储在中间层高速缓存中的至少一个或多个关系表的一个或多个部分重写到关系查询中。

公开(公告)号：US20060242563A1

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

申请号：US11261684

申请日：2005-10-28

申请人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anguel Novoselsky

发明人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anguel Novoselsky

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

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

摘要： Transformation of a set of XML documents via an XSLT stylesheet is made more efficient by rewriting the stylesheet at compile-time, based on the structural description of the set of XML documents, into an optimized stylesheet containing fewer dynamic template-matching calls than the original stylesheet. This rewritten stylesheet can be further rewritten into a set of XQuery expressions. At compile-time, the particular transformation templates that are appropriate for transforming the particular nodes contained in the set of XML documents are determined, and XSLT calls to the templates are converted to calls to corresponding XQuery user-defined functions. Determination of the appropriate transformation templates may be based on the structural description of the input set of XML documents, such as an XML Schema or Document Type Definition. The data from each template is translated into corresponding XQuery constructors, instructions from the template are translated into XQuery expressions, and the XQuery functions are inlined if possible.

摘要翻译： 通过XSLT样式表转换一组XML文档通过将编译时的样式表（基于XML文档集的结构描述）重写为优化样式表，使其具有比原始文本更少的动态模板匹配调用 样式表。 这个重写的样式表可以进一步重写成一组XQuery表达式。 在编译时，确定适合于转换XML文档集中的特定节点的特定转换模板，并将XSLT对模板的调用转换为对相应XQuery用户定义函数的调用。 确定适当的转换模板可以基于XML文档的输入集合的结构描述，例如XML模式或文档类型定义。 来自每个模板的数据被转换为相应的XQuery构造函数，模板中的指令将被转换为XQuery表达式，如果可能的话XQuery函数是内联的。

公开(公告)号：US20060179068A1

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

申请号：US11056312

申请日：2005-02-10

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

发明人： 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分类号： 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.

公开(公告)号：US20060036935A1

公开(公告)日：2006-02-16

申请号：US11246429

申请日：2005-10-06

申请人： James Warner ,  Zhen Liu ,  Muralidhar Krishnaprasad

发明人： James Warner ,  Zhen Liu ,  Muralidhar Krishnaprasad

IPC分类号： G06F17/21

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

摘要： A method for representing XML information is provided. A serialized image of XML information is generated. The serialized image comprises a collection of one or more serialized data values, where each particular serialized data value in the collection includes data associated with a particular serialized data value type of a plurality of serialized data value types. The serialized image may also comprise a first field that includes a first value, which indicates that the serialized image includes the collection of one or more serialized data values. In some embodiments, the method is performed at a database system that supports a native XML data type, wherein the XML information is one or more instances of the native XML data type.

摘要翻译： 提供了一种表示XML信息的方法。 生成XML信息的序列化图像。 序列化图像包括一个或多个序列化数据值的集合，其中集合中的每个特定序列化数据值包括与多个序列化数据值类型的特定序列化数据值类型相关联的数据。 序列化图像还可以包括第一字段，其包括第一值，其指示序列化图像包括一个或多个序列化数据值的集合。 在一些实施例中，该方法在支持本机XML数据类型的数据库系统上执行，其中该XML信息是本机XML数据类型的一个或多个实例。

公开(公告)号：US20050065949A1

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

申请号：US10984471

申请日：2004-11-08

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

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

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

CPC分类号： G06F17/30917 ,  G06F17/30448 ,  G06F17/30938 ,  Y10S707/99943

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

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

公开(公告)号：US06564203B1

公开(公告)日：2003-05-13

申请号：US09513724

申请日：2000-02-24

申请人： Muralidhar Krishnaprasad ,  Vishwanathan Krishnamurthy

发明人： Muralidhar Krishnaprasad ,  Vishwanathan Krishnamurthy

IPC分类号： G06F1730

CPC分类号： G06F17/3051 ,  G06F17/30345 ,  G06F17/30418 ,  G06F17/30451 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99942 ,  Y10S707/99943

摘要： Techniques are provided for updating data that logically resides in one or more nested collections in a nested collection column of a view. According to one technique, a Data Manipulation Language (DML) statement that operates on individual elements within the one or more nested collections is detected. Instead of executing the DML statement, trigger code is executed once for each individual element, within the one or more nested collections, that is targeted by the DML statement. In addition, the trigger code may include one or more references to parent values. For each nested collection selected by the DML statement, the following steps are performed when the trigger code includes references to parent values: determining the row, within the view, in which the nested collection resides and, prior to executing the trigger code for the nested collection, binding the one or more references to one or more corresponding values that logically reside in the row.

摘要翻译： 提供了技术来更新逻辑上驻留在视图的嵌套集合列中的一个或多个嵌套集合中的数据。 根据一种技术，检测对一个或多个嵌套集合内的各个元素进行操作的数据操作语言（DMM）语句。 对于DML语句定位的一个或多个嵌套集合中的每个单独元素，执行一次触发代码而不是执行DML语句。 此外，触发代码可以包括对父值的一个或多个引用。 对于由DML语句选择的每个嵌套集合，当触发器代码包含对父值的引用时，将执行以下步骤：确定嵌套集合所在的视图内的行，并且在执行嵌套的触发器代码之前 集合，将一个或多个引用绑定到逻辑上位于行中的一个或多个对应值。

公开(公告)号：US09015303B2

公开(公告)日：2015-04-21

申请号：US13230823

申请日：2011-09-12

申请人： Jayteerth Katti ,  Kartik Paramasivam ,  Stuart John Langley ,  Pramod Gurunath ,  Muralidhar Krishnaprasad ,  Elvin Morales ,  Manu Srivastava

发明人： Jayteerth Katti ,  Kartik Paramasivam ,  Stuart John Langley ,  Pramod Gurunath ,  Muralidhar Krishnaprasad ,  Elvin Morales ,  Manu Srivastava

IPC分类号： G06F15/173 ,  H04L12/58

CPC分类号： H04L51/26 ,  H04L51/30

摘要： Network and storage calls are reduced by batching messages. Messages are collected from a client and sent to the gateway or backend application in one round trip. Alternatively, the messages are collected for different entities, and the batched messages are durably stored. Related messages, which may have the same sessionID, are grouped into a logical unit or session. This session may be locked to a single message consumer. A session may be associated with an application processing state as an atomic unit of work while other operations are performed on the messages in the session. Acknowledgements are accumulated by a broker on a message server, but the messages are not immediately deleted. Instead, multiple messages in a selected range are periodically truncated from a message store in a single operation. Expired messages for active sessions are proactive cleaned up to prevent sessions from reaching a quota or limit.

摘要翻译： 通过批量消息来减少网络和存储呼叫。 消息从客户端收集，并一次性发送到网关或后端应用程序。 或者，为不同的实体收集消息，并且批量消息被持久地存储。 可能具有相同sessionID的相关消息被分组为逻辑单元或会话。 此会话可能被锁定到单个消息消费者。 会话可以与作为原子工作单元的应用处理状态相关联，而对会话中的消息执行其他操作。 致谢由消息服务器上的代理商累积，但消息不会立即被删除。 相反，在单个操作中，从消息存储区定期地截断所选范围内的多个消息。 活跃会话的过期消息被主动清理，以防止会话达到配额或限制。