Test input information search device and method

• US 10,241,899 B2
• Filed: 04/17/2017
• Issued: 03/26/2019
• Est. Priority Date: 01/12/2017
• Status: Active Grant

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Murata, Daijiro, Maeoka, Jun, Koreki, Genta, Yamaguchi, Kiyoshi
• Primary Examiner(s): Zhen, Wei Y
• Assistant Examiner(s): Wu, Junchun
• Application Number:
  US15/488,557
• Publication Number:
  US 20180196738A1
• Time in Patent Office: 708 Days
• Field of Search: 717124
• CPC Class Codes: G06F 11/3684 for test design, e.g. generating new test cases
• CPC Class Codes: G06F 16/9017 using directory or table look-up use of a directory or look-up table in file systems G06F16/13
• CPC Class Codes: G06F 16/90335 Query processing

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.

Claims

1. A method that improves functional testing of a computer system that accesses a database, the method comprising:

retrieving information from the database including a plurality of elements configured with a first structure;

retrieving screen information including the plurality of elements configured with a second structure and displayed;

identifying, from the second structure, a relation between the elements in the plurality of elements included in the screen information, determining a candidate for test inputting from the information from the database based on the relation identified between the elements; and

testing the database by inputting the candidate into the computer system and evaluating a response in the computer system caused by the inputting;

wherein the second structure includes a display positional relation between the elements in the plurality of elements included in the screen information and attributes of the elements, and the candidate is further determined based on the attributes of the elements in addition to the relation identified between the elements.

2. The method according to claim 1, further comprising:

identifying a type of each of the plurality of elements included in the screen information and generating a plurality of nodes each combining together the element, the attribute of the element, and the type of the element, and identifying, as the relation between the elements from the second structure, a type of an edge between the generated plurality of nodes.

3. The method according to claim 2, further comprising:

identifying a relation between two nodes as a cell based on the type of the edge identified, relation between attributes of two elements forming the two nodes located at both ends of the edge, and relation between the types of the two elements.

4. The method according to claim 3,

in a case where the type of the edge between a first node and a second node in the generated plurality of nodes is not identified from the second structure, identifying the relation between the first node and the second node as the cell based on the type of the edge between a third node and the first node in the generated plurality of nodes and the type of the edge between the third node and the second node.

5. The method according to claim 4, further comprising:

searching for part of the plurality of elements from the information in the database in accordance with order of priority based on the types identified of the elements, and searching for part of the plurality of elements from the information in the database in accordance with order of priority based on the relation identified as the cell.

6. The method according to claim 5, wherein

the first structure includes a plurality of tables each having a plurality of columns,

information of the elements and information of condition are specified, and

a value is searched for which satisfies the specified information of condition of the column including the specified information of the element in the plurality of elements searched from the information in the database.

7. The method according to claim 6, wherein

the database is relational database.

8. An apparatus that improves functional testing of a computer system that accesses a database, the apparatus comprising:

a communication interface communicatively coupled to the database;

a processor communicatively coupled to the communication interface, wherein the processor;

retrieves, using the communication interface, a plurality of elements configured with a first structure from the database, retrieves, using the communication interface, screen information that includes 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, determines a candidate for test inputting from the information in the database based on the relation identified between the elements, and test the database by inputting the candidate into the computer system and evaluating a response in the computer system caused by the inputting;

wherein the second structure includes a display positional relation between the elements in the plurality of elements included in the screen information and attributes of the elements, and the candidate is further based on the attributes of the elements in addition to the relation identified between the elements.

9. The apparatus according to claim 8, wherein processor further:

identifies a type of each of the plurality of elements included in the screen information, and generates a plurality of nodes each combining together the element, the attribute of the element, and the type of the element, and identifies, from the second structure, a type of edge between the generated plurality of nodes as the relation between the elements.

10. The apparatus according to claim 9, wherein processor further:

identifies relation between two nodes as a cell based on the type identified of the edge and relation between attributes of two elements forming the two nodes at both ends of the edge and relation between the types of the two elements.

11. The apparatus according to claim 10, wherein

in a case where the type of the edge between a first node and a second node in the generated plurality of nodes is not identified from the second structure, the processor identifies the relation between the first node and the second node as the cell based on the type of the edge between a third node and the first node in the generated plurality of nodes and the type of the edge between the third node and the second node.

12. The apparatus according to claim 11, wherein the processor further:

searches for part of the plurality of elements from the screen information in the database in accordance with order of priority based on the identified types of the elements, and searches for part of the plurality of elements from the screen information in the database in accordance with order of priority based on the relation identified as the cell.

13. The apparatus according to claim 12, wherein

the first structure includes a plurality of tables each having a plurality of columns, and

the processor further:

specifies information of the elements and information of condition, and searches for a value satisfying the specified information of condition from the column of the table including the specified information of the element in the plurality of elements searched from the screen information in the database.