|
|
DB Query is a distributed client-server database query tool,
which offers universal solution for remote access through Internet/Intranet
to various databases.
DB Query is an end user tool.
Using this software, user can build a complex queries and receive all
necessary information from databases,
without any knowledge of the SQL language and a real structure of database.
This product was developed for databases owners, who wish to supply own users
by the universal query tool to access to their databases.
DB Query provides reliable, safe and controlled access to various databases
for usual users, who are not possessing high qualification.
DB Query is a multi-tiered distributed client-server application.
It is partitioned into two logical units which run in conjunction on separate
computers and consists of thin client and application server.
DB Query client
DB Query client is installed on the end user's computer. It is
a simple and not demanding to resource program (thin client), running
under Windows systems, has a friendly interface and allows to build database queries
quite simply. For querying on
databases access schemes are used.
These schemes are information model of the related database tables which are simple
for perception by the end-users.
When client formed the query, it passes it to DB Query server.
The server processes this query and sends the result back to client for browsing.
DB Query server
The
application server is installed in a central networking location
accessible to all clients. It performs the authorized connection of clients,
granting them the individual access rights, and executes incoming queries.
Client-server interaction
Client
has not direct contacts with data sources, it interacts only with the
user and the application server. Direct access to data and database query processing
are realized on server side and is hidden from the end user. The interaction
of the client and server occurs through a local or global network (Internet) by TCP/IP
protocol.
Database protection
For
data protection against unauthorized access, application server uses authorized
client connection through it unique login and password. Besides it, client
software binds to the user's computer so, that connection to server with
given login/password becomes possible only from single workplace.
What kinds of RDBMS are supported?
Our product is independent of database platform. We tested it with
Oracle,
DB2,Interbase,MS SQL,Sybase databases as well as with local desktop
databases such as Paradox or Dbase. For access to databases application server uses Borland Database Engine,
which is capable to give access practically to all data sources, used nowadays.
What benefits of using DB Query?
- Universal solution for organising remote access to databases;
- The minimal expenses for installing of clients workplaces;
- Powerful
database protection against unauthorized access;
- Powerful administrative tools, to control clients access to databases;
Screen shots
|
Here is a main client window. With a simple mouse clicks you can
quickly build a complex database query and pass it to application server processing.
|
|
You can view the query result in a powerful and flexible grid and perform
printing/saving a whole grid or a single row.
|
|
|
The query result of complex data structures may be interpreted
in free-form manner.
|
|
To view query result the HTML format can be used.
In that case all supported HTML elements (include the graphical data) can be included in a query answer form.
|
|
Universal database query tool
