专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08112383B2 Systems and methods for a database engine in-process data provider 有权
标题翻译：数据库引擎进程内数据提供者的系统和方法
公开(公告)号：US08112383B2
公开(公告)日：2012-02-07
申请号：US10776370
申请日：2004-02-10
申请人： Alazel Acheson , Shrinivas Ashwin , Jose A. Blakeley , Peter Carlin , Erik Ismert , Christian Kleinerman , Ganapathy Subramaniam Krishnamoorthy , Girkumar Nair
发明人： Alazel Acheson , Shrinivas Ashwin , Jose A. Blakeley , Peter Carlin , Erik Ismert , Christian Kleinerman , Ganapathy Subramaniam Krishnamoorthy , Girkumar Nair
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30595 , G06F17/3041
摘要： Various embodiments of the present invention enable functions, procedures, and triggers to be written in any of the .NET languages and executed by the RDBMS. User code can access data from the local or other SQL servers using the SQL Programming Model and both the SqlServer or SqlClient implementations respectively. Moreover, to improve upon the previous extensibility mechanism, a set of APIs (commonly known as “the in-process provider” or “inproc provider”) is utilized to provide efficient and easy to use data access while running inproc, a data access API that is an implementation of the ADO.net programming model.
摘要翻译：本发明的各种实施例使功能，过程和触发器能够以任何.NET语言编写并由RDBMS执行。用户代码可以分别使用SQL编程模型和SqlServer或SqlClient实现访问来自本地或其他SQL服务器的数据。此外，为了改进以前的可扩展性机制，使用一组API（通常称为“进程内提供程序”或“inproc提供程序”）来提供高效且易于使用的数据访问，同时运行inproc，数据访问API 这是ADO.net编程模型的实现。

2. 发明授权

US07437346B2 Systems and methods for a large object infrastructure in a database system 有权
标题翻译：数据库系统中大对象基础架构的系统和方法
公开(公告)号：US07437346B2
公开(公告)日：2008-10-14
申请号：US10776664
申请日：2004-02-10
申请人： Shrinivas Ashwin , Jose A. Blakeley , Peter Carlin , Jun Fang , Ajay Kalhan , Christian Kleinerman , Stefano Stefani , Aleksandras Surna , Honggang Zhang
发明人： Shrinivas Ashwin , Jose A. Blakeley , Peter Carlin , Jun Fang , Ajay Kalhan , Christian Kleinerman , Stefano Stefani , Aleksandras Surna , Honggang Zhang
IPC分类号： G06F7/00
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.
摘要翻译：本发明的各种实施例直接利用作为大值的内部表示的Blob句柄（BH）。 BH是不可变的和无状态的引用大型数据对象。 BH的结构包含足够的信息来返回ILockBytes接口，以便提供对相应的大数据块的访问，并且BH还可以返回关于其自身寿命描述的信息。可以使用（a）指向BH数据的开始的指针和（b）BH的字节长度来完全描述BH。

3. 发明授权

US07539688B2 Systems and methods for supporting inheritance for user-defined types 有权
标题翻译：用于支持用户定义类型继承的系统和方法
公开(公告)号：US07539688B2
公开(公告)日：2009-05-26
申请号：US10837929
申请日：2004-05-03
申请人： Beysim Sezgin , Denis Y. Altudov , Jose A. Blakeley , Ramachandran Venkatesh , Wei Yu
发明人： Beysim Sezgin , Denis Y. Altudov , Jose A. Blakeley , Ramachandran Venkatesh , Wei Yu
IPC分类号： G06F7/00 , G06F17/00
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- 锐利“）和/或视觉基本声明。在任何情况下，几个实施例进一步涉及系统，其中数据库通过用户定义的类型与所述数据库的显式注册来了解两个用户定义类型之间的继承关系。

4. 发明授权

US07421445B2 System and method for relational representation of hierarchical data 有权
标题翻译：分层数据的关系表示的系统和方法
公开(公告)号：US07421445B2
公开(公告)日：2008-09-02
申请号：US10924704
申请日：2004-08-24
申请人： Patrick Eugene O'Neil , Elizabeth Jean O'Neil , Shankar Pal , Gideon Schaller , Istvan Cseri , Jose A. Blakeley , Nigel Clifton Westbury , Sameet Agarwal , F. Soner Terek
发明人： Patrick Eugene O'Neil , Elizabeth Jean O'Neil , Shankar Pal , Gideon Schaller , Istvan Cseri , Jose A. Blakeley , Nigel Clifton Westbury , Sameet Agarwal , F. Soner Terek
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30917 , Y10S707/99943 , Y10S707/99956
摘要： A technique for representing the structure of hierarchically-organized data in a non-hierarchical data structure, such as a relation. The hierarchically-organized data is represented as a tree, and each node in the tree is assigned a position identifier that represents both the depth level of the node within the hierarchy, and its ancestor/descendant relationship to other nodes. The data represented by each node, as well as its position identifier, is stored in a row of a relational database, thereby capturing the hierarchical structure of the data in such relational database. A technique is provided for the compressed storage of position identifiers in a format that allows an efficient bytewise comparison of position identifiers to determine relative order and ancestry.
摘要翻译：用于表示非分层数据结构（例如关系）中的分层组织数据的结构的技术。分层组织的数据被表示为树，并且树中的每个节点被分配一个位置标识符，其表示层次结构内的节点的深度级别，以及其与其他节点的祖先/后代关系。由每个节点表示的数据及其位置标识符存储在关系数据库的一行中，从而捕获这种关系数据库中数据的层次结构。提供了一种用于以允许位置标识符的有效从字面比较确定相对顺序和祖先的格式的位置标识符的压缩存储的技术。

5. 发明授权

US06976029B2 System and method for providing user defined types in a database system 失效
标题翻译：在数据库系统中提供用户定义类型的系统和方法
公开(公告)号：US06976029B2
公开(公告)日：2005-12-13
申请号：US10775282
申请日：2004-02-10
申请人： Ramachandran Venkatesh , Jun Fang , Jose A. Blakeley , Beysim Sezgin , Balaji Rathakrishnan , Peter A. Carlin
发明人： Ramachandran Venkatesh , Jun Fang , Jose A. Blakeley , Beysim Sezgin , Balaji Rathakrishnan , Peter A. 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查询和更新中用户定义类型的表达式。优选地，数据库系统存储关于用户定义类型的元数据，以便随后用于创建该类型的实例。

6. 发明申请

US20110219020A1 COLUMNAR STORAGE OF A DATABASE INDEX 有权
标题翻译：数据库索引的存储
公开(公告)号：US20110219020A1
公开(公告)日：2011-09-08
申请号：US12719015
申请日：2010-03-08
申请人： Artem A. Oks , Per-Ake Larson , Srikumar Rangarajan , Michael James Zwilling , Jose A. Blakeley , Hanumantha R. Kodavalla
发明人： Artem A. Oks , Per-Ake Larson , Srikumar Rangarajan , Michael James Zwilling , Jose A. Blakeley , Hanumantha R. Kodavalla
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30 , G06F17/30303 , G06F17/30589
摘要： Methods, systems, and computer-readable media of columnar storage of a database index are disclosed. A particular columnar index includes a column store that stores rows of the columnar index in a column-wise fashion and a delta store that stores rows of the columnar index in a row-wise fashion. The column store also includes an absence flag array. The absence flag array includes entries that indicate whether certain rows have been logically deleted from the column store.
摘要翻译：公开了数据库索引的柱状存储的方法，系统和计算机可读介质。特定的柱状索引包括列存储，其以列方式存储列索引的行，以及以行方式存储列索引的行的增量存储。列存储还包括不存在标志数组。缺席标志数组包括表示某些行是否已经从列存储中被逻辑删除的条目。

7. 发明授权

US07676493B2 Incremental approach to an object-relational solution 有权
标题翻译：对象关系解决方案的增量方法
公开(公告)号：US07676493B2
公开(公告)日：2010-03-09
申请号：US11364060
申请日：2006-02-28
申请人： Michael J. Pizzo , Chris A. Suver , Pablo Castro , Alyssa Heather Henry , Andrew J. Conrad , Subramanian Muralidhar , Benjamin Albahari , Jose A. Blakeley
发明人： Michael J. Pizzo , Chris A. Suver , Pablo Castro , Alyssa Heather Henry , Andrew J. Conrad , Subramanian Muralidhar , Benjamin Albahari , Jose A. Blakeley
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30607
摘要： The claimed subject matter relates to an architecture that can facilitate an incremental approach to an Object-Relational mapping solution. The architecture can provide a rich data model that is defined at the value layer. The rich data model can expose an interface that conforms with the interfaces exposed by common storage-specific data providers. The architecture can extend common storage-specific data provider to support common command representations, and provide entity services that work in terms of the rich data model as well as object services such as identity management, updating and change tracking.
摘要翻译：所要求保护的主题涉及可以促进对象关系映射解决方案的增量方法的体系结构。该架构可以提供在值层定义的丰富的数据模型。丰富的数据模型可以暴露符合常见存储特定数据提供者所暴露接口的接口。该架构可以扩展常见的特定于存储的数据提供者，以支持通用命令表示，并提供在富数据模型以及对象服务（如身份管理，更新和更改跟踪）方面工作的实体服务。

8. 发明授权

US07376656B2 System and method for providing user defined aggregates in a database system 有权
标题翻译：在数据库系统中提供用户定义的聚合的系统和方法
公开(公告)号：US07376656B2
公开(公告)日：2008-05-20
申请号：US10775982
申请日：2004-02-10
申请人： Jose A. Blakeley , Hongang Zhang , Balaji Rathakrishnan , Ramachandran Venkatesh , Beysim Sezgin , Alexios Boukouvalas , Cesar A. Galindo-Legaria , Peter A. Carlin
发明人： Jose A. Blakeley , Hongang Zhang , Balaji Rathakrishnan , Ramachandran Venkatesh , Beysim Sezgin , Alexios Boukouvalas , Cesar A. Galindo-Legaria , Peter A. Carlin
IPC分类号： G06F7/00 , G07F17/00
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 certain specified methods that can be invoked on an instance of the class. 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.
摘要翻译：数据库系统和方法允许用户以高级编程语言编写程序代码，该语言实现定义用户定义聚合的结构的类，以及可以在用户定义聚合的实例上调用的方法。该类然后向数据库系统注册，该数据库系统针对类强制执行用户定义的聚合的特定合同。合同包括以下要求。首先，类必须为数据库存储中用户定义聚合的持久化实例指定多种不同格式之一。第二，类必须包含可以在类的实例上调用的某些指定方法。一旦满足这些要求，数据库系统就可以创建用户定义聚合的实例。优选地，数据库系统存储关于用户定义聚合的元数据，用于随后用于创建聚合的实例。

9. 发明授权

US09195657B2 Columnar storage of a database index 有权
标题翻译：数据库索引的列存储
公开(公告)号：US09195657B2
公开(公告)日：2015-11-24
申请号：US12719015
申请日：2010-03-08
申请人： Artem A. Oks , Per-Ake Larson , Srikumar Rangarajan , Michael James Zwilling , Jose A. Blakeley , Hanumantha R. Kodavalla
发明人： Artem A. Oks , Per-Ake Larson , Srikumar Rangarajan , Michael James Zwilling , Jose A. Blakeley , Hanumantha R. Kodavalla
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30 , G06F17/30303 , G06F17/30589
摘要： Methods, systems, and computer-readable media of columnar storage of a database index are disclosed. A particular columnar index includes a column store that stores rows of the columnar index in a column-wise fashion and a delta store that stores rows of the columnar index in a row-wise fashion. The column store also includes an absence flag array. The absence flag array includes entries that indicate whether certain rows have been logically deleted from the column store.
摘要翻译：公开了数据库索引的柱状存储的方法，系统和计算机可读介质。特定的柱状索引包括列存储，其以列方式存储列索引的行，以及以行方式存储列索引的行的增量存储。列存储还包括不存在标志数组。缺席标志数组包括表示某些行是否已经从列存储中被逻辑删除的条目。

10. 发明授权

US07437371B2 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运算符来创建并利用同时是标量和关系的集合的特殊类型抽象。作为一个标量，这种集合类型可以由数据存储引擎的所有部分进行处理，这些数据存储引擎能够理解标量（包括但不限于客户端堆栈），作为一种关系，该集合类型可以像任何其他类型的关系一样被查询。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式