Methods for interactively defining transforms and for generating queries by manipulating existing query data
First Claim
1. A computer implemented method of interactively determining transformations for use in mapping at least one source data component from at least one source to target data component, said method comprising the steps of:
- (a) using a computer to detect selection of at least one said source data component;
(b) for each said selected source data component, generating a corresponding list of representative data examples;
(c) using a computer to compile a resulting list of representative data examples for said target data component from said lists of representative data examples of said selected source data components, said resulting list of representative data examples being a limited subset of the source data components and representative of said target data component;
(d) using a computer to display said resulting list of examples in a graphical user interface;
(e) using a computer to identify a user generated modification of a single textual entity example from said resulting list of examples, wherein said user generated modification is made by a user selecting the single textual entity example from said resulting list of examples displayed in the graphical user interface and then directly modifying the single textual entity example; and
(f) using a computer to determine at least one transformation to be applied to the at least one source data component including its corresponding representative data examples displayed in the graphical user interface, said at least one transformation being selected from a list of solutions, each solution of the list of solutions being based on the modified example and comprising at least one function, wherein said at least one transformation is selected from the list of solutions according to one of;
a length of connectors between said functions; and
a weight assigned to said functions.
1 Assignment
0 Petitions
Accused Products
Abstract
Access to heterogeneous data sources may be obtained by interactively determining transformations for use in mapping at least one source data component from at least one data source to a target data component. Selection of at least one the source data component is detected. A corresponding list of representative data examples is generated for each selected source data component. A resulting list of representative data examples is compiled for the target data component from the lists of representative data examples of the selected source data components, the resulting list of data examples being representative of the target data component. A modification of an example is identified from the resulting list of examples representative of the target data component, the example being modified as a single textual entity. At least one transformation is determined, by inferring from the modified example, to be applied to at least one source data component.
-
Citations
25 Claims
-
1. A computer implemented method of interactively determining transformations for use in mapping at least one source data component from at least one source to target data component, said method comprising the steps of:
-
(a) using a computer to detect selection of at least one said source data component; (b) for each said selected source data component, generating a corresponding list of representative data examples; (c) using a computer to compile a resulting list of representative data examples for said target data component from said lists of representative data examples of said selected source data components, said resulting list of representative data examples being a limited subset of the source data components and representative of said target data component; (d) using a computer to display said resulting list of examples in a graphical user interface; (e) using a computer to identify a user generated modification of a single textual entity example from said resulting list of examples, wherein said user generated modification is made by a user selecting the single textual entity example from said resulting list of examples displayed in the graphical user interface and then directly modifying the single textual entity example; and (f) using a computer to determine at least one transformation to be applied to the at least one source data component including its corresponding representative data examples displayed in the graphical user interface, said at least one transformation being selected from a list of solutions, each solution of the list of solutions being based on the modified example and comprising at least one function, wherein said at least one transformation is selected from the list of solutions according to one of; a length of connectors between said functions; and a weight assigned to said functions. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16, 17, 18, 19, 20, 21, 22, 23)
-
-
15. A method according to claim l wherein said unary transform is selected from the group consisting of:
-
(i) a string containing a predetermined number of first words of the operand; (ii) a string containing a predetermined number of words starting from a start word; (iii) a string containing a predetermined number of first characters of the operand; (iv) a string representing operand converted to upper case; (v) a string representing operand converted to lower case; (vi) a string in which the first characters of all non-conjunction words in the operand are capitalised; (vii) a string in which the first characters of all words in the operand are capitalised; (viii) a string in which the operand is translated to the language specified by the XML language; (ix) a string in which all punctuation in the operand is removed; (x) a string in which the string text is inserted at a predetermined position in the operand; (xi) a string in which all the conjunctions in the operand have been removed; (Xii) a number if the operand can be parsed as a number; (xiii) a string representing the operand; (xiv) a value which is the negation of the operand; (xv) a value of the operand as an integer; and (xvi) a value of the operand as double precision number.
-
-
24. A computer readable storage medium, having a program recorded thereon, where the program is configured to make a computer execute a procedure to interactively determine transformations for use in mapping at least one source data component from at least one data source to a target data component, said program comprising:
-
code providing for detecting a selection of at least one said source data component; code for generating a list of representative data examples for each corresponding said selected source data component; code for compiling a resulting list of representative data examples for said target data component from said lists of representative data examples of said selected source data components, said resulting list of representative data examples being a limited subset of the source data components and being representative of said target data component; code for displaying a resulting list of examples in a graphical user interface; code for identifying a user generated modification of a single textual entity example from said resulting list of examples, wherein said user generated modification is made by a user selecting the single textual entity example from said resulting list of examples displayed in the graphical user interface and then directly modifying the single textual entity example; and code for determining at least one transformation to be applied to at least one source data component including its corresponding representative data examples displayed in the graphical user interface, said at least one transformation being selected from a list of solutions, each solution of the list of solutions being based on the modified example and comprising at least one function, wherein said at least one transformation is selected from the list of solutions according to one of; a length of connectors between said functions; and a weight assigned to said functions.
-
-
25. A computer apparatus having a processor and a memory, wherein the memory stores a computer-executable program executable by the processor for controlling the computer apparatus to interactively determine transformations for use in mapping at least one source data component from at least one data source to a target data component, and wherein the computer-executable program stored in the memory comprises code to cause the computer apparatus to perform the steps of;
-
selecting at least one said source data component from at least one heterogenous data source; generating, upon each selection of one said data source component, a list of representative data examples for each corresponding said selected source data component; compiling a resulting list of representative data examples for said target data component from said lists of representative data examples of said selected source data components, said resulting list of representative data examples being a limited subset of the source data components and being representative of said target data component; displaying a resulting list of examples in a graphical user interface; user modification of a single textual entity example from said resulting list of examples, wherein said user generated modification is made by a user selecting the single textual entity example from said resulting list of examples displayed in the graphical user interface and then directly modifying the single textual entity example; and determining at least one transformation to be applied to at least one source data component including its corresponding representative data examples displayed in the graphical user interface, said at least one transformation being selected from a list of solutions, each solution of the list of solutions being based on the modified example and comprising at. least one function, wherein said at least one transformation is selected from the list of solutions according to one of; a length of connectors between said functions. a weight assigned to said functions.
-
Specification