会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 4. 发明申请
    • FACILITATING VERIFICATION OF CALL LEG SETUP IN THIRD PARTY CALL CONTROL SYSTEMS
    • 促进第三方呼叫控制系统中呼叫设置的验证
    • US20110182281A1
    • 2011-07-28
    • US12693259
    • 2010-01-25
    • Gibran SiddiqueAbhinav Gupta
    • Gibran SiddiqueAbhinav Gupta
    • H04L12/66H04M7/00
    • H04M7/003H04L65/1053H04L65/1069H04M3/42323H04M7/0012H04M2207/20
    • In a third party call control system, a controller sends a command to a PBX for causing the PBX to initiate setup of a call leg between the PBX and a telephone device. The PBX responsively places a telephone call to the telephone device and sends an indicator to the controller that the call is in a ringing state. Responsive to the indicator, the controller subscribes with the PBX for event notification of DTMF tones from the telephone device for verifying the setup of the call leg. Configuration of the PBX for providing the desired event notification to the controller may thus be completed before any DTMF tones arrive at the PBX. This may be true even if an audio channel of the telephone call is established before the PBX receives any indication that the call was answered. Verification of call leg setup by the controller may thus be facilitated.
    • 在第三方呼叫控制系统中,控制器向集团电话发送命令,使集团电话发起PBX和电话设备之间的呼叫支路的建立。 PBX响应地将电话呼叫到电话设备,并向控制器发送呼叫呼叫处于振铃状态的指示符。 响应于指示符,控制器用PBX从电话设备订购DTMF音的事件通知,用于验证呼叫支路的设置。 因此,可以在任何DTMF音到达PBX之前完成用于向控制器提供所需事件通知的PBX的配置。 即使电话呼叫的音频信道在PBX接收到呼叫被应答的任何指示之前建立,也可能是这样。 因此可以方便由控制器验证呼叫线路的设置。
    • 7. 发明授权
    • Evaluation of database hierarchical cubes by nesting rollup operators associated with multiple groupings
    • 通过嵌套与多个分组关联的汇总运算符来评估数据库分层立方体
    • US07035843B1
    • 2006-04-25
    • US10077828
    • 2002-02-15
    • Srikanth BellamkondaAbhinav GuptaAndrew Witkowski
    • Srikanth BellamkondaAbhinav GuptaAndrew Witkowski
    • G06F17/30
    • G06F17/30592G06F17/30489Y10S707/99933
    • Methods are provided for efficiently evaluating database queries including multiple rollup operators. With the computation of grouping identifiers to distinguish grouping levels of each rollup operator, evaluation of database queries that include concatenation of rollup operators includes nesting of the rollup operators and includes the grouping identifiers as sorting keys for subsequent processing. Furthermore, to optimize the query evaluation process, the order in which the rollup operators are computed can be determined based on cardinalities that estimate the number of records generated by each rollup operator, and parallel evaluation can be utilized by partitioning data records between rollup operator processing stages based on the grouping keys associated with the rollup operators that are not being processed at the next stage. If the query includes an algebraic aggregate function, the algebraic function is represented as distributive functions, which are propagated through the evaluation stages and used to compute the algebraic function at the final rollup stage.
    • 提供了有效评估数据库查询(包括多个汇总运算符)的方法。 通过计算分组标识符以区分每个汇总运算符的分组级别,包括汇总运算符的级联的数据库查询的评估包括汇总运算符的嵌套,并且将分组标识符包括为用于后续处理的排序键。 此外,为了优化查询评估过程,可以基于估计每个汇总运算符生成的记录数的基数来确定计算汇总运算符的顺序,并且可以通过在汇总运算符处理之间分割数据记录来利用并行评估 基于与在下一阶段未被处理的汇总运算符相关联的分组密钥的阶段。 如果查询包含代数聚合函数,则代数函数表示为分布函数,通过评估阶段传播,用于计算最终汇总阶段的代数函数。
    • 8. 发明申请
    • Choosing whether to use a delayed index maintenance depending on the portion of the materialized view (MV) changed
    • 根据物化视图(MV)的部分更改是否使用延迟索引维护
    • US20050235003A1
    • 2005-10-20
    • US11083804
    • 2005-03-18
    • Nathaniel FolkertAbhinav GuptaAndrew Witkowski
    • Nathaniel FolkertAbhinav GuptaAndrew Witkowski
    • G06F17/30
    • G06F17/30336G06F17/30312
    • In an embodiment, estimated costs are used to pick the best refresh technique (e.g., method) for a given MV. In another embodiment, estimated costs are used to schedule the refresh of a set MVs in an order such that overall time to refresh is reduced, or in an order that uses the smallest overall time, for refreshing when compared to other alternative refresh schedules. In another embodiment, the estimated cost of refreshing each of a set of MVs is used to select the set of CPU resources to allocate to refreshing each MV. Based on the estimated costs, the allocation of CPU resources is chosen to be more optimal (e.g., use less CPU time) than other available sets of CPU resources. In an embodiment, when refreshing an MV, delayed index maintenance is chosen if a significant portion of the base table and/or the partitions of the table has changed.
    • 在一个实施例中,估计成本用于选择给定MV的最佳刷新技术(例如,方法)。 在另一个实施例中,使用估计成本来按照这样的顺序调度设置的MV的刷新,使得当与其他备选刷新时间表相比时,总体刷新时间减少或以使用最小总体时间的顺序进行刷新。 在另一个实施例中,使用一组MV中的每一个刷新的估计成本来选择要分配以刷新每个MV的CPU资源集合。 基于估计的成本,CPU资源的分配被选择为比其他可用的CPU资源集合更优化(例如,使用更少的CPU时间)。 在一个实施例中,当刷新MV时,如果基表的重要部分和/或表的分区已经改变,则选择延迟索引维护。
    • 9. 发明授权
    • Automatic discovery and use of column correlations in tables
    • 在表中自动发现和使用列相关性
    • US06957225B1
    • 2005-10-18
    • US10160585
    • 2002-05-30
    • Mohamed ZaitAbhinav GuptaBenoit Dageville
    • Mohamed ZaitAbhinav GuptaBenoit Dageville
    • G06F17/30
    • G06F17/30333G06F17/3033G06F17/30492Y10S707/99932Y10S707/99943
    • Methods are provided for automatically discovering correlations between values in columns of tables. A set of significantly correlated columns is identified by identifying correlated columns, and by determining the significance of the correlation between the correlated columns from one or more tables. If the correlated columns are considered significantly correlated, a correlation table is constructed that includes records representing distinct combinations of values corresponding to the correlated columns. Embodiments include methods for identifying correlated columns, for determining the significance of the correlation between the correlated columns, and for using the resultant correlation table to enhance performance of a query execution process. One particular embodiment provides for using a correlation table for partition pruning a partitioned table, with respect to a query execution plan.
    • 提供了用于自动发现表列中的值之间的相关性的方法。 通过识别相关列并通过确定来自一个或多个表的相关列之间的相关性的重要性来识别一组显着相关的列。 如果相关列被认为是显着相关的,则构建相关表,其包括表示与相关列对应的值的不同组合的记录。 实施例包括用于识别相关列的方法,用于确定相关列之间的相关性的重要性,以及使用所得到的相关表来增强查询执行过程的性能。 一个具体实施例提供了使用相关表来分区修剪分区表,相对于查询执行计划。
    • 10. 发明授权
    • Incremental refresh of materialized views with joins and aggregates after arbitrary DML operations to multiple tables
    • 在任意DML操作到多个表之后,将连接和聚合的物化视图的增量刷新
    • US06882993B1
    • 2005-04-19
    • US10059616
    • 2002-01-28
    • Shilpa LawandeAbhinav GuptaBenoit Dageville
    • Shilpa LawandeAbhinav GuptaBenoit Dageville
    • G06F17/30
    • G06F17/30383Y10S707/99932Y10S707/99943
    • A method is provided for incrementally refreshing a materialized view after multiple operations on a row of a base table of the materialized view, by determining an equivalent operation for the multiple operations and refreshing the materialized view according to the equivalent operation. The method is applicable to a materialized view based on multiple base tables on which multiple operations have been performed. The step of determining the equivalent operation can include identifying rows for which an earliest operation is a DELETE operation, or rows for which a latest operation is an INSERT operation, or a combination of the two. The step of refreshing the materialized view includes performing an inverse operation of the equivalent operation to determine a pre-update state of the row, and refreshing the materialized view based on the pre-update state. Additional embodiments are provided which enhance the performance of materialized view refresh queries.
    • 提供一种方法,用于通过确定多个操作的等效操作并根据等效操作刷新物化视图,在物化视图的基表的行上进行多次操作之后逐步刷新物化视图。 该方法适用于基于执行多个操作的多个基表的实例化视图。 确定等效操作的步骤可以包括识别最早操作是DELETE操作的行,或者最近的操作是INSERT操作的行或两者的组合。 刷新物化视图的步骤包括执行等效操作的反向操作以确定行的更新前状态,并且基于更新前状态来刷新物化视图。 提供了增强物化视图刷新查询的性能的另外的实施例。