利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

8 条记录 (耗时 0.039 秒)

    System for executing a query having multiple distinct key columns
    1.
    发明授权
    System for executing a query having multiple distinct key columns 失效
    用于执行具有多个不同键列的查询的系统

    公开(公告)号：US08041726B2

    公开(公告)日：2011-10-18

    申请号：US12212431

    申请日：2008-09-17

    申请人： Yao-Ching Chen ,  You-Chin Fuh ,  Allan B. Lebovitz ,  Li-Mey Lee ,  Fen-Ling Lin ,  Lee-Chin Hsu Liu ,  Yun Wang ,  Binghua Zhen

    发明人： Yao-Ching Chen ,  You-Chin Fuh ,  Allan B. Lebovitz ,  Li-Mey Lee ,  Fen-Ling Lin ,  Lee-Chin Hsu Liu ,  Yun Wang ,  Binghua Zhen

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

    CPC分类号： G06F17/30595 ,  Y10S707/99933 ,  Y10S707/99937

    摘要： A system and computer readable medium for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The system and computer readable medium includes a capture module for identifying each of the plurality of DISTINCT keys in the query and a sort module coupled to the capture module for determining if more than one sort is needed to execute the query, performing a first DISTINCT operation on a first DISTINCT key of the plurality of DISTINCT keys, storing data fetched from the first DISTINCT operation in a master workfile only if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations on the other of the plurality of DISTINCT keys.

    摘要翻译： 一种用于执行查询以访问存储在数据库中的数据的系统和计算机可读介质，其中所述查询包括多个DISTINCT键。 所述系统和计算机可读介质包括用于识别所述查询中的所述多个DISTINCT密钥中的每一个的捕获模块和耦合到所述捕获模块的分类模块，用于确定是否需要多于一种排序来执行所述查询，执行第一DISTINCT操作 在多个DISTINCT密钥的第一DISTINCT密钥上，仅当需要多于一个排序处理来执行查询时，将从第一个DISTINCT操作获取的数据存储在主工作文件中，并且利用主工作文件执行后续的DISTINCT操作 多个DISTINCT键中的其他键。

    SYSTEM FOR EXECUTING A QUERY HAVING MULTIPLE DISTINCT KEY COLUMNS
    3.
    发明申请
    SYSTEM FOR EXECUTING A QUERY HAVING MULTIPLE DISTINCT KEY COLUMNS 失效
    用于执行具有多个异常键列的查询的系统

    公开(公告)号：US20090012945A1

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

    申请号：US12212431

    申请日：2008-09-17

    申请人： Yao-Ching Chen ,  You-Chin Fuh ,  Allan B. Lebovitz ,  Li-Mey Lee ,  Fen-Ling Lin ,  Lee-Chin Hsu Liu ,  Yun Wang ,  Binghua Zhen

    发明人： Yao-Ching Chen ,  You-Chin Fuh ,  Allan B. Lebovitz ,  Li-Mey Lee ,  Fen-Ling Lin ,  Lee-Chin Hsu Liu ,  Yun Wang ,  Binghua Zhen

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30595 ,  Y10S707/99933 ,  Y10S707/99937

    摘要： A system and computer readable medium for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The system and computer readable medium includes a capture module for identifying each of the plurality of DISTINCT keys in the query and a sort module coupled to the capture module for determining if more than one sort is needed to execute the query, performing a first DISTINCT operation on a first DISTINCT key of the plurality of DISTINCT keys, storing data fetched from the first DISTINCT operation in a master workfile only if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations on the other of the plurality of DISTINCT keys.

    摘要翻译： 一种用于执行查询以访问存储在数据库中的数据的系统和计算机可读介质，其中所述查询包括多个DISTINCT键。 所述系统和计算机可读介质包括用于识别所述查询中的所述多个DISTINCT密钥中的每一个的捕获模块和耦合到所述捕获模块的分类模块，用于确定是否需要多于一种排序来执行所述查询，执行第一DISTINCT操作 在多个DISTINCT密钥的第一DISTINCT密钥上，仅当需要多于一个排序处理来执行查询时，将从第一个DISTINCT操作获取的数据存储在主工作文件中，并且利用主工作文件执行后续的DISTINCT操作 多个DISTINCT键中的其他键。