Database field processing method and device, electronic equipment and readable storage medium
By obtaining the attribute information and entry and exit parameters of the database field, determining the operation mode, and encrypting or decrypting the database field based on the configuration strategy, the problem of poor maintenance and scalability of database field processing in the existing technology is solved, and the security of the system is improved Sensitive information protection.
Patent Information
- Application Number
- CN202411182691.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-26
- Publication Date
- 2024-11-08
AI Technical Summary
When encrypting database fields in the prior art, developers need to write codes with great differences, poor maintenance and scalability, making it difficult to guarantee system security.
By obtaining the attribute information of the to-process database fields, capturing the incoming and outgoing parameters, determining the database operation method, and encrypting or decrypting the fields according to the preset configuration strategy, the transformation process of the database fields is simplified and scalability is improved.
It realizes quick and convenient transformation of database fields, simplifies maintenance and expansion, enhances protection of sensitive information, and prevents information leakage.
Smart Images

Figure CN118916368A_ABST
Abstract
Description
Technical Field
[0001] The embodiments of the present application relate to but are not limited to the field of financial technology, and in particular to a database field processing method, device, electronic device and computer-readable storage medium. Background Art
[0002] With the continuous advancement of science and technology, the financial industry is developing in the direction of intelligence, and various systems are increasingly used to manage various different businesses in the financial industry. For the financial industry, sensitive information will exist in each system. In order to ensure the security of the system, sensitive information often needs to be encrypted. Among them, in order to encrypt database fields, developers are often required to write relevant codes. Because the codes written by each developer are different, it is not conducive to later maintenance and has poor scalability. Summary of the invention
[0003] The following is a summary of the subject matter described in detail herein. This summary is not intended to limit the scope of the claims.
[0004] In order to solve the problems mentioned in the above background technology, the embodiments of the present application provide a database field processing method, device, electronic device and computer-readable storage medium, which can quickly and conveniently transform database fields, facilitate subsequent maintenance processing, and have good scalability.
[0005] In a first aspect, an embodiment of the present application provides a method for processing a database field, the method comprising:
[0006] Get the database fields to be processed;
[0007] Analyzing the attributes of the database field to be processed to obtain field attribute information;
[0008] Capturing input and output parameters from a database corresponding to the data field to be processed according to the field attribute information;
[0009] Determine the database operation mode information according to the input and output parameters;
[0010] The database fields to be processed are transformed according to the database operation mode information and a preset configuration strategy.
[0011] According to some embodiments of the present application, the step of analyzing the attributes of the database field to be processed to obtain field attribute information includes:
[0012] Parsing the validation mode of the database field to be processed to obtain validation mode information;
[0013] Parsing the field type of the database field to be processed to obtain field type information;
[0014] The field attribute information includes the validation mode information and the field type information.
[0015] According to some embodiments of the present application, capturing input and output parameters from a database corresponding to the data field to be processed according to the field attribute information includes at least one of the following:
[0016] In the case where the validation mode information includes configuration validation information, extracting the input and output parameters from a database corresponding to the configuration validation information according to the field type information;
[0017] In the case where the validation mode information includes method validation information, the input and output parameters are extracted from a database corresponding to the method validation information according to the field type information.
[0018] According to some embodiments of the present application, determining the database operation mode information according to the input and output parameters includes:
[0019] Performing attribution analysis on the input and output parameters to obtain parameter attribution information;
[0020] Determine parameter source information according to the parameter attribution information;
[0021] The database operation mode information is determined according to the parameter source information.
[0022] According to some embodiments of the present application, determining the database operation mode information according to the parameter source information includes at least one of the following:
[0023] In the case where the parameter source information includes data adding and collecting information, determining the data adding operation information according to the data adding and collecting information;
[0024] In a case where the parameter source information includes data update collection information, determining the data update operation information according to the data update collection information;
[0025] In a case where the parameter source information includes data query information, the data query operation information is determined according to the data query information.
[0026] According to some embodiments of the present application, the transforming of the to-be-processed database field according to the database operation mode information and a preset configuration strategy includes:
[0027] In the case where the database operation mode information includes the data adding operation information, encrypting the database field to be processed;
[0028] In the case where the database operation mode information includes the data update operation information, encrypting the database field to be processed;
[0029] In the case where the database operation mode information includes the data query operation information, the to-be-processed database field is decrypted.
[0030] According to some embodiments of the present application, the encrypting the database field to be processed includes one of the following:
[0031] Performing hash encryption on the database field to be processed;
[0032] The database field to be processed is subjected to standard symmetric encryption.
[0033] In a second aspect, the embodiment of the present application further provides a database field processing device, including:
[0034] The first processing module is used to obtain the database fields to be processed;
[0035] A second processing module is used to analyze the attributes of the database field to be processed to obtain field attribute information;
[0036] A third processing module is used to capture input and output parameters from a database corresponding to the data field to be processed according to the field attribute information;
[0037] A fourth processing module, used to determine database operation mode information according to the input and output parameters;
[0038] The fifth processing module is used to transform the database field to be processed according to the database operation mode information and a preset configuration strategy.
[0039] In a third aspect, an embodiment of the present application further provides an electronic device, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the database field processing method as described in the first aspect above is implemented.
[0040] In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium storing computer-executable instructions, wherein the computer-executable instructions are used to execute the database field processing method described in the first aspect above.
[0041] According to the database field processing method of the embodiment provided by the present application, at least the following beneficial effects are achieved: in the process of database field processing, firstly, the database field to be processed is obtained; then, the attributes of the database field to be processed are analyzed and processed to obtain field attribute information; then, according to the field attribute information, input and output parameters are captured from the database corresponding to the data field to be processed; then, the database operation mode information is determined according to the input and output parameters; finally, the database field to be processed is transformed according to the database operation mode information and the preset configuration strategy. Through the above technical scheme, the database field to be processed can be transformed and processed simply and quickly, and in the process of modifying the transformation process of the database field to be processed, only the relevant information parameters need to be modified, so that the database field processing method of the present application has strong scalability, and thus can well prevent the leakage of sensitive information. BRIEF DESCRIPTION OF THE DRAWINGS
[0042] The accompanying drawings are used to provide further understanding of the technical solution of the present application and constitute a part of the specification. Together with the embodiments of the present application, they are used to explain the technical solution of the present application and do not constitute a limitation on the technical solution of the present application.
[0043] Figure 1 is a flowchart of a database field processing method provided by an embodiment of the present application;
[0044] Figure 2 is a specific flow chart of step S200 provided in one embodiment of the present application;
[0045] Figure 3 is a specific flow chart of step S300 provided in one embodiment of the present application;
[0046] Figure 4 is a specific flow chart of step S400 provided in one embodiment of the present application;
[0047] Figure 5 is a specific flow chart of step S430 provided by an embodiment of the present application;
[0048] Figure 6 is a specific flow chart of step S500 provided in one embodiment of the present application;
[0049] Figure 7 is a flow chart of a method for encrypting a database field to be processed provided by an embodiment of the present application;
[0050] Figure 8 is a schematic diagram of a database field processing device provided by an embodiment of the present application;
[0051] Fig. 9 It is a schematic diagram of an electronic device provided by an embodiment of the present application. DETAILED DESCRIPTION
[0052] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application 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 application and are not used to limit the present application.
[0053] It should be noted that although the functional modules are divided in the device schematic diagram and the logical order is shown in the flowchart, in some cases, the steps shown or described may be performed in a different order than the module division in the device or the order in the flowchart. The terms "first", "second", etc. in the specification and claims and the above drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence.
[0054] It should be noted that, unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which this application belongs. The terms used herein are only for the purpose of describing the embodiments of this application and are not intended to limit this application.
[0055] The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. Artificial Intelligence (AI) is the theory, method, technology and application system that uses digital computers or machines controlled by digital computers to simulate, extend and expand human intelligence, perceive the environment, acquire knowledge and use knowledge to obtain the best results.
[0056] AI is a new technical science that studies and develops theories, methods, technologies and application systems for simulating, extending and expanding human intelligence. Artificial intelligence is a branch of computer science. Artificial intelligence attempts to understand the essence of intelligence and produce a new intelligent machine that can respond in a similar way to human intelligence. Research in this field includes robots, language recognition, image recognition, natural language processing and expert systems. Artificial intelligence can simulate the information process of human consciousness and thinking. Artificial intelligence is also a theory, method, technology and application system that uses digital computers or machines controlled by digital computers to simulate, extend and expand human intelligence, perceive the environment, acquire knowledge and use knowledge to obtain the best results.
[0057] AI basic technologies generally include sensors, dedicated AI chips, cloud computing, distributed storage, big data processing technology, operation / interaction systems, mechatronics, etc. AI software technologies mainly include computer vision technology, robotics technology, biometrics technology, speech processing technology, natural language processing technology, and machine learning / deep learning.
[0058] Artificial intelligence is AI. AI is the theory, method, technology and application system that uses digital computers or machines controlled by digital computers to simulate, extend and expand human intelligence, perceive the environment, acquire knowledge and use knowledge to obtain the best results.
[0059] The servers involved in artificial intelligence technology can be independent servers or cloud servers that provide basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (CDN), as well as big data and artificial intelligence platforms.
[0060] The present application provides a database field processing method, device, electronic device and computer-readable storage medium. In the process of database field processing, firstly, the database field to be processed is obtained; then, the attributes of the database field to be processed are analyzed and processed to obtain field attribute information; then, according to the field attribute information, input and output parameters are captured from the database corresponding to the data field to be processed; then, the database operation mode information is determined according to the input and output parameters; finally, the database field to be processed is transformed according to the database operation mode information and the preset configuration strategy. Through the above technical scheme, the database field to be processed can be transformed and processed simply and quickly, and in the process of modifying the transformation process of the database field to be processed, only the relevant information parameters need to be modified, so that the database field processing method of the present application has strong scalability.
[0061] The database field processing method provided in the embodiment of the present application relates to the field of financial technology. The database field processing method provided in the embodiment of the present application can be applied to a terminal, can be applied to a server side, or can be software running in a terminal or a server side. In some embodiments, the terminal can be a smart phone, a tablet computer, a laptop computer, a desktop computer, etc.; the server side can be configured as an independent physical server, or a server cluster or distributed system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms; the software can be an application that implements the database field processing method, etc., but is not limited to the above forms.
[0062] The present application can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, etc. The present application can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform specific tasks or implement specific abstract data types. The present application can also be practiced in distributed computing environments, in which tasks are performed by remote processing devices connected through a communication network. In a distributed computing environment, program modules can be located in local and remote computer storage media including storage devices.
[0063] It should be noted that in each specific implementation of the present application, when it comes to the need to perform relevant processing based on data related to user identity or characteristics such as user information, user behavior data, user historical data, and user location information, the user's permission or consent will be obtained first, and the collection, use, and processing of these data will comply with relevant laws, regulations, and standards. In addition, when the embodiment of the present application needs to obtain the user's sensitive personal information, the user's separate permission or consent will be obtained through a pop-up window or by jumping to a confirmation page. After clearly obtaining the user's separate permission or consent, the necessary user-related data for the normal operation of the embodiment of the present application will be obtained.
[0064] The embodiments of the present application are further described below in conjunction with the accompanying drawings.
[0065] like Figure 1 As shown, Figure 1 It is a flowchart of a database field processing method provided by an embodiment of the present application. The database field processing method includes but is not limited to steps S100 to S500.
[0066] Step S100, obtaining the database fields to be processed;
[0067] Step S200, analyzing the attributes of the database field to be processed to obtain field attribute information;
[0068] Step S300, capturing input and output parameters from a database corresponding to the data field to be processed according to the field attribute information;
[0069] Step S400, determining database operation mode information according to input and output parameters;
[0070] Step S500: transform the database fields to be processed according to the database operation mode information and the preset configuration strategy.
[0071] It should be noted that, in the process of database field processing, first obtain the database field to be processed; then analyze and process the attributes of the database field to be processed to obtain field attribute information; then capture input and output parameters from the database corresponding to the data field to be processed according to the field attribute information; then determine the database operation mode information according to the input and output parameters; finally, transform the database field to be processed according to the database operation mode information and the preset configuration strategy. Through the above technical solution, the database field to be processed can be transformed and processed simply and quickly, and in the process of modifying the transformation process of the database field to be processed, only the relevant information parameters need to be modified, so that the database field processing method of the present application has strong scalability.
[0072] It is worth noting that a database field is an element in a database table that is used to store a single data item of data. In a database, tables are usually used to organize data, while fields are used to define the data type and attributes of each column in the table. Each field has its data type, such as integer, floating point number, string, date, etc. When designing a database, it is very important to reasonably define fields and their data types for data storage, query, and maintenance. The database field to be processed is the database field that is ready for identification and encryption. For example, in the financial industry, it is often necessary to use various application systems to manage various businesses, and each application system needs to use a database to store relevant data. There is some sensitive information in the database that needs to be encrypted. Encrypt these sensitive information to prevent information leakage. For example, the user's name and phone number, these information need to be encrypted.
[0073] It is worth noting that the field attribute information can be obtained by analyzing the attributes of the database fields to be processed; among them, the field attribute information includes the effectiveness mode information and the field type information, and the effectiveness mode information includes the configuration class effectiveness information and the method effectiveness information; the field attribute information can be obtained by analyzing the attributes of the database fields to be processed, so as to make the prerequisite preparation for the subsequent encryption of the database fields to be processed.
[0074] It is worth noting that, when the field attribute information is obtained, the input and output parameters can be captured from the database corresponding to the data field to be processed according to the field attribute information, and the corresponding database operation mode information can be determined by capturing the input and output parameters, and then the database field to be processed can be encrypted or decrypted according to the determined database operation mode information and the preset configuration strategy. Among them, the database operation includes adding data to the database, updating the data in the database, and querying the data in the database.
[0075] It is worth noting that the preset configuration strategy is a pre-set strategy. After the database operation mode information is determined, the database fields to be processed can be transformed according to the database operation mode information and the pre-set strategy; when adjusting and modifying the transformation process, it is only necessary to adjust and modify the pre-set configuration strategy, so that the entire database field processing process can be modified more simply, conveniently and quickly, and the entire database field processing process has good scalability.
[0076] It is worth noting that in the process of obtaining the database fields to be processed, the user's permission or consent will be obtained first, and the collection, use and processing of these data will comply with relevant laws, regulations and standards. In addition, when the embodiment of the present application needs to obtain the user's sensitive personal information, the user's separate permission or consent will be obtained through a pop-up window or jump to a confirmation page. After the user's separate permission or consent is clearly obtained, the necessary user-related data for the normal operation of the embodiment of the present application will be obtained.
[0077] It is worth noting that, through the above technical solution, only simple configuration is needed to transform the database fields to be processed, which has strong scalability, is very lightweight, and is very convenient to configure; the configuration strategy of the technical solution of the embodiment of the present application is very complete and can basically cover all usage scenarios without the need for developers to perform additional development; for different fields of different databases, it can be achieved by simply adjusting the configuration parameters.
[0078] In some embodiments, Figure 2 As shown, the above step S200 may include but is not limited to steps S210 to S230.
[0079] Step S210, parsing the validation mode of the database field to be processed to obtain validation mode information;
[0080] Step S220, parsing the field type of the database field to be processed to obtain field type information.
[0081] It should be noted that, in the process of analyzing the attributes of the database field to be processed to obtain the field attribute information, the effectiveness mode of the database field to be processed is first parsed and processed to obtain the effectiveness mode information; the field type of the database field to be processed is parsed and processed to obtain the field type information, wherein the field attribute information includes the effectiveness mode information and the field type information; through the above technical solution, it is possible to simply and quickly analyze and process the attributes of the data field to be processed to obtain the corresponding field attribute information, so as to prepare for the subsequent transformation of the database field to be processed.
[0082] It is worth noting that the effectiveness information includes configuration class effectiveness information and method effectiveness information. Different input and output parameters can be extracted according to different effectiveness information, and then the database fields to be processed can be transformed according to the input and output parameters and the preset configuration strategy. Among them, the configuration class effectiveness information is the effectiveness of the database fields to be processed on the class, and the method effectiveness information is the effectiveness of the database fields to be processed on the method.
[0083] It is worth noting that the field type refers to the field type of the database field to be processed, such as integer type, floating point type, string type, Boolean type, and enumeration type, etc. Input and output parameters refer to the input parameters and output parameters of the database.
[0084] For example, in the financial industry, to encrypt the pending database fields of a database in an intelligent dialogue system, it is necessary to parse the effectiveness mode and field type of the pending database fields in the database to determine the effectiveness mode information and field type information respectively, in order to prepare for the subsequent transformation of the pending database fields.
[0085] In some embodiments, Figure 3 As shown, the above step S300 may include but is not limited to step S310 to step S320.
[0086] Step S310, when the validation mode information includes configuration validation information, extracting input and output parameters from a database corresponding to the configuration validation information according to the field type information;
[0087] Step S320: When the validation mode information includes method validation information, input and output parameters are extracted from a database corresponding to the method validation information according to the field type information.
[0088] It should be noted that in the process of capturing input and output parameters from the database corresponding to the data field to be processed according to the field attribute information, when the effective mode information includes the configuration class effective information, the input and output parameters can be extracted from the database corresponding to the configuration class effective information according to the field type information; when the effective mode information includes the method effective information, the input and output parameters can be extracted from the database corresponding to the method effective information according to the field type information; the database operation mode information can be determined through the input and output parameters, and then the database field to be processed can be transformed according to the database operation mode information and the preset configuration strategy. According to the above technical scheme, different input and output parameters are determined according to different effective mode information, and the database field to be processed can be processed according to different input and output parameters later, and the whole processing transformation process is simple and fast.
[0089] For example, in a financial application system, when the effectiveness information includes configuration class effectiveness information and the field type is an integer, integer input parameters and output parameters will be extracted from the database corresponding to the configuration class effectiveness information to prepare for subsequent transformations of the database fields to be processed.
[0090] In some embodiments, Figure 4 As shown, the above step S400 may include but is not limited to step S410 to step S430.
[0091] Step S410, performing attribution analysis on the input and output parameters to obtain parameter attribution information;
[0092] Step S420, determining parameter source information according to parameter attribution information;
[0093] Step S430, determining database operation mode information according to parameter source information.
[0094] It should be noted that in the process of determining the database operation mode information based on the input and output parameters, the parameter attribution information can be obtained by first performing attribution analysis on the input and output parameters; then the parameter source information is determined based on the parameter attribution information; finally, the database operation mode information is determined based on the parameter source information, and then the database fields to be processed can be transformed based on the database operation mode information. The whole process is simple and fast.
[0095] Exemplarily, when the parameter attribution information obtained by performing attribution analysis on the input and output parameters indicates that the parameters are derived from an external data set, the parameter data is derived from an external data set, and therefore it can be determined that the external data needs to be added to the database.
[0096] In some embodiments, Figure 5 As shown, the above step S430 may include but is not limited to steps S431 to S433.
[0097] Step S431, when the parameter source information includes data adding collection information, determining data adding operation information according to the data adding collection information;
[0098] Step S432, when the parameter source information includes data update collection information, determining data update operation information according to the data update collection information;
[0099] Step S433: when the parameter source information includes data query information, determine data query operation information according to the data query information.
[0100] It should be noted that in the process of determining the database operation mode information according to the parameter source information, when the parameter source information includes data addition collection information, the data addition operation information can be determined according to the data addition collection information; when the parameter source information includes data update collection information, the data update operation information can be determined according to the data update collection information; when the parameter source information includes data query information, the data query operation information can be determined according to the data query information. Different operation information can be determined according to different parameter source information, so that the database field to be processed can be transformed and processed according to different operation information and corresponding configuration strategies.
[0101] It is worth noting that, when the parameter source information includes data addition collection information, it can be determined that external data is being added to the database; when the parameter source information includes data update collection information, it can be determined that the data in the database is being updated; when the parameter source information includes data query information, it can be determined that information query processing is being performed on the database. Exemplarily, for an intelligent question-and-answer robot system, when it is determined that the parameter source information includes data addition collection information, it is determined that data is currently being added to the database of the question-and-answer robot system; when the parameter source information includes data update collection information, it is determined that the database of the question-and-answer robot system is currently being updated; when the parameter source information includes data query information, it is determined that the database of the question-and-answer robot system is currently being queried.
[0102] In some embodiments, Figure 6 As shown, the above step S500 may include but is not limited to step S510 to step S530.
[0103] Step S510, when the database operation mode information includes data adding operation information, encrypting the database field to be processed;
[0104] Step S520, when the database operation mode information includes data update operation information, encrypt the database field to be processed;
[0105] Step S530: When the database operation mode information includes data query operation information, decrypt the database field to be processed.
[0106] It should be noted that, in the process of transforming the database fields to be processed according to the database operation mode information and the preset configuration strategy, when the database operation mode information includes data adding operation information, the database fields to be processed can be encrypted; when the database operation mode information includes data updating operation information, the database fields to be processed can be encrypted; when the database operation mode information includes data query operation information, the database fields to be processed can be decrypted; through the above technical solution, corresponding operations can be performed on the corresponding database fields to be processed according to different database operation mode information, so that the processing of the database fields to be processed can be simpler and faster. Based on the above technical solution, the leakage of sensitive information can be well prevented and security is improved.
[0107] In some embodiments, Figure 7 As shown, the process of encrypting the database field to be processed may include but is not limited to step S610 and step S620.
[0108] Step S610, performing hash encryption on the database field to be processed;
[0109] Step S620: perform standard symmetric encryption on the database field to be processed.
[0110] It should be noted that, in the process of encrypting the database fields to be processed, the database fields to be processed may be hashed or symmetrically encrypted. The above two encryption methods can effectively prevent leakage of sensitive information.
[0111] It is worth noting that hash encryption is a one-way encryption technology that converts data of arbitrary length into a string of fixed length, which is usually called a hash value. Here are some key features of hash encryption: hash functions are one-way, meaning you cannot recover the original data from the hash value; the length of the output hash value is fixed regardless of the size of the input data; the same input data always produces the same hash value; a small change in the input data will result in a significant change in the hash value, which is called the avalanche effect; hash functions are usually fast to calculate; a high-quality hash algorithm makes it difficult to find two different input values that produce the same output hash value, which is called collision resistance. Standard symmetric encryption is an encryption method that uses the same key to encrypt and decrypt data; this encryption method is fast and suitable for encryption processing of large amounts of data. Here are some key features of symmetric encryption: The same key is used for encryption and decryption, so both the sender and the receiver must have this key; Symmetric encryption algorithms are generally computationally efficient and suitable for real-time data transmission or encryption of large amounts of data; Symmetric encryption is considered very secure as long as the key remains secure; Symmetric encryption algorithms can use different modes to enhance security, such as electronic code books, cipher block chaining, counters, etc.; Since symmetric encryption usually requires data length to meet specific requirements, padding may be required to ensure that the data meets these requirements; Symmetric encryption algorithms are generally designed to be able to detect whether the data has been tampered with during transmission.
[0112] In addition, if Figure 8 As shown, an embodiment of the present application further provides a database field processing device 10, comprising:
[0113] The first processing module 100 is used to obtain a database field to be processed;
[0114] The second processing module 200 is used to analyze the attributes of the database field to be processed to obtain field attribute information;
[0115] The third processing module 300 is used to capture input and output parameters from the database corresponding to the data field to be processed according to the field attribute information;
[0116] The fourth processing module 400 is used to determine the database operation mode information according to the input and output parameters;
[0117] The fifth processing module 500 is used to transform the database fields to be processed according to the database operation mode information and the preset configuration strategy.
[0118] It should be noted that, in the process of database field processing, first obtain the database field to be processed; then analyze and process the attributes of the database field to be processed to obtain field attribute information; then capture input and output parameters from the database corresponding to the data field to be processed according to the field attribute information; then determine the database operation mode information according to the input and output parameters; finally, transform the database field to be processed according to the database operation mode information and the preset configuration strategy. Through the above technical solution, the database field to be processed can be transformed and processed simply and quickly, and in the process of modifying the transformation process of the database field to be processed, only the relevant information parameters need to be modified, so that the database field processing method of the present application has strong scalability.
[0119] It is worth noting that the field attribute information can be obtained by analyzing the attributes of the database fields to be processed; among them, the field attribute information includes the effectiveness mode information and the field type information, and the effectiveness mode information includes the configuration class effectiveness information and the method effectiveness information; the field attribute information can be obtained by analyzing the attributes of the database fields to be processed, so as to make the prerequisite preparation for the subsequent encryption of the database fields to be processed.
[0120] It is worth noting that, when the field attribute information is obtained, the input and output parameters can be captured from the database corresponding to the data field to be processed according to the field attribute information, and the corresponding database operation mode information can be determined by capturing the input and output parameters, and then the database field to be processed can be encrypted or decrypted according to the determined database operation mode information and the preset configuration strategy. Among them, the database operation includes adding data to the database, updating the data in the database, and querying the data in the database.
[0121] It is worth noting that the preset configuration strategy is a pre-set strategy. After the database operation mode information is determined, the database fields to be processed can be transformed according to the database operation mode information and the pre-set strategy; when adjusting and modifying the transformation process, it is only necessary to adjust and modify the pre-set configuration strategy, so that the entire database field processing process can be modified more simply, conveniently and quickly, and the entire database field processing process has good scalability.
[0122] It is worth noting that in the process of obtaining the database fields to be processed, the user's permission or consent will be obtained first, and the collection, use and processing of these data will comply with relevant laws, regulations and standards. In addition, when the embodiment of the present application needs to obtain the user's sensitive personal information, the user's separate permission or consent will be obtained through a pop-up window or jump to a confirmation page. After the user's separate permission or consent is clearly obtained, the necessary user-related data for the normal operation of the embodiment of the present application will be obtained.
[0123] It is worth noting that, through the above technical solution, only simple configuration is needed to transform the database fields to be processed, which has strong scalability, is very lightweight, and is very convenient to configure; the configuration strategy of the technical solution of the embodiment of the present application is very complete and can basically cover all usage scenarios without the need for developers to perform additional development; for different fields of different databases, it can be achieved by simply adjusting the configuration parameters.
[0124] The specific implementation of the database field processing device 10 is substantially the same as the specific implementation of the above-mentioned database field processing method, and will not be described in detail herein.
[0125] In addition, if Fig. 9 As shown, an embodiment of the present application further provides an electronic device 700 , which includes: a memory 720 , a processor 710 , and a computer program stored in the memory 720 and executable on the processor 710 .
[0126] The processor 710 and the memory 720 may be connected via a bus or in other ways.
[0127] The non-transitory software programs and instructions required to implement the database field processing methods of the above embodiments are stored in the memory 720 , and when executed by the processor 710 , the database field processing methods of the above embodiments are executed.
[0128] The device embodiments described above are merely illustrative, and the units described as separate components may or may not be physically separated, that is, they may be located in one place or distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0129] In addition, an embodiment of the present application further provides a computer-readable storage medium, which stores computer-executable instructions, and the computer-executable instructions are executed by a processor 710 or a controller, for example, by a processor 710 in the above-mentioned device embodiment, so that the above-mentioned processor 710 can execute the database field processing method in the above-mentioned embodiment.
[0130] The above embodiments may be used in combination, and modules with the same name in different embodiments may be the same or different.
[0131] The above describes specific embodiments of the present application, and other embodiments are within the scope of the appended claims. In some cases, the actions or steps recorded in the claims can be performed in an order different from that in the embodiments and still achieve the desired results. In addition, the processes depicted in the accompanying drawings do not necessarily have to be performed in the specific order or continuous order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
[0132] Each embodiment in this application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device, equipment, and computer-readable storage medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiments.
[0133] The apparatus, device, computer-readable storage medium and method provided in the embodiments of the present application correspond to each other. Therefore, the apparatus, device and non-volatile computer storage medium also have similar beneficial technical effects as the corresponding methods. Since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the corresponding apparatus, device and computer storage medium will not be repeated here.
[0134] In the 1990s, it was very clear whether the improvement of a technology was hardware improvement (for example, improvement of the circuit structure of diodes, transistors, switches, etc.) or software improvement (improvement of the method flow). However, with the development of technology, many improvements of the method flow today can be regarded as direct improvements of the hardware circuit structure. Designers almost always obtain the corresponding hardware circuit structure by programming the improved method flow into the hardware circuit. Therefore, it cannot be said that the improvement of a method flow cannot be implemented with a hardware entity module. For example, a programmable logic device (PLD) (such as a field programmable gate array (FPGA)) is such an integrated circuit whose logical function is determined by the user's programming of the device. Designers can "integrate" a digital system on a PLD by programming it themselves, without having to ask chip manufacturers to design and produce dedicated integrated circuit chips. Moreover, nowadays, instead of manually making integrated circuit chips, this kind of programming is mostly implemented by "logic compiler" software, which is similar to the software compiler used when developing and writing programs. The original code before compiling must also be written in a specific programming language, which is called Hardware Description Language (HDL). There is not only one kind of HDL, but many kinds, such as ABEL (Advanced Bootean Express Language), AHDL (Altera Hardware Description Language), Confluence, CUPL (Cornell Unity Programming Language), HDCal, JHDL (Java Hardware Description Language), Lava, Lola, MyHDL, PALASM, RHDL (Ruby Hardware Description Language), etc. The most commonly used one is VHDL (Very-High-Speed Integrated Circuit Hardware Description Language). Descript i on Language) and Ver il og.Those skilled in the art should also be aware that it is easy to obtain a hardware circuit that implements the logical method flow by simply performing some logic programming on the method flow using the above-mentioned hardware description languages and programming it into an integrated circuit.
[0135] The controller can be implemented in any appropriate manner, for example, the controller can take the form of a microprocessor or processor and a computer-readable medium storing a computer-readable program code (such as software or firmware) that can be executed by the (micro)processor, a logic gate, a switch, an application-specific integrated circuit (ASIC), a programmable logic controller, and an embedded microcontroller. Examples of controllers include, but are not limited to, the following microcontrollers: ARC 625D, Atmel AT91 SAM, Microchip PIC18F26K20, and Silicon Labs C8051 F320. The memory controller can also be implemented as part of the control logic of the memory. Those skilled in the art also know that in addition to implementing the controller in a purely computer-readable program code manner, the controller can be implemented in the form of a logic gate, a switch, an application-specific integrated circuit, a programmable logic controller, and an embedded microcontroller by logically programming the method steps. Therefore, this controller can be considered as a hardware component, and the devices included therein for implementing various functions can also be regarded as structures within the hardware component. Or even, the means for realizing various functions may be regarded as both a software module for realizing the method and a structure within a hardware component.
[0136] The systems, devices, modules or units described in the above embodiments may be implemented by computer chips or entities, or by products with certain functions. A typical implementation device is a computer. Specifically, the computer may be, for example, a personal computer, a laptop computer, a cellular phone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
[0137] For the convenience of description, the above devices are described in terms of functions and are divided into various units. Of course, when implementing the embodiments of the present application, the functions of each unit can be implemented in the same or multiple software and / or hardware.
[0138] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the embodiments of the present application may adopt the form of complete hardware embodiments, complete software embodiments, or embodiments in combination with software and hardware. Moreover, the embodiments of the present application may adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code.
[0139] This specification is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0140] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.
[0141] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.
[0142] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.
[0143] The memory may include non-permanent storage in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash memory (Flash RAM). The memory is an example of a computer-readable medium.
[0144] Computer readable media include permanent and non-permanent, removable and non-removable media that can be used to store information by any method or technology. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassettes, magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (Transitory Med ia), such as modulated data signals and carrier waves.
[0145] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.
[0146] In the embodiments of the present application, "at least one" refers to one or more, and "more than one" refers to two or more. "And / or" describes the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can represent the existence of A alone, the existence of A and B at the same time, and the existence of B alone. Among them, A and B can be singular or plural. The character " / " generally indicates that the previous and next associated objects are in an "or" relationship. "At least one of the following" and similar expressions refer to any combination of these items, including any combination of single or plural items. For example, at least one of a, b and c can be represented by: a, b, c, a and b, a and c, b and c, or a and b and c, where a, b, c can be single or multiple.
[0147] Embodiments of the present application may be described in the general context of computer executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform specific tasks or implement specific abstract data types. Embodiments of the present application may also be practiced in distributed computing environments, where tasks are performed by remote processing devices connected via a communication network. In a distributed computing environment, program modules may be located in local and remote computer storage media, including storage devices.
[0148] Each embodiment in this application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.
[0149] The above is only an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims
1. A database field processing method, characterized in that: The method comprises: Get the database fields to be processed; Analyzing the attributes of the database field to be processed to obtain field attribute information; Capturing input and output parameters from a database corresponding to the data field to be processed according to the field attribute information; Determine the database operation mode information according to the input and output parameters; The database fields to be processed are transformed according to the database operation mode information and a preset configuration strategy.
2. The database field processing method according to claim 1, characterized in that: The step of analyzing the attributes of the database field to be processed to obtain field attribute information includes: Parsing the validation mode of the database field to be processed to obtain validation mode information; Parsing the field type of the database field to be processed to obtain field type information; The field attribute information includes the validation mode information and the field type information.
3. The database field processing method according to claim 2, characterized in that: The step of capturing input and output parameters from a database corresponding to the data field to be processed according to the field attribute information includes at least one of the following: In the case where the validation mode information includes configuration validation information, extracting the input and output parameters from a database corresponding to the configuration validation information according to the field type information; In the case where the validation mode information includes method validation information, the input and output parameters are extracted from a database corresponding to the method validation information according to the field type information.
4. The database field processing method according to claim 1, characterized in that: The determining of the database operation mode information according to the input and output parameters includes: Performing attribution analysis on the input and output parameters to obtain parameter attribution information; Determine parameter source information according to the parameter attribution information; The database operation mode information is determined according to the parameter source information.
5. The database field processing method according to claim 1, characterized in that: The determining the database operation mode information according to the parameter source information includes at least one of the following: In the case where the parameter source information includes data adding and collecting information, determining the data adding operation information according to the data adding and collecting information; In a case where the parameter source information includes data update collection information, determining the data update operation information according to the data update collection information; In a case where the parameter source information includes data query information, the data query operation information is determined according to the data query information.
6. The database field processing method according to claim 5, characterized in that: The transforming of the to-be-processed database field according to the database operation mode information and the preset configuration strategy includes: In the case where the database operation mode information includes the data adding operation information, encrypting the database field to be processed; In the case where the database operation mode information includes the data update operation information, encrypting the database field to be processed; In the case where the database operation mode information includes the data query operation information, the to-be-processed database field is decrypted.
7. The database field processing method according to claim 6, characterized in that: The encrypting the database field to be processed includes one of the following: Performing hash encryption on the database field to be processed; The database field to be processed is subjected to standard symmetric encryption.
8. A database field processing device, characterized in that: include: The first processing module is used to obtain the database fields to be processed; A second processing module is used to analyze the attributes of the database field to be processed to obtain field attribute information; A third processing module is used to capture input and output parameters from a database corresponding to the data field to be processed according to the field attribute information; A fourth processing module, used to determine database operation mode information according to the input and output parameters; The fifth processing module is used to transform the database field to be processed according to the database operation mode information and a preset configuration strategy.
9. An electronic device, comprising: A memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the database field processing method according to any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium storing computer-executable instructions, characterized in that: The computer executable instructions are used to execute the database field processing method described in any one of claims 1 to 7.
