Music Acoustics
Literature Database
Version 1.2

DB search Help: Advanced Search Mode

In "Advanced Search" mode the interface offers several input fields. Keep in mind, that all fields are linked logical with "and".

That means if you input an autor and a year, all Articels conaining the Autor only written in the input year are a search result.

In the search fields "Title" and "Full text search in Abstract" a so called "implied Boolean logic" is implemented.
That means, that you can input more than one word at the same time into the same field.
Use the following operators to tell the search engine how to search:

A leading plus sign indicates that this word must be present in each row that is returned.
A leading minus sign indicates that this word must not be present in any of the rows that are returned.
(no operator)
By default (when neither + nor - is specified) the word is optional, but the rows that contain it are rated higher.
( )
Parentheses group words into subexpressions. Parenthesized groups can be nested.
The asterisk serves as the truncation (or wildcard) operator. Unlike the other operators, it should be appended to the word to be affected. Words match if they begin with
A phrase that is enclosed within double quote (""") characters matches only rows that contain the phrase literally, as it was typed. The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. Nonword characters need not be matched exactly: Phrase searching requires only that matches contain exactly the same words as the phrase and in the same order. For example, "test phrase" matches "test, phrase".

If the phrase contains no words that are in the index, the result is empty. For example, if all words are either stopwords or shorter than the minimum length of indexed words, the result is empty.

The following examples demonstrate some search strings that use boolean full-text operators:

'apple banana'    Find rows that contain at least one of the two words.

'apple +juice'    Find rows that contain both words.

'apple macintosh'     Find rows that contain the word "apple", but rank rows higher if they also contain "macintosh".

'apple -macintosh'

Find rows that contain the word "apple" but not "macintosh".

'apple ~macintosh'

Find rows that contain the word "apple", but if the row also contains the word "macintosh", rate it lower than if row does not. This is "softer" than a search for '+apple -macintosh', for which the presence of "macintosh" causes the row not to be returned at all.

'apple +(>turnover <strudel)'

Find rows that contain the words "apple" and "turnover", or "apple" and "strudel" (in any order), but rank "apple turnover" higher than "apple strudel".


Find rows that contain words such as "apple", "apples", "applesauce", or "applet".

'"some words"'

Find rows that contain the exact phrase "some words" (for example, rows that contain "some words of wisdom" but not "some noise words"). Note that the """ characters that enclose the phrase are operator characters that delimit the phrase. They are not the quotation marks that enclose the search string itself.

Copyright © 1997, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices
Input fields "ISBN", "DB Id" and "Signature" ("DB Id" and "Signature" only visible for admin-license)
    This input field allow more than one search entry value.

To search for more than one ISBN code and DB Id use the COMMA as separator like: "10292837,123244623".
To search for more than one Signature use a semicolum followed by a Space as separator like: "IWK hfg4546; II zert 523"


Insert / Edit

"lc all" Button:  changes the string typed in into the "Title" field into lower case, only the first character will be upper case

"uc words" Button:  changes the string typed in into the "Title" field into lower case, the first character of each word will be upper case

Create List

For all users which are logged in with rights as administrator, it is possible to save a search result as a list:
After you have finished your selection of data-sets hit the “create list” botton located in the right side “Features” menue. A prompt will appear, question you if you want to save the list or simple display as html. Hit “OK” to save.
Now you are asked to fill out a form, including the list-name, whom you want to show your list (private / logged in / public), and to what kind of “class” or group you want to assign your list (if choose “not assigned” the list will appear as “general”, if it is not private).
Choose the name wisely, as the list name and class can be saved as key-word for all the data-sets including your list at once.
To apply the list-name and list-class as keyword just hit the selection box on the left side of the “Save Name and Class as Key Word?” text.

Editing List

To edit your lists, click the “My Profile” link located inside banner menue. Here all existing, lists are displayed.
Also "not private" lists of other users are accessible - but youre only allowed to add data sets.