|Publication number||US7392237 B2|
|Application number||US 09/973,349|
|Publication date||Jun 24, 2008|
|Filing date||Oct 9, 2001|
|Priority date||Apr 26, 2001|
|Also published as||EP1253531A2, EP1253531A3, US20020161749|
|Publication number||09973349, 973349, US 7392237 B2, US 7392237B2, US-B2-7392237, US7392237 B2, US7392237B2|
|Inventors||Douglas Charles Pratt|
|Original Assignee||Siemens Medical Solutions Usa, Inc.|
|Export Citation||BiBTeX, EndNote, RefMan|
|Patent Citations (37), Non-Patent Citations (7), Referenced by (17), Classifications (8), Legal Events (5)|
|External Links: USPTO, USPTO Assignment, Espacenet|
This is a non-provisional application of provisional application serial No. 60/286,794 by D. Pratt filed Apr. 26, 2001.
This invention concerns a system for processing multiple different identifier codes associated with a single object by corresponding multiple different entities such as a manufacturer, wholesaler and retailer, for example.
It is common in commerce and industry for different entities such as companies or other organizations for example, to represent an object such as a product, service, resource or any other item of commercial significance, by different internal identifier codes. A problem occurs in integrating computer systems and transferring data between companies concerning commercial transactions involving such objects. Specifically, an identifier code of one entity (e.g., a manufacturer) is not recognized by the computer system of another entity (e.g., a wholesaler) involved in a transaction. Consider a case involving the procurement of an automobile oil filter, for example. A retail store ordering the oil filter part has a stock number. A distributor of the oil filter maintains another different stock number for the same filter. A company that brands the filter assigns a different part number and UPC (Universal Product Code) bar code. The manufacturer maintains yet another different part number. The difference in part numbers and codes used to represent the single part by the different entities involved in the distributorship chain causes significant problems in executing a transaction. A computer system of one entity in the chain needs to know the part number used to identify the object by another entity in the chain to generate purchase orders, for billing, and for other transaction records.
Some known systems address the problem by employing cross-reference mapping files embedded within individual networked applications used by the entities involved in a distribution chain. The mapping files translate (map) identifier codes between the different entities. This approach provides a costly, inflexible mapping system vulnerable to error and identifier code mismatch between mapping files. This approach is also dependent on synchronized update of the different mapping files involving use of complicated network interfaces and multiple, different file formats.
Another known system offered by Seebeyond.com and described at its web site employs a mapping system that involves a centralized mapping database and does not support access to additional remote external mapping databases thereby limiting the scope, flexibility and use of the mapping system.
A system according to the invention principles addresses the described problems and deficiencies.
A system dynamically maps (and translates) codes and identifier values of any type (e.g., identifying a product service or resource) to corresponding codes and identifiers of other entities (e.g. companies, organizations and individuals). A method for determining a specific identifier code for an object associated with a plurality of identifier codes by a corresponding plurality of entities involves receiving a first message including at least a first identifier code identifying an object. The first identifier code is extracted from the received first message and a second message is generated incorporating the extracted first identifier code. The second message is used for initiating a search of an identifier code database mapping an identifier code associated with a first entity to a corresponding identifier code associated with a second entity. A second identifier code corresponding to the first identifier code is received in response to communicating the second message for initiating a search of the identifier code database.
In a feature of the invention the second message initiates a remote procedure for mapping the first identifier code to a corresponding second identifier code.
The operation of the
The centralized mapping application and associated mapping database system of
In step 335, application 900 receives the mapped identifier code (421B) in message 860 from application 916. Interface processor application 900 in step 340 incorporates the mapped identifier code (421B) in message 724 previously received from requisitioning system application 700 to form message 765 for forwarding to Material Management system application 710.
In other embodiments, interrogated database applications unable to locate a corresponding identifier code also respond (as well as those applications that discover a corresponding mapped identifier code) with a message indicating such a search failure. Also, in another embodiment, instead of multiple database applications operating on server 40, a single server 40 database application is used to interrogate the multiple co-located databases in server 40. In this case a single message is sent to the server 40 application and a single response message is sent from server 40 (using the protocols previously described) to server 42 conveying corresponding mapped identifier codes. Further, the multiple databases operating on server 40 are advantageously updated using identifier codes received from the interface application operating on server 42 in a similar manner to that described in connection with
The server 54 interface application incorporates the received mapped identifier code in a message for forwarding to System B (as described in connection with
The server 62 interface application communicates the identifier code to the remote server 66 database access application using IP and other Internet compatible protocol. In other embodiments, different communication protocols (including non-Internet compatible protocols) may be used for communication to local or remote database access applications. The database applications operating on servers 64 and 66 and the mapping application on server 60 initiate searches of their respective databases for corresponding identifier codes (of the System A part). In this embodiment the server 62 interface application determines which database applications to communicate with and determines the order in which such databases should be interrogated to find a corresponding identifier code. However, in another embodiment the server 60 mapping application is provided with the identifier code and the mapping application determines which databases to interrogate and in which order. In this case the mapping application manages the communication of database application interrogation messages. The remote and local databases may be interrogated sequentially until a corresponding mapped identifier code is successfully determined or the databases may be interrogated in parallel, for example.
The interrogated database applications on servers 60, 64 and 66 individually prepare and communicate a response message including any discovered requested mapped identifier code. The response message from the mapping application on server 60 is communicated in XML and SOAP format using HTTP protocol back to the server 62 interface application. The response message from the database application on server 64 is communicated in XML and SOAP format using HTTP protocol back to the server 62-interface application via the server 60 mapping application. The response message from the database application on server 66 is communicated using IP and other Internet compatible protocols directly back to the server 62 interface application. In an alternative embodiment the response messages may be communicated using different protocols directly to the server 62 interface application or to the server 62 interface application via the server 60 mapping application.
The server 62 interface application incorporates the received mapped identifier code in a message for forwarding to System B (as described in connection with
The architectures and processes presented in
Extensible Markup Language (XML)—an Internet standard maintained by the World Wide Web Consortium used to encode structured data passed between computer systems.
Simple Object Access Protocol (SOAP)—an Internet standard submitted to the World Wide Web Consortium for using XML to invoke remote procedure calls.
Hypertext transfer protocol (HTTP)—this is the public Internet standard maintained by the Internet Engineering Task Force for networking computer systems.
|Cited Patent||Filing date||Publication date||Applicant||Title|
|US5712989 *||Apr 2, 1993||Jan 27, 1998||Fisher Scientific Company||Just-in-time requisition and inventory management system|
|US5715453 *||May 31, 1996||Feb 3, 1998||International Business Machines Corporation||Web server mechanism for processing function calls for dynamic data queries in a web page|
|US5724575 *||Jul 1, 1996||Mar 3, 1998||Actamed Corp.||Method and system for object-based relational distributed databases|
|US5740425 *||Sep 26, 1995||Apr 14, 1998||Povilus; David S.||Data structure and method for publishing electronic and printed product catalogs|
|US5913210 *||Mar 27, 1998||Jun 15, 1999||Call; Charles G.||Methods and apparatus for disseminating product information via the internet|
|US5987472||Mar 31, 1997||Nov 16, 1999||Combustion Engineering, Inc.||System and method for handling database cross references|
|US6055516 *||Jan 20, 1999||Apr 25, 2000||Procurenet, Inc.||Electronic sourcing system|
|US6058375 *||Oct 20, 1997||May 2, 2000||Samsung Electronics Co., Ltd.||Accounting processor and method for automated management control system|
|US6112209||Jun 17, 1998||Aug 29, 2000||Gusack; Mark David||Associative database model for electronic-based informational assemblies|
|US6154738 *||May 21, 1999||Nov 28, 2000||Call; Charles Gainor||Methods and apparatus for disseminating product information via the internet using universal product codes|
|US6301584 *||Aug 21, 1998||Oct 9, 2001||Home Information Services, Inc.||System and method for retrieving entities and integrating data|
|US6418441 *||Jul 24, 2000||Jul 9, 2002||Charles G. Call||Methods and apparatus for disseminating product information via the internet using universal product codes|
|US6430541 *||Apr 28, 2000||Aug 6, 2002||International Business Machines Corporation||Managing inventory purchases|
|US6430554 *||Jan 25, 2000||Aug 6, 2002||Barpoint.Com, Inc.||Interactive system for investigating products on a network|
|US6510434 *||Dec 29, 1999||Jan 21, 2003||Bellsouth Intellectual Property Corporation||System and method for retrieving information from a database using an index of XML tags and metafiles|
|US6510989 *||Jan 4, 2000||Jan 28, 2003||International Business Machines Corporation||Price check assistant|
|US6535874 *||Mar 16, 2001||Mar 18, 2003||International Business Machines Corporation||Technique for providing a universal query for multiple different databases|
|US6542933 *||Apr 5, 2000||Apr 1, 2003||Neomedia Technologies, Inc.||System and method of using machine-readable or human-readable linkage codes for accessing networked data resources|
|US6578030 *||Jun 30, 2000||Jun 10, 2003||Requisite Technology Inc.||Method and apparatus for mapping one catalog into another catalog|
|US6708161 *||Dec 22, 2000||Mar 16, 2004||I2 Technologies Us, Inc.||System and method for selective database indexing|
|US6775660 *||Feb 20, 2001||Aug 10, 2004||International Business Machines Corporation||User-oriented method and system for database query|
|US6785671 *||Mar 17, 2000||Aug 31, 2004||Amazon.Com, Inc.||System and method for locating web-based product offerings|
|US7062509 *||May 22, 2000||Jun 13, 2006||Instill Corporation||System and method for product data standardization|
|US20010029492 *||Mar 22, 2001||Oct 11, 2001||Nec Corporation||Electronic transaction method and apparatus|
|US20020059107 *||Jun 8, 2001||May 16, 2002||Hans-Linhard Reich||Method and system for automated transaction compliance processing|
|US20020059204 *||Jul 10, 2001||May 16, 2002||Harris Larry R.||Distributed search system and method|
|US20020099622 *||Mar 14, 2002||Jul 25, 2002||Langhammer Michael Jay||Merchant-affiliated direct wholesale marketing and fulfillment system|
|US20020107861 *||Dec 7, 2000||Aug 8, 2002||Kerry Clendinning||System and method for collecting, associating, normalizing and presenting product and vendor information on a distributed network|
|US20020111870 *||Dec 22, 2000||Aug 15, 2002||I2 Technologies, Inc.||System and method for identifying a product|
|US20020161745 *||May 6, 2002||Oct 31, 2002||Call Charles Gainor||Methods and apparatus for using the internet domain name system to disseminate product information|
|US20030115129 *||Sep 16, 2002||Jun 19, 2003||Feaver Donald P.||E-commerce transaction facilitation system and method|
|US20030177111 *||Jan 21, 2003||Sep 18, 2003||Searchcraft Corporation||Method for searching from a plurality of data sources|
|US20040059728 *||Sep 23, 2003||Mar 25, 2004||Todd Miller||Method and system for retrieving search results from multiple disparate databases|
|EP0722140A1||Jul 12, 1995||Jul 17, 1996||Jr East Japan Information Systems Co., Ltd.||Method of writing program for specific business|
|GB2320111A||Title not available|
|WO1998032289A2 *||Jan 16, 1998||Jul 23, 1998||The Board Of Regents Of The University Of Washington||Method and apparatus for accessing on-line stores|
|WO2001006357A1||Jul 26, 1999||Jan 25, 2001||American Management Systems, Incorporated||Meta-language for c++ business applications|
|1||*||"Simple Object Access Protocol (SOAP) 1.1" (C) May 8, 2000 W3C et al. http://www.w3.org/TR/2000/NOTE-SOAP-20000508/.|
|2||*||"SOAP for Java" (C) Apr. 28, 2000 IBM. http://www.alphaworks.ibm.com/tech/soap4j/.|
|3||*||"SQLData SOAP Server" (C) Jan. 25, 2001 SQLData Systems Inc. http://web.archive.org/web/20010202090100/http://sqldata.com/Soap.htm.|
|4||e*Index(TM) Global Identifier-In Depth See Beyond-Products.|
|5||e*Index(TM) Global Identifier-Know Your Customer See Beyond-Products.|
|6||eBusiness Integration-It's not just B2B See Beyond-Products.|
|7||*||U.S. Appl. No. 60/221,546, filed on Jul. 28, 2000.|
|Citing Patent||Filing date||Publication date||Applicant||Title|
|US8156505||Jan 27, 2005||Apr 10, 2012||Infosys Limited||Protocol processing including converting messages between SOAP and application specific formats|
|US8621427 *||Jun 30, 2010||Dec 31, 2013||International Business Machines Corporation||Code modification of rule-based implementations|
|US8660247 *||Sep 18, 2009||Feb 25, 2014||Wendell Brown||Method and apparatus for content presentation in association with a telephone call|
|US8678272||Sep 26, 2012||Mar 25, 2014||Catalina Marketing Corporation||Dimensional translator|
|US8996749||May 25, 2012||Mar 31, 2015||Candi Controls, Inc.||Achieving a uniform device abstraction layer|
|US9076121||Mar 24, 2014||Jul 7, 2015||Catalina Marketing Corporation||Dimensional translator|
|US9092246 *||Mar 7, 2012||Jul 28, 2015||International Business Machines Corporation||Code modification of rule-based implementations|
|US9148470||May 25, 2012||Sep 29, 2015||Candi Control, Inc.||Targeting delivery data|
|US9231997||May 25, 2012||Jan 5, 2016||Candi Controls, Inc.||Discovering device drivers within a domain of a premises|
|US9237183||May 25, 2012||Jan 12, 2016||Candi Controls, Inc.||Updating a domain based on device configuration within the domain and remote of the domain|
|US9471933||Jul 6, 2015||Oct 18, 2016||Catalina Marketing Corporation||Dimensional translator|
|US9729607||Nov 25, 2015||Aug 8, 2017||Candi Controls, Inc.||Discovering device drivers within a domain|
|US20050144137 *||Oct 13, 2004||Jun 30, 2005||Kumar B. V.||Protocol processing device and method|
|US20080098405 *||Jan 27, 2005||Apr 24, 2008||Infosys Technologies Limited||Protocol Processing Device And Method|
|US20100049693 *||Aug 25, 2008||Feb 25, 2010||Alcatel-Lucent||System and method of cache based xml publish/subscribe|
|US20120167070 *||Mar 7, 2012||Jun 28, 2012||International Business Machines Corporation||Code modification of rule-based implementations|
|US20130173290 *||Dec 30, 2011||Jul 4, 2013||Cerner Innovation, Inc.||Leveraging centralized mapping between organizations|
|U.S. Classification||1/1, 707/E17.006, 707/999.003|
|International Classification||G06F17/30, G06F7/10|
|Cooperative Classification||Y10S707/99933, G06F17/30569|
|Oct 9, 2001||AS||Assignment|
Owner name: SIEMENS MEDICAL SOLUTIONS HEALTH SERVICES CORPORAT
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:PRATT, DOUGLAS CHARLES;REEL/FRAME:012257/0009
Effective date: 20011003
|May 13, 2008||AS||Assignment|
Owner name: SIEMENS MEDICAL SOLUTIONS USA INC., PENNSYLVANIA
Free format text: MERGER;ASSIGNOR:SIEMENS MEDICAL SOLUTIONS HEALTH SERVICES CORPORATION;REEL/FRAME:020942/0282
Effective date: 20061221
|Nov 15, 2011||FPAY||Fee payment|
Year of fee payment: 4
|Feb 6, 2015||AS||Assignment|
Owner name: CERNER INNOVATION, INC., KANSAS
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:SIEMENS MEDICAL SOLUTIONS USA, INC.;REEL/FRAME:034914/0523
Effective date: 20150202
|Dec 24, 2015||FPAY||Fee payment|
Year of fee payment: 8