US20080059221A1 - Managing Product Information - Google Patents

Managing Product Information Download PDF

Info

Publication number
US20080059221A1
US20080059221A1 US11/856,523 US85652307A US2008059221A1 US 20080059221 A1 US20080059221 A1 US 20080059221A1 US 85652307 A US85652307 A US 85652307A US 2008059221 A1 US2008059221 A1 US 2008059221A1
Authority
US
United States
Prior art keywords
product information
product
chemical
database
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Abandoned
Application number
US11/856,523
Inventor
Louis CULOT
Mark KNELL
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
PerkinElmer Informatics Inc
Original Assignee
CambridgeSoft Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by CambridgeSoft Corp filed Critical CambridgeSoft Corp
Priority to US11/856,523 priority Critical patent/US20080059221A1/en
Publication of US20080059221A1 publication Critical patent/US20080059221A1/en
Assigned to CAMBRIDGESOFT CORPORATION reassignment CAMBRIDGESOFT CORPORATION ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: KNELL, MARK C., CULOT, LOUIS J.
Abandoned legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q30/00Commerce
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0281Customer communication at a business location, e.g. providing product or service information, consulting
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0603Catalogue ordering
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching

Definitions

  • This application relates to managing product information.
  • a product that is specified by a customer is sometimes not available, at least not within a time period specified by the customer.
  • the customer may be interested in determining the availability of an acceptable substitute for the specified product.
  • determining the acceptability of candidate substitutes can present a significant challenge, particularly if information that is necessary to the acceptability determination is unavailable or incomprehensible to the person who is in charge of acquiring the acceptable substitute.
  • a scientist may specify a research chemical product by brand name to a purchasing agent.
  • the purchasing agent may not be able to find a substitute that is acceptable to the scientist without involving the scientist in a time consuming trial and error exercise that reduces the productivity of the purchasing agent and the scientist.
  • the research chemical is available in different grades or purities from different manufacturers, and in different containers, it may be difficult to determine, from the way in which the scientist originally specified the research chemical, whether a candidate substitute has characteristics that are suitable for the purpose for which the specified product is sought.
  • the specification may include a Chemical Abstracts Service registry number (“CAS number”) number, which identifies a substance.
  • CAS number Chemical Abstracts Service registry number
  • a standardized products database is derived from product information that is provided in different formats in multiple electronic catalogs from multiple sources.
  • the product information is standardized and is linked in the database to allow an end user to determine a set of differently sourced products that meet a set of criteria, such as substance and package criteria.
  • a compact, standardized, descriptive product identifier is derived from the product information in the catalogs or the database.
  • a database of research chemical products can be provided that allows an end user to produce reports listing chemical products of the same substance from different suppliers.
  • Product information from different sources can be consolidated in an effective way with little input from an end user.
  • Products that are known by different names, such as some chemical substances, can be found by searching under one or other subset of the names.
  • Shopping efficiency can be increased by allowing an end user to view characteristics of different suppliers' chemical products side by side, and by allowing indications of important characteristics of a desired chemical product to be communicated to a purchasing agent or a seller unintrusively in a compact, universal format that can be interpreted accurately by a computer.
  • a quality category to which a product belongs may be determined by reference to an identification number for the product.
  • FIGS. 1 and 3 - 4 are block diagrams of computer-based systems.
  • FIGS. 2 and 6 are flow diagrams of computer-based procedures.
  • FIGS. 5, 7 , 8 , 12 and 13 A- 13 B are illustrations of computer data.
  • FIGS. 9-11 are illustrations of output produced by software.
  • FIG. 1 illustrates an information analyzing system 10 by which a standardized products database 12 is derived from multiple, differently organized electronic catalogs of product information 14 A- 14 C.
  • the standardized products database stores information about products' characteristics in a uniform way so that it may be readily determined which products have similar characteristics, which can facilitate finding a product that is an acceptable substitute for another product for a particular purpose.
  • differently organized electronic catalogs are acquired in the form of respective spreadsheet files 20 A, 20 B having product information organized in respective rows of products 22 A- 22 H, 24 A- 24 H and columns of product characteristics 26 A- 26 E, 28 A- 28 E (step 1010 ).
  • One or more of the columns are mapped to one or more tables 30 A- 30 E of a standardized products database 32 (step 1020 ).
  • Information in one or more of the mapped columns is analyzed for standardization (step 1030 ).
  • the tables are populated with information derived from the mapped columns (step 1040 ).
  • FIG. 4 illustrates a specific embodiment 40 of the standardized products database, in which tables are organized as follows.
  • a substances table 42 and a products table 44 include a substance entry (e.g., entry 46 ) and a product entry (e.g., entry 48 ), respectively, for each chemical substance and individual product, respectively, recorded in the database.
  • substance entries are linked to product entries in a “one to many” relationship, signified by an arrow from the products table to the substances table in FIG. 4 . With this one to many relationship, a single substance entry may be linked to multiple product entries, but a single product entry is linked to only one substance entry.
  • the substances table may have a single entry for salt, which entry is linked to multiple entries in the products table, for salt products in different containers and from different manufacturers.
  • the suppliers table records identities of product suppliers such as chemical companies.
  • the synonyms table records different names such as “salt” and “sodium chloride” for the same substance.
  • the physical properties table records physical properties such as melting and boiling points for products.
  • the packages table records different packages such as 10 milliliter bottles and 20 gallon barrels in which products may be provided.
  • the structures table records information regarding structural images for substances.
  • FIG. 12 illustrates a specific example of a relationship table for a standardized products database.
  • FIGS. 13A-13B list database fields of the specific example and demonstrate data types and sample contents of the database fields.
  • a product entry corresponding to a product that is associated with a particular structural representation in a supplier's catalog may also be linked to an entry in the structures table for that representation so that a report derived from the product entry can identify the representation as having originated in the catalog.
  • a chemical substance has only one set of physical properties
  • the properties may be expressed differently in different suppliers' catalogs.
  • entries in the physical properties table are linked to entries in the products table, not to entries in the substances table. Accordingly, a report derived from a product entry can describe the physical properties for the corresponding product as the physical properties were expressed in the catalog.
  • the combined spreadsheet file is created by determining, for each row in the first spreadsheet file, the row in the other spreadsheet file that pertains to the same product, and creating a new row having columns that include information from both rows.
  • two sets of product information may be determined to pertain to the same product if a comparison of information in designated product identification portions of each set indicates a match.
  • one spreadsheet file may include information about characteristics for one category of products, such as reagents, and another spreadsheet may include information about characteristics for another category of products, such as aromatics.
  • the combined spreadsheet file may be created by concatenating the sets of rows of the spreadsheets.
  • FIG. 5 illustrates an example 60 of a row of a catalog spreadsheet file.
  • An item number “22” is included in a catalog item number column 62
  • a product name “Baking soda, bakery grade” is included in a product name column 64
  • a chemical name “sodium bicarbonate” is included in a chemical name column 66
  • a CAS number “Z9999999” is included in a CAS number column 68
  • a supplier number “319” is included in a supplier column 70
  • a package type number “555” for a 10 milliliter bottle is included in a package type column 72
  • a structure pointer is included in a structure column 74
  • a price value “7.20” is included in a price column 76 .
  • the spreadsheet file may not include a supplier column, and the supplier number may be acquired by searching the spreadsheet file for an identification of the supplier, such as the supplier's name in a heading, or by prompting the end user as described below in connection with selecting sources.
  • information from the row of example 60 is processed according to procedure 2000 ( FIG. 6 ).
  • An end-user is prompted, by use of an input form such as form 80 of FIG. 8 , to select columns as sources for the tables of the database (step 2010 ).
  • the catalog item number column is a suitable source for the products table.
  • the CAS number column is a suitable source for the substances table.
  • the supplier column is a suitable source for the suppliers table.
  • the package type column is a suitable source for the packages table.
  • the structure column is a suitable source for the structures table.
  • the product name, chemical name, and CAS number columns are suitable sources for the synonyms table. If a price table stores a product's price, the price column is a suitable source for the price table.
  • the catalog spreadsheet file includes physical property information (e.g., in one or more physical properties columns or in other columns), the location of such information is a suitable source for the physical properties table.
  • step 2020 It is determined whether the products table has an existing entry for the product in the row (step 2020 ). Such a determination may be accomplished by searching the products table and the suppliers table to determine whether the products table has an existing entry that has the same item number as the product and is linked to an existing entry in the suppliers table that has the same supplier number as the product. If the products table does have an existing entry for the product, the existing entry is updated as necessary with the information in the row, e.g., by adding the latest price, or by linking the existing entry to a new structures table entry that includes the row's structure pointer (step 2030 ).
  • step 2040 it is determined whether the database already has one or more existing entries for the substance indicated in the row (step 2040 ). Such a determination may be made by searching the substances table and the synonyms table to determine whether either table has an existing entry that matches the CAS number, product name, or chemical name provided in the row, and by searching the structures table for an existing pointer to a structure that matches the structure referenced by the structure pointer in the row. Structure matching is performed by software such as ChemFinder® of CambridgeSoft Corporation, Cambridge, Mass.
  • a new entry is added to the substances table, and serves as an existing substances table entry for the remainder of procedure 2000 (step 2050 ).
  • the new substances table entry includes CAS number “Z9999999”.
  • the CAS number for the new entry may be acquired by submitting the structure pointer to software such as the ChemFinder® software referenced above.
  • Information in the row is added to the database in accordance with the source selections provided by the end-user (step 2060 ).
  • a new entry that includes item number “22” is added to the products table and is linked to the existing substances table entry.
  • entries in the synonyms table that include product name “Baking soda, bakery grade”, chemical name “sodium bicarbonate”, and the CAS number are added if such entries do not exist already. These entries are linked to the existing substances table entry.
  • An entry in the structures table that includes the row's structure pointer is added if such an entry does not exist already, and is linked to the existing substances table entry.
  • entries in the suppliers table and packages table that include supplier number “319” and package type number “555”, price value “7.20”, respectively, are added if such entries do not exist already, and are linked to the new products table entry.
  • the use of an erroneous CAS number may result in a single substances table entry being linked to products that in fact are for two different substances.
  • the information may be evaluated. For example, if the CAS number provided in the row conforms to a conventional format in which the CAS number is divided by “-” characters into three sections, the rightmost section is interpreted according to the convention as a checksum, and the checksum is tested against the rest of the CAS number. If the test of the CAS number indicates a problem, the row may be treated as lacking a CAS number.
  • the database allows an end user such as a purchasing agent to search for products by reference to any information in any of the tables.
  • the end user can cause a report to be derived from the database that lists a specific product, or all of the recorded products for any of the recorded suppliers or for any of the recorded substances, together with pertinent chemical structure images.
  • FIGS. 9 and 10 illustrate examples of initiating searches by text and structure, respectively.
  • FIG. 11 illustrates an example of results of the search of FIG. 9 .
  • the database allows an end user to determine whether any of the recorded products is an acceptable substitute for specified product, e.g., due to a similar price or the same package type.
  • a spreadsheet file is compliant with Microsoft Excel
  • execution of a database emulation feature of an instance of Microsoft Excel may be initiated so that the information in the spreadsheet file can be accessed much as database information is accessed.
  • each row of the spreadsheet is interpreted as a record and the column entries are interpreted as fields of the record.
  • An end user such as a scientist who is in search of a particular substance may start with a listing derived from the substances table, and then may produce a report indicating suppliers that supply one of the substances in the listing, and then may produce a report showing products by one of the suppliers of the substance.
  • FIG. 8 illustrates a user interface that allow an end user to interact with the spreadsheet and the database.
  • a product identifier such as number 100 ( FIG. 7 ) may be derived by categorizing products recorded in the database into sets. With reference to FIG. 7 , an ACX number for a product has sections that are now described.
  • a class code section 102 indicates the class of substance of the product (e.g., common research chemical).
  • a substance code section 104 identifies a specific substance (e.g., sodium bicarbonate) within the class.
  • a quality code section 106 indicates a level of quality (e.g., 99% pure) of the product.
  • a package code section 108 indicates, in subsections 110 A, 110 B, 110 C, a number of containers included in the product (e.g., four containers in a multipack), a number of units of volume of each container, and the unit of volume (e.g., liter) used, respectively.
  • a source code section 112 identifies the source (e.g., manufacturer) of the product.
  • the quality code, package code, and source code sections provide information that is not supplied by a CAS number, which identifies a substance only.
  • the ACX number is arranged so that, in at least some cases, the sections are in decreasing left to right order of importance to the consumer, particularly a research scientist.
  • the research scientist may need a particular chemical substance for a chemical reaction, and may need the substance to have at least a certain purity level so that the chemical reaction is not rendered ineffective by impurities.
  • the research scientist may desire a particular amount (i.e., volume) of the research chemical, but can accept a larger amount (provided that the excess can be discarded) and may be able to make use of a smaller amount, by reducing proportionately the amounts of other substances to be used in the reaction.
  • the research scientist may not have a significant concern regarding the identity of the supplier or manufacturer.
  • a specific implementation has the following characteristics. Substances and suppliers that are recorded in the database are assigned respective substance and source codes sequentially. Products are categorized into multiple quality categories, with each category assigned a respective quality code. The categorization may be accomplished by acquiring quality description information from the product names in the database tables (e.g., “bakery grade” from a product name “baking soda, bakery grade”, or “98% purity” from “sodium bicarbonate, 98% purity”) and analyzing the quality description information to determine the appropriate category for each product.
  • quality description information from the product names in the database tables (e.g., “bakery grade” from a product name “baking soda, bakery grade”, or “98% purity” from “sodium bicarbonate, 98% purity”)
  • the quality description information may be acquired from spreadsheet rows, particularly the product name column, as the information in the rows is being copied to the database.
  • Example quality categories include “reagent grade”, “assay grade”, “HPLC grade”, and ranges of purities such as 90% to 93%.
  • Quality description information may be normalized to a common standard, so that, for example, a quantity value of “1 liter” is normalized to “1000 ml”.
  • Numerical quality information may be rounded, so that, for example, a purity value of 95.3% may be rounded to 95%.
  • textual quality information may be converted to numerical quality information, so that, for example, “reagent grade” is converted to a purity range of 99% to 100%.
  • Quality categories may be arranged to overlap, so that a wide range quality category may be specified to indicate the acceptability of any product that belongs to a narrow range category that falls within the wide range quality category.
  • test tubes may be described in terms of quality (e.g., “plastic”, “rubber”, or “glass”, or a value indicating a level of resistance to reacting with the contents), number of items in the product (e.g., 24 test tubes to a box), volume of each test tube, and the unit of volume used, as described above.
  • a physical mixture may be described by an ACX number or an appropriate adaptation.
  • a particular toothpaste product may have an ACX number that may be used to refer to a set of other ACX numbers representing products that make up the ingredients of the toothpaste product.
  • a variation of the ACX number format may be used to indicate a research chemical's characteristics with respect to cross reactions. Such a variation may be particularly useful with medical or pharmaceutical substances. For example, a first topical substance may react with a second topical substance to create a third substance that is harmful to a patient. In such a case, tracking the chemical's cross-reactions can help to avoid causing problems.
  • An ACX number may be used in any situation in which the application of a compact, meaningful description of a product would be advantageous.
  • a research chemical product may be labeled with the ACX number so that a research scientist using the product can specify the product by the ACX number.
  • a purchasing agent is thereby provided with information that, in many cases, is sufficient by itself to allow the purchasing agent to find an acceptable substitute for the specified product, because any product having an ACX number that precisely matches all but the source code section of the specified ACX number is highly likely to serve the needs of the research scientist.
  • any product having an ACX number that precisely matches all but the source code and package code sections of the specified ACX number is highly likely to serve the needs of the research scientist, albeit possibly with some adjustments to account for quantity and package style differences.
  • An ACX number may be used in an electronic commerce environment so that a computer programmed to compare ACX numbers can readily identify a research chemical product or other product that is an acceptable substitute for a specified product, and report such identifications to an end-user.
  • each product recorded in the standardized products database described above may be assigned a respective ACX number, which may be recorded in the products table. In such a case, whenever a recorded product is listed, the corresponding ACX number may be displayed to facilitate an end-user's search for acceptable substitutes.
  • An on-line registration process may be provided so that a new product may be assigned an ACX and recorded in the standardized products database.
  • a Web page may be provided that accepts product information, perhaps including addresses of relevant on-line Web pages or other information.
  • the ACX number may be determined by analyzing the product information to determine, among other things, whether the database has an existing entry and therefore an existing substance code for the substance of the product. After being determined, the ACX number may be reported by electronic mail to the initiator (e.g., end user) of the registration of the product.
  • ACX numbers may also be used to track products such as chemicals throughout an organization, including in inventory and in recording reactions in reactions notebooks or databases.
  • ACX numbers can be indexed by ACX number so that, for example, documents that refer to a particular product can be reliably listed and retrieved.
  • ACX numbers can be embedded and linked so that selecting the ACX numbers, e.g., with mouse clicks, causes the display of information that is relevant to the product or to a feature of the product, such as the substance of the product.
  • the technique is implemented in computer programs executing on one or more programmable computers, such as a personal computer running or able to run an operating system such as Unix, Linux, Microsoft Windows 95, 98, 2000, or NT, or MacIntosh OS, that each include a processor, a storage medium readable by the processor (including volatile and non-volatile memory and/or storage elements), at least one input device such as a keyboard, and at least one output device.
  • Program code is applied to data entered using the input device to perform the technique described above and to generate output information.
  • the output information is applied to one or more output devices such as a display screen of the computer.
  • each program is implemented in a high level procedural or object-oriented programming language such as Perl, C, C++, or Java to communicate with a computer system.
  • a high level procedural or object-oriented programming language such as Perl, C, C++, or Java
  • the programs can be implemented in assembly or machine language, if desired.
  • the language may be a compiled or interpreted language.
  • each such computer program is stored on a storage medium or device, such as ROM or optical or magnetic disc, that is readable by a general or special purpose programmable computer for configuring and operating the computer when the storage medium or device is read by the computer to perform the procedures described in this document.
  • the system may also be considered to be implemented as a computer-readable storage medium, configured with a computer program, where the storage medium so configured causes a computer to operate in a specific and predefined manner.
  • the columns that are to serve as sources for the tables may be selected fully or partially automatically, perhaps by a process that analyzes the contents of column headers to determine the type of information that is provided in the column.
  • the ACX number may be provided in a form that is particularly suitable for detection or interpretation by a computer, such as in a bar code format or encoded on a magnetic strip.

Abstract

A set of product information is acquired that describes a first chemical product that is suitable for a particular use. A second chemical product that is suitable for the particular use is determined from the set of product information and a database of chemical product information. It is determined, from a set of product information that describes a chemical product and from a database of chemical product information, that multiple names refer to the same chemical substance. It is determined, based on product information acquired from an electronic catalog, whether a database includes information for a chemical substance that is described in the product information. Based on the determination, at least a portion of the product information is added to the database.

Description

    BACKGROUND OF THE INVENTION
  • This application relates to managing product information.
  • A product that is specified by a customer is sometimes not available, at least not within a time period specified by the customer. As a result, the customer may be interested in determining the availability of an acceptable substitute for the specified product. However, determining the acceptability of candidate substitutes can present a significant challenge, particularly if information that is necessary to the acceptability determination is unavailable or incomprehensible to the person who is in charge of acquiring the acceptable substitute.
  • For example, in an organization that uses research chemicals, a scientist may specify a research chemical product by brand name to a purchasing agent. In such a case, if the specified brand name product is not available, the purchasing agent may not be able to find a substitute that is acceptable to the scientist without involving the scientist in a time consuming trial and error exercise that reduces the productivity of the purchasing agent and the scientist. In particular, if the research chemical is available in different grades or purities from different manufacturers, and in different containers, it may be difficult to determine, from the way in which the scientist originally specified the research chemical, whether a candidate substitute has characteristics that are suitable for the purpose for which the specified product is sought.
  • In a case in which the specified product is a research chemical, the specification may include a Chemical Abstracts Service registry number (“CAS number”) number, which identifies a substance.
  • SUMMARY OF THE INVENTION
  • Methods and systems are provided for managing product information. A standardized products database is derived from product information that is provided in different formats in multiple electronic catalogs from multiple sources. The product information is standardized and is linked in the database to allow an end user to determine a set of differently sourced products that meet a set of criteria, such as substance and package criteria. A compact, standardized, descriptive product identifier is derived from the product information in the catalogs or the database.
  • Different aspects of the invention allow one or more of the following. A database of research chemical products can be provided that allows an end user to produce reports listing chemical products of the same substance from different suppliers. Product information from different sources can be consolidated in an effective way with little input from an end user. Products that are known by different names, such as some chemical substances, can be found by searching under one or other subset of the names. Shopping efficiency can be increased by allowing an end user to view characteristics of different suppliers' chemical products side by side, and by allowing indications of important characteristics of a desired chemical product to be communicated to a purchasing agent or a seller unintrusively in a compact, universal format that can be interpreted accurately by a computer. A quality category to which a product belongs may be determined by reference to an identification number for the product.
  • Other features and advantages will become apparent from the following description, including the drawings, and from the claims.
  • BRIEF DESCRIPTION OF THE DRAWINGS
  • FIGS. 1 and 3-4 are block diagrams of computer-based systems.
  • FIGS. 2 and 6 are flow diagrams of computer-based procedures.
  • FIGS. 5, 7, 8, 12 and 13A-13B are illustrations of computer data.
  • FIGS. 9-11 are illustrations of output produced by software.
  • DETAILED DESCRIPTION
  • FIG. 1 illustrates an information analyzing system 10 by which a standardized products database 12 is derived from multiple, differently organized electronic catalogs of product information 14A-14C. The standardized products database stores information about products' characteristics in a uniform way so that it may be readily determined which products have similar characteristics, which can facilitate finding a product that is an acceptable substitute for another product for a particular purpose.
  • With respect to procedure 1000 (FIG. 2), in a specific implementation (FIG. 3), differently organized electronic catalogs are acquired in the form of respective spreadsheet files 20A, 20B having product information organized in respective rows of products 22A-22H, 24A-24H and columns of product characteristics 26A-26E, 28A-28E (step 1010). One or more of the columns are mapped to one or more tables 30A-30E of a standardized products database 32 (step 1020). Information in one or more of the mapped columns is analyzed for standardization (step 1030). The tables are populated with information derived from the mapped columns (step 1040).
  • FIG. 4 illustrates a specific embodiment 40 of the standardized products database, in which tables are organized as follows. A substances table 42 and a products table 44 include a substance entry (e.g., entry 46) and a product entry (e.g., entry 48), respectively, for each chemical substance and individual product, respectively, recorded in the database. In embodiment 40, substance entries are linked to product entries in a “one to many” relationship, signified by an arrow from the products table to the substances table in FIG. 4. With this one to many relationship, a single substance entry may be linked to multiple product entries, but a single product entry is linked to only one substance entry. For example, the substances table may have a single entry for salt, which entry is linked to multiple entries in the products table, for salt products in different containers and from different manufacturers.
  • One to many relationships are also provided between a suppliers table 50 and products table 44, between substances table 42 and a synonyms table 52, between products table 44 and a physical properties table 54, between the products table and a packages table 56, and between substances table 42 and a structures table 58. The suppliers table records identities of product suppliers such as chemical companies. The synonyms table records different names such as “salt” and “sodium chloride” for the same substance. The physical properties table records physical properties such as melting and boiling points for products. The packages table records different packages such as 10 milliliter bottles and 20 gallon barrels in which products may be provided. The structures table records information regarding structural images for substances.
  • FIG. 12 illustrates a specific example of a relationship table for a standardized products database. FIGS. 13A-13B list database fields of the specific example and demonstrate data types and sample contents of the database fields.
  • Although a chemical substance has only one chemical structure, the structure can be presented in different views, from different angles, and with emphasis on different features of the structure. A product entry corresponding to a product that is associated with a particular structural representation in a supplier's catalog may also be linked to an entry in the structures table for that representation so that a report derived from the product entry can identify the representation as having originated in the catalog.
  • Similarly, although a chemical substance has only one set of physical properties, the properties may be expressed differently in different suppliers' catalogs. Thus, in the specific implementation described above, to avoid associating one supplier's product with another supplier's expression of the physical properties for the corresponding substance, entries in the physical properties table are linked to entries in the products table, not to entries in the substances table. Accordingly, a report derived from a product entry can describe the physical properties for the corresponding product as the physical properties were expressed in the catalog.
  • In at least some cases, it may be advantageous to combine multiple catalog spreadsheet files into one catalog spreadsheet file that is used to supply information to the database. For example, a supplier may provide one spreadsheet that provides information about some characteristics for certain products and another spreadsheet that provides information about other characteristics for the same products. In such a case, the combined spreadsheet file is created by determining, for each row in the first spreadsheet file, the row in the other spreadsheet file that pertains to the same product, and creating a new row having columns that include information from both rows. As described in more detail below in connection with populating the database, two sets of product information may be determined to pertain to the same product if a comparison of information in designated product identification portions of each set indicates a match.
  • In another example, one spreadsheet file may include information about characteristics for one category of products, such as reagents, and another spreadsheet may include information about characteristics for another category of products, such as aromatics. In such a case, the combined spreadsheet file may be created by concatenating the sets of rows of the spreadsheets.
  • FIG. 5 illustrates an example 60 of a row of a catalog spreadsheet file. An item number “22” is included in a catalog item number column 62, a product name “Baking soda, bakery grade” is included in a product name column 64, a chemical name “sodium bicarbonate” is included in a chemical name column 66, a CAS number “Z9999999” is included in a CAS number column 68, a supplier number “319” is included in a supplier column 70, a package type number “555” for a 10 milliliter bottle is included in a package type column 72, a structure pointer is included in a structure column 74, and a price value “7.20” is included in a price column 76. Alternatively, in a case in which the spreadsheet file describes products from only one supplier, the spreadsheet file may not include a supplier column, and the supplier number may be acquired by searching the spreadsheet file for an identification of the supplier, such as the supplier's name in a heading, or by prompting the end user as described below in connection with selecting sources.
  • In a specific implementation, information from the row of example 60 is processed according to procedure 2000 (FIG. 6). An end-user is prompted, by use of an input form such as form 80 of FIG. 8, to select columns as sources for the tables of the database (step 2010). The catalog item number column is a suitable source for the products table. The CAS number column is a suitable source for the substances table. The supplier column is a suitable source for the suppliers table. The package type column is a suitable source for the packages table. The structure column is a suitable source for the structures table. The product name, chemical name, and CAS number columns are suitable sources for the synonyms table. If a price table stores a product's price, the price column is a suitable source for the price table. In a case in which the catalog spreadsheet file includes physical property information (e.g., in one or more physical properties columns or in other columns), the location of such information is a suitable source for the physical properties table.
  • It is determined whether the products table has an existing entry for the product in the row (step 2020). Such a determination may be accomplished by searching the products table and the suppliers table to determine whether the products table has an existing entry that has the same item number as the product and is linked to an existing entry in the suppliers table that has the same supplier number as the product. If the products table does have an existing entry for the product, the existing entry is updated as necessary with the information in the row, e.g., by adding the latest price, or by linking the existing entry to a new structures table entry that includes the row's structure pointer (step 2030).
  • Otherwise, it is determined whether the database already has one or more existing entries for the substance indicated in the row (step 2040). Such a determination may be made by searching the substances table and the synonyms table to determine whether either table has an existing entry that matches the CAS number, product name, or chemical name provided in the row, and by searching the structures table for an existing pointer to a structure that matches the structure referenced by the structure pointer in the row. Structure matching is performed by software such as ChemFinder® of CambridgeSoft Corporation, Cambridge, Mass.
  • If no such existing entries are found, a new entry is added to the substances table, and serves as an existing substances table entry for the remainder of procedure 2000 (step 2050). In the case of example 60, the new substances table entry includes CAS number “Z9999999”. In a case in which the row includes a structure pointer but does not include a CAS number, the CAS number for the new entry may be acquired by submitting the structure pointer to software such as the ChemFinder® software referenced above.
  • Information in the row is added to the database in accordance with the source selections provided by the end-user (step 2060). With respect to example 60, a new entry that includes item number “22” is added to the products table and is linked to the existing substances table entry. In addition, entries in the synonyms table that include product name “Baking soda, bakery grade”, chemical name “sodium bicarbonate”, and the CAS number are added if such entries do not exist already. These entries are linked to the existing substances table entry. An entry in the structures table that includes the row's structure pointer is added if such an entry does not exist already, and is linked to the existing substances table entry. Further, entries in the suppliers table and packages table that include supplier number “319” and package type number “555”, price value “7.20”, respectively, are added if such entries do not exist already, and are linked to the new products table entry.
  • It can be particularly advantageous to help prevent certain errors from entering the database. For example, the use of an erroneous CAS number may result in a single substances table entry being linked to products that in fact are for two different substances. During the transfer of the information from the row to the database, the information may be evaluated. For example, if the CAS number provided in the row conforms to a conventional format in which the CAS number is divided by “-” characters into three sections, the rightmost section is interpreted according to the convention as a checksum, and the checksum is tested against the rest of the CAS number. If the test of the CAS number indicates a problem, the row may be treated as lacking a CAS number.
  • The database allows an end user such as a purchasing agent to search for products by reference to any information in any of the tables. For example, the end user can cause a report to be derived from the database that lists a specific product, or all of the recorded products for any of the recorded suppliers or for any of the recorded substances, together with pertinent chemical structure images. FIGS. 9 and 10 illustrate examples of initiating searches by text and structure, respectively. FIG. 11 illustrates an example of results of the search of FIG. 9.
  • In particular, in at least some cases as described below, the database allows an end user to determine whether any of the recorded products is an acceptable substitute for specified product, e.g., due to a similar price or the same package type.
  • In at least some cases, if a spreadsheet file is compliant with Microsoft Excel, execution of a database emulation feature of an instance of Microsoft Excel may be initiated so that the information in the spreadsheet file can be accessed much as database information is accessed. According to the database emulation feature, each row of the spreadsheet is interpreted as a record and the column entries are interpreted as fields of the record.
  • An end user such as a scientist who is in search of a particular substance may start with a listing derived from the substances table, and then may produce a report indicating suppliers that supply one of the substances in the listing, and then may produce a report showing products by one of the suppliers of the substance.
  • FIG. 8 illustrates a user interface that allow an end user to interact with the spreadsheet and the database.
  • A product identifier (“ACX number”) such as number 100 (FIG. 7) may be derived by categorizing products recorded in the database into sets. With reference to FIG. 7, an ACX number for a product has sections that are now described. A class code section 102 indicates the class of substance of the product (e.g., common research chemical). A substance code section 104 identifies a specific substance (e.g., sodium bicarbonate) within the class. A quality code section 106 indicates a level of quality (e.g., 99% pure) of the product. A package code section 108 indicates, in subsections 110A, 110B, 110C, a number of containers included in the product (e.g., four containers in a multipack), a number of units of volume of each container, and the unit of volume (e.g., liter) used, respectively. A source code section 112 identifies the source (e.g., manufacturer) of the product.
  • The quality code, package code, and source code sections provide information that is not supplied by a CAS number, which identifies a substance only. The ACX number is arranged so that, in at least some cases, the sections are in decreasing left to right order of importance to the consumer, particularly a research scientist. For example, the research scientist may need a particular chemical substance for a chemical reaction, and may need the substance to have at least a certain purity level so that the chemical reaction is not rendered ineffective by impurities. In such a case, the research scientist may desire a particular amount (i.e., volume) of the research chemical, but can accept a larger amount (provided that the excess can be discarded) and may be able to make use of a smaller amount, by reducing proportionately the amounts of other substances to be used in the reaction. With respect to the source code section, the research scientist may not have a significant concern regarding the identity of the supplier or manufacturer.
  • A specific implementation has the following characteristics. Substances and suppliers that are recorded in the database are assigned respective substance and source codes sequentially. Products are categorized into multiple quality categories, with each category assigned a respective quality code. The categorization may be accomplished by acquiring quality description information from the product names in the database tables (e.g., “bakery grade” from a product name “baking soda, bakery grade”, or “98% purity” from “sodium bicarbonate, 98% purity”) and analyzing the quality description information to determine the appropriate category for each product. (Alternatively, the quality description information may be acquired from spreadsheet rows, particularly the product name column, as the information in the rows is being copied to the database.) Example quality categories include “reagent grade”, “assay grade”, “HPLC grade”, and ranges of purities such as 90% to 93%. Quality description information may be normalized to a common standard, so that, for example, a quantity value of “1 liter” is normalized to “1000 ml”.
  • Numerical quality information may rounded, so that, for example, a purity value of 95.3% may be rounded to 95%. In a specific implementation, textual quality information may be converted to numerical quality information, so that, for example, “reagent grade” is converted to a purity range of 99% to 100%. Quality categories may be arranged to overlap, so that a wide range quality category may be specified to indicate the acceptability of any product that belongs to a narrow range category that falls within the wide range quality category.
  • ACX numbers, or appropriate adaptations, may be used for products other than research chemicals, such as other products that are used in a laboratory. For example, test tubes may be described in terms of quality (e.g., “plastic”, “rubber”, or “glass”, or a value indicating a level of resistance to reacting with the contents), number of items in the product (e.g., 24 test tubes to a box), volume of each test tube, and the unit of volume used, as described above.
  • A physical mixture may be described by an ACX number or an appropriate adaptation. For example, a particular toothpaste product may have an ACX number that may be used to refer to a set of other ACX numbers representing products that make up the ingredients of the toothpaste product.
  • A variation of the ACX number format may be used to indicate a research chemical's characteristics with respect to cross reactions. Such a variation may be particularly useful with medical or pharmaceutical substances. For example, a first topical substance may react with a second topical substance to create a third substance that is harmful to a patient. In such a case, tracking the chemical's cross-reactions can help to avoid causing problems.
  • An ACX number may be used in any situation in which the application of a compact, meaningful description of a product would be advantageous. For example, a research chemical product may be labeled with the ACX number so that a research scientist using the product can specify the product by the ACX number. A purchasing agent is thereby provided with information that, in many cases, is sufficient by itself to allow the purchasing agent to find an acceptable substitute for the specified product, because any product having an ACX number that precisely matches all but the source code section of the specified ACX number is highly likely to serve the needs of the research scientist. In addition, any product having an ACX number that precisely matches all but the source code and package code sections of the specified ACX number is highly likely to serve the needs of the research scientist, albeit possibly with some adjustments to account for quantity and package style differences.
  • An ACX number may be used in an electronic commerce environment so that a computer programmed to compare ACX numbers can readily identify a research chemical product or other product that is an acceptable substitute for a specified product, and report such identifications to an end-user. In a specific embodiment, each product recorded in the standardized products database described above may be assigned a respective ACX number, which may be recorded in the products table. In such a case, whenever a recorded product is listed, the corresponding ACX number may be displayed to facilitate an end-user's search for acceptable substitutes.
  • An on-line registration process may be provided so that a new product may be assigned an ACX and recorded in the standardized products database. For example, a Web page may be provided that accepts product information, perhaps including addresses of relevant on-line Web pages or other information. In such a case, the ACX number may be determined by analyzing the product information to determine, among other things, whether the database has an existing entry and therefore an existing substance code for the substance of the product. After being determined, the ACX number may be reported by electronic mail to the initiator (e.g., end user) of the registration of the product.
  • ACX numbers may also be used to track products such as chemicals throughout an organization, including in inventory and in recording reactions in reactions notebooks or databases.
  • Documents such as research papers and articles that include ACX numbers can be indexed by ACX number so that, for example, documents that refer to a particular product can be reliably listed and retrieved. In the case of Web pages and other electronic documents, ACX numbers can be embedded and linked so that selecting the ACX numbers, e.g., with mouse clicks, causes the display of information that is relevant to the product or to a feature of the product, such as the substance of the product.
  • All, or a portion of the procedures described above may be implemented in hardware or software, or a combination of both. In at least some cases, it is advantageous if the technique is implemented in computer programs executing on one or more programmable computers, such as a personal computer running or able to run an operating system such as Unix, Linux, Microsoft Windows 95, 98, 2000, or NT, or MacIntosh OS, that each include a processor, a storage medium readable by the processor (including volatile and non-volatile memory and/or storage elements), at least one input device such as a keyboard, and at least one output device. Program code is applied to data entered using the input device to perform the technique described above and to generate output information. The output information is applied to one or more output devices such as a display screen of the computer.
  • In at least some cases, it is advantageous if each program is implemented in a high level procedural or object-oriented programming language such as Perl, C, C++, or Java to communicate with a computer system. However, the programs can be implemented in assembly or machine language, if desired. In any case, the language may be a compiled or interpreted language.
  • In at least some cases, it is advantageous if each such computer program is stored on a storage medium or device, such as ROM or optical or magnetic disc, that is readable by a general or special purpose programmable computer for configuring and operating the computer when the storage medium or device is read by the computer to perform the procedures described in this document. The system may also be considered to be implemented as a computer-readable storage medium, configured with a computer program, where the storage medium so configured causes a computer to operate in a specific and predefined manner.
  • Other embodiments are within the scope of the following claims. For example, the columns that are to serve as sources for the tables may be selected fully or partially automatically, perhaps by a process that analyzes the contents of column headers to determine the type of information that is provided in the column. The ACX number may be provided in a form that is particularly suitable for detection or interpretation by a computer, such as in a bar code format or encoded on a magnetic strip.

Claims (8)

1.-22. (canceled)
23. Computer software, residing on a computer-readable storage medium, comprising a set of instructions for use in a computer system to help cause the computer system to manage product information, the instructions causing the system to:
acquire a set of product information describing a first chemical product that is suitable for a particular use; and
determine, from the set of product information and a database of chemical product information, a second chemical product that is suitable for the particular use.
24. Computer software, residing on a computer-readable storage medium, comprising a set of instructions for use in a computer system to help cause the computer system to manage product information, the instructions causing the system to:
acquire a set of product information describing a chemical product; and
determine, from the set of product information and a database of chemical product information, that multiple names refer to the same chemical substance.
25. Computer software, residing on a computer-readable storage medium, comprising a set of instructions for use in a computer system to help cause the computer system to manage product information, the instructions causing the system to:
acquire product information from an electronic catalog;
determine, based on the product information, whether a database includes information for a chemical substance that is described in the product information; and
add, based on the determination, at least a portion of the product information to the database.
26. A data processing system for use in managing product information, comprising:
a computer;
a storage device for storing data on a storage medium;
a first logic circuit configured to acquire a set of product information describing a first chemical product that is suitable for a particular use; and
a second logic circuit configured to determine, from the set of product information and a database of chemical product information, a second chemical product that is suitable for the particular use.
27. A data processing system for use in managing product information, comprising:
a computer;
a storage device for storing data on a storage medium;
a first logic circuit configured to acquire a set of product information describing a chemical product; and
a second logic circuit configured to determine, from the set of product information and a database of chemical product information, that multiple names refer to the same chemical substance.
28. (canceled)
29. The data processing system of claim 27, further comprising:
a third logic circuit configured to add, based on the determination, at least a portion of the set of product information to the database.
US11/856,523 2000-05-05 2007-09-17 Managing Product Information Abandoned US20080059221A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
US11/856,523 US20080059221A1 (en) 2000-05-05 2007-09-17 Managing Product Information

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US09/565,810 US7272509B1 (en) 2000-05-05 2000-05-05 Managing product information
US11/856,523 US20080059221A1 (en) 2000-05-05 2007-09-17 Managing Product Information

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
US09/565,810 Division US7272509B1 (en) 2000-05-05 2000-05-05 Managing product information

Publications (1)

Publication Number Publication Date
US20080059221A1 true US20080059221A1 (en) 2008-03-06

Family

ID=38481863

Family Applications (2)

Application Number Title Priority Date Filing Date
US09/565,810 Expired - Lifetime US7272509B1 (en) 2000-05-05 2000-05-05 Managing product information
US11/856,523 Abandoned US20080059221A1 (en) 2000-05-05 2007-09-17 Managing Product Information

Family Applications Before (1)

Application Number Title Priority Date Filing Date
US09/565,810 Expired - Lifetime US7272509B1 (en) 2000-05-05 2000-05-05 Managing product information

Country Status (1)

Country Link
US (2) US7272509B1 (en)

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6578030B1 (en) * 2000-06-30 2003-06-10 Requisite Technology Inc. Method and apparatus for mapping one catalog into another catalog
US7555503B1 (en) * 2000-06-30 2009-06-30 Click Commerce, Inc. Method and apparatus for managing updates to a catalog
US8010375B2 (en) * 2004-05-11 2011-08-30 Sap Ag Object model for global trade applications
US20070156511A1 (en) * 2005-12-30 2007-07-05 Gregor Arlt Dependent object deviation
US9460455B2 (en) * 2013-01-04 2016-10-04 24/7 Customer, Inc. Determining product categories by mining interaction data in chat transcripts
US9471628B2 (en) * 2013-03-04 2016-10-18 Mastercard International Incorporated Methods and systems for calculating and retrieving analytic data
TWI576773B (en) * 2016-07-25 2017-04-01 廣達電腦股份有限公司 Systems and methods for sharing information of product materials

Citations (81)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6128A (en) * 1849-02-20 Short slide-valve by chamfering corners
US4473890A (en) * 1982-04-07 1984-09-25 The Japan Information Center of Science & Technology Method and device for storing stereochemical information about chemical compounds
US4747059A (en) * 1984-12-14 1988-05-24 Suntory Limited Process and apparatus for naming chemical structures and the application thereof
US4811217A (en) * 1985-03-29 1989-03-07 Japan Association For International Chemical Information Method of storing and searching chemical structure data
US4908781A (en) * 1985-11-12 1990-03-13 The Trustees Of Columbia University In The City Of New York Computing device for calculating energy and pairwise central forces of particle interactions
US5025388A (en) * 1988-08-26 1991-06-18 Cramer Richard D Iii Comparative molecular field analysis (CoMFA)
US5157736A (en) * 1991-04-19 1992-10-20 International Business Machines Corporation Apparatus and method for optical recognition of chemical graphics
US5249137A (en) * 1990-03-23 1993-09-28 Xerox Corporation Computer-aided chemical illustration system
US5311437A (en) * 1992-01-28 1994-05-10 Hughes Aircraft Company Materials selector tool
US5345516A (en) * 1991-04-19 1994-09-06 International Business Machines Corporation Apparatus and method for parsing a chemical string
US5418944A (en) * 1991-01-26 1995-05-23 International Business Machines Corporation Knowledge-based molecular retrieval system and method using a hierarchy of molecular structures in the knowledge base
US5424963A (en) * 1992-11-25 1995-06-13 Photon Research Associates, Inc. Molecular dynamics simulation method and apparatus
US5434796A (en) * 1993-06-30 1995-07-18 Daylight Chemical Information Systems, Inc. Method and apparatus for designing molecules with desired properties by evolving successive populations
US5448498A (en) * 1991-11-26 1995-09-05 Fujitsu Limited Apparatus for generating a constraint condition in a molecular dynamics simulation
US5461580A (en) * 1993-04-30 1995-10-24 Xerox Corporation Computer-aided chemical illustration system
US5486995A (en) * 1994-03-17 1996-01-23 Dow Benelux N.V. System for real time optimization
US5577239A (en) * 1994-08-10 1996-11-19 Moore; Jeffrey Chemical structure storage, searching and retrieval system
US5619421A (en) * 1994-06-17 1997-04-08 Massachusetts Institute Of Technology Computer-implemented process and computer system for estimating the three-dimensional shape of a ring-shaped molecule and of a portion of a molecule containing a ring-shaped structure
US5664112A (en) * 1992-03-02 1997-09-02 Alternative Systems, Inc. Integrated hazardous substances management unit
US5699268A (en) * 1995-03-24 1997-12-16 University Of Guelph Computational method for designing chemical structures having common functional characteristics
US5740425A (en) * 1995-09-26 1998-04-14 Povilus; David S. Data structure and method for publishing electronic and printed product catalogs
US5740072A (en) * 1994-10-07 1998-04-14 The Trustees Of Columbia Universuty In The City Of New York Rapidly convergent method for boltzmann-weighted ensemble generation in free energy simulations
US5778377A (en) * 1994-11-04 1998-07-07 International Business Machines Corporation Table driven graphical user interface
US5841678A (en) * 1997-01-17 1998-11-24 Phillips Petroleum Company Modeling and simulation of a reaction for hydrotreating hydrocarbon oil
US5851272A (en) * 1997-02-14 1998-12-22 Vitech International, Inc. Non-oil organic spray wax compositions
US5854992A (en) * 1996-09-26 1998-12-29 President And Fellows Of Harvard College System and method for structure-based drug design that includes accurate prediction of binding free energy
US5874564A (en) * 1990-03-21 1999-02-23 Isis Pharmaceuticals, Inc. Reagents and methods for modulating gene expression through RNA mimicry
US5940807A (en) * 1996-05-24 1999-08-17 Purcell; Daniel S. Automated and independently accessible inventory information exchange system
US5956711A (en) * 1997-01-16 1999-09-21 Walter J. Sullivan, III Database system with restricted keyword list and bi-directional keyword translation
US5978848A (en) * 1997-03-14 1999-11-02 International Business Machines Corporation Web browser method and system for backgrounding a link access during slow link access time periods
US5978804A (en) * 1996-04-11 1999-11-02 Dietzman; Gregg R. Natural products information system
US5980096A (en) * 1995-01-17 1999-11-09 Intertech Ventures, Ltd. Computer-based system, methods and graphical interface for information storage, modeling and stimulation of complex systems
US6007691A (en) * 1991-05-07 1999-12-28 Glyko, Inc. Fluorophore assisted carbohydrate electrophoresis diagnosis
US6014449A (en) * 1998-02-20 2000-01-11 Board Of Trustees Operating Michigan State University Computer-implemented system for analyzing rigidity of substructures within a macromolecule
US6023659A (en) * 1996-10-10 2000-02-08 Incyte Pharmaceuticals, Inc. Database system employing protein function hierarchies for viewing biomolecular sequence data
US6023683A (en) * 1994-08-10 2000-02-08 Fisher Scientific Company Electronic sourcing system and method
US6038562A (en) * 1996-09-05 2000-03-14 International Business Machines Corporation Interface to support state-dependent web applications accessing a relational database
US6061636A (en) * 1996-02-26 2000-05-09 Pharmacopeia, Inc. Technique for representing combinatorial chemistry libraries resulting from selective combination of synthons
US6119104A (en) * 1997-11-24 2000-09-12 Keycorp Composite banking desktop system
US6125383A (en) * 1997-06-11 2000-09-26 Netgenics Corp. Research system using multi-platform object oriented program language for providing objects at runtime for creating and manipulating biological or chemical data
US6128619A (en) * 1998-04-30 2000-10-03 International Business Machines Corporation Generating an internet application for accessing a hierarchical database
US6178384B1 (en) * 1997-09-29 2001-01-23 The Trustees Of Columbia University In The City Of New York Method and apparatus for selecting a molecule based on conformational free energy
US6185548B1 (en) * 1998-06-19 2001-02-06 Albert Einstein College Of Medicine Of Yeshiva University Neural network methods to predict enzyme inhibitor or receptor ligand potency
US6185506B1 (en) * 1996-01-26 2001-02-06 Tripos, Inc. Method for selecting an optimally diverse library of small molecules based on validated molecular structural descriptors
US6189013B1 (en) * 1996-12-12 2001-02-13 Incyte Genomics, Inc. Project-based full length biomolecular sequence database
US6199017B1 (en) * 1995-03-17 2001-03-06 Kureha Kagaku Kogyo Kabushiki Kaisha Biochemical information processing apparatus, biochemical information processing method, and biochemical information recording medium
US6219622B1 (en) * 1995-03-24 2001-04-17 University Of Guelph Computational method for designing chemical structures having common functional characteristics
US6226620B1 (en) * 1996-06-11 2001-05-01 Yeong Kuang Oon Iterative problem solving technique
US6236989B1 (en) * 1998-12-11 2001-05-22 International Business Machines Corporation Network-based help architecture
US6240374B1 (en) * 1996-01-26 2001-05-29 Tripos, Inc. Further method of creating and rapidly searching a virtual library of potential molecules using validated molecular structural descriptors
US6246410B1 (en) * 1996-01-19 2001-06-12 International Business Machines Corp. Method and system for database access
US6256647B1 (en) * 1998-02-16 2001-07-03 Biomolecular Engineering Research Institute Method of searching database of three-dimensional protein structures
US6272472B1 (en) * 1998-12-29 2001-08-07 Intel Corporation Dynamic linking of supplier web sites to reseller web sites
US6295514B1 (en) * 1996-11-04 2001-09-25 3-Dimensional Pharmaceuticals, Inc. Method, system, and computer program product for representing similarity/dissimilarity between chemical compounds
US6311134B1 (en) * 1999-02-09 2001-10-30 Mallinckrodt Inc. Process and apparatus for comparing chemical products
US6319668B1 (en) * 1995-04-25 2001-11-20 Discovery Partners International Method for tagging and screening molecules
US6324522B2 (en) * 1997-09-15 2001-11-27 Mro Software, Inc. Electronic information network for inventory control and transfer
US6323852B1 (en) * 1999-01-04 2001-11-27 Leadscope, Inc. Method of analyzing organizing and visualizing chemical data with feature hierarchy
US6326962B1 (en) * 1996-12-23 2001-12-04 Doubleagent Llc Graphic user interface for database system
US6332138B1 (en) * 1999-07-23 2001-12-18 Merck & Co., Inc. Text influenced molecular indexing system and computer-implemented and/or computer-assisted method for same
US6341314B1 (en) * 1999-03-30 2002-01-22 International Business Machines Corporation Web-based virtual computing machine
US20020049548A1 (en) * 2000-04-03 2002-04-25 Libraria, Inc. Chemistry resource database
US6453064B1 (en) * 1994-02-28 2002-09-17 Fujitsu Limited Common structure extraction apparatus
US20020165853A1 (en) * 2001-05-02 2002-11-07 Victor Gogolak Pharmacovigilance database
US6519611B1 (en) * 1999-09-06 2003-02-11 National University Of Singapore Method and apparatus for computer automated detection of protein and nucleic acid targets of a chemical compound
US6571245B2 (en) * 1998-12-07 2003-05-27 Magically, Inc. Virtual desktop in a computer network
US6582233B1 (en) * 1999-05-14 2003-06-24 Accelrys Inc. Apparatus and method for monitoring the validity of a molecular model
US6584412B1 (en) * 1999-08-04 2003-06-24 Cambridgesoft Corporation Applying interpretations of chemical names
US6618852B1 (en) * 1998-09-14 2003-09-09 Intellichem, Inc. Object-oriented framework for chemical-process-development decision-support applications
US6631381B1 (en) * 1997-10-14 2003-10-07 International Business Machines Corporation System and method for referencing a user-generated copy of a catalog
US6654736B1 (en) * 1998-11-09 2003-11-25 The United States Of America As Represented By The Secretary Of The Army Chemical information systems
US6665685B1 (en) * 1999-11-01 2003-12-16 Cambridge Soft Corporation Deriving database interaction software
US6675105B2 (en) * 1998-02-06 2004-01-06 Ilexus Pty Limited Structure-based identification of candidate compounds using three dimensional structures and models of Fc receptors
US6678577B1 (en) * 1997-05-16 2004-01-13 Vertex Pharmaceuticals Incorporated Systems and methods for rapidly identifying useful chemicals in liquid samples
US6721754B1 (en) * 1999-04-28 2004-04-13 Arena Pharmaceuticals, Inc. System and method for database similarity join
US6751615B2 (en) * 2000-05-01 2004-06-15 Aspen Technology, Inc. Method and system generating query form, assigning and comparing risk designation of chemical product over a computer network for chemical products customers
US6871198B2 (en) * 2001-12-21 2005-03-22 Requisite Technology, Inc. Composing and cataloging item configuration data
US6884394B1 (en) * 1999-08-05 2005-04-26 3M Innovative Properties Company Chemical indicator reader
US7054754B1 (en) * 1999-02-12 2006-05-30 Cambridgesoft Corporation Method, system, and software for deriving chemical structural information
US7295931B1 (en) * 1999-02-18 2007-11-13 Cambridgesoft Corporation Deriving fixed bond information
US7356419B1 (en) * 2000-05-05 2008-04-08 Cambridgesoft Corporation Deriving product information

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6128582A (en) 1996-04-30 2000-10-03 Vertex Pharmaceuticals Incorporated Molecules comprising an IMPDH-like binding pocket and encoded data storage medium capable of graphically displaying them

Patent Citations (87)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6128A (en) * 1849-02-20 Short slide-valve by chamfering corners
US4473890A (en) * 1982-04-07 1984-09-25 The Japan Information Center of Science & Technology Method and device for storing stereochemical information about chemical compounds
US4747059A (en) * 1984-12-14 1988-05-24 Suntory Limited Process and apparatus for naming chemical structures and the application thereof
US4811217A (en) * 1985-03-29 1989-03-07 Japan Association For International Chemical Information Method of storing and searching chemical structure data
US4908781A (en) * 1985-11-12 1990-03-13 The Trustees Of Columbia University In The City Of New York Computing device for calculating energy and pairwise central forces of particle interactions
US5025388A (en) * 1988-08-26 1991-06-18 Cramer Richard D Iii Comparative molecular field analysis (CoMFA)
US5874564A (en) * 1990-03-21 1999-02-23 Isis Pharmaceuticals, Inc. Reagents and methods for modulating gene expression through RNA mimicry
US5379234A (en) * 1990-03-23 1995-01-03 Xerox Corporation Computer-aided chemical illustration system
US5249137A (en) * 1990-03-23 1993-09-28 Xerox Corporation Computer-aided chemical illustration system
US5418944A (en) * 1991-01-26 1995-05-23 International Business Machines Corporation Knowledge-based molecular retrieval system and method using a hierarchy of molecular structures in the knowledge base
US5345516A (en) * 1991-04-19 1994-09-06 International Business Machines Corporation Apparatus and method for parsing a chemical string
US5157736A (en) * 1991-04-19 1992-10-20 International Business Machines Corporation Apparatus and method for optical recognition of chemical graphics
US6007691A (en) * 1991-05-07 1999-12-28 Glyko, Inc. Fluorophore assisted carbohydrate electrophoresis diagnosis
US5448498A (en) * 1991-11-26 1995-09-05 Fujitsu Limited Apparatus for generating a constraint condition in a molecular dynamics simulation
US5311437A (en) * 1992-01-28 1994-05-10 Hughes Aircraft Company Materials selector tool
US5664112A (en) * 1992-03-02 1997-09-02 Alternative Systems, Inc. Integrated hazardous substances management unit
US5424963A (en) * 1992-11-25 1995-06-13 Photon Research Associates, Inc. Molecular dynamics simulation method and apparatus
US5461580A (en) * 1993-04-30 1995-10-24 Xerox Corporation Computer-aided chemical illustration system
US5434796A (en) * 1993-06-30 1995-07-18 Daylight Chemical Information Systems, Inc. Method and apparatus for designing molecules with desired properties by evolving successive populations
US6453064B1 (en) * 1994-02-28 2002-09-17 Fujitsu Limited Common structure extraction apparatus
US5486995A (en) * 1994-03-17 1996-01-23 Dow Benelux N.V. System for real time optimization
US5619421A (en) * 1994-06-17 1997-04-08 Massachusetts Institute Of Technology Computer-implemented process and computer system for estimating the three-dimensional shape of a ring-shaped molecule and of a portion of a molecule containing a ring-shaped structure
US5950192A (en) * 1994-08-10 1999-09-07 Oxford Molecular Group, Inc. Relational database mangement system for chemical structure storage, searching and retrieval
US6023683A (en) * 1994-08-10 2000-02-08 Fisher Scientific Company Electronic sourcing system and method
US6505172B1 (en) * 1994-08-10 2003-01-07 Eplus Inc. Electronic sourcing system
US5577239A (en) * 1994-08-10 1996-11-19 Moore; Jeffrey Chemical structure storage, searching and retrieval system
US6055516A (en) * 1994-08-10 2000-04-25 Procurenet, Inc. Electronic sourcing system
US5740072A (en) * 1994-10-07 1998-04-14 The Trustees Of Columbia Universuty In The City Of New York Rapidly convergent method for boltzmann-weighted ensemble generation in free energy simulations
US5778377A (en) * 1994-11-04 1998-07-07 International Business Machines Corporation Table driven graphical user interface
US5980096A (en) * 1995-01-17 1999-11-09 Intertech Ventures, Ltd. Computer-based system, methods and graphical interface for information storage, modeling and stimulation of complex systems
US6199017B1 (en) * 1995-03-17 2001-03-06 Kureha Kagaku Kogyo Kabushiki Kaisha Biochemical information processing apparatus, biochemical information processing method, and biochemical information recording medium
US5699268A (en) * 1995-03-24 1997-12-16 University Of Guelph Computational method for designing chemical structures having common functional characteristics
US6219622B1 (en) * 1995-03-24 2001-04-17 University Of Guelph Computational method for designing chemical structures having common functional characteristics
US6319668B1 (en) * 1995-04-25 2001-11-20 Discovery Partners International Method for tagging and screening molecules
US5740425A (en) * 1995-09-26 1998-04-14 Povilus; David S. Data structure and method for publishing electronic and printed product catalogs
US6246410B1 (en) * 1996-01-19 2001-06-12 International Business Machines Corp. Method and system for database access
US6185506B1 (en) * 1996-01-26 2001-02-06 Tripos, Inc. Method for selecting an optimally diverse library of small molecules based on validated molecular structural descriptors
US6240374B1 (en) * 1996-01-26 2001-05-29 Tripos, Inc. Further method of creating and rapidly searching a virtual library of potential molecules using validated molecular structural descriptors
US6061636A (en) * 1996-02-26 2000-05-09 Pharmacopeia, Inc. Technique for representing combinatorial chemistry libraries resulting from selective combination of synthons
US5978804A (en) * 1996-04-11 1999-11-02 Dietzman; Gregg R. Natural products information system
US6081789A (en) * 1996-05-24 2000-06-27 Purcell; Daniel S. Automated and independently accessible inventory information exchange system
US5940807A (en) * 1996-05-24 1999-08-17 Purcell; Daniel S. Automated and independently accessible inventory information exchange system
US6226620B1 (en) * 1996-06-11 2001-05-01 Yeong Kuang Oon Iterative problem solving technique
US6038562A (en) * 1996-09-05 2000-03-14 International Business Machines Corporation Interface to support state-dependent web applications accessing a relational database
US5854992A (en) * 1996-09-26 1998-12-29 President And Fellows Of Harvard College System and method for structure-based drug design that includes accurate prediction of binding free energy
US6023659A (en) * 1996-10-10 2000-02-08 Incyte Pharmaceuticals, Inc. Database system employing protein function hierarchies for viewing biomolecular sequence data
US6295514B1 (en) * 1996-11-04 2001-09-25 3-Dimensional Pharmaceuticals, Inc. Method, system, and computer program product for representing similarity/dissimilarity between chemical compounds
US6189013B1 (en) * 1996-12-12 2001-02-13 Incyte Genomics, Inc. Project-based full length biomolecular sequence database
US6326962B1 (en) * 1996-12-23 2001-12-04 Doubleagent Llc Graphic user interface for database system
US5956711A (en) * 1997-01-16 1999-09-21 Walter J. Sullivan, III Database system with restricted keyword list and bi-directional keyword translation
US5841678A (en) * 1997-01-17 1998-11-24 Phillips Petroleum Company Modeling and simulation of a reaction for hydrotreating hydrocarbon oil
US5851272A (en) * 1997-02-14 1998-12-22 Vitech International, Inc. Non-oil organic spray wax compositions
US5978848A (en) * 1997-03-14 1999-11-02 International Business Machines Corporation Web browser method and system for backgrounding a link access during slow link access time periods
US6678577B1 (en) * 1997-05-16 2004-01-13 Vertex Pharmaceuticals Incorporated Systems and methods for rapidly identifying useful chemicals in liquid samples
US6125383A (en) * 1997-06-11 2000-09-26 Netgenics Corp. Research system using multi-platform object oriented program language for providing objects at runtime for creating and manipulating biological or chemical data
US6324522B2 (en) * 1997-09-15 2001-11-27 Mro Software, Inc. Electronic information network for inventory control and transfer
US6178384B1 (en) * 1997-09-29 2001-01-23 The Trustees Of Columbia University In The City Of New York Method and apparatus for selecting a molecule based on conformational free energy
US6631381B1 (en) * 1997-10-14 2003-10-07 International Business Machines Corporation System and method for referencing a user-generated copy of a catalog
US6119104A (en) * 1997-11-24 2000-09-12 Keycorp Composite banking desktop system
US6675105B2 (en) * 1998-02-06 2004-01-06 Ilexus Pty Limited Structure-based identification of candidate compounds using three dimensional structures and models of Fc receptors
US6256647B1 (en) * 1998-02-16 2001-07-03 Biomolecular Engineering Research Institute Method of searching database of three-dimensional protein structures
US6014449A (en) * 1998-02-20 2000-01-11 Board Of Trustees Operating Michigan State University Computer-implemented system for analyzing rigidity of substructures within a macromolecule
US6128619A (en) * 1998-04-30 2000-10-03 International Business Machines Corporation Generating an internet application for accessing a hierarchical database
US6185548B1 (en) * 1998-06-19 2001-02-06 Albert Einstein College Of Medicine Of Yeshiva University Neural network methods to predict enzyme inhibitor or receptor ligand potency
US6618852B1 (en) * 1998-09-14 2003-09-09 Intellichem, Inc. Object-oriented framework for chemical-process-development decision-support applications
US6654736B1 (en) * 1998-11-09 2003-11-25 The United States Of America As Represented By The Secretary Of The Army Chemical information systems
US6571245B2 (en) * 1998-12-07 2003-05-27 Magically, Inc. Virtual desktop in a computer network
US6236989B1 (en) * 1998-12-11 2001-05-22 International Business Machines Corporation Network-based help architecture
US6272472B1 (en) * 1998-12-29 2001-08-07 Intel Corporation Dynamic linking of supplier web sites to reseller web sites
US6323852B1 (en) * 1999-01-04 2001-11-27 Leadscope, Inc. Method of analyzing organizing and visualizing chemical data with feature hierarchy
US6311134B1 (en) * 1999-02-09 2001-10-30 Mallinckrodt Inc. Process and apparatus for comparing chemical products
US7054754B1 (en) * 1999-02-12 2006-05-30 Cambridgesoft Corporation Method, system, and software for deriving chemical structural information
US7295931B1 (en) * 1999-02-18 2007-11-13 Cambridgesoft Corporation Deriving fixed bond information
US6341314B1 (en) * 1999-03-30 2002-01-22 International Business Machines Corporation Web-based virtual computing machine
US6721754B1 (en) * 1999-04-28 2004-04-13 Arena Pharmaceuticals, Inc. System and method for database similarity join
US6582233B1 (en) * 1999-05-14 2003-06-24 Accelrys Inc. Apparatus and method for monitoring the validity of a molecular model
US6542903B2 (en) * 1999-07-23 2003-04-01 Merck & Co., Inc. Text influenced molecular indexing system and computer-implemented and/or computer-assisted method for same
US6332138B1 (en) * 1999-07-23 2001-12-18 Merck & Co., Inc. Text influenced molecular indexing system and computer-implemented and/or computer-assisted method for same
US6584412B1 (en) * 1999-08-04 2003-06-24 Cambridgesoft Corporation Applying interpretations of chemical names
US6884394B1 (en) * 1999-08-05 2005-04-26 3M Innovative Properties Company Chemical indicator reader
US6519611B1 (en) * 1999-09-06 2003-02-11 National University Of Singapore Method and apparatus for computer automated detection of protein and nucleic acid targets of a chemical compound
US6665685B1 (en) * 1999-11-01 2003-12-16 Cambridge Soft Corporation Deriving database interaction software
US20020049548A1 (en) * 2000-04-03 2002-04-25 Libraria, Inc. Chemistry resource database
US6751615B2 (en) * 2000-05-01 2004-06-15 Aspen Technology, Inc. Method and system generating query form, assigning and comparing risk designation of chemical product over a computer network for chemical products customers
US7356419B1 (en) * 2000-05-05 2008-04-08 Cambridgesoft Corporation Deriving product information
US20020165853A1 (en) * 2001-05-02 2002-11-07 Victor Gogolak Pharmacovigilance database
US6871198B2 (en) * 2001-12-21 2005-03-22 Requisite Technology, Inc. Composing and cataloging item configuration data

Also Published As

Publication number Publication date
US7272509B1 (en) 2007-09-18

Similar Documents

Publication Publication Date Title
US20080306966A1 (en) Deriving Product Information
US6493724B1 (en) Web-integrated inventory management system and method
US7921099B2 (en) Guided navigation system
US20080059221A1 (en) Managing Product Information
US8738662B2 (en) Methods and apparatus for catalog data capture, storage and distribution
US20070239742A1 (en) Determining data elements in heterogeneous schema definitions for possible mapping
US8566177B2 (en) User supplied and refined tags
US20190139117A1 (en) Collections of Matched Biological Reagents and Methods for Identifying Matched Reagents
US6631365B1 (en) Method and apparatus for analyzing the quality of the content of a database
US7197479B1 (en) Methods and apparatus for implementing a multi-lingual catalog system
US7020654B1 (en) Methods and apparatus for indexing content
US7814101B2 (en) Term database extension for label system
US9372918B2 (en) Universal data relationship inference engine
US20090248626A1 (en) Information repository search system
US20040049490A1 (en) Intelligent document management system
US20030074142A1 (en) Coincidence detection programmed media and system
EP0674782A4 (en) Method and apparatus for providing a data interface between a plurality of test information sources and a database.
US7284007B1 (en) Methods of capturing catalog data
US6654736B1 (en) Chemical information systems
US20210342919A1 (en) System and method for cross catalog search
Moen et al. Assessing metadata utilization: an analysis of MARC content designation use
CN110276660A (en) A kind of goods distribution method, device and its system
US7774701B2 (en) Creating an index page for user interface frames
US20070255705A1 (en) Method of evaluating document conformance
JP3931733B2 (en) Green procurement information system

Legal Events

Date Code Title Description
AS Assignment

Owner name: CAMBRIDGESOFT CORPORATION, MASSACHUSETTS

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:CULOT, LOUIS J.;KNELL, MARK C.;REEL/FRAME:023290/0045;SIGNING DATES FROM 20000907 TO 20000908

STCB Information on status: application discontinuation

Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION