| |
All the interfaces of ZeBAze were entirely
designed to be extremely simple to use and give you a quick and easy
understanding of the different features offered to query your database.
After you connect ZeBAze to your database and
select the data table that you want to query, three main interfaces allow
you to define your search criteria and set the search engine, to either
display the results on your screen or write them back into your
database.
|
|
This
interface allows you to define search criteria for number
or date fields and contains an interactive table
with 7 columns, each row representing the criteria of a specific field.
Several
popup windows help you to define some of the search criteria and a Tools
button allows you to reorganize or modify the table.
The red
columns (2 to 4) represent the ranking criteria and
allow you to define best, importance
and scale values for several fields. ZeBAze will
query your database and return the database rows that are the closest
to your preferences.
The blue
columns (5 to 7) represent the constraint criteria
and allow you to define minimum & maximum
values, define a list of values to match or not to match, and even use
regular expressions to create more advanced search criteria.
|
|
 |
|
|
|
|
|
This
interface allows you to define search criteria for text
or boolean fields and contains a main menu (left
side), from which to select a field and display its specific criteria
sub-interface (right side).
ZeBAze
proposes you a unique process for boolean fields and two different
kinds for text fields, presented as follows :
The first
text process, very easy to use, allows you to define two lists of words
(or sentences) that you want and do not want to find inside the value
of a text field. ZeBAze will only return the database rows in which the
field's value contains at least one of the good
words and none of the bad words.
The second
text process, more powerful and complex, allows you to create a
combination of several regular expressions with the help of a table in
which each double-column row is an AND NOT operator
and all rows are linked with an OR operator. ZeBAze
will only return the database rows in which the field's value matches
the final combination of regular expressions.
|
|
 |
|
|
|
|
|
This
interface contains 2 sub-interfaces, to use depending on whether you
want to display the search results on your screen or write them back
into your database.
The Display
sub-interface allows you to select which fields you want to display and
how many results you want. A click on the Start Display
Process button will open a popup window with real-time
information about the search engine's progression and your search
results will be displayed in a new window.
The Write
sub-interface allows you to select a primary key, define the name and
default value of the new field and define how many results you want to
write. A click on the Start Write Process button
will open a popup window with real-time information about the search
engine's progression and the writing of the search results in the newly
created field (column) of your database.
|
|
 |
|
|
|
|
|
If you want
to display the search results on your screen, they will be presented as
a data table in a new window, in which a menu bar offers you several
options to sort, modify or print the search results.
Each column
of the table represents one of your database's fields (selected in the
previous Display interface) and each line
represents one of your database's rows.
Each
column's header contains its field's name, and its background color
represents the type of search criteria : red if ranking
(with or without constraint), blue if only constraint
and gray if none.
If any of
your fields has a ranking value, a column with no
header will be added to the left side of the table (as in the following
example). The numbers written in red in this column represent the final
ranking position of each row, in comparison with your search
preferences.
|
|
 |
|
|
|
|
|