Relational Database and Warehouse Subsetting

Creating a subset of a relational database involves selecting a subset of rows from each table while retaining the foreign to primary key relationships in each table. Database subsetting is a complex endeavor due to numerous challenges:  

1. When selecting a subset of rows from a table, you must also get the rows of related tables.

2. A relational constraint may be on multiple columns (Composite keys). In this case a subset of a table requires the rows of related tables using the multiple column constraint.

3. Some tables may have no foreign key columns but may have other tables that have foreign keys referencing the table. 

4. Cyclical dependencies. Table A has a foreign key to table B and table B has a foreign key back to table A. 

Windocks solves these challenges automatically with a simple visual interface.   Start by specifying a percent of the source database size, with or without bias controls, and delivery to the same or different database instance.   Windocks subsetting does not write to the source database (the one being subsetted). 

Database subsetting reduces risk by creating a smaller set of production or masked production data.  Reducing the database size also simplifies sourcing data for analytics and Machine Learning.