|
|
DB query
-
Version
1.3
This distributed client/server application offers
technology of database querying for users, not
possessing knowledge of the SQL language. DB Query is
a multi-tiered client-server application. It is
partitioned into two logical units which run in
conjunction on separate computers and consists of thin
client and remote server. 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 make database search requests quite simply.
For searching in databases the access schemes are
used. These schemes are clear for perception
information model of the related database tables.
Having formed the request, client sends it to remote
server processing. The Remote 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 search queries. Client has not
direct contacts with data sources, it interacts only
with the user and the remote server. Direct access to
data and search request 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 by TCP/IP protocol. For data
protection against unauthorized access, 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. 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 remote server uses Borland Database Engine,
which is capable to give access practically to all
data sources, used nowadays.
|