In the simple search mode, you can search the database by defining a simple logical formula composed of keywords (and their items by request) and AND/OR/BUT NOT operators.
Figure 1 shows an initial screen of the simple search.
Fig. 1. An initial screen of the simple search.
Figure 2 shows a screen defining 2 keywords, Andrena (Larandrena) echizenia in the item "scientific name" and Andrenidae in the item "Family". In the screen, the item for the 2nd keyword is just selecting from the pull down menu.
Fig. 2. A screen for defining keywords
When the search succeed, the result is shown as in Fig. 3.
Fig. 3. A screen of result of search.
Click the Arrow Link to display the retrieved records.
Figure 4 shows a screen displaying retrieved records.
Fig. 4. A screen displaying retrieved records
In the advanced search mode, you can search the database by specifying more complicated logical formulas composed of keywords (their items for request), logical operators, comparison operators and arithmetic operators. The search is performed simultaneously.
Figure 5 shows an initial screen of the advanced search. In this mode, there are three fields for inputting keywords and their items, for selecting files, and for specifying logical formulas composed by keywords and operators.
Fig. 5. An initial screen of the advanced search.
In Fig. 6., 3 keywords, Andrena in the item "scientific name", Andrenidae in the item "Family" and HIRASHIA in the item "Author" are defined as Z1, Z2 and Z3 respectively. Z1.Z2 (Z1 and Z2), Z1.Z2.Z3 (Z1 and Z2 and Z3), Z1.(Z2,Z3) (Z1 and (Z2 or Z3)), Z1.Z2.^Z3 (Z1 and Z2 and (not Z3), that is Z1 and Z2 but not Z3) are also defined as logical formulas. You can retrieve multiple logical formulas simultaneously like this.
Fig. 6. A screen for definig keywords
When the search succeed, the result is shown as in Fig. 7.
Fig. 7. A screen of result of search
Please display the record that double-clicks the Arrow (link) displayed in detail and was retrieved.
Figure 8 shows a screen displaying retrieved records.
Fig. 8. A screen displaying retrieved records
A logical formula is composed of keywords (and their items for request), logical formulas, integers, logical operators (","(OR), "."(AND), "^"(NOT)), comparison operators ("<", ">", "<=", ">=", "<>"), arithmetic operators ("+", "-", "*", "/") and parentheses("(", ")").
The logical operators are interpreted as follows.
| A,B | 1 (if A > 0 or B > 0) | 0 (otherwise) |
| A.B | 1 (if A > 0 and B > 0) | 0 (otherwise) |
| ^A | 1 (if A is not positive) | 0 (otherwise) |
The precedence and meaning of operators are as follows.
The highest precedence is 1.
| Operator | Precedence | Meaning |
|---|---|---|
| * | 1 | multiplication |
| / | 1 | division |
| + | 2 | addition |
| - | 2 | subtraction |
| = | 3 | equal to |
| <= | 3 | less than or equal to |
| >= | 3 | greater than or equal to |
| < | 3 | less than |
| > | 3 | greater than |
| <> | 3 | not equal to |
| ^ | 4 | not |
| . | 5 | and |
| , | 6 | or |