Database sampling

摘要

The present subject matter relates to systems and methods for database sampling. The method comprises identifying at least one query table and one or more associated tables amongst a plurality of tables in a production database, based on filtering criteria. Further, the method comprises generating a key value list for the at least one query table and each of the one or more associated tables based on an order indicated by an order list. Based on the generated key value list, the sample data is extracted in a reverse order indicated by the order list, from the at least one query table and each of the one or more associated tables.

主权项

1. A method for database sampling, the method comprising:
identifying at least one query table and one or more associated tables amongst a plurality of tables in a production database, wherein the one or more associated tables are related to the at least one query table; generating a key value list for the at least one query table and each of the one or more associated tables, based on an order indicated by an order list, wherein the generating the key value list comprises deriving a set of values from key columns of the at least one query table and the one or more associated tables by:
executing a filtering criteria on the at least one query table and the one or more associated tables,based on the execution of the filtering criteria on the at least one query table, obtaining primary key values for the at least one query table to provide a key value list for the query table, andobtaining a key value list for the one or more associated tables based on the key value list for the query table; and extracting sample data in a reverse order indicated by the order list from the at least one query table and each of the one or more associated tables, based on the generated key value list.