Data processing and retrieval method, database, retrieval engine and system

The invention provides a data processing and retrieval method, a database, a retrieval engine and a system. The data processing method includes receiving updated data from a search engine; acquiring aprimary key, a plurality of table structure column names and a plurality of table record data corresponding to the plurality of table structure column names one by one according to the updated data;a JSON tag format process is carry out on that primary key, the column names of a plurality of table structures and the table record data to obtain the primary key formatted by the JSON tag, the column names of a plurality of table structures formatted by the JSON tag and the table record data formatted by the JSON tag; Splicing the primary key after JSON tag formatting, a plurality of table structure column names after JSON tag formatting and a plurality of table record data after JSON tag formatting to obtain splicing data; Sending the spliced data to the search engine can perform multi-column fuzzy search, conditional search and pinyin search, shorten the search time and improve the search efficiency.