DATA SELECTION AND IDENTIFICATION

• US 20130311423A1
• Filed: 03/15/2013
• Published: 11/21/2013
• Est. Priority Date: 03/26/2012
• Status: Abandoned Application

• Current Assignee: Good Red Innovation Pty Limited
• Original Assignee: Good Red Innovation Pty Limited
• Inventors: PRICE, Russell Francis, SCOTT, Timothy
• Application Number:
  US13/838,148
• Publication Number:
  US 20130311423A1
• Time in Patent Office: Days
• US Class Current: 707/609
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 40/08 Insurance

Abstract

Target data compatible with a target computing application is generated from source data compatible with a source computing application as part of a migration from a source computing application to a target computing application. At least a first portion of the source data is selected and a variable is assigned to the first portion of the source data to enable the first portion of the source data to be referred to using the variable by one or more computer processors in a subsequent generation of further target data from the source data.

Claims

1. A method of generating target data compatible with a target computing application from source data compatible with a source computing application as part of a migration from a source computing application to a target computing application, the method being executed by one or more computer processors and comprising the steps of:

selecting at least a first portion of the source data; and

assigning a variable to the first portion of the source data to enable the first portion of the source data to be referred to using the variable by the one or more computer processors in a subsequent generation of further target data from the source data.

2. A method as claimed in claim 1 wherein the step of selecting the at least a portion of the source data comprises one or both of:

receiving definition data defining data entries within a source data store; and

receiving characteristic data defining data characteristics, wherein the characteristic data is used by the one or more computer processors to select data entries within a source data store.

3. A method as claimed in claim 2, wherein the step of receiving definition data comprises the step of receiving one or more sub-variables, wherein each of the one or more sub-variables comprises one or more of:

data identifying a second portion of the source data; and

one or more further sub-variables.

4. A method as claimed in claim 3, wherein the one or more further sub-variables comprises one or more variables or sub-variables.

5. A method as claimed in claim 1 further comprising the step of generating a set of source entries, wherein each source entry corresponds to a data entry within the source data store, and is associated with one or more variables, sub-variables or further sub-variables.

6. A method as claimed in claim 5, further comprising the steps of:

generating one or more respective target data entries from corresponding data entries within the source data store; and

associating each of the one or more respective received target data entries with the one or more variables, sub-variables or further sub-variables to which the corresponding source entry is associated.

7. A method as claimed in claim 5, further including the steps of:

attempting to generate one or more respective target data entries from each corresponding data entry within the source database; and

if one or more respective target data entries is successfully generated from a corresponding data entry within the source data store, associating the one or more respective target data entries with the one or more variables, sub-variables or further sub-variables to which the corresponding source entry is associated; and

if one or more respective target data entries is not successfully generated from a corresponding data entry within the source data store;

generating failure data representing a migration failure; and

associating the failure data with the one or more variables, sub-variables or further sub-variables to which the corresponding source entry is associated.

8. A system for generating target data compatible with a target computing software application from source data compatible with a source computing application as part of a migration from a source computing application to a target computing application, the system comprising:

a source data store storing the source data;

one or more computer processors which;

select at least a first portion of the source data stored in the source data store; and

assign a variable to the first portion of the source data to enable the first portion of the source data to be referred to using the variable by the one or more computer processors in a subsequent generation of further target data from the source data.

9. A system as claimed in claim 8, wherein the one or more computer processors:

extract data from the source data store;

transform data extracted from the source data store;

or

load data extracted and transformed from the source data store into a target data store using the assigned variable.

10. A system as claimed in claim 8, wherein the one or more computer processors select data entries from within the source data store using one or both of:

definition data defining data entries within the source data store; and

characteristic data defining data characteristics of data entries within the source data store.

11. A system as claimed in claim 10, wherein the one or more computer processors resolve the characteristic data to select data entries within the source data store for subsequent extraction, transformation or loading.

12. A system as claimed in claim 8 wherein the one or more computer processors assign to the first portion of the source data a variable that is part of a variable hierarchy.

13. A system as claimed in claim 12, wherein the variable hierarchy comprises one or more sub-variables and further sub-variables.

14. A computer readable medium containing computer-executable instructions which, when executed by a processor, cause it to execute the steps of:

selecting at least a first portion of the source data; and

assigning a variable to the first portion of the source data to enable the first portion of the source data to be referred to using the variable by the one or more computer processors in a subsequent generation of further target data from the source data.

15. A computer readable medium as claimed in claim 14 wherein the computer-executable instructions include instructions which, when executed by a processor, cause the processor to execute the steps of:

receiving definition data defining data entries within a source data store; and

receiving characteristic data defining data characteristics, wherein the characteristic data is used by the one or more computer processors to select data entries within a source data store.

16. A computer readable medium as claimed in claim 15, wherein the step of receiving definition data comprises the step of receiving one or more sub-variables, wherein each of the one or more sub-variables comprises one or more of:

data identifying a second portion of the source data; and

one or more further sub-variables.

17. A computer readable medium as claimed in claim 16, wherein the one or more further sub-variables comprises one or more variables or sub-variables.

18. A computer readable medium as claimed in claim 17 further comprising instructions which, when executed by the processor, cause it to execute the step of generating a set of source entries, wherein each source entry corresponds to a data entry within the source data store, and is associated with one or more variables, sub-variables or further sub-variables.

19. A computer readable medium as claimed in claim 18, further including instructions which, when executed by the processor, cause the processor to execute the steps of:

generating one or more respective target data entries from corresponding data entries within the source data store; and

associating each of the one or more respective received target data entries with the one or more variables, sub-variables or further sub-variables to which the corresponding source entry is associated.

20. A computer-readable medium as claimed in claim 17, further comprising instructions which, when executed by the processor, cause it to execute the steps of:

attempting to generate one or more respective target data entries from each corresponding data entry within the source database; and

if one or more respective target data entries is successfully generated from a corresponding data entry within the source data store, associating the one or more respective target data entries with the one or more variables, sub-variables or further sub-variables to which the corresponding source entry is associated; and

if one or more respective target data entries is not successfully generated from a corresponding data entry within the source data store;

generating failure data representing a migration failure; and

associating the failure data with the one or more variables, sub-variables or further sub-variables to which the corresponding source entry is associated.