Job management method, information processing device, program, and recording medium

• US 20040260696A1
• Filed: 12/19/2003
• Published: 12/23/2004
• Est. Priority Date: 06/19/2003
• Status: Abandoned Application

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Sato, Masakazu, Tomita, Seiichi, Soejima, Tsuyoshi, Iwabuchi, Fumihiko, Oku, Etsuji, Matsuoka, Takeshi, Akiba, Shinichi
• Application Number:
  US10/742,139
• Publication Number:
  US 20040260696A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

An object of the present invention is to provide a job management method for making it possible to reuse jobs in an ETL process. In the job management method, a job information table is accessed, jobs having table attributes and data field attributes matching between the respective jobs are retrieved, and, for each retrieved job, matching degrees of the data field attribute of “other jobs” in which the matching has been confirmed are calculated. Then, the “other jobs” in which the calculated matching degrees is equal to or more than a predetermined level are identified, and the identified “other jobs” are outputted to an output interface.

Claims

1. A method for managing jobs of an ETL process using an information processing device, the method comprising the steps of:

accessing a job information table in the information processing device which records contents of the respective jobs of the ETL process;

retrieving the jobs which have contents partially or exactly matching between the respective jobs; and

outputting, for each retrieved job, an other job in which the matching has been confirmed to an output interface.

2. A job management method according to claim 1,

wherein in recording of the contents of the respective jobs in the job information table, for each job, a table attribute and a data field attribute related with each of a data extraction source and a data storing destination, which are the contents of the job, are recorded and

other jobs retrieved in the retrieving step are jobs which have table attributes and data field attributes matching between the respective jobs.

3. A job management method according to claim 2, further comprising the step of:

calculating, for each retrieved job, a matching degree of the other jobs in which the matching has been confirmed,

wherein in the outputting step, the other jobs are outputted based on the calculated matching degree.

4. A job management method according to claim 3, comprising the step of:

identifying the other job in which the calculated matching degree is equal to or more than a predetermined level, the calculated matching degree of the other job being a matching degree of the data field attributes of the other job in which the matching has been confirmed,

wherein in the outputting step, the identified other job is outputted.

5. A method for managing jobs of an ETL process using an information processing device, the method comprising the steps of:

accessing a matching information table in the information processing device in which the jobs having table attributes and data field attributes matching between the respective jobs of the ETL process for each of a data extraction source and a data storing destination are listed and in which each job is related with a matching degree of the data field attribute with an other job, recognizing the matching degree with the other job for each job, and identifying the other job having the highest matching degree for each job; and

outputting the identified other job.

6. A method according to claim 5, further comprising the step of:

calculating frequencies in which the identified other jobs have been identified to have the highest matching degrees for the respective jobs,

wherein in the outputting step, the identified other jobs are listed in order of the calculated frequencies and outputted.

7. A method according to claim 6,

wherein the matching degree is the number of duplicated data fields of the data field attribute, and

wherein in the outputting step, the other jobs are outputted in a state where the other job having the highest calculated frequency and the identified other job are related in accordance with the number of duplicated data fields between the other job having the highest frequency and the identified other job.

8. A job management program for causing an information processing device to execute a method for managing jobs of an ETL process, the job management program comprising the codes for executing the steps of:

accessing a job information table which records contents of the respective jobs of the ETL process, and retrieving a job which have contents partially or exactly matching between the respective jobs;

calculating, for each retrieved job, a matching degree of an other job in which the matching has been confirmed; and

outputting the other job based on the calculated matching degree for each retrieved job.

9. A job management program according to claim 8,

wherein in the contents of the respective jobs, table attributes and data field attributes are related with each of a data extraction source and a data storing destination of each job, and

wherein in the retrieving step, the jobs which have the table attributes and the data field attributes matching between the respective jobs are retrieved.

10. A job management program according to claim 8,

wherein the information table records table attributes and data field attributes in a state where, for each job, the table attributes and the data field attributes are related with each of a data extraction source and a data storing destination, which are contents of the job,

the other jobs retrieved in the retrieving step are jobs which have the data attributes and the data field attributes matching between the respective jobs, and

the matching degree of the other job is a matching degree of the data field attribute of the other job.

11. A job management program according to claim 10, further comprising the step of:

identifying the other job in which the calculated matching degree of the data field attribute of the other job is equal to or more than a predetermined level,

wherein in the outputting step, the identified other job is outputted.

12. A job management program according to claim 8,

wherein the matching degree of the other job is the number of duplicated data fields of the data field attribute between the retrieved job and the other job, and

wherein in the outputting step, for each retrieved job, the other job in which the matching has been confirmed and the number of duplicated data fields are outputted in a state where the other job and the number of duplicated data fields are related.

13. A job management program for causing an information processing device to execute a method for managing jobs of an ETL process, the job management program comprising the codes for executing the steps of:

accessing a matching information table which records other jobs having contents partially or exactly matching between the respective jobs of the ETL process and matching degrees of the other jobs for each job, recognizing the matching degrees of the other jobs for each job, and identifying the other job having the highest matching degree for each job; and

outputting the identified other jobs.

14. A job management program according to claim 13, further comprising the codes for executing the step of:

calculating frequencies in which the identified other jobs are identified to have the highest matching degrees for the respective jobs,

wherein in the outputting step, the identified other jobs are listed in order of the frequencies and outputted.

15. A job management program according to claim 14,

wherein the other jobs having contents partially or exactly matching between the respective jobs are other jobs having table attributes and data field attributes matching between the respective jobs for each of a data extraction source and a data storing destination, and

the matching degrees are matching degrees of the data field attributes of the other jobs for each job.

16. A computer-readable recording medium having a job management program recorded thereon, the job management program causing an information processing device to execute a method for managing jobs of an ETL process, the information processing device being capable of accessing a job information table in which a table attribute and a data field attribute are related with each of a data extraction source and a data storing destination in each job of the ETL process, the job management program comprising the codes for executing the steps of:

accessing the job information table, and retrieving the jobs which have the table attributes and the data field attributes matching between the respective jobs;

calculating, for each retrieved job, a matching degree of the data field attribute of an other job in which the matching has been confirmed;

identifying the other job which has the calculated matching degree equal to or more than a predetermined level; and

outputting the identified other job to an output interface.

17. A computer-readable recording medium according to claim 16,

the information processing device being capable of accessing a matching information table in which the jobs having the table attributes and the data field attributes matching between the respective jobs of the ETL process for each of the data extraction source and the data storing destination are listed and in which each job is related with the matching degree of the data field attribute with the other job, the job management program comprising the codes for executing the steps of:

accessing the matching information table, recognizing the matching degree with the other job for each job, and identifying the other job having the highest matching degree for each job;

calculating frequencies in which the identified other jobs have been identified to have the highest matching degrees for the respective jobs; and

listing the other jobs in order of the frequencies, and outputting the other jobs to the output interface.

18. An information processing device for managing jobs of an ETL process, the information processing device comprising:

a job information table recording a table attribute and a data field attribute in a state where, for each job, the table attribute and the data field attribute are related with each of a data extraction source and a data storing destination, which are contents of the job;

a unit for accessing the job information table and retrieving jobs which have the table attributes and the data field attributes matching between the respective jobs;

a unit for calculating, for each retrieved job, a matching degree of an other job in which the matching has been confirmed; and

a unit for outputting the other job in which the matching has been confirmed, to an output interface for each retrieved job based on the calculated matching degree.

19. An information processing device according to claim 18, further comprising:

a unit for identifying the other job in which the calculated matching degree of the data field attribute of the other job is equal to or more than a predetermined level,

wherein the unit for outputting the other job outputs the identified other job.

20. An information processing device according to claim 18, further comprising:

a unit for storing the matching degree of the data field attribute with the other job in a matching information table for each retrieved job in a state where the matching degree of the data field attribute with the other job is related with the retrieved job;

a unit for accessing the matching information table, recognizing the matching degree with the other job for each job, and identifying the other job having the highest matching degree for each job;

a unit for calculating frequencies in which the identified other jobs have been identified to have the highest matching degrees for the respective jobs; and

a unit for listing the identified other jobs in order of the frequencies and outputting the identified other jobs.