11. The method of claim 1 , further comprising: generating a sample database having an identical schema as that of an original database using a database sampler module, wherein the sample database comprises a potentially biased random sample of all relations with a reduced set of data; executing the subsequent query efficiently through use of the sample database to enable the user reduce a time in debugging the subsequent query; and computing the estimated data profile from the sample database.
1. A method of a query editor comprising: generating a data profile comprising a set of characteristics captured at various granularities of an initial result set generated from an initial query using a processor and a memory; determining what a user expects in at least one of the initial result set of the initial query and a subsequent result set of a subsequent query based on one of the data profile and a heuristically estimated data profile; enabling the user to evaluate a semantic accuracy of the subsequent query based on a likely expectation of the user as determined through the set of characteristics of the data profile; determining a match ratio between the subsequent query and the initial query; and presenting at least some of the set of characteristics of the data profile to the user based on the match ratio through the query editor.