Patent Document ID: 7933932
Application ID: 11559718
Patent Flag: 1

Claim One:
1. A system that facilitates database analysis, comprising: a processor configured to execute computer executable components stored in memory, the components including: a schema analysis component configured to analyze a schema that describes organization of a source database; a statistics analysis component configured to analyze a first set of statistics that describes at least distribution of data maintained by the source database; a database copy component configured to provide a destination database based, at least, upon the schema and generate representative data entries based, at least, on the first set of statistics and independently of the data from the source database, wherein a second set of statistics that describes data maintained by the destination database is equivalent to the first set of statistics that describes the data maintained by the source database; a populator component configured to identify a foreign key column in the source database, and populate a corresponding foreign key column in the destination database at least, in part, as a function of a parent table in the source database and the first set of statistics; and a random data component configured to generate random data entries for the at least one destination column of the destination database based, at least, on a determination that histogram data is not available from the at least one data distribution histogram for the at least one destination column of the destination database, wherein the at least one data distribution histogram is based, at least, on the source database, and a structure of the destination database is created based, at least, on the at least one data distribution histogram.