University of Tasmania
Browse
Spectral_code_index_(SPECOIND)_A_general_infrared_spectral_database_search_method.pdf (313.6 kB)

Spectral code index (SPECOIND): A general infrared spectral database search method

Download (313.6 kB)
Version 2 2023-06-23, 11:08
Version 1 2023-05-26, 16:35
journal contribution
posted on 2023-06-23, 11:08 authored by J Li, B Fan, JP Doucet, A Panaye
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.

History

Publication title

Applied Spectroscopy

Volume

57

Issue

7

Article number

7

Number

7

Pagination

858-867

ISSN

0003-7028

Department/School

Chemistry

Publisher

Society for Applied Spectroscopy

Publication status

  • Published

Rights statement

Copyright 2003 Society for Applied Spectroscopy

Repository Status

  • Open

Socio-economic Objectives

280105 Expanding knowledge in the chemical sciences

Usage metrics

    University Of Tasmania

    Exports

    RefWorks
    BibTeX
    Ref. manager
    Endnote
    DataCite
    NLM
    DC