Applying matching data transformation information based on a user's editing of data within a document

Patent metadata

Field	Value
Publication number	US-10606939-B2
Application number	US-201816176181-A
Country	US
Kind code	B2
Filing date	Oct 31, 2018
Priority date	Feb 19, 2018
Publication date	Mar 31, 2020
Grant date	Mar 31, 2020

Abstract

A mechanism is provided for applying matching data transformation information based on a user's editing of data within a document. User input identifying inputs provided by a user while editing a document within an application executing on the data processing system is received. A matching algorithm is executed based on user input to identify one or more candidate transformation operations within a transformation operation data structure that matches the user input. Responsive to failing to identify any candidate transformation operations, an indication is provided that no candidate transformation operations are identifiable. Responsive to one or more candidate transformation operations being identified, a list of transformation operations is provided that includes the one or more candidate transformation operations to the user via the data processing system.

First claim

What is claimed is:

1. A method, in a data processing system, for applying matching data transformation information based on a user's editing of data within a document, the method comprising:
receiving user input identifying an edit to the data provided by a user while editing the data of the document within an application executing on the data processing system;
executing a matching algorithm based on the edit to the data to identify one or more candidate transformation operations within a transformation operation data structure that matches the edit to the data;
receiving a selection of a transformation operation from the list of transformation operations by the user;
automatically applying the selected transformation operation to the document; and
providing an indication to the user of all the changes that were made to the document by applying the selected transformation operation.

2. The method of claim 1 , further comprising:
responsive to the user indicating that the changes should be made permanent, making the changes permanent.

3. The method of claim 1 , further comprising:
responsive to the user indicating that the changes should not be made permanent, undoing the changes made based on the selected transformation operation.

4. The method of claim 1 , wherein the transformation operations within the transformation operation data structure are categorized in terms of data types, wherein the data types comprise one or more of a string data type, a numeric data type, or a date/time/timestamp data type.

5. The method of claim 1 , wherein executing the matching algorithm based on the edit to the data to identify the one or more candidate transformation operations within the transformation operation data structure that matches the edit to the data comprises:
comparing a value of a previous data in collected user input to a value of the data in the edit to the data;
responsive to no change in the value of the data, comparing a format of the previous data to a format of the data in the edit to the data; and
responsive to the format of the data changing, returning a transformation operation associated with format conversion.

6. The method of claim 1 , further comprising:
responsive to the format of the data failing to change, providing the indication that no candidate transformation operations are identifiable.

7. The method of claim 1 , wherein executing the matching algorithm based on the edit to the data to identify the one or more candidate transformation operations within the transformation operation data structure that matches the edit to the data comprises:
for each transformation operation in the transformation operation data structure:
executing the transformation operation on a previous data value to get a new data value;
determining whether the new data value matches the edit to the data;
responsive to a result of applying the transformation operation on the previous data value matching the edit to the data, identifying the transformation operation as a candidate transformation operation and adding the candidate transformation to the list of transformation operations; and
responsive to the result of applying the transformation operation on the previous data value failing to match the edit to the data, discarding the transformation operation as a possible candidate transformation operation.

8. A computer program product comprising a computer readable storage medium having a computer readable program stored therein, wherein the computer readable program, when executed on a computing device, causes the computing device to:
receive user input identifying an edit to the data provided by a user while editing the data of the document within an application executing on the data processing system;
execute a matching algorithm based on the edit to the data to identify one or more candidate transformation operations within a transformation operation data structure that matches the edit to the data;
responsive to one or more candidate transformation operations being identified, provide a list of transformation operations that includes the one or more candidate transformation operations to the user via the data processing system;
receive a selection of a transformation operation from the list of transformation operations by the user;
automatically apply the selected transformation operation to the document; and
provide an indication to the user of all the changes that were made to the document by applying the selected transformation operation.

9. The computer program product of claim 8 , wherein the computer readable program further causes the computing device to:
responsive to the user indicating that the changes should be made permanent, make the changes permanent.

10. The computer program product of claim 8 , wherein the computer readable program further causes the computing device to:
responsive to the user indicating that the changes should not be made permanent, undo the changes made based on the selected transformation operation.

11. The computer program product of claim 8 , wherein the transformation operations within the transformation operation data structure are categorized in terms of data types, wherein the data types comprise one or more of a string data type, a numeric data type, or a date/time/timestamp data type.

12. The computer program product of claim 8 , wherein the computer readable program to execute the matching algorithm based on the edit to the data to identify the one or more candidate transformation operations within the transformation operation data structure that matches the edit to the data causes the computing device to:
compare a value of a previous data in collected user input to a value of the data in the edit to the data;
responsive to no change in the value of the data, compare a format of the previous data to a format of the data in the edit to the data; and
responsive to the format of the data changing, return a transformation operation associated with format conversion.

13. The computer program product of claim 8 , wherein the computer readable program further causes the computing device to:
responsive to the format of the data failing to change, provide the indication that no candidate transformation operations are identifiable.

14. The computer program product of claim 8 , wherein the computer readable program to execute the matching algorithm based on the edit to the data to identify the one or more candidate transformation operations within the transformation operation data structure that matches the edit to the data causes the computing device to:
for each transformation operation in the transformation operation data structure:
execute the transformation operation on a previous data value to get a new data value;
determine whether the new data value matches the edit to the data;
responsive to a result of applying the transformation operation on the previous data value matching the edit to the data, identify the transformation operation as a candidate transformation operation and adding the candidate transformation to the list of transformation operations; and
responsive to the result of applying the transformation operation on the previous data value failing to match the edit to the data, discard the transformation operation as a possible candidate transformation operation.

15. An apparatus comprising:
a processor, and
a memory coupled to the processor, wherein the memory comprises instructions which, when executed by the processor, cause the processor to:
receive user input identifying an edit to the data provided by a use

Assignees

• IBM

Inventors

• Li Yong
• Pham Ryan
• Pu Xiaoyan
• Sheng Yeh-Heng

Classifications

• G06F16/254

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title

• G06F40/103

  Formatting, i.e. changing of presentation of documents (automatic justification G06F40/189; automatic line break hyphenation G06F40/191) · CPC title

• G06F40/166 Primary

  Editing, e.g. inserting or deleting · CPC title

• G06F40/16 Primary

  Automatic learning of transformation rules, e.g. from examples · CPC title

• G06F16/252

  between a Database Management System and a front-end application · CPC title