Information processing method and apparatus, electronic device, and computer-readable storage medium

Abstract

This disclosure provides an information processing method, apparatus, electronic device, and computer-readable storage medium, which can be applied to the fields of big data technology and finance. The information processing method includes: responding to receiving an information processing instruction; acquiring information to be processed according to the instruction, the information to be processed including at least one target statement and at least one target object, the information to be processed belonging to a structured query language; processing the at least one target statement to obtain position information corresponding to each of the at least one target statement, the position information being used to characterize the hierarchical relationship between the at least one target statement; processing the at least one target object to obtain first annotation information, the first annotation information including target object information corresponding to each of the at least one target object; and determining second annotation information based on the position information corresponding to each of the at least one target statement and the target object information corresponding to each of the at least one target object.

Description

Technical Field

[0001] This disclosure relates to the fields of big data technology and finance, and more specifically, to an information processing method and apparatus, electronic equipment, computer-readable storage medium and computer program product. Background Technology

[0002] With the development of big data technology, structured query language has emerged.

[0003] Structured Query Language (SQL) is a set of statements used for querying and programming databases. It is widely used in relational database systems for accessing, querying, updating, and managing data. SQL provides functions for data definition, manipulation, and control.

[0004] In realizing the concept disclosed herein, the inventors discovered at least the following problems in the related technologies: the efficiency and accuracy of data analysis using structured query language cannot be guaranteed. Summary of the Invention

[0005] In view of the above, this disclosure provides an information processing method and apparatus, an electronic device, a computer-readable storage medium, and a computer program product.

[0006] According to one aspect of this disclosure, an information processing method is provided, comprising:

[0007] In response to receiving an information processing instruction, the system obtains information to be processed according to the information processing instruction, wherein the information to be processed includes at least one target statement and at least one target object, and the information to be processed belongs to a structured query language.

[0008] The above-mentioned at least one target statement is processed to obtain position information corresponding to each of the above-mentioned at least one target statement, wherein the position information corresponding to each of the above-mentioned at least one target statement is used to characterize the hierarchical relationship between the above-mentioned at least one target statement.

[0009] Processing the at least one target object described above yields first annotation information, wherein the first annotation information includes target object information corresponding to each of the at least one target object; and

[0010] The second annotation information is determined based on the position information corresponding to each of the above-mentioned at least one target statement and the target object information corresponding to each of the above-mentioned at least one target object.

[0011] According to embodiments of this disclosure, the target statement includes at least one of the following: a target function statement and a target command statement.

[0012] According to embodiments of this disclosure, the above-mentioned processing of the at least one target statement to obtain position information corresponding to each of the at least one target statement includes:

[0013] When at least one of the target statements includes the target function statement, the preset function statement and the information to be processed are matched to obtain first matching information, wherein the first matching information is used to characterize the correspondence between the target function statement and the target preset function statement;

[0014] Based on the first matching information above, determine the position information corresponding to the above target function statement;

[0015] When at least one target statement includes the target command statement, the preset command statement and the information to be processed are matched to obtain second matching information, wherein the second matching information is used to characterize the correspondence between the target command statement and the target preset command statement; and

[0016] Based on the second matching information mentioned above, the location information corresponding to the target command statement is determined.

[0017] According to embodiments of this disclosure, the above information processing method further includes:

[0018] Based on the position information corresponding to the aforementioned objective function statement, configure the aforementioned objective function statement with the first preset color; and

[0019] Based on the position information corresponding to the target command statement, configure the target command statement with the second preset color.

[0020] According to embodiments of this disclosure, the target object includes at least one of the following: a target table object, a target field object, and a target dictionary object.

[0021] According to embodiments of this disclosure, the first annotation information mentioned above includes at least one of the following: table object annotation information, field object annotation information, and dictionary object annotation information.

[0022] According to embodiments of this disclosure, the above-described processing of at least one target object to obtain first annotation information includes:

[0023] In the case where at least one target object includes the target table object, the annotation information of the table object corresponding to the target table object is determined according to the first mapping relationship.

[0024] When at least one target object includes the target field object, the annotation information of the field object corresponding to the target field object is determined according to the second mapping relationship; and

[0025] In the case where at least one target object includes the target dictionary object, the annotation information of the dictionary object corresponding to the target dictionary object is determined according to the third mapping relationship.

[0026] According to embodiments of this disclosure, the first mapping relationship includes at least one first key-value pair, which is determined based on at least one preset table object and table object information corresponding to each of the at least one preset table object.

[0027] According to embodiments of this disclosure, the second mapping relationship includes at least one second key-value pair, which is determined based on at least one preset field object and field object information corresponding to each of the at least one preset field object.

[0028] According to embodiments of this disclosure, the third mapping relationship includes at least one third key-value pair, which is determined based on at least one preset dictionary object and dictionary object information corresponding to each of the at least one preset dictionary object.

[0029] According to embodiments of this disclosure, the aforementioned second annotation information is in natural language.

[0030] According to embodiments of this disclosure, determining the second annotation information based on the position information corresponding to each of the at least one target statement and the target object information corresponding to each of the at least one target object includes:

[0031] Based on the location information corresponding to each of the above-mentioned at least one target statement and the target object information corresponding to each of the above-mentioned at least one target object, a natural language template is determined; and

[0032] The position information corresponding to each of the above-mentioned target statements and the target object information corresponding to each of the above-mentioned target objects are filled into the above-mentioned natural language template to obtain the above-mentioned second annotation information.

[0033] According to embodiments of this disclosure, the natural language template includes at least one of the following: a first natural language template and a second natural language template.

[0034] According to embodiments of this disclosure, determining the natural language template based on the position information corresponding to each of the at least one target statement and the target object information corresponding to each of the at least one target object includes:

[0035] Based on the at least one target object mentioned above, determine the first natural language template corresponding to each of the at least one target object; and

[0036] Based on the position information corresponding to each of the above-mentioned target statements, at least one of the above-mentioned second natural language templates is determined.

[0037] According to embodiments of this disclosure, the second annotation information obtained by filling the position information corresponding to each of the at least one target statement and the target object information corresponding to each of the at least one target object into the natural language template includes:

[0038] The target object information corresponding to each of the above-mentioned at least one target object is filled into the first natural language template corresponding to each of the above-mentioned at least one target object, to obtain the second annotation information corresponding to the first natural language template; and

[0039] Based on the position information corresponding to each of the above-mentioned at least one target statement, the above-mentioned second annotation information corresponding to the above-mentioned first natural language template is filled into the above-mentioned second natural language template corresponding to each of the above-mentioned at least one target object, so as to obtain the above-mentioned second annotation information corresponding to the above-mentioned second natural language template.

[0040] According to embodiments of this disclosure, the information processing method further includes, after determining the second annotation information based on the position information corresponding to each of the at least one target statement and the target object information corresponding to each of the at least one target object:

[0041] The first annotation information is displayed in the first target area of ​​the target page, wherein the target page represents the page that receives the information processing instruction; and the second annotation information is displayed in the second target area of ​​the target page.

[0042] The positional relationship between the first target area and the second target area satisfies the predetermined positional relationship conditions.

[0043] According to embodiments of this disclosure, the above-mentioned response to receiving an information processing instruction, and the acquisition of information to be processed according to the information processing instruction, includes:

[0044] In response to receiving the above information processing instruction, the information type is determined according to the above information processing instruction, wherein the above information type is used to characterize the input type of the original information to be processed;

[0045] Based on the information type of the original information to be processed, obtain the original information to be processed; and

[0046] The original information to be processed is parsed to obtain at least one target statement and at least one target object from the information to be processed.

[0047] According to embodiments of this disclosure, the information types mentioned above include at least one of the following: text type and image type.

[0048] According to embodiments of this disclosure, obtaining the original information to be processed based on its information type includes one of the following methods:

[0049] If the above information type indicates that the original information to be processed belongs to the text type, then obtain the original information to be processed.

[0050] When the aforementioned information type indicates that the original information to be processed belongs to the image type, an image to be processed is obtained, wherein the image to be processed includes the original information to be processed; and

[0051] The above-mentioned image to be processed is subjected to image recognition processing to obtain the above-mentioned original information to be processed.

[0052] According to another aspect of this disclosure, an information processing apparatus is provided, comprising:

[0053] The acquisition module is used to respond to receiving an information processing instruction and acquire information to be processed according to the information processing instruction. The information to be processed includes at least one target statement and at least one target object. The information to be processed belongs to a structured query language.

[0054] The first processing module is used to process the at least one target statement to obtain position information corresponding to each of the at least one target statement, wherein the position information corresponding to each of the at least one target statement is used to characterize the hierarchical relationship between the at least one target statement and each other.

[0055] The second processing module is configured to process the at least one target object to obtain first annotation information, wherein the first annotation information includes target object information corresponding to each of the at least one target object; and

[0056] The determination module is used to determine the second annotation information based on the position information corresponding to each of the above-mentioned at least one target statement and the target object information corresponding to each of the above-mentioned at least one target object.

[0057] According to another aspect of this disclosure, an electronic device is provided, comprising:

[0058] One or more processors;

[0059] Memory, used to store one or more instructions.

[0060] When one or more of the above instructions are executed by one or more processors, the one or more processors cause the one or more processors to implement the method as described in this disclosure.

[0061] According to another aspect of this disclosure, a computer-readable storage medium is provided having executable instructions stored thereon, which, when executed by a processor, cause the processor to perform the methods described in this disclosure.

[0062] According to another aspect of this disclosure, a computer program product is provided, which includes computer-executable instructions that, when executed, are used to perform the methods described in this disclosure.

[0063] According to embodiments of this disclosure, since the positional information corresponding to each of the at least one target statement is obtained by processing the at least one target statement, the positional information can characterize the hierarchical relationship between the at least one target statement. Since the first annotation information is obtained by processing at least one target object, the first annotation information can characterize the target object information corresponding to each of the at least one target object. Based on this, by determining the second annotation information according to the positional information corresponding to each of the at least one target statement and the first annotation information, annotation of at least one target statement and at least one target object in the information to be processed can be automatically achieved. This at least partially overcomes the technical problem in related technologies that cannot guarantee the efficiency and accuracy of data analysis using structured query language, and improves the efficiency of information processing based on structured query language. Furthermore, since the first annotation information and the second annotation information can be obtained from the information to be processed, the readability and comprehensibility of structured query language are improved, further enhancing the accuracy of information processing based on structured query language. Attached Figure Description

[0064] The above and other objects, features and advantages of this disclosure will become clearer from the following description of embodiments with reference to the accompanying drawings, in which:

[0065] Figure 1 This illustration schematically shows a system architecture to which information processing methods can be applied according to embodiments of the present disclosure;

[0066] Figure 2 A flowchart illustrating an information processing method according to an embodiment of the present disclosure is shown schematically.

[0067] Figure 3 This illustration schematically shows an example of a process of obtaining information to be processed in response to receiving an information processing instruction, according to an embodiment of the present disclosure.

[0068] Figure 4The illustration shows an example diagram of a process of processing at least one target statement according to an embodiment of the present disclosure to obtain position information corresponding to each of the at least one target statement.

[0069] Figure 5A The illustration shows an example schematic diagram of a process of processing at least one target object to obtain first annotation information according to an embodiment of the present disclosure;

[0070] Figure 5B This illustration schematically shows an example of a process of processing at least one target object to obtain first annotation information according to another embodiment of the present disclosure;

[0071] Figure 5C This illustration schematically shows an example of a process of processing at least one target object to obtain first annotation information according to another embodiment of the present disclosure;

[0072] Figure 6 This illustration schematically shows an example of a process for determining second annotation information based on position information corresponding to at least one target statement and target object information corresponding to at least one target object, according to an embodiment of the present disclosure.

[0073] Figure 7 A block diagram schematically illustrates an information processing apparatus according to embodiments of the present disclosure; and

[0074] Figure 8 A block diagram of an electronic device suitable for implementing an information processing method according to an embodiment of the present disclosure is shown schematically. Detailed Implementation

[0075] The embodiments of the present disclosure will now be described with reference to the accompanying drawings. However, it should be understood that these descriptions are exemplary only and are not intended to limit the scope of the disclosure. In the following detailed description, numerous specific details are set forth to provide a thorough understanding of the embodiments of the present disclosure for ease of explanation. However, it will be apparent that one or more embodiments may be practiced without these specific details. Furthermore, descriptions of well-known structures and techniques are omitted in the following description to avoid unnecessarily obscuring the concepts of the present disclosure.

[0076] The terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit this disclosure. The terms “comprising,” “including,” etc., as used herein indicate the presence of the stated features, steps, operations, and / or components, but do not exclude the presence or addition of one or more other features, steps, operations, or components.

[0077] All terms used herein (including technical and scientific terms) have the meanings commonly understood by those skilled in the art, unless otherwise defined. It should be noted that the terms used herein are to be interpreted in a manner consistent with the context of this specification, and not in an idealized or overly rigid way.

[0078] When using expressions such as "at least one of A, B, and C," the expression should generally be interpreted in accordance with the meaning commonly understood by a person skilled in the art (e.g., "a system having at least one of A, B, and C" should include, but is not limited to, systems having A alone, having B alone, having C alone, having A and B, having A and C, having B and C, and / or having A, B, and C, etc.). Similarly, when using expressions such as "at least one of A, B, or C," the expression should generally be interpreted in accordance with the meaning commonly understood by a person skilled in the art (e.g., "a system having at least one of A, B, or C" should include, but is not limited to, systems having A alone, having B alone, having C alone, having A and B, having A and C, having B and C, and / or having A, B, and C, etc.).

[0079] In the technical solution disclosed herein, the acquisition, storage, and application of user personal information comply with the provisions of relevant laws and regulations, necessary confidentiality measures have been taken, and there is no violation of public order and good morals.

[0080] In the technical solution disclosed herein, the user's authorization or consent is obtained before acquiring or collecting the user's personal information.

[0081] Structured Query Language (SCL) belongs to the category of database query and programming languages. SCL can include at least one of the following: Data Query Language (DQL), Data Manipulation Language (DML), Transaction Control Language (TCL), Data Control Language (DCL), Data Language Definition (DDL), and Cursor Control Language (CCL).

[0082] However, due to the continuous occurrence of data query and analysis needs, and the frequent changes in data structures, data analysis work has a certain degree of iterativeness and timeliness. In the process of realizing the concept disclosed herein, the inventors discovered that the related technologies have at least the following problems: the efficiency and accuracy of data analysis using structured query language cannot be guaranteed.

[0083] To at least partially address the technical problems existing in related technologies, this disclosure provides an information processing method and apparatus, electronic device, and computer-readable storage medium, which can be applied to the fields of big data technology and finance. The information processing method includes: in response to receiving an information processing instruction, acquiring information to be processed according to the instruction, the information to be processed including at least one target statement and at least one target object, the information to be processed belonging to a structured query language; processing the at least one target statement to obtain position information corresponding to each of the at least one target statement, the position information being used to characterize the hierarchical relationship between the at least one target statement; processing the at least one target object to obtain first annotation information, the first annotation information including target object information corresponding to each of the at least one target object; and determining second annotation information based on the position information corresponding to each of the at least one target statement and the target object information corresponding to each of the at least one target object.

[0084] It should be noted that the information processing method and apparatus provided in this disclosure can be used in the fields of big data technology and finance, for example, in the field of information processing technology. The information processing method and apparatus provided in this disclosure can also be used in any field other than big data technology and finance, for example, in database management. The application fields of the information processing method and apparatus provided in this disclosure are not limited.

[0085] Figure 1 The illustration schematically depicts a system architecture to which information processing methods can be applied according to embodiments of the present disclosure. It should be noted that... Figure 1 The examples shown are merely examples of system architectures that can be applied to the embodiments of this disclosure, in order to help those skilled in the art understand the technical content of this disclosure, but do not mean that the embodiments of this disclosure cannot be used in other devices, systems, environments or scenarios.

[0086] like Figure 1 As shown, the system architecture 100 according to this embodiment may include a first terminal device 101, a second terminal device 102, a third terminal device 103, a network 104, and a server 105. The network 104 serves as a medium for providing communication links between the first terminal device 101, the second terminal device 102, the third terminal device 103, and the server 105. The network 104 may include various connection types, such as wired or wireless communication links, or fiber optic cables, etc.

[0087] Users can interact with server 105 via network 104 using at least one of the first terminal device 101, second terminal device 102, and third terminal device 103 to receive or send messages, etc. Various communication client applications can be installed on the first terminal device 101, second terminal device 102, and third terminal device 103, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients, social media platform software, etc. (for example only).

[0088] The first terminal device 101, the second terminal device 102, and the third terminal device 103 can be various electronic devices with displays and support web browsing, including but not limited to smartphones, tablets, laptops, and desktop computers.

[0089] Server 105 can be a server that provides various services, such as a backend management server that supports websites browsed by users using the first terminal device 101, the second terminal device 102, and the third terminal device 103 (this is just an example). The backend management server can analyze and process data such as received user requests, and feed back the processing results (such as web pages, information, or data obtained or generated according to user requests) to the terminal devices.

[0090] It should be noted that the information processing method provided in this embodiment can generally be executed by server 105. Correspondingly, the information processing device provided in this embodiment can generally be located in server 105. The information processing method provided in this embodiment can also be executed by a server or server cluster that is different from server 105 and capable of communicating with the first terminal device 101, the second terminal device 102, the third terminal device 103, and / or server 105. Correspondingly, the information processing device provided in this embodiment can also be located in a server or server cluster that is different from server 105 and capable of communicating with the first terminal device 101, the second terminal device 102, the third terminal device 103, and / or server 105.

[0091] Alternatively, the data information method provided in the embodiments of this disclosure can also be executed by the first terminal device 101, the second terminal device 102, or the third terminal device 103, or by other terminal devices different from the first terminal device 101, the second terminal device 102, or the third terminal device 103. Correspondingly, the information processing apparatus provided in the embodiments of this disclosure can also be disposed in the first terminal device 101, the second terminal device 102, or the third terminal device 103, or in other terminal devices different from the first terminal device 101, the second terminal device 102, or the third terminal device 103.

[0092] For example, the original information to be processed may be originally stored in any one of terminal devices 101, 102, or 103 (e.g., terminal device 101, but not limited thereto), or it may be stored on an external storage device and imported into terminal device 101. Then, terminal device 101 may execute the information processing method provided in the embodiments of this disclosure locally, or send the original information to be processed to other terminal devices, servers, or server clusters, and have the other terminal devices, servers, or server clusters that receive the original information to be processed execute the information processing method provided in the embodiments of this disclosure.

[0093] It should be understood that Figure 1 The number of terminal devices, networks, and servers shown is merely illustrative. Depending on implementation needs, any number of terminal devices, networks, and servers can be included.

[0094] It should be noted that the sequence numbers of the operations in the following methods are for descriptive purposes only and should not be considered as indicating the execution order of the operations. Unless explicitly stated otherwise, the method does not need to be executed in the exact order shown.

[0095] Figure 2 A flowchart illustrating an information processing method according to an embodiment of the present disclosure is shown schematically.

[0096] like Figure 2 As shown, the information processing method 200 may include operations S210 to S240.

[0097] In operation S210, in response to receiving an information processing instruction, information to be processed is obtained according to the information processing instruction. The information to be processed includes at least one target statement and at least one target object. The information to be processed belongs to a structured query language.

[0098] In operation S220, at least one target statement is processed to obtain position information corresponding to each of the at least one target statement, wherein the position information corresponding to each of the at least one target statement is used to characterize the hierarchical relationship between the at least one target statement and each other.

[0099] In operation S230, at least one target object is processed to obtain first annotation information, wherein the first annotation information includes target object information corresponding to each of the at least one target object.

[0100] In operation S240, the second annotation information is determined based on the position information corresponding to at least one target statement and the target object information corresponding to at least one target object.

[0101] According to embodiments of this disclosure, in response to receiving an information processing instruction, information to be processed can be retrieved from a data source. The data source may include at least one of the following: a local database, a cloud database, and network resources. The information to be processed may be in a Structured Query Language (SCL) format. For example, a data interface may be invoked. The data interface is used to retrieve the information to be processed from the data source.

[0102] According to embodiments of this disclosure, in response to receiving an information processing instruction, raw information to be processed can also be obtained from a data source. The raw information to be processed may be in a Structured Query Language (SCL) format. The raw information to be processed may include at least one of the following: raw text information to be processed, raw image information to be processed, and raw speech information to be processed. After obtaining the raw information to be processed, the information to be processed can be determined based on the raw information to be processed. For example, if the raw information to be processed includes raw image information to be processed, image recognition processing can be performed on the raw image information to obtain the information to be processed. Alternatively, if the raw information to be processed includes raw speech information to be processed, speech recognition processing can be performed on the raw speech information to obtain the information to be processed.

[0103] According to embodiments of this disclosure, the information to be processed may include at least one target statement and at least one target object. The target statement may include at least one of the following: a target function statement and a target command statement. The target object may include at least one of the following: a target table object (i.e., Table), a target field object (i.e., Column), and a target dictionary object (i.e., Dictionary).

[0104] According to embodiments of this disclosure, after obtaining the information to be processed, at least one target statement in the information to be processed can be processed to obtain position information corresponding to each of the at least one target statement. The position information can be used to characterize the hierarchical relationship between the at least one target statement. The hierarchical relationship can include the subordinate relationship between the at least one target statement. For example, the information to be processed may include target statement A, target statement B, and target statement C. The position information corresponding to target statement A can be in row 1, column 1; the position information corresponding to target statement B can be in row 2, column 1; and the position information corresponding to target statement C can be in row 3, column 2.

[0105] According to embodiments of this disclosure, after obtaining the information to be processed, at least one target object can be processed to obtain first annotation information. The first annotation information may include target object information corresponding to each of the at least one target object. The target object information can be used to characterize the meaning of the target object. The first annotation information may include table object annotation information, field object annotation information, and dictionary object annotation information. For example, if at least one target object includes a target table object, further processing of the target table object can yield first annotation information including table object annotation information. If at least one target object includes a target field object, further processing of the target field object can yield first annotation information including field object annotation information. If at least one target object includes a target dictionary object, further processing of the target dictionary object can yield first annotation information including dictionary object annotation information.

[0106] According to embodiments of this disclosure, after obtaining location information and first annotation information corresponding to at least one target statement, second annotation information can be obtained based on the location information corresponding to each of the at least one target statement and the target object information corresponding to each of the at least one target object. The second annotation information may be in natural language. The second annotation information can be used to characterize the natural language interpretation associated with the information to be processed. After obtaining the first and second annotation information, at least one of the first and second annotation information can be displayed for reference by the user initiating the information processing instruction.

[0107] According to embodiments of this disclosure, since the positional information corresponding to each of the at least one target statement is obtained by processing the at least one target statement, the positional information can characterize the hierarchical relationship between the at least one target statement. Since the first annotation information is obtained by processing at least one target object, the first annotation information can characterize the target object information corresponding to each of the at least one target object. Based on this, by determining the second annotation information according to the positional information corresponding to each of the at least one target statement and the first annotation information, annotation of at least one target statement and at least one target object in the information to be processed can be automatically achieved. This at least partially overcomes the technical problem in related technologies that cannot guarantee the efficiency and accuracy of data analysis using structured query language, and improves the efficiency of information processing based on structured query language. Furthermore, since the first annotation information and the second annotation information can be obtained from the information to be processed, the readability and comprehensibility of structured query language are improved, further enhancing the accuracy of information processing based on structured query language.

[0108] The following is for reference. Figure 3 , Figure 4 , Figure 5A , Figure 5B , Figure 5C , Figure 6 and Figure 7 The information processing method 200 according to an embodiment of the present invention will be further described.

[0109] According to embodiments of this disclosure, operation S210 may include the following operations.

[0110] In response to receiving an information processing instruction, the system determines the information type based on the instruction, whereby the information type characterizes the input type of the original information to be processed. Based on the information type of the original information to be processed, the system obtains the original information to be processed. The original information to be processed is then parsed to obtain at least one target statement and at least one target object.

[0111] According to embodiments of this disclosure, information processing instructions can be generated and sent periodically, or they can be generated and sent in response to user input on a target interface, triggered by the user. For example, the code for generating information processing requests can be pre-written into a script. When information processing is required, the user can run the script through a terminal device to generate an information processing request and send it to the server, so that the server can perform information processing operations based on the request.

[0112] According to embodiments of this disclosure, after receiving an information processing instruction, the information type can be determined based on the instruction. The information type may include at least one of the following: text, image, and voice. After determining the information type, the original information to be processed can be obtained based on its information type. After obtaining the original information to be processed, it can be parsed to obtain information to be processed. The information to be processed may include at least one target statement and at least one target object.

[0113] According to embodiments of this disclosure, obtaining the original information to be processed, based on the information type of the original information to be processed, may include one of the following methods.

[0114] If the information type characterization indicates that the original information to be processed is text, then the original information to be processed is obtained. If the information type characterization indicates that the original information to be processed is image, then the image to be processed is obtained, wherein the image to be processed includes the original information to be processed. Image recognition processing is performed on the image to be processed to obtain the original information to be processed.

[0115] According to embodiments of this disclosure, the information type may include at least one of the following: text type and image type.

[0116] According to embodiments of this disclosure, after determining the information type of the original information to be processed, the original information to be processed can be obtained according to the information type. The input type may include at least one of the following: text input, image input, and voice input. The text input method may include at least one of the following: text entry, text copying, and text importing. The information type corresponding to the input type may include at least one of the following: text type, image type, and voice type.

[0117] For example, if the information type includes text, the raw text-formatted information to be processed can be directly obtained. Alternatively, if the information type includes speech, the speech to be processed, including the raw information to be processed, can be obtained. Speech recognition processing is then performed on the speech to be processed to obtain the raw information to be processed.

[0118] Alternatively, when the information type includes an image type, a to-be-processed image including the original to-be-processed information can be obtained. Image recognition processing is performed on the to-be-processed image to obtain the original to-be-processed information. The file format of the to-be-processed image may include at least one of the following: JPG (Joint Photographic Experts Group), TIFF (Tag Image File Format), PNG (Portable Network Graphics), PDF (Portable Document Format), and GIF (Graphics Interchange Format), etc. This disclosure does not limit the file format of the to-be-processed image.

[0119] According to embodiments of this disclosure, when the information type includes an image, text box recognition can be performed on the image to be processed using OCR (Optical Character Recognition) technology to obtain at least one text region in the image. Character recognition can be performed on each text region within the at least one text region to obtain the field content corresponding to each text region. Based on the field content corresponding to each text region, the original information to be processed is obtained.

[0120] According to embodiments of this disclosure, since information type can be used to characterize the input type of the original information to be processed, and the original information to be processed is obtained based on its information type, which can include at least one of text type and image type, it is possible to obtain original information to be processed of different information types in different ways, thereby improving the adaptability of the information processing method. Furthermore, by parsing the original information to be processed, the information to be processed can be automatically obtained, thereby improving the efficiency of information processing based on structured query language.

[0121] Figure 3 The illustration shows an example of a process of obtaining information to be processed in response to receiving an information processing instruction, according to an embodiment of the present disclosure.

[0122] like Figure 3 As shown, in 300, in response to receiving information processing instruction 301, information type 302 can be determined according to information processing instruction 301. Information type 302 may include at least one of the following: text type and image type.

[0123] When information type 302 indicates that the original information to be processed is of the text type, the original information to be processed 304 can be obtained.

[0124] If information type 302 indicates that the original information to be processed belongs to the image type, then image 303 to be processed can be obtained. Image recognition processing is performed on image 303 to obtain the original information to be processed 304.

[0125] After obtaining the original information to be processed 304, the original information to be processed 304 can be parsed to obtain at least one target statement 305 and at least one target object 306 in the information to be processed.

[0126] According to embodiments of this disclosure, operation S220 may include the following operations.

[0127] When at least one target statement includes a target function statement, the preset function statement and the information to be processed are matched to obtain first matching information, wherein the first matching information is used to characterize the correspondence between the target function statement and the target preset function statement. Based on the first matching information, the position information corresponding to the target function statement is determined. When at least one target statement includes a target command statement, the preset command statement and the information to be processed are matched to obtain second matching information, wherein the second matching information is used to characterize the correspondence between the target command statement and the target preset command statement. Based on the second matching information, the position information corresponding to the target command statement is determined.

[0128] According to embodiments of this disclosure, the target statement may include at least one of the following: a target function statement and a target command statement.

[0129] According to embodiments of this disclosure, when at least one target statement includes a target function statement, a preset function statement can be obtained. The preset function statement may include at least one of the following: aggregate function statements, conversion function statements, date function statements, mathematical function statements, string function statements, system function statements, and text and image function statements. The preset function statement may also have a corresponding text indentation format. The text indentation format of the preset function statement can be set according to actual business needs and is not limited herein. For example, the text indentation format corresponding to an aggregate function statement may be 1 character, and the text indentation format corresponding to a conversion function statement may be 2 characters.

[0130] According to embodiments of this disclosure, after obtaining a preset function statement, the preset function statement and the information to be processed can be matched to obtain first matching information. The first matching information can be used to characterize the correspondence between a target function statement and a target preset function statement. After obtaining the first matching information, the position information corresponding to the target function statement can be determined based on the first matching information and the text indentation format characterized by the correspondence.

[0131] According to embodiments of this disclosure, when at least one target statement includes a target command statement, a preset command statement can be obtained. The preset command statement may include at least one of the following: SELECT, FROM, WHERE, AND, OR, GROUP BY, HAVING, and ORDER BY. The preset command statement may also have a corresponding text indentation format. The text indentation format of the preset command statement can be set according to actual business needs and is not limited herein. For example, the text indentation format corresponding to SELECT may be 0.5 characters, and the text indentation format corresponding to FROM may be 4 characters.

[0132] According to embodiments of this disclosure, after obtaining a preset command statement, the preset command statement and the information to be processed can be matched to obtain second matching information. The second matching information can be used to characterize the correspondence between a target command statement and a target preset command statement. After obtaining the second matching information, the position information corresponding to the target command statement can be determined based on the second matching information and the text indentation format characterized by the correspondence.

[0133] According to embodiments of this disclosure, operation S220 may further include the following operations.

[0134] Based on the position information corresponding to the target function statement, the target function statement is configured with a first preset color. Based on the position information corresponding to the target command statement, the target command statement is configured with a second preset color.

[0135] According to embodiments of this disclosure, after obtaining the location information corresponding to the target function statement, the target function statement can be configured with a first preset color based on the location information. The first preset color can be set according to actual business needs and is not limited thereto. For example, the first preset color can be set to red.

[0136] According to embodiments of this disclosure, after obtaining the location information corresponding to the target command statement, the target command statement can be configured with a second preset color based on the location information. The second preset color can be set according to actual business needs and is not limited thereto. For example, the second preset color can be set to blue.

[0137] According to embodiments of this disclosure, when at least one target statement includes a target function statement, first matching information is obtained by matching a preset function statement and the information to be processed. Based on this, since the position information corresponding to the target function statement is determined according to the first matching information, and the first preset color is configured according to the position information corresponding to the target function statement, the readability of the structured query language is improved, thereby improving the accuracy of information processing based on the structured query language. Furthermore, when at least one target statement includes a target command statement, second matching information is obtained by matching a preset command statement and the information to be processed. Based on this, since the position information corresponding to the target command statement is determined according to the second matching information, and the second preset color is configured according to the position information corresponding to the target command statement, the readability of the structured query language is improved, thereby improving the accuracy of information processing based on the structured query language.

[0138] Figure 4 The illustration shows an example diagram of a process for processing at least one target statement according to an embodiment of the present disclosure to obtain location information corresponding to each of the at least one target statement.

[0139] like Figure 4 As shown, in 400, in response to receiving information processing instruction 401, information to be processed 402 can be obtained according to information processing instruction 401. Information to be processed 402 may include at least one target statement and at least one target object. The target statement may include at least one of the following: a target function statement and a target command statement.

[0140] When at least one target statement includes a target function statement, the preset function statement and the information to be processed can be matched to obtain first matching information 403. Based on the first matching information 403, the position information 404 corresponding to the target function statement is determined. Based on the position information 404 corresponding to the target function statement, the target function statement is configured with a first preset color 405.

[0141] If at least one target statement includes a target command statement, the preset command statement and the information to be processed are matched to obtain second matching information 406. Based on the second matching information 406, the position information 407 corresponding to the target command statement is determined. Based on the position information 407 corresponding to the target command statement, the target command statement is configured with a second preset color 408.

[0142] According to embodiments of this disclosure, operation S230 may include the following operations.

[0143] If at least one target object includes a target table object, the table object annotation information corresponding to the target table object is determined according to the first mapping relationship. If at least one target object includes a target field object, the field object annotation information corresponding to the target field object is determined according to the second mapping relationship. If at least one target object includes a target dictionary object, the dictionary object annotation information corresponding to the target dictionary object is determined according to the third mapping relationship.

[0144] According to embodiments of this disclosure, the target object may include at least one of the following: a target table object, a target field object, and a target dictionary object. The first annotation information may include at least one of the following: table object annotation information, field object annotation information, and dictionary object annotation information.

[0145] According to embodiments of this disclosure, a first mapping relationship can be used to characterize the mapping relationship between preset table objects and table object information. For example, the first mapping relationship may include a one-to-one correspondence between preset table objects and table object information. A second mapping relationship can be used to characterize the mapping relationship between preset field objects and field object information. For example, the second mapping relationship may include a one-to-one correspondence between preset field objects and field object information. A third mapping relationship can be used to characterize the mapping relationship between preset dictionary objects and dictionary object information. For example, the third mapping relationship may include a one-to-one correspondence between preset dictionary objects and dictionary object information.

[0146] According to embodiments of this disclosure, when at least one target object includes a target table object, a first similarity can be calculated between the identifier corresponding to the target table object and the identifier corresponding to a preset table object in the first mapping relationship. In response to the first similarity being greater than a first preset threshold, a matching preset table object in the first mapping relationship can be determined. The table object information corresponding to the preset table object matching the first mapping relationship can be determined as the table object annotation information of the target table object.

[0147] According to embodiments of this disclosure, when at least one target object includes a target field object, a second similarity can be calculated between the identifier corresponding to the target field object and the identifier corresponding to a preset field object in the second mapping relationship. In response to the second similarity being greater than a second preset threshold, a matching preset field object in the second mapping relationship can be determined. The field object information corresponding to the preset field object matching the second mapping relationship can be determined as the field object annotation information of the target field object.

[0148] According to embodiments of this disclosure, when at least one target object includes a target dictionary object, a third similarity can be calculated between the identifier corresponding to the target dictionary object and the identifier corresponding to a preset dictionary object in a third mapping relationship. In response to a third similarity greater than a third preset threshold, a matching preset dictionary object in the third mapping relationship can be determined. The dictionary object information corresponding to the preset dictionary object matching the third mapping relationship can be determined as the dictionary object annotation information of the target dictionary object.

[0149] According to embodiments of this disclosure, the first preset threshold, the second preset threshold, and the third preset threshold can be set according to actual business needs, and are not limited herein. The first preset threshold, the second preset threshold, and the third preset threshold can be the same, for example, they can all be set to 0.95. Alternatively, the first preset threshold, the second preset threshold, and the third preset threshold can also be different, for example, the first preset threshold can be 0.9, the second preset threshold can be 0.85, and the third preset threshold can be 0.8.

[0150] According to embodiments of this disclosure, the first mapping relationship includes at least one first key-value pair, which is determined based on at least one preset table object and table object information corresponding to each of the at least one preset table object.

[0151] According to embodiments of this disclosure, the second mapping relationship includes at least one second key-value pair, which is determined based on at least one preset field object and field object information corresponding to each of the at least one preset field object.

[0152] According to embodiments of this disclosure, the third mapping relationship includes at least one third key-value pair, which is determined based on at least one preset dictionary object and dictionary object information corresponding to each of the at least one preset dictionary object.

[0153] According to embodiments of this disclosure, at least one first key-value pair can be determined based on at least one preset table object and table object information corresponding to each of the at least one preset table object. After determining at least one first key-value pair, a first mapping relationship can be determined based on the at least one first key-value pair. The first mapping relationship can be used to characterize the mapping relationship between the preset table object and the table object information.

[0154] According to embodiments of this disclosure, at least one first key-value pair can be determined based on at least one preset field object and field object information corresponding to each of the at least one preset field object. After determining at least one first key-value pair, a first mapping relationship can be determined based on the at least one first key-value pair. The first mapping relationship can be used to map the preset field object and the field object information.

[0155] According to embodiments of this disclosure, at least one first key-value pair can be determined based on at least one preset dictionary object and dictionary object information corresponding to each of the at least one preset dictionary object. After determining at least one first key-value pair, a first mapping relationship can be determined based on the at least one first key-value pair. The first mapping relationship can be used to represent the mapping relationship between the preset dictionary object and the dictionary object information.

[0156] According to embodiments of this disclosure, since the first mapping relationship includes at least one first key-value pair, and the at least one first key-value pair is determined based on at least one preset table object and table object information corresponding to each of the at least one preset table object, the table object annotation information corresponding to the target table object can be automatically determined based on the first mapping relationship, thereby improving the efficiency of obtaining the table object annotation information corresponding to the target table object. Furthermore, since the second mapping relationship includes at least one second key-value pair, and the at least one second key-value pair is determined based on at least one preset field object and field object information corresponding to each of the at least one preset field object, the field object annotation information corresponding to the target field object can be automatically determined based on the second mapping relationship, thereby improving the efficiency of obtaining the field object annotation information corresponding to the target field object. Additionally, since the third mapping relationship includes at least one third key-value pair, and the at least one third key-value pair is determined based on at least one preset dictionary object and dictionary object information corresponding to each of the at least one preset dictionary object, the dictionary object annotation information corresponding to the target dictionary object can be automatically determined based on the third mapping relationship, thereby improving the efficiency of obtaining the dictionary object annotation information corresponding to the target dictionary object.

[0157] Figure 5A The illustration shows an example diagram of a process for processing at least one target object to obtain first annotation information according to an embodiment of the present disclosure.

[0158] like Figure 5A As shown, in 500A, at least one first key-value pair 503 can be determined based on at least one preset table object 501 and table object information 502 corresponding to the preset table object. After determining at least one first key-value pair 503, a first mapping relationship 504 can be determined based on at least one first key-value pair 503.

[0159] When at least one object type represents a target object including a target table object, the table object information 505 corresponding to the target table object can be determined according to the first mapping relationship 504.

[0160] Figure 5B The illustration shows an example diagram of a process for processing at least one target object to obtain first annotation information according to another embodiment of the present disclosure.

[0161] like Figure 5B As shown, in 500B, at least one second key-value pair 508 can be determined based on at least one preset field object 506 and field object information 507 corresponding to the preset field object. After determining at least one second key-value pair 508, a second mapping relationship 509 can be determined based on at least one second key-value pair 508.

[0162] When at least one object type represents a target object including a target field object, the field object information 510 corresponding to the target field object can be determined according to the second mapping relationship 509.

[0163] Figure 5C The illustration shows an example diagram of a process for processing at least one target object to obtain first annotation information according to another embodiment of the present disclosure.

[0164] like Figure 5C As shown, in 500C, at least one third key-value pair 513 can be determined based on at least one preset dictionary object 511 and dictionary object information 512 corresponding to the preset dictionary object. After determining at least one third key-value pair 513, a third mapping relationship 514 can be determined based on at least one third key-value pair 513.

[0165] When at least one object type represents a target object including a target dictionary object, the dictionary object information 515 corresponding to the target dictionary object can be determined according to the third mapping relationship 514.

[0166] According to embodiments of this disclosure, operation S240 may include the following operations.

[0167] A natural language template is determined based on the positional information corresponding to at least one target statement and the target object information corresponding to at least one target object. The positional information corresponding to at least one target statement and the target object information corresponding to at least one target object are then filled into the natural language template to obtain the second annotation information.

[0168] According to embodiments of this disclosure, the second annotation information may be in natural language.

[0169] According to embodiments of this disclosure, a natural language can refer to a language that has naturally evolved with culture. For example, a natural language can include Chinese, English, Japanese, and Arabic. Correspondingly, a natural language script can include Chinese characters, English characters, Japanese characters, and Arabic characters.

[0170] According to embodiments of this disclosure, a natural language template may include at least one of the following: a first natural language template and a second natural language template. After obtaining position information corresponding to at least one target statement and target object information corresponding to at least one target object, at least one of the first natural language template and the second natural language template can be determined.

[0171] According to embodiments of this disclosure, the natural language template may include at least one of the following: a natural language statement, table object annotation information to be filled, field object annotation information to be filled, and dictionary object annotation information to be filled. After determining the natural language template, table object annotation information can be filled into the table object annotation information to be filled, field object annotation information can be filled into the field object annotation information to be filled, and dictionary object annotation information can be filled into the dictionary object annotation information to be filled, to obtain the second annotation information.

[0172] According to embodiments of this disclosure, determining a natural language template based on position information corresponding to at least one target statement and target object information corresponding to at least one target object may include the following operations.

[0173] Based on at least one target object, determine a first natural language template corresponding to each of the at least one target object. Based on the position information corresponding to each of the at least one target statement, determine at least one second natural language template.

[0174] According to embodiments of this disclosure, filling the position information corresponding to at least one target statement and the target object information corresponding to at least one target object into a natural language template to obtain second annotation information may include the following operations.

[0175] The target object information corresponding to each of the at least one target object is filled into the first natural language template corresponding to each of the at least one target object, to obtain the second annotation information corresponding to the first natural language template. Based on the position information corresponding to each of the at least one target statement, the second annotation information corresponding to the first natural language template is filled into the second natural language template corresponding to each of the at least one target object, to obtain the second annotation information corresponding to the second natural language template.

[0176] According to embodiments of this disclosure, a natural language template may include at least one of the following: a first natural language template and a second natural language template.

[0177] According to embodiments of this disclosure, since the first natural language template is determined based on at least one target object, the second annotation information corresponding to the first natural language template can explain part of the function of the information to be processed in natural language. The second natural language template is determined based on the positional information corresponding to each of the at least one target statement, and therefore the second annotation information corresponding to the second natural language template can explain the overall function of the information to be processed in natural language. Based on this, the readability and comprehensibility of the structured query language are improved, thereby increasing the efficiency and accuracy of information processing based on the structured query language.

[0178] Figure 6 The illustration shows an example of a process for determining second annotation information based on position information corresponding to at least one target statement and target object information corresponding to at least one target object, according to an embodiment of the present disclosure.

[0179] like Figure 6 As shown, in 600, in response to receiving information processing instruction 601, information to be processed 602 can be obtained according to information processing instruction 601. Information to be processed 602 may include at least one target object 602_1 and at least one target statement 602_2.

[0180] Based on at least one target object 602_1, determine a first natural language template 604 corresponding to each of the at least one target object 602_1. Fill the first natural language template 604 corresponding to each of the at least one target object 602_1 with the target object information 605 corresponding to each of the at least one target object 602_1 to obtain second annotation information 606 corresponding to the first natural language template.

[0181] At least one target statement 602_2 is processed to obtain position information 603 corresponding to the target statement. Based on the position information 603 corresponding to the target statement, at least one second natural language template 607 is determined. Based on the position information 603 corresponding to the target statement, the second annotation information 606 corresponding to the first natural language template is filled into at least one second natural language template 607 to obtain second annotation information 608 corresponding to the second natural language template.

[0182] According to embodiments of this disclosure, the information processing method 200 described above may further include the following operations.

[0183] The first annotation information is displayed in the first target area of ​​the target page, where the target page represents the page that received the information processing instruction. The second annotation information is displayed in the second target area of ​​the target page.

[0184] According to embodiments of this disclosure, the positional relationship between the first target region and the second target region can satisfy a predetermined positional relationship condition.

[0185] According to embodiments of this disclosure, a target page can represent a page that receives information processing instructions. The target page may include a first target area and a second target area. The first target area may represent an area displaying first annotation information. The second target area may represent an area displaying second annotation information.

[0186] According to embodiments of this disclosure, after obtaining the first annotation information, the first annotation information can be displayed in a first target area of ​​the target page. After obtaining the second annotation information, the second annotation information can be displayed in a second target area of ​​the target page. Based on this, users can obtain the first and second annotation information on the target page for reference.

[0187] According to embodiments of this disclosure, the predetermined positional relationship conditions can be set by those skilled in the art according to actual needs, and are not limited herein. For example, the predetermined positional relationship condition can be a predetermined distance between the first target area and the second target area, and the predetermined distance can be 1 cm.

[0188] According to embodiments of this disclosure, by displaying the first annotation information in a first target area of ​​the target page and the second annotation information in a second target area of ​​the target page, the output of the first annotation information and the second annotation information is realized, thereby improving the efficiency of data analysis using structured query language.

[0189] The above are merely exemplary embodiments, but are not limited thereto. Other information processing methods known in the art may also be included, as long as they can improve the efficiency and accuracy of information processing based on structured query language.

[0190] Figure 7 A block diagram of an information processing apparatus according to an embodiment of the present disclosure is shown schematically.

[0191] like Figure 7 As shown, the information processing device 700 may include an acquisition module 701, a first processing module 702, a second processing module 703, and a determination module 704.

[0192] The acquisition module 701 is used to acquire information to be processed in response to receiving an information processing instruction, wherein the information to be processed includes at least one target statement and at least one target object, and the information to be processed belongs to a structured query language.

[0193] The first processing module 702 is used to process at least one target statement to obtain position information corresponding to each of the at least one target statement, wherein the position information corresponding to each of the at least one target statement is used to characterize the hierarchical relationship between the at least one target statement and each other.

[0194] The second processing module 703 is used to process at least one target object to obtain first annotation information, wherein the first annotation information includes target object information corresponding to each of the at least one target object.

[0195] The determination module 704 is used to determine the second annotation information based on the position information corresponding to at least one target statement and the target object information corresponding to at least one target object.

[0196] According to embodiments of this disclosure, the target statement includes at least one of the following: a target function statement and a target command statement.

[0197] According to embodiments of this disclosure, the first processing module 702 may include a first matching unit, a first determining unit, a second matching unit, and a second determining unit.

[0198] The first matching unit is used to match the preset function statement and the information to be processed when at least one target statement includes a target function statement, to obtain first matching information, wherein the first matching information is used to characterize the correspondence between the target function statement and the target preset function statement.

[0199] The first determining unit is used to determine the position information corresponding to the target function statement based on the first matching information.

[0200] The second matching unit is used to match the preset command statement and the information to be processed when at least one target statement includes a target command statement, to obtain second matching information, wherein the second matching information is used to characterize the correspondence between the target command statement and the target preset command statement.

[0201] The second determining unit is used to determine the position information corresponding to the target command statement based on the second matching information.

[0202] According to embodiments of this disclosure, the first processing module 702 may further include a first configuration unit and a second configuration unit.

[0203] The first configuration unit is used to configure the target function statement with a first preset color according to the position information corresponding to the target function statement.

[0204] The second configuration unit is used to configure the target command statement with a second preset color according to the position information corresponding to the target command statement.

[0205] According to embodiments of this disclosure, the target object includes at least one of the following: a target table object, a target field object, and a target dictionary object.

[0206] According to embodiments of this disclosure, the first annotation information includes at least one of the following: table object annotation information, field object annotation information, and dictionary object annotation information.

[0207] According to embodiments of this disclosure, the second processing module 703 may include a third determining unit, a fourth determining unit, and a fifth determining unit.

[0208] The third determining unit is used to determine the table object annotation information corresponding to the target table object according to the first mapping relationship when at least one target object includes a target table object.

[0209] The fourth determining unit is used to determine the field object annotation information corresponding to the target field object according to the second mapping relationship when at least one target object includes a target field object.

[0210] The fifth determining unit is used to determine the dictionary object annotation information corresponding to the target dictionary object based on the third mapping relationship, when at least one target object includes a target dictionary object.

[0211] According to embodiments of this disclosure, the first mapping relationship includes at least one first key-value pair, which is determined based on at least one preset table object and table object information corresponding to each of the at least one preset table object.

[0212] According to embodiments of this disclosure, the second mapping relationship includes at least one second key-value pair, which is determined based on at least one preset field object and field object information corresponding to each of the at least one preset field object.

[0213] According to embodiments of this disclosure, the third mapping relationship includes at least one third key-value pair, which is determined based on at least one preset dictionary object and dictionary object information corresponding to each of the at least one preset dictionary object.

[0214] According to embodiments of this disclosure, the second annotation information is in natural language.

[0215] According to embodiments of this disclosure, the determining module 704 may include a sixth determining unit and a filling unit.

[0216] The sixth determining unit is used to determine a natural language template based on the position information corresponding to at least one target statement and the target object information corresponding to at least one target object.

[0217] The filling unit is used to fill the natural language template with the position information corresponding to at least one target statement and the target object information corresponding to at least one target object to obtain the second annotation information.

[0218] According to embodiments of this disclosure, the natural language template includes at least one of the following: a first natural language template and a second natural language template.

[0219] According to embodiments of this disclosure, the sixth determining unit may include a first determining subunit and a second determining subunit.

[0220] The first determining subunit is used to determine a first natural language template corresponding to each of the at least one target object.

[0221] The second determining subunit is used to determine at least one second natural language template based on the position information corresponding to each of the at least one target statement.

[0222] According to embodiments of this disclosure, the filling unit may include a first filling subunit and a second filling subunit.

[0223] The first filling sub-unit is used to fill the target object information corresponding to at least one target object into the first natural language template corresponding to at least one target object, so as to obtain the second annotation information corresponding to the first natural language template.

[0224] The second filling subunit is used to fill the second annotation information corresponding to the first natural language template into the second natural language template corresponding to the at least one target object according to the position information corresponding to each of the at least one target statement, so as to obtain the second annotation information corresponding to the second natural language template.

[0225] According to embodiments of this disclosure, the information processing device 700 may further include a first display module and a second display module.

[0226] The first display module is used to display the first annotation information in the first target area of ​​the target page, wherein the target page represents the page that receives the information processing instruction.

[0227] The second display module is used to display the second annotation information in the second target area of ​​the target page.

[0228] According to embodiments of this disclosure, the positional relationship between the first target area and the second target area satisfies a predetermined positional relationship condition.

[0229] According to embodiments of this disclosure, the acquisition module 701 may include a seventh determining unit, a first acquisition unit, and a parsing unit.

[0230] The seventh determining unit is used to determine the information type in response to receiving an information processing instruction, wherein the information type is used to characterize the input type of the original information to be processed.

[0231] The first acquisition unit is used to acquire the original information to be processed based on the information type of the original information to be processed.

[0232] The parsing unit is used to parse the original information to be processed to obtain at least one target statement and at least one target object from the information to be processed.

[0233] According to embodiments of this disclosure, the information type includes at least one of the following: text type and image type.

[0234] According to embodiments of this disclosure, the first acquisition unit may include a first acquisition subunit, a second acquisition subunit, and a processing subunit.

[0235] The first acquisition subunit is used to acquire the original information to be processed when the information type characterization indicates that the original information to be processed belongs to the text type.

[0236] The second acquisition subunit is used to acquire the image to be processed when the information type characterization indicates that the original information to be processed belongs to the image type, wherein the image to be processed includes the original information to be processed.

[0237] The processing subunit is used to perform image recognition processing on the image to be processed to obtain the original information to be processed.

[0238] Any one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure, or at least part of the functions of any one or more of them, can be implemented in one module. Any one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure can be implemented by dividing them into multiple modules. Any one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure can be at least partially implemented as hardware circuitry, such as Field Programmable Gate Arrays (FPGAs), Programmable Logic Arrays (PLAs), Systems-on-Chip, Systems-on-Substrate, Systems-on-Package, Application-Specific Integrated Circuits (ASICs), or implemented in hardware or firmware by any other reasonable means of integrating or packaging circuitry, or implemented in software, hardware, or firmware, or in any suitable combination of any of these three implementation methods. Alternatively, one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure can be at least partially implemented as computer program modules, which, when run, can perform corresponding functions.

[0239] For example, any plurality of the acquisition module 701, the first processing module 702, the second processing module 703, and the determination module 704 can be combined into one module / unit / subunit, or any one of these modules / units / subunits can be split into multiple modules / units / subunits. Alternatively, at least part of the functionality of one or more of these modules / units / subunits can be combined with at least part of the functionality of other modules / units / subunits and implemented in one module / unit / subunit. According to embodiments of this disclosure, at least one of the acquisition module 701, the first processing module 702, the second processing module 703, and the determination module 704 can be at least partially implemented 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-package, an application-specific integrated circuit (ASIC), or implemented in hardware or firmware by any other reasonable means of integrating or packaging the circuitry, or implemented in software, hardware, or firmware, or in any suitable combination of any of these three implementation methods. Alternatively, at least one of the acquisition module 701, the first processing module 702, the second processing module 703, and the determination module 704 may be implemented at least partially as a computer program module, which can perform corresponding functions when the computer program module is run.

[0240] It should be noted that the information processing device part in the embodiments of this disclosure corresponds to the information processing method part in the embodiments of this disclosure. The description of the information processing device part is specifically referred to in the information processing method part, and will not be repeated here.

[0241] Figure 8 A block diagram of an electronic device suitable for implementing an information processing method according to an embodiment of the present disclosure is shown schematically. Figure 8 The electronic device shown is merely an example and should not be construed as limiting the functionality and scope of the embodiments disclosed herein.

[0242] like Figure 8 As shown, a computer electronic device 800 according to an embodiment of the present disclosure includes a processor 801, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 802 or a program loaded from a storage portion 809 into a random access memory (RAM) 803. The processor 801 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)), etc. The processor 801 may also include onboard memory for caching purposes. The processor 801 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.

[0243] RAM 803 stores various programs and data required for the operation of electronic device 800. Processor 801, ROM 802, and RAM 803 are interconnected via bus 804. Processor 801 performs various operations of the method flow according to embodiments of the present disclosure by executing programs in ROM 802 and / or RAM 803. It should be noted that the programs may also be stored in one or more memories other than ROM 802 and RAM 803. Processor 801 may also perform various operations of the method flow according to embodiments of the present disclosure by executing programs stored in said one or more memories.

[0244] According to embodiments of this disclosure, the electronic device 800 may further include an input / output (I / O) interface 805, which is also connected to a bus 804. The electronic device 800 may also include one or more of the following components connected to the I / O interface 805: an input section 806 including a keyboard, mouse, etc.; an output section 807 including a cathode ray tube (CRT), liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 808 including a hard disk, etc.; and a communication section 809 including a network interface card such as a LAN card, modem, etc. The communication section 809 performs communication processing via a network such as the Internet. A drive 810 is also connected to the I / O interface 805 as needed. A removable medium 811, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., is installed on the drive 810 as needed so that computer programs read from it can be installed into the storage section 808 as needed.

[0245] According to embodiments of this disclosure, the method flow according to embodiments of this disclosure can be implemented as a computer software program. For example, embodiments of this disclosure include a computer program product comprising a computer program carried on a computer-readable storage medium, the computer program containing program code for performing the methods shown in the flowchart. In such embodiments, the computer program can be downloaded and installed from a network via communication section 809, and / or installed from removable medium 811. When the computer program is executed by processor 801, it performs the functions defined in the system of embodiments of this disclosure. According to embodiments of this disclosure, the systems, devices, apparatuses, modules, units, etc., described above can be implemented by computer program modules.

[0246] This disclosure also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiments; or it may exist independently and not assembled into the device / apparatus / system. The computer-readable storage medium carries one or more programs that, when executed, implement the method according to the embodiments of this disclosure.

[0247] According to embodiments of this disclosure, the computer-readable storage medium can be a non-volatile computer-readable storage medium. Examples include, but are not limited to: portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof. In this disclosure, the computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

[0248] For example, according to embodiments of this disclosure, a computer-readable storage medium may include the ROM 802 and / or RAM 803 described above and / or one or more memories other than ROM 802 and RAM 803.

[0249] Embodiments of this disclosure also include a computer program product comprising a computer program containing program code for performing the methods provided in the embodiments of this disclosure. When the computer program product is run on an electronic device, the program code is used to enable the electronic device to implement the information processing methods provided in the embodiments of this disclosure.

[0250] When the computer program is executed by the processor 801, it performs the functions defined in the system / apparatus of this disclosure embodiments. According to embodiments of this disclosure, the systems, apparatuses, modules, units, etc., described above can be implemented by computer program modules.

[0251] In one embodiment, the computer program may rely on a tangible storage medium such as an optical storage device or a magnetic storage device. In another embodiment, the computer program may also be transmitted and distributed in the form of signals over a network medium, and may be downloaded and installed via the communication section 809, and / or installed from a removable medium 811. The program code contained in the computer program can be transmitted using any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination thereof.

[0252] According to embodiments of this disclosure, program code for executing the computer programs provided in embodiments of this disclosure can be written in any combination of one or more programming languages. Specifically, these computational programs can be implemented using high-level procedural and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, languages ​​such as Java, C++, Python, "C", or similar programming languages. The program code can execute entirely on the user's computing device, partially on the user's device, partially on a remote computing device, or entirely on a remote computing device or server. In cases involving remote computing devices, the remote computing device can be connected to the user's computing device via any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computing device (e.g., via the Internet using an Internet service provider).

[0253] The flowcharts and block diagrams in the accompanying drawings 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 a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram or flowchart, and combinations of blocks in a block diagram or flowchart, may be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions. Those skilled in the art will understand that the features recited in the various embodiments and / or claims of this disclosure can be combined and / or combined in various ways, even if such combinations or combinations are not expressly described in this disclosure. In particular, the features described in the various embodiments and / or claims of this disclosure may be combined and / or combined in various ways without departing from the spirit and teachings of this disclosure. All such combinations and / or combinations fall within the scope of this disclosure.

[0254] The embodiments of this disclosure have been described above. However, these embodiments are for illustrative purposes only and are not intended to limit the scope of this disclosure. Although various embodiments have been described above, this does not mean that the measures in the various embodiments cannot be used advantageously in combination. The scope of this disclosure is defined by the appended claims and their equivalents. Various substitutions and modifications can be made by those skilled in the art without departing from the scope of this disclosure, and all such substitutions and modifications should fall within the scope of this disclosure.

Claims

1. An information processing method, comprising: In response to receiving an information processing instruction, information to be processed is obtained according to the information processing instruction, wherein the information to be processed includes at least one target statement and at least one target object, and the information to be processed belongs to a structured query language; The at least one target statement is processed to obtain position information corresponding to each of the at least one target statement, wherein the position information corresponding to each of the at least one target statement is used to characterize the hierarchical relationship between the at least one target statement and each other; The at least one target object is processed to obtain first annotation information, wherein the first annotation information includes target object information corresponding to each of the at least one target object; and a first natural language template corresponding to each of the at least one target object is determined based on the at least one target object. Based on the position information corresponding to each of the at least one target statement, at least one second natural language template is determined; The target object information corresponding to each of the at least one target object is filled into the first natural language template corresponding to each of the at least one target object to obtain the second annotation information corresponding to the first natural language template; and Based on the position information corresponding to each of the at least one target statement, the second annotation information corresponding to the first natural language template is filled into the second natural language template corresponding to each of the at least one target object to obtain the second annotation information corresponding to the second natural language template, wherein the second annotation information belongs to natural language.

2. The method according to claim 1, wherein, The target statement includes at least one of the following: a target function statement and a target command statement; The step of processing the at least one target statement to obtain the position information corresponding to each of the at least one target statement includes: When the at least one target statement includes the target function statement, the preset function statement and the information to be processed are matched to obtain first matching information, wherein the first matching information is used to characterize the correspondence between the target function statement and the target preset function statement; Based on the first matching information, determine the position information corresponding to the target function statement; When at least one target statement includes the target command statement, the preset command statement and the information to be processed are matched to obtain second matching information, wherein the second matching information is used to characterize the correspondence between the target command statement and the target preset command statement; and Based on the second matching information, the location information corresponding to the target command statement is determined.

3. The method according to claim 2, further comprising: Based on the position information corresponding to the target function statement, the target function statement is configured with a first preset color; as well as Based on the position information corresponding to the target command statement, the target command statement is configured with a second preset color.

4. The method according to claim 1, wherein, The target object includes at least one of the following: a target table object, a target field object, and a target dictionary object; The first annotation information includes at least one of the following: table object annotation information, field object annotation information, and dictionary object annotation information; The step of processing the at least one target object to obtain the first annotation information includes: When the at least one target object includes the target table object, the table object annotation information corresponding to the target table object is determined according to the first mapping relationship; When the at least one target object includes the target field object, the field object annotation information corresponding to the target field object is determined according to the second mapping relationship; and When the at least one target object includes the target dictionary object, the dictionary object annotation information corresponding to the target dictionary object is determined according to the third mapping relationship.

5. The method according to claim 4, wherein, The first mapping relationship includes at least one first key-value pair, which is determined based on at least one preset table object and table object information corresponding to each of the at least one preset table object; The second mapping relationship includes at least one second key-value pair, which is determined based on at least one preset field object and field object information corresponding to each of the at least one preset field object; and The third mapping relationship includes at least one third key-value pair, which is determined based on at least one preset dictionary object and dictionary object information corresponding to each of the at least one preset dictionary object.

6. The method according to claim 1, further comprising, after determining the second annotation information based on the position information corresponding to each of the at least one target statement and the target object information corresponding to each of the at least one target object: The first annotation information is displayed in the first target area of ​​the target page, wherein... The target page represents the page that receives the information processing instruction; as well as The second annotation information is displayed in the second target area of ​​the target page; The positional relationship between the first target area and the second target area satisfies a predetermined positional relationship condition.

7. The method according to claim 1, wherein, The step of responding to receiving an information processing instruction and obtaining the information to be processed according to the information processing instruction includes: In response to receiving the information processing instruction, the information type is determined according to the information processing instruction, wherein the information type is used to characterize the input type of the original information to be processed; Based on the information type of the original information to be processed, obtain the original information to be processed; and The original information to be processed is parsed to obtain at least one target statement and at least one target object in the information to be processed.

8. The method according to claim 7, wherein, The information type includes at least one of the following: text type and image type; The step of obtaining the original information to be processed based on its information type includes one of the following methods: If the information type indicates that the original information to be processed belongs to the text type, then the original information to be processed is obtained; If the information type indicates that the original information to be processed belongs to the image type, then an image to be processed is obtained, wherein the image to be processed includes the original information to be processed; and The image to be processed is subjected to image recognition processing to obtain the original information to be processed.

9. An information processing apparatus, comprising: The acquisition module is used to respond to receiving an information processing instruction and acquire information to be processed according to the information processing instruction, wherein the information to be processed includes at least one target statement and at least one target object, and the information to be processed belongs to a structured query language; The first processing module is used to process the at least one target statement to obtain position information corresponding to each of the at least one target statement, wherein the position information corresponding to each of the at least one target statement is used to characterize the hierarchical relationship between the at least one target statement and each other. The second processing module is used to process the at least one target object to obtain first annotation information, wherein the first annotation information includes target object information corresponding to each of the at least one target object; The first determining subunit is used to determine a first natural language template corresponding to each of the at least one target object, based on the at least one target object. The second determining subunit is used to determine at least one second natural language template based on the position information corresponding to each of the at least one target statement; The first filling subunit is used to fill the target object information corresponding to each of the at least one target object into the first natural language template corresponding to each of the at least one target object, thereby obtaining second annotation information corresponding to the first natural language template; and The second filling subunit is used to fill the second annotation information corresponding to the first natural language template into the second natural language template corresponding to the at least one target object according to the position information corresponding to each of the at least one target statement, so as to obtain the second annotation information corresponding to the second natural language template, wherein the second annotation information belongs to natural language.

10. An electronic device, comprising: One or more processors; Memory, used to store one or more instructions. When the one or more instructions are executed by the one or more processors, the one or more processors cause the one or more processors to implement the method of any one of claims 1 to 8.

11. A computer-readable storage medium having executable instructions stored thereon, which, when executed by a processor, cause the processor to perform the method of any one of claims 1 to 8.

12. A computer program product comprising computer-executable instructions, which, when executed, are used to implement the method of any one of claims 1 to 8.

Images