Spectral Code Index (SPECOIND): A General Infrared Spectral Database Search Method

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.

[1]  Stephen R. Lowry,et al.  Data base development and search algorithms for automated infrared spectral identification , 1985, J. Chem. Inf. Comput. Sci..

[2]  Donald F. Averill,et al.  Fourier transform infrared spectroscopy without an FTIR spectrometer: library searching and concise storage of spectra , 1990, J. Chem. Inf. Comput. Sci..

[3]  D. H. Anderson,et al.  Computer search system for retrieval of infrared data , 1967 .

[4]  K. Tanabe,et al.  An algorithm for astm infrared file searches based on intensity data , 1979 .

[5]  W. Simons.  The Sadtler handbook of infrared spectra , 1978 .

[6]  Stephen L. R. Ellison,et al.  Predicting chance infrared spectroscopic matching frequencies , 1998 .

[7]  Jamieson M. Cobleigh,et al.  Evaluation of a 1H-13C NMR Spectral Library , 2001, J. Chem. Inf. Comput. Sci..

[8]  F. J. Holler,et al.  Principles of Instrumental Analysis , 1973 .

[9]  R. Keller,et al.  The Sigma library of FT-IR spectra , 1986 .

[10]  R. C. Fox.  Computer searching of infrared spectra using peak location and intensity data , 1976 .

[11]  Johanna Smeyers-Verbeke,et al.  Handbook of Chemometrics and Qualimetrics: Part A , 1997 .

[12]  B. K. Alsberg.  Representation of spectra by continuous functions , 1993 .

[13]  Karl-Artur Kovar,et al.  Strategies for Constructing Near-Infrared Spectral Libraries for the Identification of Drug Substances , 1997 .

[14]  Andrew G. Glen,et al.  APPL , 2001 .

[15]  M. Munk.  Computer-Based Structure Determination: Then and Now , 1998, Journal of chemical information and computer sciences.

[17]  A. Dijkstra,et al.  Numerical taxonomy and information theory applied to feature selection from filed infrared spectra for automated interpretation , 1978 .

[18]  Elwin C. Penski,et al.  Computer storage and search system for infrared spectra including peak width and intensity , 1974 .

[19]  Jan P. Radomski,et al.  Wavelet Bases for IR Library Compression, Searching and Reconstruction , 2000 .

[20]  Kurt Varmuza,et al.  Characteristic Substructures in Sets of Organic Compounds with Similar Infrared Spectra , 2001, Comput. Chem..

[21]  Sergei V. Trepalin,et al.  CheD: Chemical Database Compilation Tool, Internet Server, and Client for SQL Servers , 2001, J. Chem. Inf. Comput. Sci..

[22]  Tao Bai,et al.  A new approach to a coding and retrieval system for infrared spectral data: The `Effective Peaks Matching' method , 2000 .

[23]  Peter de B. Harrington,et al.  Two-Dimensional Fourier Compression , 1997 .

[24]  Alexander Kai-man Leung,et al.  Application of wavelet transform in infrared spectrometry: spectral compression and library search , 1998 .

[25]  N. H. Velthorst,et al.  Identification of herbicides in river water using on-line trace enrichment combined with column liquid chromatography-Fourier-transform infrared spectrometry , 1996 .

[26]  Hideyuki Masui,et al.  SPECTRA: A Spectral Information Management System Featuring a Novel Combined Search Function , 1996, J. Chem. Inf. Comput. Sci..

[27]  D. Hummel.  Atlas of polymer and plastics analysis , 1978 .

[28]  Thomas L. Isenhour,et al.  Clipped Fourier transform mass spectral compression algorithm for microcomputer-compatible search systems , 1981 .

[29]  Chris W. Brown,et al.  Infrared Spectral Search for Mixtures in Large-Size Libraries , 1991 .

[30]  Charles J. Pouchert.  The Aldrich library of infrared spectra , 1970 .

[31]  E. K. Kemsley,et al.  Discriminant analysis of high-dimensional data: a comparison of principal components analysis and partial least squares data reduction methods , 1996 .

[32]  Plamen N. Penchev,et al.  Description and Performance Analysis of an Infrared Library Search System , 1996 .