Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

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

Jian Feng Li1, Bo Tao Fan, Jean-Pierre Doucet

  • 1Interfaces, Traitements, Organisation et Dynamique des Systèmes, CNRS UMR 7086, Université Paris 7, 1, rue Guy de la Brosse, 75005 Paris, France.

Applied Spectroscopy
|December 9, 2003
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Data-driven remaining useful life prediction based on domain adaptation.

PeerJ. Computer science·2021
Same author

Identification of interferon-γ-inducible-lysosomal thiol reductase (GILT) gene in goldfish (Carassius auratus) and its immune response to LPS challenge.

Fish & shellfish immunology·2014
Same author

Surface analysis using shell-isolated nanoparticle-enhanced Raman spectroscopy.

Nature protocols·2012
Same author

Duplex quantitative real-time PCR assay for the detection and discrimination of the eggs of Toxocara canis and Toxocara cati (Nematoda, Ascaridoidea) in soil and fecal samples.

Parasites & vectors·2012
Same author

High efficient expression of bioactive human BMP-14 in E. coli using SUMO fusion partner.

The protein journal·2011
Same author

The antibacterial peptide ABP-CM4: the current state of its production and applications.

Amino acids·2011
Same journal

EXPRESS: Deterministic Compressed Sensing in Time-Domain Spectroscopy.

Applied spectroscopy·2026
Same journal

EXPRESS: Multi-Parameter Wavelength Characterization of Array Spectrometers Under Near-Limit Sampling Conditions.

Applied spectroscopy·2026
Same journal

EXPRESS: A Validated Reference Database for Twentieth-Century Cd-Based Pigments: Integrated Structural and Compositional Characterization.

Applied spectroscopy·2026
Same journal

EXPRESS: Two-Trace Two-Dimensional (2T2D-COS) in the Analysis of Brain Tissue Sample Preparation Method.

Applied spectroscopy·2026
Same journal

EXPRESS: Simplified Protocol for Analyzing Polarization Properties of Scanning Tunneling Microscope (STM) Light Emission Spectra at an Oblique Angle.

Applied spectroscopy·2026
Same journal

EXPRESS: Monitoring a Polyurethane Synthesis by Fiber-Coupled Attenuated Total Reflection Fourier Transform Infrared Spectroscopy and Multivariate Curve Resolution-Alternating Least Squares.

Applied spectroscopy·2026
See all related articles

A novel spectral coding method enhances infrared spectra searches in relational databases. This approach efficiently indexes and retrieves spectral data using SQL, significantly reducing comparison sets.

Area of Science:

  • Analytical Chemistry
  • Computer Science
  • Database Management

Background:

  • Infrared (IR) spectra searches in large databases are computationally intensive.
  • Existing indexing methods for spectral data may lack efficiency for relational database management systems (RDBMS).
  • Efficient retrieval of spectral information is crucial for chemical structure interpretation and material identification.

Purpose of the Study:

  • To introduce and evaluate a new spectral coding technique for indexing infrared spectra within relational databases.
  • To demonstrate the suitability of this spectral code for efficient spectral searching using SQL.
  • To assess the impact of parameter choices on the performance of spectral indexing and querying.

Main Methods:

  • Development of a novel spectral coding algorithm for IR spectra.

Related Experiment Videos

  • Construction of spectral codes as indexes for a relational database (RDB).
  • Generation of query strings using the same methodology as index code creation.
  • Implementation of spectral searches using structured query language (SQL).

    • Main Results:

    • The proposed spectral code effectively serves as an index for IR spectra in RDBMS.
    • SQL-based spectral searches significantly reduce the number of spectra requiring detailed comparison (e.g., from 18,000 to a few).
    • The developed software facilitates efficient spectral searching and aids in chemical structure interpretation.

    Conclusions:

    • The new spectral coding method provides an efficient solution for IR spectral searching in relational databases.
    • The SQL-based approach streamlines the process, making it suitable for large spectral libraries.
    • This technique enhances the capability of RDBMS for spectral data management and analysis.