利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

18 条记录 (耗时 0.029 秒)

    GENERATING STATISTICAL VIEWS IN A DATABASE SYSTEM
    2.
    发明申请
    GENERATING STATISTICAL VIEWS IN A DATABASE SYSTEM 有权
    在数据库系统中生成统计视图

    公开(公告)号：US20130198165A1

    公开(公告)日：2013-08-01

    申请号：US13361800

    申请日：2012-01-30

    申请人： Qi Cheng ,  John F. Hornibrook ,  Ting Y. Leung ,  Xin Wu ,  Daniel C. Zilio ,  Calisto P. Zuzarte

    发明人： Qi Cheng ,  John F. Hornibrook ,  Ting Y. Leung ,  Xin Wu ,  Daniel C. Zilio ,  Calisto P. Zuzarte

    IPC分类号： G06F17/30 ,  G06F7/00

    CPC分类号： G06F17/30463 ,  G06F17/30289

    摘要： Techniques are disclosed for generating statistical views in a database system. In one embodiment, a request is received to execute a database workload. One or more constraints pertaining to executing the database workload is retrieved. The database workload is evaluated to generate multiple statistical view candidates. The statistical view candidates are refined based on the one or more constraints. One or more statistical views are then generated based on the refined statistical view candidates.

    摘要翻译： 公开了用于在数据库系统中生成统计视图的技术。 在一个实施例中，接收到执行数据库工作负载的请求。 检索与执行数据库工作负载有关的一个或多个约束。 评估数据库工作负载以生成多个统计视图候选。 基于一个或多个约束来改进统计视图候选。 然后，基于精细的统计视图候选来生成一个或多个统计视图。

    Executing CASE expressions containing subqueries
    4.
    发明授权
    Executing CASE expressions containing subqueries 有权
    执行包含子查询的CASE表达式

    公开(公告)号：US08626744B2

    公开(公告)日：2014-01-07

    申请号：US13358779

    申请日：2012-01-26

    申请人： Qi Cheng ,  John F. Hornibrook ,  Jose A. Saborit ,  David C. Sharpe ,  Calisto P. Zuzarte

    发明人： Qi Cheng ,  John F. Hornibrook ,  Jose A. Saborit ,  David C. Sharpe ,  Calisto P. Zuzarte

    IPC分类号： G06F7/00 ,  G06F17/30

    CPC分类号： G06F17/30483

    摘要： Methods and apparatus, including computer program products, implementing and using techniques for executing a query in a computer to retrieve data from a relational database stored on a data storage device. A query is received that contains a CASE expression having one or more subqueries. A query execution plan is generated. The query execution plan uses a parameterized union all operator to keep the semantics of the CASE expression, and a nested loop join operator to drive data across the section of the query execution plan that executes the CASE expression without performing any join operations. The generated query execution plan is executed in the computer to retrieve data from the relational database.

    摘要翻译： 方法和装置，包括计算机程序产品，用于在计算机中执行查询以从存储在数据存储设备上的关系数据库中检索数据的实现和使用技术。 接收到包含具有一个或多个子查询的CASE表达式的查询。 生成查询执行计划。 查询执行计划使用参数化的联合所有运算符来保留CASE表达式的语义，以及嵌套循环连接运算符来驱动执行CASE表达式的查询执行计划部分中的数据，而不执行任何连接操作。 生成的查询执行计划在计算机中执行以从关系数据库检索数据。

    Executing CASE Expressions Containing Subqueries
    5.
    发明申请
    Executing CASE Expressions Containing Subqueries 有权
    执行包含子查询的CASE表达式

    公开(公告)号：US20130198164A1

    公开(公告)日：2013-08-01

    申请号：US13358779

    申请日：2012-01-26

    申请人： Qi Cheng ,  John F. Hornibrook ,  Jose A. Saborit ,  David C. Sharpe ,  Calisto P. Zuzarte

    发明人： Qi Cheng ,  John F. Hornibrook ,  Jose A. Saborit ,  David C. Sharpe ,  Calisto P. Zuzarte

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30483

    摘要： Methods and apparatus, including computer program products, implementing and using techniques for executing a query in a computer to retrieve data from a relational database stored on a data storage device. A query is received that contains a CASE expression having one or more subqueries. A query execution plan is generated. The query execution plan uses a parameterized union all operator to keep the semantics of the CASE expression, and a nested loop join operator to drive data across the section of the query execution plan that executes the CASE expression without performing any join operations. The generated query execution plan is executed in the computer to retrieve data from the relational database.

    摘要翻译： 方法和装置，包括计算机程序产品，用于在计算机中执行查询以从存储在数据存储设备上的关系数据库中检索数据的实现和使用技术。 接收到包含具有一个或多个子查询的CASE表达式的查询。 生成查询执行计划。 查询执行计划使用参数化的联合所有运算符来保留CASE表达式的语义，以及嵌套循环连接运算符来驱动执行CASE表达式的查询执行计划部分中的数据，而不执行任何连接操作。 生成的查询执行计划在计算机中执行以从关系数据库检索数据。

    System and method for transforming queries using window aggregation
    6.
    发明授权
    System and method for transforming queries using window aggregation 有权
    使用窗口聚合转换查询的系统和方法

    公开(公告)号：US07275056B2

    公开(公告)日：2007-09-25

    申请号：US10425343

    申请日：2003-04-29

    申请人： Qi Cheng ,  Linqi Liu ,  Wenbin Ma ,  Mir Hamid Pirahesh ,  Calisto P. Zuzarte

    发明人： Qi Cheng ,  Linqi Liu ,  Wenbin Ma ,  Mir Hamid Pirahesh ,  Calisto P. Zuzarte

    IPC分类号： G06F7/00 ,  G06F17/30

    CPC分类号： G06F17/30451 ,  Y10S707/99934 ,  Y10S707/99935

    摘要： A system and method transform queries with subqueries, using window aggregation. An optimizer in a relational database management system transforms queries to optimize their efficiency and speed. The method transforms queries that have a subquery, replacing the subquery with a window aggregation function. In the case of a correlated subquery, the window aggregation function is partitioned by a correlated column of a correlated table. All data in the main select clause, or outer block, of the query that was obtained through references to the correlated table is instead obtained through the new window aggregation subquery. By using window aggregation, the aggregation is performed at the same time as the selection of relevant data from the correlated table, thereby compiling all needed data in a single pass through the table or view. Reducing the number of times that tables or views are accessed reduces the computational demands of a query.

    摘要翻译： 系统和方法使用子查询转换查询，使用窗口聚合。 关系数据库管理系统中的优化器可以转换查询以优化其效率和速度。 该方法转换具有子查询的查询，使用窗口聚合函数替换子查询。 在相关子查询的情况下，窗口聚合函数由相关表的相关列划分。 通过引用相关表获得的查询的main select子句或外部块中的所有数据都是通过新的窗口聚合子查询得到的。 通过使用窗口聚合，在从相关表中选择相关数据的同时进行聚合，从而在通过表或视图的单次传递中编译所有需要的数据。 降低访问表或视图的次数减少了查询的计算需求。

    SYSTEM FOR AGGREGATION SUBQUERY JOIN ELIMINATION
    7.
    发明申请
    SYSTEM FOR AGGREGATION SUBQUERY JOIN ELIMINATION 失效
    集体救助系统

    公开(公告)号：US20080306906A1

    公开(公告)日：2008-12-11

    申请号：US12193585

    申请日：2008-08-18

    申请人： Calisto P. Zuzarte ,  Qi Cheng ,  Wenbin Ma

    发明人： Calisto P. Zuzarte ,  Qi Cheng ,  Wenbin Ma

    IPC分类号： G06F7/06 ,  G06F17/30

    CPC分类号： G06F17/30979 ,  Y10S707/99933 ,  Y10S707/99934

    摘要： A system for use with an information retrieval system, in which system is used for transforming a database statement containing a first subquery and a second subquery joined together, the first subquery including a group by operation over a child subquery, the information retrieval system comprising means for removing the first subquery from the database statement thereby eliminating the join between the first subquery and the second subquery.

    摘要翻译： 一种与信息检索系统一起使用的系统，其中所述系统用于变换包含连接在一起的第一子查询和第二子查询的数据库语句，所述第一子查询包括通过子查询的操作的组，所述信息检索系统包括装置 用于从数据库语句中删除第一个子查询，从而消除了第一个子查询和第二个子查询之间的连接。

    Apparatus and system for reducing locking in materialized query tables
    8.
    发明授权
    Apparatus and system for reducing locking in materialized query tables 失效
    用于减少物化查询表中锁定的装置和系统

    公开(公告)号：US08112414B2

    公开(公告)日：2012-02-07

    申请号：US12200674

    申请日：2008-08-28

    申请人： James P. Bates ,  Jonathan Sloan ,  Calisto P. Zuzarte

    发明人： James P. Bates ,  Jonathan Sloan ,  Calisto P. Zuzarte

    IPC分类号： G06F7/00 ,  G06F17/30

    CPC分类号： G06F17/30362 ,  G06F17/30377

    摘要： Disclosed is an apparatus and system for reducing locking in materialized query tables (MQT) for distributive functions. The apparatus includes an insert module that inserts into an MQT table a child record when a new record is inserted into a base table associated with the MQT. The child record includes values associated with the insert operation. Also included is a delete module that inserts into the MQT a child record that includes measure values that are the negative of the measure values in the base table row that is the subject of the delete operation. An update module inserts two child rows into the MQT, one negating the affected record and the other adding the values of the update operation. Each inserted child row includes a unique identifier that relates the inserted row to a parent row. An execution module generates responses using the values indicated by the cumulative records in a family.

    摘要翻译： 公开了用于减少用于分配功能的物化查询表（MQT）中的锁定的装置和系统。 该装置包括插入模块，当将新记录插入到与MQT相关联的基表中时，插入到MQT表中的子记录。 子记录包括与插入操作相关联的值。 还包括一个删除模块，将删除模块插入到包含测量值的子记录中，该测量值是作为删除操作主题的基表行中度量值的负值。 更新模块将两个子行插入到MQT中，一个对待受影响的记录，另一个添加更新操作的值。 每个插入的子行包含将插入的行与父行相关联的唯一标识符。 执行模块使用家庭中累积记录指示的值生成响应。

    Method and system for index sampled tablescan
    9.
    发明授权
    Method and system for index sampled tablescan 失效
    索引采样表的方法和系统

    公开(公告)号：US07680821B2

    公开(公告)日：2010-03-16

    申请号：US10215073

    申请日：2002-08-07

    申请人： Ian R. Finlay ,  Calisto P. Zuzarte

    发明人： Ian R. Finlay ,  Calisto P. Zuzarte

    IPC分类号： G06F17/00

    CPC分类号： G06F17/30321 ,  G06F17/30463

    摘要： An optimized query processing system and method for a database system. The database system includes a table of data and an index correlated to both the query and to the table. The optimized query processing system includes an index accessing module adapted to access the index to determine if the table contains an entry satisfying a query predicate; and a tablescan module for scanning substantially the entire table and retrieving data satisfying the query. A method is also disclosed for generating database diagnostic data.

    摘要翻译： 一种用于数据库系统的优化查询处理系统和方法。 数据库系统包括数据表和与查询和表相关的索引。 所述优化查询处理系统包括适于访问所述索引的索引访问模块，以确定所述表是否包含满足查询谓词的条目; 以及用于基本扫描整个表并检索满足查询的数据的桌面模块。 还公开了一种用于生成数据库诊断数据的方法。

    Method, system and program for joining source table rows with target table rows
    10.
    发明授权
    Method, system and program for joining source table rows with target table rows 失效
    将源表行与目标表行连接的方法，系统和程序

    公开(公告)号：US07512625B2

    公开(公告)日：2009-03-31

    申请号：US11095619

    申请日：2005-04-01

    申请人： Josep L. Lariba-Pey ,  Victor Muntés-Mulero ,  Hebert W. Pereyra ,  Josep Aguilar-Saborit ,  Calisto P. Zuzarte

    发明人： Josep L. Lariba-Pey ,  Victor Muntés-Mulero ,  Hebert W. Pereyra ,  Josep Aguilar-Saborit ,  Calisto P. Zuzarte

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30466 ,  G06F17/30498 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99943

    摘要： Disclosed is a data processing system implemented method, a data processing system, and an article of manufacturing for use with the data processing system. The data processing system implemented method is used for directing the data processing system to join rows associated with a column of a source table with rows associated with a column of a target table. The data processing system includes a source node containing the source table and including a target node containing the target table. The method includes generating a reduced representation of selected rows associated with the column of the source table, and generating a representation of the column of the target table, filtering the generated reduced representation of selected rows associated with the column of the source table through the generated representation of the column of the target table, the filtered generated reduced representation of selected rows identifying source table rows that do not have to be joined with the target table, and joining, to the rows associated with the column of the target table, the rows associated with the column of the source table minus the filtered generated reduced representation of selected rows.

    摘要翻译： 公开了一种与数据处理系统一起使用的数据处理系统实现方法，数据处理系统和制造物品。 数据处理系统实现的方法用于指导数据处理系统连接与源表的列相关联的行，该行与目标表的列相关联。 数据处理系统包括包含源表并包括目标表的目标节点的源节点。 该方法包括生成与源表的列相关联的所选行的缩小表示，以及生成目标表的列的表示，通过生成的对源表的列相关联的所选行的过滤生成的缩小表示 目标表的列的表示，被筛选的生成的缩小表示，标识不必与目标表连接的源表行，并且将与加入目标表的列相关联的行加入到行中 与源表的列减去所筛选的生成的所选行的缩小表示相关联。