公开(公告)号：US20050091231A1

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

申请号：US10693158

申请日：2003-10-24

申请人： Shankar Pal ,  Ramachandran Venkatesh ,  Jose Blakeley ,  Denis Altudov ,  Istvan Cseri ,  Chia-Hsun Chen ,  Alazel Acheson

发明人： Shankar Pal ,  Ramachandran Venkatesh ,  Jose Blakeley ,  Denis Altudov ,  Istvan Cseri ,  Chia-Hsun Chen ,  Alazel Acheson

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

CPC分类号： G06F16/84 ,  G06F16/93

摘要： A system and method are provided for modeling structured, semi-structured, and unstructured data all within a single instance of a user defined type (UDT) within a database store. In particular, the XML data model is extended to fields of a UDT. As a result, the properties of the XML data model—such as document order and document structure—can be preserved within instances of a UDT. Moreover, code representing object behavior (i.e., methods that can be invoked on an object in managed code) can be added to the UDT to operate on an XML field, as well as non-XML fields of the UDT. This enables a framework for adding business logic to XML data. The content model of the XML data can be optionally described using XML schema documents associated with the XML fields of the UDT.

摘要翻译： 提供了一种系统和方法，用于在数据库存储内的用户定义类型（UDT）的单个实例中对结构化，半结构化和非结构化数据进行建模。 特别地，XML数据模型扩展到UDT的字段。 因此，XML数据模型的属性（如文档顺序和文档结构）可以在UDT的实例中保留。 此外，可以将代表对象行为的代码（即，可以在托管代码中的对象上调用的方法）添加到UDT以对XML字段以及UDT的非XML字段进行操作。 这使得可以将业务逻辑添加到XML数据中。 可以使用与UDT的XML字段相关联的XML模式文档来可选地描述XML数据的内容模型。

公开(公告)号：US20050091188A1

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

申请号：US10693750

申请日：2003-10-24

申请人： Shankar Pal ,  Istvan Cseri ,  Gideon Schaller ,  Oliver Seeliger ,  Denis Altudov ,  Denis Churin ,  Sameer Verkhedkar

发明人： Shankar Pal ,  Istvan Cseri ,  Gideon Schaller ,  Oliver Seeliger ,  Denis Altudov ,  Denis Churin ,  Sameer Verkhedkar

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

CPC分类号： G06F17/30911 ,  Y10S707/99942 ,  Y10S707/99944

摘要： Storing and querying XML data in a primary table or document utilizes an index of XML data and includes creating a primary table structure, creating a primary XML index commensurate with the primary table structure, populating the primary table and the primary XML index, and running a query on the XML data in a primary table by utilizing the XML index. The XML index can be implemented as a node table. The node table may have a B+-tree structure and be populated by shredding the XML values in the primary table. The XML data may be stored as binary large objects in an XML column of the primary table. Secondary XML indexes may be created to assist in the search and retrieval of XML data stored in the primary table. Both the primary XML index and the secondary XML index tables may be created using data definition language statements.

摘要翻译： 在主表或文档中存储和查询XML数据使用XML数据索引，包括创建主表结构，创建与主表结构相称的主XML索引，填充主表和主XML索引，并运行 通过利用XML索引对主表中的XML数据进行查询。 XML索引可以实现为节点表。 节点表可以具有B + SUPERTree结构，并且通过对主表中的XML值进行粉碎来填充。 XML数据可以作为二进制大对象存储在主表的XML列中。 可以创建辅助XML索引以帮助搜索和检索存储在主表中的XML数据。 主XML索引和辅助XML索引表都可以使用数据定义语言语句创建。

公开(公告)号：US20050177551A1

公开(公告)日：2005-08-11

申请号：US11027416

申请日：2004-12-30

申请人： Balaji Rathakrishnan ,  Beysim Sezgin ,  Denis Altudov ,  Jose Blakeley ,  Oliver Seeliger ,  Ramachandran Venkatesh ,  Wei Yu ,  Dragan Tomic ,  Denis Churin ,  Bruno Denuit ,  Conor Cunningham ,  Stefano Stefani

发明人： Balaji Rathakrishnan ,  Beysim Sezgin ,  Denis Altudov ,  Jose Blakeley ,  Oliver Seeliger ,  Ramachandran Venkatesh ,  Wei Yu ,  Dragan Tomic ,  Denis Churin ,  Bruno Denuit ,  Conor Cunningham ,  Stefano Stefani

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30607 ,  Y10S707/99934

摘要： Several embodiments of the present invention are directed to systems and methods for extending the UDT framework of an extended relational data store (ERDS) to include support for unordered collections (multisets) and ordered collection (lists). More specifically, several embodiments of the present invention use an UDT infrastructure, CLR generics, and a new UNNEST operator to create and utilize a special type abstraction for collections that is simultaneously a scalar and a relation. As a scalar, this collection type can be processed by all parts of the data store engine that understand scalars (including but not limited to the client stack) and, as a relation, this collection type is queriable like any other type of relation.

摘要翻译： 本发明的几个实施例涉及用于扩展扩展关系数据存储（ERDS）的UDT框架以包括对无序集合（多集）和有序集合（列表）的支持的系统和方法。 更具体地，本发明的几个实施例使用UDT基础设施，CLR泛型和新的UNNEST运算符来创建并利用同时是标量和关系的集合的特殊类型抽象。 作为一个标量，这种集合类型可以由数据存储引擎的所有部分进行处理，这些数据存储引擎能够理解标量（包括但不限于客户端堆栈），作为一种关系，该集合类型可以像任何其他类型的关系一样被查询。

公开(公告)号：US20060225027A1

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

申请号：US11099020

申请日：2005-04-05

申请人： Ramachandran Venkatesh ,  Denis Altudov ,  Beysim Sezgin ,  Jose Blakeley

发明人： Ramachandran Venkatesh ,  Denis Altudov ,  Beysim Sezgin ,  Jose Blakeley

IPC分类号： G06F9/44

CPC分类号： G06F9/4493 ,  Y10S707/99932 ,  Y10S707/99944 ,  Y10S707/99953 ,  Y10S707/99957

摘要： Systems and methodologies of partially deserializing a Complex Type Object, via a deserializer that intercepts and materializes such object on demand. The object or a subset thereof can be deserialized to produce an Instance of Complex Type that is implemented by a property store. The deserializer can include an analyzer component that analyzes the Property Store.

公开(公告)号：US20050177581A1

公开(公告)日：2005-08-11

申请号：US10837929

申请日：2004-05-03

申请人： Beysim Sezgin ,  Denis Altudov ,  Jose Blakeley ,  Ramachandran Venkatesh ,  Wei Yu

发明人： Beysim Sezgin ,  Denis Altudov ,  Jose Blakeley ,  Ramachandran Venkatesh ,  Wei Yu

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

CPC分类号： G06F7/00 ,  G06F17/30289 ,  Y10S707/99934 ,  Y10S707/99943

摘要： 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 user-defined types with said database.

摘要翻译： 本发明的各种实施例涉及具有用于至少一个用户定义类型的可扩展类型系统的数据库，其包括用于描述其结构的信息以及用于描述其自身与另一用户定义类型之间的继承关系的信息 子类型或超类型/基类型）。 对于某些实施例，用户定义的类型以顺序查询语言（SQL）语句（例如公共语言运行时（CLR））语句，C，C ++和C＃（“C- 锐利“）和/或视觉基本声明。 在任何情况下，几个实施例进一步涉及系统，其中数据库通过用户定义的类型与所述数据库的显式注册来了解两个用户定义类型之间的继承关系。

公开(公告)号：US20050120048A1

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

申请号：US11028783

申请日：2005-01-04

申请人： Ramachandran Venkatesh ,  Beysim Sezgin ,  Jose Blakeley ,  Denis Altudov

发明人： Ramachandran Venkatesh ,  Beysim Sezgin ,  Jose Blakeley ,  Denis Altudov

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

CPC分类号： G06F17/30607 ,  G06F9/4493 ,  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.

公开(公告)号：US20050091228A1

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

申请号：US10692225

申请日：2003-10-23

申请人： Ramachandran Venkatesh ,  Beysim Sezgin ,  Jose Blakeley ,  Denis Altudov

发明人： Ramachandran Venkatesh ,  Beysim Sezgin ,  Jose Blakeley ,  Denis Altudov

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

CPC分类号： G06F17/30607 ,  G06F9/4493 ,  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.

摘要翻译： 用于将用户定义类型的对象存储在数据库存储中的新的持久性格式使得能够传送要传送到商店的类型的结构的信息。 此信息可实现多种存储优化，包括对类型成员的直接结构访问。 具体来说，在类型实现者和数据存储之间交换元数据。 商店使用元数据来确定该类型的实例的存储布局。 利用该信息，商店能够检测可优化的访问模式以直接在存储表示上操作而不对物体进行水化（反序列化）。