Patent ID: 8527552

Claim:
A computer implemented method for database consistent sample data extraction comprising: receiving a selection of a source database system; receiving a selection of one or more tables from the source database system; identifying one or more master tables from the one or more selected tables, the one or more master tables connected to one or more dependent tables by: defining oriented cardinalities of tables from a schema comprising the selected tables and their related tables; and defining paths using the oriented cardinalities; receiving a selection of sample data extraction variant for extraction of sample data from the one or more master tables; filtering the one or more dependent tables to keep valid joins between the sample data of the one or more master tables and the one or more dependent tables by following join cardinalities to reach the one or more dependent tables starting from the one or more master tables; and generating a sample database from the sample data of the one or more master tables and the filtered dependent tables.