WO2009005823A2 - Document validation system and method - Google Patents
Document validation system and method Download PDFInfo
- Publication number
- WO2009005823A2 WO2009005823A2 PCT/US2008/008255 US2008008255W WO2009005823A2 WO 2009005823 A2 WO2009005823 A2 WO 2009005823A2 US 2008008255 W US2008008255 W US 2008008255W WO 2009005823 A2 WO2009005823 A2 WO 2009005823A2
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- document
- certification
- documents
- database
- supplier
- Prior art date
Links
- 238000000034 method Methods 0.000 title claims abstract description 108
- 238000010200 validation analysis Methods 0.000 title description 74
- 239000000463 material Substances 0.000 claims description 171
- 238000013519 translation Methods 0.000 claims description 26
- 230000004044 response Effects 0.000 claims description 6
- 230000002110 toxicologic effect Effects 0.000 claims description 3
- 231100000723 toxicological property Toxicity 0.000 claims description 3
- 238000013068 supply chain management Methods 0.000 abstract description 3
- 239000000047 product Substances 0.000 description 83
- 239000000126 substance Substances 0.000 description 81
- 238000012545 processing Methods 0.000 description 52
- 238000011144 upstream manufacturing Methods 0.000 description 36
- 230000014616 translation Effects 0.000 description 25
- 230000006870 function Effects 0.000 description 23
- 235000013305 food Nutrition 0.000 description 20
- 231100000647 material safety data sheet Toxicity 0.000 description 19
- 239000000203 mixture Substances 0.000 description 15
- 238000010586 diagram Methods 0.000 description 13
- 239000002994 raw material Substances 0.000 description 13
- 238000012552 review Methods 0.000 description 13
- 230000008569 process Effects 0.000 description 12
- 238000012360 testing method Methods 0.000 description 12
- 238000009472 formulation Methods 0.000 description 11
- 239000002480 mineral oil Substances 0.000 description 11
- 230000001105 regulatory effect Effects 0.000 description 11
- 238000013475 authorization Methods 0.000 description 10
- 235000010446 mineral oil Nutrition 0.000 description 10
- LDHQCZJRKDOVOX-NSCUHMNNSA-N crotonic acid Chemical compound C\C=C\C(O)=O LDHQCZJRKDOVOX-NSCUHMNNSA-N 0.000 description 9
- 238000004458 analytical method Methods 0.000 description 7
- 230000008859 change Effects 0.000 description 7
- LDHQCZJRKDOVOX-UHFFFAOYSA-N trans-crotonic acid Natural products CC=CC(O)=O LDHQCZJRKDOVOX-UHFFFAOYSA-N 0.000 description 7
- 238000004422 calculation algorithm Methods 0.000 description 6
- 230000000694 effects Effects 0.000 description 6
- 239000012634 fragment Substances 0.000 description 6
- 238000013439 planning Methods 0.000 description 6
- -1 polyethylene Polymers 0.000 description 6
- 239000004698 Polyethylene Substances 0.000 description 5
- 238000000605 extraction Methods 0.000 description 5
- 238000007726 management method Methods 0.000 description 5
- 238000012986 modification Methods 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 229920000573 polyethylene Polymers 0.000 description 5
- PXLIDIMHPNPGMH-UHFFFAOYSA-N sodium chromate Chemical compound [Na+].[Na+].[O-][Cr]([O-])(=O)=O PXLIDIMHPNPGMH-UHFFFAOYSA-N 0.000 description 5
- 235000005976 Citrus sinensis Nutrition 0.000 description 4
- 240000002319 Citrus sinensis Species 0.000 description 4
- 230000008901 benefit Effects 0.000 description 4
- 238000013070 change management Methods 0.000 description 4
- 235000020971 citrus fruits Nutrition 0.000 description 4
- 238000011156 evaluation Methods 0.000 description 4
- 239000000284 extract Substances 0.000 description 4
- 230000008676 import Effects 0.000 description 4
- 229910052500 inorganic mineral Inorganic materials 0.000 description 4
- 239000011707 mineral Substances 0.000 description 4
- UHOVQNZJYSORNB-UHFFFAOYSA-N Benzene Chemical compound C1=CC=CC=C1 UHOVQNZJYSORNB-UHFFFAOYSA-N 0.000 description 3
- RAHZWNYVWXNFOC-UHFFFAOYSA-N Sulphur dioxide Chemical group O=S=O RAHZWNYVWXNFOC-UHFFFAOYSA-N 0.000 description 3
- 238000013459 approach Methods 0.000 description 3
- 230000000711 cancerogenic effect Effects 0.000 description 3
- JOPOVCBBYLSVDA-UHFFFAOYSA-N chromium(6+) Chemical class [Cr+6] JOPOVCBBYLSVDA-UHFFFAOYSA-N 0.000 description 3
- 238000004891 communication Methods 0.000 description 3
- 150000001875 compounds Chemical class 0.000 description 3
- 239000000356 contaminant Substances 0.000 description 3
- 239000004033 plastic Substances 0.000 description 3
- 229920003023 plastic Polymers 0.000 description 3
- 238000002360 preparation method Methods 0.000 description 3
- YBJHBAHKTGYVGT-ZKWXMUAHSA-N (+)-Biotin Chemical compound N1C(=O)N[C@@H]2[C@H](CCCCC(=O)O)SC[C@@H]21 YBJHBAHKTGYVGT-ZKWXMUAHSA-N 0.000 description 2
- 229920000877 Melamine resin Polymers 0.000 description 2
- 240000006365 Vitis vinifera Species 0.000 description 2
- 235000014787 Vitis vinifera Nutrition 0.000 description 2
- 230000009471 action Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 2
- 230000015572 biosynthetic process Effects 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- 231100000315 carcinogenic Toxicity 0.000 description 2
- 239000002385 cottonseed oil Substances 0.000 description 2
- 235000012343 cottonseed oil Nutrition 0.000 description 2
- 230000003247 decreasing effect Effects 0.000 description 2
- 230000007812 deficiency Effects 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 239000003814 drug Substances 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000007613 environmental effect Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 239000004615 ingredient Substances 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- JDSHMPZPIAZGSV-UHFFFAOYSA-N melamine Chemical compound NC1=NC(N)=NC(N)=N1 JDSHMPZPIAZGSV-UHFFFAOYSA-N 0.000 description 2
- 239000010461 other edible oil Substances 0.000 description 2
- 239000011087 paperboard Substances 0.000 description 2
- 229920000098 polyolefin Polymers 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 150000003839 salts Chemical class 0.000 description 2
- 210000002966 serum Anatomy 0.000 description 2
- 230000009897 systematic effect Effects 0.000 description 2
- 230000000699 topical effect Effects 0.000 description 2
- 235000013311 vegetables Nutrition 0.000 description 2
- 235000013618 yogurt Nutrition 0.000 description 2
- 208000010444 Acidosis Diseases 0.000 description 1
- 229930195730 Aflatoxin Natural products 0.000 description 1
- XWIYFDMXXLINPU-UHFFFAOYSA-N Aflatoxin G Chemical compound O=C1OCCC2=C1C(=O)OC1=C2C(OC)=CC2=C1C1C=COC1O2 XWIYFDMXXLINPU-UHFFFAOYSA-N 0.000 description 1
- 235000017060 Arachis glabrata Nutrition 0.000 description 1
- 244000105624 Arachis hypogaea Species 0.000 description 1
- 235000010777 Arachis hypogaea Nutrition 0.000 description 1
- 235000018262 Arachis monticola Nutrition 0.000 description 1
- 241000894006 Bacteria Species 0.000 description 1
- 235000002568 Capsicum frutescens Nutrition 0.000 description 1
- 241000207199 Citrus Species 0.000 description 1
- 244000089742 Citrus aurantifolia Species 0.000 description 1
- 235000008733 Citrus aurantifolia Nutrition 0.000 description 1
- 235000005979 Citrus limon Nutrition 0.000 description 1
- 244000131522 Citrus pyriformis Species 0.000 description 1
- 231100000678 Mycotoxin Toxicity 0.000 description 1
- 239000004677 Nylon Substances 0.000 description 1
- 235000011941 Tilia x europaea Nutrition 0.000 description 1
- 241000700605 Viruses Species 0.000 description 1
- 239000002253 acid Substances 0.000 description 1
- 239000005409 aflatoxin Substances 0.000 description 1
- QMAYBMKBYCGXDH-UHFFFAOYSA-N alpha-amorphene Natural products C1CC(C)=CC2C(C(C)C)CC=C(C)C21 QMAYBMKBYCGXDH-UHFFFAOYSA-N 0.000 description 1
- 230000001147 anti-toxic effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 235000013361 beverage Nutrition 0.000 description 1
- 239000003124 biologic agent Substances 0.000 description 1
- 229960002685 biotin Drugs 0.000 description 1
- 235000020958 biotin Nutrition 0.000 description 1
- 239000011616 biotin Substances 0.000 description 1
- 231100000357 carcinogen Toxicity 0.000 description 1
- 239000003183 carcinogenic agent Substances 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 150000001845 chromium compounds Chemical class 0.000 description 1
- 238000000576 coating method Methods 0.000 description 1
- 230000000052 comparative effect Effects 0.000 description 1
- 239000002131 composite material Substances 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 235000015872 dietary supplement Nutrition 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 235000011869 dried fruits Nutrition 0.000 description 1
- 229940079593 drug Drugs 0.000 description 1
- HJUFTIJOISQSKQ-UHFFFAOYSA-N fenoxycarb Chemical compound C1=CC(OCCNC(=O)OCC)=CC=C1OC1=CC=CC=C1 HJUFTIJOISQSKQ-UHFFFAOYSA-N 0.000 description 1
- 235000013373 food additive Nutrition 0.000 description 1
- 239000002778 food additive Substances 0.000 description 1
- 239000005003 food packaging material Substances 0.000 description 1
- 235000003599 food sweetener Nutrition 0.000 description 1
- 231100001261 hazardous Toxicity 0.000 description 1
- 239000000383 hazardous chemical Substances 0.000 description 1
- 230000036541 health Effects 0.000 description 1
- 230000008821 health effect Effects 0.000 description 1
- 229930195733 hydrocarbon Natural products 0.000 description 1
- 150000002430 hydrocarbons Chemical class 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000002372 labelling Methods 0.000 description 1
- 239000004571 lime Substances 0.000 description 1
- 238000011068 loading method Methods 0.000 description 1
- 239000000314 lubricant Substances 0.000 description 1
- WSFSSNUMVMOOMR-NJFSPNSNSA-N methanone Chemical compound O=[14CH2] WSFSSNUMVMOOMR-NJFSPNSNSA-N 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 239000002636 mycotoxin Substances 0.000 description 1
- 229920001778 nylon Polymers 0.000 description 1
- 231100000616 occupational exposure limit Toxicity 0.000 description 1
- 239000003921 oil Substances 0.000 description 1
- 235000019198 oils Nutrition 0.000 description 1
- 235000020232 peanut Nutrition 0.000 description 1
- 239000002304 perfume Substances 0.000 description 1
- 239000000447 pesticide residue Substances 0.000 description 1
- 229920000642 polymer Polymers 0.000 description 1
- 238000012805 post-processing Methods 0.000 description 1
- 230000001681 protective effect Effects 0.000 description 1
- 229920005989 resin Polymers 0.000 description 1
- 239000011347 resin Substances 0.000 description 1
- 238000011076 safety test Methods 0.000 description 1
- 238000005070 sampling Methods 0.000 description 1
- 230000035945 sensitivity Effects 0.000 description 1
- 239000000344 soap Substances 0.000 description 1
- 235000014347 soups Nutrition 0.000 description 1
- 239000003381 stabilizer Substances 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
- 239000003765 sweetening agent Substances 0.000 description 1
- 230000001225 therapeutic effect Effects 0.000 description 1
- 231100000041 toxicology testing Toxicity 0.000 description 1
- 239000003053 toxin Substances 0.000 description 1
- 231100000765 toxin Toxicity 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/18—Legal services
Definitions
- the present invention relates generally to the field of self- validating documents in supply chain management, documentation services, method and data processing system for creating the same.
- a letter of certification or compliance certification document from the supplier of food and consumer products contains control statements that communicate requirements applicable to the use of the product.
- a certification document might accompany the supplier's shipment of a food packaging material to stipulate that the product could be used only with certain types of foodstuffs under the requirements of the Food and Drug Administration or similar governmental agencies of other countries.
- Such certifications may relate to regulations, standards, religious codes (e.g., keeping Kosher), scientific studies and the like. Millions of such documents are generated and transmitted every year in many different languages and countries for many different types of products and uses.
- the recipient may wish to use the product in a different market or area of the world, and is unable to relate the control statements relevant in one jurisdiction to parameters of use in other jurisdictions or areas. Independently of the supplier's certifications the recipient may also simply wish to review the control statements in a certification document to determine whether information is missing or for which he requires additional information by reviewing the source document of such a statement. Finally, the recipient may wish to relate the general information conveyed about the product in the received document to information about a specific shipment of that product received from the supplier where the shipment has, for example, a particular RFID code. This last aspect is especially important where a product recall or alert has occurred for specific shipments of a product.
- control statements are not simply a one-to-one relationship between a supplier and a customer, but rather between a many-to-one relationship of multiple upstream suppliers in a supply chain with the customer.
- the customer may receive a certification document with control statements that depend upon the specific claims of an upstream manufacturer of raw materials used by the immediate supplier of the customer; however, the upstream manufacturer may be unwilling to disclose important source information to the immediate supplier without a non-disclosure agreement, because of claims of confidentiality or trade secrecy.
- a manufacturer of a plastic sells to a small converter that produces formed cups to a yogurt food processor.
- the small converter may provide certifications, but these depend on the materials used in the conversion process. Often it is not the certification statement itself that is confidential; rather it is the source document supporting the statement that is confidential (e.g., test results or toxicological study).
- the yogurt food processor has a critical need to be assured of claims or compliance certifications that include both the immediate supplier and the upstream raw material suppliers.
- HACCP Hazard Analysis and Critical Control Point
- the supplier may have proprietary evidence to support a certification and may not have revealed the full composition of a formulation under restrictions on the disclosure of confidential business information, in which case an independent evaluation is limited. Nevertheless, the customer can perform many checks based on the information presented by the supplier, and may as a standard practice adopt a review and validation of a supplier's certification statements.
- VOLVO Corporate Standard STD 1009,11 (Established 2/1998) CHEMICAL SUBSTANCES WHOSE USE WITHIN THE VOLVO GROUP SHALL BE LIMITED (VOLVO'S GREY LIST) .
- a customer has several validation needs:
- Upstream Supplier Certifications Access to upstream supplier certifications relating to the immediate supplier's product or changes in these certifications under authorized terms and conditions acceptable to the upstream supplier. 22]
- Today, suppliers and customers seek to establish checks within their business processes and to establish review systems within their organizations, but it is prone to error and oversight especially in light of the complexity of global markets. The reason is straightforward: These review systems are separated from the certification document itself.
- the present invention provides a data processing system to support automatic validation and addresses this need.
- ERP enterprise resource planning systems
- SAP e.g., SAP EH&S
- the components of such systems often include:
- Transaction control tables that include data that prevents or alerts the potential shipment, purchase, import, export, or sale of a product that may be forbidden;
- Document databases that include the generated documents or other documents that may be associated with a product, substance, or process.
- ERP and document authoring systems as SAP EH&S, do not today include a dynamic component, such as a hyperlink, in phrase libraries of control statements used in the creation of certification documents, one that permits the recipient to validate a control statement within a received document in an automatic manner; • ERP and document authoring systems do not provide for validation of control statements through automatic means in generated certification documents for products from within the generated documents;
- Google® returns two thousand five hundred and twenty (2,520) document references. Entering a synonym, "(E)-2-Butenoic acid” returns only twenty-two (22) document references. A Dutch synonym, "Crotonzuur” returns no hits and the message: "Try different keywords”.
- This search illustrates both a searching display and a searching index that does not return document references that include a compilation of not only direct references, but also synonyms or translations of a material term. This is a common approach of existing search displays and indexing methods, for example, Google®, SCOPUS®, ILLUMINA®, and others.
- the search term and interest in a reference to a broad group may not necessarily be a chemical, but also a foodstuff, biologic, or formulation.
- a comprehensive search for the term, "orange”, according to the present invention, should return a link to a document including a reference to "citrus fruits, except lemon and limes".
- Current search systems may return synonyms, (e.g., TOXNET) and may include related identifiers and translations of substance names, but do not include a systematic cross-referencing system for such; nor do they include parent classes within the context of the regulation or referenced document.
- An identifier for a material is a particular type of synonym. Many such identification systems are used by regulatory or scientific organizations, where an alphanumeric code represents a material. For example, the European Union uses EINECS numbers to refer to existing chemicals. FDA has its own system, as do the governments of Japan and Korea. Other systems, include color index numbers, etc. It is desirable to provide a system and method that spans any identifier returning documents that include a reference, whether that reference is a synonym, translation, parent group or class, or identifier in addition to any direct reference.
- Web-based search engines do not include such features whether in the simultaneous display of document links containing references to synonyms, translations, identifiers, and parent groups in addition to direct references or whether in methods used to index documents to extract references to such terms.
- One embodiment of the present invention includes a system for validating at least a portion of a certification document for at least one material.
- the system includes a certification document including at least one dynamic control statement relating to and defining parameters of use for the at least one material, wherein the certification document is accessible by at least one recipient, and, wherein the dynamic control statement is validated by retrieving validation information relating to the dynamic control statement from a dynamic source of validation information.
- Another embodiment of the present invention includes a method for indexing documents in a data processing system, the documents including a reference to at least one material, comprising: inputting a document into the data processing system; extracting at least one alphanumeric string from the document; determining relevant alphanumeric strings from the extracted alphanumeric strings by processing the extracted alphanumeric strings utilizing at least one algorithm by comparing, in sequence and in combination, the extracted alphanumeric strings with material terms in at least a dictionary database of common material terms; matching the relevant alphanumeric strings with materials alphanumeric strings stored in the data processing system; and storing the matched alphanumeric strings in respective matched records in the data processing system.
- Another embodiment of the present invention provides methods for generating, distributing, validating, and searching documents about products that include standardized phrases that are claims made about the compliance of the product with guidelines, standards, and laws or that are properties of the product supported by a bibliographic reference to a literature reference.
- Yet another embodiment of the invention provides for a database of standard phrases (hyperlinked standard phrase database) each with its own with unique identification code, a text phrase that defines a specific claim or statement, optional translated variants of the text phrase in a one-to-one relationship to the unique identification code, and a hyperlink to a server that can retrieve a document or translation supporting the specific claim made by the standard phrase.
- standard phrases hyperlinked standard phrase database
- the Hyperlinked Standard Phrase Database can be distributed and used by many parties in the supply chain so that any document generated that includes the phrase will have a standard meaning and any recipient of the document can validate the statement through clicking on the hyperlink.
- Another embodiment of the invention provides for the Hyperlinked Standard Phrase Library Database including a hyperlink that will return an index, compilation or reference to all changes in the source documents relating to the statement.
- a further aspect of the method above is that it allows the author of the document to use a standard enterprise resource planning system (ERP), such as SAP, Oracle, or other document authoring system to include standard phrases from the phrase database as well as his or her own phrases in a flexible manner so that the document can contain a combination of phrases that are standard, other phrases from upstream suppliers of raw materials, and phrases inserted by the document's author.
- ERP enterprise resource planning system
- SAP SAP, Oracle
- other document authoring system to include standard phrases from the phrase database as well as his or her own phrases in a flexible manner so that the document can contain a combination of phrases that are standard, other phrases from upstream suppliers of raw materials, and phrases inserted by the document's author.
- the standard phrases can be selected based on need by the document's author in a completely free and flexible manner.
- the standard phrase will have a hyperlink to a document or function retrieving the relevant text.
- the standardization of the hyperlinks permits the recipient of a document in any form that accepts hyperlinks to retrieve source documents associated with a claim from a centralized service that can route and retrieve hyperlinked source documents from any server wherever located.
- a further aspect of the method above is that it allows for a system of user authorization associated with standard phrases contained in generated product documents.
- an upstream supplier can pass to his direct customer a statement with a hyperlink to a secure server open only to authorized users.
- the statement is public but the source documents supporting the claim are confidential.
- the customer can include the statement in an authored document and distribute the document to his downstream customers, but the control to open access to the confidential supporting document is controlled by the provider of the standard phrase.
- Another embodiment of the present invention also relates to a method for indexing documents including a description of at least one material in a data processing system.
- the method includes inputting a document into the data processing system; extracting at least one alphanumeric string from the document; determining relevant alphanumeric strings from the extracted alphanumeric strings by processing the extracted alphanumeric strings utilizing at least one algorithm by comparing, in sequence and in combination, the extracted alphanumeric strings with material terms in at least a dictionary database of common material terms; matching the relevant alphanumeric strings with materials alphanumeric strings stored in the data processing system; and storing the matched alphanumeric strings in respective matched records in the data processing system.
- Another embodiment of the present invention provides methods for searching document management systems and an improved means of efficiently locating, searching, and categorizing documents stored on Internet web-sites to enable identification and cross- referencing of references to dangerous chemicals within documents in any language.
- One aspect of the present invention provides for post-processing of identified documents to permit a document to be opened at a relevant page with the term of interest highlighted, and in the integration of found documents into a validation system supporting certification documents transmitted between supplier and recipient
- Another aspect of the present invention provides a validation that can be established from within the document itself in an analogous manner to the checks that occur in giving a credit card to a merchant in order to effect a purchase.
- a third-party service supports the security of the transaction between merchant and customer that reduces fraud and improves the efficient functioning of markets — based on the credit card itself.
- Another aspect of the present invention provides a review system and related validation technologies based on the certification document itself.
- One aspect of the present invention provides for a system of self-validating documents with independent validation support services.
- Another aspect of the present invention provides a self-validating certification documents passed between supplier and recipient based on standard phrases to be included in such documents together with validation hyperlinks that invoke a series of services, including: a) the retrieval of a cited document opened at a referenced page with a highlighted section associated with a material, material class, topic, use, or legal citation; b) the retrieval of summary reports of all requirements related to the standard certification phrase; c) the retrieval of all amendments, additions, and deletions of requirements related to the certification phrase; d) the retrieval of related property data records that may be automatically loaded into a document management or enterprise resource planning system; and e) the retrieval of transaction control alerts.
- One embodiment of the present invention provides for the generation indexing, extraction, and formation of documents containing validation links.
- Another aspect of the present invention provides a system of self-validating documents through which a downstream recipient of a certification document can assure himself of upstream certifications related to the submission of the immediate supplier in a confidential manner acceptable to an upstream supplier.
- Another aspect of the present invention provides self-validating certification documents passed to the validation service by the upstream supplier, including a standard phrase, a validation hyperlink to the source document, and an authorization procedure.
- a series of services are made available that relate to the upstream certification in the context of the immediate supplier's product or use, including: a) the retrieval of a cited upstream supplier document opened at a referenced page with a highlighted section associated with a material, material class, topic, use, or legal citation; b) the retrieval of summary reports of all requirements related to the standard certification phrase, including the supplier's confidential certification statements; c) the retrieval of all amendments, additions, and deletions of requirements related to the certification phrase, including the upstream supplier's confidential certifications; d) the retrieval of related property data records that may be automatically loaded into a document management or enterprise resource planning system, including upstream supplier data; and e) the retrieval of transaction control alerts, including transaction control alerts that relate to the upstream supplier's certifications.
- Another aspect of the present invention provides for the generation indexing, extraction, and formation of documents containing validation links.
- Yet another aspect of the present invention provides that the user to search for a standard synonym and return a highlighted reference to a literal reference on the page of a document, which provides the capability to link proper synonyms to literal names found within the text of a document that may not be "acceptable”, as well as the ability to link in synonyms based on confidential upstream supplier references;
- Another aspect of the present invention provides linking not only to sets of chemical substances but to any "material” that may not be chemicals in the proper sense at all that may be biological agents, products, or concepts ('sweeteners'), including but not limited to confidential upstream supplier materials.
- Another aspect of the present invention provides a system of self-validating documents including direct submissions between a supplier and a recipient as well as multiple party submissions through a chain of supplier-user relationships.
- An aspect of the invention provides for supporting the validation system in its method to search and index documents in order to extract references to materials, material classes, and legal citations.
- An aspect of the invention provides for supporting the validation system through access to upstream supplier certifications or certification documents through an authorization system.
- Fig. 1 is a block diagram of a system for validating certification documents according to one embodiment of the present invention.
- Fig. IA is a block diagram of a system for validating certification documents according to one embodiment of the present invention.
- Fig. 2 is a block diagram of an alternative embodiment of the system of the present invention.
- Fig. 3 is a chart illustrating an example of a hyperlinked standard phrase library of the system of one embodiment of the present invention.
- Fig. 4 is a diagram of a certification document including a dynamic control statement according to one embodiment of the present invention.
- FIG. 5 A is a block diagram of a data processing system according to one embodiment of the present invention.
- FIGs. 5B and 5C are flowcharts of a method for indexing documents in a data processing system according to one embodiment of the present invention.
- Fig. 6 is a diagram of a database produced by the method for indexing documents of one embodiment of the present invention.
- Fig. 7 is a diagram of a result of a search for a chemical term according to one embodiment of the present invention.
- Fig. 8 is a diagram illstrating an alphanumeric string in a document to be indexed utilizing the method of one embodiment of the present invention.
- Fig. 9 is a chart illustrating a materials database of one embodiment of the present invention.
- Fig. 1OA is a block diagram of an alternative embodiment of a data processing system described herein.
- FIGs. 1OB and 1OC are flowcharts of an alternative embodiment of a method for indexing documents in a data processing system described herein.
- Fig. 11 is a diagram illustrating a materials database of one embodiment of the present invention.
- Fig. 12 is a diagram illustrating results of a search for a materials term according to the prior art.
- Fig. 13 is a diagram illustrating the results of a search term in a non-English language, e.g., Chinese, where in this case the term is ⁇ JR1K_B? (melamine).
- Fig. 14 is a diagram illustrating the creation of a customized certification document from one of a personalized profile and search query according to one embodiment of the present invention.
- a certification document comprises: A purchase order, advanced shipment notice, shipping document, material safety data sheet, compliance certification statement, customer procurement standard, compliance statement, technical dossier, label, guideline, legislation, regulation, and standard as well as any document, submission, or compilation required for REACH (Registration, Evaluation, Authorization and Restriction of Chemicals under any related requirements).
- a certification document includes proposed and final publications and analysis of same.
- control statement As used in this invention, a control statement is a phrase intended to be included in a document to communicate the parameters of use of a material.
- authoring system As used in this invention, an authoring system is a software application employed for one of the preparation, generation, and distribution of a certification document.
- a dynamic control statement is a control statement that includes a function that can be executed by the recipient to retrieve one of a document, document reference, document link, compilation, summary, data, and function to perform the same.
- An example of a function that is included in a dynamic control statement is a hyperlink.
- An illustration of such a dynamic control statement might be "This product complies with EU Directive 2002/72/EC" found on the worldwide web at decernis.com/reference/document/2002_72_en.pdf.
- parameter of use is a restriction, limitation, approval, guideline, standard, practice, recommendation, characteristic, behavior, measure, and data for a material.
- a recipient is a human being and a computer system.
- validation information is a dynamic control statement, source document, compilation, summary, alert, recall, and reference supporting said dynamic control statement.
- a data processing system is a one or more programmable electronic devices that can store, retrieve, and process data.
- a logical function is a business rule, programmable computer routine that performs a calculation with variables and returns a result.
- a business rule expressed descriptively is "if the concentration of a component of a mixture is above .1% and that component is a listed carcinogen, then insert the control statement database key which is associated with the phrase 'Carcinogenic'.”
- An example of a logical function expressed descriptively is "if the web server receives a request from a dynamic control statement for a variable associated with the retrieval of a document from the server's document database, then a check should be performed of the user's authorization in the authorization database".
- a material means a chemical, formulation, biological product, food, any virus, therapeutic serum, toxin, antitoxin, analogous product, and finished article.
- materials include but are not limited to formaldehyde, orange, peanut, mycotoxin, aflatoxin, perfume, polymers, compounds, Irganox, a food or foodstuff, and serums.
- a finished article includes a toy, a packaged soup.
- a document means a computer file whether as a whole or deconstructed into component parts for electronic transmission and communication.
- alphanumeric string means a sequence of computer codes representing letters, numbers, and control characters, such as a line ending and punctuation mark.
- an algorithm is a computer procedure that begins in an initial state and terminates in a definite end state, applied here to process alphanumeric strings to prepare for, compare, determine the relevance of, and terminate indexing and searching related to a material term.
- an algorithm to prepare an individual alphanumeric string for matching with a material term is to strip all punctuation codes, raise all letters to capital, and to store the result in temporary memory.
- Another example of an algorithm is to compare any given alphanumeric string after processing with a database of material terms similarly processed and sorted in order of longest terms first.
- sequence is one or more alphanumeric strings extracted from a document in a defined order.
- the order of extraction includes but is not limited to the presentation of columns within a document and processing in order within a column.
- the order of extraction of alphanumeric strings should follow the natural order of the language, i.e., from left-to-right in English.
- dictionary database As used in this invention, a dictionary database is a collection or records stored systematically in an electronic medium so that it may be queried .
- common words means a dictionary of terms that are ignored as noise in indexing.
- matching is a procedure that terminates in accepting or rejecting an alphanumeric string extracted from a document to determine whether it is identical to a term describing a material stored in a database.
- An embodiment of the invention is a data processing system that improves the capability of a recipient of a certification document to validate dynamic control statements made in the document to define the parameters of use of a product by including within the document hyperlinks that retrieve the source document or reference supporting the given dynamic control statement from a web server (see Figure 1).
- This embodiment has the effect of communicating data about the parameters of use of a product to improve product safety and compliance.
- a certification document 152 is generated by an author from a client computer 100 via a document authoring application 101 that resides on a document authoring server 151 for a product sent to a recipient 153.
- Dynamic control statements for a product retrieve, e.g., by hyperlink, an authoritative source document 102 and are included in an electronic certification document 104 for electronic transmission to the recipient 153 via a network.
- a recipient may also receive the electronic document via computer readable medium, such as XML or other electronic document exchange or by posting or sending a link to a secure web server, discussed in more detail below, to the recipient 153.
- the recipient 153 validates a dynamic control statement, for example, by clicking on a hyperlink in the electronic certification document 104 that returns from a validation server 154 at least one of the following sources of validation information: (a) a source document 107 supporting the dynamic control statement ; (b) a list of change(s) 109 relevant to the dynamic control statement; (c) a compilation 108 of references related to the dynamic control statement, and (d) alerts 110.
- the validation server 154 is preferably a dynamic source of validation information, as the information is preferably updated at least at predetermined intervals.
- the request 1 13 is passed to the web-server 106, which may be in a number of different forms, including but not limited to HTTP, SOAP, remote object function calls, web services protocols, and the like.
- the web-server 106 passes the request to the application server 111 that returns a response to the request 114.
- a hyperlinked standard phrase library 102 includes for each dynamic control statement at least one of the following and preferably including a hyperlink, hyperlink fragment, or other variable that serves to invoke a function: a unique identification code, a phrase identification code, a language code, a text string, and a hyperlink or hyperlink fragment stored in a database.
- each dynamic control statement may have translated variants associated with dynamic components, e.g., hyperlinks, that will return from a server the source document supporting the statement.
- the hyperlink may be fully formed or a unique fragment associated with the unique phrase code which when appended to a base URL address where the server application has been loaded will return from a server the source document supporting the statement.
- a dynamic control statement with a hyperlink in the present invention can be included in a certification document, advantageously to providing the recipient 153 the capability to validate it.
- the hyperlinked standard phrase library 102 is preferably integrated into a document authoring application 101, for example an enterprise resource planning system, such as SAP R/3, SAP EH&S, product life cycle management system, or material safety data sheet generation system.
- the author of the document 100 to be prepared for a material stored in the Product Composition Database 103 selects unique dynamic control statements with the hyperlinks that represent parameters of use to be included in the certification document for a given product. For example, a food contact certification document for a particular grade of polyethylene is being manufactured and an author selects the phrase "Kunstoffverowski Mr. 476/2003" (with its associated dynamic component, e.g., hyperlink) to indicate the compliance of the manufactured product with an applicable food contact regulation in Austria.
- the author electronically places into a certification document the phrase with its hyperlink to the authoritative document so that the recipient can validate the dynamic control statement independently.
- the generated certification document 152 may be in any form that accepts a hyperlink or logical function to retrieve validation information for a dynamic control statement 104, including HTML, RTF, Microsoft Word, Excel, Adobe PDF, or in a structured data format such as XML but not limited thereto.
- the document received by the recipient 153 includes dynamic control statements with a hyperlink or logical function to retrieve the source document accessible from a validation server 154.
- the recipient of the certification document who wishes to examine the authority for a particular dynamic control statement may request 113 the source document from the hyperlink through the validation server.
- the web server 106 receives the request that is processed by the validation application 1 11 to retrieve the requested data from the database 1 12. The recipient is directed to the source document 114 through the web server 106.
- Figure 3 illustrates one example of an embodiment of the present invention for a Hyperlinked Standard Phrase Library of dynamic control statements with hyperlinks, providing a more detailed illustration of 102 in Figure 1.
- a unique identification code 300 groups dynamic control statements that have been translated into different languages so that the document authoring application 101 can produce a certification document 152 in Figure 1 in any of the languages available in the Hyperlinked Standard Phrase Library.
- the Phrase Code 301 identifies the specific dynamic control statement in the database.
- the Language Code 302 defines the language of the text phrase, i.e., the dynamic control statement, 303.
- the hyperlink or hyperlink fragment 304 references the source document or documents supporting the specific dynamic control statement in any available language.
- the address of the hyperlink can refer to any one of the following to produce the results 107, 108, 109, or 110 for a dynamic control statement: A specific document, compilation, or summary in the document database 112 of Figure 1, an index pointing to a document, compilation, or summary, or an argument of a function that will retrieve or generate a requested document, compilation, or summary.
- a data processing system using hyperlinked dynamic control statements in a certification document 252 is illustrated according to one embodiment of the present invention in which the certification document 252 is transmitted in computer readable form.
- the certification document 252 is produced in a computer readable form, including XML or other electronic document exchange formats, in such a manner that a dynamic control statement 204 can be received by the recipient's enterprise system 253 via the receiving computer 215.
- the dynamic control statement can then be extracted and stored in the recipient's database 216.
- the recipient can produce electronic reports from the database 216 in the enterprise system 205 that include dynamic control statements received in certification documents for a product.
- the recipient using the enterprise system 253 can validate such dynamic control statements by clicking on a hyperlink in any such generated recipient electronic report will produce a request 213 that will return (214) from the validation server 254 at least one of the following sources of validation information: (a) a source document 207 supporting the dynamic control statement; (b) changes 209 relevant to the dynamic control statement; (c) a compilation 208 of references related to the dynamic control statement, and (d) alerts 210.
- the validation server 154 is preferably a dynamic source of validation information, as the validation information is preferably updated at least at predetermined intervals.
- the recipient can implement a document authoring system as in Figure 1 and load the received dynamic control statements with hyperlinks or logical functions into the recipient's equivalent Hyperlinked Standard Phrase Library as in 102 of Figure 1, thus permitting the reuse of dynamic control statements in a plurality of document authoring systems for any dynamic control statement passed through the supply chain.
- the recipient's Hyperlinked Standard Phrase Library includes at least one of the following with hyperlinks: standard dynamic control statements, the recipient's own dynamic control statements, and received dynamic control statements.
- the recipient who has implemented a data processing system of the present invention can generate certification documents including dynamic control statements passed to the recipient.
- One embodiment of the present invention provides a certification document with such hyperlinked dynamic control statements can be passed to a recipient in a computer readable medium so that the recipient can then include a received hyperlinked dynamic control statement in authoring a further certification document.
- the embodiment provides a data processing system to improve the means of passing information in a supply chain to control the safe use and compliance of products in a standard manner and in a manner that permits the validation of a dynamic control statement included in a certification document being transmitted in a supply chain.
- the present invention provides an improved capability to prepare and distribute hyperlinked standard phrase libraries that are industry, subject-specific, or within a supply chain with hyperlinks and optionally translation variants so that a manufacturer may prepare a certification document in a flexible way with any selection of applicable hyperlinked dynamic control statements according to the conclusions of the expert author of the certification document and thus to permit the recipient to evaluate the stated parameters of use of the product by reviewing the source document supporting each dynamic control statement made.
- one embodiment of the present invention improves upon current practice by providing a method by which the author of a certification document may add locally authored dynamic control statements to the hyperlinked standard phrase library or to insert in a certification document hyperlinked dynamic control statements received from upstream suppliers of raw materials, which improves the capability for upstream suppliers to communicate parameters of safe and compliant use of materials through certification documents that includes a data processing system that can be implemented by both direct recipients of a certification document as well as downstream recipients of a dynamic control statement associated with the raw materials of a value-added produce to validate the source documents or references associated with any given dynamic control statement.
- documents generated with a hyperlinked dynamic control statement may be in any language.
- Such translated variants may be required where the use of the document is in a country with more than one national language, for example, Belgium, Canada, or Switzerland.
- a further embodiment of the invention improves upon the capability of the recipient of a certification document 152 to determine changes in associated source documents relevant to an included dynamic control statement 104 for a given period of time.
- the recipient of a certification document 152 can request 113 changes 109 relevant to a dynamic control statement 104 in a certification document 152 for a given period of time.
- the argument of the hyperlink of a dynamic control statement can include a date in order to request (113) changes (109 in Figures 1 and 3) relevant to the source documents supporting a given dynamic control statement 104.
- the argument of a hyperlink may include the date of the certification document's 152 generation in order that the recipient can be informed of amendments to a regulation cited by the dynamic control statement.
- the invention provides a data processing system that improves upon one of the most difficult tasks for a recipient of a document in the supply chain, which is to determine whether important amendments or modifications have come into force, or further studies or standards, relevant to a specific claim made in a dynamic control statement. At present, this task is disadvantageously performed manually by the recipient. For example, if the text of the dynamic control statement is, "This product complies with EU directive 2002/72/EC for plastic materials in contact with foodstuffs" then the hyperlink request 113 to the validation server 106, 109 can return 114 references to all successive amendments to this directive since the time of the certification document's 152 generation.
- the invention thus provides an improved capability to provide a data processing system for standardized change management alerts for dynamic control statement 104 claims made in certification documents 152 to support the safe use of a product.
- a further embodiment of the present invention is a data processing system to provide for product recalls and product alerts for specific shipments.
- an RFID identification number is associated with the certification document 152 or 252 or to one or more dynamic control statements 104 or 204 with hyperlinks or logical functions in order to return from the validation server 254 a product recall, alert, or other information applicable to a specific shipment.
- the present invention improves the capability for a data processing system to provide alerts regarding product recalls 110, 210 or other information as described above from a validation server 106, 206 not only in relation to the product in general but to a specific shipment of that product identified by RFID identification code, such information regarding a product recall or alert being automatically provided in response to a request 1 13, 213 either from a human being 153 or from a computer system 253, which provides for the advanced shipment notice or other commercial business-to-business interaction in electronic document exchange format or in XML format to include a reference to a document generated with the Hyperlinked Standard Phrase Library and to an RFID identification of a specific shipment.
- the described embodiments of the present invention improve the capability of the recipient to review MSDS and similar compliance certification documents, which otherwise must be carried out manually.
- the data processing system of the present invention further supports review of compliance and review of supplier certifications for foodstuffs, medical devices, pharmaceuticals, etc.
- the present invention is an improvement in that it is based on the document itself and not on an adjunct manual review process.
- An aspect of the present invention is to provide supply chain actors with a validation service bureau where such actors may generate may connect generate regular documents, regulatory compliance document preparation with the source document validation management that the invention provides.
- a certification document or safety document is self validating upon review by the recipient. Currently a recipient must contact the supplier directly to validate documents.
- the document opened by the hyperlink or logical function of the invention may open a document, may open a document at a cited page, or may open a document at a cited page with a relevant section of the page or document highlighted.
- the hyperlink or logical function contains an argument that includes the page(s) number of the cited document and the sections of those pages to highlight with the coordinates describing areas of the page to highlight.
- coordinates of the highlighted page may be specified by defining one or more rectangular areas of the page to highlight identified by the x,y positions of the axes of the rectangle that can be positioned on the space of a page. Other highlighted shapes or coordinate systems may be provided for within this invention.
- a further embodiment of present invention provides access to a data processing system which is controlled by the level of service agreed to in a service agreement.
- the hyperlink contains an additional argument which is an authorization code to control users authorized to view or download the source document referenced by the statement in the received document, which improves the general capability for upstream supply chain actors to provide documents containing statements referencing confidential information to intermediate and downstream actors in the supply chain.
- the downstream user can pass along the statement with the hyperlink or logical function to customers who may rely on this statement and be granted access based upon the privileges granted by the owner of the information hyperlinked with the statement, which improves the potential for a service bureau to manage authorization privileges for statements included in a Hyperlinked Standard Phrase Library.
- Fig. 4 shows a certification document for a Polyethylene product containing dynamic control statements that the product meets required approvals for its use in several countries.
- Each dynamic control statement contains a hyperlink of the type defined in the invention that permits the customer to receive a document that can perform one or more of the following:
- 400 illustrates a dynamic control statement for the United States (401) while 402 illustrates a dynamic control statement for Sweden.
- Dynamic control statement 400 hyperlinks to document 403 with a preferred embodiment in which the section is highlighted 405.
- 400 illustrates a claim and instruction by the supplier for the safe use of the product, i.e., a dynamic control statement, that the product complies with 21 CFR 177.1520(a)(3) (2003).
- the user may be interested in an immediate review of the relevant source regulation opened at the page with the relevant page with the section highlighted that relates to FDA regulation of "Olefin polymers" (as illustrated), a family of plastics that subsumes the specific product, Polyethylene.
- the supplier receives a Hyperlinked Standard Phrase Library ( Figure 1, 102) that contains identifiers, a phrase code, phrase texts in optionally different languages, and a validation hyperlink, as illustrated in Fig. 3.
- the dynamic control statement is:
- the validation hyperlink or logical function can alternatively contain, for example, systematic information that can be associated with certification phrases in the document.
- a database of hyperlinked dynamic control statements as a component of the data processing system of the present invention can be distributed to many different suppliers permitting consistency and validation by recipients in the communication of the parameters of use of a product, while allowing for significant customization to meet the needs of a supplier.
- the validation database can include dynamic control statements of an upstream supplier that include a hyperlink to the source document contained in a database available only to authorized users.
- the author of a document can assemble certification statements in a standardized as well as customizable manner that include both the immediate user's claims as well as upstream supplier claims although the upstream supplier claims would only be accessible to an authorized user.
- certifications can be passed from multiple parties upstream in the supply chain, simplifying greatly the assessment task of an downstream user.
- the supplier can use his or her document authoring environment to embed the appropriate phrase codes within a defined report template for a given product.
- the invention is providing a component that can be used in ERP or document authoring systems.
- the supplier distributes the certification document in at least two ways:
- the recipient may be an end-user (153), e.g., procurement expert for a customer reviewing compliance for global raw material acquisitions;
- the recipient may be another ERP system (253) automatically connected in a business-to-business network in which the transaction data and documents are passed from the supplier's ERP directly into the recipient's ERP system.
- the end-user can open the document in a number of different formats (Adobe PDF, Microsoft Word, HTML, etc.), and click on the validation hyperlink within the document itself (401).
- the user may invoke (or depending on the customization of the validation hyperlink) a number of different services from the validation hyperlink:
- the source document may be returned opened at the relevant page, optionally with a relevant section highlighted (107, 207); •
- the validation service may provide a report of all amendments or modifications to the cited document since the date of the document's generation relative to the timestamp of the validation phrase code (109, 209);
- the validation service may return a summary report of other regulations within the topical context of the document as defined in a profile (108, 208);
- the validation service may return alerts, news of proposals relevant to the certification, or other transaction control information (110, 210).
- the customer may wish to trans-ship the received polyethylene [as the example in this case] to another country not included in the list of certifications.
- the supplier may not have, in some cases, disclosed all information necessary for a conclusive answer by the customer, the customer may wish to make an independent evaluation based upon the information provided for a number of reasons.
- the customer's intended market or use may be perceived as confidential information that the customer may be unwilling to disclose to the supplier.
- An aspect of the invention provides for supporting the validation system is its method to search and index documents in order to extract references to materials and material classes.
- the invention provides methods for:
- a material in the database has a common identification even if it may be referenced by many other identifiers as used in regulations or documents.
- prior art has defined any number of different types of databases of substances, the present invention is unique in several respects:
- the database has a superset and unique concept of material that cuts across-and- relates individual occurrences to it;
- the database structure links together proper names, synonyms, translations, identifiers, and literal names (i.e., alphanumeric sequences used in documents that refer to a material but may be erroneous or have ancillary alphanumeric characters associated with them), allowing a reference in a document, which may be entirely erroneous or in a different language, to be related back to both a proper synonym as well as to a larger concept of material; and,
- a material class is a superset containing one or more materials.
- An example of a class defined in many environmental, safety, and health regulations is "Chrome VI" compounds, which defines a particular membership of chromium compounds and includes sodium chromate.
- sodium chromate is a "child" of the "parent” class, "Chrome VI compounds”.
- the document's definitional context - the use in question may not be a scientific relationship but an arbitrarily defined one.
- an automaker may define a set of materials that it has chosen not to purchase, as a matter of policy. Or, a document may refer to a particular list of salts, but not all salts of an acid.
- One embodiment of the present invention is a method and data processing system to cross-index references to chemicals and materials in documents not only by a direct reference to a material but also by one or more of the following: synonym, identifier, translation, or material class of which the chemical is a member.
- FIG. 12 An illustration from prior Art of the need for the embodiment of the present invention to provide a method and data processing system to cross-index references to chemicals and materials in documents is illustrated in Fig. 12, which provides the results from three searches from Google 1202, found on the worldwide web at scholar.google.com/.
- the first example 1203 is a search for the chemical, "crotonic acid” that returns two thousand five hundred and twenty document references (2,520) 1204.
- the second example is a search for a synonym of the chemical, "(E)-2-Butenoic acid” 1205 that returns twenty document references (22) 1206 that are not consistent with the references found in the first search.
- the third example is a search for a translation of the chemical, "Crotonzuur" 1207 that returns no search results from the Google index or search engine 1208. Similar results would occur for a chemical class of which crotonic acid is a member, such as "Ungesatt Anlagen aliphatician Mono- und Dicarbonsauren C3-C8" or "Acidos".
- the approach to indexing chemical terms by prior Art embodied by other suppliers provides similar inconsistencies: for example, the search above would provide similar inconsistent results but for a different document index library if the same three searches were performed on the publicly accessible demonstration of Illumina, found on the worldwide web at csa.com/.
- One embodiment of the present invention provides all matching available document references to the entered search term, synonyms of the search term, identifiers of the search term, translations of the search term or classes of which the chemical or material is a member can be returned from a search for a chemical or material term (see Figure 7).
- the synonyms may be in any language in order to return cross-indexed references (see Figure 13).
- FIG. 5 A, 5B, and 5C an embodiment of the present invention is illustrated, providing the steps to index chemical entries in a document that includes a reference to at least one material, so that the data processing system can permit a search for a given chemical in order to return from a web server not only a direct reference but also a compilation of references to documents containing the chemical term including: (a) documents containing a synonymous reference to the chemical term; (b) documents containing a translated reference to the chemical term; (c) documents containing a reference to an identifier associated with the chemical term; (d) documents containing a reference to a parent class of which the chemical term is a member.
- the document is input, preferably in electronic format, such as HTML, Adobe PDF, Microsoft Excel, Microsoft Word, or in computer readable form such as XML or other document exchange format and preferably input into a document database 530.
- the software of the present invention extracts all of the words or alphanumeric strings in the document in a step 503 and tests that it is a word and not simply a sequence of control codes or other information.
- a found word is compared to a dictionary of common words in order to suppress words that are not chemical terms, which has the effect of decreasing the size of the database and the speed of the indexing.
- a record in the index database is stored.
- the word is stored, including the address of the document whether a filename or hyperlink, the page on which the word is found, and the position of the word on the page.
- One method for defining the position of the term on the page is to define a rectangular area that encompasses the area of the word on the page, and to store the coordinates of the rectangle in the index record.
- a step 504 the relevance of the extracted words or alphanumeric strings in the document as stored in the index is determined by comparing, in sequence and in combination, the extracted words or alphanumeric strings to a dictionary database of material terms.
- the material terms dictionary database contains at least one of the following: a unique material identification code, a preferred name of the instance of the material, and a name used for matching against a document term (Matchname).
- An extracted word or alphanumeric string is compared to an index of Matchnames from the database of material terms, such as by retrieving the extracted word or alphanumeric string from a document index, discussed in more detail below.
- an index record is prepared for at least one of the following: (a) found chemical, (b) document, (c) document address, (d) material code, after which the record is stored in the materials index in a step 506.
- a particular chemical name is indexed against any entry in a plurality of documents in the document database.
- the sub-step 504 is shown in greater detail.
- the first alphanumeric string is extracted in a step 535.
- the alphanumeric string is prepared for matching, such as by converting lower case characters to upper case, stripping punctuation, converting Greek letters to alphanumeric equivalents or the like.
- the alphanumeric string is compared with a dictionary database of material terms.
- a match occurs, the method proceeds to the step 539 and the matched term is added to a stored set of matching material terms, after which the combined matching terms are combined in a step 541 and the method proceeds to the step 544 to test if there are more strings in the document. If there are no more strings, the sub-step 504 ends and the method 501 proceeds to the step 505. If there are more strings, the method returns to the step 535 to begin a new determination of relevance.
- the method tests, in a step 540 if the stored material terms exist. If the stored material term does exist, the method proceeds to a step 542 where a stored matching material term is retrieved, which is accepted as a material reference and the method writes an index record in a step 543 after which the method proceeds to the step 544 to test if there are more strings in the document. If there are no more strings, the sub-step 504 ends and the method 501 proceeds to the step 505. If there are more strings, the method returns to the step 535 to begin a new determination of relevance. If no stored material terms exist in the step 540, the method proceeds to the step 544 to test if there are more strings in the document. If there are no more strings, the sub- step 504 ends and the method 501 proceeds to the step 505. If there are more strings, the method returns to the step 535 to begin a new determination of relevance.
- the materials database or dictionary database of common material terms is illustrated at 515 as including one or more of the following: (a) A unique material identification code or key 516; (b) a proper chemical name 517; (c) synonyms 518; (d) identifiers, e.g., an EU Reference Number, an EINECS number, etc. 519; (e) translations of chemical names 520; (f) members of parent classes, e.g., sodium chromate is a member of the class hexavalent chromium compounds; and other material attributes.
- the embodiment of the indexing method in Fig. 5A and the present invention applies to any biological terms as they do to chemical terms, all encompassed within the definition of material as used in this invention: (a) A unique material identification code or key is assigned to an entry; (b) a proper name is assigned, e.g., Citrus sinensis; (c) synonyms are assigned, e.g. sweet orange; (d) identifiers that might be used, in this example none; (e) translations of the term e.g., Appelsien, sweet orange, Apelsiini, Arancia, and7l " U Vv; (f) members of parent classes, e.g., this example is a child of the parent class, citrus.
- the embodiment of the indexing method can, for example, reference documents establishing thresholds for pesticide residues and additionally cross-reference them to a particular cited item, such as sweet orange, a synonym in any language, or to a family of related items, such as citrus fruits, permitting the user to open the referenced document at the page at which the item is cited via a defined set of cross-indexed terms.
- a particular cited item such as sweet orange, a synonym in any language
- a family of related items such as citrus fruits
- a master materials database is shown at 523 and defines the relationship with a master "material” that encompasses one or more entries in the materials database 515.
- a master material record has one or more of the following elements: (a) a unique master materials code or key 524; (b) a proper master name 525; (c) master identifiers associated with the master material 526; (d) attributes associated with the master material 527; (e) an identification that this is a parent class.
- a cross-index is generated by retrieving a matched alphanumeric string from the step 505, matching the retrieved alphanumeric string with a matching master materials database key 524 and cross-indexing the matching records in the document database 530, the materials database 515, and the master materials database 523.
- the resulting cross- index permits a particular occurrence of a chemical term to be related not only to all indexed documents in the document database 530 containing the term, but to any synonym, translation, identifier or membership in a broad chemical class in the materials database 515 or the master materials database 523.
- FIG. 6 An example master material key (516 in Fig. 5A) is illustrated at 601. If there is an associated reference to a master material key (524 in Fig. 5A) that is a parent class the key entry is represented in 602. For example 608, in this instance the preferred name for the material entry is (E)-2-butanoic acid 603, indicating here as the "head name” with a material identifier code 304 (601). One instance of a material linked to this index entry is the name, "crotonic acid” 604. This entry is found in the file, 21cfrl76.180.pdf (607). An attribute of this entry is a citation, "21 CFR 176.180 Paper/paperboard (dry food)".
- the material is a member of a chemical class "Ungesatt Weg aliphatician Mono- und Dicarbonsauren C3-C8", and this class is referenced in a document with the citation "BfR Empf. 35 [XXXV.] Mischpolymerisate: Ethylen, Propylen, Butylen, Vinylestern, ungesattigten aliphat.” with the filename, de_350deutsch.pdf. (E)-2-butanoic acid is a member of the referenced class of chemicals.
- FIG. 8 is an illustration of an example of a fragment from a document, 21 CFR ⁇ 178.2010, with a sequence of words at 810, beginning "3.1 Mineral oil (CAS Reg. No. 8012-95-1): Not to exceed 40 percent by weight of the stabilizer formulation".
- the chemical term of interest in this fragment is "Mineral oil", which is embedded in a sequence of other alphanumeric characters and other non- alphanumeric punctuation, bit streams, and control codes.
- the first term of this sequence is extracted as indicated in steps 503 and 506. This alphanumeric sequence,"3.1", does not match any term in the materials database and is discarded.
- One difficulty with existing indexing methods that is addressed by the present invention is that a chemical term may span many separated words 901 as illustrated in Fig. 9. Extracting only the first word length term in sequence, i.e., "Mineral" would not correctly represent the term in this example extract.
- One advantageous aspect of this embodiment of the present invention is that the comparative indexing method in the step of determining relevance 506 heuristically evaluates a series of possibilities as it processes the document by considering a plurality of terms in sequence. In one embodiment of this method, the terms in the material database 515 are taken in order of the longest alphanumeric sequence first.
- the indexing utility extracts the word, "Mineral” in the step 503 and stores this term temporarily until the indexing method 501 can conclude that the best match has been found for the series, rejecting or accepting terms as the processing continues.
- “Mineral” might possibly be followed by "reinforced nylon resins”, “Mineral oils and hydrocarbons”, “Mineral oil based greases”, or the like as shown at 901 although it does not in the document example 801.
- the indexing method 501 has found a chemical term with a plurality of matches, and then seeks to narrow the possible matches by taking the second term, "oil” 801 following the term, "Mineral”.
- Mineral oil in combination eliminates all other available terms in this example, and the method determines that "Mineral oil” with the internal identification material identification key (516 from Fig. 5A) of "1476" (902 in Fig. 9) matches this series of words in the document in the step 509. This match is then stored in the step 510.
- the indexing method 501 then moves in sequence or sequentially to consider the following term, "(CAS" and the subsequent term"No". 803 that are discarded without matches.
- a database of common (i.e. non- material) words may be additionally used to make the comparison more efficient by eliminating any common word, such as "the", “No.”, “not", "to”, “exceed”. A common word in such a list would be ignored by the indexing method 501.
- the database of common words is used in the heuristic comparison step 508, the words of the phrase “Not to exceed” would be discarded as “common words” or "noise” without comparison to the material database.
- the CAS Registry Number, "8012-95-1" 803 is an example of an identifier for the substance, "mineral oil” that can be itself extracted from the document by the indexing method 501 of the present invention and used in association with other material identification keys that are themselves linked to other document references.
- the words are pre-processed to strip punctuation and capitalize terms so that the comparison step can consider a number of equivalent chemical terms more easily.
- the indexing method would treat the punctuation as noise.
- the embodiment would ignore case sensitivity, such as initial capitalization in a document reference.
- the indexing method 501 found the term, "Mineral oil" in the text of the document and its associated reference to the material identification key "1476" 902. Once this identification has occurred, the material identification key 516 or 531 and thus the document reference may be related to all other references associated with the master material key 524.
- the master material key 524 may include direct references, synonyms, translations, or chemical or material classes. As an example of a material class, the material, "mineral oil” with its material identification key can be considered a member of the class, "cottonseed and other edible oils”. Thus the master material identification key
- the indexing method 501 of this embodiment of the present invention can be used to support a search for "mineral oil” that will return a reference to any available document that uses the term “cottonseed and other edible oils".
- the benefit of this cross-indexing is that the user would be able to rapidly determine that "mineral oil” is permitted as a surface lubricant by FDA in the production of resinous and polymeric coatings used in food contact uses under 21 CFR ⁇ 175.300.
- the method 501 for indexing and searching chemical terms has significant, beneficial application that assist in improving the safe and globally compliant use of product, for instance.
- the method 501 of the present invention permits a cross-referencing of documents by: (a) preferred chemical name, (b) identifier; (c) translation; (d) synonym; and (e) membership in a parent class.
- FIG. 7 a data processing system is illustrated as a preferred embodiment of the present invention that returns in response to a search based on the index described above for a particular material name, "crotonic acid”, with found references to documents that include a reference to a synonym 703, one or more references to parent classes 701, 702, or a translated name 703.
- the hyperlink to the document opens at the page of the document on which the particular reference is found.
- the preferred embodiment permits the user to enter a search term and to create a personalized profile of search terms in order to return a search result that is itself a compliance document.
- the personalized profile may include a plurality of materials, a plurality of topics, a plurality of jurisdictions or any combination of the above.
- the customized result from the user's search profile may be in any language whether the same or different from the input.
- indexing method can be applied to a subset, such as those documents that have changed over a particular period of time.
- Fig. 10 an embodiment of the present invention is illustrated in which the body of documents selected for search are "new" or "changed".
- the subset of documents subject to indexing and search may be assembled by either manual or automatic means.
- manual research may have identified amendments to a certain topical area of regulations over a period of time, or a subsequent studies that have been published, or other subsequent publications during the given period.
- Automatic means may select a document subset as well.
- the present embodiment supports a search for a chemical that is affected by a change, whether the document that has changed refers directly to the chemical term, uses an identifier, a translation, or refers to a chemical class encompassing the term.
- a search for the term "biotin” 1101 returns a reference to a repealed European Union Directive 96/5/EC 1102, where a reference to this material was deleted by the action of a subsequently enacted directive.
- This document is a member of a subset of documents added or changed during a given period of time.
- the period of time is "the current update”, and the color red and the citation struck through indicates that the document was repealed as one visual method of presentation in the present embodiment.
- the benefit of the present embodiment are that a researcher can more effectively keep abreast of changes that affect his or her use of materials that are referenced in newly published regulations or documents through the present data processing system. At present, the researcher must perform this task manually or through partially automated searches.
- FIG. 1OA, 1OB, and 1OC an embodiment of the present invention is illustrated providing the steps to index chemical entries in a new, subset, or changed document that includes a reference to at least one material, so that the data processing system can permit a search for a given chemical in order to return from a web server not only a direct reference but also a compilation of references to documents containing the chemical term including: (a) documents containing a synonymous reference to the chemical term; (b) documents containing a translated reference to the chemical term; (c) documents containing a reference to an identifier associated with the chemical term; (d) documents containing a reference to a parent class of which the chemical term is a member.
- the document is input, preferably in electronic format, such as HTML, Adobe PDF, Microsoft Excel, Microsoft Word, or in computer readable form such as XML or other document exchange format and preferably input into a document database 1030.
- the software of the present invention extracts all of the words or alphanumeric strings in the document in a step 1003 and tests that it is a word and not simply a sequence of control codes or other information.
- a found word is compared to a dictionary of common words in order to suppress words that are not chemical terms, which has the effect of decreasing the size of the database and the speed of the indexing.
- a record in the index database is stored.
- the word is stored, including the address of the document whether a filename or hyperlink, the page on which the word is found, and the position of the word on the page.
- One method for defining the position of the term on the page is to define a rectangular area that encompasses the area of the word on the page, and to store the coordinates of the rectangle in the index record.
- a step 1004 the relevance of the extracted words or alphanumeric strings in the document as stored in the index is determined by comparing, in sequence and in combination, the extracted words or alphanumeric strings to a dictionary database of material terms.
- the material terms dictionary database contains at least one of the following: a unique material identification code, a preferred name of the instance of the material, and a name used for matching against a document term (Matchname).
- An extracted word or alphanumeric string is compared to an index of Matchnames from the database of material terms, such as by retrieving the extracted word or alphanumeric string from a document index, discussed in more detail below.
- an index record is prepared for at least one of the following: (a) found chemical, (b) document, (c) document address, (d) material code (in this case for the subset of documents), after which the record is stored in the materials index in a step 1006.
- material code in this case for the subset of documents
- the sub-step 1004 is shown in greater detail .
- the first alphanumeric string from the document subset is extracted in a step 1035.
- the alphanumeric string is prepared for matching, such as by converting lower case characters to upper, stripping punctuation, converting Greek letters to alphanumeric equivalents or the like.
- the alphanumeric string is compared with a dictionary database of material terms.
- a match occurs, the method proceeds to the step 1039 and the matched term is added to a stored set of matching material terms, after which the combined matching terms are combined in a step 1041 and the method proceeds to the step 1044 to test if there are more strings in the document. If there are no more strings, the sub-step 1004 ends and the method 1001 proceeds to the step 1005. If there are more strings, the method returns to the step 1035 to begin a new determination of relevance.
- the method tests, in a step 1040, if the stored material terms exist. If the stored material term does exist, the method proceeds to a step 1042 where a stored matching material term is retrieved, which is accepted as a material reference and the method writes an index record in a step 1043 after which the method proceeds to the step 1044 to test if there are more strings in the document. If there are no more strings, the sub-step 1004 ends and the method 1001 proceeds to the step 1005. If there are more strings, the method returns to the step 1035 to begin a new determination of relevance. If no stored material terms exist in the step 1040, the method proceeds to the step 1044 to test if there are more strings in the document.
- the materials database or dictionary database of common material terms is illustrated at 1015 as including one or more of the following: (a) A unique material identification code or key 1016; (b) a proper chemical name 1017; (c) synonyms 1018; (d) identifiers, e.g., an EU Reference Number, an EINECS number, etc. 1019; (e) translations of chemical names 1020; (f) members of parent classes, e.g., sodium chromate is a member of the class hexavalent chromium compounds; and other material attributes.
- the change document database is illustrated at 1030 as including one or more of the following: (a) A unique material identification code or key 1031, which is related to 1016; (b) a document address or filename using the Matchname of the material; (c) a page number for the occurrence of the Matchname 1033; and (d) the location on the page of the term 1034.
- a master materials database is shown at 1023 and defines the relationship with a master "material” that encompasses one or more entries in the materials database 1015.
- a master material record has one or more of the following elements: (a) a unique master materials code or key 1024; (b) a proper master name 1025; (c) master identifiers associated with the master material 1026; (d) attributes associated with the master material 1027; (e) an identification that this is a parent class.
- a cross-index is generated by retrieving a matched alphanumeric string from the step 1005, matching the retrieved alphanumeric string with a matching master materials database key 1024 and cross-indexing the matching records in the document database 1030, the materials database 1015, and the master materials database 1023.
- the resulting cross- index permits a particular occurrence of a chemical term to be related not only to all indexed documents in the document database 1030 containing the term, but to any synonym, translation, identifier or membership in a broad chemical class in the materials database 1015 or the master materials database 1023.
- a personalized profile and search query 1401 returns a customized certification document 1407 to the user of a compilation service including certification documents.
- a compilation service would include but would not be limited to, for example, an aggregator of certification documents, a service offered to the user to generate a customized certification document, and a database service supporting the generation of customized certification documents.
- the query 1401 is searched against one of an index of certification documents and extracted data from such 1402. Based on the received query as described above, the sections of the customized certification document are determined 1403. Content is fetched from the index 1404, as described above, associated with the personalized query 1401.
- the base customized certification document is created 1405.
- each section of the customized certification document is populated 1406 with appropriate unique content from the search of the index as described above that is associated with each one of fetched certification document and extracted data.
- the generated customized search document is returned to the user 1407.
- An embodiment of the present invention as illustrated in Fig. 14 includes a search query that may be a material and an index that includes cross-references of materials selected from a proper name, an identifier, a translation, a synonym, a member of a parent class, and any combination thereof.
- a further embodiment of the present invention as illustrated in Fig. 14 includes a further selection within the one of a personalized profile and search query of a regulation, a physico-chemical property, toxicological property, end use, a material, topic, or any combination thereof.
- the user of a compilation service may define a personalized search profile that may include but is not limited to a topic, such as food additives, a subtopic, such as contaminants, a period of time, such as the last month, a set of jurisdictions, such as China and the U.S., and a request for the generation of a certification document type, such as an analysis of proposed regulations.
- a personalized search profile may include but is not limited to a topic, such as food additives, a subtopic, such as contaminants, a period of time, such as the last month, a set of jurisdictions, such as China and the U.S., and a request for the generation of a certification document type, such as an analysis of proposed regulations.
- the customized certification document is returned with sections that correspond to the criteria received by the user.
- the sections are populated with content that may include but is not limited to, for example, data, an analysis and a reference to a certification document, such as one of a Chinese proposed regulation, a translation, and a function that can be executed by the recipient to retrieve one of a document, document reference, document link, compilation, summary, data, and function to perform the same.
- a personalized search profile may include a material, such as a product formulation, and other elements of the example above in order to return an analysis of any proposed regulations affecting the entered product formulation or substance within it.
- Another example of an embodiment of the present invention includes but is not limited to a personalized search profile that may include a material, such as a product formulation, and other elements of the example above in order to return an analysis of any proposed regulations affecting the entered one of a product formulation and substance within it that may be in any language and relate to the product by cross-reference that may be at least one of a synonym, an identifier, a translation, a member of a parent class.
- a personalized search profile may include a material, such as a product formulation, and other elements of the example above in order to return an analysis of any proposed regulations affecting the entered one of a product formulation and substance within it that may be in any language and relate to the product by cross-reference that may be at least one of a synonym, an identifier, a translation, a member of a parent class.
- Another example of an embodiment of the present invention includes but is not limited to a personalized search profile that may include at least one of a food, such as an orange, a class of foods, such as citrus fruits, and other elements of a search query that may, for example, include jurisdictions, such as the European Union and the U.S., and a certification document type, such as an analysis, in order to return a customized certification document with sections defining restrictions of contaminants for the food by jurisdiction, regardless of the language of the certification documents retrieved during the search.
- a personalized search profile may include at least one of a food, such as an orange, a class of foods, such as citrus fruits, and other elements of a search query that may, for example, include jurisdictions, such as the European Union and the U.S., and a certification document type, such as an analysis, in order to return a customized certification document with sections defining restrictions of contaminants for the food by jurisdiction, regardless of the language of the certification documents retrieved during the search.
- a further example of an embodiment of the present invention includes but is not limited to the creation of a customized certification document where the type of certification document created is, for instance, a compliance statement and the topic is, for example, food contact, and the language for the customized certification document to be generated in is, for instance, English and a product formulation is given as part of the query.
- a customized certification document may equally include an end use, such as use in beverages.
- an example of a customized certification document may be generated based on given criteria that include a country, a regulation, a physico-chemical property, a toxicological property, an end use, a material, a topic or any combination of the above.
- Embodiments of the present invention may also be practiced by a computer readable medium storing executable software code thereon for executing the indexing method and the system for validating certification documents in accordance with the present invention, as will be appreciated by those skilled in the art.
- Embodiments of the present invention may also be practiced by a device, such as a personal computer or the like, having a processor, wherein the processor is responsive to software instructions; and software instructions adapted to enable the processor to execute the indexing method and the system for validating certification documents in accordance with the present invention, as will be appreciated by those skilled in the art.
- Embodiments of the present invention produce an advantageous technical effect by providing a data processing system that more effectively communicates parameters of use of products in a supply chain by utilizing dynamic control statements in certification documents that may be validated by a recipient of the certification document, thereby improving the safe and compliant use of the products in the supply chain by the recipient.
- the present invention thereby provides a further technical effect which lends technical character to the embodied computer programs in the control of an industrial process and in processing data that represents parameters of use of physical entities through the dynamic control statements.
- the present invention provides a solution to a difficult supply chain management problem by the automatic validation of certification documents.
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Tourism & Hospitality (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Data Mining & Analysis (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Machine Translation (AREA)
- Document Processing Apparatus (AREA)
- Stored Programmes (AREA)
Abstract
The present invention relates generally to the field of self- validating documents in supply chain management, documentation services and method for creating the same.
Description
DOCUMENT VALIDATION SYSTEM AND METHOD
CROSS REFERENCE TO RELATED APPLICATIONS
[0001 ] This application is a continuation- in-part application of U.S. Patent
Application Serial No. 11/614,81 1, entitled "Document Validation System and Method", to Andrew B. Waldo, et al., filed on December 21, 2006, which claims priority of U.S. Provisional Patent Application Serial No. 60/752,980, entitled "Document Validation System and Method", to Andrew B. Waldo, et al., filed on December 21, 2005, and of U.S. Provisional Patent Application Serial No. 60/755,897, entitled "Document Validation System and Method", to Andrew B. Waldo, et al., filed on December 30, 2005, and the specification and claims thereof are incorporated herein by reference. [0002] This application also claims priority to Patent Cooperation Treaty
Application Serial No. PCT/US06/62516, entitled "Document Validation System and Method", filed on December 21, 2006, and the specification and claims thereof are also incorporated herein by reference.
BACKGROUND OF THE INVENTION
[0003] The present invention relates generally to the field of self- validating documents in supply chain management, documentation services, method and data processing system for creating the same.
[0004] Millions of documents are passed in global commerce between supplier and recipient containing control statements within certification documents, such as for the safe use and handling of a product or its compliance with applicable restrictions. Studies have shown a high rate of error in such documents.
[0005] Global trade in products between a supplier and a customer depends upon the control statements made in certification documents, such as Material Safety Data Sheets and Safety Data Sheets (MSDS or SDS), letters of certification or compliance certifications, because such control statements define the parameters of use of the product. For example, an MSDS for a hazardous substance or formulation, has become the common means by which the supplier communicates to the customer the controls necessary for safe
handling of the product as well as its compliance with applicable restrictions whether in the U.S. at the federal or state level, or the requirements of another country or international convention.
[0006] With regard to other types of products, a letter of certification or compliance certification document from the supplier of food and consumer products contains control statements that communicate requirements applicable to the use of the product. For instance, a certification document might accompany the supplier's shipment of a food packaging material to stipulate that the product could be used only with certain types of foodstuffs under the requirements of the Food and Drug Administration or similar governmental agencies of other countries. Such certifications may relate to regulations, standards, religious codes (e.g., keeping Kosher), scientific studies and the like. Millions of such documents are generated and transmitted every year in many different languages and countries for many different types of products and uses.
[0007] In many cases such documents are a compilation of standard control statements defining various parameters of use of the product. It is common for such documents to be prepared and generated using a document authoring system or enterprise resource planning (ERP) system such as SAP from a phrase library that may have different language variants.
[0008] However, although the recipient of a generated certification document has the control statements for the product, he is not able to obtain or validate the source document supporting a control statement in an automatic way. Nor can the recipient automatically determine whether a change relevant to a control statement in the received certification document might have occurred from the time of the document's creation.
[0009] Moreover, the recipient may wish to use the product in a different market or area of the world, and is unable to relate the control statements relevant in one jurisdiction to parameters of use in other jurisdictions or areas. Independently of the supplier's certifications the recipient may also simply wish to review the control statements in a certification document to determine whether information is missing or for which he requires additional information by reviewing the source document of such a statement. Finally, the recipient may wish to relate the general information conveyed about the product in the received document to information about a specific shipment of that product received from the supplier where the shipment has, for example, a particular RFID code.
This last aspect is especially important where a product recall or alert has occurred for specific shipments of a product.
[0010] It is desirable, therefore, to provide a data processing system to support the automatic validation of control statements made about products flowing through the supply chain. Normally, validation of a control statement is done as a manual task by the recipient. Providing a data processing system for such information will improve the safety of products in the supply chain, will improve the transparency of global product requirements, will reduce cost of product approval, and will reduce mistakes.
[0011] It is also desirable for the customer to validate the control statements of the supplier whenever possible through an automatic data processing system. Although the customer must legally rely on the statements of the supplier, a prudent customer may wish to independently validate such a certification by looking up the reference to determine that it is current or to assure himself or herself that important omissions have not been made.
[0012] The communication of control statements is not simply a one-to-one relationship between a supplier and a customer, but rather between a many-to-one relationship of multiple upstream suppliers in a supply chain with the customer. The customer may receive a certification document with control statements that depend upon the specific claims of an upstream manufacturer of raw materials used by the immediate supplier of the customer; however, the upstream manufacturer may be unwilling to disclose important source information to the immediate supplier without a non-disclosure agreement, because of claims of confidentiality or trade secrecy.
[0013] For example, a manufacturer of a plastic sells to a small converter that produces formed cups to a yogurt food processor. The small converter may provide certifications, but these depend on the materials used in the conversion process. Often it is not the certification statement itself that is confidential; rather it is the source document supporting the statement that is confidential (e.g., test results or toxicological study). Thus, the yogurt food processor has a critical need to be assured of claims or compliance certifications that include both the immediate supplier and the upstream raw material suppliers. The need of the customer is to validate control statements of the immediate supplier as well as -to the extent permitted by the upstream supplier and under terms agreed to by the customer - the control statements passed through the supply chain from upstream manufacturers that
concern raw materials or other conditions important to the immediate customer's use of the received product. 14] Many such certification documents transmitted by suppliers to customers — important though they are — contain omissions or errors. Indeed, according to a recent study of the completeness of safety data sheets: "The deficiencies for the different headings [that is, of the 16 sections of a standard format MSDS] vary between twenty percent and forty percent". ECLIPS:. "European Classification and Labeling Inspections of Preparations, including for Safety Data Sheets", Final Report 2004 published by the European Enforcement Network, page 11. In consequence, the control statements made in the safety data sheets reviewed in the study have deficiencies that may include missing control statements, out-of-date control statements, or other errors. Further, according to the report, the error rates of regulatory statements in section fifteen of the MSDS, where required regulatory certification statements are made, averaged 35% . Ibid. Similar findings have resulted from Canadian studies. Welsh M. S.; Lamesse M.; Karpinski E. "The Verification of Hazardous Ingredients Disclosures in Selected Material Safety Data Sheets." Applied Occupational and Environmental Hygiene, Volume 15, Number 5, 1 May 2000, pp. 409-420(12). OSHA has performed studies of MSDS quality:
Based on the chemical ingredients identified, the accuracy in the other four areas of concern was evaluated based on information obtained from readily available reference sources. The evaluation indicated that 37% of the MSDSs examined accurately identified health effects data, 76% provided complete and correct first aid procedures, 47% accurately identified proper personal protective equipment, and 47% correctly noted all relevant occupational exposure limits. Only 11% of the MSDSs were accurate in all four information areas, but more (51%) were judged accurate, or considered to include both accurate and partially accurate information, than were judged inaccurate (10%).(Found at the world wide web address osha.gov/dsg/hazcom/finalmsdsreport.html).
[0015] Given the importance of such certification documents and the control statements that they contain to the safety of the recipient, means to improve accuracy, as addressed in the present invention should be established. A number of studies agree: Error rates in supplier certification statements are high.
[0016] In the area of food safety, FDA has established processes for review of hazards: Hazard Analysis and Critical Control Point (HACCP). Nevertheless frequent reports appear where a food processor has purchased a material that contains a contaminant not reviewed adequately, especially with regard to imports and exports of foods and foodstuffs.
China's safety and quality watchdog said 8 percent of domestic dried fruits and vegetables failed safety tests, mainly because of excess sulfur dioxide residue, after rejecting some U.S. raisin imports for the same reason.
The General Administration of Quality Supervision, Inspection and Quarantine also found that 13 percent of chili products did not meet safety standards.
The agency Friday announced that imports of a brand of U.S. raisins had been rejected for high sulfur dioxide levels, along with three kinds of U.S. health supplements with excess bacteria and mold. It also called on local officials to boost monitoring of U.S. food exports amid tensions over food safety.
All the below-standard products found in the sampling came from small producers.
China has seven million small-food processors, 30 percent of which do not comply with hygiene standards, according to Wang Lei, a researcher at the Shenzhen Institute of Standards and Technology.
"8 pc of dried vegetables fail tests". The Standard. June 12, 2007
(Found at the worldwide web address thestandard.com.hk/ news_detail.asp?we_cat+3&art_id=46542&sid= 14013053 &con_type= l&d_str=20070612)
[0017] The probability of error between supplier and customer increases with the volume of certification documents and the number of suppliers. In chemical-using industries, the number of raw materials for a single manufacturer can be thousands or tens of thousands and the number of suppliers in the hundreds or thousands. The same holds true in the food- processing and food-related industries. As a result there is an essential need to improve methods of validation of supplier's statements and to monitor important changes that may have occurred that relate to the supplier's statements.
[0018] It is true that the supplier may have proprietary evidence to support a certification and may not have revealed the full composition of a formulation under restrictions on the disclosure of confidential business information, in which case an independent evaluation is limited. Nevertheless, the customer can perform many checks based on the information presented by the supplier, and may as a standard practice adopt a review and validation of a supplier's certification statements.
[0019] Further, apart from any regulatory requirements, a number of industries have established their own internal standards that must be met in any procurement of raw materials by the company. For example, Volvo has established: VOLVO Corporate Standard STD 1009,11 (Established 2/1998) CHEMICAL SUBSTANCES WHOSE USE WITHIN THE VOLVO GROUP SHALL BE LIMITED (VOLVO'S GREY LIST) .
[0020] Such ad hoc customer procurement standards that are in addition to any mandatory governmental requirement and accepted only in the face of market pressure have become widely accepted in part because of the difficulties and high error rates in certification documents being passed in the supply chain between supplier and customer. In addition, these standards are subject to change without notice. Such ad hoc standards increase the cost of compliance and its complexity, and reflect the need for an improved method of producing, distributing, and validating certification documents in the supply chain.
[0021] A customer has several validation needs:
• Accuracy and Currency. Has the supplier correctly cited a supporting reference related to the safe handling of a product and is it current?
• Access to Source Documents. Can the customer obtain the cited reference?
• Access to Cited References. How can the customer obtain a cited sub-reference within the cited document?
• Completeness. Are there other related restrictions or references that have been omitted or overlooked?
• Global Scope. Are there similar restrictions in other countries or languages?
• Customer's Use vs. Supplier's Scope. Are there other restrictions that apply to the customer's use in another market, but which the supplier has not directly addressed in the certification that are nonetheless critical to the customer (e.g., the customer purchases a product in the U.S., and receives a U.S. certification document but intends to use it as a component or trans-ship it to another country)?
• Change Management Regarding Supplier Statements. After a period of time subsequent to the first receipt of the certification how can the customer be informed if an important amendment or modification has occurred related to a certification for the product that the customer has purchased? Again, although many regulations require the automated updating of MSDS or other certifications in the event of a "significant" regulatory change, many recipients seek to independently review supplier information.
• Change Management with Regard to Customer's Uses. After a period of time subsequent to the first receipt of the certification how can the customer be informed of other related changes of interest but not provided by the supplier that may affect the customer's use of the product, for example, in a country to which transshipment occurs?
• Upstream Supplier Certifications. Access to upstream supplier certifications relating to the immediate supplier's product or changes in these certifications under authorized terms and conditions acceptable to the upstream supplier. 22] Today, suppliers and customers seek to establish checks within their business processes and to establish review systems within their organizations, but it is prone to error and oversight especially in light of the complexity of global markets. The reason is straightforward: These review systems are separated from the certification document
itself. The present invention provides a data processing system to support automatic validation and addresses this need.
[0023] There are many ways in which suppliers generate such certification documents either manually or by automated means within a system. For example, enterprise resource planning systems (ERP's) such as that of SAP (e.g., SAP EH&S) assist suppliers in automatically generating MSDS.
[0024] The components of such systems often include:
• A composition database containing products and detailed composition and raw materials
• Properties tables or databases containing associated values, classifications, and restrictions applicable to substances and properties. Such property tables may also include the automated calculations from business rules;
• Phrase libraries - sometimes with translations of phrases - that contain control statements to be included in generated documents;
• Transaction control tables that include data that prevents or alerts the potential shipment, purchase, import, export, or sale of a product that may be forbidden;
• Document databases that include the generated documents or other documents that may be associated with a product, substance, or process; and,
• Business rule tables with conclusions (Left Hand Side - LHS) actions that depend on criteria (Right Hand Side - RHS parameters). For example, if benzene is a component in a formulation greater than .1 percent used in the United States, then insert the phrase code associated with the conclusion "carcinogenic" into the properties table for this substance identifier.
[0025] There are a number of current limitations in such systems:
• ERP and document authoring systems as SAP EH&S, do not today include a dynamic component, such as a hyperlink, in phrase libraries of control statements used in the creation of certification documents, one that permits the recipient to validate a control statement within a received document in an automatic manner;
• ERP and document authoring systems do not provide for validation of control statements through automatic means in generated certification documents for products from within the generated documents;
• Although it is common for a manufacturer to hyperlink from a product listing on a web-site page to a related MSDS or technical document associated with the product, for example, it does not exist that the control statements in the certification document hyperlink to the authoritative source document for that statement or data element.
• Data processing systems do not exist to pass certification documents containing dynamic control statements with hyperlinks in business-to-business exchange of such between computer systems in computer readable form so that the control statements with hyperlinks can be extracted and placed in a database for further use.
• As a result, such data processing systems do not today allow the generation of certification documents that permit automated third-party validation and change management support services in association with control statements made.
• Such data processing systems do not use the loading and storage of certification documents with control statements using hyperlinks.
• It is not possible to obtain direct access to upstream manufacturer control statements or certification documents as described through a central service and no general practice or data processing system exists to provide this information.
[0026] One of the most difficult tasks of regulatory managers within supplier and customer organizations is keeping up with new or modified regulations or standards. Such compliance tracking tasks focus on the raw materials purchased, the substances manufactured, the processes themselves, or the products sold or distributed. The regulatory manager may use enterprise systems, subscribe to publications, participate in trade organizations, or search the web for information about change.
[0027] Equally difficult is the task of determining or obtaining upstream raw material certifications for products obtained from the immediate supplier.
[0028] It is desirable, therefore, to provide the capability for such a regulatory manager to validate a dynamic control statement within a certification document by a hyperlink to the source document supporting the control statement. In addition, it is desirable to provide the capability for the recipient of a certification document to determine by clicking a hyperlink whether amendments, new requirements, or modifications that pertain to a control statement have occurred for a given period of time, for example, since the time that the certification document was generated.
[0029] It is desirable, therefore, to provide a system by which a recipient's computer system can receive a certification document with its control statement from an upstream supply chain actors in such a manner that the recipient can store and re-use these control statements in authoring a further certification document for a product where the parameters of use are dependent on the control statements of the upstream supplier. Further, the downstream recipient does not have a system by which he can validate the control statements of the upstream provider, if authorized.
[0030] There are many services where you can enroll to receive updates of journals, regulations with customized scope defined by the user. Such services include:
• Westclip on Westlaw
• ECLIPSE on Lexis/Nexis
• U.S. Federal Register
[0031 ] However, the regulatory manager, researcher, or document recipient is interested in changes that relate to the context of the certification document and a particular control statement within it, which at present means that the process of analyzing the control statements within a certification document is separate from and totally independent of the process of tracking changes. The complexity and discontinuity of these two important processes - receiving the certification document and determining changes that relate to such a document's control statements - increase the probability of accidental non- compliance.
[0032] In addition to the data processing system for self-validation of certification documents, it is desirable for the researcher to obtain relevant documents from a searching or indexing system that will return a compilation of documents that includes not only direct
references to the search term for a material but also a synonym, identifier, translation, or reference to a class or group containing the search term as a member. It is also desirable if the document reference from such a search will return the document opened at the relevant page with the applicable direct reference, synonym, identifier, translation, or reference to a class or group containing the search term as a member. Finally, it is desirable if the researcher can obtain a subset of documents, for example, only those that have changed where the returned reference is to a document containing not only a direct reference, but also a synonym, identifier, translation, or reference to a class or group containing the search term as a member.
[0033] Publishers maintain large libraries of abstracts of knowledge in various areas related to science and business, among other fields. One example is the ILLUMINA® system published by CSA and another is SCOPUS® by Reed-Elsevier. Although such systems may contain links to the full-text documents associated with an abstract, they do not include either the search capabilities or validation system as described in this invention.
[0034] Referring now to Fig. 12, an example prior art search from Google® illustrates the need. In this instance, the researcher has searched for a material, specifically, a chemical, which is "crotonic acid". Google® returns two thousand five hundred and twenty (2,520) document references. Entering a synonym, "(E)-2-Butenoic acid" returns only twenty-two (22) document references. A Dutch synonym, "Crotonzuur" returns no hits and the message: "Try different keywords". This search illustrates both a searching display and a searching index that does not return document references that include a compilation of not only direct references, but also synonyms or translations of a material term. This is a common approach of existing search displays and indexing methods, for example, Google®, SCOPUS®, ILLUMINA®, and others.
[0035] In searching for documents relevant to a material, the research is often interested in documents that include a reference to a class of which the search term is a member. For example, if the user enters the term, "crotonic acid", he or she may be interested in a document that refers to "UngesSttigte aliphatische Mono- und Dicarbonsauren" because the meaning of this chemical class with many members includes the specific substance, crotonic acid. Similarly, if the user searches for "sodium chromate", the user would be interested in documents that include a reference to "hexavalent chromium compounds".
Such indirect references to broad classes including the direct search term are not returned by the example searches above of Google®.
[0036] The search term and interest in a reference to a broad group may not necessarily be a chemical, but also a foodstuff, biologic, or formulation. A comprehensive search for the term, "orange", according to the present invention, should return a link to a document including a reference to "citrus fruits, except lemon and limes". Current search systems may return synonyms, (e.g., TOXNET) and may include related identifiers and translations of substance names, but do not include a systematic cross-referencing system for such; nor do they include parent classes within the context of the regulation or referenced document.
[0037] An identifier for a material is a particular type of synonym. Many such identification systems are used by regulatory or scientific organizations, where an alphanumeric code represents a material. For example, the European Union uses EINECS numbers to refer to existing chemicals. FDA has its own system, as do the governments of Japan and Korea. Other systems, include color index numbers, etc. It is desirable to provide a system and method that spans any identifier returning documents that include a reference, whether that reference is a synonym, translation, parent group or class, or identifier in addition to any direct reference.
[0038] Web-based search engines do not include such features whether in the simultaneous display of document links containing references to synonyms, translations, identifiers, and parent groups in addition to direct references or whether in methods used to index documents to extract references to such terms.
Current systems, including those noted above, do not:
• Search with the scope and methods described above or in this invention; nor
• Return a document opened at the relevant page with the term highlighted.
SUMMARY OF THE INVENTION
[0039] One embodiment of the present invention includes a system for validating at least a portion of a certification document for at least one material. The system includes a certification document including at least one dynamic control statement relating to and defining parameters of use for the at least one material, wherein the certification document
is accessible by at least one recipient, and, wherein the dynamic control statement is validated by retrieving validation information relating to the dynamic control statement from a dynamic source of validation information.
[0040] Another embodiment of the present invention includes a method for indexing documents in a data processing system, the documents including a reference to at least one material, comprising: inputting a document into the data processing system; extracting at least one alphanumeric string from the document; determining relevant alphanumeric strings from the extracted alphanumeric strings by processing the extracted alphanumeric strings utilizing at least one algorithm by comparing, in sequence and in combination, the extracted alphanumeric strings with material terms in at least a dictionary database of common material terms; matching the relevant alphanumeric strings with materials alphanumeric strings stored in the data processing system; and storing the matched alphanumeric strings in respective matched records in the data processing system.
[0041] Another embodiment of the present invention provides methods for generating, distributing, validating, and searching documents about products that include standardized phrases that are claims made about the compliance of the product with guidelines, standards, and laws or that are properties of the product supported by a bibliographic reference to a literature reference.
[0042] Yet another embodiment of the invention provides for a database of standard phrases (hyperlinked standard phrase database) each with its own with unique identification code, a text phrase that defines a specific claim or statement, optional translated variants of the text phrase in a one-to-one relationship to the unique identification code, and a hyperlink to a server that can retrieve a document or translation supporting the specific claim made by the standard phrase. In this manner, the Hyperlinked Standard Phrase Database can be distributed and used by many parties in the supply chain so that any document generated that includes the phrase will have a standard meaning and any recipient of the document can validate the statement through clicking on the hyperlink.
[0043] Another embodiment of the invention provides for the Hyperlinked Standard Phrase Library Database including a hyperlink that will return an index, compilation or reference to all changes in the source documents relating to the statement.
[0044] A further aspect of the method above is that it allows the author of the document to use a standard enterprise resource planning system (ERP), such as SAP, Oracle, or other document authoring system to include standard phrases from the phrase database as well as his or her own phrases in a flexible manner so that the document can contain a combination of phrases that are standard, other phrases from upstream suppliers of raw materials, and phrases inserted by the document's author. The standard phrases can be selected based on need by the document's author in a completely free and flexible manner. What is new is that the standard phrase will have a hyperlink to a document or function retrieving the relevant text. In addition, the standardization of the hyperlinks permits the recipient of a document in any form that accepts hyperlinks to retrieve source documents associated with a claim from a centralized service that can route and retrieve hyperlinked source documents from any server wherever located.
[0045] A further aspect of the method above is that it allows for a system of user authorization associated with standard phrases contained in generated product documents. In this manner, an upstream supplier can pass to his direct customer a statement with a hyperlink to a secure server open only to authorized users. Let us suppose that the statement is public but the source documents supporting the claim are confidential. Thus, the customer can include the statement in an authored document and distribute the document to his downstream customers, but the control to open access to the confidential supporting document is controlled by the provider of the standard phrase.
[0046] Another embodiment of the present invention also relates to a method for indexing documents including a description of at least one material in a data processing system. The method includes inputting a document into the data processing system; extracting at least one alphanumeric string from the document; determining relevant alphanumeric strings from the extracted alphanumeric strings by processing the extracted alphanumeric strings utilizing at least one algorithm by comparing, in sequence and in combination, the extracted alphanumeric strings with material terms in at least a dictionary database of common material terms; matching the relevant alphanumeric strings with materials alphanumeric strings stored in the data processing system; and storing the matched alphanumeric strings in respective matched records in the data processing system.
[0047] Another embodiment of the present invention provides methods for searching document management systems and an improved means of efficiently locating, searching, and categorizing documents stored on Internet web-sites to enable identification and cross- referencing of references to dangerous chemicals within documents in any language.
[0048] One aspect of the present invention provides for post-processing of identified documents to permit a document to be opened at a relevant page with the term of interest highlighted, and in the integration of found documents into a validation system supporting certification documents transmitted between supplier and recipient
[0049] Another aspect of the present invention provides a validation that can be established from within the document itself in an analogous manner to the checks that occur in giving a credit card to a merchant in order to effect a purchase. A third-party service supports the security of the transaction between merchant and customer that reduces fraud and improves the efficient functioning of markets — based on the credit card itself.
[0050] Another aspect of the present invention provides a review system and related validation technologies based on the certification document itself.
[0051] One aspect of the present invention provides for a system of self-validating documents with independent validation support services. Another aspect of the present invention provides a self-validating certification documents passed between supplier and recipient based on standard phrases to be included in such documents together with validation hyperlinks that invoke a series of services, including: a) the retrieval of a cited document opened at a referenced page with a highlighted section associated with a material, material class, topic, use, or legal citation; b) the retrieval of summary reports of all requirements related to the standard certification phrase; c) the retrieval of all amendments, additions, and deletions of requirements related to the certification phrase; d) the retrieval of related property data records that may be automatically loaded into a document management or enterprise resource planning system; and e) the retrieval of transaction control alerts. One embodiment of the present invention provides for the generation indexing, extraction, and formation of documents containing validation links.
[0052] Another aspect of the present invention provides a system of self-validating documents through which a downstream recipient of a certification document can assure
himself of upstream certifications related to the submission of the immediate supplier in a confidential manner acceptable to an upstream supplier. Another aspect of the present invention provides self-validating certification documents passed to the validation service by the upstream supplier, including a standard phrase, a validation hyperlink to the source document, and an authorization procedure. If the downstream user accepts or meets the conditions of the authorization procedure, a series of services are made available that relate to the upstream certification in the context of the immediate supplier's product or use, including: a) the retrieval of a cited upstream supplier document opened at a referenced page with a highlighted section associated with a material, material class, topic, use, or legal citation; b) the retrieval of summary reports of all requirements related to the standard certification phrase, including the supplier's confidential certification statements; c) the retrieval of all amendments, additions, and deletions of requirements related to the certification phrase, including the upstream supplier's confidential certifications; d) the retrieval of related property data records that may be automatically loaded into a document management or enterprise resource planning system, including upstream supplier data; and e) the retrieval of transaction control alerts, including transaction control alerts that relate to the upstream supplier's certifications.
[0053] Another aspect of the present invention provides for the generation indexing, extraction, and formation of documents containing validation links.
[0054] Yet another aspect of the present invention provides that the user to search for a standard synonym and return a highlighted reference to a literal reference on the page of a document, which provides the capability to link proper synonyms to literal names found within the text of a document that may not be "acceptable", as well as the ability to link in synonyms based on confidential upstream supplier references;
[0055] Another aspect of the present invention provides linking not only to sets of chemical substances but to any "material" that may not be chemicals in the proper sense at all that may be biological agents, products, or concepts ('sweeteners'), including but not limited to confidential upstream supplier materials.
[0056] Another aspect of the present invention provides a system of self-validating documents including direct submissions between a supplier and a recipient as well as multiple party submissions through a chain of supplier-user relationships.
[0057] An aspect of the invention provides for supporting the validation system in its method to search and index documents in order to extract references to materials, material classes, and legal citations.
[0058] An aspect of the invention provides for supporting the validation system through access to upstream supplier certifications or certification documents through an authorization system.
[0059] Additional objects and advantages of the present invention will be apparent in the following detailed description read in conjunction with the accompanying drawing figures.
BRIEF DESCRIPTION OF THE DRAWINGS
[0060] Fig. 1 is a block diagram of a system for validating certification documents according to one embodiment of the present invention.
[0061] Fig. IA is a block diagram of a system for validating certification documents according to one embodiment of the present invention.
[0062] Fig. 2 is a block diagram of an alternative embodiment of the system of the present invention.
[0063] Fig. 3 is a chart illustrating an example of a hyperlinked standard phrase library of the system of one embodiment of the present invention.
[0064] Fig. 4 is a diagram of a certification document including a dynamic control statement according to one embodiment of the present invention.
[0065] Fig. 5 A is a block diagram of a data processing system according to one embodiment of the present invention.
[0066] Figs. 5B and 5C are flowcharts of a method for indexing documents in a data processing system according to one embodiment of the present invention.
[0067] Fig. 6 is a diagram of a database produced by the method for indexing documents of one embodiment of the present invention.
[0068] Fig. 7 is a diagram of a result of a search for a chemical term according to one embodiment of the present invention.
[0069] Fig. 8 is a diagram illstrating an alphanumeric string in a document to be indexed utilizing the method of one embodiment of the present invention.
[0070] Fig. 9 is a chart illustrating a materials database of one embodiment of the present invention; and
[0071] Fig. 1OA is a block diagram of an alternative embodiment of a data processing system described herein.
[0072] Figs. 1OB and 1OC are flowcharts of an alternative embodiment of a method for indexing documents in a data processing system described herein.
[0073] Fig. 11 is a diagram illustrating a materials database of one embodiment of the present invention.
[0074] Fig. 12 is a diagram illustrating results of a search for a materials term according to the prior art.
[0075] Fig. 13 is a diagram illustrating the results of a search term in a non-English language, e.g., Chinese, where in this case the term is ≡JR1K_B? (melamine).
[0076] Fig. 14 is a diagram illustrating the creation of a customized certification document from one of a personalized profile and search query according to one embodiment of the present invention.
DETAILED DESCRIPTION OF THE INVENTION
[0077] "certification document" - As used in this invention, a certification document comprises: A purchase order, advanced shipment notice, shipping document, material safety data sheet, compliance certification statement, customer procurement standard, compliance statement, technical dossier, label, guideline, legislation, regulation, and standard as well as any document, submission, or compilation required for REACH (Registration, Evaluation, Authorization and Restriction of Chemicals under any related requirements). A certification document includes proposed and final publications and analysis of same.
[0078] "control statement" - As used in this invention, a control statement is a phrase intended to be included in a document to communicate the parameters of use of a material.
[0079] "authoring system" - As used in this invention, an authoring system is a software application employed for one of the preparation, generation, and distribution of a certification document.
[0080] "dynamic control statement" - As used in this invention, a dynamic control statement is a control statement that includes a function that can be executed by the recipient to retrieve one of a document, document reference, document link, compilation, summary, data, and function to perform the same. An example of a function that is included in a dynamic control statement is a hyperlink. An illustration of such a dynamic control statement might be "This product complies with EU Directive 2002/72/EC" found on the worldwide web at decernis.com/reference/document/2002_72_en.pdf.
[0081] "parameter of use" - As used in this invention, a parameter of use is a restriction, limitation, approval, guideline, standard, practice, recommendation, characteristic, behavior, measure, and data for a material.
[0082] "recipient" - As used in this invention, a recipient is a human being and a computer system.
[0083] "validation information" - As used in this invention, validation information is a dynamic control statement, source document, compilation, summary, alert, recall, and reference supporting said dynamic control statement.
[0084] "data processing system" - As used in this invention, a data processing system is a one or more programmable electronic devices that can store, retrieve, and process data.
[0085] "logical function" - As used in this invention, a logical function is a business rule, programmable computer routine that performs a calculation with variables and returns a result. For example, a business rule expressed descriptively is "if the concentration of a component of a mixture is above .1% and that component is a listed carcinogen, then insert the control statement database key which is associated with the phrase 'Carcinogenic'." An example of a logical function expressed descriptively is "if the web server receives a request from a dynamic control statement for a variable associated with the retrieval of a document from the server's document database, then a check should be performed of the user's authorization in the authorization database".
[0086] "material" - As used in this invention, a material means a chemical, formulation, biological product, food, any virus, therapeutic serum, toxin, antitoxin, analogous product, and finished article. Examples of materials include but are not limited to formaldehyde, orange, peanut, mycotoxin, aflatoxin, perfume, polymers, compounds, Irganox, a food or foodstuff, and serums. Examples of a finished article includes a toy, a packaged soup.
[0087] "document" - As used in this invention, a document means a computer file whether as a whole or deconstructed into component parts for electronic transmission and communication.
[0088] "alphanumeric string" - As used in this invention, an alphanumeric string means a sequence of computer codes representing letters, numbers, and control characters, such as a line ending and punctuation mark.
[0089] "algorithm" - As used in this invention, an algorithm is a computer procedure that begins in an initial state and terminates in a definite end state, applied here to process alphanumeric strings to prepare for, compare, determine the relevance of, and terminate indexing and searching related to a material term. For example, an algorithm to prepare an individual alphanumeric string for matching with a material term, is to strip all punctuation codes, raise all letters to capital, and to store the result in temporary memory. Another example of an algorithm is to compare any given alphanumeric string after processing with a database of material terms similarly processed and sorted in order of longest terms first.
[0090] "sequence" - As used in this invention, a sequence is one or more alphanumeric strings extracted from a document in a defined order. For example, the order of extraction includes but is not limited to the presentation of columns within a document and processing in order within a column. Another example is that the order of extraction of alphanumeric strings should follow the natural order of the language, i.e., from left-to-right in English.
[0091] "dictionary database" - As used in this invention, a dictionary database is a collection or records stored systematically in an electronic medium so that it may be queried .
[0092] "common words" - As used in this invention, common words means a dictionary of terms that are ignored as noise in indexing.
[0093] "matching" - As used in this invention, matching is a procedure that terminates in accepting or rejecting an alphanumeric string extracted from a document to determine whether it is identical to a term describing a material stored in a database.
[0094] An embodiment of the invention is a data processing system that improves the capability of a recipient of a certification document to validate dynamic control statements made in the document to define the parameters of use of a product by including within the document hyperlinks that retrieve the source document or reference supporting the given dynamic control statement from a web server (see Figure 1). This embodiment has the effect of communicating data about the parameters of use of a product to improve product safety and compliance.
[0095] Referring now to Figures 1 and IA, a data processing system using hyperlinked dynamic control statements in a certification document is illustrated according to one embodiment of the present invention. A certification document 152 is generated by an author from a client computer 100 via a document authoring application 101 that resides on a document authoring server 151 for a product sent to a recipient 153. Dynamic control statements for a product retrieve, e.g., by hyperlink, an authoritative source document 102 and are included in an electronic certification document 104 for electronic transmission to the recipient 153 via a network. However, a recipient may also receive the electronic document via computer readable medium, such as XML or other electronic document exchange or by posting or sending a link to a secure web server, discussed in more detail below, to the recipient 153. The recipient 153 validates a dynamic control statement, for example, by clicking on a hyperlink in the electronic certification document 104 that returns from a validation server 154 at least one of the following sources of validation information: (a) a source document 107 supporting the dynamic control statement ; (b) a list of change(s) 109 relevant to the dynamic control statement; (c) a compilation 108 of references related to the dynamic control statement, and (d) alerts 110. The validation server 154 is preferably a dynamic source of validation information, as the information is preferably updated at least at predetermined intervals.
[0096] The request 1 13 is passed to the web-server 106, which may be in a number of different forms, including but not limited to HTTP, SOAP, remote object function calls,
web services protocols, and the like. The web-server 106 passes the request to the application server 111 that returns a response to the request 114.
[0097] A hyperlinked standard phrase library 102 includes for each dynamic control statement at least one of the following and preferably including a hyperlink, hyperlink fragment, or other variable that serves to invoke a function: a unique identification code, a phrase identification code, a language code, a text string, and a hyperlink or hyperlink fragment stored in a database. In a preferred embodiment each dynamic control statement may have translated variants associated with dynamic components, e.g., hyperlinks, that will return from a server the source document supporting the statement. In another preferred embodiment the hyperlink may be fully formed or a unique fragment associated with the unique phrase code which when appended to a base URL address where the server application has been loaded will return from a server the source document supporting the statement.
[0098] A dynamic control statement with a hyperlink in the present invention can be included in a certification document, advantageously to providing the recipient 153 the capability to validate it.
[0099] The hyperlinked standard phrase library 102 is preferably integrated into a document authoring application 101, for example an enterprise resource planning system, such as SAP R/3, SAP EH&S, product life cycle management system, or material safety data sheet generation system. The author of the document 100 to be prepared for a material stored in the Product Composition Database 103 selects unique dynamic control statements with the hyperlinks that represent parameters of use to be included in the certification document for a given product. For example, a food contact certification document for a particular grade of polyethylene is being manufactured and an author selects the phrase "Kunstoffverordnung Nr. 476/2003" (with its associated dynamic component, e.g., hyperlink) to indicate the compliance of the manufactured product with an applicable food contact regulation in Austria. The author electronically places into a certification document the phrase with its hyperlink to the authoritative document so that the recipient can validate the dynamic control statement independently.
[00100] The generated certification document 152 may be in any form that accepts a hyperlink or logical function to retrieve validation information for a dynamic control
statement 104, including HTML, RTF, Microsoft Word, Excel, Adobe PDF, or in a structured data format such as XML but not limited thereto.
[00101] The document received by the recipient 153 includes dynamic control statements with a hyperlink or logical function to retrieve the source document accessible from a validation server 154. The recipient of the certification document who wishes to examine the authority for a particular dynamic control statement may request 113 the source document from the hyperlink through the validation server. The web server 106 receives the request that is processed by the validation application 1 11 to retrieve the requested data from the database 1 12. The recipient is directed to the source document 114 through the web server 106.
[00102] Figure 3 illustrates one example of an embodiment of the present invention for a Hyperlinked Standard Phrase Library of dynamic control statements with hyperlinks, providing a more detailed illustration of 102 in Figure 1. In this example of a preferred embodiment, a unique identification code 300 groups dynamic control statements that have been translated into different languages so that the document authoring application 101 can produce a certification document 152 in Figure 1 in any of the languages available in the Hyperlinked Standard Phrase Library. The Phrase Code 301 identifies the specific dynamic control statement in the database. The Language Code 302 defines the language of the text phrase, i.e., the dynamic control statement, 303. In addition, the hyperlink or hyperlink fragment 304 references the source document or documents supporting the specific dynamic control statement in any available language. The address of the hyperlink can refer to any one of the following to produce the results 107, 108, 109, or 110 for a dynamic control statement: A specific document, compilation, or summary in the document database 112 of Figure 1, an index pointing to a document, compilation, or summary, or an argument of a function that will retrieve or generate a requested document, compilation, or summary.
[00103] Referring now to Figure 2 a data processing system using hyperlinked dynamic control statements in a certification document 252 is illustrated according to one embodiment of the present invention in which the certification document 252 is transmitted in computer readable form. In this embodiment of the present invention the certification document 252 is produced in a computer readable form, including XML or other electronic
document exchange formats, in such a manner that a dynamic control statement 204 can be received by the recipient's enterprise system 253 via the receiving computer 215. The dynamic control statement can then be extracted and stored in the recipient's database 216.
[00104] Again referring to Figure 2, in this embodiment of the present invention the recipient can produce electronic reports from the database 216 in the enterprise system 205 that include dynamic control statements received in certification documents for a product. The recipient using the enterprise system 253 can validate such dynamic control statements by clicking on a hyperlink in any such generated recipient electronic report will produce a request 213 that will return (214) from the validation server 254 at least one of the following sources of validation information: (a) a source document 207 supporting the dynamic control statement; (b) changes 209 relevant to the dynamic control statement; (c) a compilation 208 of references related to the dynamic control statement, and (d) alerts 210. The validation server 154 is preferably a dynamic source of validation information, as the validation information is preferably updated at least at predetermined intervals.
[00105] In a further embodiment of the present invention, the recipient can implement a document authoring system as in Figure 1 and load the received dynamic control statements with hyperlinks or logical functions into the recipient's equivalent Hyperlinked Standard Phrase Library as in 102 of Figure 1, thus permitting the reuse of dynamic control statements in a plurality of document authoring systems for any dynamic control statement passed through the supply chain. In an embodiment, the recipient's Hyperlinked Standard Phrase Library includes at least one of the following with hyperlinks: standard dynamic control statements, the recipient's own dynamic control statements, and received dynamic control statements. The recipient who has implemented a data processing system of the present invention can generate certification documents including dynamic control statements passed to the recipient.
[00106] One embodiment of the present invention provides a certification document with such hyperlinked dynamic control statements can be passed to a recipient in a computer readable medium so that the recipient can then include a received hyperlinked dynamic control statement in authoring a further certification document. In consequence, the embodiment provides a data processing system to improve the means of passing information in a supply chain to control the safe use and compliance of products in a
standard manner and in a manner that permits the validation of a dynamic control statement included in a certification document being transmitted in a supply chain.
[00107] The present invention provides an improved capability to prepare and distribute hyperlinked standard phrase libraries that are industry, subject-specific, or within a supply chain with hyperlinks and optionally translation variants so that a manufacturer may prepare a certification document in a flexible way with any selection of applicable hyperlinked dynamic control statements according to the conclusions of the expert author of the certification document and thus to permit the recipient to evaluate the stated parameters of use of the product by reviewing the source document supporting each dynamic control statement made.
[00108] Further, one embodiment of the present invention improves upon current practice by providing a method by which the author of a certification document may add locally authored dynamic control statements to the hyperlinked standard phrase library or to insert in a certification document hyperlinked dynamic control statements received from upstream suppliers of raw materials, which improves the capability for upstream suppliers to communicate parameters of safe and compliant use of materials through certification documents that includes a data processing system that can be implemented by both direct recipients of a certification document as well as downstream recipients of a dynamic control statement associated with the raw materials of a value-added produce to validate the source documents or references associated with any given dynamic control statement.
[00109] Through the availability of translated variants, documents generated with a hyperlinked dynamic control statement may be in any language. Such translated variants may be required where the use of the document is in a country with more than one national language, for example, Belgium, Canada, or Switzerland.
[00110] A further embodiment of the invention improves upon the capability of the recipient of a certification document 152 to determine changes in associated source documents relevant to an included dynamic control statement 104 for a given period of time. Referring to Figure 1 and Figure 3, the recipient of a certification document 152 can request 113 changes 109 relevant to a dynamic control statement 104 in a certification document 152 for a given period of time. In an embodiment the argument of the hyperlink of a dynamic control statement can include a date in order to request (113) changes (109 in
Figures 1 and 3) relevant to the source documents supporting a given dynamic control statement 104. For example, the argument of a hyperlink may include the date of the certification document's 152 generation in order that the recipient can be informed of amendments to a regulation cited by the dynamic control statement.
[001 11] The invention provides a data processing system that improves upon one of the most difficult tasks for a recipient of a document in the supply chain, which is to determine whether important amendments or modifications have come into force, or further studies or standards, relevant to a specific claim made in a dynamic control statement. At present, this task is disadvantageously performed manually by the recipient. For example, if the text of the dynamic control statement is, "This product complies with EU directive 2002/72/EC for plastic materials in contact with foodstuffs" then the hyperlink request 113 to the validation server 106, 109 can return 114 references to all successive amendments to this directive since the time of the certification document's 152 generation. The invention thus provides an improved capability to provide a data processing system for standardized change management alerts for dynamic control statement 104 claims made in certification documents 152 to support the safe use of a product.
[00112] A further embodiment of the present invention is a data processing system to provide for product recalls and product alerts for specific shipments. In an embodiment of the present invention, an RFID identification number is associated with the certification document 152 or 252 or to one or more dynamic control statements 104 or 204 with hyperlinks or logical functions in order to return from the validation server 254 a product recall, alert, or other information applicable to a specific shipment.
[001 13] The present invention improves the capability for a data processing system to provide alerts regarding product recalls 110, 210 or other information as described above from a validation server 106, 206 not only in relation to the product in general but to a specific shipment of that product identified by RFID identification code, such information regarding a product recall or alert being automatically provided in response to a request 1 13, 213 either from a human being 153 or from a computer system 253, which provides for the advanced shipment notice or other commercial business-to-business interaction in electronic document exchange format or in XML format to include a reference to a
document generated with the Hyperlinked Standard Phrase Library and to an RFID identification of a specific shipment.
[00114] The described embodiments of the present invention improve the capability of the recipient to review MSDS and similar compliance certification documents, which otherwise must be carried out manually. The data processing system of the present invention further supports review of compliance and review of supplier certifications for foodstuffs, medical devices, pharmaceuticals, etc. The present invention is an improvement in that it is based on the document itself and not on an adjunct manual review process. An aspect of the present invention is to provide supply chain actors with a validation service bureau where such actors may generate may connect generate regular documents, regulatory compliance document preparation with the source document validation management that the invention provides.
[001 15] A certification document or safety document is self validating upon review by the recipient. Currently a recipient must contact the supplier directly to validate documents.
[001 16] Another embodiment of the present invention applicable to certification documents is that the document opened by the hyperlink or logical function of the invention may open a document, may open a document at a cited page, or may open a document at a cited page with a relevant section of the page or document highlighted. In such a form, the hyperlink or logical function contains an argument that includes the page(s) number of the cited document and the sections of those pages to highlight with the coordinates describing areas of the page to highlight. One example is to specify coordinates of the highlighted page by defining one or more rectangular areas of the page to highlight identified by the x,y positions of the axes of the rectangle that can be positioned on the space of a page. Other highlighted shapes or coordinate systems may be provided for within this invention. What is improved is the capability for the user of a certification document to click on the hyperlink or invoke a logical function so that the source document which will be returned from the validation server opened at the relevant page associated with the statement in the document with the highlighted relevant section of the page(s) of the source document.
[001 17] A further embodiment of present invention provides access to a data processing system which is controlled by the level of service agreed to in a service agreement. In this aspect of the invention the hyperlink contains an additional argument which is an
authorization code to control users authorized to view or download the source document referenced by the statement in the received document, which improves the general capability for upstream supply chain actors to provide documents containing statements referencing confidential information to intermediate and downstream actors in the supply chain. The downstream user can pass along the statement with the hyperlink or logical function to customers who may rely on this statement and be granted access based upon the privileges granted by the owner of the information hyperlinked with the statement, which improves the potential for a service bureau to manage authorization privileges for statements included in a Hyperlinked Standard Phrase Library. In this aspect of the invention it is not necessary for the service bureau to maintain the confidential documents themselves, only references to them with the reviewed authorization privileges.
[00118] To provide an example of the type of certification document depicted at 152, 252 Fig. 4 shows a certification document for a Polyethylene product containing dynamic control statements that the product meets required approvals for its use in several countries. Each dynamic control statement contains a hyperlink of the type defined in the invention that permits the customer to receive a document that can perform one or more of the following:
• hyperlink to the text of the applicable cited regulation, optionally opened to the relevant page with a highlight of a section of the page.
• hyperlink to a validation server that will return all regulatory changes for the dynamic control statement since the date of the document's generation for the context of the letter for which the behavior of the returned format or information can be customized; this includes the capability for authorized users to obtain from a validation server the changes to the certifications of an upstream supplier;
• hyperlink to a validation server to return a summary report or compilation of other relevant requirements or restrictions of interest to the customer; This includes the capability for authorized users to obtain from a validation server a summary report including the certifications of an upstream supplier;
• hyperlink to a validation server to return a transaction control alert, such as "forbidden in transport by air";
• hyperlink to a validation server to return data in a structured format.
[00119] In the example, 400 illustrates a dynamic control statement for the United States (401) while 402 illustrates a dynamic control statement for Sweden. Dynamic control
statement 400 hyperlinks to document 403 with a preferred embodiment in which the section is highlighted 405. 120] 400 illustrates a claim and instruction by the supplier for the safe use of the product, i.e., a dynamic control statement, that the product complies with 21 CFR 177.1520(a)(3) (2003). In the simplest case, the user may be interested in an immediate review of the relevant source regulation opened at the page with the relevant page with the section highlighted that relates to FDA regulation of "Olefin polymers" (as illustrated), a family of plastics that subsumes the specific product, Polyethylene. To produce this result, the supplier receives a Hyperlinked Standard Phrase Library (Figure 1, 102) that contains identifiers, a phrase code, phrase texts in optionally different languages, and a validation hyperlink, as illustrated in Fig. 3. In this example embodiment the dynamic control statement is:
"FDA , CFR, Title 21 (2003), 177.1520 (a)(3)(i)(c)(l),(b) and (c) 3. Ia. Olefin Polymers." The validation hyperlink for that phrase code is:
//decernis.com/reference/navpdf2.jsp?timestamp=6_5_2003&piOfile-l 155&doc=2 1 58789.pdf&pg=3&llx=156&lly=173&rux=196&ruy=183&lib=document in which the validation hyperlink or logical function may contain one or more components, such as:
• URL [http://decernis. com/reference]
• Target function [navpdΩ.jsp]
• Timestamp [6_5_2003]
• Source
• Identifier
• Profile [1155]
• Topic
• Material
• Document [2158789.pdf, page 3, and the document itself is to be retrieved]
• XY positions [lower left x position (Hx) at 156, lower left y position (lly) at 173, right upper x (rux) position at 196, right upper y position (ruy) at 183]
o In consequence, the validation hyperlink or logical function can alternatively contain, for example, systematic information that can be associated with certification phrases in the document.
[00121] In this manner, a database of hyperlinked dynamic control statements as a component of the data processing system of the present invention can be distributed to many different suppliers permitting consistency and validation by recipients in the communication of the parameters of use of a product, while allowing for significant customization to meet the needs of a supplier. The validation database can include dynamic control statements of an upstream supplier that include a hyperlink to the source document contained in a database available only to authorized users. In this manner, the author of a document can assemble certification statements in a standardized as well as customizable manner that include both the immediate user's claims as well as upstream supplier claims although the upstream supplier claims would only be accessible to an authorized user. As a result certifications can be passed from multiple parties upstream in the supply chain, simplifying greatly the assessment task of an downstream user.
[00122] The supplier can use his or her document authoring environment to embed the appropriate phrase codes within a defined report template for a given product. The invention is providing a component that can be used in ERP or document authoring systems.
[00123] Once the document authoring step has been completed the supplier distributes the certification document in at least two ways:
• The recipient may be an end-user (153), e.g., procurement expert for a customer reviewing compliance for global raw material acquisitions;
• The recipient may be another ERP system (253) automatically connected in a business-to-business network in which the transaction data and documents are passed from the supplier's ERP directly into the recipient's ERP system.
[00124] The end-user can open the document in a number of different formats (Adobe PDF, Microsoft Word, HTML, etc.), and click on the validation hyperlink within the document itself (401). The user may invoke (or depending on the customization of the validation hyperlink) a number of different services from the validation hyperlink:
• The source document may be returned opened at the relevant page, optionally with a relevant section highlighted (107, 207);
• The validation service may provide a report of all amendments or modifications to the cited document since the date of the document's generation relative to the timestamp of the validation phrase code (109, 209);
• The validation service may return a summary report of other regulations within the topical context of the document as defined in a profile (108, 208);
• The validation service may return alerts, news of proposals relevant to the certification, or other transaction control information (110, 210).
[00125] In addition, if the document above contained a statement, such as "Raw materials used in processing comply with FDA requirements, according to supplier certification", the source document would be opened as above, but only to an authorized user.
[00126] The supplier of the Polyethylene certification has cited a 2003 dated CFR in the above example. An obvious question for the recipient is whether FDA has promulgated any changes to the citation from the time that the document was created. Two related issues arise: a) Was the supplier correct and current in citing the FDA approval; and b) have any changes occurred since? One aspect of the present invention provides validating documents for a quicker and more effective answer to these questions.
[00127] Further, the customer may wish to trans-ship the received polyethylene [as the example in this case] to another country not included in the list of certifications. At this point, although the supplier may not have, in some cases, disclosed all information necessary for a conclusive answer by the customer, the customer may wish to make an independent evaluation based upon the information provided for a number of reasons. The customer's intended market or use may be perceived as confidential information that the customer may be unwilling to disclose to the supplier.
[00128] As a result a rich set of validation services is provided on the basis of the system of validation of the invention, and these services are available to both supplier and recipient, as well as downstream in the supply chain.
[00129] Document Searching, Indexing, and Extraction of References to Materials and Material Classes: An aspect of the invention provides for supporting the validation system is its method to search and index documents in order to extract references to materials and material classes. The invention provides methods for:
• Indexing, searching, and extracting direct references, identifiers, synonyms and multi-lingual references to "materials" from a document (e.g., 608, 703, 704); and
• Indexing, searching, and extracting multi-lingual references to "material classes" from a document (e.g., 609, 701, 702).
[00130] A material in the database has a common identification even if it may be referenced by many other identifiers as used in regulations or documents. Although prior art has defined any number of different types of databases of substances, the present invention is unique in several respects:
• The database has a superset and unique concept of material that cuts across-and- relates individual occurrences to it;
• The database structure links together proper names, synonyms, translations, identifiers, and literal names (i.e., alphanumeric sequences used in documents that refer to a material but may be erroneous or have ancillary alphanumeric characters associated with them), allowing a reference in a document, which may be entirely erroneous or in a different language, to be related back to both a proper synonym as well as to a larger concept of material; and,
• The database structure links all of these references together to the associated documents.
[00131] A material class is a superset containing one or more materials. An example of a class defined in many environmental, safety, and health regulations is "Chrome VI" compounds, which defines a particular membership of chromium compounds and includes sodium chromate. In order for the user of a material to meet applicable requirements, he or she must be aware not only of direct references to the substance but also indirect references, which apply through parent-child relationships. For example, sodium chromate is a "child" of the "parent" class, "Chrome VI compounds". In many cases, because the legal definition of the regulation's scope - or more precisely, the document's definitional context - the use in question may not be a scientific relationship but an arbitrarily defined one. As noted above, an automaker may define a set of materials that it has chosen not to purchase, as a matter of policy. Or, a document may refer to a particular list of salts, but not all salts of an acid.
[00132] Although prior art includes many uses of parent-child relationships in databases and to parent-child relationships of substances to groups, the present invention is unique in that:
• Materials and material class references are related to their occurrence within documents;
• Materials and material classes are defined within the scope of a document or regulation;
• Materials can themselves be supersets of substances;
• Materials and material classes are structurally linked to multi-lingual occurrences and to literal name occurrences.
[00133] One embodiment of the present invention is a method and data processing system to cross-index references to chemicals and materials in documents not only by a direct reference to a material but also by one or more of the following: synonym, identifier, translation, or material class of which the chemical is a member.
[00134] An illustration from prior Art of the need for the embodiment of the present invention to provide a method and data processing system to cross-index references to chemicals and materials in documents is illustrated in Fig. 12, which provides the results from three searches from Google 1202, found on the worldwide web at scholar.google.com/. The first example 1203 is a search for the chemical, "crotonic acid" that returns two thousand five hundred and twenty document references (2,520) 1204. The second example is a search for a synonym of the chemical, "(E)-2-Butenoic acid" 1205 that returns twenty document references (22) 1206 that are not consistent with the references found in the first search. The third example is a search for a translation of the chemical, "Crotonzuur" 1207 that returns no search results from the Google index or search engine 1208. Similar results would occur for a chemical class of which crotonic acid is a member, such as "Ungesattigte aliphatische Mono- und Dicarbonsauren C3-C8" or "Acidos". The approach to indexing chemical terms by prior Art embodied by other suppliers provides similar inconsistencies: for example, the search above would provide similar inconsistent results but for a different document index library if the same three searches were performed
on the publicly accessible demonstration of Illumina, found on the worldwide web at csa.com/.
[00135] One embodiment of the present invention provides all matching available document references to the entered search term, synonyms of the search term, identifiers of the search term, translations of the search term or classes of which the chemical or material is a member can be returned from a search for a chemical or material term (see Figure 7). In this embodiment, the synonyms may be in any language in order to return cross-indexed references (see Figure 13).
[00136] Referring now to Figures 5 A, 5B, and 5C, an embodiment of the present invention is illustrated, providing the steps to index chemical entries in a document that includes a reference to at least one material, so that the data processing system can permit a search for a given chemical in order to return from a web server not only a direct reference but also a compilation of references to documents containing the chemical term including: (a) documents containing a synonymous reference to the chemical term; (b) documents containing a translated reference to the chemical term; (c) documents containing a reference to an identifier associated with the chemical term; (d) documents containing a reference to a parent class of which the chemical term is a member.
[00137] Referring now to Fig. 5C, in a method 501 at a step 502, the document is input, preferably in electronic format, such as HTML, Adobe PDF, Microsoft Excel, Microsoft Word, or in computer readable form such as XML or other document exchange format and preferably input into a document database 530. The software of the present invention extracts all of the words or alphanumeric strings in the document in a step 503 and tests that it is a word and not simply a sequence of control codes or other information. In one embodiment of the present invention, a found word is compared to a dictionary of common words in order to suppress words that are not chemical terms, which has the effect of decreasing the size of the database and the speed of the indexing. Once the words are found in the document, a record in the index database is stored. In a preferred embodiment of the present invention the word is stored, including the address of the document whether a filename or hyperlink, the page on which the word is found, and the position of the word on the page. One method for defining the position of the term on the page is to define a
rectangular area that encompasses the area of the word on the page, and to store the coordinates of the rectangle in the index record.
[00138] In a step 504 the relevance of the extracted words or alphanumeric strings in the document as stored in the index is determined by comparing, in sequence and in combination, the extracted words or alphanumeric strings to a dictionary database of material terms. The material terms dictionary database contains at least one of the following: a unique material identification code, a preferred name of the instance of the material, and a name used for matching against a document term (Matchname). An extracted word or alphanumeric string is compared to an index of Matchnames from the database of material terms, such as by retrieving the extracted word or alphanumeric string from a document index, discussed in more detail below. If a match occurs in a step 505, an index record is prepared for at least one of the following: (a) found chemical, (b) document, (c) document address, (d) material code, after which the record is stored in the materials index in a step 506. As a result of this embodiment of the indexing system, a particular chemical name is indexed against any entry in a plurality of documents in the document database.
[00139] Referring to Fig. 5B the sub-step 504 is shown in greater detail. After the alphanumeric strings have been extracted in the step 503, the first alphanumeric string is extracted in a step 535. In a step 536, the alphanumeric string is prepared for matching, such as by converting lower case characters to upper case, stripping punctuation, converting Greek letters to alphanumeric equivalents or the like. In a step 537, the alphanumeric string is compared with a dictionary database of material terms. In a step 538, if a match occurs, the method proceeds to the step 539 and the matched term is added to a stored set of matching material terms, after which the combined matching terms are combined in a step 541 and the method proceeds to the step 544 to test if there are more strings in the document. If there are no more strings, the sub-step 504 ends and the method 501 proceeds to the step 505. If there are more strings, the method returns to the step 535 to begin a new determination of relevance.
[00140] If no match occurs in the step 538, the method tests, in a step 540 if the stored material terms exist. If the stored material term does exist, the method proceeds to a step 542 where a stored matching material term is retrieved, which is accepted as a material
reference and the method writes an index record in a step 543 after which the method proceeds to the step 544 to test if there are more strings in the document. If there are no more strings, the sub-step 504 ends and the method 501 proceeds to the step 505. If there are more strings, the method returns to the step 535 to begin a new determination of relevance. If no stored material terms exist in the step 540, the method proceeds to the step 544 to test if there are more strings in the document. If there are no more strings, the sub- step 504 ends and the method 501 proceeds to the step 505. If there are more strings, the method returns to the step 535 to begin a new determination of relevance.
[00141] Referring now to Fig. 5A, the materials database or dictionary database of common material terms is illustrated at 515 as including one or more of the following: (a) A unique material identification code or key 516; (b) a proper chemical name 517; (c) synonyms 518; (d) identifiers, e.g., an EU Reference Number, an EINECS number, etc. 519; (e) translations of chemical names 520; (f) members of parent classes, e.g., sodium chromate is a member of the class hexavalent chromium compounds; and other material attributes.
[00142] The embodiment of the indexing method in Fig. 5A and the present invention applies to any biological terms as they do to chemical terms, all encompassed within the definition of material as used in this invention: (a) A unique material identification code or key is assigned to an entry; (b) a proper name is assigned, e.g., Citrus sinensis; (c) synonyms are assigned, e.g. sweet orange; (d) identifiers that might be used, in this example none; (e) translations of the term e.g., Appelsien, sweet orange, Apelsiini, Arancia, and7l" U Vv; (f) members of parent classes, e.g., this example is a child of the parent class, citrus. In this manner the embodiment of the indexing method can, for example, reference documents establishing thresholds for pesticide residues and additionally cross-reference them to a particular cited item, such as sweet orange, a synonym in any language, or to a family of related items, such as citrus fruits, permitting the user to open the referenced document at the page at which the item is cited via a defined set of cross-indexed terms.
[00143] A master materials database is shown at 523 and defines the relationship with a master "material" that encompasses one or more entries in the materials database 515. A master material record has one or more of the following elements: (a) a unique master materials code or key 524; (b) a proper master name 525; (c) master identifiers associated
with the master material 526; (d) attributes associated with the master material 527; (e) an identification that this is a parent class.
[00144] After the method 501 is complete, a cross-index is generated by retrieving a matched alphanumeric string from the step 505, matching the retrieved alphanumeric string with a matching master materials database key 524 and cross-indexing the matching records in the document database 530, the materials database 515, and the master materials database 523. In this embodiment of the present invention, the resulting cross- index permits a particular occurrence of a chemical term to be related not only to all indexed documents in the document database 530 containing the term, but to any synonym, translation, identifier or membership in a broad chemical class in the materials database 515 or the master materials database 523.
[00145] Referring now to Figure 6, the results of the indexing of chemical terms in documents is illustrated in an example of an embodiment of the present invention. An example master material key (516 in Fig. 5A) is illustrated at 601. If there is an associated reference to a master material key (524 in Fig. 5A) that is a parent class the key entry is represented in 602. For example 608, in this instance the preferred name for the material entry is (E)-2-butanoic acid 603, indicating here as the "head name" with a material identifier code 304 (601). One instance of a material linked to this index entry is the name, "crotonic acid" 604. This entry is found in the file, 21cfrl76.180.pdf (607). An attribute of this entry is a citation, "21 CFR 176.180 Paper/paperboard (dry food)".
[00146] In another instance 609, the material is a member of a chemical class "Ungesattigte aliphatische Mono- und Dicarbonsauren C3-C8", and this class is referenced in a document with the citation "BfR Empf. 35 [XXXV.] Mischpolymerisate: Ethylen, Propylen, Butylen, Vinylestern, ungesattigten aliphat." with the filename, de_350deutsch.pdf. (E)-2-butanoic acid is a member of the referenced class of chemicals.
[00147] Fig. 8 is an illustration of an example of a fragment from a document, 21 CFR § 178.2010, with a sequence of words at 810, beginning "3.1 Mineral oil (CAS Reg. No. 8012-95-1): Not to exceed 40 percent by weight of the stabilizer formulation". In applying the method 501 of the present invention for indexing chemical terms to this portion of the document, the chemical term of interest in this fragment is "Mineral oil", which is embedded in a sequence of other alphanumeric characters and other non-
alphanumeric punctuation, bit streams, and control codes. The first term of this sequence is extracted as indicated in steps 503 and 506. This alphanumeric sequence,"3.1", does not match any term in the materials database and is discarded.
[00148] One difficulty with existing indexing methods that is addressed by the present invention is that a chemical term may span many separated words 901 as illustrated in Fig. 9. Extracting only the first word length term in sequence, i.e., "Mineral" would not correctly represent the term in this example extract. One advantageous aspect of this embodiment of the present invention is that the comparative indexing method in the step of determining relevance 506 heuristically evaluates a series of possibilities as it processes the document by considering a plurality of terms in sequence. In one embodiment of this method, the terms in the material database 515 are taken in order of the longest alphanumeric sequence first.
[00149] In an illustration of this approach, the indexing utility extracts the word, "Mineral" in the step 503 and stores this term temporarily until the indexing method 501 can conclude that the best match has been found for the series, rejecting or accepting terms as the processing continues. For instance, "Mineral" might possibly be followed by "reinforced nylon resins", "Mineral oils and hydrocarbons", "Mineral oil based greases", or the like as shown at 901 although it does not in the document example 801. At this step the indexing method 501 has found a chemical term with a plurality of matches, and then seeks to narrow the possible matches by taking the second term, "oil" 801 following the term, "Mineral". "Mineral oil" in combination eliminates all other available terms in this example, and the method determines that "Mineral oil" with the internal identification material identification key (516 from Fig. 5A) of "1476" (902 in Fig. 9) matches this series of words in the document in the step 509. This match is then stored in the step 510.
[00150] The indexing method 501 then moves in sequence or sequentially to consider the following term, "(CAS" and the subsequent term"No". 803 that are discarded without matches. In a preferred embodiment of this method, a database of common (i.e. non- material) words may be additionally used to make the comparison more efficient by eliminating any common word, such as "the", "No.", "not", "to", "exceed". A common word in such a list would be ignored by the indexing method 501. In consequence, if the database of common words is used in the heuristic comparison step 508, the words of the
phrase "Not to exceed" would be discarded as "common words" or "noise" without comparison to the material database.
[00151] In a further aspect of this embodiment of the present invention, the CAS Registry Number, "8012-95-1" 803, is an example of an identifier for the substance, "mineral oil" that can be itself extracted from the document by the indexing method 501 of the present invention and used in association with other material identification keys that are themselves linked to other document references.
[00152] In an embodiment of the indexing method 501, the words are pre-processed to strip punctuation and capitalize terms so that the comparison step can consider a number of equivalent chemical terms more easily. Taking an example, such as "(+) l,6-Di-(4- amidinophenoxy)-n-hexan", whether the chemical appears with the use of parentheses or bracket characters does not matter, because the indexing method would treat the punctuation as noise. Similarly the embodiment would ignore case sensitivity, such as initial capitalization in a document reference.
[00153] Additionally, certain alphanumeric sequences taken together are considered as equivalent in the preferred embodiment of the indexing method. For example "Alphamuurolen", "a-Muurolene", and "α-Muuolene" are equivalent, permitting the "Alpha", "a-", and "α-" alphanumeric character sequences to be indexed as companion terms. Such terms can be in any position within the word, such as "2-Metossi-4-(2- propenil)fenil-β-D-glucopiranoside" which should be treated synonymously to ""2- Metossi-4-(2-propenil)fenil-beta-D-glucopiranoside". These variants are assigned to the matching material key 516 or 531.
[00154] In the previous example, the indexing method 501 found the term, "Mineral oil" in the text of the document and its associated reference to the material identification key "1476" 902. Once this identification has occurred, the material identification key 516 or 531 and thus the document reference may be related to all other references associated with the master material key 524. The master material key 524 may include direct references, synonyms, translations, or chemical or material classes. As an example of a material class, the material, "mineral oil" with its material identification key can be considered a member of the class, "cottonseed and other edible oils". Thus the master material identification key
524 would include a reference to this class.
[00155] The indexing method 501 of this embodiment of the present invention can be used to support a search for "mineral oil" that will return a reference to any available document that uses the term "cottonseed and other edible oils". In this example, the benefit of this cross-indexing is that the user would be able to rapidly determine that "mineral oil" is permitted as a surface lubricant by FDA in the production of resinous and polymeric coatings used in food contact uses under 21 CFR § 175.300.
[00156] The method 501 for indexing and searching chemical terms has significant, beneficial application that assist in improving the safe and globally compliant use of product, for instance. The method 501 of the present invention permits a cross-referencing of documents by: (a) preferred chemical name, (b) identifier; (c) translation; (d) synonym; and (e) membership in a parent class.
[00157] Referring now to Figure 7, a data processing system is illustrated as a preferred embodiment of the present invention that returns in response to a search based on the index described above for a particular material name, "crotonic acid", with found references to documents that include a reference to a synonym 703, one or more references to parent classes 701, 702, or a translated name 703. In this illustration of a preferred embodiment, the hyperlink to the document opens at the page of the document on which the particular reference is found.
[00158] Referring now to Figure 13, the above preferred embodiment of the present invention that returns in response to a search based on the index described above for a particular material name in a non- English language, "≡RIKK" (melamine) 1301, with found references to documents, which in this case are a set of regulations that control this material in food contact use 1302. The hyperlink to the referenced document opens at the page of the document on which technical synonym in a different language appears. The benefits of the present embodiment return document cross-references across language, across synonym, and across associated class in contrast to the method illustrated in Fig. 12 where such results do not occur.
[00159] The preferred embodiment permits the user to enter a search term and to create a personalized profile of search terms in order to return a search result that is itself a compliance document. The personalized profile may include a plurality of materials, a
plurality of topics, a plurality of jurisdictions or any combination of the above. The customized result from the user's search profile may be in any language whether the same or different from the input.
[00160] Another aspect of this embodiment of the present invention is that the indexing method can be applied to a subset, such as those documents that have changed over a particular period of time.
[00161] Referring now to Fig. 10, an embodiment of the present invention is illustrated in which the body of documents selected for search are "new" or "changed". The subset of documents subject to indexing and search may be assembled by either manual or automatic means. For example, manual research may have identified amendments to a certain topical area of regulations over a period of time, or a subsequent studies that have been published, or other subsequent publications during the given period. Automatic means may select a document subset as well.
[00162] In consequence, the present embodiment supports a search for a chemical that is affected by a change, whether the document that has changed refers directly to the chemical term, uses an identifier, a translation, or refers to a chemical class encompassing the term.
[00163] Referring now to Fig. 11, a search for the term "biotin" 1101 returns a reference to a repealed European Union Directive 96/5/EC 1102, where a reference to this material was deleted by the action of a subsequently enacted directive. This document is a member of a subset of documents added or changed during a given period of time. In Fig. 11, the period of time is "the current update", and the color red and the citation struck through indicates that the document was repealed as one visual method of presentation in the present embodiment. The benefit of the present embodiment are that a researcher can more effectively keep abreast of changes that affect his or her use of materials that are referenced in newly published regulations or documents through the present data processing system. At present, the researcher must perform this task manually or through partially automated searches.
[00164] At present, the researcher must perform this task manually or through partially automated searches.
[00165] Referring now to Figures 1OA, 1OB, and 1OC, an embodiment of the present invention is illustrated providing the steps to index chemical entries in a new, subset, or changed document that includes a reference to at least one material, so that the data processing system can permit a search for a given chemical in order to return from a web server not only a direct reference but also a compilation of references to documents containing the chemical term including: (a) documents containing a synonymous reference to the chemical term; (b) documents containing a translated reference to the chemical term; (c) documents containing a reference to an identifier associated with the chemical term; (d) documents containing a reference to a parent class of which the chemical term is a member.
[00166] Referring now to Fig. 1OC, in a method 1001 at a step 1002, the document is input, preferably in electronic format, such as HTML, Adobe PDF, Microsoft Excel, Microsoft Word, or in computer readable form such as XML or other document exchange format and preferably input into a document database 1030. The software of the present invention extracts all of the words or alphanumeric strings in the document in a step 1003 and tests that it is a word and not simply a sequence of control codes or other information. In one embodiment of the present invention, a found word is compared to a dictionary of common words in order to suppress words that are not chemical terms, which has the effect of decreasing the size of the database and the speed of the indexing. Once the words are found in the document, a record in the index database is stored. In a preferred embodiment of the present invention the word is stored, including the address of the document whether a filename or hyperlink, the page on which the word is found, and the position of the word on the page. One method for defining the position of the term on the page is to define a rectangular area that encompasses the area of the word on the page, and to store the coordinates of the rectangle in the index record.
[00167] In a step 1004 the relevance of the extracted words or alphanumeric strings in the document as stored in the index is determined by comparing, in sequence and in combination, the extracted words or alphanumeric strings to a dictionary database of material terms. The material terms dictionary database contains at least one of the following: a unique material identification code, a preferred name of the instance of the material, and a name used for matching against a document term (Matchname). An extracted word or alphanumeric string is compared to an index of Matchnames from the
database of material terms, such as by retrieving the extracted word or alphanumeric string from a document index, discussed in more detail below. If a match occurs in a step 1005, an index record is prepared for at least one of the following: (a) found chemical, (b) document, (c) document address, (d) material code (in this case for the subset of documents), after which the record is stored in the materials index in a step 1006. As a result of this embodiment of the indexing system, a particular chemical name is indexed against any entry in a plurality of documents in the document database.
[00168] Referring to Fig. 1OB the sub-step 1004 is shown in greater detail . After the alphanumeric strings have been extracted in the step 1003, the first alphanumeric string from the document subset is extracted in a step 1035. In a step 1036, the alphanumeric string is prepared for matching, such as by converting lower case characters to upper, stripping punctuation, converting Greek letters to alphanumeric equivalents or the like. In a step 1037, the alphanumeric string is compared with a dictionary database of material terms. In a step 1038, if a match occurs, the method proceeds to the step 1039 and the matched term is added to a stored set of matching material terms, after which the combined matching terms are combined in a step 1041 and the method proceeds to the step 1044 to test if there are more strings in the document. If there are no more strings, the sub-step 1004 ends and the method 1001 proceeds to the step 1005. If there are more strings, the method returns to the step 1035 to begin a new determination of relevance.
[00169] If no match occurs in the step 1038, the method tests, in a step 1040, if the stored material terms exist. If the stored material term does exist, the method proceeds to a step 1042 where a stored matching material term is retrieved, which is accepted as a material reference and the method writes an index record in a step 1043 after which the method proceeds to the step 1044 to test if there are more strings in the document. If there are no more strings, the sub-step 1004 ends and the method 1001 proceeds to the step 1005. If there are more strings, the method returns to the step 1035 to begin a new determination of relevance. If no stored material terms exist in the step 1040, the method proceeds to the step 1044 to test if there are more strings in the document. If there are no more strings, the sub-step 1004 ends and the method 1001 proceeds to the step 1005. If there are more strings, the method returns to the step 1035 to begin a new determination of relevance.
[00170] Referring now to Fig. 1OA, the materials database or dictionary database of common material terms according to one embodiment of the present invention is illustrated at 1015 as including one or more of the following: (a) A unique material identification code or key 1016; (b) a proper chemical name 1017; (c) synonyms 1018; (d) identifiers, e.g., an EU Reference Number, an EINECS number, etc. 1019; (e) translations of chemical names 1020; (f) members of parent classes, e.g., sodium chromate is a member of the class hexavalent chromium compounds; and other material attributes.
[00171] The change document database is illustrated at 1030 as including one or more of the following: (a) A unique material identification code or key 1031, which is related to 1016; (b) a document address or filename using the Matchname of the material; (c) a page number for the occurrence of the Matchname 1033; and (d) the location on the page of the term 1034.
[00172] A master materials database is shown at 1023 and defines the relationship with a master "material" that encompasses one or more entries in the materials database 1015. A master material record has one or more of the following elements: (a) a unique master materials code or key 1024; (b) a proper master name 1025; (c) master identifiers associated with the master material 1026; (d) attributes associated with the master material 1027; (e) an identification that this is a parent class.
[00173] After the method 1001 is complete, a cross-index is generated by retrieving a matched alphanumeric string from the step 1005, matching the retrieved alphanumeric string with a matching master materials database key 1024 and cross-indexing the matching records in the document database 1030, the materials database 1015, and the master materials database 1023. In this illustration of the present invention, the resulting cross- index permits a particular occurrence of a chemical term to be related not only to all indexed documents in the document database 1030 containing the term, but to any synonym, translation, identifier or membership in a broad chemical class in the materials database 1015 or the master materials database 1023.
[00174] Referring now to Fig. 14, an embodiment of the present invention is depicted by which one of a personalized profile and search query 1401 returns a customized certification document 1407 to the user of a compilation service including certification documents. A compilation service would include but would not be limited to, for example,
an aggregator of certification documents, a service offered to the user to generate a customized certification document, and a database service supporting the generation of customized certification documents. The query 1401 is searched against one of an index of certification documents and extracted data from such 1402. Based on the received query as described above, the sections of the customized certification document are determined 1403. Content is fetched from the index 1404, as described above, associated with the personalized query 1401. The base customized certification document is created 1405. For each one of a certification document and extracted data retrieved by means of the index, each section of the customized certification document is populated 1406 with appropriate unique content from the search of the index as described above that is associated with each one of fetched certification document and extracted data. The generated customized search document is returned to the user 1407.
[00175] An embodiment of the present invention as illustrated in Fig. 14 includes a search query that may be a material and an index that includes cross-references of materials selected from a proper name, an identifier, a translation, a synonym, a member of a parent class, and any combination thereof.
[00176] A further embodiment of the present invention as illustrated in Fig. 14 includes a further selection within the one of a personalized profile and search query of a regulation, a physico-chemical property, toxicological property, end use, a material, topic, or any combination thereof.
[00177] For example, the user of a compilation service may define a personalized search profile that may include but is not limited to a topic, such as food additives, a subtopic, such as contaminants, a period of time, such as the last month, a set of jurisdictions, such as China and the U.S., and a request for the generation of a certification document type, such as an analysis of proposed regulations. In response, the customized certification document is returned with sections that correspond to the criteria received by the user. The sections are populated with content that may include but is not limited to, for example, data, an analysis and a reference to a certification document, such as one of a Chinese proposed regulation, a translation, and a function that can be executed by the recipient to retrieve one of a document, document reference, document link, compilation, summary, data, and function to perform the same.
[00178] Another example of an embodiment of the present invention includes but is not limited to a personalized search profile that may include a material, such as a product formulation, and other elements of the example above in order to return an analysis of any proposed regulations affecting the entered product formulation or substance within it.
[00179] Another example of an embodiment of the present invention includes but is not limited to a personalized search profile that may include a material, such as a product formulation, and other elements of the example above in order to return an analysis of any proposed regulations affecting the entered one of a product formulation and substance within it that may be in any language and relate to the product by cross-reference that may be at least one of a synonym, an identifier, a translation, a member of a parent class.
[00180] Another example of an embodiment of the present invention includes but is not limited to a personalized search profile that may include at least one of a food, such as an orange, a class of foods, such as citrus fruits, and other elements of a search query that may, for example, include jurisdictions, such as the European Union and the U.S., and a certification document type, such as an analysis, in order to return a customized certification document with sections defining restrictions of contaminants for the food by jurisdiction, regardless of the language of the certification documents retrieved during the search.
[00181] A further example of an embodiment of the present invention includes but is not limited to the creation of a customized certification document where the type of certification document created is, for instance, a compliance statement and the topic is, for example, food contact, and the language for the customized certification document to be generated in is, for instance, English and a product formulation is given as part of the query. Such a customized certification document may equally include an end use, such as use in beverages. Further, an example of a customized certification document may be generated based on given criteria that include a country, a regulation, a physico-chemical property, a toxicological property, an end use, a material, a topic or any combination of the above.
[00182] Embodiments of the present invention may also be practiced by a computer readable medium storing executable software code thereon for executing the indexing method and the system for validating certification documents in accordance with the
present invention, as will be appreciated by those skilled in the art. Embodiments of the present invention may also be practiced by a device, such as a personal computer or the like, having a processor, wherein the processor is responsive to software instructions; and software instructions adapted to enable the processor to execute the indexing method and the system for validating certification documents in accordance with the present invention, as will be appreciated by those skilled in the art.
[00183] Embodiments of the present invention produce an advantageous technical effect by providing a data processing system that more effectively communicates parameters of use of products in a supply chain by utilizing dynamic control statements in certification documents that may be validated by a recipient of the certification document, thereby improving the safe and compliant use of the products in the supply chain by the recipient. The present invention thereby provides a further technical effect which lends technical character to the embodied computer programs in the control of an industrial process and in processing data that represents parameters of use of physical entities through the dynamic control statements. In consequence, the present invention provides a solution to a difficult supply chain management problem by the automatic validation of certification documents.
[00184] Embodiments of the present invention have been described in terms of preferred embodiments and nonlimiting examples, however, it will be appreciated that various modifications and improvements may be made to the described embodiments and examples without departing from the scope of the invention.
Claims
1. A method for creating a customized certification document associated with a user of a compilation service including certification documents comprising the steps of: receiving at least one of a personalized profile and search query from the user; creating a customized certification document, wherein creating further comprises: dividing the certification document to be created into a plurality of sections wherein at least one of the plurality of sections contains content that is related to one or more indexed certification documents and extracted data identified in response to at least one of the personalized profile and search query; searching one or more indexed certification documents and extracted data using at least one of the personalized profile and search query provided by the user; fetching content relating to any indexed certification documents or extracted data identified in the searching step; populating the one or more of the plurality of sections with the content fetched to produce a customized certification document.
2. The method of claim 1 wherein one of the search query is associated with a material and the customized certification document created is produced by associating the search query with a cross-reference selected from a proper name, an identifier, a translation, a synonym, a member of a parent class or any combination thereof found within a certification document that is indexed by cross-referencing the search term and wherein the certification document indexed is in the same language or a different language from the search term.
3. The method of claim 1 further comprising selecting a country, a regulation, a physiochemical property, toxicological property, end use, a material, a topic, or any combination thereof within one of the personalized profile and search query to further define the customized certification document to be created.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
EP08779964.9A EP2174305A4 (en) | 2007-07-03 | 2008-07-03 | Document validation system and method |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US11/773,368 US7769712B2 (en) | 2005-12-21 | 2007-07-03 | Document validation system and method |
US11/773,368 | 2007-07-03 |
Publications (2)
Publication Number | Publication Date |
---|---|
WO2009005823A2 true WO2009005823A2 (en) | 2009-01-08 |
WO2009005823A3 WO2009005823A3 (en) | 2009-12-30 |
Family
ID=40261961
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US2008/008255 WO2009005823A2 (en) | 2007-07-03 | 2008-07-03 | Document validation system and method |
Country Status (3)
Country | Link |
---|---|
US (1) | US7769712B2 (en) |
EP (1) | EP2174305A4 (en) |
WO (1) | WO2009005823A2 (en) |
Families Citing this family (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
DE112006003518T5 (en) * | 2005-12-21 | 2009-01-29 | Decernis, Llc | System for the validation of at least part of a document |
US20100217988A1 (en) * | 2007-04-12 | 2010-08-26 | Avow Systems, Inc. | Electronic document management and delivery |
US20100076964A1 (en) * | 2007-12-18 | 2010-03-25 | Daniel Joseph Parrell | Instance-Class-Attribute Matching Web Page Ranking |
US20090202967A1 (en) * | 2008-02-13 | 2009-08-13 | Carol Fitzgerald | Computer-based evaluation tool for organizing and displaying results of dataset analysis |
US8219592B2 (en) * | 2008-02-29 | 2012-07-10 | International Business Machines Corporation | Method and system for using overlay manifests to encode differences between virtual machine images |
US7856440B2 (en) * | 2008-02-29 | 2010-12-21 | International Business Machines Corporation | Method and system for separating content identifiers from content reconstitution information in virtual machine images |
US7996414B2 (en) | 2008-02-29 | 2011-08-09 | International Business Machines Corporation | Method and system for separating file system metadata from other metadata in virtual machine image format |
US7856439B2 (en) * | 2008-02-29 | 2010-12-21 | International Business Machines Corporation | Method and system for using semantic information to improve virtual machine image management |
US9176938B1 (en) * | 2011-01-19 | 2015-11-03 | LawBox, LLC | Document referencing system |
US8484183B1 (en) | 2011-02-17 | 2013-07-09 | Ithos USA Inc. | Automated regulatory guideline management system |
US9063964B2 (en) * | 2012-01-04 | 2015-06-23 | Trustgo Mobile, Inc. | Detecting application harmful behavior and grading application risks for mobile devices |
US10068074B2 (en) | 2016-03-25 | 2018-09-04 | Credly, Inc. | Generation, management, and tracking of digital credentials |
US10033536B2 (en) | 2016-03-25 | 2018-07-24 | Credly, Inc. | Generation, management, and tracking of digital credentials |
US11341507B2 (en) | 2017-03-14 | 2022-05-24 | Avalara, Inc. | Compliance document creation, modification, and provisioning |
US20190089692A1 (en) | 2017-09-15 | 2019-03-21 | Pearson Education, Inc. | Time-based degradation of digital credentials in a digital credential platform |
US10803104B2 (en) | 2017-11-01 | 2020-10-13 | Pearson Education, Inc. | Digital credential field mapping |
Family Cites Families (35)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6507872B1 (en) | 1992-09-25 | 2003-01-14 | David Michael Geshwind | Class of methods for improving perceived efficiency of end-user interactive access of a large database such as the world-wide web via a communication network such as “The Internet” |
US6678864B1 (en) | 1992-02-25 | 2004-01-13 | Irving Tsai | Method and apparatus for linking designated portions of a received document image with an electronic address |
US5838458A (en) | 1992-02-25 | 1998-11-17 | Tsai; Irving | Method and apparatus for linking designated portions of a received document image with an electronic address |
US5495581A (en) | 1992-02-25 | 1996-02-27 | Tsai; Irving | Method and apparatus for linking a document with associated reference information using pattern matching |
US5878406A (en) | 1993-01-29 | 1999-03-02 | Noyes; Dallas B. | Method for representation of knowledge in a computer as a network database system |
US5519608A (en) | 1993-06-24 | 1996-05-21 | Xerox Corporation | Method for extracting from a text corpus answers to questions stated in natural language by using linguistic analysis and hypothesis generation |
US5615268A (en) | 1995-01-17 | 1997-03-25 | Document Authentication Systems, Inc. | System and method for electronic transmission storage and retrieval of authenticated documents |
US5708825A (en) | 1995-05-26 | 1998-01-13 | Iconovex Corporation | Automatic summary page creation and hyperlink generation |
US5638446A (en) | 1995-08-28 | 1997-06-10 | Bell Communications Research, Inc. | Method for the secure distribution of electronic files in a distributed environment |
US6272505B1 (en) | 1998-07-07 | 2001-08-07 | Carlos De La Huerga | Document modification based hyperlink limiting method and apparatus |
US6122647A (en) | 1998-05-19 | 2000-09-19 | Perspecta, Inc. | Dynamic generation of contextual links in hypertext documents |
DE69937972T2 (en) | 1998-11-19 | 2009-01-08 | Digimarc Corp., Beaverton | ID document with photo |
IL128720A (en) | 1999-02-25 | 2009-06-15 | Cidway Technologies Ltd | Method for certification of over the phone transactions |
US6636242B2 (en) | 1999-08-31 | 2003-10-21 | Accenture Llp | View configurer in a presentation services patterns environment |
US6615199B1 (en) | 1999-08-31 | 2003-09-02 | Accenture, Llp | Abstraction factory in a base services pattern environment |
US6754873B1 (en) | 1999-09-20 | 2004-06-22 | Google Inc. | Techniques for finding related hyperlinked documents using link-based analysis |
US7010742B1 (en) | 1999-09-22 | 2006-03-07 | Siemens Corporate Research, Inc. | Generalized system for automatically hyperlinking multimedia product documents |
US6785864B1 (en) | 1999-12-01 | 2004-08-31 | International Business Machines Corporation | System and method for notifying of changes in web page hyperlinked documents |
JP2001306308A (en) | 2000-04-11 | 2001-11-02 | Sap Ag | Method for defining class of data center application |
US6922776B2 (en) * | 2000-05-19 | 2005-07-26 | Networks Associates Technology, Inc. | Scalable system and method for management and notification of electronic certificate changes |
US7152047B1 (en) | 2000-05-24 | 2006-12-19 | Esecure.Biz, Inc. | System and method for production and authentication of original documents |
US20020103869A1 (en) | 2000-07-07 | 2002-08-01 | Philip Goatly | Standards development package method and system |
GB2376389A (en) | 2001-06-04 | 2002-12-11 | Hewlett Packard Co | Packaging evidence for long term validation |
WO2003014867A2 (en) * | 2001-08-03 | 2003-02-20 | John Allen Ananian | Personalized interactive digital catalog profiling |
US20030028494A1 (en) | 2001-08-06 | 2003-02-06 | King Shawn L. | Electronic document management system and method |
NO316480B1 (en) | 2001-11-15 | 2004-01-26 | Forinnova As | Method and system for textual examination and discovery |
US8176334B2 (en) | 2002-09-30 | 2012-05-08 | Guardian Data Storage, Llc | Document security system that permits external users to gain access to secured files |
US7174332B2 (en) | 2002-06-11 | 2007-02-06 | Ip. Com, Inc. | Method and apparatus for safeguarding files |
US6925599B2 (en) | 2002-10-04 | 2005-08-02 | Clinisys, Inc. | Methodology for performing validated clinical studies of pharmeceutical related products |
US7254581B2 (en) | 2002-11-13 | 2007-08-07 | Jerry Johnson | System and method for creation and maintenance of a rich content or content-centric electronic catalog |
US7454615B2 (en) * | 2003-05-08 | 2008-11-18 | At&T Intellectual Property I, L.P. | Centralized authentication system |
US20050021480A1 (en) | 2003-05-16 | 2005-01-27 | Hyperspace Communications, Inc. | Method and apparatus for creating and validating an encrypted digital receipt for third-party electronic commerce transactions |
US20050038746A1 (en) * | 2003-08-11 | 2005-02-17 | Ncr Corporation | Method of associating physical cheques with cheque image data previously captured remotely at a self-service terminal |
US6889390B1 (en) * | 2003-11-25 | 2005-05-10 | Kirby Morgan Dive Systems, Inc. | Face mask retaining system |
US20060247944A1 (en) | 2005-01-14 | 2006-11-02 | Calusinski Edward P Jr | Enabling value enhancement of reference data by employing scalable cleansing and evolutionarily tracked source data tags |
-
2007
- 2007-07-03 US US11/773,368 patent/US7769712B2/en active Active
-
2008
- 2008-07-03 WO PCT/US2008/008255 patent/WO2009005823A2/en active Application Filing
- 2008-07-03 EP EP08779964.9A patent/EP2174305A4/en not_active Withdrawn
Non-Patent Citations (1)
Title |
---|
See references of EP2174305A4 * |
Also Published As
Publication number | Publication date |
---|---|
US20080034000A1 (en) | 2008-02-07 |
EP2174305A4 (en) | 2015-01-07 |
WO2009005823A3 (en) | 2009-12-30 |
US7769712B2 (en) | 2010-08-03 |
EP2174305A2 (en) | 2010-04-14 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7769712B2 (en) | Document validation system and method | |
US8037018B2 (en) | Document validation system and method | |
US20090198541A1 (en) | Enhanced Brand Label Validation | |
US20110302171A1 (en) | Apparatus and Method for the Automatic Discovery of Control Events from the Publication of Documents | |
KR102198291B1 (en) | Method for providing product control protocol service for complying with laws and regulations | |
Rajan et al. | Towards a content agnostic computable knowledge repository for data quality assessment | |
US11436458B2 (en) | Information management system for product ingredients to allow regulatory compliance checks | |
Westenbrink et al. | EuroFIR quality approach for managing food composition data; where are we in 2014? | |
Radu et al. | Global trends and research hotspots on HACCP and modern quality management systems in the food industry | |
US20120016707A1 (en) | System and Method for Supplier and Customer Management of Technical and Regulatory Requirements in Procurement Standards | |
Dwyer et al. | Commentary: an impossible dream? Integrating dietary supplement label databases: needs, challenges, next steps | |
Manikas et al. | Design of an integrated supply chain model for supporting traceability of dairy products | |
Mayounga | Antecedents of recalls prevention: analysis and synthesis of research on product recalls | |
Li et al. | Perspective: a comprehensive evaluation of data quality in nutrient databases | |
Cho et al. | Exploring latent factors influencing the adoption of a processed food traceability system in South Korea | |
EP2377054A1 (en) | Apparatus and method for the automatic discovery of control events from the publication of documents | |
Emara et al. | Workflow for building interoperable food and nutrition security (FNS) data platforms | |
Casellas | Linked legal data: A SKOS vocabulary for the code of federal regulations | |
Uula | Study on halal food in Indonesia | |
TW201743058A (en) | A food safety Cloud system and tracking method | |
Wallace et al. | Dietary supplement regulation in the United States | |
Browne et al. | Mondeca for thesaurus, autotagging and ontology management in a public health statistics platform | |
Ireland et al. | US, Canadian, Australian, and New Zealand datasets seen through foreign eyes | |
Azzi et al. | Enriching the FIDEO ontology with food-drug interactions from online knowledge sources | |
Winters | Less May Be More: Reading into FDA's Labeling Requirements |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 08779964 Country of ref document: EP Kind code of ref document: A2 |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2008779964 Country of ref document: EP |
|
NENP | Non-entry into the national phase |
Ref country code: DE |