Method, system and computer product for integrating case based reasoning data and failure modes, effects and corrective action data

• US 7,103,610 B2
• Filed: 11/25/2002
• Issued: 09/05/2006
• Est. Priority Date: 11/25/2002
• Status: Expired due to Fees

• Current Assignee: General Electric Company
• Original Assignee: General Electric Company
• Inventors: Azzaro, Steven Hector, Cleary, Daniel Joseph, Johnson, Timothy Lee
• Primary Examiner(s): Rimell, Sam
• Assistant Examiner(s): Betit, Jacob F.
• Application Number:
  US10/302,440
• Publication Number:
  US 20040103121A1
• Time in Patent Office: 1,380 Days
• Field of Search: 707/1, 707/3, 707/100, 707/101, 707/102
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method of integrating case based reasoning data and FMECA data for product life cycle support. The method comprises creating an access path to case based data using a FMECA classification. The creating includes receiving a case based record including heading data. The heading data includes data elements and the data elements are correlated with data fields in a FMECA database. The FMECA database is searched for an entry that includes one or more of the data elements. The creating further includes determining if the entry should include a reference to the case based record. A new pointer to the case based record is inserted if the determining results in finding that the entry should include a reference to the case based record. The method for integrating case based reasoning data and FMECA data further comprises receiving a request from a user to access the case based data. The case based data is accessed via the FMECA database using the access path in response to the request.

Claims

1. A method of integrating case based data and FMECA data for product life cycle support, the method comprising:

creating an access path to case based data using a FMECA classification, wherein said creating includes;

receiving a case based record including heading data, wherein said heading data includes data elements;

correlating said data elements in said heading data with data fields in a FMECA database;

searching said FMECA database for an entry that includes one or more of said data elements;

determining if said entry should include a reference to said case based record; and

inserting a new pointer to said case based record in said entry if said determining results in finding that said entry should include a reference to said case based record;

receiving a request from a user to access said case based data; and

accessing said case based data via said FMECA database using said access path in response to said request.

2. The method of claim 1 wherein said access path is created for use in product service and said user is a product service provider.

3. The method of claim 1 wherein said access path is created for use in product upgrades and said user is a product upgrade design team member.

4. The method of claim 1 wherein said access path is created for use in self-service and said user is a product owner or customer.

5. The method of claim 1 wherein said determining includes:

assigning a hierarchical order to said data fields in said FMECA database;

evaluating said entry for a level of hierarchy match with said heading data; and

finding that said entry should include a reference to said case based record in response to said evaluating resulting in a hierarchy match of the lowest level relative to other entries that include one or more of said data elements.

6. The method of claim 1 wherein said heading data includes a data pointer to a storage location.

7. The method of claim 6 wherein said data element value is determined by accessing data stored at said storage location.

8. The method of claim 1 wherein said receiving a case based record occurs on a periodic basis.

9. The method of claim 1 wherein said receiving a case based record occurs in response to an update in said case based record.

10. The method of claim 1 wherein said receiving occurs in response to an update in said FMECA database.

11. The method of claim 1 wherein said case based record is stored in a case based database.

12. The method of claim 11 wherein said database is a relational database.

13. The method of claim 1 wherein said case based record is in an XML format including pointers to said heading data.

14. The method of claim 1 further comprising:

calculating an insertion position for said new pointer in response to said entry including an existing case based record pointer; and

reordering said existing case based record pointer in response to said calculating.

15. The method of claim 1 wherein said data elements include product line, customer complaint, system level symptom, trouble shooting procedure and repair procedure.

16. The method of claim 1 where said data elements include product line, product and customer complaint.

17. A system of integrating case based data and FMECA data for product life cycle support, the system comprising:

a network;

a first storage device including case based records;

a second storage device including a FMECA database in communication with said network;

a user system in communication with said network; and

a host system including a case based system in communication with said network and said first storage device, said case based system including software to implement a method comprising;

creating an access path to case based data stored on said first storage device using a FMECA classification, wherein said creating includes;

receiving a case based record across said network from said first storage device including heading data, wherein said heading data includes data elements;

correlating said data elements in said heading data with data fields in a FMECA database stored on said second storage device;

searching said FMECA database for an entry that includes one or more of said data elements;

determining if said entry should include a reference to said case based record; and

inserting a new pointer to said case based record if said determining results in finding that said entry should include a reference to said case based record;

receiving a request from a user on said user system to access said case based data; and

accessing said case based data via said FMECA database using said access path in response to said request.

18. The system of claim 17 wherein said first storage device and said second storage device are the same physical device.

19. The system of claim 17 wherein said network is the Internet.

20. The system of claim 17 wherein said network is an intranet.

21. A computer program product for integrating case based data and FMECA data for product life cycle support, the computer product comprising:

a storage medium readable by a processing circuit and storing instructions for execution by the processing circuit for performing a method comprising;

creating an access path to case based data using a FMECA classification, wherein said creating includes;

receiving a case based record including heading data, wherein said heading data includes data elements;

correlating said data elements in said heading data with data fields in a FMECA database;

searching said FMECA database for an entry that includes one or more of said data elements;

determining if said entry should include a reference to said case based record;

inserting a new pointer to said case based record in said entry if said determining results in finding that said entry should include a reference to said case based record; and

receiving a request from a user to access said case based data; and

accessing said case based data via said FMECA database using said access path in response to said request.