Method and system for processing dirty data

Abstract

The invention relates to a method and system for processing dirty data. The method comprises the following steps: generating a retrieve request by a client according to retrieve information inputted by a user, and transmitting the retrieve request to a processing center and a database; transmitting all inquired relevant data records to the processing center by the database; verifying and comparing all data records with data information in a state library by the processing center, gradually judging whether each data record is dirty data or not, marking all data records which are the dirty data if the dirty data exists, eliminating the data records which are marked as the dirty data, and returning all relevant records to the client if no dirty data exists; transmitting the retrieve request to the database by the processing center, re-acquiring all relevant data records from the database, and eliminating the dirty data until all requested data records are returned. By adopting the method and system, time consumption for processing complicated SQL sentences can be avoided, the data exchanging efficiency of the system also can be improved, and the user experience can be improved.

Description

technical field [0001] The invention relates to a data interaction method, in particular to a method and system for processing dirty data. Background technique [0002] The data interaction between the front end and the server is one of the core businesses of the B / S system, and efficient, fast, and real-time data interaction is the long-term goal of the system. The traditional method of processing dirty data is to use complex SQL statements, which has low execution efficiency and slow query speed. Especially the larger the data volume, the faster the query speed will drop, which greatly affects the user operation time and reduces the user experience. cause unnecessary trouble. With the development of the Internet industry and the increasing emphasis on user experience, traditional data query methods can no longer meet the needs of today's systems, especially due to the existence of dirty data, which brings certain troubles to query valid data. Contents of the invention ...

AI Technical Summary

Problems solved by technology

The traditional method of processing dirty data is to use complex SQL statements, which has low execution efficiency and slow query speed. Especially the larger the data volume, the faster the query speed will drop, which greatly affects the user operation time and reduces the user experience. bring unnecessary trouble

With the development of the Internet industry and the increasing emphasis on user experience, traditional data query methods can no longer meet the needs of today's systems, especially due to the existence of dirty data, which brings certain troubles to query valid data

Images