-
公开(公告)号：US07340445B2
公开(公告)日：2008-03-04
申请号：US11051360
申请日：2005-02-04
申请人： Conor J. Cunningham , Eric N. Hanson , Milind M. Joshi , Cesar A. Galindo-Legaria , Florian M. Waas
发明人： Conor J. Cunningham , Eric N. Hanson , Milind M. Joshi , Cesar A. Galindo-Legaria , Florian M. Waas
IPC分类号： G06F17/30
CPC分类号： G06F17/30451 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： Indexed views or materialized views are used as a secondary index on a base table with multi-valued attributes. This provides for using the index to search in the nested data. Moreover, indexing is provided on the result of an unnest operation. Indexing a view on the result of an unnesting operation provides the ability to index the contents of a nested collection. One such unnesting operation is “cross apply unnest”. This provides additional options for a query execution plan, leading to a more optimized query. A back-join is provided from the indexed view to the base table to allow fields from the base table that are not present in the indexed view to be included in a result of a query on the table which is processed using the indexed view as an access path. This provides a means of including columns in the query result that are not in the indexed view but are in the base table. The back-join is supported from a single-table indexed view to the base table via a unique clustering key which acts as a logical row locator. Thus, the system can back-join to the base table from an indexed view via the unique clustering key. These features allow the use of indexed views to index a table on the contents of multi-set or multi-valued attributes.
摘要翻译： 索引视图或物化视图用作具有多值属性的基表上的辅助索引。 这提供了使用索引来搜索嵌套数据。 而且，索引是针对不良操作的结果。 索引对不察觉操作的结果的视图提供了对嵌套集合的内容进行索引的能力。 一个这样的不太理想的操作是“不适用”。 这为查询执行计划提供了其他选项，从而导致更优化的查询。 从索引视图向基表提供反向连接，以允许来自索引视图中不存在的基表中的字段包含在使用索引视图处理的表上的查询结果中作为 访问路径 这提供了一种在查询结果中包含不在索引视图中但在基表中的列的方法。 通过独立的集群密钥（作为逻辑行定位符），从单表索引视图向基表支持后连接。 因此，系统可以通过独特的聚类键从索引视图返回到基表。 这些功能允许使用索引视图来索引关于多集或多值属性的内容的表。
-
公开(公告)号：US07272598B2
公开(公告)日：2007-09-18
申请号：US11096149
申请日：2005-03-31
申请人： Conor J. Cunningham , Eric N. Hanson , Milind M. Joshi , Cesar A. Galindo-Legaria , Florian M. Waas
发明人： Conor J. Cunningham , Eric N. Hanson , Milind M. Joshi , Cesar A. Galindo-Legaria , Florian M. Waas
IPC分类号： G06F17/30
CPC分类号： G06F17/30451 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： Indexed views or materialized views are used as a secondary index on a base table with multi-valued attributes. This provides for using the index to search in the nested data. Moreover, indexing is provided on the result of an unnest operation. Indexing a view on the result of an unnesting operation provides the ability to index the contents of a nested collection. One such unnesting operation is “cross apply unnest”. This provides additional options for a query execution plan, leading to a more optimized query. A back-join is provided from the indexed view to the base table to allow fields from the base table that are not present in the indexed view to be included in a result of a query on the table which is processed using the indexed view as an access path. This provides a means of including columns in the query result that are not in the indexed view but are in the base table. The back-join is supported from a single-table indexed view to the base table via a unique clustering key which acts as a logical row locator. Thus, the system can back-join to the base table from an indexed view via the unique clustering key. These features allow the use of indexed views to index a table on the contents of multi-set or multi-valued attributes.
摘要翻译： 索引视图或物化视图用作具有多值属性的基表上的辅助索引。 这提供了使用索引来搜索嵌套数据。 而且，索引是针对不良操作的结果。 索引对不察觉操作的结果的视图提供了对嵌套集合的内容进行索引的能力。 一个这样的不太理想的操作是“不适用”。 这为查询执行计划提供了其他选项，从而导致更优化的查询。 从索引视图向基表提供反向连接，以允许来自索引视图中不存在的基表中的字段包含在使用索引视图处理的表上的查询结果中作为 访问路径 这提供了一种在查询结果中包含不在索引视图中但在基表中的列的方法。 通过独立的集群密钥（作为逻辑行定位符），从单表索引视图向基表支持后连接。 因此，系统可以通过独特的聚类键从索引视图返回到基表。 这些功能允许使用索引视图来索引关于多集或多值属性的内容的表。
-
公开(公告)号：US07254574B2
公开(公告)日：2007-08-07
申请号：US10795623
申请日：2004-03-08
申请人： Conor J. Cunningham , Eric N. Hanson , Milind M. Joshi , Cesar A. Galindo-Legaria , Florian M. Waas
发明人： Conor J. Cunningham , Eric N. Hanson , Milind M. Joshi , Cesar A. Galindo-Legaria , Florian M. Waas
IPC分类号： G06F17/30
CPC分类号： G06F17/30451 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： Indexed views or materialized views are used as a secondary index on a base table with multi-valued attributes. This provides for using the index to search in the nested data. Moreover, indexing is provided on the result of an unnest operation. Indexing a view on the result of an unnesting operation provides the ability to index the contents of a nested collection. One such unnesting operation is “cross apply unnest”. This provides additional options for a query execution plan, leading to a more optimized query. A back-join is provided from the indexed view to the base table to allow fields from the base table that are not present in the indexed view to be included in a result of a query on the table which is processed using the indexed view as an access path. This provides a means of including columns in the query result that are not in the indexed view but are in the base table. The back-join is supported from a single-table indexed view to the base table via a unique clustering key which acts as a logical row locator. Thus, the system can back-join to the base table from an indexed view via the unique clustering key. These features allow the use of indexed views to index a table on the contents of multi-set or multi-valued attributes.
-
公开(公告)号：US07349897B2
公开(公告)日：2008-03-25
申请号：US11051447
申请日：2005-02-04
申请人： Conor J. Cunningham , Eric N. Hanson , Milind M. Joshi , Cesar A. Galindo-Legaria , Florian M. Waas
发明人： Conor J. Cunningham , Eric N. Hanson , Milind M. Joshi , Cesar A. Galindo-Legaria , Florian M. Waas
CPC分类号： G06F17/30451 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： Indexed views or materialized views are used as a secondary index on a base table with multi-valued attributes. This provides for using the index to search in the nested data. Moreover, indexing is provided on the result of an unnest operation. Indexing a view on the result of an unnesting operation provides the ability to index the contents of a nested collection. One such unnesting operation is “cross apply unnest”. This provides additional options for a query execution plan, leading to a more optimized query. A back-join is provided from the indexed view to the base table to allow fields from the base table that are not present in the indexed view to be included in a result of a query on the table which is processed using the indexed view as an access path. This provides a means of including columns in the query result that are not in the indexed view but are in the base table. The back-join is supported from a single-table indexed view to the base table via a unique clustering key which acts as a logical row locator. Thus, the system can back-join to the base table from an indexed view via the unique clustering key. These features allow the use of indexed views to index a table on the contents of multi-set or multi-valued attributes.
-
公开(公告)号：US07769744B2
公开(公告)日：2010-08-03
申请号：US11292679
申请日：2005-12-02
IPC分类号： G06F7/00
CPC分类号： G06F17/30536 , G06F17/30312
摘要： A method of accumulating and aggregating statistics concerning the use of database table indexes includes using a plurality of counters to register index use. The plurality of counters allow multiple instances of index usage to be recorded simultaneously. A missing index may be detected using an optimal index in a query plan. The optimal index is compared against the available indexes to determine if an index is missing. Statistics may be gathered against the used and missing indexes.
摘要翻译： 累积和汇总关于使用数据库表索引的统计的方法包括使用多个计数器来注册索引使用。 多个计数器允许同时记录索引使用的多个实例。 可以使用查询计划中的最佳索引检测到缺失的索引。 将最优索引与可用索引进行比较，以确定索引是否丢失。 可以针对使用和缺失的索引收集统计数据。
-
公开(公告)号：US07640230B2
公开(公告)日：2009-12-29
申请号：US11098949
申请日：2005-04-05
申请人： Eric N. Hanson , Cesar A. Galindo-Legaria , Lubor Kollar , Ganapathy Subramaniam Krishnamoorthy , Sameer Arun Verkhedkar , Evgueni Zabokritski , Erik Ismert
发明人： Eric N. Hanson , Cesar A. Galindo-Legaria , Lubor Kollar , Ganapathy Subramaniam Krishnamoorthy , Sameer Arun Verkhedkar , Evgueni Zabokritski , Erik Ismert
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , Y10S707/99932 , Y10S707/99934
摘要： A system and method for creation, modification and/or use of plan guide(s) is provided. Plan guide(s) can be employed to optimize the performance of query(ies) when it is not possible and/or desirable to change the text of the query directly. Plan guides can be useful, for example, when a small subset of queries in a database application deployed from a third-party vendor is not performing as expected. Plan guides influence optimization of queries by attaching query hints to them. In accordance with an aspect of the subject invention, a query plan execution system is provided. The system includes an execution component, a query optimizer, and, a plan cache. Plan guides and other associated metadata are stored in a plan guide metadata store.
摘要翻译： 提供了一种用于创建，修改和/或使用计划指南的系统和方法。 当不可能和/或希望直接更改查询文本时，可以使用计划指南来优化查询的性能。 计划指南可能是有用的，例如，当从第三方供应商部署的数据库应用程序中的一小部分查询未按预期执行时。 计划指南通过将查询提示附加到他们来影响查询的优化。 根据本发明的一个方面，提供一种查询计划执行系统。 该系统包括一个执行组件，一个查询优化器和一个计划缓存。 计划指南和其他关联的元数据存储在计划指南元数据存储中。
-
公开(公告)号：US07516143B2
公开(公告)日：2009-04-07
申请号：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.
摘要翻译： 高效的层次搜索是基于对象类型的。 通过预先计算附加信息并将其存储在快速查找结构中，可以快速识别满足对象检索请求的对象。 此外，也可以使用该技术来避免商店中的操作的物体水合。 此外，可以利用诸如直方图的数据库统计结构来估计限定对象的数量而不必检查每个对象。
-
公开(公告)号：US07379927B2
公开(公告)日：2008-05-27
申请号：US11244018
申请日：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.
摘要翻译： 高效的层次搜索是基于对象类型的。 通过预先计算附加信息并将其存储在快速查找结构中，可以快速识别满足对象检索请求的对象。 此外，也可以使用该技术来避免商店中的操作的物体水合。 此外，可以利用诸如直方图的数据库统计结构来估计限定对象的数量而不必检查每个对象。
-
公开(公告)号：US07480646B2
公开(公告)日：2009-01-20
申请号：US10692350
申请日：2003-10-23
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.
-
10.发明授权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.
摘要翻译： 提供了一种用于促进对数据库的安全访问的系统和方法。 该系统涉及授权对关系数据库数据的歧视性访问。 更具体地，本发明提供了一种创新技术，其以不能欺骗的方式定义对关系数据库表中的行的安全访问，同时保持各种优化技术。 本发明通过提供一种安全架构来提供持久性方案，从而可以在保持基于集合的关联查询能力的同时定义和实施持久性实体上的歧视性访问策略。 本发明的一个特定方面涉及这些策略的说明以及执行这些策略的技术。 关于本发明的一个具体实现，提供了称为安全描述符的访问控制列表的创建，修改和删除。 安全描述符可以独立于数据库表中的行进行配置，并且可以共享，并且包含与哪些权限相关联的权限被授予谁的策略。
-
-
-
-
-
-
-
-
-
搜索结果
12 条记录 (耗时 0.028 秒)
