Big data entry method of SQL database

Abstract

The invention relates to a big data entry method for an SQL database, and the method comprises the following steps: S1, capturing big data, and obtaining big data information through multiple devices and communication interfaces in a network; s2, the obtained information is screened, so that useful information is selected and temporarily stored; s3, arranging the obtained information, generating a super list box convenient to read, and performing classified display on the information in the list box through categories; s4, the classified information is stored in an SQL database of a corresponding client in a distributed system for long-term storage, so that the client can read the classified information conveniently; s5, when the SQL database stores the information, encrypting the information, and setting an access permission; s6, the client accesses the SQL after performing permission verification, and accesses different contents and operation permissions in the SQL database according to different permissions; according to the scheme, the business opportunity searching convenience of e-commerce is improved, and the data security is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of data entry methods, and in particular to a large data entry method for an SQL database. Background Art

[0002] SQL (Structured Query Language) is a database language with multiple functions such as data manipulation and data definition. This language is interactive and can provide great convenience for users. Database management systems should make full use of SQL language to improve the work quality and efficiency of computer application systems. SQL language can not only be used independently in terminals, but also as a sub-language to provide effective assistance for other program designs. In this program application, SQL can optimize program functions together with other program languages, thereby providing users with more comprehensive information.

[0003] With the advancement of technology, in e-commerce activities, it is often necessary to find the required information in big data, and obtain customer information through the found information to accurately locate customers.

[0004] Existing big data entry is mostly manual, where the acquired information is manually entered into a SQL database for use, which is unable to achieve efficient information acquisition.

[0005] It can be seen that there is an urgent need for a big data entry method for SQL database to efficiently obtain input information in order to improve the efficiency of e-commerce activities. Summary of the invention

[0006] The present invention is aimed at the problems existing in the prior art and provides a method for inputting big data into an SQL database to solve the problems raised in the above-mentioned background technology.

[0007] In order to achieve the above object, the technical solution of the present invention is as follows: a method for entering big data into an SQL database, comprising the following steps:

[0008] S1. Capture big data and obtain big data information through multiple devices and communication interfaces in the network;

[0009] S2. After step S1, the acquired information is screened to select useful information and temporarily store it;

[0010] S3. After step S2, the acquired information is arranged to generate a super list box that is easy to read, and the information is displayed by category in the list box;

[0011] S4. The classified information is stored in the SQL database of the corresponding client in the distributed system for long-term storage so that the client can read it;

[0012] S5. When storing information in the SQL database, encrypt the information and set access permissions;

[0013] S6. The client accesses SQL after performing permission verification, and accesses different contents and operation permissions in the SQL database according to different permissions.

[0014] Preferably, the big data capture comprises the following steps:

[0015] S11. Set search keywords and generate a keyword list;

[0016] S12. Search the network through the keyword list and capture the information containing the keywords in the network information;

[0017] S13. Temporarily cache the acquired information to facilitate subsequent reading.

[0018] Preferably, there are multiple search keywords, the multiple search keywords exist in parallel, and the multiple parallel keywords are combined for search.

[0019] Preferably, the combined search is keyword search alone, two-by-two combined search, and multiple-word combined search, so as to obtain different information in different combination modes.

[0020] Preferably, the screening comprises the following steps:

[0021] S21. Compare the information captured by big data to remove overlapping items;

[0022] S22. Eliminate interference items in the information captured by comparing big data to reduce the amount of information;

[0023] S23. Set weights for the eliminated information.

[0024] Preferably, the weight is set to match the acquired information according to the degree of match with the keyword, the higher the degree of match with the keyword, the higher the weight of the information, and the lower the degree of match, the lower the weight of the information.

[0025] Preferably, the weight is set to set a matching code, different matching codes are allocated according to different information weights, and the weight is distinguished by the matching code.

[0026] Preferably, the super list box arranges the information according to the acquired weight code and divides it into multiple pages, and the information with different weights is distributed and distinguished respectively, and each piece of information has a hyperlink.

[0027] Preferably, the SQL database includes read permissions and operation permissions, and the operation permissions are divided into ordinary permissions, advanced permissions and full permissions.

[0028] Compared with the prior art, the beneficial effects achieved by the present invention are:

[0029] First, the present invention sets a big data capture step before SQL big data is entered, sets keyword search, obtains required relevant information on the Internet, and organizes the information and enters it into SQL data for the client to read and call, thereby achieving the effect of automatically entering useful information through big data, thereby improving the convenience of e-commerce in finding business opportunities.

[0030] Second, the present invention sets a screening step between big data capture and SQL database entry, compares information to eliminate duplicate information, assigns weights to the information, generates a super list to classify the information according to weight, thereby reducing the amount of SQL database storage occupied by information and making it easier for the client to read the information.

[0031] Third, the present invention sets permissions for the SQL database so that ordinary users can only query data, and authorized clients can operate on the information, and further limits the permissions for operations to improve data security. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] Figure 1 It is a schematic block diagram of the overall process of the present invention;

[0033] Figure 2 This is a schematic diagram of big data information capture in the present invention;

[0034] Figure 3 It is a schematic diagram of the screening process of the present invention;

[0035] Figure 4 A schematic block diagram of the process of generating a super list according to the present invention;

[0036] Figure 5 This is a schematic diagram of SQL operation permissions of the present invention. DETAILED DESCRIPTION

[0037] In order to deepen the understanding of the present invention, the present embodiment is described in detail below with reference to the accompanying drawings.

[0038] Example 1: Please refer to Figure 1-5 , a method for entering big data into a SQL database, comprising the following steps:

[0039] S1. Capture big data and obtain big data information through multiple devices and communication interfaces in the network;

[0040] S2. After step S1, the acquired information is screened to select useful information and temporarily store it;

[0041] S3. After step S2, the acquired information is arranged to generate a super list box that is easy to read, and the information is displayed by category in the list box;

[0042] S4. The classified information is stored in the SQL database of the corresponding client in the distributed system for long-term storage so that the client can read it;

[0043] S5. When storing information in the SQL database, encrypt the information and set access permissions;

[0044] S6. The client accesses SQL after performing permission verification, and accesses different contents and operation permissions in the SQL database according to different permissions.

[0045] Through the above technical solution, a big data capture step is set before SQL big data is entered. By setting keyword search, the required relevant information is obtained on the Internet, and the information is sorted and entered into the SQL data for the client to read and call, thereby achieving the effect of automatically entering useful information through big data.

[0046] Specifically, the big data capture includes the following steps:

[0047] S1. Set search keywords and generate a keyword list;

[0048] S2. Search the Internet using a keyword list and capture information containing the keywords in Internet information;

[0049] S3. Temporarily cache the acquired information to facilitate subsequent reading.

[0050] Through the above technical solution, keywords are input into the terminal, and the program puts the keywords into the search engine for retrieval. During the retrieval process, information with keywords is captured and temporarily stored for subsequent calls.

[0051] Specifically, there are multiple search keywords, the multiple search keywords exist in parallel, and the multiple parallel keywords are combined for search.

[0052] Through the above technical solution, multiple parallel keywords are set, and the accuracy of retrieval is improved through the combination of keywords, avoiding slow operation caused by too much useless information retrieved in a single time.

[0053] Specifically, the combined search includes keyword single search, two-by-two combined search, and multi-word combined search, so as to obtain different information in different combination modes.

[0054] Through the above technical solution, different keywords are combined to form more groups of search solutions to improve the scope of search information.

[0055] Specifically, the screening includes the following steps:

[0056] S1. Compare the information captured by big data to remove overlapping items;

[0057] S2. Eliminate interference items in the information captured by the big data to reduce the amount of information;

[0058] S3. Set weights for the eliminated information.

[0059] Through the above technical solution, because information is acquired through different combinations of keywords, the information that can be retrieved by a single keyword and a combination of multiple keywords is the same, which leads to duplication of captured information. By eliminating duplicate information, the amount of data transmitted to the SQL database is reduced, thereby saving storage space and improving storage and call speeds.

[0060] Specifically, the weight is set to match the acquired information according to the degree of match with the keyword, the higher the degree of match with the keyword, the higher the weight of the information, and the lower the degree of match, the lower the weight of the information.

[0061] Through the above technical solution, weights are set for information, so that galaxies can be classified by weight, thereby distinguishing important information from secondary information. In subsequent expansions, access permissions can be set for important information and secondary information respectively to improve information security. Traditional classification by pronunciation or first letter cannot distinguish the importance of information.

[0062] Specifically, the weight is set to set a matching code, different matching codes are allocated according to different information weights, and the weights are distinguished by the matching code.

[0063] Through the above technical solution, a matching code is set to realize the classification of weights to reduce the memory space occupied by computer operations. The matching code is a digital code, where 1 is important information, 2 is secondary information, 3 is ordinary information, and 4 is random access information. The matching code is a pattern of hidden bytes added at the beginning of the information.

[0064] Specifically, the super list box arranges the information according to the acquired weight code and divides it into multiple pages, and the information with different weights is distributed and distinguished respectively, and each piece of information has a hyperlink.

[0065] Through the above technical solution, a super list box is used to classify and arrange information, so that the information is displayed clearly on the client to facilitate retrieval and use. If each piece of information is a hyperlink, it can jump to the initial position of the information by clicking the hyperlink, so that the reliability of the information can be further identified manually during use. The above super list box is a term in Easy Language, that is, a list table with extended functions.

[0066] Specifically, the SQL database contains read permissions and operation permissions, and the operation permissions are divided into ordinary permissions, advanced permissions, and full permissions.

[0067] Through the above technical solution, permissions are set for the SQL database so that ordinary users can only query data, and authorized clients can operate on the information, and the operation permissions are further limited to improve data security.

[0068] When in use, by setting the big data capture steps before SQL big data entry, by setting keyword search, the required relevant information is obtained on the Internet, and the information is sorted and entered into the SQL data for the client to read and call, the effect of automatically entering useful information through big data is achieved;

[0069] By setting up a screening step between big data capture and SQL database entry, duplicate information is eliminated by comparing information, and information is weighted and a super list is generated to classify information according to weight, thereby reducing the amount of SQL database storage occupied by information and making it easier for clients to read information;

[0070] By setting permissions for the SQL database, ordinary users can only query data, and authorized clients can operate on the information. The operation permissions are further limited to improve data security.

[0071] It should be noted that the above embodiments are not intended to limit the protection scope of the present invention, and equivalent changes or substitutions made on the basis of the above technical solutions all fall within the protection scope of the claims of the present invention.

Claims

1. A method for entering big data into a SQL database, characterized in that: The method comprises the following steps: S1. Capture big data and obtain big data information through multiple devices and communication interfaces in the network; S2. After step S1, the acquired information is screened to select useful information and temporarily store it; S3. After step S2, the acquired information is arranged to generate a super list box that is easy to read, and the information is displayed by category in the list box; S4. The classified information is stored in the SQL database of the corresponding client in the distributed system for long-term storage so that the client can read it; S5. When storing information in the SQL database, encrypt the information and set access permissions; S6. The client accesses SQL after performing permission verification, and accesses different contents and operation permissions in the SQL database according to different permissions.

2. The method for entering large data into a SQL database according to claim 1, characterized in that: S1. Capture big data, including the following steps: S11. Set search keywords and generate a keyword list; S12. Search the network through the keyword list and capture the information containing the keywords in the network information; S13. Temporarily cache the acquired information to facilitate subsequent reading.

3. The method for entering large data into a SQL database according to claim 2, characterized in that: There are multiple search keywords, and the multiple search keywords exist in parallel. The multiple parallel keywords are searched in combination. The combined search includes keyword single search, two-by-two combination search and multi-word combination search, so as to obtain different information under different combination modes.

4. The method for entering large data into a SQL database according to claim 3, characterized in that: S2. After step S1, the acquired information is screened, and the screening includes the following steps: S21. Compare the information captured by big data to remove overlapping items; S22. Eliminate interference items in the information captured by comparing big data to reduce the amount of information; S23. Set weights for the eliminated information.

5. The method for entering large data into a SQL database according to claim 4, characterized in that: The weight in S2 is set to match the acquired information according to the degree of match with the keyword. The higher the degree of match with the keyword, the higher the weight of the information, and the lower the degree of match, the lower the weight of the information. The weight is set to set a matching code, and different matching codes are assigned according to different information weights. The weight is distinguished by the matching code.

6. The method for entering large data into a SQL database according to claim 5, characterized in that: In S3, the super list box arranges the information according to the obtained weight code and divides it into multiple pages. Information with different weights is distributed and distinguished separately, and each piece of information has a hyperlink.

7. The method for entering large data into a SQL database according to claim 6, characterized in that: The SQL database in S5 contains read permissions and operation permissions. Operation permissions are divided into general permissions, advanced permissions, and full permissions.

Images