Method and device for merging and classifying massive SQL (Structured Query Language) sentences

The invention provides a method and a device for merging and classifying massive SQL (Structured Query Language) sentences. The method comprises the steps of S1, analyzing database environment and collecting all SQL sentences in the operating system; S2, parsing the SQL sentences to obtain variable values in the SQL sentences; replacing the variable values with constants to obtain parsed SQL sentences; and S3, calculating and obtaining HASH values of parsed SQL sentences, classifying and merging the SQL sentences according to the HASH values, and storing results after classifying and merging, wherein SQL sentences which are same after being parsed are similar SQL sentences. According to the technical scheme, similar SQL sentences and unique HASH values are obtained, so that the SQL sentences are merged and classified. For a system audited and monitored in same operation repeated, the space occupied by original SQL sentences is greatly reduced, thus, the storage space is greatly saved, and the data inquiry eff