Executing a query plan with display of intermediate results
    1.
    发明授权
    Executing a query plan with display of intermediate results 失效
    执行显示中间结果的查询计划

    公开(公告)号:US08290936B2

    公开(公告)日:2012-10-16

    申请号:US12857873

    申请日:2010-08-17

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/30463

    摘要: In an embodiment, a FIRSTIO execution plan is selected that has a lowest estimated execution time for finding a number of records that satisfy the query and are simultaneously viewable. An ALLIO execution plan is selected that has a lowest estimated execution time for finding all records that satisfy the query. The FIRSTIO execution plan is executed for a first time period to create a FIRSTIO result set. The ALLIO execution plan is executed for a second time period to create an ALLIO result set. The FIRSTIO result set is displayed if the FIRSTIO result set comprises more records than the ALLIO result set. The ALLIO result set is displayed if the ALLIO result set comprises more records than the FIRSTIO result set. In an embodiment, the first and second time periods expire in response to the expiration of a maximum time specified by the query.

    摘要翻译: 在一个实施例中,选择具有最低估计执行时间的FIRSTIO执行计划,用于查找满足查询并且可同时查看的多个记录。 选择一个ALLIO执行计划,其具有最低的估计执行时间,用于查找满足查询的所有记录。 执行FIRSTIO执行计划第一个时间段以创建FIRSTIO结果集。 ALLIO执行计划在第二个时间段内执行,以创建一个ALLIO结果集。 如果FIRSTIO结果集包含比ALLIO结果集更多的记录,则显示FIRSTIO结果集。 如果ALLIO结果集包含比FIRSTIO结果集更多的记录,则显示ALLIO结果集。 在一个实施例中,响应于由查询指定的最大时间的到期,第一和第二时间段到期。

    EXECUTING A QUERY PLAN WITH DISPLAY OF INTERMEDIATE RESULTS
    2.
    发明申请
    EXECUTING A QUERY PLAN WITH DISPLAY OF INTERMEDIATE RESULTS 失效
    执行查询计划,显示中间结果

    公开(公告)号:US20120047125A1

    公开(公告)日:2012-02-23

    申请号:US12857873

    申请日:2010-08-17

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30463

    摘要: In an embodiment, a FIRSTIO execution plan is selected that has a lowest estimated execution time for finding a number of records that satisfy the query and are simultaneously viewable. An ALLIO execution plan is selected that has a lowest estimated execution time for finding all records that satisfy the query. The FIRSTIO execution plan is executed for a first time period to create a FIRSTIO result set. The ALLIO execution plan is executed for a second time period to create an ALLIO result set. The FIRSTIO result set is displayed if the FIRSTIO result set comprises more records than the ALLIO result set. The ALLIO result set is displayed if the ALLIO result set comprises more records than the FIRSTIO result set. In an embodiment, the first and second time periods expire in response to the expiration of a maximum time specified by the query.

    摘要翻译: 在一个实施例中,选择具有最低估计执行时间的FIRSTIO执行计划,用于查找满足查询并且可同时查看的多个记录。 选择一个ALLIO执行计划,其具有最低的估计执行时间,用于查找满足查询的所有记录。 执行FIRSTIO执行计划第一个时间段以创建FIRSTIO结果集。 ALLIO执行计划在第二个时间段内执行,以创建一个ALLIO结果集。 如果FIRSTIO结果集包含比ALLIO结果集更多的记录,则显示FIRSTIO结果集。 如果ALLIO结果集包含比FIRSTIO结果集更多的记录,则显示ALLIO结果集。 在一个实施例中,响应于由查询指定的最大时间的到期,第一和第二时间段到期。

    Adding entries to an index based on use of the index
    3.
    发明授权
    Adding entries to an index based on use of the index 失效
    根据索引使用索引添加条目

    公开(公告)号:US08396858B2

    公开(公告)日:2013-03-12

    申请号:US13207954

    申请日:2011-08-11

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30312

    摘要: In an embodiment, a threshold value is calculated for a current entry in a first column of an index. If the current entry has been read a number of times by execution of an execution plan that is more than the threshold value and the current entry points to at least one row in a table and not all of the at least one row have been selected by the execution plan for inclusion in a result set as satisfying a query that the execution plan implements, then a new entry is added to the index.

    摘要翻译: 在一个实施例中,针对索引的第一列中的当前条目计算阈值。 如果通过执行超过阈值的执行计划已经读取当前条目多次,并且当前条目指向表中的至少一行,并且并非所有至少一行都已被 包含在结果集中以满足执行计划实现的查询的执行计划,然后将新条目添加到索引。

    ADDING ENTRIES TO AN INDEX BASED ON USE OF THE INDEX
    4.
    发明申请
    ADDING ENTRIES TO AN INDEX BASED ON USE OF THE INDEX 失效
    基于使用索引将索引添加到索引中

    公开(公告)号:US20130041887A1

    公开(公告)日:2013-02-14

    申请号:US13207954

    申请日:2011-08-11

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30312

    摘要: In an embodiment, a threshold value is calculated for a current entry in a first column of an index. If the current entry has been read a number of times by execution of an execution plan that is more than the threshold value and the current entry points to at least one row in a table and not all of the at least one row have been selected by the execution plan for inclusion in a result set as satisfying a query that the execution plan implements, then a new entry is added to the index.

    摘要翻译: 在一个实施例中,针对索引的第一列中的当前条目计算阈值。 如果通过执行超过阈值的执行计划已经读取当前条目多次,并且当前条目指向表中的至少一行,并且并非所有至少一行都已被 包含在结果集中以满足执行计划实现的查询的执行计划,然后将新条目添加到索引。

    DISAPPEARING INDEX FOR MORE EFFICIENT PROCESSING OF A DATABASE QUERY
    5.
    发明申请
    DISAPPEARING INDEX FOR MORE EFFICIENT PROCESSING OF A DATABASE QUERY 有权
    DISAPPEARING INDEX用于更有效地处理数据库查询

    公开(公告)号:US20120124056A1

    公开(公告)日:2012-05-17

    申请号:US12944505

    申请日:2010-11-11

    IPC分类号: G06F17/30

    摘要: A disappearing index allows faster processing of a database query without the startup time of a prior art sparse index. The disappearing index starts as a full index but is trimmed of index values that point to a row in the table that is not selected by the query. Thus the traditional index disappears as it becomes a sparse index tailored to the query. The query is able to execute faster using the now sparse index since the target database table is not accessed for duplicate values in the base table of the query. The query optimizer may determine to use a disappearing index based on estimates of the number of duplicate values in the base table. When the query is complete, the created disappearing table may be discarded or used for other queries that match the selection of the query that created the disappearing index.

    摘要翻译: 消失的索引允许在没有现有技术稀疏索引的启动时间的情况下更快地处理数据库查询。 消失的索引以完整索引开头,但修剪为指向表中未被查询选择的行的索引值。 因此,传统索引随着它成为针对查询量身定制的稀疏索引而消失。 由于查询的基表中的重复值不访问目标数据库表,因此查询能够使用现在的稀疏索引执行更快。 查询优化器可以基于基表中的重复值的估计来确定使用消失的索引。 当查询完成时,创建的消失表可能会被丢弃或用于与创建消失索引的查询的选择相匹配的其他查询。

    Disappearing index for more efficient processing of a database query
    6.
    发明授权
    Disappearing index for more efficient processing of a database query 有权
    消除索引以更有效地处理数据库查询

    公开(公告)号:US08977601B2

    公开(公告)日:2015-03-10

    申请号:US12944505

    申请日:2010-11-11

    IPC分类号: G06F17/30

    摘要: A disappearing index allows faster processing of a database query without the startup time of a prior art sparse index. The disappearing index starts as a full index but is trimmed of index values that point to a row in the table that is not selected by the query. Thus the traditional index disappears as it becomes a sparse index tailored to the query. The query is able to execute faster using the now sparse index since the target database table is not accessed for duplicate values in the base table of the query. The query optimizer may determine to use a disappearing index based on estimates of the number of duplicate values in the base table. When the query is complete, the created disappearing table may be discarded or used for other queries that match the selection of the query that created the disappearing index.

    摘要翻译: 消失的索引允许在没有现有技术稀疏索引的启动时间的情况下更快地处理数据库查询。 消失的索引以完整索引开头,但修剪为指向表中未被查询选择的行的索引值。 因此,传统索引随着它成为针对查询量身定制的稀疏索引而消失。 由于查询的基表中的重复值不访问目标数据库表,因此查询能够使用现在的稀疏索引执行更快。 查询优化器可以基于基表中的重复值的估计来确定使用消失的索引。 当查询完成时,创建的消失表可能会被丢弃或用于与创建消失索引的查询的选择相匹配的其他查询。

    Determining a density of a key value referenced in a database query over a range of rows
    7.
    发明授权
    Determining a density of a key value referenced in a database query over a range of rows 失效
    确定数据库查询在一系列行上引用的密钥值的密度

    公开(公告)号:US08396861B2

    公开(公告)日:2013-03-12

    申请号:US13591935

    申请日:2012-08-22

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30442

    摘要: A method, apparatus and program product that determine a density of a key value referenced in a database query over at least one range of rows, and utilize the determined density to optimize the database query. By doing so, the density of various key values may be determined and compared, and a bit map may be generated over the range of rows of the key value that is denser, resulting in a reduction of resources to build and use the bit map. Moreover, from the bit map over the range of rows to be selected after using the determined density, dense regions may be identified that can be used to optimize block I/O's according to the number of rows to be selected based on the query.

    摘要翻译: 一种方法,装置和程序产品,其通过至少一行行确定数据库查询中引用的密钥值的密度,并利用确定的密度来优化数据库查询。 通过这样做,可以确定和比较各种键值的密度,并且可以在密度较大的键值的行的范围上生成位图,导致减少构建和使用位图的资源。 此外,从使用确定的密度之后要选择的行的范围上的位图中,可以识别出可以根据要根据查询选择的行数来优化块I / O的密集区域。

    Embedding densities in a data structure
    8.
    发明授权
    Embedding densities in a data structure 失效
    在数据结构中嵌入密度

    公开(公告)号:US08140520B2

    公开(公告)日:2012-03-20

    申请号:US12120773

    申请日:2008-05-15

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30442

    摘要: A method, apparatus and program product that determine a density for each key value of a plurality of key values in a table over at least one range of rows in the database table, and store the determined densities in a data structure for use in optimizing a query that references a key value in the plurality of key values in the table. By doing so, the density of various key values may be determined and dynamically maintained, often resulting in optimization data for improved query optimization.

    摘要翻译: 一种方法,装置和程序产品,其通过数据库表中的至少一行行确定表中多个键值的每个键值的密度,并将所确定的密度存储在用于优化数据结构中的数据结构中 查询引用表中的多个键值中的键值。 通过这样做,可以确定和动态地维护各种关键值的密度,通常导致用于改进的查询优化的优化数据。

    Database query optimization using weight mapping to qualify an index
    9.
    发明授权
    Database query optimization using weight mapping to qualify an index 失效
    数据库查询优化使用权重映射来限定索引

    公开(公告)号:US08140517B2

    公开(公告)日:2012-03-20

    申请号:US12419039

    申请日:2009-04-06

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30442

    摘要: A method, apparatus, and program product is provided to, in response to receiving a first database query for which usage of shared weight indices is prohibited, determine whether a shared weight index associated with a column of a database table referenced by the first database query can be utilized as a non-shared weight index to optimize the database query. The method, apparatus, and program product determine whether the column includes at least one changed weight value and determines whether the database query references at least one changed weight value in the column. The shared weight index is utilized to optimize the first database query in response to determining that the shared weight index can be utilized as a non-shared weight index to optimize the first database query.

    摘要翻译: 提供了一种方法,装置和程序产品,用于响应于接收到第一数据库查询,对于共享权重索引的哪个使用被禁止,确定与由第一数据库查询引用的数据库表的列相关联的共享权重索引 可以用作非共享权重索引来优化数据库查询。 方法,装置和程序产品确定列是否包括至少一个改变的权重值,并确定数据库查询是否引用该列中至少一个改变的权重值。 响应于确定共享权重索引可以用作非共享权重索引来优化第一数据库查询,共享权重索引用于优化第一数据库查询。

    Determining a Density of a Key Value Referenced in a Database Query Over a Range of Rows
    10.
    发明申请
    Determining a Density of a Key Value Referenced in a Database Query Over a Range of Rows 失效
    确定在一个范围内的数据库查询中引用的键值的密度

    公开(公告)号:US20090287637A1

    公开(公告)日:2009-11-19

    申请号:US12120706

    申请日:2008-05-15

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30442

    摘要: A method, apparatus and program product that determine a density of a key value referenced in a database query over at least one range of rows, and utilize the determined density to optimize the database query. By doing so, the density of various key values may be determined and compared, and a bit map may be generated over the range of rows of the key value that is denser, resulting in a reduction of resources to build and use the bit map. Moreover, from the bit map over the range of rows to be selected after using the determined density, dense regions may be identified that can be used to optimize block I/O's according to the number of rows to be selected based on the query.

    摘要翻译: 一种方法,装置和程序产品,其通过至少一行行确定数据库查询中引用的密钥值的密度,并利用确定的密度来优化数据库查询。 通过这样做,可以确定和比较各种键值的密度,并且可以在密度较大的键值的行的范围上生成位图,导致减少构建和使用位图的资源。 此外,从使用确定的密度之后要选择的行的范围上的位图中,可以识别出可以根据要根据查询选择的行数来优化块I / O的密集区域。