Method for facilitating development and testing of relational database application software

摘要

A method for allowing individual user entities access to tables in a database, such as a DB2 database, in an isolated manner, that is, without interfering with each other. For each original database table, DDL statements are employed to create a new table. Within the new table are defined the same columns that are defined in the original database table, as well as an additional column that includes a User Identification. A view is created having the same name and column definitions as the original database table, where the view selects only the rows in the new table in which the User Identification matches a particular user entity. For each particular user entity, access is allowed to the view for executing DML statements of the application program without modification of the DML statements of the application program other than for purposes of developing and testing functionality of the application program.