公开(公告)号：US07386567B2

公开(公告)日：2008-06-10

申请号：US10956300

申请日：2004-09-30

Applicant: Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Visar Nimani ,  James Warner ,  Eric Sedlar ,  Neema Jalali ,  Bhushan Khaladkar

Inventor： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Visar Nimani ,  James Warner ,  Eric Sedlar ,  Neema Jalali ,  Bhushan Khaladkar

IPC: G06F17/30

CPC classification number: G06F17/3061 ,  G06F17/30923 ,  Y10S707/99943

Abstract: Techniques are provided for changing data for an XML construct in an SQL/XML compliant database management system (DBMS). The DBMS allows instances of XML type to represent XML constructs, such as XML documents, XML elements, XML attributes, and fragments of XML documents. An SQL statement is received that includes an XML operator that operates on a particular component in an instance of XML type. During execution of the SQL statement, the XML operator is evaluated by modifying content for the component without modifying the entire instance. For example, an XML delete operator deletes the particular component from the instance. Other XML operators include an insert operator, an insert-before operator, an append-child operator, and an update operator. During execution, these operators may be rewritten to operate on existing SQL constructs, or evaluated by updating only some of the existing SQL constructs, or both.

Abstract translation: 提供技术用于在符合SQL / XML的数据库管理系统（DBMS）中更改XML构造的数据。 DBMS允许XML类型的实例表示XML构造，例如XML文档，XML元素，XML属性和XML文档片段。 收到一条SQL语句，其中包含一个在XML类型的实例中对特定组件进行操作的XML运算符。 在执行SQL语句期间，通过修改组件的内容而不修改整个实例来评估XML运算符。 例如，XML删除运算符从实例中删除特定组件。 其他XML运算符包括一个插入运算符，一个insert-before运算符，一个append-child运算符和一个update运算符。 在执行期间，这些运算符可能被重写为对现有的SQL结构进行操作，或者只通过更新现有的SQL结构或两者来评估。

公开(公告)号：US20060224627A1

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

申请号：US11099918

申请日：2005-04-05

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

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

IPC: G06F17/00

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表达式中引用的列相同或更高的级别上操作。

公开(公告)号：US20050044113A1

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

申请号：US10956300

申请日：2004-09-30

Applicant: Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Visar Nimani ,  James Warner ,  Eric Sedlar ,  Neema Jalali ,  Bhushan Khaladkar

Inventor： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Visar Nimani ,  James Warner ,  Eric Sedlar ,  Neema Jalali ,  Bhushan Khaladkar

IPC: G06F17/30 ,  G06F17/00

CPC classification number: G06F17/3061 ,  G06F17/30923 ,  Y10S707/99943

Abstract: Techniques are provided for changing data for an XML construct in an SQL/XML compliant database management system (DBMS). The DBMS allows instances of XML type to represent XML constructs, such as XML documents, XML elements, XML attributes, and fragments of XML documents. An SQL statement is received that includes an XML operator that operates on a particular component in an instance of XML type. During execution of the SQL statement, the XML operator is evaluated by modifying content for the component without modifying the entire instance. For example, an XML delete operator deletes the particular component from the instance. Other XML operators include an insert operator, an insert-before operator, an append-child operator, and an update operator. During execution, these operators may be rewritten to operate on existing SQL constructs, or evaluated by updating only some of the existing SQL constructs, or both.

Abstract translation: 提供技术用于在符合SQL / XML的数据库管理系统（DBMS）中更改XML构造的数据。 DBMS允许XML类型的实例表示XML构造，例如XML文档，XML元素，XML属性和XML文档片段。 收到一条SQL语句，其中包含一个在XML类型的实例中对特定组件进行操作的XML运算符。 在执行SQL语句期间，通过修改组件的内容而不修改整个实例来评估XML运算符。 例如，XML删除运算符从实例中删除特定组件。 其他XML运算符包括一个插入运算符，一个insert-before运算符，一个append-child运算符和一个update运算符。 在执行期间，这些运算符可能被重写为对现有的SQL结构进行操作，或者只通过更新现有的SQL结构或两者来评估。

公开(公告)号：USD419061S

公开(公告)日：2000-01-18

申请号：US102262

申请日：1999-03-19

Applicant: Robert Croft ,  James Warner ,  Robert Boyce ,  Neil Enciso

Designer： Robert Croft ,  James Warner ,  Robert Boyce ,  Neil Enciso

公开(公告)号：USD404651S

公开(公告)日：1999-01-26

申请号：US80949

申请日：1997-12-22

Applicant: James Warner ,  Insun Yun

Designer： James Warner ,  Insun Yun

公开(公告)号：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.

公开(公告)号：US20060036935A1

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

申请号：US11246429

申请日：2005-10-06

Applicant: James Warner ,  Zhen Liu ,  Muralidhar Krishnaprasad

Inventor： James Warner ,  Zhen Liu ,  Muralidhar Krishnaprasad

IPC: G06F17/21

CPC classification number: G06F17/30917 ,  G06F17/30932

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

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

公开(公告)号：US20050189308A1

公开(公告)日：2005-09-01

申请号：US11065506

申请日：2005-02-24

Applicant: James Warner ,  Frank Kostelnik ,  Frank Thomson

Inventor： James Warner ,  Frank Kostelnik ,  Frank Thomson

IPC: A47F5/08 ,  B42F1/00

CPC classification number: A47F5/0823

Abstract: A bin support bracket apparatus is provided for mounting in holes in a peg board and includes a pair of support rods, wherein each support rod includes top hole-engaging means and a bracket-supporting portion which extends downward from the top hole-engaging means. In addition, a bin-support bracket is connected between the support rods. Preferably, the bin-support bracket also includes a forwardly and upwardly projecting bin-support flange portion. One or more storage bins are supported by the bin-support bracket. Each storage bin includes a lip which engages the bin-support flange portion for supporting the storage bin on the bin-support bracket. In addition, the bin-support bracket includes a forwardly and downwardly projecting bin-levelling flange portion which keeps a supported storage bin in a vertical orientation.

Abstract translation: 提供了一种用于安装在钉板中的孔中的托架托架装置，并且包括一对支撑杆，其中每个支撑杆包括顶孔接合装置和从顶孔接合装置向下延伸的支架支撑部分。 另外，在支撑杆之间连接有箱支撑支架。 优选地，料仓支撑托架还包括向前和向上突出的料仓支撑凸缘部分。 一个或多个存储箱由支架支架支撑。 每个存储箱包括唇缘，该唇缘接合箱支撑凸缘部分，用于支撑箱支撑托架上的存储箱。 此外，货箱支撑支架包括向前和向下突出的料斗平整法兰部分，其将支撑的仓库保持在垂直取向。

公开(公告)号：US20050138047A1

公开(公告)日：2005-06-23

申请号：US10810152

申请日：2004-03-26

Applicant: Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  Ravi Murthy ,  James Warner ,  Thomas Chang ,  Vikas Arora ,  Susan Kotsovolos

Inventor： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  Ravi Murthy ,  James Warner ,  Thomas Chang ,  Vikas Arora ,  Susan Kotsovolos

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/3092

Abstract: Techniques for managing XML data associated with multiple execution units ensure that execution units are able to use XML data coming from other execution units. Such techniques are applicable when, but for the technique, an XML type value is produced in a particular form by one execution unit and is supposed to be consumed by another execution unit that is unable to process data in the particular form, and involves detecting that the foregoing situation exists and annotating information sent to an XML producer execution unit to cause the XML type value to be transformed into a canonical form that can be shared by all relevant execution units.

Abstract translation: 管理与多个执行单元相关联的XML数据的技术确保执行单元能够使用来自其他执行单元的XML数据。 这种技术适用于但是对于技术而言，XML类型值由一个执行单元以特定形式产生并且被假定由不能处理特定形式的数据的另一执行单元消耗，并且涉及检测该 存在上述情况并且向XML生成器执行单元注释信息，以使XML类型值被转换成可由所有相关执行单元共享的规范形式。

公开(公告)号：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数据来评估不可映射的路径片段，而不是否则需要评估原始的不可映射路径。