Chemical information systems

• US 6,654,736 B1
• Filed: 11/09/1999
• Issued: 11/25/2003
• Est. Priority Date: 11/09/1998
• Status: Expired due to Fees

• Current Assignee: The United States of America As Represented By The Secretary of Agriculture
• Original Assignee: The United States Of America As Represented By The Secretary Of The Army
• Inventors: Ellis, William Y., McGreevy, Patrick B., Notsch, John D.
• Primary Examiner(s): Breene, John
• Assistant Examiner(s): Ali, Mohammad
• Application Number:
  US09/436,226
• Time in Patent Office: 1,477 Days
• Field of Search: 707/1-3, 707/100-104, 707/9-10, 704/9, 702/27
• US Class Current: 1/1
• CPC Class Codes: G06F 16/28 Databases characterised by their database models, e.g. relational or object models
• CPC Class Codes: G16C 20/80 Data visualisation
• CPC Class Codes: G16C 20/90 Programming languages; Computing architectures; Database systems; Data warehousing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A chemical information system having a graphical user interface that allows manipulation of multiple databases having related material and information. The system includes a server and multiple workstations communicating with the server. The databases reside on the server, which may include multiple servers.

Claims

1. A chemical information system comprising:

at least one server,

a plurality of databases resident on said at least one server, said databases include a chemist database, a biology database, and an inventory database,

at least two workstations in communication with said at least one server,

a graphical user interface, said interface allowing searching, retrieving, synchronizing and correlating of information from at least two different databases, and

a means for handling inventory including receiving orders, approving orders, and processing orders, said inventory handling means is in communication with said at least two workstations,

a bar code reader in communication with said inventory handling means,

a bar code printer in communication with said inventory handling means, and

at least one balance; and

wherein one of said at least two workstations is in communication with said at least one balance.

2. A The chemical information system comprising:

at least one server,

a plurality of databases resident on said at least one server, said plurality of databases includes a chemistry database, a biology database having information relating to experiment results for at least some of the chemicals present within said chemistry database, and an inventory database,

at least two workstations in communication with said at least one server,

a graphical user interface, said interface allowing searching, retrieving, synchronizing and correlating of information from at least two different databases, and

a means for handling inventory including receiving orders, approving orders, and processing orders, said inventory handling means is in communication with said at least two workstations,

a bar code reader in communication with said inventory handling means,

a bar code printer in communication with said inventory handling means,

at least one balance; and

wherein one of said at least two workstations is in communication with said at least one balance.

3. A method for handling inventory of chemicals comprising:

receiving an order for at least one chemical from an user,

providing a list having at least one chemical order for approval,

receiving instructions for approval or disapproval of at least one chemical order,

when a chemical order has been disapproved, notifying the user of the disapproval,

when a chemical order has been approved,

entering the chemical order for processing and shipment, and processing the chemical order for shipping; and

wherein the processing step includes

receiving information relating to a chemical read in through a bar code reader,

verifying the chemical sample information matches the chemical order,

receiving a final weight for the amount of the chemical present upon a balance,

deducting the final weight for the amount of the chemical from available supply for the chemical,

creating a new record for the chemical order including an identifier and the user,

sending information relating to the chemical order including the identifier and the user to a bar code printer, and

notifying the user of shipment of the chemical order.

4. A data signal embodied in a carrier wave readable by a computing system,and encoding instructions for executing a process performing the method recited in claim 3.

5. A computer-readable medium having computer-executable instructions for the method recited in claim 3.

6. A chemical information system comprising:

a graphical user interface,

a biology database,

a chemistry database,

a biology application in communication with said graphical user interface and said biology database, said biology application having

means for processing a search request based upon entered criteria in said biology database,

means for displaying the results of the search in said graphical user interface, and

means for receiving a selection, retrieving information related to the selection from said biology database, and displaying the retrieved information in said graphical user interface,

an inventory application in communication with said biology application, said inventory application having

means for receiving orders,

means for tracking orders, and

means for entering new samples,

a chemistry application in communication with said graphical user interface and said chemistry database, said chemistry application having

means for conducting a SMILE search based upon entered criteria in said chemistry database, and

means for displaying chemical information located based upon the SMILE search in said graphical user interface; and

a data entry module in communication with said biology database, said data entry module having means for entering test results into said biology database.

7. The chemical information system according to claim 6, further comprising means for retrieving chemistry information relating to the selection received by said biology application from said chemistry database.

8. The chemical information system according to claim 6, further comprising means for retrieving biology information relating to the displayed chemical information from said biology database.

9. The chemical information system according to claim 6, wherein said ordering means includes

means for receiving an order for at least one chemical from an user,

means for providing a list having at least one chemical order for approval,

means for receiving instructions for approval or disapproval of at least one chemical order,

means for notifying the user of the disapproval when a chemical order has been disapproved,

means for entering the chemical order for processing and shipment when a chemical order has been approved, and

means for processing the chemical order for shipping when a chemical order has been approved.

10. The chemical information system according to claim 6, further comprising:

a balance in communication with said inventory application,

a bar code reader in communication with said inventory application, and

a bar code printer in communication with said inventory application.