The Interactive Databases Approach to the User Interface Modeling

The proposed principle of Interactive Databases (IDB) is intended to improve client-server interaction and to avoid database integrity constraints violation. In order to make the client more clever and give it the opportunity to make preliminary decisions regarding the correctness of the transaction...

Full description

Bibliographic Details
Main Author: Egor Bugaenko
Other Authors: The Pennsylvania State University CiteSeerX Archives
Format: Text
Language:English
Subjects:
SQL
DML
Online Access:http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.48.3167
http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-10/paper6.ps
Description
Summary:The proposed principle of Interactive Databases (IDB) is intended to improve client-server interaction and to avoid database integrity constraints violation. In order to make the client more clever and give it the opportunity to make preliminary decisions regarding the correctness of the transactions without the server, we define the formal mechanism of "step-queries" definition. This mechanism is used as a tool for the conversion of the knowledge the DBMS has into the concrete collection of DML queries. Step-queries are used by the client. It sends them to the server before the transaction and the retrieves lists of possible values for the fields of the visual form. Then, these lists are used in order to give the user an opportunity to choose correct value for the given field. After the form has been completed the transaction could be filled with entered data. After the formal description of step-queries they must be mapped to DML. Here we will define the algorithm of such mapping int.