Data protection method and data protection system for electronic dictionary and computer readable medium
By symmetric encryption and binary to text encoding of electronic dictionary data, and decrypting it in the memory database when the device is started, the problem of electronic dictionary data being easily stolen is solved, achieving high security and rapid query of data.
Patent Information
- Application Number
- CN202411644293.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-18
- Publication Date
- 2025-02-28
AI Technical Summary
The dictionary data of existing electronic dictionaries is easily stolen, and pronunciation resources are also easily downloaded in batches by crawler programs, resulting in data security risks.
The symmetric encryption algorithm is used to encrypt the dictionary data in the dictionary device in a field-level manner, and the encrypted data is encoded in binary to text and stored in the database. When the device is started, it is decrypted and temporarily stored in the in-memory database, and data is extracted from the in-memory database in response to user query requests.
Effectively prevent dictionary data from being directly extracted and cracked, increasing data security, improving query speed and user experience, and avoiding batch download of pronunciation resources.
Smart Images
Figure CN119538291A_ABST
Abstract
Description
Technical Field
[0001] The invention relates to the technical field of electronic teaching equipment, and specifically discloses a data protection method for an electronic dictionary, a data protection system and a computer-readable medium. Background Art
[0002] With the rapid development of educational informatization, the application of electronic dictionaries in the field of teaching is becoming increasingly popular. As an important teaching auxiliary tool in electronic whiteboards, electronic dictionaries are used frequently. Electronic dictionary devices first identify user query requests, such as electronic whiteboard dictionaries, which can be adapted to a variety of input methods, such as touch screen virtual keyboard input, not limited to handwriting input, and then extract data stored in the database through search algorithms, filter the extracted data and display it to the user to realize the word search function.
[0003] Existing electronic dictionaries usually store dictionary data directly in plain text in a local database. This storage method has certain data security risks: dictionary data can be easily directly extracted and copied, resulting in the theft of educational resources; on the other hand, the pronunciation resources of the dictionary are usually stored on the server. When using the dictionary, the pronunciation data of the word is obtained from the server through an interface request. The pronunciation data is easily downloaded in batches by crawlers, resulting in the leakage of audio resources. Therefore, it is urgent to develop an electronic whiteboard dictionary system that can protect the security of dictionary data and meet the query efficiency, so as to meet the actual needs of modern education and teaching. Summary of the invention
[0004] The purpose of the present invention is to provide a data protection method, a data protection system and a computer-readable medium for an electronic dictionary in view of the problem that the dictionary data of the electronic dictionary in the prior art is easily stolen.
[0005] In order to achieve the above object, the technical solution adopted by the present invention is:
[0006] A data protection method for an electronic dictionary comprises the following steps:
[0007] S1, encrypting each field of the first dictionary data in the dictionary device using a symmetric encryption algorithm;
[0008] S2, performing binary-to-text encoding on the encrypted first dictionary data to obtain second dictionary data;
[0009] S3, storing the second dictionary data in a first database of a dictionary device according to the data structure of the first dictionary data;
[0010] S4, when the dictionary device is started, reading the second dictionary data in the first database and decrypting it to form third dictionary data; temporarily storing the third dictionary data in the second database;
[0011] S5, responding to the user's query request, extracting the third dictionary data from the second database, and feeding back the query result;
[0012] S6. When the dictionary device is shut down, the second database is shut down to release the memory resources occupied by the second database.
[0013] The electronic dictionary data protection method of the present invention implements encryption and encoding conversion of the first dictionary data in the dictionary device by executing steps S1 to S6, that is, encryption and encoding conversion of the original data, and stores the encrypted second dictionary data in a specific binary text format in the first database. This encryption and encoding mechanism ensures the security of the data, so that even if the data is accessed by other applications, it cannot be easily identified and parsed. Therefore, the method effectively prevents unauthorized extraction and cracking of data, and enhances the data security of the electronic dictionary device.
[0014] Preferably, in the data protection method for an electronic dictionary described in the present invention, the encryption and decryption both adopt a symmetric encryption algorithm; a single key is used to traverse each data of the first dictionary data for encryption, and encrypted data is generated.
[0015] As a preferred solution of the present invention, the first dictionary data is traversed through an encryption algorithm, each field is encrypted, and a corresponding single key is generated, so that the decryption process needs to use a symmetric encryption algorithm to pair and decrypt the second dictionary data one by one with a single key to obtain the original first dictionary data; on the one hand, the single key is compiled in the program, which increases the difficulty of cracking. Even if the database file is obtained, the valid information cannot be directly read; on the other hand, the built-in single key cannot be directly obtained from the outside, thereby further improving the security performance of dictionary data protection.
[0016] Preferably, in the data protection method for the electronic dictionary described in the present invention, the establishment of the second database specifically includes the following steps: when the dictionary device is started, a first request is sent to the control module, and the control module controls the storage module to establish the second database in the memory of the storage module.
[0017] As a preferred solution of the present invention, the decrypted third dictionary data is written into the third database in the memory. After the dictionary device is turned off, the third database in the memory will be released, so that the third database no longer exists. When the dictionary device is running, since the decrypted third dictionary data only exists in the memory and no content is stored in the file system, the security of the dictionary data is greatly improved; by loading the decrypted dictionary data into the second database, it is convenient to efficiently process the user's query request. The use of the memory database significantly improves the data reading speed and optimizes the user experience.
[0018] Preferably, the data protection method of the electronic dictionary of the present invention, in response to a user's query request, specifically comprises the following steps:
[0019] S51, receiving a query request from a user;
[0020] S52, executing an SQL query in the second database;
[0021] S53. Feedback query results.
[0022] As a preferred solution of the present invention, by executing SQL queries in the second database and feeding back the query results, the efficiency of dictionary data queries can be improved while maintaining the security of the dictionary data, thereby enhancing the user experience.
[0023] Preferably, in the data protection method of the electronic dictionary of the present invention, the first dictionary data includes a pronunciation identifier corresponding to each word; the pronunciation identifier is used to identify a pronunciation file corresponding to each of the words; the server is provided with a pronunciation file corresponding to each pronunciation identifier; and responding to a user's query request specifically includes the following steps:
[0024] S521, searching a cache folder for a first pronunciation file corresponding to a first pronunciation identifier of a first word queried by a user;
[0025] S522: If the first pronunciation file does not exist in the cache folder, send an audio resource request to the server;
[0026] S523, the server verifies whether the audio resource request is legal;
[0027] S524: If the audio resource request is legal, extract the first pronunciation file according to the first pronunciation identifier, and send the first pronunciation file to the data protection system.
[0028] As a preferred solution of the present invention, a one-to-one mapping mechanism between words and pronunciation files is implemented through pronunciation identifiers. If the audio resource request of the data protection system passes the verification, the server provides the corresponding audio file according to the request; the audio file can be encrypted by conventional encryption means during transmission, thereby enhancing the security of data transmission; a small number of pronunciation files are transmitted and can be encrypted, thereby avoiding batch downloading of audio files, and the on-demand download strategy optimizes the utilization of network resources; the server stores each pronunciation file according to the pronunciation identifier, and the data protection system can efficiently access the required audio resources through the pronunciation identifier, thereby improving the response speed of pronunciation playback.
[0029] Preferably, the data protection method for the electronic dictionary described in the present invention, in response to the user's query request, specifically further includes step S525: the data protection system downloads the first pronunciation file and stores it in a cache folder.
[0030] As a preferred solution of the present invention, the downloaded audio files are cached locally through the data protection system so that they do not need to be downloaded again the next time they are accessed. At the same time, the system performs cache management on local audio files. For example, it can delete expired files according to the frequency of file use, thereby saving storage space and improving the efficiency of electronic dictionary use. The local audio cache mechanism improves the response speed of pronunciation playback.
[0031] To achieve the purpose of the present invention, the present invention also provides a data protection system for an electronic dictionary, comprising a data encryption module, a control module, a storage module, a data loading module, and a query processing module. The data encryption module is used to encrypt and convert the first dictionary data into the second dictionary data; the control module is used to control the operation of the data protection system; the storage module is used to store the first dictionary data, the second dictionary data, and the third dictionary data; the data loading module is used to decrypt the second dictionary data into the third dictionary data; and the query processing module is used to respond to the user's query request.
[0032] The data protection system of the electronic dictionary of the present invention encrypts the dictionary data and converts and encrypts the coding form through the encryption module, and effectively prevents the dictionary data from being directly extracted and cracked before the dictionary device is started through the encrypted storage of the control module and the storage module; the decrypted second dictionary data is temporarily stored in the second database to form the third dictionary data through the data loading module and the query processing module, which can be convenient for users to look up words; when the dictionary device is turned off, the memory resources occupied by the second database are released, and other software or applications cannot retrieve the decrypted dictionary data, thereby preventing the dictionary data from being copied and stolen due to its existence in the file system, and improving the safety performance of the electronic dictionary device; through the data loading module, the dictionary device is loaded and decrypted when it is started, which disperses the time consumption of the decryption operation, and cooperates with the query processing module's function of responding to user query requests, which significantly improves the query speed of the dictionary device.
[0033] Preferably, the data protection system of the electronic dictionary of the present invention also includes an audio processing module; the audio processing module is used to search for pronunciation files in a cache folder; or to send an audio resource request to a server and download audio files; the server is used to store pronunciation files and communicate with the data protection system of the electronic dictionary.
[0034] As a preferred solution of the present invention, by setting up an audio processing module, it can not only meet the visual display needs of users for word search, but also obtain audio information matching the words through the audio processing module in cooperation with the server, thereby expanding the use of the dictionary data protection system; and, through the highly secure server verification and the audio processing module's recognition of pronunciation identifiers and pronunciation file search functions, when a pronunciation file is needed, an audio resource request is sent to the server to download a small amount of required audio files, thereby avoiding batches of audio files being downloaded by external software, thereby further improving the reliability of the data protection system.
[0035] To achieve the purpose of the present invention, the present invention also provides a non-temporary computer-readable medium on which a computer program is stored. When the computer program is executed by a processor, the data protection method of the electronic dictionary described in the present invention is implemented.
[0036] In summary, due to the adoption of the above technical solution, the beneficial effects of the present invention are:
[0037] 1. The data protection method effectively prevents dictionary data from being directly extracted and cracked through field-level symmetric encryption and binary-to-text encoding of an encryption symmetric algorithm, thereby increasing the difficulty of dictionary data being cracked; even if software or applications obtain database files, they cannot directly read valid information, thereby significantly improving data security;
[0038] 2. The data protection method preloads dictionary data for decryption when the dictionary device is started, which disperses the time of the decryption operation, adopts a memory database, significantly improves the query speed, and optimizes the system performance;
[0039] 3. The data protection system has a fast response speed and no obvious delay, which improves the user experience; the system runs stably and is suitable for use in teaching scenarios. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] Figure 1 is a flow chart of the data protection method of the electronic dictionary of the present invention;
[0041] Figure 2 It is a flowchart of specific steps of responding to a user's query request of the present invention;
[0042] Figure 3 is a schematic diagram a of the module structure of the data protection system of the electronic dictionary of the present invention;
[0043] Figure 4 It is a schematic diagram b of the module structure of the data protection system of the electronic dictionary of the present invention. DETAILED DESCRIPTION
[0044] The present invention will be described in detail below in conjunction with the accompanying drawings.
[0045] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.
[0046] Embodiment 1:
[0047] refer to Figure 1 As shown, this embodiment discloses a data protection method for an electronic dictionary, comprising the following steps:
[0048] S1, encrypting each field of the first dictionary data in the dictionary device using a symmetric encryption algorithm;
[0049] S2, performing binary-to-text encoding on the encrypted first dictionary data to obtain second dictionary data;
[0050] S3, storing the second dictionary data in the first database of the dictionary device according to the data structure of the first dictionary data;
[0051] S4, when the dictionary device is started, reading the second dictionary data in the first database and decrypting it to form the third dictionary data; temporarily storing the third dictionary data in the second database;
[0052] S5, responding to the user's query request, extracting third dictionary data from the second database, and feeding back the query result;
[0053] S6. When the dictionary device is shut down, the second database is shut down to release the memory resources occupied by the second database.
[0054] It should be noted that the electronic dictionary described in the present invention may be an electronic whiteboard dictionary, but is not limited to being used in data protection of electronic whiteboard dictionaries.
[0055] The first, second and third described in the present invention are only formally distinguished for the purpose of clear description, and no substantial mathematical meaning is explained; the first database and the second database are understood to be SQLite databases with persistent storage and memory storage. Persistent storage refers to the process of saving the contents of the database as a file, reading the second dictionary data and decrypting it, and being able to read the persistently stored second dictionary data into the memory; the memory is understood to be a storage unit for storing data in computers and other electronic devices. It is the main memory of the computer, used to store the data and programs currently being processed. When the program is running, it will be loaded into the memory. Once the computer is powered off, the data stored therein will be lost.
[0056] The data structure of the first dictionary data of the present invention is understood to be stored according to the same DDL. For example, a table named EnglishWords is created, and the table structure includes the following two fields: word and meaning. The type of Word is varchar (32), which is used to store words and can contain up to 32 characters. This field cannot be NULL and must be a non-repeating word. At the same time, the word field is defined as the primary key to ensure that each word has a unique identifier in the table. The type of Meaning is TEXT, which is used to store the meaning of the word. There is no limit on the character length, and long text can be stored. The Meaning field is optional. The data structure of the second dictionary is implemented in the same way as the data structure of the first dictionary: first obtain its DDL from the original unencrypted database, and after the encryption is completed, use the DDL to create a new first database with the same structure to store the encrypted second dictionary data.
[0057] It should be noted that the binary-to-text encoding refers to an encoding method for converting binary data into a printable character sequence, including but not limited to Base64 encoding and its variants, Base32 encoding, Base85 encoding, etc. The present invention adopts this encoding method, which not only ensures the integrity of the encrypted data, but also facilitates storage and processing in the database.
[0058] Specifically, the establishment of the second database includes the following steps: when the dictionary device is started, a first request is sent to the control module, and the control module controls the storage module to establish the second database in the memory of the storage module. For example, when the electronic device of the present invention is in operation, the data query module can request a temporary memory through code, and then a temporary SQLite database is created in the temporary memory, which is the second database, and then the decrypted data is written into the second database to complete the temporary storage of the decrypted data, which is also understood as the decrypted data is not stored locally. After the dictionary device is turned off, the temporary memory will be cleared and the temporary second database will no longer exist. During the operation of the whiteboard software of the dictionary device, since the decrypted third dictionary database only exists in the memory and no content is stored in the file system, the security is greatly improved.
[0059] The symmetric encryption algorithm used in the present invention is an algorithm in the encryption algorithm. Specifically, for comprehensive consideration of encryption security and decryption efficiency, a symmetric encryption algorithm can be selected to encrypt the content of each field of the first dictionary data one by one, which can provide reliable encryption strength to prevent the leakage or unauthorized access of the dictionary data; it should be noted that the encrypted data is converted into a text encoding form for easy storage. Specifically, we use Base64 encoding to convert the encrypted binary data into a text format, so that the processed data can be safely stored in the first database. Among them, Base64 is a commonly used binary-to-text encoding method that can ensure that storage and transmission are simplified while maintaining data integrity.
[0060] Specifically, the encryption and decryption both use a symmetric encryption algorithm; a single key is used to traverse each data of the first dictionary data for encryption, and encrypted data is generated. It should be noted that during the encryption process, the system will traverse each field of the first dictionary data, and use a pre-generated key to encrypt these fields to generate encrypted data. This key is a binary data sequence that conforms to the AES algorithm rules, usually a byte array of a specific length. During the decryption process, the same key is used to restore the original data. It should be pointed out that the generation of the key should follow the security standards to ensure its randomness and complexity to improve the security of the encrypted data; the encryption algorithm enables the data protection system of the dictionary device to use the same single key in the encryption and decryption processes. In the present invention, after the single key is compiled into an executable file through a symmetric encryption algorithm, all data and program instructions will become binary data to form encrypted data. For example, the second dictionary data is encrypted data; it is difficult to find a single key directly from a data file. More specifically, the difficulty of deciphering the single key can be increased by further encryption or obfuscation means to achieve encryption protection of the dictionary data.
[0061] Step S4 of the present invention is triggered when the dictionary device is started or the electronic whiteboard is started. The encrypted dictionary data in the local SQLite database is first read so that the decryption task is completed in advance in the background. When the user starts to query, there is no need to wait for the query, thereby improving the response speed.
[0062] Specifically, responding to a user's query request includes the following steps:
[0063] S51, receiving a query request from a user;
[0064] S52, executing SQL query in the second database;
[0065] S53. Feedback query results.
[0066] It should be noted that the SQL is understood as the English abbreviation of Structured Query Language, which is a programming language used to manage and operate relational databases; in the present invention, the query processing module of the dictionary device can be used to execute SQL queries; and then through step S53, the SQL query results are returned to the user interface, and the results are displayed to the user so that the user can view the specific interpretation, examples and related information of the dictionary content.
[0067] Specifically, refer to Figure 2 As shown, the first dictionary data includes a pronunciation identifier corresponding to each word; the pronunciation identifier is used to identify a pronunciation file corresponding to each word; the server is provided with a pronunciation file corresponding to each pronunciation identifier; responding to a user's query request, specifically further comprising the following steps:
[0068] S521, searching a cache folder for a first pronunciation file corresponding to the first pronunciation identifier according to a first pronunciation identifier of a first word queried by a user;
[0069] S522: If the first pronunciation file does not exist in the cache folder, send an audio resource request to the server;
[0070] S523, the server verifies whether the audio resource request is legal;
[0071] S524: If the audio resource request is legal, extract the first pronunciation file according to the first pronunciation identifier, and send the first pronunciation file to the data protection system.
[0072] Specifically, in response to the user's query request, the method further includes step S525: the data protection system downloads the first pronunciation file and stores it in a cache folder. It should be noted that the pronunciation file is understood as a general term for all pronunciation files corresponding to each word, and the first pronunciation file is understood as the pronunciation file required for the first word queried by a specific user in real time; the cache folder is understood as: there is a folder in the running directory of the dictionary device or the electronic whiteboard system dedicated to storing downloaded cache files, such as the aduio_cache folder.
[0073] For example, when a user searches for the first word "apple", the system of the present invention will retrieve the corresponding meaning and example sentences of apple, and at the same time, it will retrieve its corresponding first pronunciation identifier, which can be understood as a pronunciation ID. For example, the first pronunciation identifier of the American pronunciation corresponding to the first word "apple" is apple82ecd13c-b3f1-479b-bacb-70aa4600cb6f; the system will search whether there is a 82ecd13c-b3f1-479b-bacb-70aa4600cb6f.mp3 file in the aduio_cache folder.
[0074] Embodiment 2:
[0075] Based on Example 1, this embodiment discloses a data protection system for an electronic dictionary, which implements the data protection method for the electronic dictionary described in Example 1, including: a data encryption module, a control module, a storage module, a data loading module, and a query processing module; the data encryption module is used to encrypt and convert first dictionary data into second dictionary data; the control module is used to control the operation of the data protection system; the storage module is used to store first dictionary data, second dictionary data, and third dictionary data; the data loading module is used to decrypt the second dictionary data into third dictionary data; and the query processing module is used to respond to user query requests.
[0076] like Figure 3 As shown, the control module is a commonly used computer control module, which can control the data encryption module, storage module, data loading module and query module through a micro-processing computing unit to achieve data interaction between modules.
[0077] Specifically, it also includes an audio processing module; the audio processing module is used to search for pronunciation files in a cache folder; or to send an audio resource request to a server and download audio files; the server is used to store pronunciation files and communicate with a data protection system of an electronic dictionary.
[0078] It should be noted that the specific implementation method of sending an audio resource request to the server described in the present invention can be a request to the server through a network protocol, such as the HTTP protocol; the system described in the present invention sends a network request with a specific ID to the server, and after receiving the ID, the server finds the audio file named with the ID, and then replies the audio file to the data protection system, thereby enabling the data protection system to access the audio resources through the ID.
[0079] Specifically, Figure 4 As shown, the client is understood as the dictionary device of the present invention, and is also understood as an electronic whiteboard dictionary system that includes the data protection system of the present invention. The server is understood as a network service platform. The server and the client can realize network communication and data transmission, and realize the data protection system of the present invention to obtain audio files from the server.
[0080] Embodiment 3:
[0081] Based on Example 1 or Example 2, this embodiment discloses a non-temporary computer-readable medium on which a computer program is stored. When the computer program is executed by a processor, the data protection method of the electronic dictionary described in Example 1 is implemented.
[0082] 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 and improvements made within the spirit and principles of the present invention should be included in the protection scope of the present invention.
Claims
1. A data protection method for an electronic dictionary, characterized in that: The following steps are involved: S1, encrypting each field of the first dictionary data in the dictionary device using a symmetric encryption algorithm; S2, performing binary-to-text encoding on the encrypted first dictionary data to obtain second dictionary data; S3, storing the second dictionary data in a first database of a dictionary device according to the data structure of the first dictionary data; S4, when the dictionary device is started, reading the second dictionary data in the first database and decrypting it to form third dictionary data; temporarily storing the third dictionary data in the second database; S5, responding to the user's query request, extracting the third dictionary data from the second database, and feeding back the query result; S6. When the dictionary device is shut down, the second database is shut down to release the memory resources occupied by the second database.
2. The data protection method of the electronic dictionary according to claim 1, characterized in that: The encryption and decryption both adopt a symmetric encryption algorithm; a single key is used to traverse each data of the first dictionary data for encryption, and encrypted data is generated.
3. The data protection method of the electronic dictionary according to claim 1, characterized in that: The establishment of the second database specifically includes the following steps: when the dictionary device is started, a first request is sent to the control module, and the control module controls the storage module to establish the second database in the memory of the storage module.
4. The data protection method of the electronic dictionary according to claim 1, characterized in that: Respond to user query requests, specifically The following steps are involved: S51, receiving a query request from a user; S52, executing an SQL query in the second database; S53. Feedback query results.
5. The data protection method of the electronic dictionary according to any one of claims 1 to 4, characterized in that: The first dictionary data includes a pronunciation identifier corresponding to each word; the pronunciation identifier is used to identify a pronunciation file corresponding to each word; the server is provided with a pronunciation file corresponding to each pronunciation identifier; responding to a user's query request, specifically further comprising the following steps: S521, searching a cache folder for a first pronunciation file corresponding to a first pronunciation identifier of a first word queried by a user; S522: If the first pronunciation file does not exist in the cache folder, send an audio resource request to the server; S523, the server verifies whether the audio resource request is legal; S524: If the audio resource request is legal, extract the first pronunciation file according to the first pronunciation identifier, and send the first pronunciation file to the data protection system.
6. The data protection method of the electronic dictionary according to claim 5, characterized in that: In response to the user's query request, the method further includes step S525: the data protection system downloads the first pronunciation file and stores it in a cache folder.
7. A data protection system for an electronic dictionary, characterized in that: A method for implementing data protection of an electronic dictionary as described in any one of claims 1 to 6, comprising: a data encryption module, a control module, a storage module, a data loading module, and a query processing module; the data encryption module is used to encrypt and convert the first dictionary data into second dictionary data; the control module is used to control the operation of the data protection system; the storage module is used to store the first dictionary data, the second dictionary data and the third dictionary data; the data loading module is used to decrypt the second dictionary data into third dictionary data; and the query processing module is used to respond to user query requests.
8. The data protection system for an electronic dictionary according to claim 7, characterized in that: It also includes an audio processing module; the audio processing module is used to search for pronunciation files in the cache folder; or to send an audio resource request to the server and download the audio file; the server is used to store the pronunciation file and communicate with the data protection system of the electronic dictionary.
9. A non-transitory computer-readable medium, characterized in that A computer program is stored thereon, and when the computer program is executed by a processor, the data protection method for the electronic dictionary as described in any one of claims 1-6 is implemented.