-
公开(公告)号：US07539688B2
公开(公告)日：2009-05-26
申请号：US10837929
申请日：2004-05-03
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- 锐利“）和/或视觉基本声明。 在任何情况下，几个实施例进一步涉及系统，其中数据库通过用户定义的类型与所述数据库的显式注册来了解两个用户定义类型之间的继承关系。
-
2.发明授权Systems and methods for the implementation of unordered and ordered collections in a data store 有权在数据存储中实现无序和有序集合的系统和方法公开(公告)号：US07437371B2
公开(公告)日：2008-10-14
申请号：US11027416
申请日：2004-12-30
申请人： Balaji Rathakrishnan , Beysim Sezgin , Denis Y. Altudov , Jose A. Blakeley , Oliver Nicholas Seeliger , Ramachandran Venkatesh , Wei Yu , Dragan Tomic , Denis Churin , Bruno H. M. Denuit , Conor J. Cunningham , Stefano Stefani
发明人： Balaji Rathakrishnan , Beysim Sezgin , Denis Y. Altudov , Jose A. Blakeley , Oliver Nicholas Seeliger , Ramachandran Venkatesh , Wei Yu , Dragan Tomic , Denis Churin , Bruno H. M. Denuit , Conor J. Cunningham , Stefano Stefani
IPC分类号： G06F17/00
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运算符来创建并利用同时是标量和关系的集合的特殊类型抽象。 作为一个标量，这种集合类型可以由数据存储引擎的所有部分进行处理，这些数据存储引擎能够理解标量（包括但不限于客户端堆栈），作为一种关系，该集合类型可以像任何其他类型的关系一样被查询。
-
公开(公告)号：US06941316B2
公开(公告)日：2005-09-06
申请号：US10692225
申请日：2003-10-23
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.
-
公开(公告)号：US07356546B2
公开(公告)日：2008-04-08
申请号：US11028783
申请日：2005-01-04
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.
摘要翻译： 用于将用户定义类型的对象存储在数据库存储中的新的持久性格式使得能够传送要传送到商店的类型的结构的信息。 此信息可实现多种存储优化，包括对类型成员的直接结构访问。 具体来说，在类型实现者和数据存储之间交换元数据。 商店使用元数据来确定该类型的实例的存储布局。 利用该信息，商店能够检测可优化的访问模式以直接在存储表示上操作而不对物体进行水化（反序列化）。
-
公开(公告)号：US07634498B2
公开(公告)日：2009-12-15
申请号：US10693750
申请日：2003-10-24
申请人： Shankar Pal , Istvan Cseri , Gideon Schaller , Oliver N. Seeliger , Denis Y. Altudov , Denis V. Churin , Sameer A. Verkhedkar
发明人： Shankar Pal , Istvan Cseri , Gideon Schaller , Oliver N. Seeliger , Denis Y. Altudov , Denis V. Churin , Sameer A. Verkhedkar
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 +树结构，并通过粉碎主表中的XML值来填充。 XML数据可以作为二进制大对象存储在主表的XML列中。 可以创建辅助XML索引以帮助搜索和检索存储在主表中的XML数据。 主XML索引和辅助XML索引表都可以使用数据定义语言语句创建。
-
-
-
-
搜索结果
5 条记录 (耗时 0.023 秒)
