Method and system for master planning priority assignment

• US 20030028507A1
• Filed: 08/03/2001
• Published: 02/06/2003
• Est. Priority Date: 08/03/2001
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: MacKay, Grant Lindsey, Ervolina, Thomas Robert, Santo, Sarah Elizabeth, Kotecki, Amanda, Harrod, Darrell Lavern, Bundy, Michael Lee, Pauliks, Michael Georg, Kanuch, James
• Granted Patent: US 6,981,003 B2
• Time in Patent Office: Days
• US Class Current: 707/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/959 Network
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99936 Pattern matching access

Abstract

A method and system for performing master planning priority assignment is presented. The method includes assigning a priority to a demand record that contains at least one demand attribute and a priority field. The assignment includes identifying a database that contains priority assignment rules for demand records and then querying the rule database to find the database record that corresponds to the particular demand record. The corresponding database record is found by matching the data in the attribute fields in the rule database and the demand record. The priority associated with the matching priority database record is assigned to the demand record. Additional embodiments include a system and storage medium for performing master planning priority assignment.

Claims

1. A method for performing master planning priority assignment, the method comprising:

assigning a priority to a demand record, said demand record containing a demand record attribute field and a demand record priority field;

said assigning including;

identifying a rule database, said rule database including at least one record, a rule database attribute field that correlates to said demand record attribute field, and a rule database priority field;

querying said rule database for a corresponding rule database record that contains data in said rule database attribute field that matches data in said demand record attribute field; and

updating data in said demand record priority field with data from said corresponding rule database priority field.

2. The method of claim 1 wherein said data in said corresponding rule database attribute field contains an explicit value.

3. The method of claim 1 wherein said data in said corresponding rule database attribute field contains a hierarchy value and said match occurs if said data in said demand record attribute field is contained within said hierarchy value.

4. The method of claim 1 wherein said data in said corresponding rule database attribute field contains a wildcard value and said data in said demand record attribute field is not used in said matching.

5. The method of claim 1 wherein said demand record attribute field includes due date, customer, and demand type.

6. The method of claim 1 further comprising creating said rule database.

7. The method of claim 1 further comprising updating said at least one record in said rule database.

8. The method of claim 1 further comprising creating a hierarchy value, said hierarchy value containing a hierarchy value.

9. The method of claim 1 further comprising creating a hierarchy value, said hierarchy value containing an explicit value.

10. A method for master planning priority assignment, the method comprising:

assigning a priority to a demand record, said demand record containing a demand record attribute field and a demand record priority field;

said assigning including;

identifying a rule database, said rule database including at least one record, a rule database attribute field that correlates to said demand record attribute field, and a rule database priority field;

querying said rule database for a corresponding rule database record that contains data in said rule database attribute field that matches data in said demand record attribute field, said matching comprising;

querying said rule database for an explicit data match;

if no said explicit data match exists querying said rule database for a hierarchy value match; and

;

if no said explicit data match or said hierarchy value data match exists querying said rule database for a wildcard match; and

updating data in said demand record priority field with data from said corresponding rule database priority field.

11. A system for performing master planning priority assignment, the system comprising:

a storage device storing master planning priority assignment data;

a user system; and

a host system in communication with said storage device and said user systems, said host system implementing a process comprising;

assigning a priority to a demand record, said demand record containing a demand record attribute field and a demand record priority field;

said assigning including;

identifying a rule database, said rule database including at least one record, a rule database attribute field that correlates to said demand record attribute field, and a rule database priority field;

querying said rule database for a corresponding rule database record that contains data in said rule database attribute field that matches data in said demand record attribute field; and

updating data in said demand record priority field with data from said corresponding rule database priority field.

12. The system of claim 11 wherein said wherein said data in said corresponding rule database attribute field contains an explicit value.

13. The system of claim 11 wherein said data in said corresponding rule database attribute field contains a hierarchy value and said match occurs if said data in said demand record attribute field is contained within said hierarchy value.

14. The system of claim 11 wherein said data in said corresponding rule database attribute field contains a wildcard value and said data in said demand record attribute field is not used in said matching.

15. The system of claim 11 wherein said demand record attribute field includes due date, customer, and demand type.

16. The system of claim 11 wherein said host system implementing a process further comprises creating said rule database.

17. The system of claim 11 wherein said host system implementing a process further comprises updating said at least one record in said rule database.

18. The system of claim 11 wherein said host system implementing a process further comprises creating a hierarchy value, said hierarchy value containing a hierarchy value.

19. The system of claim 11 wherein said host system implementing a process further comprises creating a hierarchy value, said hierarchy value containing an explicit value.

20. The system of claim 11 further comprising a network providing communication between the host system and the user system.

21. The system of claim 11 further comprising a network providing communication between the storage device and the host system.

22. A system for performing master planning priority assignment, the system comprising:

a storage device storing master planning priority assignment data;

a user system; and

a host system in communication with said storage device and said user systems, said host system implementing a process comprising;

assigning a priority to a demand record, said demand record containing a demand record attribute field and a demand record priority field;

said assigning including;

identifying a rule database, said rule database including at least one record, a rule database attribute field that correlates to said demand record attribute field, and a rule database priority field;

querying said rule database for a corresponding rule database record that contains data in said rule database attribute field that matches data in said demand record attribute field, said matching comprising;

querying said rule database for an explicit data match;

if no said explicit data match exists querying said rule database for a hierarchy value match; and

;

if no said explicit data match or said hierarchy value data match exists querying said rule database for a wildcard match; and

updating data in said demand record priority field with data from

said corresponding rule database priority field.

23. A storage medium encoded with machine-readable computer program code for performing master planning priority assignment, the storage medium storing instructions for causing a host system to implement a method comprising:

assigning a priority to a demand record, said demand record containing a demand record attribute field and a demand record priority field;

said assigning including;

identifying a rule database, said rule database including at least one record, a rule database attribute field that correlates to said demand record attribute field, and a rule database priority field;

querying said rule database for a corresponding rule database record that contains data in said rule database attribute field that matches data in said demand record attribute field; and

updating data in said demand record priority field with data from said corresponding rule database priority field.

24. The storage medium of claim 23 wherein said data in said corresponding rule database attribute field contains an explicit value.

25. The storage medium of claim 23 wherein said data in said corresponding rule database attribute field contains a hierarchy value and said match occurs if said data in said demand record attribute field is contained within said hierarchy value.

26. The storage medium of claim 23 wherein said data in said corresponding rule database attribute field contains a wildcard value and said data in said demand record attribute field is not used in said matching.

27. The storage medium of claim 23 wherein said demand record attribute field includes due date, customer, and demand type.

28. The storage medium of claim 23 further comprising creating said rule database.

29. The storage medium of claim 23 further comprising updating said at least one record in said rule database.

30. The storage medium of claim 23 further comprising creating a hierarchy value, said hierarchy value containing a hierarchy value.

31. The storage medium of claim 23 further comprising creating a hierarchy value, said hierarchy value containing an explicit value.

32. A storage medium encoded with machine-readable computer program code for performing master planning priority assignment, the storage medium storing instructions for causing a host system to implement a method comprising:

assigning a priority to a demand record, said demand record containing a demand record attribute field and a demand record priority field;

said assigning including;

identifying a rule database, said rule database including at least one record, a rule database attribute field that correlates to said demand record attribute field, and a rule database priority field;

querying said rule database for a corresponding rule database record that contains data in said rule database attribute field that matches data in said demand record attribute field, said matching comprising;

querying said rule database for an explicit data match;

if no said explicit data match exists querying said rule database for a hierarchy value match; and

;

if no said explicit data match or said hierarchy value data match exists querying said rule database for a wildcard match; and

updating data in said demand record priority field with data from said corresponding rule database priority field.