US5950192A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Relational database mangement system for chemical structure storage, searching and retrieval
Assignee: Dassault Systemes Biovia Corp
•
Filing: 1997-06-26
•
Granted: 1999-09-07
•
Expires: 2017-06-26
Abstract
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.
Inventors
- 👤 Jeffrey Moore
- 👤 Joanne Brazil
- 👤 Jeffrey R. Hoover
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 20:23
CPC Classifications
G; G16; G16C; G16C20/00; G16C20/90; G16C20/40; Y; Y10; Y10S; Y10S707/00; Y10S707/912; Y10S707/941; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99933
Claims Analysis
Total Claims: 18
Claim 1
Independent Claim
74 words
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.
Claim 2
Independent Claim
74 words
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.
Claim 3
Dependent Claim
45 words
The method of storing chemical structures of claim 1 further comprising the steps of: defining a registry key number for said structure; defining a registry key name for said structure; and storing said registry key number and said registry key name in said relational database.
Claim 4
Dependent Claim
26 words
The method of storing chemical structures of claim 1 further comprising the steps of storing a chemical formula for each said structure in said relational database.
Claim 5
Dependent Claim
23 words
The method for storing chemical structures in a relational database according to claim 1, further comprising relating inventory information to said stored structure.
Claim 6
Dependent Claim
23 words
The method for storing chemical structures in a relational database according to claim 1, further comprising relating spectroscopic data to said stored structure.
Claim 7
Dependent Claim
25 words
The method for storing chemical structures in a relational database according to claim 1, further comprising relating clinical or biological information to said stored structure.
Claim 8
Independent Claim
120 words
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.
Claim 9
Independent Claim
120 words
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.
Claim 10
Dependent Claim
48 words
The method of searching chemical structures stored in a relational database according to claim 7, wherein said step of generating one query key comprises assigning a code to each atom in said structure, said code being based on the type of atom and the type of neighboring atoms.
Claim 11
Dependent Claim
46 words
The method of searching chemical structures stored in a relational database of claim 8, further comprising the steps of: labeling each bond with a unique letter based on an ordering of said bonds; and storing said letters as a search query key in said relational database.
Claim 12
Dependent Claim
43 words
The method of searching chemical structures stored in a relational database according to claim 7, further comprising outputting results selected from the group consisting of inventory data, spectroscopic data, clinical data, toxicological data and biological data for the results of said inputted query.
Claim 13
Dependent Claim
25 words
The method of searching chemical structures stored in a relational database according to claim 7, wherein said search query key includes a Markush searching query.
Claim 14
Dependent Claim
25 words
The method of searching chemical structures stored in a relational database according to claim 7, wherein said search query key includes a wildcard search query.
Claim 15
Independent Claim
73 words
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.
Claim 16
Independent Claim
73 words
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.
Claim 17
Independent Claim
76 words
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.
Claim 18
Independent Claim
76 words
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.
References Cited (Backward Citations)
EP0090895A2
Cited
US4642762A
Cited
US4811217A
Cited
EP0213483A2
Cited
US5056035A
Cited
US4855931A
Cited
US5025388A
Cited
US5379234A
Cited
US5418944A
Cited
US5386507A
Cited
US5259137A
Cited
US5367058A
Cited
US5577239A
Cited
US5463564A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-09-06 | 2003-03-08 | 2003-09-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-09-06 | 2007-03-08 | 2007-09-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-09-06 | 2011-03-08 | 2011-09-07 | $7700.00 | Window Closed / Lapsed |