Open content interface for EH&S systems

• US 7,680,803 B2
• Filed: 06/21/2004
• Issued: 03/16/2010
• Est. Priority Date: 06/21/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Salomon, Thomas, Ambrosch, Wolfgang
• Primary Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US10/873,747
• Publication Number:
  US 20050283374A1
• Time in Patent Office: 2,094 Days
• Field of Search: 707/1, 707/2, 707/100, 707/102, 707/4, 707/10
• US Class Current: 1/1
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

Methods and apparatus for providing an open content interface from importing EH&S data. The invention provides a computer-implemented method that includes: receiving a first input specifying a substance described in a database of an EH&S system; identifying product data available for the substance, the identifying being based on information stored in a first XML file; generating and displaying a data tree that indicates the product data available for the substance, wherein information stored in the first XML file is used to generate the data tree; receiving a second input selecting which of the product data is to be imported to the database of the EH&S system; retrieving the product data from second XML file that includes the product data; using mapping information stored in a third XML file to map the product data retrieved into a data format supported by the EH&S system; and storing the mapped product data.

Claims

1. A computer-implemented method for importing product data into a database that stores the product data in a first format, wherein the product data is available from a content provider in a second format that is content-provider-specific, the method comprising:

receiving, at an import interface associated with the database, a mapping file that defines one or more mappings associated with the second format;

generating mapping rules for mapping a data structure corresponding to the second format to a data structure corresponding to the first format, wherein the mapping rules are generated using the mapping file, and wherein the mapping rules comprise one or more rules for mapping text for product data in the second format to different text for product data in the first format that conveys at least some of the same information as the text for product data in the second format;

receiving product data from the content provider via the import interface of the database, the received product data having the second format; and

importing the received product data into the database using the mapping rules;

wherein the mapping file comprises a header file comprising metadata that relates to product data in the second format.

4. The computer-implemented method of claim 1, 2, or 3, further comprising:

tracking selections of data;

storing tracked user selections; and

displaying stored user selections in a process for updating the database.

5. The computer-implemented method of claim 1, 2, or 3, wherein the received product data comprises information relating to at least one of substances, pharmaceuticals, chemicals, safety information, hazardous material management, dangerous goods, physical chemical information, list substances, and regulatory content.

6. The computer-implemented method of claim 1, 2, or 3, wherein the mapping file is received from the content provider.

7. The computer-implemented method of claim 1, 2, or 3, wherein the product data received from the content provider comprises a file comprising data for one product.

8. The computer-implemented method of claim 1, 2, or 3, further comprising, in the import interface:

parsing the received product data; and

validating a format of the received product data.

9. The computer-implemented method of claim 1, 2, or 3, further comprising:

receiving a selection that corresponds to product data to be imported into the database, the selection corresponding to the received product data.

2. A computer-implemented method for importing product data into a database that stores the product data in a first format, wherein the product data is available from a content provider in a second format that is content-provider-specific, the method comprising:

receiving, at an import interface associated with the database, a mapping file that defines one or more mappings associated with the second format;

generating mapping rules for mapping a data structure corresponding to the second format to a data structure corresponding to the first format, wherein the mapping rules are generated using the mapping file, and wherein the mapping rules comprise one or more rules for mapping text for product data in the second format to different text for product data in the first format that conveys at least some of the same information as the text for product data in the second format;

receiving product data from the content provider via the import interface of the database, the received product data having the second format; and

importing the received product data into the database using the mapping rules;

wherein the mapping file is in a markup-language file format.

3. A computer-implemented method for importing product data into a database that stores the product data in a first format, wherein the product data is available from a content provider in a second format that is content-provider-specific, the method comprising:

receiving, at an import interface associated with the database, a mapping file that defines one or more mappings associated with the second format;

generating mapping rules for mapping a data structure corresponding to the second format to a data structure corresponding to the first format, wherein the mapping rules are generated using the mapping file, and wherein the mapping rules comprise one or more rules for mapping text for product data in the second format to different text for product data in the first format that conveys at least some of the same information as the text for product data in the second format;

receiving product data from the content provider via the import interface of the database, the received product data having the second format;

importing the received product data into the database using the mapping rules;

configuring a filter for selecting a scope of product data to be imported; and

storing the filter and the mapping rules separately.

10. A computer system for importing product data from a content provider that keeps product data in a second format that is content-provider-specific, the computer system comprising:

a database for storing product data in a first format; and

an import interface in communication with the database and configured to receive product data from a content provider;

wherein the import interface is configured to;

receive a mapping file that defines one or more mappings associated with the second format;

generate mapping rules for mapping a data structure corresponding to the second format to a data structure corresponding to the first format, wherein the mapping rules are generated using the mapping file, and wherein the mapping rules comprise one or more rules for mapping text for product data in the second format to different text for product data in the first format that conveys at least some of the same information as the text for product data in the second format;

receive product data from the content provider, the received product data having the second format; and

import the received product data into the database using the mapping rules;

wherein the mapping file comprises a header file comprising metadata that relates to product data in the second format.

22. The computer system of claim 10, 20, or 21, wherein the received product data comprises information relating to at least one of substances, pharmaceuticals, chemicals, safety information, hazardous material management, dangerous goods, physical chemical information, list substances, and regulatory content.

23. The computer system of claim 10, 20, or 21, wherein the mapping file is received from the content provider.

24. The computer system of claim 10, 20, or 21, wherein the product data received from the content provider comprises a file comprising data for one product.

25. The computer system of claim 10, 20, or 21, wherein the import interface is further configured to:

parse the received product data; and

validate a format of the received product data.

26. The computer system of claim 10, 20, or 21, wherein the import interface is further configured to:

receive a selection that corresponds to product data to be imported into the database, the selection corresponding to the received product data.

11. A computer program product tangibly embodied in one or more machine-readable storage media, the computer program product comprising instructions that are executable to import product data into a database that stores the product data in a first format, wherein the product data is available from a content provider in a second format that is content-provider-specific, the instructions for:

receiving, at an import interface associated with the database, a mapping file that defines one or more mappings associated with the second format;

generating mapping rules for mapping a data structure corresponding to the second format to a data structure corresponding to the first format, wherein the mapping rules are generated using the mapping file, and wherein the mapping rules comprise one or more rules for mapping text for product data in the second format to different text for product data in the first format that conveys at least some of the same information as the text for product data in the second format;

receiving product data from the content provider via the import interface of the database, the received product data having the second format; and

importing the received product data into the database using the mapping rules;

wherein the mapping file comprises a header file comprising metadata that relates to product data in the second format.

14. The computer program product of claim 11, 12, or 13, further comprising instructions for:

tracking selections of data;

storing tracked selections; and

displaying stored selections in a process for updating the database.

15. The computer program product of claim 11, 12, or 13, wherein the received product data comprises information relating to at least one of substances, pharmaceuticals, chemicals, safety information, hazardous material management, dangerous goods, physical chemical information, list substances, and regulatory content.

16. The computer program product of claim 11, 12, or 13, wherein the mapping file is received from the content provider.

17. The computer program product of claim 11, 12, or 13, wherein the product data received from the content provider comprises a file comprising data for one product.

18. The computer program product of claim 11, 12, or 13, further comprising instructions for:

parsing the received product data; and

validating a format of the received product data.

19. The computer program product of claim 11, 12, or 13, further comprising instructions for:

receiving a selection that corresponds to product data to be imported into the database, the selection corresponding to the received product data.

12. A computer program product tangibly embodied in one or more machine-readable storage media, the computer program product comprising instructions that are executable to import product data into a database that stores the product data in a first format, wherein the product data is available from a content provider in a second format that is content-provider-specific, the instructions for:

receiving, at an import interface associated with the database, a mapping file that defines one or more mappings associated with the second format;

generating mapping rules for mapping a data structure corresponding to the second format to a data structure corresponding to the first format, wherein the mapping rules are generated using the mapping file, and wherein the mapping rules comprise one or more rules for mapping text for product data in the second format to different text for product data in the first format that conveys at least some of the same information as the text for product data in the second format;

receiving product data from the content provider via the import interface of the database, the received product data having the second format; and

importing the received product data into the database using the mapping rules;

wherein the mapping file is in a markup-language file format.

13. A computer program product tangibly embodied in one or more machine-readable storage media, the computer program product comprising instructions that are executable to import product data into a database that stores the product data in a first format, wherein the product data is available from a content provider in a second format that is content-provider-specific, the instructions for:

receiving, at an import interface associated with the database, a mapping file that defines one or more mappings associated with the second format;

generating mapping rules for mapping a data structure corresponding to the second format to a data structure corresponding to the first format, wherein the mapping rules are generated using the mapping file, and wherein the mapping rules comprise one or more rules for mapping text for product data in the second format to different text for product data in the first format that conveys at least some of the same information as the text for product data in the second format;

receiving product data from the content provider via the import interface of the database, the received product data having the second format;

importing the received product data into the database using the mapping rules;

configuring a filter for selecting a scope of product data to be imported; and

storing the filter file and the mapping rules separately.

20. A computer system for importing product data from a content provider that keeps product data in a second format that is content-provider-specific, the computer system comprising:

a database for storing product data in a first format; and

an import interface in communication with the database and configured to receive product data from a content provider;

wherein the import interface is configured to;

receive a mapping file that defines one or more mappings associated with the second format;

generate mapping rules for mapping a data structure corresponding to the second format to a data structure corresponding to the first format, wherein the mapping rules are generated using the mapping file, and wherein the mapping rules comprise one or more rules for mapping text for product data in the second format to different text for product data in the first format that conveys at least some of the same information as the text for product data in the second format;

receive product data from the content provider, the received product data having the second format; and

import the received product data into the database using the mapping rules;

wherein the mapping file is in a markup-language file format.

21. A computer system for importing product data from a content provider that keeps product data in a second format that is content-provider-specific, the computer system comprising:

a database for storing product data in a first format; and

an import interface in communication with the database and configured to receive product data from a content provider;

wherein the import interface is configured to;

receive a mapping file that defines one or more mappings associated with the second format;

generate mapping rules for mapping a data structure corresponding to the second format to a data structure corresponding to the first format, wherein the mapping rules are generated using the mapping file, and wherein the mapping rules comprise one or more rules for mapping text for product data in the second format to different text for product data in the first format that conveys at least some of the same information as the text for product data in the second format;

receive product data from the content provider, the received product data having the second format;

import the received product data into the database using the mapping rules;

configure a filter for selecting a scope of product data to be imported; and

store the filter and the mapping rules separately.