Create a new
Identification view as database tab for spectral database search.
Each database tab holds one database and consists of four subdivisions
(select as vertical tabs on the left side):
1) Database Structure: enter a database name and default
file pathes, give a description, define descriptor categories
and list descriptor values. "Method" is a mandatory
descriptor, containing measurement methods as values.
2) Database Content: listing of reference entries, set
reference ID, assign descriptor values, display reference spectra,
search for reference entries
3) Search definition: create search definitions , restrict
searches to parts of the database, combine and weight search definitions
for combined result assessment
4) Search Execution & Results: load sample spectra,
select search definitions, review search results, display sample
spectra and best hits from database. Save and reload search results,
export results to Excel, create PDF search reports sample-wise.
Structure: default descriptor "method" + one
user-defined descriptor ("origin"). Name and description
entered by user.
Content: list of loaded reference spectra below, reference
ID edited, three reference spectra selected and shown in the
Definition: with two defined searches, differing in the
used x axis range. Combine searches by using the same search
Results: after loading a sample spectrum, selecting a
search type and executing the database search, an ordered
reference hit list is shown and can be displayed in plot above.
back to top>
creation & configuration
database consists of three files:
*.sgdd: contains the database definition (first vertical
*.sgdr: contains the database content, the reference entries
(second vertical tab)
*.sgds: contains the search definitions (third vertical
Additionally, *.sgsr: contains search results consisting
of sample spectra and a hit list (fourth vertical tab)
For creating a new database, start in the first
vertical tab (Database Structure). Enter a database name and
a database description into the edit box on the right side. Optionally,
a default filepath for the database files and for the reference
spectra's original files can be defined. To better describe and
categorize the database's reference entries, add your own descriptors
and define a range of allowed descriptor values. These
can be any kind of alphanumeric content. Additional rows can be
created by pressing CTRL+ArrowDown within a cell from the lowest
row. When finished with this tab, save the database with the [Save
Database...] button. Saved databases are loaded with the [Load
add reference spectra (all file formats, including OMNIC database
files *.lbt/ *.lbd) with the [Import Reference Spectra ...] button.
This happens in the second
vertical tab.(Database Content). For every loaded reference
spectrum, the "method" descriptor gets filled automatically,
the "name" column is equivalent to the legend text (can't
be edited), the unique db ID is assigned and, depending on
the choosen options a reference ID is assigned. The reference
ID can be edited and helps to assign and classify reference entries.
There is a multitude of options for creating the reference ID from
the legend text, filename or foldername. The same reference ID can
be used for multiple reference entries. This allows to group several
spectra of the same reference material, even from different measurement
If there are user-defined descriptor categories, they are listed
in columns right to the "method" column. For each reference
spectrum, a descriptor value can be choosen from the cell's dropdown
list. When creating new descriptor categories of descriptor values
after loading reference spectra, these are only available here after
saving the database once more.
For showing reference spectra in the above plot window, select them
in the "show" column. Clicking the checkbox in the "show"
column's first row, results in showing/ hiding all reference entries
(not wise if there are thousands).
The columns for reference ID and descriptor values each can be filtered
for certain content, in order to show only a certain part of the
reference entries. The search bar at the bottom allows to search
for any text in the grid above.
After adding new reference entries, save the
database before executing a search!
use the third
vertical tab (Search Definition) to create search definitions.
Start with the "compare the" column and select an algorithm
from the dropdown list. When nothing special is desired, try first
the "spectral similarity" algorithm. It works with
all kind of spectra (UV-VIS absorbance and transmittance, NIR, FTIR,
Raman, ...) and is based on calculating a full-spectrum Pearson
correlation coefficent. Depending on the algorithm, some options
for restricting the x axis range are available. Select one from
the "x axis range" column and enter the numbers on the
right into the appropriate cells. All algorithms can be applied
to the original spectrum, as well as to a smoothed spectrum and
first and second derivatives. While executing searches, the same
transformation is temporarily applied to the reference spectra.
By choosing a dedicated descriptor value within the "method"
column and all user-defined descriptor columns to the right, the
search range can be restricted to matching reference entries.
Search definitions sharing the same name ("search name"
column) are executed together and give one common result and rating
value. To visualize such search groups, click the check box in the
first-row, leftmost cell (see left). For search groups, the result
impact of each search definition can be weighted by changing the
value in the "result impact" column.
Search rows can be removed by simply pressing DEL key. Additional
rows can be created by pressing CTRL+ArrowDown within a cell from
the lowest row. The [Load Search Definitions] allows to load a saved
search definition (file type *.sgds) and add the search defnition
to the current list of search definitons.
After changing searches or defining new searches,
save the database before executing a search!
back to top>
The real searching
happens in the fourth
vertical tab (Search Execution & Results). For any sample
spectrum to search, load it first with the [Load Sample Spectra...]
button. It is selected by default for searching (checkbox in "search"
column) and the first search definition from the list of search
definitions is selected in the "search name" column,
also by default. Both can be changed as needed. The sample ID
can be edited. As with reference spectra, a "sample"
can also consist of several spectra of one or multiple types,
to cover cases where several spectra describe one sample. As with
the reference ID, the creation of the sample ID can be directed
by changing the options in the options dialog.
Execute the search with the [Execute Database Search] button.
Searches are comparing the sample spectrum against all reference
spectra according to the selected search definition, restricted
by descriptor selection and spectral method (only reference spectra
with same method type are considered). As output, an ordered list
of search hits are shown, with the hit rating value and the descriptor
values of the found reference entries. Search results can be saved
with the [Save Search Results...]. the number of displayed hits
can be changed on the fly from the options dialog, as well as
the number of saved hits. With the [Load Search Results...], previously
saved search results can be loaded again into the same grid. .
The sample spectrum together with the best reference hits can
be displayed in the plot above by clicking the checkbox in the
"show" column. The search bar at the bottom allows to
search for any text in the grid above.
back to top>
Here you can
transfer the search results to Excel, either as one Excel file
per sample (the upper left button) or else all results into a
big single file (the lower button). The created Excel files will
be instantly opened into Excel for review, if the option was set
in the options dialog.
The [Create PDF Search Report(s)] allows to create a configurable
and layouted PDF file that can serve as printable report. In the
options dialog (see left), company name, address and logo can
be entered. This will make up the header of the Search report.
It further contains information about the used database (name
& description), information about the searched sample (sample
ID and according spectrum names), and finally the search results
with best hit, hit table and a plot of sample spectrum with best
hits. One search report is created per sample ID, and get's created
for all present samples. Created reports get opened in your systems
PDF reader, if the option was set in the options dialog.
In the options dialog, the report's page format can also be set.
Additionally, All described database search options available
in the options dialog can be permanently set ("Keep options
permanently") with the general options feature from the "File"
menu, so that they are already set after the next software start..
back to top>