公开(公告)号：EP2132668A4

公开(公告)日：2011-03-02

申请号：EP08730424

申请日：2008-02-21

申请人： MICROSOFT CORP

发明人： BARYSHNIKOV BORIS ,  SURNA ALEKSANDRAS ,  CHOE IN-JERNG ,  VERBITSKI ALEXANDRE ,  RAJAMANI RAVISHANKAR

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

CPC分类号： G06F9/5027 ,  G06F17/30286 ,  G06F2209/5011

公开(公告)号：EP1597655A4

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

申请号：EP04779537

申请日：2004-07-29

申请人： MICROSOFT CORP

发明人： RATHAKRISHNAN BALAJI ,  STEFANI STEFANO ,  BLAKELEY JOSE A ,  SEELIGER OLIVER NICHOLAS ,  SURNA ALEKSANDRAS

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

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 (see figure 6) 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-value that can be applied to the changed collection-valued column. The change descriptor includes hierarchical information for the cell, thereby enabling efficient application of multiple updates at various granularity levels.

公开(公告)号：EP1616278A4

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

申请号：EP04779504

申请日：2004-07-29

申请人： MICROSOFT CORP

发明人： ASHWIN SHRINIVAS ,  BLAKELY JOSE A ,  CARLIN PETER ,  FANG JUN ,  KALHAN AJAY ,  KLEINERMAN CHRISTIAN ,  STEFANI STEFANO ,  SURNA ALEKSANDRAS ,  ZHANG HONGGANG

IPC分类号： G06F17/30

CPC分类号： G06F17/30504 ,  Y10S707/99931 ,  Y10S707/99936 ,  Y10S707/99943

摘要： Various embodiments of the present invention are direct to the utilization of Blob Handles (BHs) which are an internal representation of a large value. BHs are immutable and stateless references to a large data object. The structure of a BH contains enough information to return an ILockBytes interface in order to provide access to the corresponding large data block, and a BH can also return information regarding its own lifetime description. A BH can be completely described using (a) a pointer to the beginning of BH data and (b) the byte-length of the BH.

公开(公告)号：EP1604261A4

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

申请号：EP04779707

申请日：2004-07-29

申请人： MICROSOFT CORP

发明人： CUNNINGHAM CONOR J ,  VENKATESH RAMACHANDRAN ,  HANSON ERIC N ,  RATHAKRISHAN BALAJI ,  STEFANI STEFANO ,  SURNA ALEKSANDRAS ,  BLAKELEY JOSE A ,  SEELIGER OLIVER NICHOLAS

IPC分类号： G06F17/30

CPC分类号： G06F17/30327 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99936 ,  Y10S707/99937 ,  Y10S707/99942 ,  Y10S707/99944

摘要： Efficient hierarchical searching is based on object type. By pre-computing additional information and storing it in a fast-lookup structure, it is possible to quickly identify objects that satisfy an object retrieval request. Furthermore, it is also possible to use this technique to avoid object hydration for operations in the store. Moreover, it is possible to leverage database statistical structures such as histograms to estimate the number of qualifying objects without having to examine each object.

摘要翻译： 高效的分层搜索基于对象类型。 通过预先计算附加信息并将其存储在快速查找结构中，可以快速识别满足对象检索请求的对象。 此外，也可以使用这种技术来避免商店中的操作对象水合。 此外，可以利用数据库统计结构（如直方图）来估计合格对象的数量，而不必检查每个对象。