Automatically correcting invalid scripts in web applications

Patent metadata

Field	Value
Publication number	US-9727599-B2
Application number	US-201414518350-A
Country	US
Kind code	B2
Filing date	Oct 20, 2014
Priority date	Oct 30, 2013
Publication date	Aug 8, 2017
Grant date	Aug 8, 2017

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 the 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, 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 by 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;

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 by:
filtering out all tables which non-insert statements involve from tables which the database statements involve in;
based on attribute of the created reference, filtering out tables unrelated with the created reference from the remaining tables; and
determining the finally remaining table as the table related with the created reference; and

traversing the table using the actual value of the created reference to determine a matched column.

2. 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, 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 by 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;

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 by:
filtering out all tables which non-insert statements involve from tables which the database statements involve in;
based on attribute of the created reference, filtering out tables unrelated with the created reference from the remaining tables; and
determining the finally remaining table as the table related with the created reference; and

traversing the table using the actual value of the created reference to determine a matched column.

3. 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; 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, 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 by 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;

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 by:
filtering out all tables which non-insert statements involve from tables which the database statements involve in;
based on attribute of the created reference, filtering out tables unrelated with the created reference from the remaining tables; and
determining the finally remaining table as the table related with the created reference; 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

• G06F17/30864

  Physics · mapped topic

• G06F17/30371 Primary

  Physics · mapped topic

• G06F17/30339

  Physics · mapped topic

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title

• G06F16/951

  Indexing; Web crawling techniques · CPC title