-
1.发明申请Systems and methods for the implementation of unordered and ordered collections in a data store 有权在数据存储中实现无序和有序集合的系统和方法公开(公告)号：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运算符来创建并利用同时是标量和关系的集合的特殊类型抽象。 作为一个标量，这种集合类型可以由数据存储引擎的所有部分进行处理，这些数据存储引擎能够理解标量（包括但不限于客户端堆栈），作为一种关系，该集合类型可以像任何其他类型的关系一样被查询。
-
2.发明授权System and method for efficient evaluation of a query that invokes a table valued function 有权用于有效评估调用表值函数的查询的系统和方法公开(公告)号：US07606792B2
公开(公告)日：2009-10-20
申请号：US10881474
申请日：2004-06-30
CPC分类号： G06F17/30483 , G06F17/30471 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99936 , Y10S707/99939 , Y10S707/99943 , Y10S707/99945
摘要： The present invention describes an efficient and fast framework for implementing table-valued functions (TVF's) in a relational database server. The framework provides desirable extensibility properties and has the ability to minimize performance degradations by integrating tightly with the optimization infrastructure in a query processor. The present invention also enables a managed execution environment (MEE) such as the Common-Language-Runtime (CLR), to efficiently and dynamically extend the logic of the database engine with user-supplied code.
摘要翻译： 本发明描述了在关系数据库服务器中实现表值函数（TVF）的有效和快速的框架。 该框架提供了所需的可扩展性，并具有通过与查询处理器中的优化基础架构紧密集成来最小化性能下降的能力。 本发明还使得诸如公共语言运行时（CLR）的被管理执行环境（MEE）能够用用户提供的代码来有效地和动态地扩展数据库引擎的逻辑。
-
3.发明申请System and method for efficient evaluation of a query that invokes a table valued function 有权用于有效评估调用表值函数的查询的系统和方法公开(公告)号：US20050209988A1
公开(公告)日：2005-09-22
申请号：US10881474
申请日：2004-06-30
CPC分类号： G06F17/30483 , G06F17/30471 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99936 , Y10S707/99939 , Y10S707/99943 , Y10S707/99945
摘要： The present invention describes an efficient and fast framework for implementing table-valued functions (TVF's) in a relational database server. The framework provides desirable extensibility properties and has the ability to minimize performance degradations by integrating tightly with the optimization infrastructure in a query processor. The present invention also enables a managed execution environment (MEE) such as the Common-Language-Runtime (CLR), to efficiently and dynamically extend the logic of the database engine with user-supplied code.
摘要翻译： 本发明描述了在关系数据库服务器中实现表值函数（TVF）的有效和快速的框架。 该框架提供了所需的可扩展性，并具有通过与查询处理器中的优化基础架构紧密集成来最小化性能下降的能力。 本发明还使得诸如公共语言运行时（CLR）的被管理执行环境（MEE）能够用用户提供的代码有效地和动态地扩展数据库引擎的逻辑。
-
公开(公告)号：US20060235834A1
公开(公告)日：2006-10-19
申请号：US11105878
申请日：2005-04-14
IPC分类号： G06F17/30
CPC分类号： G06F16/24544
摘要： Systems and methods for extension of a query language for defining a simple formulation of joins by capturing the semantics of an existing linkage between a plurality of tables, via employing a reference join. Such reference join enables a compiler to exploit existing relationships in a data base, and employ existing knowledge about referential constraints for an unambiguous transformation of the reference join expression into the equivalent INNER JOIN on the columns involved. Accordingly, a simpler query syntax and semantics can be provided to express multi-table join navigation over primary key/foreign key relations, for example.
摘要翻译： 用于扩展查询语言的系统和方法，用于通过采用参考连接捕获多个表之间的现有链接的语义来定义联接的简单公式。 这种引用连接使得编译器能够利用数据库中的现有关系，并且使用关于引用约束的现有知识来将引用连接表达式的明确变换引入相关列中的等效INNER JOIN。 因此，可以提供更简单的查询语法和语义来表示例如主键/外键关系的多表连接导航。
-
5.发明授权Systems and methods for fine grained access control of data stored in relational databases 有权对关系数据库中存储的数据进行细粒度访问控制的系统和方法公开(公告)号：US07599937B2
公开(公告)日：2009-10-06
申请号：US11696024
申请日：2007-04-03
IPC分类号： G06F17/30
CPC分类号： G06F21/6227 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99939
摘要： A system and method for facilitating secure access to database(s) is provided. The system relates to authorizing discriminatory access to relational database data. More particularly, the invention provides for an innovative technique of defining secured access to rows in relational database tables in a way that cannot be spoofed while preserving various optimization techniques. The invention affords a persistent scheme via providing for a security architecture whereby discriminatory access policies on persistent entities can be defined and enforced while preserving set based associative query capabilities.A particular aspect of the invention relates to the specification of such policies and the technique by which those policies are enforced. With respect to one particular implementation of the invention, creation, modification and deletion of access control lists called security descriptors is provided. The security descriptors can be provisioned independent of rows in tables of the database and can be shared and embody the policy on what permissions are granted to whom when associated with a row.
摘要翻译： 提供了一种用于促进对数据库的安全访问的系统和方法。 该系统涉及授权对关系数据库数据的歧视性访问。 更具体地，本发明提供了一种创新技术，其以不能欺骗的方式定义对关系数据库表中的行的安全访问，同时保持各种优化技术。 本发明通过提供一种安全架构来提供持久性方案，从而可以在保持基于集合的关联查询能力的同时定义和实施持久性实体上的歧视性访问策略。 本发明的一个特定方面涉及这些策略的说明以及执行这些策略的技术。 关于本发明的一个具体实现，提供了称为安全描述符的访问控制列表的创建，修改和删除。 安全描述符可以独立于数据库表中的行进行配置，并且可以共享，并且包含与哪些权限相关联的权限被授予谁的策略。
-
6.发明授权Systems and methods for fine grained access control of data stored in relational databases 有权对关系数据库中存储的数据进行细粒度访问控制的系统和方法公开(公告)号：US07200595B2
公开(公告)日：2007-04-03
申请号：US10878152
申请日：2004-06-28
IPC分类号： G06F17/30
CPC分类号： G06F21/6227 , G06F17/30306 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99939
摘要： A system and method for facilitating secure access to database(s) is provided. The system relates to authorizing discriminatory access to relational database data. More particularly, the invention provides for an innovative technique of defining secured access to rows in relational database tables in a way that cannot be spoofed while preserving various optimization techniques. The invention affords a persistent scheme via providing for a security architecture whereby discriminatory access policies on persistent entities can be defined and enforced while preserving set based associative query capabilities.A particular aspect of the invention relates to the specification of such policies and the technique by which those policies are enforced. With respect to one particular implementation of the invention, creation, modification and deletion of access control lists called security descriptors is provided. The security descriptors can be provisioned independent of rows in tables of the database and can be shared and embody the policy on what permissions are granted to whom when associated with a row.
摘要翻译： 提供了一种用于促进对数据库的安全访问的系统和方法。 该系统涉及授权对关系数据库数据的歧视性访问。 更具体地，本发明提供了一种创新技术，其以不能欺骗的方式定义对关系数据库表中的行的安全访问，同时保持各种优化技术。 本发明通过提供一种安全架构来提供持续方案，从而可以在保持基于集合的关联查询能力的同时定义和实施对持久性实体的区别性访问策略。
-
公开(公告)号：US20070239658A1
公开(公告)日：2007-10-11
申请号：US11392267
申请日：2006-03-29
申请人： Conor Cunningham , Stanislav Oks , Stefano Stefani
发明人： Conor Cunningham , Stanislav Oks , Stefano Stefani
IPC分类号： G06F17/30
CPC分类号： G06F17/30442
摘要： Implementations of various technologies for compiling a query. In one implementation, the memory consumption of the query may be monitored. If the amount of memory consumed by the query exceeds one or more gateway thresholds, then the query may be processed to acquire one or more gateways. The query may then be compiled as having acquired the one or more gateways.
摘要翻译： 用于编译查询的各种技术的实现。 在一个实现中，可以监视查询的内存消耗。 如果查询消耗的内存量超过一个或多个网关阈值，则可以处理查询以获取一个或多个网关。 然后可以将查询编译为已经获取了一个或多个网关。
-
8.发明申请Systems and methods for fine grained access control of data stored in relational databases 有权对关系数据库中存储的数据进行细粒度访问控制的系统和方法公开(公告)号：US20050216465A1
公开(公告)日：2005-09-29
申请号：US10878152
申请日：2004-06-28
申请人： Tanmoy Dutta , Conor Cunningham , Stefano Stefani , Girish Chander , Eric Hanson
发明人： Tanmoy Dutta , Conor Cunningham , Stefano Stefani , Girish Chander , Eric Hanson
CPC分类号： G06F21/6227 , G06F17/30306 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99939
摘要： A system and method for facilitating secure access to database(s) is provided. The system relates to authorizing discriminatory access to relational database data. More particularly, the invention provides for an innovative technique of defining secured access to rows in relational database tables in a way that cannot be spoofed while preserving various optimization techniques. The invention affords a persistent scheme via providing for a security architecture whereby discriminatory access policies on persistent entities can be defined and enforced while preserving set based associative query capabilities. A particular aspect of the invention relates to the specification of such policies and the technique by which those policies are enforced. With respect to one particular implementation of the invention, creation, modification and deletion of access control lists called security descriptors is provided. The security descriptors can be provisioned independent of rows in tables of the database and can be shared and embody the policy on what permissions are granted to whom when associated with a row.
摘要翻译： 提供了一种用于促进对数据库的安全访问的系统和方法。 该系统涉及授权对关系数据库数据的歧视性访问。 更具体地，本发明提供了一种创新技术，其以不能欺骗的方式定义对关系数据库表中的行的安全访问，同时保持各种优化技术。 本发明通过提供一种安全架构来提供持续方案，从而可以在保持基于集合的关联查询能力的同时定义和实施对持久性实体的区别性访问策略。 本发明的一个特定方面涉及这些策略的说明以及执行这些策略的方法。 关于本发明的一个具体实现，提供了称为安全描述符的访问控制列表的创建，修改和删除。 安全描述符可以独立于数据库表中的行进行配置，并且可以共享，并且包含与哪些权限相关联的权限被授予谁的策略。
-
9.发明申请SYSTEMS AND METHODS FOR FINE GRAINED ACCESS CONTROL OF DATA STORED IN RELATIONAL DATABASES 有权用于关联数据库中存储的数据的细粒度访问控制的系统和方法公开(公告)号：US20070174285A1
公开(公告)日：2007-07-26
申请号：US11696024
申请日：2007-04-03
申请人： Tanmoy Dutta , Conor Cunningham , Stefano Stefani , Girish Chander , Eric Hanson
发明人： Tanmoy Dutta , Conor Cunningham , Stefano Stefani , Girish Chander , Eric Hanson
IPC分类号： G06F17/30
CPC分类号： G06F21/6227 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99939
摘要： A system and method for facilitating secure access to database(s) is provided. The system relates to authorizing discriminatory access to relational database data. More particularly, the invention provides for an innovative technique of defining secured access to rows in relational database tables in a way that cannot be spoofed while preserving various optimization techniques. The invention affords a persistent scheme via providing for a security architecture whereby discriminatory access policies on persistent entities can be defined and enforced while preserving set based associative query capabilities. A particular aspect of the invention relates to the specification of such policies and the technique by which those policies are enforced. With respect to one particular implementation of the invention, creation, modification and deletion of access control lists called security descriptors is provided. The security descriptors can be provisioned independent of rows in tables of the database and can be shared and embody the policy on what permissions are granted to whom when associated with a row.
摘要翻译： 提供了一种用于促进对数据库的安全访问的系统和方法。 该系统涉及授权对关系数据库数据的歧视性访问。 更具体地，本发明提供了一种创新技术，其以不能欺骗的方式定义对关系数据库表中的行的安全访问，同时保持各种优化技术。 本发明通过提供一种安全架构来提供持续方案，从而可以在保持基于集合的关联查询能力的同时定义和实施对持久性实体的区别性访问策略。 本发明的一个特定方面涉及这些策略的说明以及执行这些策略的技术。 关于本发明的一个具体实现，提供了称为安全描述符的访问控制列表的创建，修改和删除。 安全描述符可以独立于数据库表中的行进行配置，并且可以共享，并且包含与哪些权限相关联的权限被授予谁的策略。
-
公开(公告)号：US20060074965A1
公开(公告)日：2006-04-06
申请号：US10957409
申请日：2004-10-01
申请人： Conor Cunningham , Stefano Stefani
发明人： Conor Cunningham , Stefano Stefani
IPC分类号： G06F17/00
CPC分类号： G06F17/30315
摘要： Database management systems allow modification of existing table rows through update statements or other data modification commands. For example, a user may specify, via a command statement, the table to update, the columns to modify and their respective new value(s), and qualify the rows to be updated. Optimized constraint and index maintenance for data modification statements and commands is provided where the new value being assigned to the columns is actually the same as the current value, e.g., update commands that actually leave the columns unchanged.
摘要翻译： 数据库管理系统允许通过更新语句或其他数据修改命令修改现有的表行。 例如，用户可以通过命令语句指定要更新的表，要修改的列及其各自的新值，并限定要更新的行。 提供了数据修改语句和命令的优化约束和索引维护，其中分配给列的新值实际上与当前值相同，例如，实际上使列保持不变的更新命令。
-
-
-
-
-
-
-
-
-
搜索结果
23 条记录 (耗时 0.038 秒)
