The main thing to uncover the distance and the concentration queries from the log files of SQL where the neighbor which is nearest to search that is compulsory for each point. The existences are detected in the databases is a necessary procedure in knowledge discovery and for recovering critical data. Many methods which are implemented for this are unproductive in finding a precise outline owing to the pattern. So, here we need to approve the assignment as an evaluation of a structure which is the subset minority which brings the easy description to subset preserving the integrity. We are finding a new way of discovering the patterns. There are some attributes which take a dynamic part for the inspection of patterns; we have the different pattern nature, the rate and the time between one work and other. The means of generating the patterns is to recognize any modification has happened in the data, so system sends the mail to higher officials. This technique helps in finding up the miscreant activities and to prevent these. So we here are evolving a new technology which enables us to stop these illicit activities. © 2016, International Journal of Pharmacy and Technology. All rights reserved.