公开(公告)号：EP1627508A4

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

申请号：EP04779521

申请日：2004-07-29

申请人： MICROSOFT CORP

发明人： PAL SHANKAR ,  VANKATESH RAMACHANDRAN ,  BLAKELEY JOSE A ,  ALTUDOV DENIS Y ,  CSERI ISTVAN ,  CHEN CHIA-HSUN ,  ACHESON ALAZEL

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

CPC分类号： G06F17/30914 ,  G06F17/30011

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

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

公开(公告)号：EP2008206A4

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

申请号：EP07753857

申请日：2007-03-22

申请人： MICROSOFT CORP

发明人： ADYA ATUL ,  BLAKELEY JOSE A ,  LARSON PER-AKE ,  MELNIK SERGEY

IPC分类号： G06F17/30

CPC分类号： G06F17/30457 ,  Y10S707/99932

摘要： A data access architecture is provided that includes a mapping architecture for mapping data as may be used by an application to data as persisted in a database. The mapping architecture makes use of two types of mapping views—a query view that helps in translating queries and an update view that helps in translating updates. Incremental view maintenance can be used to translate data between the application and database.

公开(公告)号：EP1683046A4

公开(公告)日：2009-07-08

申请号：EP04779487

申请日：2004-07-29

申请人： MICROSOFT CORP

发明人： SEZGIN BEYSIM ,  ALTUDOV DENIS Y ,  BLAKELEY JOSE A ,  VENKATESH RAMACHANDRAN ,  YU WEI

IPC分类号： G06F17/30

CPC分类号： G06F17/30607

摘要： Various embodiments of the present invention are directed to a database with an extensible type system for at least one user-defined type that comprises information for describing its structure as well as information for describing an inheritance relationship between itself and another user-defined type (either a subtype or a supertype/base type). For certain embodiments, the user-defined type is defined in something other than Sequential Query Language (SQL) statement such as, for example, a Common Language Runtime (CLR) statement, a statement in C, C++, and C# ("C-sharp"), and/or a visual basic statement. In any event, several embodiments are further directed to a system wherein the database is aware of the inheritance relationship between two user-defined types by an explicit registration of the userdefined types with said database.

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

公开(公告)号：EP1593059A4

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

申请号：EP04779551

申请日：2004-07-29

申请人： MICROSOFT CORP

发明人： VENKATESH RAMACHANDRAN ,  SEZGIN BEYSIM ,  BLAKELEY JOSE A ,  ALTUDOV DENIS Y

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

CPC分类号： G06F17/30607 ,  G06F9/4435 ,  G06F17/30492 ,  Y10S707/955 ,  Y10S707/99932 ,  Y10S707/99936 ,  Y10S707/99937 ,  Y10S707/99942 ,  Y10S707/99944

摘要： A new persistence format for storing objects of a user defined type in a database store enables information about the structure of the type to be communicated to the store. This information enables a number of store optimizations, including direct structural access to members of the type. Specifically, metadata is exchanged between the type implementer and the data store. The store uses the metadata to determine the storage layout for instances of the type. With this information, the store is able to detect access patterns that can be optimized to directly operate over the storage representation without hydration (deserialization) the object.