The Interactive Databases Approach to the User Interface Modeling

• Main Author: Egor Bugaenko
• Other Authors: The Pennsylvania State University CiteSeerX Archives
• Format: Text
• Language: English
• Subjects: transactions verification; client-database interaction; visual form; predicate calculus; SQL; step-query; 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

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.