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

1. 发明申请

US20060248046A1 System and method for forcing a query execution plan 有权
标题翻译：用于强制查询执行计划的系统和方法
公开(公告)号：US20060248046A1
公开(公告)日：2006-11-02
申请号：US11117586
申请日：2005-04-28
申请人： Cesar Galindo-Legaria , Ganapathy Krishnamoorthy , Eric Hanson , Wei Yu , Milind Joshi
发明人： Cesar Galindo-Legaria , Ganapathy Krishnamoorthy , Eric Hanson , Wei Yu , Milind Joshi
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30474 , Y10S707/99932 , Y10S707/99933
摘要： A suggested query execution plan is used as a constraint on a guided optimization process such that all execution plans that do not conform to the suggested execution plan are eliminated as possible alternatives. If the guided optimization process successfully generates a resulting execution plan, then the result will conform to the suggested execution plan. If the guided optimization process fails to generate a resulting execution plan, then it may be determined that the suggested execution plan is invalid.
摘要翻译：建议的查询执行计划被用作引导优化过程的约束，使得不符合建议的执行计划的所有执行计划作为可能的替代方案被消除。如果引导优化过程成功生成结果执行计划，则结果将符合建议的执行计划。如果引导优化过程无法生成结果执行计划，则可以确定建议的执行计划无效。

2. 发明授权

US07464071B2 System and method for forcing a query execution plan 有权
标题翻译：用于强制查询执行计划的系统和方法
公开(公告)号：US07464071B2
公开(公告)日：2008-12-09
申请号：US11117586
申请日：2005-04-28
申请人： Cesar Galindo-Legaria , Ganapathy Krishnamoorthy , Eric N. Hanson , Wei Yu , Milind Joshi
发明人： Cesar Galindo-Legaria , Ganapathy Krishnamoorthy , Eric N. Hanson , Wei Yu , Milind Joshi
IPC分类号： G06F7/00
CPC分类号： G06F17/30463 , G06F17/30474 , Y10S707/99932 , Y10S707/99933
摘要： A suggested query execution plan is used as a constraint on a guided optimization process such that all execution plans that do not conform to the suggested execution plan are eliminated as possible alternatives. If the guided optimization process successfully generates a resulting execution plan, then the result will conform to the suggested execution plan. If the guided optimization process fails to generate a resulting execution plan, then it may be determined that the suggested execution plan is invalid.
摘要翻译：建议的查询执行计划被用作引导优化过程的约束，使得不符合建议的执行计划的所有执行计划作为可能的替代方案被消除。如果引导优化过程成功生成结果执行计划，则结果将符合建议的执行计划。如果引导优化过程无法生成结果执行计划，则可以确定建议的执行计划无效。

3. 发明申请

US20050198001A1 Structured indexes on results of function applications over data 有权
标题翻译：功能应用程序对数据结果的结构化索引
公开(公告)号：US20050198001A1
公开(公告)日：2005-09-08
申请号：US11051360
申请日：2005-02-04
申请人： Conor Cunningham , Eric Hanson , Milind Joshi , Cesar Galindo-Legaria , Florian Waas
发明人： Conor Cunningham , Eric Hanson , Milind Joshi , Cesar Galindo-Legaria , Florian Waas
IPC分类号： G06F7/00 , G06F12/00 , 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.
摘要翻译：索引视图或物化视图用作具有多值属性的基表上的辅助索引。这提供了使用索引来搜索嵌套数据。而且，索引是针对不良操作的结果。索引对不察觉操作的结果的视图提供了对嵌套集合的内容进行索引的能力。一个这样的不太理想的操作是“不适用”。这为查询执行计划提供了其他选项，从而导致更优化的查询。从索引视图向基表提供反向连接，以允许来自索引视图中不存在的基表中的字段包含在使用索引视图处理的表上的查询结果中作为访问路径这提供了一种在查询结果中包含不在索引视图中但在基表中的列的方法。通过独立的集群密钥（作为逻辑行定位符），从单表索引视图向基表支持后连接。因此，系统可以通过独特的聚类键从索引视图返回到基表。这些功能允许使用索引视图来索引关于多集或多值属性的内容的表。

4. 发明申请

US20050198019A1 Structured indexes on results of function applications over data 有权
公开(公告)号：US20050198019A1
公开(公告)日：2005-09-08
申请号：US11096149
申请日：2005-03-31
申请人： Conor Cunningham , Eric Hanson , Milind Joshi , Cesar Galindo-Legaria , Florian Waas
发明人： Conor Cunningham , Eric Hanson , Milind Joshi , Cesar Galindo-Legaria , Florian Waas
IPC分类号： G06F7/00 , G06F12/00 , 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.

5. 发明申请

US20050198013A1 Structured indexes on results of function applications over data 有权
公开(公告)号：US20050198013A1
公开(公告)日：2005-09-08
申请号：US10795623
申请日：2004-03-08
申请人： Conor Cunningham , Eric Hanson , Milind Joshi , Cesar Galindo-Legaria , Florian Waas
发明人： Conor Cunningham , Eric Hanson , Milind Joshi , Cesar Galindo-Legaria , Florian Waas
IPC分类号： G06F7/00 , G06F12/00 , 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.

6. 发明申请

US20050198016A1 Structured indexes on results of function applications over data 有权
公开(公告)号：US20050198016A1
公开(公告)日：2005-09-08
申请号：US11051447
申请日：2005-02-04
申请人： Conor Cunningham , Eric Hanson , Milind Joshi , Cesar Galindo-Legaria , Florian Waas
发明人： Conor Cunningham , Eric Hanson , Milind Joshi , Cesar Galindo-Legaria , Florian Waas
IPC分类号： G06F7/00 , G06F12/00 , 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.

7. 发明申请

US20050050041A1 Use of statistic on view in query optimization 失效
标题翻译：在查询优化中使用统计信息
公开(公告)号：US20050050041A1
公开(公告)日：2005-03-03
申请号：US10652423
申请日：2003-08-29
申请人： Cesar Galindo-Legaria , Milind Joshi
发明人： Cesar Galindo-Legaria , Milind Joshi
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30536 , Y10S707/99933 , Y10S707/99934
摘要： A query optimizer produces a preferred execution plan by utilizing statistics on views. These provide the optimizer with statistical information beyond that available on tables, for example, with information on the result of scalar or relational expressions. Pre-derived accurate statistics are thus available which are used to improve the accuracy of estimation and thus increase the quality and reliability of the query processor. Transformations of expressions and sub-expressions of candidate plans produce equivalent sub-expressions. Where those sub-expressions include references to views, an estimation of the cardinality and other execution statistics for the sub-expression can be made using the view statistics. This can be used to estimate the cardinality for all equivalent sub-expressions, leading to higher accuracy for the estimate.
摘要翻译：查询优化器通过利用视图统计信息生成首选执行计划。这些为优化器提供超出表上可用的统计信息，例如，具有关于标量或关系表达式的结果的信息。因此，可以使用预先导出的精确统计量来提高估计的准确性，从而提高查询处理器的质量和可靠性。候选计划的表达式和子表达式的转换产生等效的子表达式。在这些子表达式包括对视图的引用的情况下，可以使用视图统计信息来估计子表达式的基数和其他执行统计信息。这可以用于估计所有等效子表达式的基数，导致估计的更高的准确性。

8. 发明申请

US20050097100A1 System and method for segmented evaluation of database queries 失效
标题翻译：数据库查询分段评估的系统和方法
公开(公告)号：US20050097100A1
公开(公告)日：2005-05-05
申请号：US10998761
申请日：2004-11-29
申请人： Cesar Galindo-Legaria , Goetz Graefe , Milind Joshi , Ross Bunker
发明人： Cesar Galindo-Legaria , Goetz Graefe , Milind Joshi , Ross Bunker
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30501 , G06F17/3046 , G06F17/30466 , G06F17/30498 , Y10S707/99933 , Y10S707/99943
摘要： A method of satsfying a database query includes evaluating certain joins on a per-segment basis. An expression tree is produced for the query, and the expression tree is evaluated to identify joins whose operands are two instances of the same relation and whose join predicate conjunctively includes an equality comparison between two instances of the same column. When such a join is identified, it may be evaluated by segmenting the operand relation according to the columns that are compared for equality in the predicate. The join is then evaluated by performing the join operation separately on each segment. Segments may be spooled separately, thereby exploiting the efficiencies obtained by spooling even where the entire relation is too large to fit in the spool. Execution iterators are provided for spooling successive segments and for applying the join to the spooled segment.
摘要翻译：饱和数据库查询的方法包括基于每个段来评估某些联接。为查询生成表达式树，并且对表达式树进行评估，以标识其操作数是相同关系的两个实例的连接，并且其连接谓词连接地包含同一列的两个实例之间的等效比较。当识别出这样的连接时，可以通过根据在谓词中的相等性进行比较的列分割操作数关系来评估操作数关系。然后通过在每个段上分别执行连接操作来评估连接。分段可以单独地卷绕，从而利用即使在整个关系太大而不能装入卷轴的情况下通过卷绕获得的效率。提供执行迭代器用于假脱机连续的段并将连接应用到假脱机段。

9. 发明申请

US20120245389A1 PROCESS FOR HYDROGENATING NITRILES 审中-公开
标题翻译：加氢处理方法
公开(公告)号：US20120245389A1
公开(公告)日：2012-09-27
申请号：US13427308
申请日：2012-03-22
申请人： Christof Wilhelm Wigbers , Christoph Müller , Wolfgang Mägerlein , Martin Ernst , Thomas Heidemann , Johann-Peter Melder , Lucia Königsmann , Milind Joshi , Oliver Bey , Bernd Stein
发明人： Christof Wilhelm Wigbers , Christoph Müller , Wolfgang Mägerlein , Martin Ernst , Thomas Heidemann , Johann-Peter Melder , Lucia Königsmann , Milind Joshi , Oliver Bey , Bernd Stein
IPC分类号： C07C209/48
CPC分类号： C07C209/48 , C07C2601/14 , C07C211/36 , C07C211/09
摘要： The present invention relates to a process for hydrogenating organic nitriles by means of hydrogen in the presence of a catalyst in a reactor, where the shaped body catalyst is arranged in a fixed bed, wherein the shaped body in the shape of spheres or rods has in each case a diameter 3 mm or less, in the shape of tablets a height of 4 mm or less, and in the case of all other geometries in each case has an equivalent diameter L=1/a′ of 0.70 mm or less, where a′ is the external surface area per unit volume (mms2/mmp3), where: a ′ = A p V p , where Ap is the external surface area of the catalyst particle (mms2) and Vp is the volume of the catalyst particle (mmp3). The present invention further relates to a process for preparing downstream products of isophoronediamine (IPDA) or N,N-dimethylaminopropylamine (DMAPA) from amines prepared according to the invention.
摘要翻译：本发明涉及一种在反应器中催化剂存在下通过氢气氢化有机腈的方法，其中成形体催化剂布置在固定床中，其中球体或棒状的成形体具有每个壳体的直径为3mm以下，片状形状为4mm以下，在各种情况下，所有其他几何形状的等效直径L = 1 / a'为0.70mm以下，其中 a'是每单位体积的外表面积（mms2 / mmp3），其中：a'= A p V p，其中Ap是催化剂颗粒的外表面积（mms2），Vp是催化剂颗粒的体积 mmp3）。本发明还涉及由根据本发明制备的胺制备异佛尔酮二胺（IPDA）或N，N-二甲基氨基丙胺（DMAPA）的下游产物的方法。

10. 发明申请

US20060257507A1 Herbal cough formulations and process for the preparation thereof 审中-公开
标题翻译：草药咳嗽配方及其制备方法
公开(公告)号：US20060257507A1
公开(公告)日：2006-11-16
申请号：US11345895
申请日：2006-02-02
申请人： Madhukat Doshi , Shashikant Vasavada , Milind Joshi , Shirish Mody
发明人： Madhukat Doshi , Shashikant Vasavada , Milind Joshi , Shirish Mody
IPC分类号： A61K36/67 , A61K36/886 , A61K36/53 , A61K36/906 , A61K36/48 , A61K36/28
CPC分类号： A61K36/00 , A61K2300/00
摘要： The present invention relates to an herbal composition which is non-alcoholic, non-sedating and non-freezing in nature for the treatment of chronic respiratory disorders such as cold, cough, allergic asthma, seasonal allergic rhinitis, pharyngitis, laryngitis and the like and a process for preparing the same. The process comprises procuring, cleaning, grading of specified herbal plants per the standard specification, disintegrating and pulverizing separately to form coarse powder, then macerating individual powders separately with aqueous solution of preservatives, then extracting, filtering, concentrating and spray drying to make dry extract powder or semisolid soft extract. Further dissolving each of the extracts separately in aqueous solution containing preservatives and then allowing to maturate after mixing. Then adding filtered extracts to the sugar syrup containing preservatives, glycerin and appropriate excipients to obtain a homogenous cough syrup.
摘要翻译：本发明涉及用于治疗慢性呼吸系统疾病如感冒，咳嗽，过敏性哮喘，季节性过敏性鼻炎，咽炎，喉炎等的非酒精性，非镇静性和非冷冻性的草药组合物，其制备方法。该方法包括按照标准规范采购，清洗，分级指定草药，分解粉碎，形成粗粉，然后分别用防腐剂水溶液浸渍个别粉末，然后提取，过滤，浓缩和喷雾干燥，制成干提取物粉末或半固体软提取物。进一步将各提取物分别溶解在含有防腐剂的水溶液中，然后在混合后使其成熟。然后将过滤的提取物加入到含有糖浆的防腐剂，甘油和适当的赋形剂中以获得均匀的止咳糖浆。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式