Automatically correcting invalid scripts in web applications

Patent metadata

Field	Value
Publication number	US-10713237-B2
Application number	US-201715623544-A
Country	US
Kind code	B2
Filing date	Jun 15, 2017
Priority date	Oct 30, 2013
Publication date	Jul 14, 2020
Grant date	Jul 14, 2020

Abstract

According to an aspect, a method for correcting an invalid script in a web application includes determining an invalid reference in an invalid script. A storage location is determined in a database corresponding to the invalid reference based on a data relationship mapping, wherein the data relationship mapping indicates the correspondence between the reference and a storage location in the database. An up-to-date value at the storage location is queried and he queried up-to-date value is determined to be the correct value of the invalid reference.

First claim

What is claimed is:

1. A method for correcting an invalid script in a web application, comprising:
determining an invalid reference in an invalid script;
determining a storage location in a database corresponding to the invalid reference based on a data relationship mapping, in which the data relationship mapping indicates the correspondence between the reference and a storage location in the database;
querying an up-to-date value at the storage location;
determining the queried up-to-date value to be the correct value of the invalid reference;
searching a response corresponding to the invalid reference using the determined correct value to determine the location of the correct value in the response; and
creating a data correlation for the invalid reference according to the determined location and its context and updating an invalid data correlation corresponding to the invalid reference with the created data correlation.

2. The method according to claim 1 , wherein the data correlation is determined by:
in response to creating a reference, determining a correspondence between the created reference and a storage location in the database; and
generating the data relationship mapping based on the determined correspondence.

3. The method according to claim 2 , wherein determining a correspondence between the created reference and a storage location in the database comprises:
determining a correspondence between the created reference and a storage location in the database according to database statements caused by a request corresponding to the created reference for performing operations in the database and the actual value of the created reference, wherein the actual value of the created reference is included in a response corresponding to the created reference.

4. The method according to claim 3 , wherein determining a correspondence between the created reference and a storage location in the database according to database statements caused by a request corresponding to the created reference for performing operations in the database and the actual value of the created reference comprises:
determining a table related with the created reference in the database according to the database statements; and
traversing the table using the actual value of the created reference to determine a matched column.

5. An apparatus for correcting an invalid script in a web application comprising:
a memory having computer readable instructions; and
a processor for executing the computer readable instructions, the computer readable instructions including:
determining an invalid reference in an invalid script;
determining a storage location in a database corresponding to the invalid reference based on a data relationship mapping, in which the data relationship mapping indicates the correspondence between the reference and a storage location in the database;
querying an up-to-date value at the storage location;
determining the queried up-to-date value to be the correct value of the invalid reference;
searching a response corresponding to the invalid reference using the determined correct value to determine the location of the correct value in the response; and
creating a data correlation for the invalid reference according to the determined location and its context and updating an invalid data correlation corresponding to the invalid reference with the created data correlation.

6. The apparatus according to claim 5 , wherein the data correlation is determined by:
in response to creating a reference, determining a correspondence between the created reference and a storage location in the database; and
generating the data relationship mapping based on the determined correspondence.

7. The apparatus according to claim 6 , wherein determining a correspondence between the created reference and a storage location in the database comprises:
determining a correspondence between the created reference and a storage location in the database according to database statements caused by a request corresponding to the created reference for performing operations in the database and the actual value of the created reference, wherein the actual value of the created reference is included in a response corresponding to the created reference.

8. The apparatus according to claim 7 , wherein determining a correspondence between the created reference and a storage location in the database according to database statements caused by a request corresponding to the created reference for performing operations in the database and the actual value of the created reference comprises:
determining a table related with the created reference in the database according to the database statements; and
traversing the table using the actual value of the created reference to determine a matched column.

9. A computer program product for correcting an invalid script in a web application, the computer program product comprising computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a computer to cause the computer to perform a method comprising:
determining an invalid reference in an invalid script;
determining a storage location in a database corresponding to the invalid reference based on a data relationship mapping, wherein the data relationship mapping indicates the correspondence between the reference and a storage location in the database;
querying an up-to-date value at the storage location;
determining the queried up-to-date value to be the correct value of the invalid reference;
searching a response corresponding to the invalid reference using the determined correct value to determine the location of the correct value in the response;
creating a data correlation for the invalid reference according to the determined location and its context and updating an invalid data correlation corresponding to the invalid reference with the created data correlation.

10. The computer program product according to claim 9 , wherein the data correlation is determined by:
in response to creating a reference, determining a correspondence between the created reference and a storage location in the database; and
generating the data relationship mapping based on the determined correspondence.

11. The computer program product according to claim 9 , wherein determining a correspondence between the created reference and a storage location in the database comprises:
determining a correspondence between the created reference and a storage location in the database according to database statements caused by a request corresponding to the created reference for performing operations in the database and the actual value of the created reference, wherein the actual value of the created reference is included in a response corresponding to the created reference.

12. The computer program product according to claim 11 , wherein determining a correspondence between the created reference and a storage location in the database according to database statements caused by a request corresponding to the created reference for performing operations in the database and the actual value of the created reference comprises:
determining a table related with the created reference in the database according to the database statements; and
traversing the table using the actual value of the created reference to determine a matched column.

Assignees

• IBM

Inventors

• Kong Yi
• Tu Zi Yan
• Wang Xi Ning
• Xing Zhen Yu
• Zhang Qi

Classifications

• G06F16/951

  Indexing; Web crawling techniques · CPC title

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title

• G06F16/2365 Primary

  Ensuring data consistency and integrity · CPC title