Patent ID: 8521699

Claim:
A method executed at least in part in a computing device for tracking changes in two or more tables stored in a database management system, the method comprising: detecting a change tracking request on two or more tables stored in the database management system from one or more applications; identifying the two or more tables as a collection of related tables in the database management system; determining relationships between the two or more tables in the collection of related tables; organizing the collection of related tables and the relationships between the tables together in the database management system as an entity, wherein the entity utilizes one or more of: object oriented concepts and relational concepts; identifying a root table from the collection of related tables representing the entity in the database management system; generating a relational query based on the determined relationships between the two or more tables in the collection of related tables; transforming the relational query into a union query to track the changes across the collection of related tables in the database management system; generating a change tracking query to track the changes across the collection of related tables in the database management system; reporting tracked changes on any table in the entity through the root table, wherein a tracked change is reported if an insert, update, modification, or delete occurs on any of the two or more tables in the entity; enabling two or more applications to track changes on the one or more tables in the database management system concurrently; enabling a scope mechanism for managing tracking changes on the one or more tables in the database management system by the two or more applications, wherein the collection of related tables in the database management system is organized into a plurality of scopes; associating a first collection of related tables activated for change tracking by a first application into a first scope; associating a second collection of related tables activated for change tracking by a second application into a second scope; and identifying one or more tables from the first collection of related tables and the second collection of related tables that have been associated with both the first scope and the second scope.