Relational database mangement system for chemical structure storage, searching and retrieval
First Claim
1. A method for storing chemical structures in a relational database, comprising the following steps:
- receiving the atoms of a chemical structure;
receiving the bonds between the atoms of said chemical structure;
constructing a matrix representation of said chemical structure including said atoms and said bonds;
storing said matrix in said relational database;
generating one search key for each of said atoms in said chemical structure; and
storing said search keys in said relational database.
1 Assignment
0 Petitions
Accused Products
Abstract
A chemical structure search system and method are disclosed which expand the capabilities of existing systems by capitalizing on the strengths of relational database technology. The system allows the user to optimally store and search chemical structure information including information relating to multi-valued atoms, multi-typed bonds, Markush searching and various other options in a relational database management system. The system provides a complete chemical information system which includes capabilities for: (1) exact structure searching; (2) substructure searching; (3) key searching; (4) chemical name searching; (5) molecular formula searching; (6) registration of new molecules; (7) structure import/export; and (8) data editing. Additionally, the chemical structure search system allows the routine integration of chemical structure data with other related information such as inventory, spectroscopic data and clinical data via standard relational database methods. The system also has dynamic querying capabilities which allow the user to be notified of any new chemicals that are entered into the database that are responsive to previously run queries. Furthermore, structure classes can also be implemented which allow the user to store certain types of information about particular types of chemical structures such as steroids. Accordingly, users can later call up this information in a quick and efficient manner without re-entering or performing previously run queries.
93 Citations
14 Claims
-
1. A method for storing chemical structures in a relational database, comprising the following steps:
-
receiving the atoms of a chemical structure; receiving the bonds between the atoms of said chemical structure; constructing a matrix representation of said chemical structure including said atoms and said bonds; storing said matrix in said relational database; generating one search key for each of said atoms in said chemical structure; and storing said search keys in said relational database. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method for searching chemical structures stored in a relational database, comprising the following steps:
-
inputting queries including atoms and bonds; generating one query key for each said atom in said inputted query; creating a query connection table derived from said inputted query; comparing at least one said query key to one or more search keys generated for a given database structure, wherein a match is found when said at least one said query key matches at least one of said search keys in said chemical structure; comparing said query connection table to a search connection table when said match is found; creating a table which stores said matches of said comparisons; and outputting the results of said inputted query. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A method of storing chemical structures in a relational database, comprising the following steps:
-
inputting a structure including atoms and bonds into a relational database of a computer; constructing a matrix representation of each of said structures including said atoms and said bonds; checking said stored structures for duplicates; generating one search key for each of said atoms and said bonds in said structure; and storing said search keys in said relational database.
-
-
14. A method for storing chemical structures in a database, comprising the following steps:
-
receiving each of the atoms of a chemical structure; receiving each of the bonds between said atoms in said chemical structure; constructing a matrix representation of said chemical structure including said atoms and said bonds; storing said matrix in said database; generating one search key for every one of said atoms in said chemical structure; and storing said search keys in said database.
-
Specification