公开(公告)号：US20190095474A1

公开(公告)日：2019-03-28

申请号：US16129130

申请日：2018-09-12

Applicant: HITACHI, LTD.

Inventor： Yasunari TAKAI ,  Keishi OOSHIMA ,  Katsumi KAWAI ,  Makoto KIMURA ,  Kiyoshi YAMAGUCHI

IPC: G06F17/30

Abstract: A table relation analysis assisting apparatus analyzes a relation between pieces of data in a certain column (external key) astride tables in a relational database. The apparatus analyzes a relation between tables and holds inter-table relation analysis information in which tables, pieces of data in the tables being in a one to one relation or a plural to one relation, are defined as one table group. In the apparatus, an analysis result display unit provides a display in such a form that one or more tables in a relational database are contracted into a table group. The display unit displays table groups in such a form that which of a one to one relation or a plural to one relation a relation between pieces of data included therein is astride tables can be viewed.

公开(公告)号：US20150032708A1

公开(公告)日：2015-01-29

申请号：US14339829

申请日：2014-07-24

Applicant: Hitachi, Ltd.

Inventor： Yasunori HASHIMOTO ,  Ryota MIBE ,  Kentaro YOSHIMURA ,  Hirofumi DANNO ,  Keishi OSHIMA ,  Sadahiro ISHIKAWA ,  Kiyoshi YAMAGUCHI

IPC: G06F17/30

CPC classification number: G06F16/221 ,  G06F16/24564

Abstract: A database analysis apparatus pays its attention to table columns more than two constituting a table among plural tables that a database holds, and analyzes automatically a dependence and a limitation condition that exist between the table columns from a tendency of appearance at the same time of data which each table column maintains, which comprises a data category calculation means to calculate a method of categorizing a data group from association rules generated from the data group of two or more table columns and an association rules reconstruction means to generate association rules of the best granularity by reconstructing the association rules based on the result of the above categorizing.

Abstract translation: 数据库分析装置将数据库分析装置注意到数据库所保存的多个表之中的两个以上的表的列，并且从数据的同时出现的趋势自动分析存在于表列之间的依赖性和限制条件 其包括数据类别计算装置，用于计算从两个或多个表列的数据组生成的关联规则和关联规则重构装置中对数据组进行分类的方法，以生成最佳粒度的关联规则 通过根据上述分类的结果重建关联规则。

公开(公告)号：US20170270185A1

公开(公告)日：2017-09-21

申请号：US15320992

申请日：2016-08-01

Applicant: Hitachi, Ltd.

Inventor： Yasunari TAKAI ,  Katsumi KAWAI ,  Shuhei NOJIRI ,  Ryota MIBE ,  Kiyoshi YAMAGUCHI

IPC: G06F17/30

CPC classification number: G06F16/287 ,  G06F16/2358

Abstract: The present invention has an object to analyze, regarding an existing system without a source code, the relationship between input items and internal system processing with respect to output items and present the analysis results to a user. An existing system processing specification extractor is an apparatus for making an existing system operate and analogizing input items of the existing system and internal system processing patterns without performing analysis of implementation and includes: an output data change information acquisition unit that classifies changes of output data associated with input to the existing system on the basis of types of changes of each output element; and an internal system processing specifying unit that combines the classifications obtained by making different input to the existing system and specifies a type of processing based on a usage pattern of an input item value.

公开(公告)号：US20140289706A1

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

申请号：US14171163

申请日：2014-02-03

Applicant: Hitachi, Ltd.

Inventor： KUNIHIKO MIYAZAKI ,  Naoto SATO ,  Shinji ITOH ,  Sadahiro ISHIKAWA ,  Kiyoshi YAMAGUCHI ,  Hiroki MORI

IPC: G06F11/36

CPC classification number: G06F11/3684

Abstract: A test case is generated by receiving software specification, generating a test case including a test input value for particular software from the software specification, as well as an expected output value expected to be obtained as an output value when the software is executed by inputting the test input value, and checking whether a value that can be output in the software specification is included in the expected output value. As a result of the check, if it is determined that the output value that can be output in the software specification is not included in the expected output value, a test case including the value that can be output in the software specification as well as a corresponding test input value is generated and added to the test case that has been generated.

Abstract translation: 通过接收软件规格生成测试用例，生成包括软件规格中的特定软件的测试输入值的测试用例，以及当通过输入软件执行软件时期望获得的预期输出值作为输出值 测试输入值，并检查可以在软件规格中输出的值是否包含在预期输出值中。 作为检查的结果，如果确定可以在软件规格中输出的输出值不包括在预期输出值中，则包括可以在软件规范中输出的值以及a 生成相应的测试输入值并将其添加到已生成的测试用例中。

公开(公告)号：US20180196738A1

公开(公告)日：2018-07-12

申请号：US15488557

申请日：2017-04-17

Applicant: HITACHI, LTD.

Inventor： Daijiro MURATA ,  Jun MAEOKA ,  Genta KOREKI ,  Kiyoshi YAMAGUCHI

IPC: G06F11/36 ,  G06F17/30

CPC classification number: G06F11/3684 ,  G06F17/30952 ,  G06F17/30979

Abstract: A test input information search device searches for a candidate for test inputting in a database, and stores information of the database including a plurality of elements configured with a first structure, stores screen information including the plurality of elements configured with a second structure and displayed, identifies, from the second structure, relation between the elements in the plurality of elements included in the screen information, and searches for, based on the identified relation between the elements, the plurality of elements as the candidate for the test inputting from the information of the database.

公开(公告)号：US20170140309A1

公开(公告)日：2017-05-18

申请号：US15344698

申请日：2016-11-07

Applicant: HITACHI, LTD.

Inventor： Yasunori HASHIMOTO ,  Ryota MIBE ,  Hirofumi DANNO ,  Katsumi KAWAI ,  Keishi OOSHIMA ,  Kiyoshi YAMAGUCHI ,  Makoto KIMURA

IPC: G06Q10/06 ,  G06F17/30

CPC classification number: G06Q10/0633 ,  G06F16/22 ,  G06F16/2474

Abstract: An attribute having influence on a business flow is automatically extracted among one or more attributes associated with the business flow when the business flow is restored based on history data of business performed on a business system. An event sequence variation indicating an order of an attribute name is calculated based on a chronological relation of an attribute value of a date and time from history data of the business configured with an attribute name and an attribute value of business, the number of appearances of each attribute value of each attribute other than a date and time is counted for each event sequence variation, event sequences that are similar in a distribution of the number of appearances are grouped, and business flows generated for respective groups are integrated.

公开(公告)号：US20160004968A1

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

申请号：US14614006

申请日：2015-02-04

Applicant: HITACHI, LTD.

Inventor： Yasunori HASHIMOTO ,  Keishi OOSHIMA ,  Hirofumi DANNO ,  Ryota MIBE ,  Kiyoshi YAMAGUCHI

IPC: G06N5/02

CPC classification number: G06N5/025 ,  G06F16/00 ,  G06F16/2465

Abstract: A correlation rule analysis apparatus extracts data dependence relation and restriction conditions of database columns of a database from data stored in the database. The correction rule analysis apparatus includes a correlation rule extraction part which extracts information of simultaneous appearance relation of data among plural columns as correlation rules from inputted database table data, a correlation rule summarization part which summarizes or puts the extracted correlation rules together on the basis of specific community and a summarization result appropriateness judgment part which calculates usefulness indexes as the data dependence relation and the restriction conditions from appearance frequency and combination in the summarized correlation rules.

Abstract translation: 相关规则分析装置从存储在数据库中的数据提取数据库的数据库列的数据依赖关系和限制条件。 校正规则分析装置包括：相关规则提取部，其将从多个列中的数据的同时出现关系的信息提取为来自输入的数据库表数据的相关规则;相关规则汇总部，其将基于所提取的相关规则汇总或提取在一起 具体社区和总结结果适当判断部分，在总结的相关规则中计算有用指标作为数据依赖关系和出现频率和组合的限制条件。

公开(公告)号：US20140122445A1

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

申请号：US14061115

申请日：2013-10-23

Applicant: Hitachi, Ltd.

Inventor： Yasunori HASHIMOTO ,  Ryota MIBE ,  Kentaro YOSHIMURA ,  Hirofumi DANNO ,  Sadahiro ISHIKAWA ,  Kiyoshi YAMAGUCHI

IPC: G06F17/30

CPC classification number: G06F17/30306 ,  G06F17/30292

Abstract: A database analyzer includes a data sorting unit sorting a data group acquired from an analysis target database based on data values in a table column and storing it as analysis target data in a storage unit; a data pattern creation processing unit creating a group for each data value based on differences between the data values and storing a data pattern in the storage unit; a data pattern judgment processing unit for judging validity of the data pattern; and a data pattern transformation processing unit for reconstructing the data pattern with respect to constituent elements of each group included in the data pattern by transforming each group in accordance with a specified conversion rule for converting the constituent elements, which are conceptually similar to each other, into the same constituent element, and storing it in the storage unit if a negative result is obtained for the validity judgment.

Abstract translation: 数据库分析器包括：数据分类单元，根据表列中的数据值对从分析目标数据库获取的数据组进行排序，并将其作为分析目标数据存储在存储单元中; 数据模式创建处理单元，基于数据值之间的差异为每个数据值创建组，并将数据模式存储在存储单元中; 数据模式判断处理单元，用于判断数据模式的有效性; 以及数据模式变换处理单元，用于根据在概念上彼此相似的用于转换构成要素的指定转换规则，对每个组进行变换来重构关于包含在数据模式中的每个组的组成元素的数据模式， 如果对于有效性判断获得否定结果，则将其存储在存储单元中。