-
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）能够用用户提供的代码有效地和动态地扩展数据库引擎的逻辑。
-
公开(公告)号：US20060041574A1
公开(公告)日：2006-02-23
申请号：US11244018
申请日：2005-10-05
IPC分类号： G06F17/00
CPC分类号： G06F17/30327 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99936 , Y10S707/99937 , Y10S707/99942 , Y10S707/99944
摘要： Efficient hierarchical searching is based on object type. By pre-computing additional information and storing it in a fast-lookup structure, it is possible to quickly identify objects that satisfy an object retrieval request. Furthermore, it is also possible to use this technique to avoid object hydration for operations in the store. Moreover, it is possible to leverage database statistical structures such as histograms to estimate the number of qualifying objects without having to examine each object.
-
公开(公告)号：US20060064412A1
公开(公告)日：2006-03-23
申请号：US11244021
申请日：2005-10-05
IPC分类号： G06F17/30
CPC分类号： G06F17/30327 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99936 , Y10S707/99937 , Y10S707/99942 , Y10S707/99944
摘要： Efficient hierarchical searching is based on object type. By pre-computing additional information and storing it in a fast-lookup structure, it is possible to quickly identify objects that satisfy an object retrieval request. Furthermore, it is also possible to use this technique to avoid object hydration for operations in the store. Moreover, it is possible to leverage database statistical structures such as histograms to estimate the number of qualifying objects without having to examine each object.
-
公开(公告)号：US20050091183A1
公开(公告)日：2005-04-28
申请号：US10692350
申请日：2003-10-23
CPC分类号： G06F17/30327 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99936 , Y10S707/99937 , Y10S707/99942 , Y10S707/99944
摘要： Efficient hierarchical searching is based on object type. By pre-computing additional information and storing it in a fast-lookup structure, it is possible to quickly identify objects that satisfy an object retrieval request. Furthermore, it is also possible to use this technique to avoid object hydration for operations in the store. Moreover, it is possible to leverage database statistical structures such as histograms to estimate the number of qualifying objects without having to examine each object.
摘要翻译： 高效的层次搜索是基于对象类型的。 通过预先计算附加信息并将其存储在快速查找结构中，可以快速识别满足对象检索请求的对象。 此外，也可以使用该技术来避免商店中的操作的物体水合。 此外，可以利用诸如直方图的数据库统计结构来估计限定对象的数量而不必检查每个对象。
-
7.发明授权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.
摘要翻译： 提供了一种用于促进对数据库的安全访问的系统和方法。 该系统涉及授权对关系数据库数据的歧视性访问。 更具体地，本发明提供了一种创新技术，其以不能欺骗的方式定义对关系数据库表中的行的安全访问，同时保持各种优化技术。 本发明通过提供一种安全架构来提供持久性方案，从而可以在保持基于集合的关联查询能力的同时定义和实施持久性实体上的歧视性访问策略。 本发明的一个特定方面涉及这些策略的说明以及执行这些策略的技术。 关于本发明的一个具体实现，提供了称为安全描述符的访问控制列表的创建，修改和删除。 安全描述符可以独立于数据库表中的行进行配置，并且可以共享，并且包含与哪些权限相关联的权限被授予谁的策略。
-
8.发明授权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.
摘要翻译： 用于编译查询的各种技术的实现。 在一个实现中，可以监视查询的内存消耗。 如果查询消耗的内存量超过一个或多个网关阈值，则可以处理查询以获取一个或多个网关。 然后可以将查询编译为已经获取了一个或多个网关。
-
10.发明申请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.
摘要翻译： 提供了一种用于促进对数据库的安全访问的系统和方法。 该系统涉及授权对关系数据库数据的歧视性访问。 更具体地，本发明提供了一种创新技术，其以不能欺骗的方式定义对关系数据库表中的行的安全访问，同时保持各种优化技术。 本发明通过提供一种安全架构来提供持续方案，从而可以在保持基于集合的关联查询能力的同时定义和实施对持久性实体的区别性访问策略。 本发明的一个特定方面涉及这些策略的说明以及执行这些策略的方法。 关于本发明的一个具体实现，提供了称为安全描述符的访问控制列表的创建，修改和删除。 安全描述符可以独立于数据库表中的行进行配置，并且可以共享，并且包含与哪些权限相关联的权限被授予谁的策略。
-
-
-
-
-
-
-
-
-
搜索结果
23 条记录 (耗时 0.024 秒)
