CN116820566A

CN116820566A - Data processing method, device, electronic equipment and storage medium

Info

Publication number: CN116820566A
Application number: CN202310772624.4A
Authority: CN
Inventors: 陈枫; 李桂林; 郑峥
Original assignee: CCB Finetech Co Ltd
Current assignee: CCB Finetech Co Ltd
Priority date: 2023-06-27
Filing date: 2023-06-27
Publication date: 2023-09-29

Abstract

The present disclosure provides a data processing method, apparatus, electronic device, and storage medium, which may be applied to the computer technology field, the financial field, or other fields. The method comprises the following steps: in response to the data processing request, a first text block in the source operating environment is obtained. And processing the first text block based on the grammar difference between the source running environment and the target running environment to obtain a second text block. And dynamically converting the second text block into a third text block by taking the parameters carried by the data processing request as environment variables. And operating the third text block in the target operating environment based on the variable information carried by the data processing request so as to perform data processing on the database in the target operating environment.

Description

Data processing method, device, electronic equipment and storage medium

Technical Field

The present disclosure relates to the field of computer technology and financial, and more particularly, to a data processing method, apparatus, electronic device, and storage medium.

Background

With the progress of software technology, code migration is performed in order to achieve better performance, extensibility, and security. Code migration refers to the process of migrating source code of a software system from one platform or environment to another. In the code migration process, the situation that the running environments are incompatible exists, so that the original code cannot be directly migrated to the target running environment.

Disclosure of Invention

In view of this, the present disclosure provides a data processing method, apparatus, electronic device, readable storage medium, and computer program product.

One aspect of the present disclosure provides a data processing method, including:

in response to the data processing request, a first text block in the source operating environment is obtained. And processing the first text block based on the grammar difference between the source running environment and the target running environment to obtain a second text block. And dynamically converting the second text block into a third text block by taking the parameters carried by the data processing request as environment variables. And running the third text block in the target running environment based on the variable information carried by the data processing request so as to perform data processing on the database in the target running environment.

According to an embodiment of the present disclosure, the dynamically converting the second text block into a third text block with the parameter carried by the data processing request as an environment variable includes:

and carrying out sentence conversion on the second text block based on the grammar rule of the target operation environment to obtain a script text block. And calling a script engine of the target running environment to process the script text block by taking the parameter carried by the data processing request as an environment variable to obtain the third text block.

According to an embodiment of the present disclosure, the sentence conversion is performed on the second text block based on the grammar rule of the target running environment to obtain a script text block, including:

at least one structured query statement and at least one script statement are determined from the second text block. For each of the structured query statement, converting the structured query statement into a printout statement based on the grammar rules of the target operating environment. And combining at least one of the printout statements and the at least one script statement in a target order to obtain the script text block, wherein the target order represents an arrangement order of the at least one structured query statement and the at least one script statement in the second text block.

and calling a persistence framework component to process the second text block to obtain a dynamic structured query statement. And generating the third text block based on the dynamic structured query statement by taking the parameters carried by the data processing request as environment variables.

According to an embodiment of the present disclosure, the running the third text block in the target running environment based on the variable information carried by the data processing request to perform data processing on a database in the target running environment includes:

at least one binding variable is determined from the third text block based on the first marker included in the third text block. And performing assignment processing on the at least one binding variable based on at least one variable value included in the variable information. And running the third text block subjected to assignment processing in the target running environment so as to perform data processing on the database in the target running environment.

According to an embodiment of the present disclosure, the first marker is related to the source runtime environment; the method further comprises the following steps: and replacing the first marker respectively related to at least one binding variable included in the third text block with the second marker in the target running environment to obtain a fourth text block. Wherein, the operating the third text block subjected to assignment processing in the target operating environment to perform data processing on the database in the target operating environment includes: and operating the fourth text block subjected to assignment processing in the target operating environment so as to perform data processing on the database in the target operating environment.

According to an embodiment of the present disclosure, the processing the first text block to obtain a second text block based on the syntax difference between the source runtime environment and the target runtime environment includes:

based on the above-described grammatical differences between the source and target runtime environments, a regular expression is generated. And processing the first text block based on the regular expression respectively to obtain the second text block.

According to an embodiment of the present disclosure, the processing the first text block based on the regular expression to obtain the second text block includes:

and determining keywords and/or sub-sentence blocks related to the source running environment existing in the first text block based on the regular expression. And deleting keywords and/or sub-sentence blocks related to the source operation environment, which exist in the first text block, so as to obtain the second text block.

based on the regular expression, a plurality of consecutive blank characters present in the first text block are determined. And replacing the continuous plurality of blank characters with a single blank character to obtain the second text block.

Another aspect of the present disclosure provides a data processing apparatus comprising:

the acquisition module is used for responding to the data processing request and acquiring a first text block in the source operation environment;

the processing module is used for processing the first text block based on the grammar difference between the source running environment and the target running environment to obtain a second text block;

the conversion module is used for dynamically converting the second text block into a third text block by taking the parameters carried by the data processing request as environment variables; and

and the data processing module is used for operating the third text block in the target operating environment based on the variable information carried by the data processing request so as to perform data processing on the database in the target operating environment.

Another aspect of the present disclosure provides an electronic device, comprising: one or more processors; and a memory for storing one or more instructions that, when executed by the one or more processors, cause the one or more processors to implement the method as described above.

Another aspect of the present disclosure provides a computer-readable storage medium storing computer-executable instructions that, when executed, are configured to implement a method as described above.

Another aspect of the present disclosure provides a computer program product comprising computer executable instructions which, when executed, are adapted to implement the method as described above.

A data processing method, apparatus, device, medium, and program product are provided in accordance with the present disclosure. In response to the data processing request, a first text block in the source operating environment is obtained. And processing the first text block based on the grammar difference between the source running environment and the target running environment to obtain a second text block. And dynamically converting the second text block into a third text block by taking the parameters carried by the data processing request as environment variables. And operating the third text block in the target operating environment based on the variable information carried by the data processing request so as to perform data processing on the database in the target operating environment. Since the text blocks in the source running environment are migrated to the target running environment and are executed aiming at the database in the target running environment, the migrated application program can realize operations such as adding, deleting, modifying and the like on the database in the target running environment.

Drawings

The above and other objects, features and advantages of the present disclosure will become more apparent from the following description of embodiments thereof with reference to the accompanying drawings in which:

FIG. 1 illustrates an exemplary system architecture to which data processing methods and apparatus may be applied, according to embodiments of the present disclosure;

FIG. 2 schematically illustrates a flow chart of a data processing method according to an embodiment of the disclosure;

FIG. 3 schematically illustrates a flow chart of a data processing method according to another embodiment of the present disclosure;

FIG. 4 schematically illustrates a flow chart of a data processing method according to a further embodiment of the present disclosure;

FIG. 5 schematically illustrates a block diagram of a data processing apparatus according to an embodiment of the present disclosure; and

fig. 6 schematically illustrates an electronic device block diagram of a data processing method according to an embodiment of the disclosure.

Detailed Description

Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is only exemplary and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. In addition, in the following description, descriptions of well-known structures and techniques are omitted so as not to unnecessarily obscure the concepts of the present disclosure.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and/or the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It should be noted that the terms used herein should be construed to have meanings consistent with the context of the present specification and should not be construed in an idealized or overly formal manner.

Where expressions like at least one of "A, B and C, etc. are used, the expressions should generally be interpreted in accordance with the meaning as commonly understood by those skilled in the art (e.g.," a system having at least one of A, B and C "shall include, but not be limited to, a system having a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).

Data migration (Data migration) refers to the conversion of Data between storage types, formats, and computer systems. The data migration process can be data exchange among databases of different types, and the problem that the running environments are not matched exists, so that the original database sentences cannot be directly migrated to the target running environment.

In view of this, embodiments of the present disclosure provide a data processing method, including: in response to the data processing request, a first text block in the source operating environment is obtained. And processing the first text block based on the grammar difference between the source running environment and the target running environment to obtain a second text block. And dynamically converting the second text block into a third text block by taking the parameters carried by the data processing request as environment variables. And operating the third text block in the target operating environment based on the variable information carried by the data processing request so as to perform data processing on the database in the target operating environment. Since the text blocks in the source running environment are migrated to the target running environment and are executed aiming at the database in the target running environment, the migrated application program can realize operations such as adding, deleting, modifying and the like on the database in the target running environment.

It should be noted that the data processing method and apparatus determined by the embodiments of the present disclosure may be used in the field of computer technology or the field of finance. The data processing method and device determined by the embodiment of the disclosure can also be used in any field except the field of computer technology and the field of finance. The application fields of the data processing method and the data processing device determined by the embodiment of the disclosure are not limited.

In embodiments of the present disclosure, the collection, updating, analysis, processing, use, transmission, provision, disclosure, storage, etc., of the data involved (including, but not limited to, user personal information) all comply with relevant legal regulations, are used for legal purposes, and do not violate well-known. In particular, necessary measures are taken for personal information of the user, illegal access to personal information data of the user is prevented, and personal information security, network security and national security of the user are maintained.

In embodiments of the present disclosure, the user's authorization or consent is obtained before the user's personal information is obtained or collected.

FIG. 1 schematically illustrates an exemplary system architecture to which data processing methods and apparatus may be applied, according to embodiments of the present disclosure. It should be noted that fig. 1 is only an example of a system architecture to which embodiments of the present disclosure may be applied to assist those skilled in the art in understanding the technical content of the present disclosure, but does not mean that embodiments of the present disclosure may not be used in other devices, systems, environments, or scenarios.

As shown in fig. 1, a system architecture 100 according to this embodiment may include a terminal device 101, a terminal device 102, a terminal device 103, a network 104, and a server 105. The network 104 is a medium used to provide communication links between the terminal device 101, the terminal device 102, the terminal device 103, and the server 105. The network 104 may include various connection types, such as wired and/or wireless communication links, and the like.

The user may interact with the server 105 via the network 104 using the terminal device 101, the terminal device 102, the terminal device 103, to receive or send messages or the like. Various communication client applications may be installed on terminal devices 101, 102, 103, such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, and/or social platform software, to name a few.

Terminal device 101, terminal device 102, terminal device 103 may be a variety of electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (by way of example only) providing support for websites browsed by the user using the terminal device 101, the terminal device 102, the terminal device 103. The background management server may analyze and process the received data such as the user request, and feed back the processing result (e.g., the web page, information, or data obtained or generated according to the user request) to the terminal device.

It should be noted that the data processing method provided in the embodiments of the present disclosure may be generally performed by the server 105. Accordingly, the data processing apparatus provided by the embodiments of the present disclosure may be generally provided in the server 105. The data processing method provided by the embodiments of the present disclosure may also be performed by a server or a server cluster that is different from the server 105 and is capable of communicating with the terminal device 101, the terminal device 102, the terminal device 103, and/or the server 105. Accordingly, the data processing apparatus provided by the embodiments of the present disclosure may also be provided in a server or a server cluster that is different from the server 105 and is capable of communicating with the terminal device 101, the terminal device 102, the terminal device 103, and/or the server 105. Alternatively, the data processing method provided by the embodiment of the present disclosure may be performed by the terminal device 101, the terminal device 102, or the terminal device 103, or may be performed by another terminal device other than the terminal device 101, the terminal device 102, or the terminal device 103. Accordingly, the data processing apparatus provided by the embodiments of the present disclosure may also be provided in the terminal device 101, the terminal device 102, or the terminal device 103, or in other terminal devices different from the terminal device 101, the terminal device 102, or the terminal device 103.

For example, the script text block may be originally stored in any one of the terminal device 101, the terminal device 102, or the terminal device 103 (for example, but not limited to, the terminal device 101), or stored on an external storage device and imported into the terminal device 101. Then, the terminal device 101 may locally perform the data processing method provided by the embodiment of the present disclosure, or the script text block is transmitted to other terminal devices, servers, or server clusters, and one of the data processing methods provided by the embodiment of the present disclosure is performed by the other terminal devices, servers, or server clusters of the script text block.

It should be understood that the number of terminal devices, networks and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

Fig. 2 schematically illustrates a flow chart of a data processing method according to an embodiment of the present disclosure.

As shown in fig. 2, the method includes operations S210 to S240.

In operation S210, a first text block in a source execution environment is acquired in response to a data processing request.

In operation S220, the first text block is processed based on the grammatical difference between the source runtime environment and the target runtime environment, resulting in a second text block.

The second text block is dynamically converted into a third text block using the parameters carried by the data processing request as environment variables in operation S230.

In operation S240, the third text block is run in the target running environment based on the variable information carried by the data processing request to perform data processing on the database in the target running environment.

According to embodiments of the present disclosure, the source runtime environment may be a runtime environment in a database language, for example, a runtime environment in a database in the C language, or a runtime environment in a database in the JAVA language. Wherein the C language and JAVA language are computer languages. The source operating environment is not limited to the operating environment of the database, but may be the operating environment of the platform.

According to an embodiment of the present disclosure, the parameters carried by the data processing request may be parameters received by the persistence layer in the database access, but the parameters are not limited to parameters received at the persistence layer, for example, parameters transmitted by the front-end device and input by the user.

According to embodiments of the present disclosure, the variable information may be binding variable information, where the binding variable is a structured query statement with a temporary variable as a placeholder, which may be replaced with an appropriate value. For example, the variable information is the value of the binding variable "Teller".

For example, in response to a data processing request, a first text block in a Pro x C operating environment is obtained. And Pro is an application-specific development tool, and the complex SQL statement can be embedded in the C program by taking the C language as an operating environment to perform database operation. Where SQL (Structured Query Language), structured query language) statements are one language in which databases are operated upon.

For example, the source runtime environment is C language, the target runtime environment may be JAVA language, and the first text chunk is processed based on a grammar difference between the C language and the JAVA language to obtain the second text chunk. And dynamically converting the second text block into a third text block by taking a parameter 'Teller' carried by the data processing request at the persistence layer as an environment variable. The third text block is run in the target running environment based on the variable information carried by the data processing request is 'teller=21', so as to perform data processing on the database in the target running environment.

According to an embodiment of the present disclosure, a first text block in a source runtime environment is obtained in response to a data processing request. And processing the first text block based on the grammar difference between the source running environment and the target running environment to obtain a second text block. And dynamically converting the second text block into a third text block by taking the parameters carried by the data processing request as environment variables. And operating the third text block in the target operating environment based on the variable information carried by the data processing request so as to perform data processing on the database in the target operating environment. Since the text blocks in the source running environment are migrated to the target running environment and are executed aiming at the database in the target running environment, the migrated application program can realize operations such as adding, deleting, modifying and the like on the database in the target running environment.

According to an embodiment of the present disclosure, dynamically converting the second text block into the third text block with a parameter carried by the data processing request as an environment variable includes:

and performing sentence conversion on the second text block based on grammar rules of the target operation environment to obtain a script text block. And calling a script engine of the target running environment to process the script text block by taking the parameters carried by the data processing request as environment variables to obtain a third text block.

According to an embodiment of the present disclosure, the grammar rule of the target environment may be a rule of an algorithm language, may be a C language rule, and may be a JAVA language rule.

According to an embodiment of the present disclosure, the script engine may be a javascript engine. For example, the script engine may be a script enginemanager. The script engine is not limited to a javascript engine, but may be, for example, an SQL script engine or a Visual Basic script engine.

The script text block according to the present disclosure may be a pure JavaScript code script, but the script text block is not limited to the pure JavaScript code script, and may be, for example, a c+ code script, a Python code script.

For example, the target operating environment may be JAVA language. And carrying out sentence conversion on the second text block based on the JAVA grammar rule to obtain the JavaScript code script which can be used for being executed in the JAVA language. Wherein the script text block is a JavaScript code script. Wherein the target operating environment is a JAVA operating environment. And calling a JavaScript engine of the JAVA language to process the JavaScript code script by taking a parameter 'Num' carried by the data processing request of the persistence layer as an environment variable to obtain a third text block.

For example, the variable information carried based on the data processing request is "num=2", and the third text block is run in the JAVA running environment to perform data processing in the JAVA running environment.

According to the embodiment of the disclosure, the purpose of the statement conversion and script engine execution script is to eliminate script statements not recognized by a database, and to solidify dynamic structured query statements into static structured query statements in combination with runtime parameter values, so that the efficiency of data migration is improved.

According to an embodiment of the present disclosure, sentence conversion is performed on the second text block based on a grammar rule of the target running environment, to obtain a script text block, including:

at least one structured query statement and at least one script statement are determined from the second text block. For each structured query statement, converting the structured query statement into a printout statement based on the grammar rules of the target run environment. And combining the at least one printout statement and the at least one script statement in a target order to obtain a script text block, wherein the target order represents the arrangement order of the at least one structured query statement and the at least one script statement in the second text block.

For example, at least one structured query statement may be determined in the second text block according to a statement type of the structured query statement. Statement types of structured query statements include data definition language, database query language, database operation language, and the like. For example, the data definition language may be create, drop, or the like; the database query language may be select (filtering), etc.; the database operating language may be insert, update, delete, etc.

For example, the printout statement may be "$.

For example, the second text block may be "select from TableA where 1=1; <%if (typeof Teller = 'undefined' & Teller = null) {% > and Teller field =: teller <% } >. Wherein, the embedded script statement will be marked with a marker, and the second text block is marked with "<% and% >" and "<% >". Determining from the second text block that the structured query statement is "select x from TableA where 1 =1" and teller field=: a script statement is "if (typeof Teller = 'undefined' & Teller =: null". For a structured query statement, the structured query statement is converted into a printout statement based on a grammar rule that the target execution environment is JAVA language, the printout statement is "$write (" select = from TableA where 1 ") and" $write ("and Teller field =: teller").

For example, the print-out statement and the script statement are combined in the target order to obtain the script text block. Script text blocks may be "$write (" select from TableA where 1=1 "); if (typeof Teller = 'undefined' & Teller = null) { $write ("and Teller field =: teller") }).

According to the embodiment of the disclosure, the structured query statement is converted into the printout statement, and at least one script statement of the printout statement is combined according to the target sequence, so that a script text block executable in the target running environment is obtained, the accuracy of code migration is improved, and the data processing speed is improved.

and calling the persistence framework component to process the second text block to obtain the dynamic structured query statement. And generating a third text block based on the dynamically structured query statement with parameters carried by the data processing request as environment variables.

According to embodiments of the present disclosure, the persistence framework component can be mybatis, which can establish a mapping relationship between entity classes and structured query statements.

According to embodiments of the present disclosure, dynamically structured query statements may be compiled and executed at application runtime.

For example, invoking the persistence framework component mybatis processes the second text block resulting in dynamically structured query statements of "$write (" select from TableA where 1 =1 ")" and "{ $write (" and TellerField=: teller "). And generating a third text block based on the dynamic structured query statement by taking a parameter 'Teller' carried by the data processing request as an environment variable. The third text block may be "select from TableA where 1=1; and terllerfield=: teller.

According to an embodiment of the present disclosure, the second text block may be a text block suitable for processing by the persistence framework component, and thus, the persistence framework component may be directly invoked to implement the dynamic structured query statement, and the dynamic structured query statement generates the static structured query statement upon receiving the parameters.

According to an embodiment of the present disclosure, based on variable information carried by a data processing request, a third text block is executed in a target execution environment to perform data processing on a database in the target execution environment, including:

at least one binding variable is determined from the third text block based on the first marker included in the third text block. And performing assignment processing on the at least one binding variable based on the at least one variable value included in the variable information. And running the third text block subjected to assignment processing in the target running environment so as to perform data processing on the database in the target running environment.

According to an embodiment of the present disclosure, the first marker may be a marker that the target operating environment is able to recognize.

For example, the binding variables determined from the third text block are "Teller" and "Teller age". The variable information includes "Teller" including "operator 1", "operator 2", and "Teller" including "operator 1 age 25 years" and "operator 2 age 26 years". The assignment processing statement may be described as "teller=: teller; terllerage=. Tellerage). And running the third text block subjected to assignment processing under the condition that the target running environment is JAVA language so as to perform data processing on the database under the target running environment.

According to the embodiment of the disclosure, the assignment processing is performed on the binding variable, so that the third text block which runs under the target running environment and is subjected to the assignment processing is obtained, and the accuracy of data processing can be improved.

According to an embodiment of the present disclosure, a first marker is associated with a source runtime environment; the method further comprises the steps of: and replacing the first markers respectively related to at least one binding variable included in the third text block with the second markers in the target running environment to obtain a fourth text block. The method for processing the data of the database in the target running environment comprises the following steps of: and running the fourth text block subjected to assignment processing in the target running environment so as to perform data processing on the database in the target running environment.

For example, the source runtime environment may be in the C language and the first marker may be ": ", wherein the binding variable is as follows": the variable name "label". The target execution environment may be the JAVA language executing the persistence framework component mybatis and the second marker may be "# { }" where the binding variable is marked with "# { variable name }".

For example: in the third text block is the "teller=" in the C language: teller; terllerage=. Terllerage ", the first marker may be": "replace with the second marker" # { } "of the Java language of the goal running environment, get the binding variable statement in the fourth text block to be" Teller = # { Teller }; tellerage= # Tellerage }.

For example, including multiple variable values for a binding variable may be registered in a List so that the binding variable can be subsequently assigned a value in order.

For example, "? ". Replace the second tag of the binding variable in the fourth text block with "? And the database application programming interface is convenient to submit for precompiled processing.

According to the embodiment of the disclosure, the first marker is replaced by the second marker in the target running environment, so that variable assignment can be accurately bound, and the accuracy of data processing is improved.

According to an embodiment of the present disclosure, processing a first text block based on a grammatical difference between a source runtime environment and a target runtime environment to obtain a second text block includes:

based on the grammatical differences between the source runtime environment and the target runtime environment, a regular expression is generated. And processing the first text block based on the regular expression respectively to obtain a second text block.

For example, the source runtime environment is C language, the target runtime environment is JAVA language, a regular expression to delete annotations may be generated based on the grammatical differences of the C language and JAVA language, and the invoked code statement may be "sqlgr1. Reprplaces all ("/\\s ] [ \s ].

According to the embodiment of the disclosure, due to the grammar difference between the source running environment and the target running environment, the first text block is respectively processed through the regular expression, so that the second text block for reducing codes is obtained, the structured query sentence in the second text block does not exceed the maximum structured query sentence length supported by the database, and the data processing speed is improved.

According to an embodiment of the present disclosure, processing a first text block based on a regular expression to obtain a second text block includes:

Keywords and/or sub-sentence blocks associated with the source runtime environment present in the first text block are determined based on the regular expression. And deleting keywords and/or sub-sentence blocks related to the source operation environment existing in the first text block to obtain a second text block.

For example, the first text block may be "EXEC SQL SELECT print_num2, bill_2dcode; INTO: iPrintNum: sRsp2DCODE; FROM t_main_bill_info WHERE bill_no=: ans _bill_no; "wherein the first text block is code in the source runtime environment, the source runtime environment is the C language, the key related to the C language is" EXEC SQL ", and the sub-sentence block related to the C language is an INTO sentence block. The resulting second text block may be "SELECT print_num2, bill_2dcode" by deleting keywords and/or sub-sentence blocks associated with the source runtime environment that are present in the first text block; iPrintNum: sRsp2DCODE; FROM t_main_bill_info WHERE bill_no=: ans _bill_no; ".

According to the embodiment of the disclosure, the second text block is obtained by deleting the keywords and/or the sub-sentence blocks related to the source running environment in the first text block, so that invalid codes of the target running environment are reduced, and the database in the target running environment is facilitated to process data.

based on the regular expression, a plurality of consecutive blank characters present in the first text block is determined. And replacing the continuous plurality of blank characters with a single blank character to obtain a second text block.

For example, consecutive blank characters in the first text block may be replaced with a single blank character by the string. Reprplaces all () method.

According to embodiments of the present disclosure, the first text block may be slimming by replacing a continuous plurality of blank characters with a single blank character to accommodate code length requirements of a database or platform.

Fig. 3 schematically illustrates a flow chart of a data processing method according to another embodiment of the present disclosure.

As shown in fig. 3, the method includes operations S301 to S311.

In operation S301, a first text block in a source execution environment is acquired in response to a data processing request.

In operation S302, a regular expression is generated based on a syntax difference between a source runtime environment and a target runtime environment.

In operation S303, keywords and/or sub-sentence blocks related to the source execution environment present in the first text block are determined based on the regular expression.

In operation S304, keywords and/or sub-sentence blocks related to the source execution environment existing in the first text block are deleted to obtain a second text block.

In operation S305, at least one structured query statement and at least one script statement are determined from the second text block.

In operation S306, for each structured query statement, the structured query statement is converted into a printout statement based on the grammar rules of the target execution environment.

In operation S307, at least one printout sentence and at least one script sentence are combined in the target order to obtain a script text block.

In operation S308, the script engine of the target operating environment is invoked to process the script text block with the parameter carried by the data processing request as an environment variable, to obtain a third text block.

In operation S309, at least one binding variable is determined from the third text block based on the first marker included in the third text block.

In operation S310, assignment processing is performed on at least one binding variable based on at least one variable value included in the variable information.

In operation S311, the assigned-processed third text block is executed in the target execution environment to perform data processing on the database in the target execution environment.

Fig. 4 schematically shows a flow chart of a data processing method according to a further embodiment of the present disclosure.

As shown in fig. 4, the method includes operations S401 to S409.

In operation 401, a first text block in a source runtime environment is obtained in response to a data processing request.

At operation 402, a regular expression is generated based on a grammatical difference between a source runtime environment and a target runtime environment.

In operation 403, a continuous plurality of blank characters present in the first text block is determined based on the regular expression.

At operation 404, the continuous plurality of blank characters is replaced with a single blank character to obtain a second block of text.

At operation 405, a persistence framework component is invoked to process the second text block, resulting in a dynamically structured query statement.

In operation 406, a third text block is generated based on the dynamically structured query statement with parameters carried by the data processing request as environment variables.

At operation 407, at least one binding variable is determined from the third text block based on the first marker included in the third text block.

At operation 408, the first markers associated with each of the at least one binding variable included in the third text block are replaced with the second markers in the target operating environment to obtain a fourth text block.

In operation 409, the assigned fourth text block is run in the target run-time environment to perform data processing on the database in the target run-time environment.

Fig. 5 schematically shows a block diagram of a data processing apparatus according to an embodiment of the disclosure.

As shown in fig. 5, the data processing apparatus includes an acquisition module 510, a processing module 520, a conversion module 530, and a data processing module 540.

An obtaining module 510 is configured to obtain, in response to the data processing request, a first text block in the source operating environment. The obtaining module 510 may be configured to perform the operation S210 described above, which is not described herein.

And a processing module 520, configured to process the first text block based on the grammatical difference between the source runtime environment and the target runtime environment, to obtain a second text block. The processing module 520 may be configured to perform the operation S220 described above, which is not described herein.

The conversion module 530 is configured to dynamically convert the second text block into a third text block with the parameter carried by the data processing request as an environment variable. The conversion module 530 may be used to perform the operation S230 described above, which is not described herein.

The data processing module 540 is configured to execute the third text block in the target running environment based on the variable information carried by the data processing request, so as to perform data processing on the database in the target running environment. The data processing module 540 may be used to perform the operation S240 described above, and will not be described herein.

According to an embodiment of the present disclosure, the translation module 530 includes a statement translation unit and a first call unit. The sentence conversion unit is used for performing sentence conversion on the second text block based on grammar rules of the target operation environment to obtain a script text block. The first calling unit is used for calling a script engine of the target running environment to process the script text block by taking the parameter carried by the data processing request as an environment variable to obtain a third text block.

According to an embodiment of the present disclosure, the sentence conversion unit includes a determination subunit, a conversion subunit, and a combination subunit. Wherein the determining subunit is configured to determine at least one structured query statement and at least one script statement from the second text block. And the conversion subunit is used for converting the structured query statement into a printout statement based on the grammar rule of the target running environment for each structured query statement. And the combining subunit is used for combining the at least one printout statement and the at least one script statement according to a target sequence to obtain a script text block, wherein the target sequence represents the arrangement sequence of the at least one structured query statement and the at least one script statement in the second text block.

According to an embodiment of the present disclosure, a conversion module includes a first processing unit and a generating unit. The first processing unit is used for calling the persistence framework component to process the second text block so as to obtain the dynamic structured query statement. And the generation unit is used for generating a third text block based on the dynamic structured query statement by taking the parameter carried by the data processing request as an environment variable.

According to an embodiment of the present disclosure, a data processing module includes a determination unit, an assignment processing unit, and an execution unit. Wherein the determining unit is configured to determine at least one binding variable from the third text block based on the first marker included in the third text block. And the assignment processing unit is used for carrying out assignment processing on at least one binding variable based on at least one variable value included in the variable information. And the operation unit is used for operating the third text block subjected to assignment processing in the target operation environment so as to perform data processing on the database in the target operation environment.

According to an embodiment of the present disclosure, the data processing module further comprises a replacement unit. And the replacing unit is used for replacing the first marker respectively related to at least one binding variable included in the third text block with the second marker in the target running environment to obtain a fourth text block.

According to an embodiment of the present disclosure, the execution unit further includes an execution subunit, where the execution subunit is configured to execute the assigned fourth text block in the target execution environment, so as to perform data processing on the database in the target execution environment.

According to an embodiment of the present disclosure, the processing module includes a generating unit and a second processing unit. The generation unit is used for generating a regular expression based on the grammar difference between the source running environment and the target running environment. And the second processing unit is used for respectively processing the first text blocks based on the regular expression to obtain second text blocks.

According to an embodiment of the present disclosure, the second processing unit comprises a determining subunit and a deleting subunit. The determining subunit is configured to determine, based on the regular expression, a keyword and/or a sub-sentence block related to the source running environment that exists in the first text block. And the deleting subunit is used for deleting keywords and/or sub-sentence blocks which exist in the first text block and are related to the source running environment to obtain a second text block.

According to an embodiment of the present disclosure, the second processing unit comprises a second determination subunit and a replacement subunit. And a second determining subunit configured to determine, based on the regular expression, a plurality of consecutive blank characters present in the first text block. And a replacing subunit for replacing the continuous plurality of blank characters with a single blank character to obtain the second text block.

Any number of modules, sub-modules, units, sub-units, or at least some of the functionality of any number of the sub-units according to embodiments of the present disclosure may be implemented in one module. Any one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be implemented as split into multiple modules. Any one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be implemented at least in part as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system-on-chip, a system-on-substrate, a system-on-package, an Application Specific Integrated Circuit (ASIC), or in any other reasonable manner of hardware or firmware that integrates or encapsulates the circuit, or in any one of or a suitable combination of three of software, hardware, and firmware. Alternatively, one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be at least partially implemented as computer program modules, which when executed, may perform the corresponding functions.

For example, any number of the acquisition module 510, the processing module 520, the conversion module 530, and the data processing module 540 may be combined in one module/unit/sub-unit, or any one of the modules/units/sub-units may be split into a plurality of modules/units/sub-units. Alternatively, at least some of the functionality of one or more of these modules/units/sub-units may be combined with at least some of the functionality of other modules/units/sub-units and implemented in one module/unit/sub-unit. According to embodiments of the present disclosure, at least one of the acquisition module 510, the processing module 520, the conversion module 530, and the data processing module 540 may be implemented at least in part as hardware circuitry, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or in hardware or firmware in any other reasonable manner of integrating or packaging the circuitry, or in any one of or a suitable combination of three of software, hardware, and firmware. Alternatively, at least one of the acquisition module 510, the processing module 520, the conversion module 530, and the data processing module 540 may be at least partially implemented as a computer program module, which when executed, may perform the corresponding functions.

It should be noted that, in the embodiments of the present disclosure, the data processing apparatus portion corresponds to the data processing method portion in the embodiments of the present disclosure, and the description of the data processing apparatus portion specifically refers to the data processing method portion and is not described herein.

Fig. 6 schematically illustrates a block diagram of an electronic device adapted to implement a data processing method according to an embodiment of the disclosure. The electronic device shown in fig. 6 is merely an example and should not be construed to limit the functionality and scope of use of the disclosed embodiments.

As shown in fig. 6, a computer electronic device 600 according to an embodiment of the present disclosure includes a processor 601 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 602 or a program loaded from a storage section 608 into a Random Access Memory (RAM) 603. The processor 601 may include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or an associated chipset and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), or the like. Processor 601 may also include on-board memory for caching purposes. The processor 601 may comprise a single processing unit or a plurality of processing units for performing different actions of the method flows according to embodiments of the disclosure.

In the RAM 603, various programs and data necessary for the operation of the electronic apparatus 600 are stored. The processor 601, the ROM 602, and the RAM 603 are connected to each other through a bus 604. The processor 601 performs various operations of the method flow according to the embodiments of the present disclosure by executing programs in the ROM 602 and/or the RAM 603. Note that the program may be stored in one or more memories other than the ROM 602 and the RAM 603. The processor 601 may also perform various operations of the method flow according to embodiments of the present disclosure by executing programs stored in the one or more memories.

According to an embodiment of the present disclosure, the electronic device 600 may also include an input/output (I/O) interface 605, the input/output (I/O) interface 605 also being connected to the bus 604. The electronic device 600 may also include one or more of the following components connected to an input/output (I/O) interface 605: an input portion 606 including a keyboard, mouse, etc.; an output portion 607 including a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, a speaker, and the like; a storage section 608 including a hard disk and the like; and a communication section 609 including a network interface card such as a LAN card, a modem, or the like. The communication section 609 performs communication processing via a network such as the internet. The drive 610 is also connected to an input/output (I/O) interface 605 as needed. Removable media 611 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is installed as needed on drive 610 so that a computer program read therefrom is installed as needed into storage section 608.

According to embodiments of the present disclosure, the method flow according to embodiments of the present disclosure may be implemented as a computer software program. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable storage medium, the computer program comprising program code for performing the method shown in the flowcharts. In such an embodiment, the computer program may be downloaded and installed from a network through the communication portion 609, and/or installed from the removable medium 611. The above-described functions defined in the system of the embodiments of the present disclosure are performed when the computer program is executed by the processor 601. The systems, devices, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.

The present disclosure also provides a computer-readable storage medium that may be embodied in the apparatus/device/system described in the above embodiments; or may exist alone without being assembled into the apparatus/device/system. The computer-readable storage medium carries one or more programs which, when executed, implement methods in accordance with embodiments of the present disclosure.

According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium. Examples may include, but are not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

For example, according to embodiments of the present disclosure, the computer-readable storage medium may include ROM 602 and/or RAM 603 and/or one or more memories other than ROM 602 and RAM 603 described above.

Embodiments of the present disclosure also include a computer program product comprising a computer program comprising program code for performing the methods provided by the embodiments of the present disclosure, the program code for causing an electronic device to implement the data processing methods provided by the embodiments of the present disclosure when the computer program product is run on the electronic device.

The above-described functions defined in the system/apparatus of the embodiments of the present disclosure are performed when the computer program is executed by the processor 601. The systems, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.

In one embodiment, the computer program may be based on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted, distributed in the form of signals over a network medium, and downloaded and installed via the communication section 609, and/or installed from the removable medium 611. The computer program may include program code that may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.

According to embodiments of the present disclosure, program code for performing computer programs provided by embodiments of the present disclosure may be written in any combination of one or more programming languages, and in particular, such computer programs may be implemented in high-level procedural and/or object-oriented programming languages, and/or assembly/machine languages. Programming languages include, but are not limited to, such as Java, c++, python, "C" or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).

The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions. Those skilled in the art will appreciate that the features recited in the various embodiments of the disclosure and/or in the claims may be combined in various combinations and/or combinations, even if such combinations or combinations are not explicitly recited in the disclosure. In particular, the features recited in the various embodiments of the present disclosure and/or the claims may be variously combined and/or combined without departing from the spirit and teachings of the present disclosure. All such combinations and/or combinations fall within the scope of the present disclosure.

The embodiments of the present disclosure are described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described above separately, this does not mean that the measures in the embodiments cannot be used advantageously in combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be made by those skilled in the art without departing from the scope of the disclosure, and such alternatives and modifications are intended to fall within the scope of the disclosure.

Claims

1. A data processing method, comprising:

responding to a data processing request, and acquiring a first text block in a source running environment;

processing the first text block based on the grammar difference between the source running environment and the target running environment to obtain a second text block;

taking parameters carried by the data processing request as environment variables, and dynamically converting the second text block into a third text block; and

and operating the third text block in the target operating environment based on the variable information carried by the data processing request so as to perform data processing on the database in the target operating environment.

2. The method of claim 1, wherein the dynamically converting the second text block into a third text block with the parameters carried by the data processing request as environment variables comprises:

sentence conversion is carried out on the second text block based on grammar rules of the target operation environment, so that a script text block is obtained; and

and calling a script engine of the target running environment to process the script text block by taking the parameters carried by the data processing request as environment variables to obtain the third text block.

3. The method of claim 2, wherein said performing sentence conversion on the second text block based on the grammar rule of the target running environment to obtain a script text block includes:

determining at least one structured query statement and at least one script statement from the second text block;

for each structured query statement, converting the structured query statement into a printout statement based on grammar rules of the target operating environment; and

and combining at least one printed output statement and at least one script statement according to a target sequence to obtain the script text block, wherein the target sequence represents the arrangement sequence of the at least one structured query statement and the at least one script statement in the second text block.

4. The method of claim 1, wherein the dynamically converting the second text block into a third text block with the parameters carried by the data processing request as environment variables comprises:

invoking a persistence framework component to process the second text block to obtain a dynamic structured query statement; and

and generating the third text block based on the dynamic structured query statement by taking the parameters carried by the data processing request as environment variables.

5. The method of claim 1, wherein the running the third text block in the target running environment based on the variable information carried by the data processing request to perform data processing on a database in the target running environment includes:

determining at least one binding variable from the third text block based on a first marker included in the third text block;

performing assignment processing on the at least one binding variable based on at least one variable value included in the variable information; and

and operating the third text block subjected to assignment processing in the target operating environment so as to perform data processing on the database in the target operating environment.

6. The method of claim 5, wherein the first marker is associated with the source runtime environment;

the method further comprises the steps of:

replacing the first markers respectively related to at least one binding variable included in the third text block with the second markers in the target running environment to obtain a fourth text block;

the step of operating the third text block subjected to assignment processing in the target operating environment so as to perform data processing on the database in the target operating environment comprises the following steps:

and operating the fourth text block subjected to assignment processing in the target operating environment so as to perform data processing on the database in the target operating environment.

7. The method of claim 1, wherein the processing the first text block based on the grammatical difference between the source runtime environment and the target runtime environment to obtain a second text block comprises:

generating a regular expression based on a grammatical difference between the source runtime environment and the target runtime environment; and

and respectively processing the first text block based on the regular expression to obtain the second text block.

8. The method of claim 7, wherein the processing the first text block based on the regular expression to obtain the second text block, respectively, comprises:

Determining keywords and/or sub-sentence blocks related to the source running environment existing in the first text block based on the regular expression; and

and deleting keywords and/or sub-sentence blocks which exist in the first text block and are related to the source operation environment to obtain the second text block.

9. The method of claim 7, wherein the processing the first text block based on the regular expression to obtain the second text block, respectively, comprises:

determining a plurality of consecutive blank characters present in the first text block based on the regular expression; and

and replacing the continuous plurality of blank characters with a single blank character to obtain the second text block.

10. A data processing apparatus comprising:

11. An electronic device, comprising:

one or more processors;

a memory for storing one or more instructions,

wherein the one or more instructions, when executed by the one or more processors, cause the one or more processors to implement the method of any of claims 1 to 9.

12. A computer readable storage medium having stored thereon executable instructions which when executed by a processor cause the processor to implement the method of any of claims 1 to 9.

13. A computer program product comprising computer executable instructions for implementing the method of any one of claims 1 to 9 when executed.