Full Description:
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.