(DynaDBEdit): Dynamic database textbox field and validator for web and application software

Abstract

When the database tables are concerned alterations in the structure of table attributes have a direct impact on the edit fields those are used in database application software (e.g. Web pages application software). In case when any of the attributes are changed it becomes necessary for software or Web pages to be recompiled following the changes made in edit fields. This process of recompilation is a long and costly operation which means a temporary pause for transactions. For this reason that it causes important loss in financial sector. Besides the maxim of the software engineering is that the final product should require the least updating. This study offers an object and component that aims to remove the necessity for the recompilation of application software following the amendments made in the attributes. This component is a contribution to software development and maintenance for it is capable of automatically obtaining the data of domain for the attributes in database tables and controlling the data entrance process. Moreover it is also a contribution for the users and practitioners in the sense that it reduces the time required to correct the errors and to ensure data coherency database integrity. © 2007 Asian Network for Scientific Information. © 2018 Elsevier B.V. All rights reserved.