Data processing method and device, electronic equipment and computer readable storage medium

Abstract

The invention relates to the field of data processing, and provides a data processing method and device, electronic equipment and a computer readable storage medium, the method comprises the steps that database modification table item information is acquired, and the database modification table item information comprises database marking information, component marking information and modification parameter information; determining a target database from a preset data management system according to the database marking information; determining a target component from preset system components according to the component marking information; loading the modification parameter information into the target component to form modification object information; analyzing and processing the modified object information to obtain structured query language parameter information; and performing mapping processing on the target database according to the structured query language parameter information to obtain a data processing result. According to the technical scheme, the modification process of the data table can be simplified, and the flexibility of data modification can be improved.

Description

Technical Field

[0001] The embodiments of the present application relate to but are not limited to the field of data processing, and in particular, to a data processing method, device, electronic device, and computer-readable storage medium. Background Art

[0002] In an intelligent business management platform, it is necessary to use multiple different project management modules to manage and coordinate related business data. A complex business management system often corresponds to multiple databases to meet different functional requirements. For example, in property insurance business management systems, digital medical management systems, or health and elderly care service business management systems, Mybatis is usually used as the framework system. Since Mybatis is a persistence layer framework and belongs to object-relational mapping, there is no need to write structured query language after the configuration file is written, which can greatly simplify the data management process. Therefore, it is widely used in various business management industries. However, in the object-relational mapping framework, the data required for different scenarios is changing. Each time a new change attribute is added, the configuration attributes of the corresponding field need to be modified. The scope of system changes is relatively large, and the details of the changes are relatively many, which are easy to miss. In addition, the configuration file needs to be rewritten for the new data table, which has low reusability and poor flexibility. 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 data processing method, device, electronic device and computer-readable storage medium, which can simplify the modification process of the data table and improve the flexibility of data modification.

[0005] In a first aspect, an embodiment of the present application provides a data processing method, including:

[0006] Acquire database modification table item information, wherein the database modification table item information includes database tag information, component tag information and modification parameter information;

[0007] Determining a target database from a preset data management system according to the database tag information; and determining a target component from preset system components according to the component tag information;

[0008] Loading the modification parameter information into the target component to form modification object information;

[0009] Parsing the modification object information to obtain structured query language parameter information;

[0010] The target database is mapped according to the structured query language parameter information to obtain a data processing result.

[0011] In a second aspect, an embodiment of the present application provides a data processing device, including:

[0012] An acquiring unit, used for acquiring database modification table item information, wherein the database modification table item information includes database tag information, component tag information and modification parameter information;

[0013] A selection unit, configured to determine a target database from a preset data management system according to the database tag information; and to determine a target component from preset system components according to the component tag information;

[0014] A loading unit, used for loading the modification parameter information into the target component to form modification object information;

[0015] A parsing unit, used for parsing the modification object information to obtain structured query language parameter information;

[0016] A mapping unit is used to perform mapping processing on the target database according to the structured query language parameter information to obtain a data processing result.

[0017] In a third aspect, an embodiment of the present application provides 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 data processing method as described above when executing the computer program.

[0018] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium storing computer-executable instructions, wherein the computer-executable instructions are used to execute the data processing method as described above.

[0019] The data processing method according to the embodiment provided in the present application has at least the following beneficial effects: in the process of data processing, firstly, database modification table item information is obtained, wherein the database modification table item information includes database tag information, component tag information and modification parameter information; then, the target database is determined from a preset data management system according to the database tag information; and, the target component is determined from a preset system component according to the component tag information; then, the modification parameter information is loaded into the target component to form modification object information; then, the modification object information is parsed to obtain structured query language parameter information; finally, the target database is mapped according to the structured query language parameter information to obtain the data processing result. Through the above technical scheme, after obtaining the database modification table item information, the target database can be determined according to the database tag information in the database modification table item information, and the target component can also be determined from the preset system components according to the component tag information. Through the above method, the determination of the target database and the target component can be faster and more flexible; then the modification parameter information is loaded into the target component to form the modification object information; then the modification object information is parsed to obtain the structured query language parameter information; finally, the target database is mapped based on the structured query language parameter information to obtain the data processing result, so that the modification of the database can be more intelligent and simple. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] 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.

[0021] Figure 1 It is a flowchart of a data processing method provided by an embodiment of the present application;

[0022] Figure 2 yes Figure 1 A schematic flow chart of a specific implementation of step S200;

[0023] Figure 3 yes Figure 1 Another specific implementation flow diagram of step S200;

[0024] Figure 4 yes Figure 1 A schematic flow chart of a specific implementation of step S300;

[0025] Figure 5 yes Figure 1 A schematic flow chart of a specific implementation of step S400;

[0026] Figure 6 yes Figure 1 A schematic flow chart of a specific implementation of step S500;

[0027] Figure 7 is a flowchart of a data processing method provided by another embodiment of the present application;

[0028] Figure 8 is a schematic diagram of a data processing device provided by an embodiment of the present application;

[0029] Fig. 9 It is a schematic diagram of an electronic device provided by an embodiment of the present application. DETAILED DESCRIPTION

[0030] 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.

[0031] 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.

[0032] 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.

[0033] The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. Among them, 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.

[0034] 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.

[0035] 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.

[0036] 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.

[0037] 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.

[0038] The present application provides a data processing method, device, electronic device and computer-readable storage medium. In the process of data processing, database modification table item information is first obtained, wherein the database modification table item information includes database tag information, component tag information and modification parameter information; then, a target database is determined from a preset data management system according to the database tag information; and, a target component is determined from a preset system component according to the component tag information; then, the modification parameter information is loaded into the target component to form modification object information; then, the modification object information is parsed to obtain structured query language parameter information; finally, the target database is mapped according to the structured query language parameter information to obtain the data processing result. Through the above technical scheme, after obtaining the database modification table item information, the target database can be determined according to the database tag information in the database modification table item information, and the target component can also be determined from the preset system components according to the component tag information. Through the above method, the determination of the target database and the target component can be faster and more flexible; then the modification parameter information is loaded into the target component to form the modification object information; then the modification object information is parsed to obtain the structured query language parameter information; finally, the target database is mapped based on the structured query language parameter information to obtain the data processing result, so that the modification of the database can be more intelligent and simple.

[0039] The data processing method provided in the embodiment of the present application relates to the field of data processing. The data 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 can be configured as a server cluster or a distributed system composed of multiple physical servers, and can also be configured as 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 data processing method, etc., but is not limited to the above forms.

[0040] 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.

[0041] 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.

[0042] The embodiments of the present application are further described below in conjunction with the accompanying drawings.

[0043] like Figure 1 As shown, Figure 1 : is a flow chart of a data processing method provided by an embodiment of the present application, the data processing method comprises the following steps:

[0044] Step S100: Obtain database modification entry information, wherein the database modification entry information includes database tag information, component tag information and modification parameter information.

[0045] The data processing method provided in the embodiment of the present application can be used to modify the database. For example, in the property insurance business management system, multiple databases can be included, and each database corresponds to a subsystem in the property insurance business management system one by one. Each subsystem load manages and processes a project in the property insurance business management system, such as the core business subsystem, risk management subsystem, customer management subsystem, sales and channel management subsystem, financial management subsystem, operation support subsystem, and data and decision support subsystem; when it is necessary to modify the data in the database of the property insurance business management system, first obtain the database modification table item information, and the database modification table item information includes database tag information, component tag information, and modification parameter information. Among them, the database tag information is used to refer to the tag information of different databases. Each database in the property insurance business management system will correspond to a unique database tag information, so that the database that needs to be modified can be accurately located. The component tag information is used to refer to the column name, data type, and constraint type, etc. The modification parameter information is used to refer to the parameters that need to be modified in the database. For another example, in a smart medical system, multiple databases may be included, and each database corresponds one-to-one to a subsystem in the smart medical system, and each subsystem is responsible for managing and processing a project in the smart medical system; when it is necessary to modify the data in the database in the smart medical system, the database modification table item information may be obtained first, and the database modification table item information includes database tag information, component tag information, and modification parameter information. Among them, the database tag information is used to refer to the tag information of different databases. Each database in the smart medical system will correspond to a unique database tag information. Through the above settings, the database that needs to be modified can be well located. The component tag information is used to refer to the fields in the database. The fields can be column names, data types, constraint types, etc. The modification parameter information is used to refer to the parameters that need to be modified in the database.

[0046] For example, in a health and elderly care service business management system, when the price of a healthy meal needs to be changed, the dietary database can be determined based on the database tag information in the database modification table information, and then the corresponding healthy meal can be determined from the dietary database based on the component tag information, and finally the price corresponding to the healthy meal can be modified based on the modification parameter information. For another example, in a smart medical system, when the price of a certain medicine needs to be changed, the medicine database can be determined based on the database tag information in the database modification table information, and then the corresponding medicine name can be determined from the medicine database based on the component tag information, and finally the medicine price corresponding to the medicine name can be modified based on the modification parameter information.

[0047] For example, when the accident insurance business management system is more complex, it is necessary to use multiple different databases to meet the different functional requirements of the accident insurance business management system; wherein the database in the accident insurance business management system may include a relational database and a non-relational database. For another example, when the smart medical system is more complex, it is necessary to use multiple different databases to meet the different functional requirements of the smart medical system; wherein the different databases of the smart medical system may include a relational database and a non-relational database. Among them, the relational databases of the accident insurance business management system and the smart medical system organize data in the form of tables, store data through rows and columns, and associate different tables through relationships (such as primary keys and foreign keys); the data structure of the relational database is clear, easy to understand and operate, and supports complex queries and transaction processing. The relational database is suitable for scenarios that require complex queries and transactional operations. The non-relational databases of the accident insurance business management system and the smart medical system do not rely on the traditional relational model, and the data storage method is more flexible and diverse, which can better cope with the needs of large-scale data storage and high concurrent access. In addition, according to different storage methods, the database of the smart medical system can be subdivided into key-value storage databases, document storage databases, column storage databases, and graph databases. Key-value storage databases store data in the form of key-value pairs. The key is unique and the corresponding value can be quickly retrieved through the key. The data structure is simple and the read and write speed is fast, but the query function is relatively limited. Document storage databases store data in the form of documents; each document can have a different structure, which is suitable for storing semi-structured data. Column storage databases organize data in the form of column families. Each column family contains multiple columns. The columns in the column family can be dynamically expanded. It is suitable for processing large-scale tabular data and has high query performance. Graph databases store data in a graph structure. Nodes represent entities and edges represent the relationship between entities. It is suitable for processing complex relational data, such as social networks, knowledge graphs, etc.

[0048] Step S200: determining a target database from a preset data management system according to database tag information; and determining a target component from preset system components according to component tag information.

[0049] After obtaining the database modification table item information, the embodiment of the present application can determine the target database from the pre-set data management system according to the database tag information, and can also determine the target component from the pre-set system component according to the component tag information. Exemplarily, the health and elderly care service business management system can include multiple databases, such as a customer management database, a health management database, a nursing management database, a residence management database, a cost management database, a logistics material management database, an intelligent monitoring and call database, etc., and each database will correspond to a database tag information, for example, the data tag information of the residence management database is "04", and then when the received database tag information is "04", the residence management database can be determined as the target database from the data management system. In addition, the system components of the health and elderly care service business management system can include multiple components, for example, data types, views, and backup and recovery components, etc.; and each component will correspond to a component tag information, exemplarily, the component tag information of the backup and recovery component is "02", and then the backup and recovery component can be determined as the target component from the system component according to the component tag information "02". For another example, the data management system of the smart medical system includes multiple databases, such as patient information management database, medical resource management database, medical business process management database, medical data analysis and decision support database, medical knowledge base and intelligent auxiliary diagnosis database, medical Internet of Things data management database, medical image management database, medical data security and privacy protection database, medical supply chain management database and medical scientific research management database, and each database will correspond to a database tag information. For example, the database tag information of the medical image management database is "02", and then the medical image management database can be determined as the target database from the data management system according to the database tag information "02". Similarly, the system components of the smart medical system include multiple components, such as the Internet of Things platform, the user authentication and authorization subsystem, the medical resource scheduling engine, the financial settlement interface and the self-service platform, and each component will correspond to a component tag information. For example, the component tag information of the medical resource scheduling engine is "03", and then the medical resource scheduling engine can be determined as the target component from the system components according to the component tag information "03".

[0050] It is worth noting that a data management system can usually manage multiple databases. A database is a warehouse that organizes, stores and manages data according to the data structure. A database usually contains multiple tables (for relational databases) or data sets (for non-relational databases) to store different types of data. A data management system is a software system used to create, manage, maintain and use databases. It can provide users with a unified interface to operate the database, including data addition, deletion, modification and query, data organization, data security management, data backup and recovery and other functions.

[0051] like Figure 2 As shown, in step S200, the data management system includes multiple databases, and determining the target database from the preset data management system according to the database tag information may include the following steps:

[0052] Step S210, matching the database tag information with the label information of each database in the data management system to obtain target label information;

[0053] Step S220: taking the database corresponding to the target label information as the target database.

[0054] For steps S210 to S220, in the process of determining the target database from the preset data management system based on the database tag information, the database tag information can be first matched with the label information of each database in the data management system, and then the target label information can be obtained; finally, the database corresponding to the target label information can be used as the target database to prepare for subsequent database modifications.

[0055] For example, in a property insurance business management system, multiple databases may be included, and each database will correspond to a unique label information. When the database label information of the financial management database is "01", the database label information "01" is matched with the label information of each database in the data management system, and the financial management database can be selected from the data management system. Finally, the financial management database can be used as the target database, and the selected financial management database can be prepared for modification. For another example, in a smart medical system, multiple databases are included, and each database will correspond to a unique label information; when the database label information of the medical Internet of Things data management database is "04", the database label information "04" is matched with the label information of each database in the data management system, and the medical Internet of Things data management database can be selected from the data management system. Finally, the medical Internet of Things data management database can be used as the target database, and the selected medical Internet of Things data management database can be prepared for modification; through the above technical solution, the target database can be determined from the data management system, so that the determination of the target database can be simpler and faster, and it can also prepare for subsequent database modification.

[0056] like Figure 3 As shown, in step S200, the system component includes multiple task components, and determining the target component from the preset system components according to the component tag information may include the following steps:

[0057] Step S230, matching the component tag information with the identification information of each task component in the system component to obtain target identification information;

[0058] Step S240: taking the task component corresponding to the target identification information as the target component.

[0059] For steps S230 to S240, in the process of determining the target component from the preset system components based on the component marking information, the component marking information can be first matched with the identification information of each task component in the system components to obtain the target identification information; finally, the task component corresponding to the target identification information can be used as the target component, which can also prepare for subsequent database modifications.

[0060] Exemplarily, in the system components of the property insurance business management system, there are multiple task components, and each task component corresponds to unique identification information; when the identification information of the sales and channel management component is "02", the identification information "02" is matched with the identification information of each task component in the system component, and the sales and channel management component can be selected from the system component, and finally the sales and channel management component can be used as the target component to prepare for subsequent database modifications. In the system components of a smart medical system, there are multiple task components, and each task component corresponds to unique identification information; when the identification information of the financial settlement interface is "03", the identification information "03" is matched with the identification information of each task component in the system component, and the financial settlement interface can be selected from the system component, and finally the financial settlement interface can be used as the target component to prepare for subsequent database modifications.

[0061] Step S300: Load the modification parameter information into the target component to form modification object information.

[0062] After the target component is determined from the preset system component according to the component tag information, the embodiment of the present application can load the modification parameter information in the database modification table item information into the target component, so as to form the modification object information, so as to prepare for the subsequent structured query language parameter information generation. Among them, in the process of loading the modification parameter information into the target component to form the modification object information, the target modification parameter is first determined from the modification parameter information; then the target component is initialized so that the target component enters the configuration mode; and the configuration file of the target component entering the configuration mode is modified by the target modification parameter to obtain the modification configuration information; finally, the modification configuration information is verified, and the modified configuration information that passes the verification is used as the modification object information, so as to prepare for the subsequent database modification. Exemplarily, in the property insurance business management system, when the target component is the regulatory agency interface component, the regulatory agency interface component can be initialized first, so that the regulatory agency interface component enters the configuration mode, and then the target modification parameter is modified on the regulatory agency interface component entering the configuration mode, so as to obtain the modification configuration information of the regulatory agency interface component, and finally the modification configuration information of the regulatory agency interface component is verified to obtain the corresponding modification object information. For another example, in a smart medical system, when the target component is a financial settlement interface, the financial settlement interface can be initialized first so that the financial settlement interface enters the configuration mode, and then the target modification parameters are used to modify the financial settlement interface that has entered the configuration mode to obtain the modified configuration information of the financial settlement interface. Finally, the modified configuration information of the financial settlement interface can be verified to obtain the modified object information.

[0063] It is worth noting that after obtaining the database modification table item information, the target component can be determined from the preset system components according to the component tag information in the database modification table item information; then the modification parameter information in the database modification table item information can be loaded into the target component, and the modification object information can be formed to prepare for the subsequent structured query language parameter information generation. Among them, structured query language parameter information generally refers to parameterized queries, parameter passing, and information related to structured query language involved when using structured query language for database operations. Parameterized query is a method of using parameters in structured query language statements instead of directly embedding values ​​into structured query language statements. This method can improve the security of the code, prevent structured query language injection attacks, and improve performance.

[0064] like Figure 4 As shown, in step S300, loading the modification parameter information into the target component to form the modification object information may include the following steps:

[0065] Step S310, determining a target modification parameter from the modification parameter information;

[0066] Step S320, initializing the target component so that the target component enters the configuration mode; and modifying the configuration file of the target component that enters the configuration mode by using the target modification parameter to obtain modified configuration information;

[0067] Step S330, verifying the modified configuration information, and using the modified configuration information that passes the verification as the modified object information.

[0068] For steps S310 to S330, in the process of loading the modification parameter information into the target component to form the modification object information, firstly, the target modification parameter is determined from the modification parameter information, and then the target component is initialized so that the target component enters the configuration mode; and the configuration file of the target component entering the configuration mode is modified by the target modification parameter to obtain the modification configuration information; finally, the modification configuration information is verified, and the modified configuration information that passes the verification is used as the modification object information. Among them, in the process of loading the modification parameter information into the target component to form the modification object information, firstly, the target modification parameter is determined from the modification parameter information, and then the target component is initialized so that the target component enters the configuration mode to prepare for the subsequent information loading; subsequently, the configuration file of the target component entering the configuration mode can be modified by the target modification parameter, so that the modification configuration information can be obtained; subsequently, the modification configuration information after the modification processing will be verified, so that the final modification object information can be more accurate, so that the subsequent target database modification can be more accurate, and the accuracy of the database modification is improved.

[0069] It is worth noting that only when the target component enters the configuration mode can the target modification parameters be used to modify the configuration file of the target component that enters the configuration mode; when the target component does not enter the configuration mode, the target modification parameters cannot be used to modify the configuration file of the target component that enters the configuration mode. And after obtaining the modified configuration information, the modified configuration information will be verified, and then the modified configuration information that passes the verification will be used as the modification object information, so that the subsequent target database modification can be more accurate. Among them, the process of verifying the modified configuration information can include format verification, logic verification, compatibility verification and security verification. Format verification is used to ensure that the modified configuration information meets the predefined format requirements, for example, whether the value of a configuration item in the modified configuration information is within a pre-set range; logic verification is used to ensure that the modified configuration information is logically reasonable; compatibility verification is used to ensure that the modified configuration information is compatible with other parts of the system; security verification is used to ensure that the modified configuration information is safe and reliable, for example, verifying whether the modified configuration information contains sensitive information.

[0070] Step S400: parsing the modification object information to obtain structured query language parameter information.

[0071] The embodiment of the present application can obtain structured query language parameter information by parsing the modified object information, so as to prepare for the subsequent mapping of the target database according to the structured query language parameter information. Among them, in the process of parsing the modified object information to obtain the structured query language parameter information, the modified object information can be first instantiated to obtain the instantiated object; then the instantiated object is analyzed and processed for the object attribute to obtain the object attribute value; finally, the object attribute value is converted to obtain the structured query language parameter information. Among them, structured query language is a standard programming language for managing and operating relational databases; when a user submits a structured query language statement, the database management system first parses the structured query language statement. The parser will check whether the syntax of the structured query language statement is correct, such as whether the keywords are used correctly, whether the brackets match, etc.; at the same time, the parser will also verify the objects (such as table names, column names) in the structured query language statement, check whether these objects exist and whether the user has the right to access. After the parsing is completed, the structured query language statement enters the optimization stage. The optimizer will select the best execution plan based on the database statistics (such as the number of rows in the table, the distribution of columns, etc.) and the characteristics of the query statement. For example, for a complex query, the optimizer may decide whether to perform a join operation or a filter operation first, or choose to use an index scan or a full table scan to obtain data. Different execution plans can lead to huge differences in query performance. The execution plan generated by the optimizer will be sent to the execution engine. The execution engine will step by step execute the operations of the structured query language statement according to the execution plan and finally generate the query results. During the execution process, the execution engine may involve multiple operations such as reading, writing, sorting, and joining data. The execution results will be returned to the user or stored in the database.Exemplarily, in a health and elderly care service business management system, the health management component serves as the target component, and the target modification parameters are used to modify the configuration file of the health management component that enters the configuration mode, so as to obtain the modified configuration information; then the modified configuration information is verified, and the modified configuration information that passes the verification is used as the modification object information of the health management component; then the modification object information of the health management component is parsed to obtain the corresponding structured query language parameter information, in order to prepare for the subsequent database modification corresponding to the health management component; for another example, in a smart medical system, the medical resource scheduling engine serves as the target component, and the target modification parameters are used to modify the configuration file of the medical resource scheduling engine that enters the configuration mode, so as to obtain the modified configuration information; then the modified configuration information is verified, and the modified configuration information that passes the verification is used as the modification object information of the medical resource scheduling engine; then the modification object information of the medical resource scheduling engine is parsed to obtain the corresponding structured query language parameter information, in order to prepare for the subsequent database modification corresponding to the medical resource scheduling engine.

[0072] like Figure 5 As shown, in step S400, parsing the modified object information to obtain structured query language parameter information may include the following steps:

[0073] Step S410, instantiating the modified object information to obtain an instantiated object;

[0074] Step S420, performing object attribute analysis on the instantiated object to obtain object attribute values;

[0075] Step S430: convert the object attribute value to obtain structured query language parameter information.

[0076] For steps S410 to S430, in the process of parsing the modified object information to obtain the structured query language parameter information in the embodiment of the present application, the modified object information is first instantiated to obtain the instantiated object; then the instantiated object is subjected to object attribute analysis to obtain the object attribute value; finally, the object attribute value is converted to obtain the structured query language parameter information, so as to prepare for the subsequent mapping of the structured query language parameter information. Among them, instantiation refers to converting an abstract class or data structure into a specific object instance. In programming, this usually means creating an object and allocating memory space for it; in database operations, the modified object information may be an abstract data structure (such as a class or a data model), which needs to be instantiated into a specific object for subsequent processing. Object attribute analysis refers to extracting the values ​​of each attribute of an object, which is usually achieved through reflection or similar mechanisms; in database operations, it is necessary to know the values ​​of each attribute of an object in order to map these values ​​to columns in a database table. Conversion processing refers to converting the attribute value of an object into a format suitable for use in a structured query language statement, which may include type conversion, formatting, etc. When generating a structured query language statement, it is necessary to ensure that the parameter value complies with the grammatical requirements of the structured query language statement.

[0077] Exemplarily, in a health and elderly care service business management system, the target component is a customer relationship management component. In the process of obtaining the structured query language parameter information of the customer relationship management component, the modified object information of the customer relationship management component can be instantiated to obtain an instantiated object first; then the object attribute analysis of the instantiated object can be performed to obtain the object attribute value; finally, the object attribute value is converted to obtain the structured query language parameter information corresponding to the customer relationship management component, so as to prepare for the subsequent modification of the database corresponding to the customer relationship management component. For another example, in a smart medical system, the target component is an Internet of Things platform. In the process of obtaining the structured query language parameter information of the Internet of Things platform, the modified object information of the Internet of Things platform can be instantiated to obtain an instantiated object first; then the object attribute analysis of the instantiated object can be performed to obtain the object attribute value; finally, the object attribute value is converted to obtain the structured query language parameter information corresponding to the Internet of Things platform, so as to prepare for the subsequent modification of the database corresponding to the Internet of Things platform.

[0078] It is worth noting that in the process of parsing the modified object information to obtain the structured query language parameter information, the abstract modified object information is first converted into a specific instantiated object, then the attribute value of the instantiated object is extracted to obtain the object attribute value, and finally the object attribute value is converted into the structured query language parameter information for constructing the structured query language statement.

[0079] Step S500: mapping the target database according to the structured query language parameter information to obtain a data processing result.

[0080] After the modification object information is parsed and processed to obtain the structured query language parameter information, the embodiment of the present application can map the target database according to the structured query language parameter information to obtain the data processing result, so as to modify the target database. Through the above technical solution, the target database can be modified simply and quickly. For example, in a property insurance business management system, it is necessary to modify the insurance amount database of the property insurance business management system. After obtaining the structured query parameter information, the insurance amount database can be mapped according to the structured query parameter information, so as to modify the insurance amount database. The whole process is simple and fast. For another example, in a smart medical system, in the process of modifying the patient information management database in the smart medical system, after obtaining the structured query parameter information, the patient information management database can be mapped according to the structured query parameter information, so as to modify the patient information management database. The whole process is simple, fast, and more flexible.

[0081] It is worth noting that in the process of mapping the target database according to the structured query language parameter information to obtain the data processing result, first, the instantiated object is connected to the target database according to the database connection information in the structured query language parameter information; then, the query statement information in the structured query language parameter information is executed to obtain the processing result set; then, the processing result set is traversed to obtain the traversal object data; finally, the target database is adjusted according to the traversal object data to obtain the corresponding data processing result.

[0082] like Figure 6 As shown, in step S500, mapping processing is performed on the target database according to the structured query language parameter information to obtain a data processing result, which may include the following steps:

[0083] Step S510, establishing a connection between the instantiated object and the target database according to the database connection information in the structured query language parameter information;

[0084] Step S520, executing the query statement information in the structured query language parameter information to obtain a processing result set;

[0085] Step S530, traverse the processing result set to obtain traversal object data;

[0086] Step S540: adjusting the target database according to the traversed object data to obtain a data processing result.

[0087] For steps S510 to S540, in the process of mapping the target database according to the structured query language parameter information to obtain the data processing result, first, the instantiated object is connected to the target database according to the database connection information in the structured query language parameter information; then, the query statement information in the structured query language parameter information is executed to obtain a processing result set; then, the processing result set is traversed to obtain traversal object data; finally, the target database is adjusted according to the traversal object data to obtain the corresponding data processing result. In the above manner, the corresponding data processing result can be obtained simply and quickly, which can greatly simplify the process of database modification.

[0088] It is worth noting that the instantiated object is connected to the target database according to the database connection information in the structured query language parameter information to ensure that the instantiated object can communicate with the target database; the query statement information in the structured query language parameter information is executed, such as querying data, inserting data, updating data or deleting data. The processing result set is traversed, and the data can be processed or analyzed line by line to extract the required information. Adjusting the target database according to the traversed object data means further operating the target database according to the traversed data, such as updating data, inserting data or deleting data. These operations can dynamically adjust the data in the database based on the traversal results, making the modification of the database more flexible and reliable.

[0089] like Figure 7 As shown, after mapping the target database according to the structured query language parameter information and obtaining the data processing result, the following steps may also be included:

[0090] Step S610, verifying the data processing result to obtain a data verification result;

[0091] Step S620: When the data verification result indicates that the data processing result is normal, the corresponding data processing result is stored in a preset monitoring terminal.

[0092] For steps S610 to S620, after the target database is mapped according to the structured query language parameter information to obtain the data processing result, the data processing result can also be verified to obtain the data verification result; when the data verification result indicates that the data processing result is normal, the corresponding data processing result is stored in a pre-set monitoring terminal; wherein, verifying the data processing result can well verify the accuracy of the data processing; when the data verification result indicates that the data processing result is normal, the corresponding data processing result is stored in the monitoring terminal, so that the relevant data processing process can be recorded conveniently and quickly, so as to facilitate the subsequent review and processing of the relevant process.

[0093] For example, for a property insurance business management system, after modifying the claims management database in the property insurance business management system, the data processing results of the database can be verified, and the verification results obtained by the verification can be stored in a pre-set insurance business server, so that the insurance system maintenance personnel can easily and quickly view the data processing process of the database through the insurance business server. For another example, for a smart medical system, after modifying the database in the smart medical system, the data processing results of the database can be verified, and the verification results obtained by the verification can be stored in a pre-set medical server, so that the system maintenance personnel can easily and quickly view the data processing process of the database through the medical server.

[0094] In addition, if Figure 8 As shown, an embodiment of the present application further provides a data processing device 10, including:

[0095] The acquisition unit 100 is used to acquire database modification entry information, wherein the database modification entry information includes database tag information, component tag information and modification parameter information;

[0096] The selection unit 200 is used to determine a target database from a preset data management system according to the database tag information; and to determine a target component from a preset system component according to the component tag information;

[0097] The loading unit 300 is used to load the modification parameter information into the target component to form the modification object information;

[0098] The parsing unit 400 is used to parse the modification object information to obtain structured query language parameter information;

[0099] The mapping unit 500 is used to perform mapping processing on the target database according to the structured query language parameter information to obtain a data processing result.

[0100] It should be noted that in the process of data processing, the database modification table item information is first obtained, wherein the database modification table item information includes database tag information, component tag information and modification parameter information; then the target database is determined from the preset data management system according to the database tag information; and, the target component is determined from the preset system component according to the component tag information; then the modification parameter information is loaded into the target component to form modification object information; then the modification object information is parsed to obtain structured query language parameter information; finally, the target database is mapped according to the structured query language parameter information to obtain the data processing result. Through the above technical scheme, after obtaining the database modification table item information, the target database can be determined according to the database tag information in the database modification table item information, and the target component can also be determined from the preset system components according to the component tag information. Through the above method, the determination of the target database and the target component can be faster and more flexible; then the modification parameter information is loaded into the target component to form the modification object information; then the modification object information is parsed to obtain the structured query language parameter information; finally, the target database is mapped based on the structured query language parameter information to obtain the data processing result, so that the modification of the database can be more intelligent and simple.

[0101] The specific implementation of the data processing device 10 is substantially the same as the specific implementation of the above-mentioned data processing method, and will not be described in detail herein.

[0102] 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 .

[0103] The processor 710 and the memory 720 may be connected via a bus or in other ways.

[0104] The non-transitory software programs and instructions required to implement the data processing methods of the above embodiments are stored in the memory 720 , and when executed by the processor 710 , the data processing methods of the above embodiments are executed.

[0105] 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.

[0106] In addition, an embodiment of the present application also 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 data processing method in the above-mentioned embodiment.

[0107] The above embodiments may be used in combination, and modules with the same name in different embodiments may be the same or different.

[0108] 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.

[0109] 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.

[0110] 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.

[0111] In the 1990s, improvements to a technology could be clearly distinguished as hardware improvements (for example, improvements to the circuit structure of diodes, transistors, switches, etc.) or software improvements (improvements to the method flow). However, with the development of technology, many improvements to the method flow today can be regarded as direct improvements to 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 an improvement in a method flow cannot be implemented using 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 a chip manufacturer to design and produce a dedicated integrated circuit chip. 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, and the original code before compilation must also be written in a specific programming language, which is called hardware description language (HDL). There is not only one HDL, but many kinds, such as ABEL (Advanced Boolean Expression Language), AHDL (Altera Hardware Description Language), Confluence, CUPL (Cornell University Programming Language), HDCal, JHDL (Java Hardware Description Language), Lava, Lola, MyHDL, PALASM, RHDL (Ruby Hardware Description Language), etc. The most commonly used ones are VHDL (Very-High-Speed ​​Integrated Circuit Hardware Description Language) and Verilog. Those skilled in the art should also know that it is only necessary to program the method flow slightly in the above-mentioned hardware description languages ​​and program it into the integrated circuit, and then it is easy to obtain the hardware circuit that implements the logic method flow.

[0112] 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 AT91SAM, Microchip PIC18F26K20, and Silicone Labs C8051F320. 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 devices for implementing various functions can be regarded as both software modules for implementing the method and structures within the hardware component.

[0113] 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.

[0114] 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.

[0115] 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.

[0116] 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.

[0117] 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.

[0118] 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 in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0119] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0120] 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 RAM. The memory is an example of a computer-readable medium.

[0121] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. 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 disk read-only memory (CD-ROM), digital versatile disk (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 media), such as modulated data signals and carrier waves.

[0122] 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.

[0123] 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.

[0124] 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.

[0125] 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.

[0126] 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 data processing method, characterized in that: include: Acquire database modification table item information, wherein the database modification table item information includes database tag information, component tag information and modification parameter information; Determining a target database from a preset data management system according to the database tag information; and determining a target component from preset system components according to the component tag information; Loading the modification parameter information into the target component to form modification object information; Parsing the modification object information to obtain structured query language parameter information; Mapping processing is performed on the target database according to the structured query language parameter information to obtain a data processing result.

2. The data processing method according to claim 1, characterized in that: The data management system includes a plurality of databases, and determining a target database from a preset data management system according to the database tag information includes: Matching the database tag information with the label information of each database in the data management system to obtain target label information; The database corresponding to the target label information is used as the target database.

3. The data processing method according to claim 1, characterized in that: The system component includes a plurality of task components, and determining the target component from the preset system components according to the component tag information includes: Matching the component tag information with the identification information of each of the task components in the system components to obtain target identification information; The task component corresponding to the target identification information is used as the target component.

4. The data processing method according to claim 1, characterized in that: The step of loading the modification parameter information into the target component to form the modification object information includes: determining a target modification parameter from the modification parameter information; Initializing the target component so that the target component enters a configuration mode; and modifying the configuration file of the target component that enters the configuration mode by using the target modification parameter to obtain modified configuration information; The modified configuration information is verified, and the modified configuration information that passes the verification is used as the modified object information.

5. The data processing method according to claim 1, characterized in that: The step of parsing the modification object information to obtain structured query language parameter information includes: Instantiating the modified object information to obtain an instantiated object; Performing object attribute analysis on the instantiated object to obtain object attribute values; The object attribute value is converted to obtain the structured query language parameter information.

6. The data processing method according to claim 5, characterized in that: The mapping process is performed on the target database according to the structured query language parameter information to obtain a data processing result, including: Establishing a connection between the instantiated object and the target database according to the database connection information in the structured query language parameter information; Execute the query statement information in the structured query language parameter information to obtain a processing result set; Performing traversal processing on the processing result set to obtain traversal object data; The target database is adjusted and processed according to the traversal object data to obtain the data processing result.

7. The data processing method according to claim 1, characterized in that: After mapping the target database according to the structured query language parameter information to obtain a data processing result, the method further includes: Performing verification processing on the data processing result to obtain a data verification result; When the data verification result indicates that the data processing result is normal, the corresponding data processing result is stored in a preset monitoring terminal.

8. A data processing device, characterized in that: include: An acquiring unit, used for acquiring database modification table item information, wherein the database modification table item information includes database tag information, component tag information and modification parameter information; A selection unit, configured to determine a target database from a preset data management system according to the database tag information; and to determine a target component from preset system components according to the component tag information; A loading unit, used for loading the modification parameter information into the target component to form modification object information; A parsing unit, used for parsing the modification object information to obtain structured query language parameter information; A mapping unit is used to perform mapping processing on the target database according to the structured query language parameter information to obtain a data processing result.

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 data 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 data processing method according to any one of claims 1 to 7.

Images