Data configuration method, device and equipment for big data structured query language

Abstract

The present disclosure relates to a data configuration method, device and equipment for big data structured query language, to realize the visual configuration of parameters in SQL statements, reduce the configuration difficulty and improve the development efficiency. The method comprises the following steps: displaying a configuration interface for a structured query language (SQL) statement, wherein the configuration interface displays a target SQL statement in code form; in response to a parsing operation on the target SQL statement, displaying a configurable parameter in the target SQL statement obtained by the parsing operation; in response to a first configuration operation on a first target parameter in the configurable parameter, determining parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation.

Description

TECHNICAL FIELD

[0001] The present disclosure relates to the technical field of computer, and in particular, to a data configuration method, device and equipment for big data structured query language. BACKGROUND

[0002] In the development process of big data SQL (Structured Query Language), the parameters in the SQL statement need to be assigned values to achieve the corresponding functional requirements.

[0003] In the related art, whether in the SQL development stage or the later maintenance stage, the SQL statement in the form of code is usually configured directly, which is not only difficult to configure and prone to errors, but also low in development efficiency. SUMMARY

[0004] This summary is provided to introduce a selection of concepts that are further described below in the detailed description. This summary is not intended to identify key or essential features of the claimed subject matter, nor is it used to limit the scope of the claimed subject matter's scope.

[0005] In a first aspect, the present disclosure provides a data configuration method for big data structured query language, the method comprising:

[0006] displaying a configuration interface for a structured query language (SQL) statement, the configuration interface displaying a target SQL statement in the form of code;

[0007] in response to a parsing operation on the target SQL statement, displaying configurable parameters in the target SQL statement obtained by the parsing operation;

[0008] in response to a first configuration operation on a first target parameter in the configurable parameters, determining parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation.

[0009] In a second aspect, the present disclosure provides a data configuration device for big data structured query language, the device comprising:

[0010] a display module configured to display a configuration interface for a structured query language (SQL) statement, the configuration interface displaying a target SQL statement in the form of code;

[0011] a parsing module configured to, in response to a parsing operation on the target SQL statement, display configurable parameters in the target SQL statement obtained by the parsing operation;

[0012] The configuration module is configured to, in response to a first configuration operation on a first target parameter in the configurable parameters, determine parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation.

[0013] In a third aspect, the present disclosure provides a computer readable medium having stored thereon a computer program which, when executed by a processing apparatus, implements the steps of the method of any one of the first aspect.

[0014] In a fourth aspect, the present disclosure provides an electronic device comprising:

[0015] a storage device having stored thereon a computer program;

[0016] a processing apparatus configured to execute the computer program stored in the storage device to implement the steps of the method of any one of the first aspect.

[0017] By the above technical solution, first, a configuration interface for a structured query language (SQL) statement is displayed, then, in response to a parsing operation on a target SQL statement, configurable parameters in the target SQL statement obtained by the parsing operation are displayed, and finally, in response to a first configuration operation on a first target parameter in the configurable parameters, parameter information of the first target parameter in the target SQL statement is determined according to configuration information corresponding to the first configuration operation. Thus, by parsing the SQL statement in code form, the configurable parameters are obtained and visually displayed, and then the parameter information of the parameters in the SQL statement can be determined by configuring the configurable parameters, thereby realizing visual configuration of the SQL statement. Not only is it convenient for a user to configure the parameters and improves the accuracy of parameter configuration, but also the parameters can be displayed in a visual manner in both the SQL development stage and the later maintenance stage, thereby reducing the configuration difficulty, improving the development efficiency, and reducing the development or maintenance cost.

[0018] Other features and advantages of the present disclosure will be described in detail in the following detailed description section. BRIEF DESCRIPTION OF DRAWINGS

[0019] The above and other features, advantages, and aspects of the embodiments of the present disclosure will become more apparent by describing in detail exemplary embodiments thereof with reference to the attached drawings in which:

[0020] Figure 1 is a flowchart of a data configuration method for a big data structured query language according to an exemplary embodiment;

[0021] Figure 2is a schematic diagram of a configuration interface according to an exemplary embodiment;

[0022] Figure 3 is a schematic diagram of a first display area according to an exemplary embodiment;

[0023] Figure 4 is a schematic diagram of a first display area according to an exemplary embodiment;

[0024] Figure 5 is a schematic diagram of a display form of a configurable parameter according to an exemplary embodiment;

[0025] Figure 6 is a schematic diagram of a parsing control according to an exemplary embodiment;

[0026] Figure 7 is a schematic diagram of a positioning control according to an exemplary embodiment;

[0027] Figure 8 is a schematic diagram of an adding control and a deleting control according to an exemplary embodiment;

[0028] Figure 9 is a schematic diagram of a data configuration device for a big data structured query language according to an exemplary embodiment;

[0029] Figure 10 is a block diagram of an electronic device according to an exemplary embodiment. DETAILED DESCRIPTION

[0030] Embodiments of the present disclosure will be described more fully hereinafter with reference to the accompanying drawings, in which some, but not all embodiments of the present disclosure are shown. As those skilled in the art would realize, the present disclosure can be carried out in many different forms and should not be considered limited to the embodiments set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and fully convey the scope of the present disclosure to those skilled in the art. As such, the drawings and the embodiments described herein are to be regarded as illustrative in nature, and not as restrictive.

[0031] It should be understood that the various steps of the method embodiments of the present disclosure can be performed in different orders, and / or in parallel. In addition, the method embodiments can include additional steps and / or omit performing the steps shown. The scope of the present disclosure is not limited in this regard.

[0032] The term "include" and variations thereof, as used in this document, mean "to include, without limitation." The term "based on" means "based at least in part on." The term "one embodiment" means "at least one embodiment." The term "another embodiment" means "at least one additional embodiment." The term "some embodiments" means "at least some embodiments." Related terms shall be construed accordingly. Other definitions will be apparent from the description that follows.

[0033] It should be noted that the terms "first", "second", etc. mentioned in the disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0034] It should be noted that the modification of "one" or "multiple" mentioned in the disclosure is illustrative and not restrictive, and those skilled in the art should understand that unless otherwise explicitly indicated in the context, it should be understood as "one or more".

[0035] The names of the messages or information exchanged between the plurality of devices in the embodiments of the disclosure are only for illustrative purposes, and are not used to limit the scope of the messages or information.

[0036] In the development process of big data SQL (Structured Query Language, structured query language), the parameters in the SQL statement need to be assigned values to achieve the corresponding functional requirements. For example, in the scenario of splicing and inserting SQL statements, the parameters in the spliced and inserted SQL statements need to be assigned values to achieve the corresponding functional requirements.

[0037] In the related art, the configuration of the interpolation parameter is not visualized, but is directly configured to the SQL statement in the form of code, which has great configuration difficulty, low efficiency, is easy to make mistakes, and has high development and maintenance cost. And for the parameters that need to be assigned values in the SQL statement, since the automatic analysis is not implemented, the developer can only manually add the parameters and then configure them, which has high operation cost and is easy to make mistakes.

[0038] Therefore, the embodiments of the disclosure provide a data configuration method, device and equipment for big data structured query language to solve the above problems.

[0039] The embodiments of the disclosure will be further explained and described below with reference to the accompanying drawings.

[0040] Figure 1 is a flowchart of a data configuration method for big data structured query language according to an exemplary embodiment of the disclosure. Referring to Figure 1 The method comprises:

[0041] S101: display a configuration interface for a structured query language (SQL) statement.

[0042] The configuration interface displays the target SQL statement in a code form.

[0043] S102: in response to a parsing operation on the target SQL statement, display a configurable parameter in the target SQL statement obtained by the parsing operation.

[0044] In a possible manner, the configuration interface includes a first display area and a second display area, the first display area is configured to display the target SQL statement in the code form, and the second display area is configured to allow a user to visually configure the configurable parameter. In response to the parsing operation on the target SQL statement, the display of the configurable parameter in the target SQL statement obtained by the parsing operation can include: in response to the parsing operation on the target SQL statement, displaying the configurable parameter in the target SQL statement obtained by the parsing operation in the second display area.

[0045] For example, referring to Figure 2 , the first display area is configured to display the target SQL statement in the code form, and the second display area is configured to display the configurable parameter in the target SQL statement obtained by the parsing operation, so as to allow the user to visually configure the configurable parameter. Not only can the editing operation on the target SQL statement in the code form be taken into account, but also the configurable parameter can be intuitively displayed to the user, thereby facilitating the subsequent configuration operation on the parameter.

[0046] It should be understood that, in addition to the left-right distribution as shown in Figure 2 , the first display area and the second display area in the configuration interface can also be distributed in a top-bottom manner, the second display area can be displayed in a pop-up box form on the upper layer of the first display area, and the like, and the present disclosure does not limit this. In order to facilitate unified description, the present disclosure will be described in the embodiment with the distribution manner as shown in Figure 2 .

[0047] In a possible manner, the method further includes: in response to the parsing operation on the target SQL statement, determining a code position of the configurable parameter in the target SQL statement, and displaying the configurable parameter obtained by the parsing operation at a preset position around the code position in the first display area.

[0048] For example, referring to Figure 3After the target SQL statement is parsed to obtain the configurable parameters, the configurable parameters can be displayed at a preset position around the code position corresponding to the configurable parameters in the target SQL statement. The preset position can be determined according to requirements, for example, the configurable parameters can be displayed at a position below the code line corresponding to the configurable parameters, or a position above the code line, and the present disclosure does not limit this. In this way, the user can quickly understand the configurable parameters existing in the code, and the development efficiency is improved.

[0049] In a possible manner, the method further includes: in response to a selection operation of a second target parameter in the configurable parameters in the first display area, expanding and displaying a configuration input control for the second target parameter; and in response to an input operation of the configuration input control, determining parameter information of the second target parameter in the target SQL statement according to input information corresponding to the input operation, and / or synchronously updating the parameter information of the second target parameter displayed in the second display area according to the input information corresponding to the input operation.

[0050] For example, referring to Figure 4 In response to a selection operation of the configurable parameter "a_id" in the first display area, a configuration input control for "a_id" is expanded and displayed. The configuration input control can be in the form of an input box, a drop-down selection box, etc., and the present disclosure does not limit this. The parameter information of "a_id" in the SQL statement in the code can be modified according to the input operation of the user on the configuration input control, for example, the parameter value is modified from "101" to "10111".

[0051] It is worth noting that through the interpolation syntax of SQL, the code position of the interpolation parameter (configurable parameter) in the SQL statement can be determined, and then the configurable parameter is displayed at the preset position and the configuration input control is displayed at the corresponding position, which facilitates the user to quickly configure the parameter during the SQL editing process and improves the development efficiency.

[0052] For example, the parameter information of "a_id" displayed in the second display area can also be synchronously updated according to the input information corresponding to the input operation, for example, the parameter value is modified from "101" to "10111". In this way, not only can the configurable parameter be visually configured when the user edits the code using the first display area, thereby reducing the configuration difficulty and improving the development efficiency, but also the parameter information of the corresponding parameter in the second display area can be synchronously modified, thereby facilitating the user to continue the visual configuration of the parameter in the second display area.

[0053] S103: In response to a first configuration operation of a first target parameter in the configurable parameters, parameter information of the first target parameter in the target SQL statement is determined according to configuration information corresponding to the first configuration operation.

[0054] In a possible implementation, the displaying the configurable parameters in the target SQL statement obtained by the parsing operation on the target SQL statement in response to the parsing operation on the target SQL statement can include: in response to the parsing operation on the target SQL statement, displaying at least one of the following information of the configurable parameters in the target SQL statement obtained by the parsing operation: a parameter name, an assignment result, and a parameter type. In response to the first configuration operation on the first target parameter in the configurable parameters, determining the parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation can include: in response to the first configuration operation on the assignment result and / or the parameter type of the first target parameter in the configurable parameters, determining the parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation.

[0055] For example, continuing to refer to Figure 2 In response to the parsing operation on the target SQL statement, at least one of the following information of the configurable parameters can be displayed: a parameter name, an assignment result (a parameter value), and a parameter type. Accordingly, the parameter value or the parameter type of the configurable parameters can be configured, and the parameter information of the corresponding parameter in the SQL statement in the code can be determined according to configuration information corresponding to the first configuration operation, which is equivalent to synchronously modifying the parameter in the SQL statement in the code, realizing visual parameter configuration, and improving development efficiency.

[0056] By using the above method, the configurable parameters are obtained by parsing the SQL statement in the code form and are visually displayed, and then the parameter information of the parameters in the SQL statement can be determined by configuring the configurable parameters, realizing visual configuration of the SQL statement. Not only is it convenient for users to configure the parameters and improve the accuracy of parameter configuration, but also the parameters can be displayed in a visual manner in the SQL development stage or the later maintenance stage, reducing the configuration difficulty, improving the development efficiency, and reducing the development or maintenance cost.

[0057] In a possible implementation, the displaying the configurable parameters in the target SQL statement obtained by the parsing operation on the target SQL statement in response to the parsing operation on the target SQL statement can include: in response to the parsing operation on the target SQL statement, displaying the configurable parameters in the target SQL statement obtained by the parsing operation in the form of a table or in the form of a key-value pair.

[0058] For example, referring to Figure 5 The configurable parameters can be displayed in the form of a table or in the form of a key-value pair, where the form of a key-value pair can be implemented by code, for example, code in JSON format, which can be set according to requirements, and the present disclosure does not limit this. Thus, the configuration requirements and configuration habits of different users can be met.

[0059] It should be understood that, relative to the SQL statement in the form of code, even if the form of key-value pair is realized by code, the amount of code is greatly reduced, and therefore the parameter information of the configurable parameter can be intuitively embodied, facilitating user operation. Taking the configurable parameter "a_id" as an example, for the parameter name in the parameter information, the key is "parameter name" and the value is "a_id", for the parameter value in the parameter information, the key is "parameter value" and the value is "101", and for the parameter type in the parameter information, the key is "parameter type" and the value is "int".

[0060] In a possible manner, the configurable parameters in the target SQL statement obtained by the parsing operation can be displayed in the form of a form or a key-value pair, which can include: in response to a trigger operation of a preset form option in the configuration interface, the configurable parameters in the target SQL statement obtained by the parsing operation are displayed in the form of a form; or, in response to a trigger operation of a preset key-value pair option in the configuration interface, the configurable parameters in the target SQL statement obtained by the parsing operation are displayed in the form of a key-value pair.

[0061] For example, continuing to refer to Figure 5 An option control can be provided for a user to select the display form of the configurable parameter, such as a "form" control corresponding to a preset form option and a "JSON" control corresponding to a preset key-value pair option, and the user can click the corresponding control to switch the display form of the configurable parameter. Alternatively, a configuration item can also be provided to configure the display form of the configurable parameter, such as a configuration item corresponding to the form and the key-value pair in a setting menu in the menu bar of the configuration interface, and the user can set the configuration item, and the like, and the present disclosure does not limit this. In this way, the user can arbitrarily switch the display form of the configurable parameter to meet different configuration needs of the user.

[0062] In a possible manner, in response to the parsing operation of the target SQL statement, the configurable parameters in the target SQL statement obtained by the parsing operation can be displayed, which can include: in response to a trigger operation of a first parsing control in the configuration interface, all the configurable parameters in the target SQL statement are displayed; or, in response to a trigger operation of a second parsing control in the configuration interface, a parsing selection interface is displayed, and in response to a first SQL statement selected in the parsing selection interface, the configurable parameters in the first SQL statement are displayed; or, when a second SQL statement in the target SQL statement is in a selected state, in response to a parsing operation of the second SQL statement, the configurable parameters in the second SQL statement obtained by the parsing operation are displayed.

[0063] For example, referring to Figure 6The resolving control can be displayed in the configuration interface for the user to select a corresponding resolving mode. For example, the user can click the control "resolve all" to resolve all the SQL statements in the configuration interface and display all the configurable parameters in the SQL statements. Alternatively, the user can click the control "resolve part" to display a resolving selection interface, which includes all the SQL statements in the configuration interface. The user can select the SQL statements to be resolved to obtain the configurable parameters of the selected SQL statements.

[0064] For example, the user can also directly perform a selection operation on the SQL statements displayed in the configuration interface, for example, select part or all of the SQL statements, and then pop up an operation menu by right-clicking to select the resolving function to resolve the selected part or all of the SQL statements to obtain the configurable parameters. In addition, the user can resolve the selected part or all of the SQL statements by using a shortcut key, and the present disclosure does not limit this.

[0065] For example, when selecting the resolving, the user can also select a display form of the configurable parameters, for example, by right-clicking to pop up an operation menu, selecting the resolving function, and then displaying selection items of "form" and "JSON", and the present disclosure does not limit this.

[0066] In this way, the user can select part or all of the SQL statements to be resolved in response to the operation of the user, meet the configuration requirements of the user in different application scenarios, and achieve flexible and visual parameter configuration.

[0067] In a possible manner, the method further includes: in response to a triggering operation on a positioning control corresponding to a first target parameter, positioning to a code line where the first target parameter is located in the target SQL statement and highlighting the first target parameter.

[0068] For example, a corresponding positioning control can be set for each configurable parameter, as shown in the black circular control, and then the user can click the positioning control to position to a code line where the configurable parameter corresponding to the positioning control is located in the SQL statement. Alternatively, the user can select a configurable parameter, right-click to pop up an operation menu, and select a positioning function to position the selected configurable parameter, and the present disclosure does not limit this. Figure 7 For example, in response to a triggering operation on a positioning control corresponding to a first target parameter, the first target parameter is positioned to a code line where the first target parameter is located in the target SQL statement and the first target parameter is highlighted, as shown in

[0069] Figure 7 For example, in response to a triggering operation on a positioning control corresponding to a first target parameter, the first target parameter is positioned to a code line where the first target parameter is located in the target SQL statement and the first target parameter is highlighted, as shown in

[0070] ​In a possible implementation, the method further includes: in response to a triggering operation of the adding control in the configuration interface, displaying a blank new parameter row, the new parameter row being used for the user to configure a configurable parameter to be added in the target SQL statement; and / or in response to a triggering operation of the deleting control in the configuration interface, clearing the configured parameter information corresponding to the deleting control.

[0071] For example, referring to Figure 8 , in response to a triggering operation of the adding control (such as “+” or “add” in Figure 8 ), a blank new parameter row is displayed, where the parameter “a1” is a new parameter with inputted parameter information.

[0072] For example, the “add” control can be used to add a configurable parameter, and the “+” control corresponding to each configurable parameter can be used to add a sibling node (an associated same-level parameter) or a child node (an associated lower-level parameter) of the configurable parameter. For example, by clicking the “+” control, a selection pop-up box can be popped up to allow the user to select. In addition, the function of the “+” control can also be triggered without triggering the control, for example, a right-click operation menu can be popped up, and the add function can be selected to trigger the function. The present disclosure does not limit this.

[0073] It should be noted that for parameters of a Struct (structure) type, a blank new parameter row can be automatically displayed, for example, a blank new parameter row is automatically displayed below the parameter when the user selects the type, to prompt the user to add a lower-level parameter of the type.

[0074] For example, continuing to refer to Figure 8 , in response to a triggering operation of the deleting control (such as “-” or “clear” in Figure 8 ), the configured parameter information corresponding to the deleting control is cleared. The “clear” control can be used to clear the configured parameter information (such as a parameter value and a parameter type) of all configurable parameters, and the “-” control corresponding to each configurable parameter can be used to clear the configured parameter information of the configurable parameter, or the “-” control corresponding to each configurable parameter can be used to delete the configuration information. The specific implementation can be determined according to requirements, and the present disclosure does not limit this. In addition, the function of the “-” control can also be triggered without triggering the control, for example, a right-click operation menu can be popped up, and the clear or delete function can be selected to trigger the corresponding function, and the present disclosure does not limit this.

[0075] It should be understood that the added configurable parameter also corresponds to a “+” control and a “-” control, so that the added configurable parameter can be operated by the corresponding function.

[0076] It is worth noting that the present disclosure provides automatic parsing of interpolation parameters (configurable parameters), and further generates a corresponding configuration form (or configuration JSON), and the form items are linked with the parameters in the SQL statement (the parameters can be located, and the parameters in the SQL statement are highlighted), so that the user can configure the parameter values and parameter types of the parameters. In addition, during the process of writing the SQL statement by the user, the interpolation syntax can be used to determine the code position of the interpolation parameter in the SQL statement, and then the configurable parameters are displayed at the preset position and the configuration input controls are displayed at the corresponding position, so that the user can realize visual configuration of the SQL statement during the SQL editing process, so as to quickly configure the parameters and improve the development efficiency.

[0077] Based on the same inventive concept, the present disclosure provides a data configuration device for a big data structured query language, referring to Figure 9 , the device 900 comprises:

[0078] The display module 901 is configured to display a configuration interface for a structured query language (SQL) statement, and the configuration interface displays a target SQL statement in code form.

[0079] The analysis module 902 is configured to display configurable parameters in the target SQL statement obtained by an analysis operation on the target SQL statement in response to the analysis operation.

[0080] The configuration module 903 is configured to determine parameter information of a first target parameter in the target SQL statement according to configuration information corresponding to a first configuration operation on the first target parameter in response to the first configuration operation.

[0081] By analyzing the SQL statement in code form, the above device obtains configurable parameters and visually displays them, and then the parameter information of the parameters in the SQL statement can be determined by configuring the configurable parameters, thereby realizing visual configuration of the SQL statement. Not only is it convenient for users to configure parameters and improve the accuracy of parameter configuration, but also the parameters can be displayed in a visual manner during the SQL development stage or the later maintenance stage, thereby reducing the configuration difficulty, improving the development efficiency, and reducing the development or maintenance cost.

[0082] Optionally, the configuration interface comprises a first display area and a second display area, the first display area is configured to display the target SQL statement in code form, and the second display area is configured to allow a user to visually configure the configurable parameters, and the analysis module 902 is configured to:

[0083] In response to the parsing operation of the target SQL statement, the configurable parameters in the target SQL statement obtained by the parsing operation are displayed in the second display area.

[0084] Optionally, the device 900 further includes a display submodule, the display submodule being used for:

[0085] In response to the parsing operation of the target SQL statement, the code position of the configurable parameter in the target SQL statement is determined, and the configurable parameter obtained by the parsing operation is displayed at a preset position around the code position in the first display area.

[0086] Optionally, the device 900 further includes an input module, the input module being used for:

[0087] In response to the selection operation of the second target parameter among the configurable parameters in the first display area, the configuration input control for the second target parameter is expanded and displayed;

[0088] In response to an input operation on the configuration input control, the parameter information of the second target parameter in the target SQL statement is determined based on the input information corresponding to the input operation, and / or the parameter information of the second target parameter displayed in the second display area is updated synchronously based on the input information corresponding to the input operation.

[0089] Optionally, the parsing module 902 includes a parsing submodule, which is used for:

[0090] In response to the parsing operation of the target SQL statement, the configurable parameters in the target SQL statement obtained by the parsing operation are displayed in either form or key-value pair format.

[0091] Optionally, the parsing submodule is used for:

[0092] In response to a trigger operation on preset form options in the configuration interface, the configurable parameters in the target SQL statement obtained by the parsing operation are displayed in form format; or,

[0093] In response to a trigger operation on a preset key-value pair option in the configuration interface, the configurable parameters in the target SQL statement obtained by the parsing operation are displayed in key-value pair form.

[0094] Optionally, the parsing module 902 is used for:

[0095] In response to a trigger operation on the first parsing control in the configuration interface, all configurable parameters in the target SQL statement are displayed; or,

[0096] In response to a triggering operation on a second parsing control in the configuration interface, a parsing selection interface is displayed, and in response to a first SQL statement selected in the parsing selection interface, display configurable parameters in the first SQL statement; or,

[0097] When the second SQL statement in the target SQL statement is in a selected state, in response to a parsing operation on the second SQL statement, display configurable parameters in the second SQL statement obtained by the parsing operation.

[0098] Optionally, the parsing module 902 is configured to:

[0099] In response to the parsing operation on the target SQL statement, display at least one of the following information of the configurable parameters in the target SQL statement obtained by the parsing operation: parameter name, assignment result, and parameter type.

[0100] In response to the first configuration operation on the first target parameter in the configurable parameters, determine parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation, including:

[0101] In response to the first configuration operation on the assignment result and / or the parameter type of the first target parameter in the configurable parameters, determine parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation.

[0102] Optionally, the apparatus 900 further includes a positioning module configured to:

[0103] In response to a triggering operation on a positioning control corresponding to the first target parameter, locate a code line in the target SQL statement where the first target parameter is located, and highlight the first target parameter.

[0104] Optionally, the apparatus 900 further includes an adding module configured to:

[0105] In response to a triggering operation on an adding control in the configuration interface, display a blank new parameter line, the new parameter line being used for a user to configure a configurable parameter to be added in the target SQL statement; and / or,

[0106] In response to a triggering operation on a deleting control in the configuration interface, clear configured parameter information corresponding to the deleting control.

[0107] As to the apparatus in the above embodiments, the specific manners in which various modules perform operations have been described in details in the embodiments of the method, and thus will not be described in details here.

[0108] Based on the same idea, the embodiments of the present disclosure further provide a computer readable medium, having stored thereon a computer program, which, when executed by a processing apparatus, implements the steps of the above-mentioned data configuration method for big data structured query language.

[0109] Based on the same idea, the embodiments of the present disclosure further provide an electronic device, comprising:

[0110] a storage device having stored thereon a computer program;

[0111] a processing apparatus configured to execute the computer program in the storage device to implement the steps of the above-mentioned data configuration method for big data structured query language.

[0112] Reference will now be made to the following description Figure 10 , which shows a structural schematic diagram of an electronic device 1000 suitable for use to implement the embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure can include, but is not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (Tablet Personal Computers), PMPs (Portable Multimedia Players), and the like, as well as fixed terminal devices such as digital TVs, desktop computers, and the like. Figure 10 The electronic device shown is merely an example and should not impose any limitation on the functions and use range of the embodiments of the present disclosure.

[0113] As shown in Figure 10 , the electronic device 1000 can include a processing apparatus (such as a central processor, a graphics processor, etc.) 1001, which can perform various appropriate actions and processes according to programs stored in a read-only memory (ROM) 1002 or programs loaded from a storage device 1008 into a random access memory (RAM) 1003. In the RAM 1003, various programs and data required for the operation of the electronic device 1000 are also stored. The processing apparatus 1001, the ROM 1002, and the RAM 1003 are connected to each other through a bus 1004. An input / output (I / O) interface 1005 is also connected to the bus 1004.

[0114] Generally, the following devices can be connected to the I / O interface 1005: input devices 1006 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, and the like; output devices 1007 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, and the like; storage devices 1008 including, for example, a magnetic tape, a hard disk, and the like; and communication devices 1009. The communication devices 1009 can allow the electronic device 1000 to communicate with other devices wirelessly or via wires to exchange data. Although Figure 10The electronic device 1000 is illustrated with various means, but it is understood that not all of the illustrated means need be present in every embodiment. A greater or lesser number of means can alternatively be implemented.

[0115] In particular, according to embodiments of the present disclosure, the processes described above with reference to the flowcharts can be implemented as a computer software program. For example, embodiments of the present disclosure include a computer program product comprising a computer program carried on a non-transitory computer-readable medium, the computer program containing program code for executing the methods illustrated by the flowcharts. In such embodiments, the computer program can be downloaded and installed from the network by the communication device 1009, or installed from the storage device 1008, or installed from the ROM 1002. When the computer program is executed by the processing device 1001, the above-mentioned functions defined in the methods of the embodiments of the present disclosure are performed.

[0116] It should be noted that the computer-readable medium described above in the present disclosure can be a computer-readable signal medium or a computer-readable storage medium or any combination thereof. The computer-readable storage medium, for example, can be, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or apparatus, or any suitable combination thereof. More specific examples of the computer-readable storage medium can include, but are not limited to, an electrical connection having one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present disclosure, the computer-readable storage medium can be any tangible medium that contains or stores a program used or used in conjunction with an instruction execution system, apparatus, or device. In the present disclosure, the computer-readable signal medium can include a data signal carried in a baseband or as a part of a carrier wave, which carries computer-readable program code. Such a propagated data signal can take on various forms, including but not limited to an electromagnetic signal, an optical signal, or any suitable combination thereof. The computer-readable signal medium can also be any computer-readable medium other than the computer-readable storage medium that can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained in the computer-readable medium can be transmitted by any suitable medium, including but not limited to a wire, a cable, a radio frequency (RF) link, or the like, or any suitable combination thereof.

[0117] In some embodiments, communications can be conducted using any currently known or future developed network protocol, such as HTTP (HyperText Transfer Protocol), and can be interconnected with digital data communications of any form or medium (e.g., a communications network). Examples of communications networks include local area networks ("LANs"), wide area networks ("WANs"), internetworks (e.g., the Internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed networks.

[0118] The computer readable medium described above can be included in the electronic device described above; or can exist separately from the electronic device and be not assembled into the electronic device.

[0119] The computer readable medium described above carries one or more programs, when the one or more programs are executed by the electronic device, cause the electronic device to: display a configuration interface for a structured query language (SQL) statement, the configuration interface displaying a target SQL statement in a code form; in response to a parsing operation on the target SQL statement, display a configurable parameter in the target SQL statement obtained by the parsing operation; and in response to a first configuration operation on a first target parameter in the configurable parameter, determine parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation.

[0120] Computer program code for carrying out operations of the present disclosure can be written in any one or more programming languages, including object oriented programming languages such as Java, Smalltalk, C++, as well as conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code can execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer can be connected to the user's computer through any type of network, including a local area network ("LAN") or a wide area network ("WAN"), or the connection can be made to an external computer (for example, through the Internet using an Internet Service Provider).

[0121] The computer program product of the first aspect can include one or more non-transitory computer-readable media storing instructions that, when executed, cause one or more processors to perform the operations of the method of the first aspect. The computer program product of the first aspect can include a computer-readable medium storing instructions that, when executed, cause one or more processors to perform the operations of the method of the first aspect.

[0122] The modules involved in the embodiments of the present disclosure can be implemented in the form of software or in the form of hardware. In some cases, the name of the module does not constitute a limitation on the module itself.

[0123] The functions described above in the present document can be performed, at least in part, by one or more hardware logic components. For example, and without limitation, example types of hardware logic components that can be used include Field-programmable Gate Arrays (FPGAs), Application-specific Integrated Circuits (ASICs), Application-specific Standard Products (ASSPs), System-on-a-chip systems (SOCs), Complex Programmable Logic Devices (CPLDs), etc.

[0124] In the context of the present disclosure, a machine-readable medium can be a tangible medium that contains or stores a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. Machine-readable storage media can include, without limitation, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of machine-readable storage media can include one or more lines of electrical wire, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or Flash memory), optical fiber, portable compact disc read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0125] The above description merely illustrates the preferred embodiment of the disclosure and a principle of applied technologies. It should be understood by those skilled in the art that the disclosed range of the disclosure is not limited to the technical solutions formed by the specific combinations of the technical features described above, and should also cover other technical solutions formed by the combinations of the technical features described above or their equivalent features without departing from the disclosed concept. For example, the technical solutions formed by the mutual replacement of the above-described features and the technical features with similar functions disclosed in the disclosure (but not limited to) can be formed.

[0126] Furthermore, although operations are depicted in a particular, sequential order, this should not be understood as requiring or implying that the operations are performed in the order illustrated or sequentially. In certain circumstances, multitasking and parallel processing can be advantageous. Likewise, although specific implementation details are contained in the above discussion, these should not be construed as limiting the scope of the disclosure. Certain features described in the context of separate embodiments can also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment can also be implemented in multiple embodiments separately or in any suitable sub-combination.

[0127] Although the subject matter has been described in language specific to structural features and / or methodological acts, it is to be understood that the subject defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are merely illustrative of the example forms of implementing the claims. As to the means for performing the operations of the apparatus in the above-described embodiments, the specific manner in which the various modules perform the operations has been described in detail in the embodiments related to the method, and will not be described here in detail.

Claims

1. A data configuration method for big data structured query language, characterized in that, The method comprises: displaying a configuration interface for a structured query language (SQL) statement, the configuration interface displaying a target SQL statement in code form; in response to a parsing operation on the target SQL statement, displaying configurable parameters in the target SQL statement obtained by the parsing operation; in response to a first configuration operation on a first target parameter in the configurable parameters, determining parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation; in response to a triggering operation of an adding control corresponding to a third target parameter in the configurable parameters in the configuration interface, displaying a blank first newly-added parameter row for a user to configure a sibling parameter or a subordinate parameter associated with the third target parameter to be newly added in the target SQL statement; the response to the parsing operation on the target SQL statement, displaying the configurable parameters in the target SQL statement obtained by the parsing operation, comprises: in response to the parsing operation on the target SQL statement, displaying parameter names, assignment results, and parameter types of the configurable parameters in the target SQL statement obtained by the parsing operation; the response to the first configuration operation on the first target parameter in the configurable parameters, determining the parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation, comprises: in response to the first configuration operation on an assignment result and / or a parameter type of the first target parameter in the configurable parameters, determining the parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation; the method further comprises: in response to the parameter type configured for the first target parameter being a structure type, displaying a blank second newly-added parameter row for the user to configure a subordinate parameter of the first target parameter.

2. The method of claim 1, wherein, The configuration interface comprises a first display area and a second display area, the first display area being used to display the target SQL statement in code form, and the second display area being used for a user to visually configure the configurable parameters, the response to the parsing operation on the target SQL statement, displaying the configurable parameters in the target SQL statement obtained by the parsing operation, comprises: in response to the parsing operation on the target SQL statement, displaying the configurable parameters in the target SQL statement obtained by the parsing operation in the second display area.

3. The method of claim 2, wherein, The method further comprises: in response to the parsing operation on the target SQL statement, determining a code position of the configurable parameters in the target SQL statement, and displaying the configurable parameters obtained by the parsing operation at a preset position around the code position in the first display area.

4. The method of claim 3, wherein, The method further comprises: in response to a selection operation on a second target parameter in the configurable parameters in the first display area, expanding and displaying configuration input controls for the second target parameter; In response to an input operation on the configuration input control, parameter information of the second target parameter in the target SQL statement is determined according to input information corresponding to the input operation, and / or the parameter information of the second target parameter displayed in the second display area is synchronously updated according to the input information corresponding to the input operation.

5. The method according to any of claims 1 to 4, characterized in that, The operation of displaying the configurable parameters in the target SQL statement obtained by the operation of analyzing the target SQL statement includes: In response to the operation of analyzing the target SQL statement, the configurable parameters in the target SQL statement obtained by the operation of analyzing are displayed in the form of a table or in the form of a key-value pair.

6. The method of claim 5, wherein, The operation of displaying the configurable parameters in the target SQL statement obtained by the operation of analyzing in the form of a table or in the form of a key-value pair includes: In response to a triggering operation on a preset table option in the configuration interface, the configurable parameters in the target SQL statement obtained by the operation of analyzing are displayed in the form of a table; or In response to a triggering operation on a preset key-value pair option in the configuration interface, the configurable parameters in the target SQL statement obtained by the operation of analyzing are displayed in the form of a key-value pair.

7. The method according to any one of claims 1 to 4, characterized in that, The operation of displaying the configurable parameters in the target SQL statement obtained by the operation of analyzing the target SQL statement includes: In response to a triggering operation on a first analysis control in the configuration interface, all the configurable parameters in the target SQL statement are displayed; or In response to a triggering operation on a second analysis control in the configuration interface, a resolution selection interface is displayed, and in response to a first SQL statement selected in the resolution selection interface, the configurable parameters in the first SQL statement are displayed; or When a second SQL statement in the target SQL statement is in a selected state, in response to an operation of analyzing the second SQL statement, the configurable parameters in the second SQL statement obtained by the operation of analyzing are displayed.

8. The method of any one of claims 1-4, wherein, The method further includes: In response to a triggering operation on a positioning control corresponding to the first target parameter, a code line in the target SQL statement where the first target parameter is located is positioned to and the first target parameter is highlighted.

9. The method according to any one of claims 1 to 4, characterized in that, The method further includes: In response to a triggering operation on a deletion control in the configuration interface, configured parameter information corresponding to the deletion control is cleared.

10. A data configuration apparatus for big data structured query language, characterized by, The apparatus includes: A display module configured to display a configuration interface for a structured query language (SQL) statement, the configuration interface displaying a target SQL statement in a code form; An analysis module configured to, in response to an operation of analyzing the target SQL statement, display configurable parameters in the target SQL statement obtained by the operation of analyzing the target SQL statement; A configuration module configured to, in response to a first configuration operation on a first target parameter in the configurable parameters, determine parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation. The adding module is configured to, in response to a triggering operation of an adding control corresponding to a third target parameter in the configurable parameters on the configuration interface, display a first blank new parameter row for a user to configure a sibling parameter or a subordinate parameter of the third target parameter to be added in the target SQL statement. The parsing module is configured to, in response to a parsing operation on the target SQL statement, display parameter names, assignment results, and parameter types of the configurable parameters in the target SQL statement obtained by the parsing operation. The configuration module is configured to, in response to a first configuration operation on an assignment result and / or a parameter type of a first target parameter in the configurable parameters, determine parameter information of the first target parameter in the target SQL statement according to configuration information corresponding to the first configuration operation; and in response to the parameter type configured for the first target parameter being a structure type, display a second blank new parameter row for the user to configure a subordinate parameter of the first target parameter.

11. A computer readable medium having stored thereon a computer program, characterized in that The program, when executed by a processing device, implements the steps of the method of any one of claims 1-9.

12. An electronic device, comprising: The program comprises: a storage device having a computer program stored thereon; a processing device configured to execute the computer program in the storage device to implement the steps of the method of any one of claims 1-9.

Images