Static and dynamic reverse engineering of relational database applications: a form-driven methodology

Form-Driven Application Development

“…While in approaches presented in [1], [2] and [10], just ER diagrams are generated, IIS*Studio generates relational database schemas and executes an efficient transformation of design specifications into error free SQL specifications of relational database (db) schemas for different DBMSs ( [20], [21] and [22]). Although our research does not tackle the same problems as it is in [6] and [12], a common value is a reported necessity of the integration of independently developed database subschemas. Integration of db subschemas in [6] and [12] is done at the conceptual level.…”

“…Although our research does not tackle the same problems as it is in [6] and [12], a common value is a reported necessity of the integration of independently developed database subschemas. Integration of db subschemas in [6] and [12] is done at the conceptual level. In our approach it is done at the implementation instead of the conceptual level [23].…”

“…Database systems have been extended to deal with forms and other types of documents used to facilitate the manipulation of data via computerized form (e.g., Oracle SQL Forms, Informix-SQL, Microsoft Access Forms, different reports tools, etc.) [6].…”

“…Choobineh and Venkatraman in [11] presented a methodology and tools for derivation of functional dependencies from business form. A formbased approach for reverse engineering of relational databases is proposed by Malki, Flory, and Rahmouni [6]. This methodology uses the information extracted from both form structure and instances as a database reverse engineering input using an interaction with a user.…”

Extracting Entity Relationship Diagram from a Table-Based Legacy Database

“…Form analysis gathers information extracted from both forms structures and instances and generalizes such information into database semantics using an inference process [9] [8]. A form is any structured collection of variables, which are appropriately formatted to communicate with the database, particularly for data retrieval and data display.…”