公开(公告)号：US20050091256A1

公开(公告)日：2005-04-28

申请号：US10693302

申请日：2003-10-24

申请人： Balaji Rathakrishnan ,  Stefano Stefani ,  Aleksandras Surna ,  Jose Blakeley ,  Oliver Seeliger

发明人： Balaji Rathakrishnan ,  Stefano Stefani ,  Aleksandras Surna ,  Jose Blakeley ,  Oliver Seeliger

IPC分类号： G06F20060101 ,  G06F1/00 ,  G06F17/00

CPC分类号： G06F17/30365 ,  G06F17/30342 ,  G06F17/30607 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99944

摘要： A technique for updating collection-valued and other complex structured columns in a nested table using a nested extension of an UPDATE statement that uses syntax and semantics to modify collection-valued columns in a way that is analogous to the syntax and semantics of the UPDATE statement that is used to modify scalar-valued columns of the table (called the outer UPDATE). Using the same syntactic and semantic constructs as the table at the outer level allows an existing implementation that processes modifications to relational tables to reuse its implementation techniques for processing outer updates to modify collection-valued columns as well. The UPDATE extensions enable the specification of updates to nested collections embedded at arbitrary levels of depth in the object model. The new syntax is embedded inside the outer UPDATE statement in a way that parallels the structure of the data itself and thus maps more directly to the user's conceptual model of the data. The method for implementing the UPDATE extensions uses a change descriptor, which is a data structure that aggregates substantially all changes, both scalar and collection-valued into a single value that can be applied to the changed collection-valued column. This technique can also be used for modifications to other kinds of complex-structured columns such as objects or xml. The change descriptor includes hierarchical information for the cell, thereby enabling efficient application of multiple updates at various granularity levels in a single operation and enabling the implementation of efficient index maintenance algorithms by updating only the indexes affected by the UPDATE operation and updating only those index rows that were affected by the UPDATE operation.

摘要翻译： 一种用于使用UPDATE语句的嵌套扩展来更新嵌套表中的集合值和其他复杂结构化列的技术，该语法使用语法和语义来以类似于UPDATE语句的语法和语义的方式修改集合值列 用于修改表的标量值列（称为外部UPDATE）。 使用与外层相同的句法和语义结构允许处理对关系表的修改的现有实现，以重用其实现技术来处理外部更新以修改集合值列。 UPDATE扩展使得能够对对象模型中嵌套在任意深度深度的嵌套集合进行更新。 新的语法以外部UPDATE语句的方式嵌入到数据本身的结构中，从而更直接地映射到用户的数据概念模型。 实现UPDATE扩展的方法使用一个更改描述符，该描述符是一个数据结构，它将基本上所有的变量（标量和收集值）聚合成一个可以应用到更改的收集值列的值。 此技术也可用于修改其他类型的复杂结构列（如对象或xml）。 更改描述符包括小区的分层信息，从而能够在单个操作中在各种粒度级别高效地应用多个更新，并且通过仅更新受UPDATE操作影响的索引并仅更新那些索引行，从而实现高效的索引维护算法 受UPDATE操作的影响。

公开(公告)号：US20060235834A1

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

申请号：US11105878

申请日：2005-04-14

申请人： Jose Blakeley ,  Evgueni Zabokritski ,  Conor Cunningham ,  Balaji Rathakrishnan

发明人： Jose Blakeley ,  Evgueni Zabokritski ,  Conor Cunningham ,  Balaji Rathakrishnan

IPC分类号： G06F17/30

CPC分类号： G06F16/24544

摘要： Systems and methods for extension of a query language for defining a simple formulation of joins by capturing the semantics of an existing linkage between a plurality of tables, via employing a reference join. Such reference join enables a compiler to exploit existing relationships in a data base, and employ existing knowledge about referential constraints for an unambiguous transformation of the reference join expression into the equivalent INNER JOIN on the columns involved. Accordingly, a simpler query syntax and semantics can be provided to express multi-table join navigation over primary key/foreign key relations, for example.

摘要翻译： 用于扩展查询语言的系统和方法，用于通过采用参考连接捕获多个表之间的现有链接的语义来定义联接的简单公式。 这种引用连接使得编译器能够利用数据库中的现有关系，并且使用关于引用约束的现有知识来将引用连接表达式的明确变换引入相关列中的等效INNER JOIN。 因此，可以提供更简单的查询语法和语义来表示例如主键/外键关系的多表连接导航。