Search method and apparatus for plural databases
    1.
    发明申请
    Search method and apparatus for plural databases 审中-公开
    多个数据库的搜索方法和装置

    公开(公告)号:US20080183689A1

    公开(公告)日:2008-07-31

    申请号:US12075373

    申请日:2008-03-11

    CPC classification number: G06F16/2471 G06F16/835

    Abstract: In a search method, integration metadata is newly introduced in which structure data defining an output structure of a query result, a correspondence relation between elements in the structure data and elements in databases, an association of elements between the databases and a bi-directional conversion function applied to said association of said elements between said databases or a specific element of said databases are defined. And, this search method includes: accepting a query of integrated data reference for a plurality of databases; extracting a value of an element in database, which corresponds to the top-level element in a structure identified from the integration metadata in a integration metadata storage by upwardly tracing the structure based on the query; extracting a value of each element in each database by downwardly tracing the structure based on a value of an element in the database, which corresponding to the top-level element in the structure; and outputting the extracted value of each element in each database according to data stored in the integration metadata storage.

    Abstract translation: 在搜索方法中,新引入了集成元数据,其中定义查询结果的输出结构的结构数据,结构数据中的元素与数据库中的元素之间的对应关系,数据库之间的元素的关联以及双向转换 定义应用于所述数据库之间的所述元素的所述关联或所述数据库的特定元素的功能。 而且,该搜索方法包括:接受多个数据库的综合数据参考查询; 通过向上跟踪基于查询的结构,提取数据库中的元素的值,其对应于通过集成元数据存储中的集成元数据识别的结构中的顶层元素; 通过基于数据库中的元素的值向下跟踪结构来提取每个数据库中每个元素的值,该值对应于结构中的顶级元素; 以及根据存储在所述集成元数据存储器中的数据,输出每个数据库中的每个元素的提取值。

    Method, computer program, and information processing apparatus for analyzing performance of computer system
    3.
    发明申请
    Method, computer program, and information processing apparatus for analyzing performance of computer system 有权
    方法,计算机程序和用于分析计算机系统性能的信息处理装置

    公开(公告)号:US20130116976A1

    公开(公告)日:2013-05-09

    申请号:US13373047

    申请日:2011-11-03

    Abstract: In an information processing apparatus, a calculation unit retrieves data that indicates processing periods of processes executed in each time window constituting an analysis period. The calculation unit then calculates a total processing time for each time window by adding up processing times spent for execution of processes. The calculation unit also calculates a total progress quantity for each time window by adding up progress quantities of the processes. A determination unit determines, based on the total processing time and total progress quantity of each time window, a threshold of the total processing times at which the ratio of an increase of the total progress quantity to an increase of the total processing time is equal to or smaller than a predetermined value. A detection unit detects time windows whose total processing times are equal to or longer than the threshold.

    Abstract translation: 在信息处理装置中,计算单元检索指示构成分析期间的每个时间窗口中执行的处理的处理周期的数据。 然后,计算单元通过将用于执行处理的处理时间相加来计算每个时间窗口的总处理时间。 计算单元还通过相加处理的进度量来计算每个时间窗口的总进度数。 确定单元基于每个时间窗口的总处理时间和总进度量来确定总进程数量的增加与总处理时间的增加的比率等于的总处理时间的阈值 或小于预定值。 检测单元检测总处理时间等于或大于阈值的时间窗口。

    Computer-readable medium storing program for automatically generating query window, apparatus for automatically generating query window, and method for automatically generating query window
    4.
    发明授权
    Computer-readable medium storing program for automatically generating query window, apparatus for automatically generating query window, and method for automatically generating query window 有权
    用于自动生成查询窗口的计算机可读介质存储程序,用于自动生成查询窗口的设备,以及自动生成查询窗口的方法

    公开(公告)号:US07933892B2

    公开(公告)日:2011-04-26

    申请号:US12058163

    申请日:2008-03-28

    CPC classification number: G06F17/30926 G06F17/30929 G06F17/30941

    Abstract: A query processing apparatus and method automatically generating a query window for an end user. The apparatus and method includes acquiring virtual schema information about tagged document data, automatically generating a query window on the basis of the virtual schema information, specifying an increase or a decrease in a number of repetitions of condition input fields for a repetitive item on the query window, copying content of the condition input fields in a certain repetition to the condition input fields in a newly-added repetition when an increase in the number of repetitions is specified, specifying a joining condition between conditions in each of the repetitions; and generating query code from information input in the query window and transmitting the query code to the query processing apparatus.

    Abstract translation: 查询处理装置和方法自动生成最终用户的查询窗口。 该装置和方法包括获取关于标记的文档数据的虚拟模式信息,基于虚拟模式信息自动生成查询窗口,指定查询上的重复项目的条件输入字段的重复次数的增加或减少 窗口,当指定重复次数的增加时,将特定重复的条件输入字段的内容复制到新添加的重复中的条件输入字段,指定每个重复的条件之间的连接条件; 以及从查询窗口输入的信息生成查询代码,并将查询代码发送给查询处理装置。

    Method and apparatus for referring to database integration, and computer product
    5.
    发明申请
    Method and apparatus for referring to database integration, and computer product 审中-公开
    参考数据库集成的方法和装置,以及计算机产品

    公开(公告)号:US20050160076A1

    公开(公告)日:2005-07-21

    申请号:US10876917

    申请日:2004-06-25

    CPC classification number: G06F16/2471 G06F16/25

    Abstract: When referring to database integration, integration metadata is stored. The integration metadata defines a format of a tagged document used for outputting a result of a query for data reference to a plurality of databases, a relation between each element in the tagged document and each element in each database, and a relation between the elements in each database. When a query is received in a format of the tagged document, the integration metadata is referred to and queries are made to various databases to acquire data. Finally a result of the queries is generated in the format of the tagged document.

    Abstract translation: 当提及数据库集成时,存储集成元数据。 集成元数据定义了用于输出对多个数据库的数据引用的查询的结果的标记文档的格式,标记的文档中的每个元素与每个数据库中的每个元素之间的关系,以及元数据之间的关系 每个数据库。 当以标签文档的格式接收到查询时,引用集成元数据,并且对各种数据库进行查询以获取数据。 最后,查询的结果以标记的文档的格式生成。

    Computer program, method, and information processing apparatus for analyzing performance of computer system
    6.
    发明授权
    Computer program, method, and information processing apparatus for analyzing performance of computer system 有权
    用于分析计算机系统性能的计算机程序,方法和信息处理装置

    公开(公告)号:US08984125B2

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

    申请号:US13587544

    申请日:2012-08-16

    Abstract: In an information processing apparatus, a comparing unit determines whether the response time of each transaction falls within an acceptable time range that is specified previously. For each time window, a first calculation unit calculates a load of processes executed in parallel by the servers in a specified tier, based on transaction data of individual transactions. Further, a second calculation unit calculates a total progress quantity in each time window, based on the transaction data of transactions whose respective response times are determined to fall within the acceptable time range. A determination unit determines a specific load value as a threshold at which the total progress quantity begins to decrease in spite of an increase of the load.

    Abstract translation: 在信息处理装置中,比较单元确定每个事务的响应时间是否落在之前规定的可接受的时间范围内。 对于每个时间窗口,第一计算单元基于各个事务的事务数据来计算由指定层中的服务器并行执行的进程的负载。 此外,第二计算单元基于其各自的响应时间被确定在可接受的时间范围内的事务的交易数据来计算每个时间窗口中的总进度数。 确定单元确定特定负载值作为总进度量开始减小的阈值,尽管负载增加。

    Detecting bottleneck condition based on frequency distribution of sampled counts of processing requests
    7.
    发明授权
    Detecting bottleneck condition based on frequency distribution of sampled counts of processing requests 有权
    基于处理请求的采样计数的频率分布检测瓶颈状况

    公开(公告)号:US08850435B2

    公开(公告)日:2014-09-30

    申请号:US12970095

    申请日:2010-12-16

    Abstract: An operation management apparatus obtains a value Xi indicating the number of process requests being processed by an information processing apparatus during each sampling operation, from N samplings acquired during a specific time period from the information processing apparatus, wherein N is an integer satisfying a condition of 1≦N, and i is an integer satisfying a condition of 1≦i≦N. The apparatus determines, for a plurality of information processing apparatuses, a ratio of the sum of values Xi, each value Xi having a difference, from a maximum value of the values Xi, falling within a specific range, to the total sum of the values Xi. The apparatus detects an information processing apparatus having the ratio equal to or higher than a specific value.

    Abstract translation: 操作管理装置从信息处理装置获取表示在每个采样操作期间由信息处理装置正在处理的处理请求数的值Xi,其中N是满足条件的条件的整数 1≦̸ N,i是满足1≦̸ i≦̸ N的条件的整数。 对于多个信息处理装置,该装置确定值Xi之和与具有区间的值Xi的每个值Xi与值的总和之间的比值 Xi。 该装置检测具有等于或高于特定值的比率的信息处理装置。

    Computer product, database integration reference method, and database integration reference apparatus
    8.
    发明申请
    Computer product, database integration reference method, and database integration reference apparatus 审中-公开
    计算机产品,数据库集成参考方法和数据库集成参考设备

    公开(公告)号:US20070219959A1

    公开(公告)日:2007-09-20

    申请号:US11487572

    申请日:2006-07-17

    CPC classification number: G06F16/8358 G06F16/2471

    Abstract: The database integration reference apparatus stores therein metadata for integration which defines the structure of the XML file used for outputting the query result, the correspondence relationship between the elements in the XML file and the elements in the databases, and the correspondence relationship among the elements in different databases. Using the metadata for integration, pieces of data that are distributed in a plurality of databases including an XML-DB and an RDB are integrated so that the user recognizes the distributed data as one virtual XML file. A query that is made to the integrated data and is written in an XML query language called XQuery is received, and a piece of integrated data is extracted in an XML format and output to the user terminal.

    Abstract translation: 数据库集成参考装置在其中存储用于集成的元数据,该元数据定义用于输出查询结果的XML文件的结构,XML文件中的元素与数据库中的元素之间的对应关系,以及元素之间的对应关系 不同的数据库。 使用用于集成的元数据,分散在包括XML-DB和RDB的多个数据库中的数据片段被集成,使得用户将分布式数据识别为一个虚拟XML文件。 接收到对集成数据进行查询并以XML查询语言编写的称为XQuery的查询,并以XML格式提取一段集成数据并将其输出到用户终端。

    Information processing apparatus, computer program, and method for controlling execution of jobs
    9.
    发明授权
    Information processing apparatus, computer program, and method for controlling execution of jobs 有权
    信息处理装置,计算机程序和用于控制作业执行的方法

    公开(公告)号:US09189272B2

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

    申请号:US13597507

    申请日:2012-08-29

    CPC classification number: G06F9/4881 G06F2209/485 G06F2209/486

    Abstract: An information processing apparatus submits jobs for execution on a server. Jobs are classified into a plurality of groups, and these groups are ranked in ascending order of workload that the groups of jobs impose on the server. A processor in the information processing apparatus counts ongoing jobs that are currently executed on the server and belong to a specified number of top-ranked groups. The processor designates pending jobs that belong to other groups than the specified number of top-ranked groups and suspends submission of processing requests of the designated pending jobs to the server, when the number of ongoing jobs is greater than or equal to a threshold and when there are one or more pending jobs that belong to the specified number of top-ranked groups.

    Abstract translation: 信息处理装置提交作业以在服务器上执行。 作业分为多个组,这些组按照作业组在服务器上施加的工作负荷的升序排列。 信息处理装置中的处理器对当前在服务器上执行并属于指定数量的顶级组的进行中的作业进行计数。 处理器指定属于除指定数量的顶级组之外的其他组的挂起作业,并且当正在进行的作业的数量大于或等于阈值时以及何时停止向服务器提交指定的挂起作业的处理请求 有一个或多个待处理作业属于指定数量的顶级组。

    Recording medium storing analysis program, analyzing method, and analyzing apparatus
    10.
    发明授权
    Recording medium storing analysis program, analyzing method, and analyzing apparatus 有权
    记录介质存储分析程序,分析方法和分析装置

    公开(公告)号:US08531984B2

    公开(公告)日:2013-09-10

    申请号:US13117736

    申请日:2011-05-27

    Abstract: An analyzing apparatus calculates a time-series change in an average process time per process of a server belonging to a first tier of a plurality of tiers and a time-series change in an average process time per process of a server belonging to a second tier of the plurality of tiers, referring to a storage unit that stores, with respect to each transaction executed in a multi-tier system in which a plurality of servers coordinate with each other to execute the transaction, information indicating periods in which the server in each of the plurality of tiers executes processes for the transaction. The apparatus determines the presence/absence of a correlation between the time-series change in the average process time of the server belonging to the first tier and the time-series change in the average process time of the server belonging to the second tier.

    Abstract translation: 分析装置计算属于多层的第一层的服务器的每个处理的平均处理时间的时间序列变化和属于第二层的服务器的每个处理的平均处理时间的时间序列变化 涉及存储单元,其针对在多个服务器彼此协调以执行交易的多层系统中执行的每个交易存储指示每个服务器中的服务器的周期的信息 多个层级执行交易的处理。 该装置确定属于第一层的服务器的平均处理时间的时间序列变化与属于第二层的服务器的平均处理时间的时间序列变化之间的相关性的存在与否。

Patent Agency Ranking