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

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

公开(公告)号：US20050177585A1

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

申请号：US11057475

申请日：2005-02-14

申请人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

发明人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

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

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

摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

公开(公告)号：US20050177583A1

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

申请号：US11016240

申请日：2004-12-17

申请人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

发明人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

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

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

摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

公开(公告)号：US20050177589A1

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

申请号：US10775282

申请日：2004-02-10

申请人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

发明人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

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

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

摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

摘要翻译： 数据库系统和方法允许用户以实现定义用户定义类型的结构的类的高级编程语言编写程序代码，并且可以在该类型的实例上调用方法。 该类然后向数据库系统注册，该系统针对类强制执行用户定义类型的特定合同。 合同包括以下要求。 首先，类必须为数据库存储中的用户定义类型的持久化实例指定多种不同格式之一。 第二，类必须能够返回用户定义类型的空值。 第三，类必须提供一种将用户定义类型转换为另一种类型的方法。 一旦满足这些要求，数据库系统就可以创建用户定义类型的实例。 可以在可以使用任何其他内置类型的所有上下文中使用用户定义的类型。 这包括定义表的列，将变量和参数声明为函数和存储过程，以及评估SQL查询和更新中用户定义类型的表达式。 优选地，数据库系统存储关于用户定义类型的元数据，以便随后用于创建该类型的实例。

公开(公告)号：US20050177579A1

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

申请号：US10775982

申请日：2004-02-10

申请人： Jose Blakeley ,  Hongang Zhang ,  Balaji Rathakrishnan ,  Ramachandran Venkatesh ,  Beysim Sezgin ,  Alexios Boukouvalas ,  Cesar Galindo-Legaria ,  Peter Carlin

发明人： Jose Blakeley ,  Hongang Zhang ,  Balaji Rathakrishnan ,  Ramachandran Venkatesh ,  Beysim Sezgin ,  Alexios Boukouvalas ,  Cesar Galindo-Legaria ,  Peter Carlin

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

CPC分类号： G06F17/30607 ,  G06F17/30412 ,  G06F17/30421 ,  Y10S707/955 ,  Y10S707/99944

摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined aggregate and methods that can be invoked on instances of the user-defined aggregate. The class is then registered with the database system, which enforces a specific contract for user-defined aggregates against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined aggregate in a database store. Second, the class must comprise a first method that can be invoked to initialize the computation of an instance of the user-defined aggregate, a second method that can be invoked to accumulate a plurality of values to be aggregated with the user-defined aggregate, a third method that can be invoked to merge an instance of the user-defined aggregate with another partial aggregation, and a fourth method that can be invoked to compute a final result of an instance of the user-defined aggregate. Once these requirements are satisfied, the database system enables instances of the user-defined aggregate to be created. Preferably, the database system stores metadata about the user-defined aggregate for subsequent use in creating instances of the aggregate.

摘要翻译： 数据库系统和方法允许用户以高级编程语言编写程序代码，该语言实现定义用户定义聚合的结构的类，以及可以在用户定义聚合的实例上调用的方法。 该类然后向数据库系统注册，该数据库系统针对类强制执行用户定义的聚合的特定合同。 合同包括以下要求。 首先，类必须为数据库存储中用户定义聚合的持久化实例指定多种不同格式之一。 第二，类必须包括可被调用以初始化用户定义聚合的实例的计算的第一方法，可以被调用以累积要与用户定义的聚合聚合的多个值的第二方法， 可以调用以将用户定义聚合的实例与另一部分聚合合并的第三种方法，以及可以调用以计算用户定义聚合的实例的最终结果的第四种方法。 一旦满足这些要求，数据库系统就可以创建用户定义聚合的实例。 优选地，数据库系统存储关于用户定义聚合的元数据，用于随后用于创建聚合的实例。

公开(公告)号：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数据的内容模型。