Patent ID: 8195621

Claim:
A method of managing schema changes made by a user to an object in a database, the method comprising: a) intercepting a database command entered by said user; b) if said database command is a schema change command referencing said object in said database and a registry criterion is met, then inserting said database command or a command derived therefrom into a registered storage, otherwise releasing said database command to said database for execution thereby; c) releasing said database command or a command derived therefrom from said registered storage to said database for execution thereby when a release criterion is met thus giving rise to a released command; and upon obtaining a rollback command, restoring said object in said database to a former version, indicated by said rollback command; wherein said former version is indicated by said rollback command by specifying one of said released command or said command derived therefrom stored in said history storage; wherein said rollback command is of type project rollback command, said method further comprising: i) defining an object referenced by the released command specified by the rollback command giving rise to a rollback object; ii) defining at least one project associated with said rollback object giving rise to a rollback project; iii) defining all objects associated with said rollback project giving rise to project objects; iv) defining the execution time of the released command specified by said rollback command giving rise to execution time; and v) restoring said project objects to a former version, said version corresponds with said objects' version at said execution time; d) inserting said released command or a command derived therefrom into a history storage.