Method and system for providing continuous reference architecture and bill of material modeling

• US 10,445,695 B2
• Filed: 09/04/2015
• Issued: 10/15/2019
• Est. Priority Date: 09/04/2015
• Status: Active Grant

• Current Assignee: Dell Products LP (Dell Technologies Inc.)
• Original Assignee: Dell Products LP (Dell Technologies Inc.)
• Inventors: Chaganti, Ravikanth
• Primary Examiner(s): Masud, Rokib
• Application Number:
  US14/846,375
• Publication Number:
  US 20170068931A1
• Time in Patent Office: 1,502 Days
• Field of Search: 705 16, 705 29
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials

Abstract

A method for generating bill of material data for complex systems comprising storing a plurality of electronic documents in a standardized format using an electronic data storage device, where each electronic document has an associated solution identifier data field and one or more associated bill of materials data fields. Receiving a query request over a data network in an electronic data format that includes a query solution identifier data field. Extracting electronic data documents having a matching data field value to the solution identifier data field. Extracting the bill of materials data fields for each electronic document using data processing equipment. Assembling a compilation of the bill of materials data fields from each of the extracted electronic data documents.

Claims

1. A method for generating bill of material data for complex systems comprising:

storing a plurality of electronic documents in a standardized format using an electronic data storage device, where each electronic document has an associated unique solution identifier data field and one or more associated bill of materials data fields;

receiving a query request over a data network in an electronic data format that includes a query solution identifier data field;

extracting electronic data documents having a matching data field value to the solution identifier data field;

extracting the bill of materials data fields for each electronic document using data processing equipment;

assembling a compilation of the bill of materials data fields from each of the extracted electronic data documents;

determining whether an end of life component is included in the bill of materials data as a function of product offering cycle data for the component; and

implementing a remediation policy in response to the end of life component to identify a replacement component that is compatible with the solution.

2. The method of claim 1 wherein storing the plurality of electronic documents in the standardized format using the electronic data storage device, where each electronic document has the associated unique solution identifier data field and one or more associated bill of materials data fields comprises storing the plurality of electronic documents in an Open Packaging Convention format using the electronic data storage device, where each electronic document has the associated solution identifier data field and one or more associated bill of materials data fields.

3. The method of claim 1 wherein receiving the query request over the data network in the electronic data format that includes the query solution identifier data field comprises receiving the query request over the data network in a Javascript Object Notation format that includes the query solution identifier data field.

4. The method of claim 1 wherein extracting the electronic data documents having the matching data field value to the solution identifier data field comprises accessing one or more data records storing stock keeping unit data.

5. The method of claim 1 wherein extracting the bill of materials data fields for each electronic document using the data processing equipment comprises accessing one or more data records of an inventory system.

6. The method of claim 1 wherein assembling the compilation of the bill of materials data fields from each of the extracted electronic data documents comprises assembling the compilation of the bill of materials data fields from each of the extracted electronic data documents in a data structure having a standardized format.

7. The method of claim 1 wherein storing the plurality of electronic documents in the standardized format using the electronic data storage device comprises:

receiving a new electronic document; and

extracting a solution identifier from the new electronic document.

8. The method of claim 1 wherein storing the plural of electronic documents in the standardized format using the electronic data storage device comprises:

receiving a new electronic document;

extracting a solution identifier from the new electronic document; and

generating bill of materials data for the new electronic document.

9. The method of claim 1 wherein storing the plurality of electronic documents in the standardized format using the electronic data storage device comprises:

receiving a new electronic document;

extracting a solution identifier from the new electronic document;

generating bill of materials data for the new electronic document; and

determining whether there are any end of life components in the bill of materials.

10. The method of claim 1 wherein storing the plurality of electronic documents in the standardized format using the electronic data storage device comprises:

receiving a new electronic document;

extracting a solution identifier from the new electronic document;

generating bill of materials data for the new electronic document;

determining whether there are any end of life components in the bill of materials; and

determining whether a remediation policy can be applied to the end of life components in the bill of materials.

11. The method of claim 1 wherein storing the plurality of electronic documents in the standardized format using the electronic data storage device comprises:

receiving a new electronic document;

extracting a solution identifier from the new electronic document;

generating bill of materials data for the new electronic document;

determining whether there are any end of life components in the bill of materials;

determining whether a remediation policy can be applied to the end of life components in the bill of materials; and

generating a flag if it is determined that the remediation policy cannot be applied to the end of components in the bill of materials.

12. The method of claim 1 wherein storing the plurality of electronic documents in the standardized format using the electronic data storage device comprises:

receiving a new electronic document;

extracting a solution identifier from the new electronic document;

generating bill of materials data for the new electronic document;

determining whether there are any end of life components in the bill of materials;

determining whether a remediation policy can be applied to the end of life components in the bill of materials; and

converting the document to a data store format.

13. The method of claim 1 wherein storing the plurality of electronic documents in the standardized format using the electronic data storage device comprises:

receiving a new electronic document;

extracting a solution identifier from the new electronic document;

generating bill of materials data for the new electronic document;

determining whether there are any end of life components in the bill of materials;

determining whether a remediation policy can be applied to the end of life components in the bill of materials;

converting the document to a data store format; and

determining whether the document has been updated.

14. The method of claim 13 further comprising extracting a solution identifier from the document if the document has been updated.

15. The method of claim 1 wherein storing the plurality of electronic documents in the standardized format using the electronic data storage device comprises:

receiving an updated electronic document;

extracting a solution identifier from the updated electronic document;

generating bill of materials data for the updated electronic document;

determining whether there are any end of life components in the bill of materials;

determining whether a remediation policy can be applied to the end of life components in the bill of materials; and

converting the document to a data store format.

16. The method of claim 1 wherein storing the plurality of electronic documents in the standardized format using the electronic data storage device comprises:

receiving an updated electronic document;

extracting a solution identifier from the updated electronic document;

generating bill of materials data for the updated electronic document using an ordering system;

determining whether there are any end of life components in the bill of materials; and

converting the document to a data store format if it is determined that there are no end of life components.

17. A method for generating bill of material data for complex systems comprising:

storing a plurality of electronic documents in a standardized format using an electronic data storage device, where each electronic document has an associated unique solution identifier data field and one or more associated bill of materials data fields;

receiving a query request over a data network in an electronic data format that includes a query solution identifier data field;

extracting electronic data documents having a matching data field value to the solution identifier data field;

extracting the bill of materials data fields for each electronic document using data processing equipment;

assembling a compilation of the bill of materials data fields from each of the extracted electronic data documents;

wherein extracting the bill of materials data fields for each electronic document further comprises;

determining whether an end of life component is included in the bill of materials data as a function of product offering cycle data for the component; and

implementing a remediation policy in response to the end of life component to identify a replacement component that is compatible with the solution;

wherein storing the plurality of electronic documents in the standardized format using the electronic data storage device, where each electronic document has the associated solution identifier data field and one or more associated bill of materials data fields comprises storing the plurality of electronic documents in an Open Packaging Convention format using the electronic data storage device, where each electronic document has the associated solution identifier data field and one or more associated bill of materials data fields;

wherein receiving the query request over the data network in the electronic data format that includes the query solution identifier data field comprises receiving the query request over the data network in a Javascript Object Notation format that includes the query solution identifier data field;

wherein extracting the electronic data documents having the matching data field value to the solution identifier data field comprises accessing one or more data records storing stock keeping unit data;

wherein extracting the bill of materials data fields for each electronic document using the data processing equipment comprises accessing one or more data records of an inventory system;

wherein assembling the compilation of the bill of materials data fields from each of the extracted electronic data documents comprises assembling the compilation of the bill of materials data fields from each of the extracted electronic data documents in a data structure having a standardized format;

receiving a new electronic document;

extracting a solution identifier from the new electronic document;

generating bill of materials data for the new electronic document;

determining whether there are any end of life components in the bill of materials;

determining whether a remediation policy can be applied to the end of life components in the bill of materials; and

generating a flag if it determined that the remediation policy cannot be applied to the end of life components in the bill of materials.