ANALYSIS SYSTEM, COMPUTER SYSTEM, AND ANALYSIS METHOD
    114.
    发明申请
    ANALYSIS SYSTEM, COMPUTER SYSTEM, AND ANALYSIS METHOD 有权
    分析系统,计算机系统和分析方法

    公开(公告)号:US20150149439A1

    公开(公告)日:2015-05-28

    申请号:US14404525

    申请日:2012-05-31

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30445 G06F17/30557

    摘要: This analysis system analyzes the behavior of a DBMS in a computer system having a computer which executes tasks in parallel and reads data from a database (DB) when executing a query. This analysis system acquires the number of selected rows corresponding to a key value of an index key used in the query, and calculates a model-based predicted degree of processing parallelism of the processing corresponding to the query. The system acquires, from the storage device, event information on an input-output event with respect to the storage medium when the processing corresponding to the query is executed actually, calculates a measured degree of processing parallelism when the processing corresponding to the query is executed actually, based on the event information, and displays information based on the model-based predicted degree of processing parallelism and the measured degree of processing parallelism.

    摘要翻译: 该分析系统分析具有并行执行任务的计算机的计算机系统中的DBMS的行为,并且在执行查询时从数据库(DB)读取数据。 该分析系统获取与查询中使用的索引关键字键对应的所选行数,并计算与查询对应的处理的基于模型的预测处理并行度。 当实际执行与查询对应的处理时,系统从存储装置获取关于存储介质的输入 - 输出事件的事件信息,当执行与查询相对应的处理时,计算测量的处理并行度 实际上,基于事件信息,并且基于基于模型的预测处理并行度和所测量的处理并行度来显示信息。

    Database processing system and method
    116.
    发明授权
    Database processing system and method 有权
    数据库处理系统和方法

    公开(公告)号:US08510316B2

    公开(公告)日:2013-08-13

    申请号:US12543826

    申请日:2009-08-19

    IPC分类号: G06F7/24

    CPC分类号: G06F17/30454

    摘要: Provided is a database system in which sorting of query results is sped up. The database system stores storage location information in which storage locations of the pieces of data are recorded in a given order. When there is no second task, which is executed based on data that is fetched in a first task, whether every piece of data requested in a third task, which is executed before the first task, has been fetched is determined. In the case where every piece of data requested in the third task has been fetched, data fetched in the first task is output. In the case where some of the data requested in the third task has not been fetched, data fetched in the first task is kept in a temporary buffer until every piece of data requested in the third task is fetched, and then output.

    摘要翻译: 提供了一种数据库系统,其中查询结果的排序加快。 数据库系统存储以给定顺序记录数据段的存储位置的存储位置信息。 当不存在基于在第一任务中获取的数据而执行的第二任务时,确定在第一任务之前执行的第三任务中请求的每个数据片段是否已被获取。 在第三任务中请求的每个数据片段被取出的情况下,输出在第一任务中取出的数据。 在第三任务中请求的一些数据尚未获取的情况下,将第一任务中提取的数据保存在临时缓冲区中,直到第三个任务中请求的每个数据片段被提取,然后输出。

    DATABASE PROCESSING METHOD, DATABASE PROCESSING SYSTEM AND DATABASE SERVER
    117.
    发明申请
    DATABASE PROCESSING METHOD, DATABASE PROCESSING SYSTEM AND DATABASE SERVER 有权
    数据库处理方法,数据库处理系统和数据库服务器

    公开(公告)号:US20130144867A1

    公开(公告)日:2013-06-06

    申请号:US13814976

    申请日:2011-01-31

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30463 G06F17/30486

    摘要: It is provided a database processing method including: a first step of receiving a query request instructing to output the requested data as query results in a designated order; a second step of generating a query execution plan including an order of accessing tables for storing the data based on the received query request; a third step of acquiring the data requested based on the query request from the database based on the generated query execution plan; a fourth step of generating intermediate results including the acquired data; a fifth step of sorting the generated intermediate results in the designated order; a sixth step of judging, for each of the intermediate results, whether an order of the sorted intermediate results has been determined; and a seventh step of outputting the intermediate results whose order has been determined as the query results in order from a head thereof.

    摘要翻译: 提供了一种数据库处理方法,包括:第一步骤,以指定的顺序接收指示以请求数据作为查询结果输出的查询请求; 生成查询执行计划的第二步骤,所述查询执行计划包括基于接收的查询请求访问用于存储数据的表的顺序; 基于所生成的查询执行计划,从数据库获取基于查询请求所请求的数据的第三步骤; 产生包括所获取的数据的中间结果的第四步骤; 以指定的顺序排列所生成的中间结果的第五步骤; 对于每个中间结果,判断排序的中间结果的顺序是否已被确定的第六步骤; 以及从其头部按顺序输出其顺序已被确定为查询结果的中间结果的第七步骤。

    System executing log data transfer synchronously and database data transfer asynchronously
    119.
    发明授权
    System executing log data transfer synchronously and database data transfer asynchronously 有权
    系统同步执行日志数据传输和异步数据库数据传输

    公开(公告)号:US07890461B2

    公开(公告)日:2011-02-15

    申请号:US10819191

    申请日:2004-04-07

    IPC分类号: G06F7/00 G06F17/00

    摘要: A disaster recovery system and a method therefor, having: a function for receiving write requests from a host computer to write log information indicating the contents of a database process executed for a database buffer on a main site, database data updated on the database buffer and status information indicating the position of log information used for disaster recovery; a function for transferring the received write request for log information to a recovery site by a synchronous remote copy process; and a function for transferring the received write request for database data to the recovery site by an asynchronous remote copy process. While remote copy can be executed at a long distance without data loss, the deterioration of the performance of a database process on a main site can be suppressed.

    摘要翻译: 一种灾难恢复系统及其方法,具有:接收来自主计算机的写入请求的功能,用于写入表示在主站点上为数据库缓冲器执行的数据库处理的内容的日志信息,数据库缓冲器上更新的数据库数据, 指示用于灾难恢复的日志信息的位置的状态信息; 用于通过同步远程复制处理将接收到的日志信息写入请求传送到恢复站点的功能; 以及通过异步远程复制处理将接收的数据库数据写入请求传送到恢复站点的功能。 虽然远程复制可以在没有数据丢失的情况下长时间执行,但是可以抑制主站点上的数据库处理的性能的恶化。

    Method, program and apparatus for document retrieval system
    120.
    发明授权
    Method, program and apparatus for document retrieval system 有权
    文件检索系统的方法,程序和装置

    公开(公告)号:US07620614B2

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

    申请号:US11625983

    申请日:2007-01-23

    IPC分类号: G06F17/30 G06F12/00

    摘要: The present invention realize a high speed retrieval performance in a document retrieval system referring to partial data of documents including structured data such as XML documents and electric mails, without providing further memory. The present invention includes storage means for storing documents to be retrieved onto a disk device, a calculation means for calculating an allocated capacity of the memory, and storage means for saving, onto the memory, partial data of the documents stored on the disk device by the calculated allocated capacity of the memory. The present invention also includes a first retrieval means for retrieving partial data stored on the memory, determining means for determining whether or not to retrieve the documents stored on the disk device based on the result from the first retrieval, and a second means for retrieving the documents stored on the disk device based on the result from the above determination.

    摘要翻译: 本发明在文件检索系统中实现高速检索性能,参考包括诸如XML文档和电子邮件的结构化数据的文档的部分数据,而不提供进一步的存储器。 本发明包括用于存储要被检索到盘装置上的文件的存储装置,用于计算存储器的分配容量的计算装置,以及存储装置,用于将存储在盘装置上的文件的部分数据保存在存储器中 计算出的内存分配容量。 本发明还包括用于检索存储在存储器上的部分数据的第一检索装置,用于基于第一检索的结果来确定是否检索存储在磁盘装置上的文档的确定装置,以及用于检索 基于上述确定的结果存储在磁盘设备上的文档。