Abstract
A new spectral code that can be used by Relational Database Management Systems (RDBMS) as an index for infrared (IR) spectra searches in Relational Database (RDB) is presented and its suitability is evaluated. Spectral codes are constructed for all spectra in the database as the spectral indexes and three query strings are created with the same theory used for the creation of the index code for the query spectrum. Some effects of parameters used to create index strings and query strings are discussed. All spectral searches are accomplished in structured query language (SQL) approach and the utilization examples of SQL have been shown. The sequential application of this procedure can reduce the original library of about 18 000 spectra to a few spectra that can be used as references for subsequent detailed comparison. The software developed for the proposed system is particularly suitable for spectral search and structure interpretation.
Get full access to this article
View all access options for this article.
References
1.
Derendyaev
B. G.
Makarov
L. I.
Bogdanova
T. F.
Piottukh-Peletskii
V. N.
, J. Struct. Chem. 42 , 271 (2001 ).
2.
Munk
M. E.
, J. Chem. Inf. Comput. Sci. 38 , 997 (1998 ).
3.
Penchev
P. N.
Varmuza
K.
, Comput. Chem. 25 , 231 (2001 ).
4.
Somsen
G. W.
Jagt
I.
Gooijer
C.
Velthorst
N. H.
Brinkman
U. A.
, J. Chromatogr., A 756 , 145 (1996 ).
5.
Warr
W. A.
, Chemom. Intell. Lab. Syst. 10 , 279 (1991 ).
6.Bio-Rad Laboratories, Inc : http://www.bio-rad.com.
7.Sadtler Research Laboratories , Sadtler Standard Infrared Grating Spectra (Division of Bio-Rad Laboratories , Philadelphia , 1980 ).
8.
Pouchert
C. J.
, Aldrich Library of Infrared Spectra (Aldrich Chemical Company , Milwaukee, WI , 1981 ), 3rd ed.
9.
Pouchert
C. J.
, Aldrich Library of FT-IR Spectra (Aldrich Chemical Company , Milwaukee, WI , 1985 ), 1st ed.
10.
Kelley
R. J.
, The Sigma Library of FT-IR Spectra (Sigma Chemical Co. , 1986 ).
11.
Hummel
D. O.
, Atlas of Polymer and Plastics Analysis (VCH , New York , 1985 ).
12.American Society for Testing and Materials , Alphabetical List of Compound Names, Formulae, and References to Published Infrared Spectra: An Index to 92,000 Published Infrared Spectra (ASTM , Philadelphia , 1969 ).
13.
Davies
A. N.
, Spectroscopy Europe 12 , 30 (2000 ).
14.Chemical Concepts : http://www.chemicalconcepts.com.
15.SpecInfo database : http://www.library.qmw.ac.uk/sci/cds.htm.
16.NIST Chemistry WebBook : http://webbook.nist.gov/chemistry/.
17.Integrated Spectral Data Base System for Organic Compounds (SDBS) : http://www.aist.go.jp/RIODB/SDBS/intro-en.html.
18.
Podgornaya
M. I.
Derendyaev
B. G.
, “Databases on IR spectroscopy of organic compounds”, Nauchno-Tekh. Inf., Ser. 2, No. 9 , 1 (1992 ).
19.
Meyer
M.
Weber
I.
Sieler
R.
Hobert
H.
, Jena Rev. 35 , 16 (1990 ).
20.
Gerhausser
C. I.
Kovar
K.
, Appl. Spectrosc. 51 , 1504 (1997 ).
21.
Tanabe
K.
Hayamizu
K.
Ono
S.
, Anal. Sci. 7 , 711 (1991 ).
22.
Averill
D. F.
Baird
K. C.
Hopkins
L. L.
Yerkes
M. J.
, J. Chem. Inf. Comput. Sci. 30 , 133 (1990 ).
23.
Jarvis
T. D.
Kalivas
J. H.
, Anal. Chim. Acta 272 , 53 (1993 ).
24.
Smith
S. K.
Cobleigh
J.
Svetnik
V.
, J. Chem. Inf. Comput. Sci. 41 , 1463 (2001 ).
25.
Trepalin
S. V.
Yarkov
A. V.
, J. Chem. Inf. Comput. Sci. 41 , 100 (2001 ).
26.
Lowry
S. R.
Huppler
D. A.
Anderson
C. R.
, J. Chem. Inf. Comput. Sci. 25 , 235 (1985 ).
27.
Cai
C.
De Harrington
P.
Davis
D. M.
, Anal. Chem. 69 , 4249 (1997 ).
28.
Lam
R. B.
Foulk
S. J.
Isenhour
T. L.
, Anal. Chem. 53 , 1679 (1981 ).
29.
Leung
A. K.
Chau
F.
Gao
J.
Shih
T.
, Chemom. Intell. Lab. Syst. 43 , 69 (1998 ).
30.
Walczak
B.
Radomski
J. P.
, Data Handl. Sci. Technol. 22 , 291 (2000 ).
31.
Lo
S. C.
Brown
C. W.
, Appl. Spectrosc. 45 , 1628 , (1991 ).
32.
Alsberg
B. K.
, J. Chemom. 7 , 177 (1993 ).
33.
Kemsley
E. K.
, Chemom. Intell. Lab. Syst. 33 , 47 (1996 ).
34.
Hideyuki
M.
Mototsugu
Y.
, J. Chem. Inf. Comput. Sci. 36 , 294 (1996 ).
35.
Drobyshev
Y. P.
Nigmatullin
R. S.
Lobanov
V. I.
Korobeinicheva
I. K.
Bochkarev
V. S.
Koptyug
V. A.
, Vestn. Akad. Nauk SSSR 40 , 75 (1970 ).
36.
Penski
E. C.
Padowski
D. A.
Bouck
J. B.
, Anal. Chem. 46 , 955 (1974 ).
37.
Fox
R. C.
, Anal. Chem. 48 , 717 (1976 ).
38.
Heite
F. H.
Dupuis
P. F.
Van't Klooster
H. A.
Dijkstra
A.
, Anal. Chim. Acta 103 , 313 (1978 ).
39.
Ellison
S. L.
Gregory
S. L.
, Anal. Chim. Acta 370 , 181 (1998 ).
40.
Skoog
D. A.
West
D. M.
, Principles of Instrumental Analysis (Saunders , Philadelphia , 1980 ), 2nd ed. , p. 232 .
41.
Anderson
D. H.
Covert
G. L.
, Anal. Chem. 39 , 1288 (1967 ).
42.
William
W. S.
, The Sadtler Handbook of Infrared Spectra (Sadtler Research Laboratories , Philadelphia , 1978 ).
43.
Tanabe
K.
Tamura
T.
Hiraishi
J.
Saeki
S.
, Anal. Chim. Acta 112 , 211 (1979 ).
44.
Lau
O.
Hon
P.
Tao
B.
, Vib. Spectrosc. 23 , 23 (2000 ).
45.
Penchev
P. N.
Sohou
A. N.
Andreev
G. N.
, Spectrosc. Lett. 29 , 1513 (1996 ).
46.
Penchev
P. N.
Kotchev
N. T.
Andreev
G. N.
, Dokl. Bulg. Akad. Nauk. 51 , 67 (1998 ).
47.
Massart
D. L.
Vandeginste
B. G. M.
Buydens
L. C. M.
De Jong
S.
Lewi
P. J.
Smeyers-Verbeke
J.
, Handbook of Chemometrics and Qualimetrics: Part A (Elsevier , Amsterdam , 1997 ).