Short message sensitive word rapid detection method and system

By establishing character tables and sensitive word tables, building SQL query statement conversion methods, and using the database engine to perform XOR operation matching, solving the problem of unsupported and poor performance of SMS sensitive word matching in the existing technology, achieving efficient and Accurate SMS sensitive word detection reduces operational costs and workload.

CN119204001APending Publication Date: 2024-12-27CHANGXUN COMM SERVICE CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411250166.9
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-09-06
Publication Date
2024-12-27

AI Technical Summary

Technical Problem

The existing SMS sensitive word matching method is based on regular expressions, and there are logical operations that do not support, complex disassembly, and low performance, making it difficult to cope with the demand for large-scale SMS content retrieval, resulting in low detection accuracy, high cost and low efficiency.

Method used

By establishing a character table and sensitive word table, building a SQL query statement conversion method, splitting sensitive phrases into independent sensitive words, using the database engine to perform XOR operation matching, generating SQL query commands, and realizing logical operations and efficient matching.

Benefits of technology

It improves matching speed and accuracy, reduces maintenance costs, enhances the scalability and maintainability of the system, supports large-scale data processing, and meets the rapid screening needs of massive SMS content.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119204001A_ABST
    Figure CN119204001A_ABST
Patent Text Reader

Abstract

The invention discloses a short message sensitive word rapid detection method and system, which converts a matching problem of a sensitive word group into an SQL query problem, can greatly improve the matching speed by utilizing the efficient processing capability of a database engine, and can greatly improve the matching efficiency compared with the traditional character string matching based on a regular expression. Through the combination of the XOR operation and the SQL query statements, the problems of complexity and low performance of regular expressions are avoided, particularly, the defect that the regular expressions do not support logic NOT operation is overcome, through conversion of the SQL query statements, complex logic combinations can be flexibly processed, more accurate matching can be achieved, and when a sensitive phrase library is updated, the sensitive phrase library can be quickly updated. By constructing an automatic conversion mode of the sensitive word list and the SQL query statement, the maintenance cost is greatly reduced, the expandability and maintainability of the system are improved, and compared with a traditional character string matching method, the system is more stable and reliable due to the fact that a database engine is adopted to process logic operation.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of short message sensitive word detection, and in particular to a method and system for quickly detecting short message sensitive words. Background Art

[0002] With the rapid development of mobile communication technology, text messages, as an important way of information transmission, play a vital role in people's daily lives.

[0003] The existing tools and computing resources of SMS operators are limited, making it difficult to conduct large-scale matching of sensitive words in SMS.

[0004] Traditional sensitive word matching methods are mostly based on regular expressions for string matching, but this method has obvious limitations. First, regular expressions do not support the "not" operation of logical operations, which means that sensitive phrases containing "not" operations need to be manually disassembled into multiple "and or" sub-combinations, increasing the workload and error rate. Secondly, with the continuous increase and update of the number of sensitive phrases, this disassembly work becomes more cumbersome and complicated, greatly increasing the operating costs of operators. In addition, regular expressions require a large number of rollback operations when performing logical matching, resulting in poor matching performance, which makes it difficult to cope with the current large-scale SMS content retrieval needs. Summary of the invention

[0005] In view of this, the present invention proposes a method and system for quickly detecting sensitive words in short messages, which can solve the defects of low detection accuracy, high cost and low efficiency in the prior art.

[0006] The technical solution of the present invention is achieved in this way:

[0007] A method for quickly detecting sensitive words in short messages, specifically comprising:

[0008] Establish a character table to uniformly number Chinese characters and assign a corresponding positive integer code to each character;

[0009] Construct a sensitive word list to split the logically combined sensitive word group into a set of multiple independent sensitive words, and format these independent sensitive words;

[0010] Construct SQL query statement conversion method to convert single sensitive words and logically combined sensitive words into SQL query statements;

[0011] Set up an SQL index table to record the positional relationship between independent sensitive words in SQL query statements and placeholders in SQL statements;

[0012] Get the SMS to be tested;

[0013] According to the character table, convert the SMS content to be detected into a digital array;

[0014] According to the constructed SQL query statement conversion method, the digital array of the SMS is XOR-matched with the sensitive word table, and the SQL query command of the SMS is generated according to the SQL index table;

[0015] Use the database engine to execute the command and determine whether the text message matches the sensitive phrase based on the execution result.

[0016] As a further optional solution of the method for quickly detecting sensitive words in short messages, the formatting of these independent sensitive words specifically includes:

[0017] Align the length of all sensitive words to the maximum length;

[0018] Use the established character table to replace each character in the sensitive word with the corresponding positive integer code;

[0019] The replaced positive integer code is stored in the sensitive word table according to a predetermined format.

[0020] As a further optional solution of the method for quickly detecting sensitive words in short messages, the SQL query statement conversion method converts a single sensitive word and a logically combined sensitive phrase into an SQL query statement, specifically including:

[0021] Convert single sensitive words and logically combined sensitive words into placeholders in SQL statements;

[0022] According to the logical operation relationship in the sensitive phrase, the converted placeholders are connected using SQL logical operators to form an SQL query statement.

[0023] As a further optional solution of the method for quickly detecting sensitive words in short messages, the setting of the SQL index table specifically includes:

[0024] Setting keyword encoding, which is used to represent each keyword in the character table, wherein the keyword includes a sensitive word or a combination of sensitive words;

[0025] Set the placeholder position index to correspond to the keyword code and record the position index of the placeholder corresponding to the keyword in the SQL query statement;

[0026] Set the SQL statement structure to build a SQL query statement framework that includes all sensitive word placeholders.

[0027] As a further optional solution of the method for quickly detecting sensitive words in short messages, the SQL query statement conversion method constructed according to the method performs XOR operation matching on the digital array of the short message and the sensitive word table, and generates the SQL query command of the short message according to the SQL index table, specifically including:

[0028] According to the SQL query statement conversion method that has been constructed, the digital array of the SMS is matched with the sensitive word list through window sliding. In this process, the digital array of the SMS is matched with the sensitive word list through XOR operation. If the result of the XOR operation is zero, it means that the SMS content in the current window successfully matches a sensitive word. According to the positional relationship between the keywords and placeholders recorded in the SQL index table, the corresponding placeholder position in the SQL query statement is found, and the placeholder at that position is modified to generate the SQL query command for the SMS.

[0029] As a further optional solution of the method for quickly detecting sensitive words in SMS, before performing window sliding matching between the digital array of the SMS and the sensitive word list, first determine whether the first number of the digital array of the SMS is included in the sensitive word list. If it is included, sliding matching is performed, otherwise the line is directly changed.

[0030] A system for quickly detecting sensitive words in short messages, comprising:

[0031] A character table building module is used to uniformly number Chinese characters and assign a corresponding positive integer code to each character;

[0032] The sensitive word list construction module is used to split the logical combination sensitive word groups that need to be matched into non-repeating independent sensitive words, and format these sensitive words to align their lengths and encode them;

[0033] SQL query statement conversion module, used to convert single sensitive words and logically combined sensitive word groups into SQL query statements, including the conversion of logical operators to adapt to different database engines;

[0034] SQL index table building module, used to record the position relationship between independent sensitive words in SQL query statements and placeholders in SQL statements;

[0035] The SMS content processing module is used to obtain the SMS content to be detected and convert it into a digital array according to the character table;

[0036] The matching and generation module is used to perform XOR operations on the digital array of the SMS and the sensitive word list, and generate the SQL query command of the SMS based on the matching results and the SQL index table;

[0037] The database execution module is used to use the database engine to execute the generated SQL query command and determine whether the text message matches the sensitive phrase based on the execution result.

[0038] As a further optional solution of the system for quickly detecting sensitive words in short messages, the system further includes:

[0039] The judgment module is used to judge whether the sensitive word list contains the first number of the SMS digital array before performing XOR operation matching on the SMS digital array and the sensitive word list. If it does, XOR matching is performed; otherwise, the line is directly changed.

[0040] A computing device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps of the method for quickly detecting sensitive words in short messages are implemented.

[0041] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the steps of the method for quickly detecting sensitive words in short messages.

[0042] The beneficial effects of the present invention are: the matching problem of sensitive phrases is converted into an SQL query problem, and the efficient processing capability of the database engine is utilized to greatly improve the matching speed. Compared with the traditional string matching based on regular expressions, the present invention avoids the complexity and low performance problems of regular expressions through the combination of XOR operation and SQL query statements, and especially solves the defect that regular expressions do not support logical "not" operation. The traditional sensitive word matching method is often unable to cope with sensitive phrases containing complex combinations of logical "and", "or", "not", etc., while the present invention can flexibly process these complex logical combinations through the conversion of SQL query statements to achieve more accurate matching. When the sensitive phrase library is updated, Traditional matching methods may require manual re-disassembly and reconfiguration of matching rules, which is labor-intensive and prone to errors. The present invention greatly reduces maintenance costs and improves the scalability and maintainability of the system by constructing a sensitive word list and an automatic conversion method for SQL query statements. Since a database engine is used to process logical operations, the system of the present invention is more stable and reliable than traditional string matching methods. The database engine has a natural advantage in processing large-scale data and complex logical operations, and can ensure the stable operation of the system. In the current context of a large number of text messages and diverse content, the fast matching method provided by the present invention can support large-scale data processing and meet the needs of operators for rapid screening of massive text message content. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0044] Figure 1 A schematic diagram of the steps of a method for quickly detecting sensitive words in short messages provided by an embodiment of the present invention;

[0045] Figure 2 A schematic diagram of the composition of a system for quickly detecting sensitive words in short messages provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0046] The technical solutions in the embodiments of the present invention are described clearly and completely below. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0047] refer to Figure 1 to Figure 2 , a method for quickly detecting sensitive words in short messages, specifically comprising:

[0048] Establish a character table to uniformly number Chinese characters and assign a corresponding positive integer code to each character;

[0049] Construct a sensitive word list to split the logically combined sensitive word group into a set of multiple independent sensitive words, and format these independent sensitive words;

[0050] Construct SQL query statement conversion method to convert single sensitive words and logically combined sensitive words into SQL query statements;

[0051] Set up an SQL index table to record the positional relationship between independent sensitive words in SQL query statements and placeholders in SQL statements;

[0052] Get the SMS to be tested;

[0053] According to the character table, convert the SMS content to be detected into a digital array;

[0054] According to the constructed SQL query statement conversion method, the digital array of the SMS is XOR-matched with the sensitive word table, and the SQL query command of the SMS is generated according to the SQL index table;

[0055] Use the database engine to execute the command and determine whether the text message matches the sensitive phrase based on the execution result.

[0056] In this embodiment, the sensitive phrase matching problem is converted into an SQL query problem, and the efficient processing capability of the database engine is utilized to greatly improve the matching speed. Compared with the traditional string matching based on regular expressions, the present invention avoids the complexity and low performance problems of regular expressions through the combination of XOR operation and SQL query statements, and especially solves the defect that regular expressions do not support logical "not" operation. The traditional sensitive word matching method is often unable to cope with sensitive phrases containing complex combinations of logical "and", "or", "not", etc., while the present invention can flexibly process these complex logical combinations through the conversion of SQL query statements to achieve more accurate matching. When the sensitive phrase library is updated, the transmission Traditional matching methods may require manual re-disassembly and reconfiguration of matching rules, which is labor-intensive and prone to errors. The present invention greatly reduces maintenance costs and improves the scalability and maintainability of the system by constructing a sensitive word list and an automatic conversion method for SQL query statements. Since a database engine is used to process logical operations, the system of the present invention is more stable and reliable than traditional string matching methods. The database engine has a natural advantage in processing large-scale data and complex logical operations, and can ensure the stable operation of the system. In the current context of a large number of text messages and diverse content, the fast matching method provided by the present invention can support large-scale data processing and meet the needs of operators for rapid screening of massive text message content.

[0057] Preferably, the formatting of these independent sensitive words specifically includes:

[0058] Align the length of all sensitive words to the maximum length;

[0059] Use the established character table to replace each character in the sensitive word with the corresponding positive integer code;

[0060] The replaced positive integer code is stored in the sensitive word table according to a predetermined format.

[0061] In this embodiment, by aligning the lengths of all sensitive words to the maximum length and using a unified character table to replace characters with positive integer codes, the consistency and standardization of sensitive words at the data representation level are ensured. This processing method helps to simplify the subsequent matching logic and improve matching efficiency. After the sensitive words are replaced with positive integer codes, they occupy less storage space than the original string representation, because integer codes are usually more compact than character codes. At the same time, the comparison and operation speed between numbers are usually faster than string operations, which helps to improve the speed of sensitive word matching. The formatted sensitive word table can support complex logical combination matching. By converting the logically combined sensitive word groups into SQL query statements, the powerful query capabilities of SQL can be used, including logical "AND", "OR" and "NOT" operations, to achieve efficient matching of complex sensitive word combinations. The establishment of the character table and the sensitive word table makes the entire system highly scalable and maintainable. With the addition of new sensitive words or the update of old sensitive words, only the corresponding table needs to be updated, without large-scale modification of the entire system. In addition, the digital encoding method is also convenient for automated processing and analysis.

[0062] Preferably, the SQL query statement conversion method converts a single sensitive word and a logically combined sensitive word group into an SQL query statement, specifically including:

[0063] Convert single sensitive words and logically combined sensitive words into placeholders in SQL statements;

[0064] According to the logical operation relationship in the sensitive phrase, the converted placeholders are connected using SQL logical operators to form an SQL query statement.

[0065] In this embodiment, compared with the traditional matching method based on regular expressions, this method effectively supports the logical "not" (such as NOT in SQL) operation by converting sensitive phrases into SQL query statements, solving the problem that regular expressions do not support logical "not" operations, which is particularly important when dealing with sensitive phrases containing complex logical relationships, and can greatly improve the accuracy and flexibility of matching; by converting sensitive phrases into SQL query statements and using the database engine to perform logical operations, a large number of possible rollback operations and repeated calculations in the regular expression matching process are avoided, thereby significantly improving the matching efficiency, which is crucial for dealing with scenarios such as large-scale SMS content retrieval and can reduce detection time , improving user experience; this method constructs SQL query statements to represent the logical combination of sensitive phrases, which improves the scalability and maintainability of the system. When new sensitive phrases or logical combinations need to be added, only the sensitive word list and SQL query statements need to be updated, without the need to significantly modify the core matching algorithm. At the same time, since the SQL query statements have good readability and comprehensibility, they are also convenient for subsequent maintenance and optimization work; by converting sensitive phrases into placeholders and performing logical operations when needed, this method can make more efficient use of system resources, especially when processing a large amount of SMS content, by reducing unnecessary calculations and resource consumption, the overall performance and stability of the system can be significantly improved.

[0066] Preferably, the setting of the SQL index table specifically includes:

[0067] Setting keyword encoding, which is used to represent each keyword in the character table, wherein the keyword includes a sensitive word or a combination of sensitive words;

[0068] Set the placeholder position index to correspond to the keyword code and record the position index of the placeholder corresponding to the keyword in the SQL query statement;

[0069] Set the SQL statement structure to build a SQL query statement framework that includes all sensitive word placeholders.

[0070] In this embodiment, by recording the encoding of each keyword (including sensitive words or sensitive word combinations) in the character table, fast recognition and indexing of keywords are achieved. This encoding method not only simplifies the storage and query process of keywords, but also improves the processing efficiency of the system. Corresponding to the keyword encoding, the position index of the corresponding placeholder of the keyword in the SQL query statement is recorded, so that in the subsequent matching process, the position that needs to be modified in the SQL statement can be quickly located, thereby avoiding unnecessary traversal and searching, and improving the matching speed; by constructing an SQL query statement framework containing all sensitive word placeholders, the system can flexibly cope with different numbers and types of sensitive word combinations. When a new sensitive word or sensitive word combination is added to the system, only The SQL index table and sensitive word table can be updated without large-scale modification of the SQL query statement itself, thus ensuring the scalability and maintainability of the system. During the matching process, the SQL index table can be used to quickly determine which sensitive words appear in the SMS content, and accurately find the corresponding placeholder positions of these sensitive words in the SQL query statement. This precise positioning and modification method avoids the repeated calculations and invalid matches that may exist in traditional matching methods, thereby significantly improving the matching performance. Since the SQL index table records the precise correspondence between keywords and placeholders, the possibility of human errors is reduced during the matching and modification process. At the same time, the error rate caused by human negligence or misoperation is also reduced through the automated matching and modification process.

[0071] Preferably, the SQL query statement conversion method constructed according to the method specifically includes: performing an XOR operation on the digital array of the SMS and the sensitive word table, and generating an SQL query command of the SMS according to the SQL index table.

[0072] According to the SQL query statement conversion method that has been constructed, the digital array of the SMS is matched with the sensitive word list through window sliding. In this process, the digital array of the SMS is matched with the sensitive word list through XOR operation. If the result of the XOR operation is zero, it means that the SMS content in the current window successfully matches a sensitive word. According to the positional relationship between the keywords and placeholders recorded in the SQL index table, the corresponding placeholder position in the SQL query statement is found, and the placeholder at that position is modified to generate the SQL query command for the SMS.

[0073] In this embodiment, the digital array of the SMS is matched with each sensitive word in the sensitive word table by sliding the window. This matching method utilizes the characteristics of XOR operation to quickly determine whether the SMS content in the current window matches the sensitive word. If the result of the XOR operation is zero, it means that the match is successful, that is, the SMS content in the current window is completely consistent with a certain sensitive word. Compared with the traditional string matching algorithm, the XOR operation matching avoids a large number of string comparison operations, reduces the amount of calculation, and thus improves the matching speed. At the same time, due to the good parallelism of the XOR operation, the parallel processing capability of modern computers can be further utilized to further improve the matching efficiency. When the XOR operation matches successfully, the corresponding placeholder position in the SQL query statement is found according to the positional relationship between the keyword and the placeholder recorded in the SQL index table, and the placeholder at that position (the default is 0) is replaced. Modify to 1, so that each sensitive word that matches successfully will be reflected in the SQL query statement, ensuring that the generated SQL query command can accurately reflect the sensitive information in the SMS content. Since the SQL query statement supports logical operations (such as AND, OR, NOT, etc.), it can handle sensitive phrases containing complex logical combinations well, which enables the method to cope with more complex and diverse SMS content and improves the accuracy and flexibility of matching; through efficient XOR operation matching and accurate SQL query command generation, the method can complete the sensitive word matching of SMS content in a very short time, which enables SMS operators to detect and intercept illegal information in real time and reduce its adverse effects on users and society. The entire matching and interception process is automated without manual intervention, which greatly reduces the operating costs and workload of operators and improves work efficiency and accuracy.

[0074] Preferably, before performing window sliding matching on the digital array of the SMS and the sensitive word list, it is first determined whether the sensitive word list contains the first number of the digital array of the SMS. If so, sliding matching is performed, otherwise, the line is directly changed.

[0075] In this embodiment, by first determining whether the sensitive word list contains the first digit of the SMS digital array, sensitive words that are impossible to match can be quickly filtered out to avoid unnecessary window sliding matching processes, which significantly reduces unnecessary calculations and improves the overall matching efficiency; since unnecessary sliding matching is reduced, the consumption of system resources (such as CPU, memory, etc.) is also reduced accordingly, which is particularly important for application scenarios that process large-scale SMS content and achieve rapid screening; this step is an optimization of the matching strategy. By adding a pre-judgment condition, the matching process is made more accurate and efficient. It embodies the idea of ​​reducing computational complexity through reasonable preprocessing and judgment in algorithm design.

[0076] A system for quickly detecting sensitive words in short messages, comprising:

[0077] A character table building module is used to uniformly number Chinese characters and assign a corresponding positive integer code to each character;

[0078] The sensitive word list construction module is used to split the logical combination sensitive word groups that need to be matched into non-repeating independent sensitive words, and format these sensitive words to align their lengths and encode them;

[0079] SQL query statement conversion module, used to convert single sensitive words and logically combined sensitive word groups into SQL query statements, including the conversion of logical operators to adapt to different database engines;

[0080] SQL index table building module, used to record the position relationship between independent sensitive words in SQL query statements and placeholders in SQL statements;

[0081] The SMS content processing module is used to obtain the SMS content to be detected and convert it into a digital array according to the character table;

[0082] The matching and generation module is used to perform XOR operations on the digital array of the SMS and the sensitive word list, and generate the SQL query command of the SMS based on the matching results and the SQL index table;

[0083] The database execution module is used to use the database engine to execute the generated SQL query command and determine whether the text message matches the sensitive phrase based on the execution result.

[0084] Preferably, the system further comprises:

[0085] The judgment module is used to judge whether the sensitive word list contains the first number of the SMS digital array before performing XOR operation matching on the SMS digital array and the sensitive word list. If it does, XOR matching is performed; otherwise, the line is directly changed.

[0086] A computing device comprises a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the container sealing supervision method when executing the computer program.

[0087] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the steps of the container sealing supervision method described above.

[0088] The above are only preferred embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent substitutions or improvements made within the spirit and principles of the present invention should be included in the protection scope of the present invention.

[0089] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for quickly detecting sensitive words in short messages, characterized in that: Specifically include: Establish a character table to uniformly number Chinese characters and assign a corresponding positive integer code to each character; Construct a sensitive word list to split the logically combined sensitive word group into a set of multiple independent sensitive words, and format these independent sensitive words; Construct SQL query statement conversion method to convert single sensitive words and logically combined sensitive words into SQL query statements; Set up an SQL index table to record the positional relationship between independent sensitive words in SQL query statements and placeholders in SQL statements; Get the SMS to be tested; According to the character table, convert the SMS content to be detected into a digital array; According to the constructed SQL query statement conversion method, the digital array of the SMS is matched with the sensitive word table by XOR operation, and the SQL query command of the SMS is generated according to the SQL index table; Use the database engine to execute the command and determine whether the text message matches the sensitive phrase based on the execution result.

2. A method for quickly detecting sensitive words in short messages according to claim 1, characterized in that: The formatting of these independent sensitive words specifically includes: Align the length of all sensitive words to the maximum length; Use the established character table to replace each character in the sensitive word with the corresponding positive integer code; The replaced positive integer code is stored in the sensitive word table according to a predetermined format.

3. A method for quickly detecting sensitive words in short messages according to claim 2, characterized in that: The SQL query statement conversion method converts a single sensitive word and a logically combined sensitive word group into an SQL query statement, specifically including: Convert single sensitive words and logically combined sensitive words into placeholders in SQL statements; According to the logical operation relationship in the sensitive phrase, the converted placeholders are connected using SQL logical operators to form an SQL query statement.

4. A method for quickly detecting sensitive words in short messages according to claim 3, characterized in that: The setting of the SQL index table specifically includes: Setting keyword encoding, which is used to represent each keyword in the character table, wherein the keyword includes a sensitive word or a combination of sensitive words; Set the placeholder position index to correspond to the keyword code and record the position index of the placeholder corresponding to the keyword in the SQL query statement; Set the SQL statement structure to build a SQL query statement framework that includes all sensitive word placeholders.

5. A method for quickly detecting sensitive words in short messages according to claim 4, characterized in that: The SQL query statement conversion method constructed according to the method performs XOR operation matching on the digital array of the SMS and the sensitive word list, and generates the SQL query command of the SMS according to the SQL index table, specifically including: According to the SQL query statement conversion method that has been constructed, the digital array of the SMS is matched with the sensitive word list through window sliding. In this process, the digital array of the SMS is matched with the sensitive word list through XOR operation. If the result of the XOR operation is zero, it means that the SMS content in the current window successfully matches a sensitive word. According to the positional relationship between the keywords and placeholders recorded in the SQL index table, the corresponding placeholder position in the SQL query statement is found, and the placeholder at that position is modified to generate the SQL query command for the SMS.

6. A method for quickly detecting sensitive words in short messages according to claim 5, characterized in that: Before performing window sliding matching on the numeric array of the SMS message and the sensitive word list, first determine whether the sensitive word list contains the first number of the numeric array of the SMS message. If so, perform sliding matching, otherwise, directly wrap the line.

7. A system for quickly detecting sensitive words in short messages, characterized in that: include: A character table building module is used to uniformly number Chinese characters and assign a corresponding positive integer code to each character; The sensitive word list construction module is used to split the logical combination sensitive word groups that need to be matched into non-repeating independent sensitive words, and format these sensitive words to align their lengths and encode them; SQL query statement conversion module, used to convert single sensitive words and logically combined sensitive word groups into SQL query statements, including the conversion of logical operators to adapt to different database engines; SQL index table building module, used to record the position relationship between independent sensitive words in SQL query statements and placeholders in SQL statements; The SMS content processing module is used to obtain the SMS content to be detected and convert it into a digital array according to the character table; The matching and generation module is used to perform XOR operations on the digital array of the SMS and the sensitive word list, and generate the SQL query command of the SMS based on the matching results and the SQL index table; The database execution module is used to use the database engine to execute the generated SQL query command and determine whether the text message matches the sensitive phrase based on the execution result.

8. A system for quickly detecting sensitive words in short messages according to claim 7, characterized in that: The system further comprises: The judgment module is used to judge whether the sensitive word list contains the first number of the SMS digital array before performing XOR operation matching on the SMS digital array and the sensitive word list. If it does, XOR matching is performed; otherwise, the line is directly changed.

9. A computing device, characterized in that The method comprises a memory, a processor and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the method implements the steps of the method for quickly detecting sensitive words in short messages as described in any one of claims 1 to 6.

10. A computer-readable storage medium, characterized in that: The storage medium stores a computer program, and when the computer program is executed by the processor, the steps of the method for quickly detecting sensitive words in short messages described in any one of claims 1 to 6 are implemented.