Method, device and equipment for operating data engine and storage medium

Abstract

The application discloses an operation method, device and equipment of a data engine and a storage medium, and the method comprises the steps of determining a data engine selected by a user, obtaining a data configuration corresponding to the data engine based on the data engine and a preset transfer protocol, obtaining a first SQL statement required by the user and obtaining an operation instruction, performing corresponding operation on the data configuration based on the operation instruction, and obtaining an operation result. As long as the data engine selected by the user is determined, the data configuration corresponding to the data engine can be directly obtained from the preset transfer protocol, and the data configuration is operated, so that the problem of excessive data is avoided, the lag of the operation page is reduced, and the efficiency of the user in operating the data engine is improved.

Description

Technical Field

[0001] This application relates to the field of communication computers, and more particularly to a method, apparatus, device and storage medium for operating a data engine. Background Technology

[0002] Developers need to operate multiple data engines to improve work efficiency.

[0003] When users interact with the data engine, they need to use data engines with different functionalities. Currently, to operate different data engines, multiple servers with different configurations need to be started in the backend. After the frontend and backend are indirectly connected, the frontend uses the corresponding tools to operate on the data. Due to the large amount of data in the database and too many backend servers, the operation page is prone to lag, resulting in low efficiency for users to operate the data engine. Summary of the Invention

[0004] The main objective of this application is to provide a method, apparatus, device, and storage medium for operating a data engine, aiming to solve the technical problem of low efficiency in user operation of data engines in the prior art.

[0005] To achieve the above objectives, this application provides a method for operating a data engine, the method comprising:

[0006] Determine the data engine selected by the user, and based on the data engine and the preset relay protocol, obtain the data configuration corresponding to the data engine;

[0007] Obtain the first SQL statement required by the user and obtain the operation instructions;

[0008] Based on the operation instructions, the data configuration is operated accordingly to obtain the operation result.

[0009] Optionally, before the step of obtaining the data configuration corresponding to the data engine based on the data engine and the preset relay protocol, the method includes:

[0010] Obtain the data file corresponding to each of the data engines;

[0011] The data file is written into the configuration file of the corresponding data engine to obtain the data configuration of each data engine;

[0012] Based on the data configuration, the connection configuration obtained by the preset Hue plugin is integrated to obtain the relay protocol.

[0013] Optionally, the step of integrating the connection configuration obtained by the preset Hue plugin based on the data configuration to obtain the relay protocol includes:

[0014] Each of the data configurations is analyzed to determine the location information and data type of each data configuration.

[0015] The location information and the data type are input into the connection configuration, and the location information and the data type are analyzed and integrated to obtain the relay protocol.

[0016] Optionally, the step of obtaining the data configuration corresponding to the data engine based on the data engine and the preset relay protocol includes:

[0017] The data engine is analyzed to obtain its basic information;

[0018] The basic information of the data engine is matched with the relay protocol to determine the programming interface corresponding to the data engine;

[0019] The data configuration is obtained based on the programming interface.

[0020] Optionally, the step of matching the basic information of the data engine with the relay protocol to determine the programming interface corresponding to the data engine includes:

[0021] The basic information includes at least the data source type and data source location of the data engine;

[0022] Based on the data source type, the programming interfaces in the relay protocol are filtered to determine the programming interface group that is consistent with the data source type;

[0023] Based on the location of the data source, the programming interface group is matched to determine the programming interface corresponding to the data engine.

[0024] Optionally, before the step of obtaining the first SQL statement required by the user, the method includes:

[0025] The data configuration is parsed to obtain the data information in the data configuration;

[0026] The data information includes standard statements used when operating the data engine, and application data used when operating the data engine.

[0027] The standard statement and the application data are input into the editing library required to obtain the first SQL statement, and the editing library is updated to obtain the updated editing library.

[0028] Optionally, the step of obtaining the first SQL statement required by the user includes:

[0029] Obtain the second SQL statement input by the user, match the second SQL statement with a preset update and edit library, and obtain a group of SQL statements that match the second SQL statement;

[0030] Select the first SQL statement from the group of SQL statements.

[0031] This application also provides an operating device for a data engine, the operating device for the data engine comprising:

[0032] The first acquisition module is used to determine the data engine selected by the user, and based on the data engine and the preset relay protocol, acquire the data configuration corresponding to the data engine;

[0033] The second acquisition module is used to acquire the first SQL statement required by the user and to acquire the operation instructions;

[0034] The operation module is used to perform corresponding operations on the data configuration based on the operation instructions, and obtain the operation results.

[0035] Optionally, the operating device of the data engine further includes:

[0036] The acquisition submodule is used to acquire the data file corresponding to each of the data engines;

[0037] The writing module allows users to write the data file into the configuration file of the corresponding data engine, thereby obtaining the data configuration for each data engine.

[0038] The connection module is used to integrate the connection configuration obtained by the preset Hue plugin based on the data configuration to obtain the relay protocol.

[0039] Optionally, the connection module includes:

[0040] A connection unit is used to analyze each of the data configurations and determine the location information and data type of each data configuration;

[0041] The analysis and integration module is used to input the location information and the data type into the connection configuration, and to analyze and integrate the location information and the data type to obtain the relay protocol.

[0042] Optionally, the first acquisition module includes:

[0043] The analysis unit is used to analyze the data engine and obtain basic information about the data engine.

[0044] The matching module is used to match the basic information of the data engine with the relay protocol to determine the programming interface corresponding to the data engine.

[0045] The acquisition unit is used to acquire the data configuration based on the programming interface.

[0046] Optionally, the matching module includes:

[0047] The basic information includes at least the data source type and data source location of the data engine;

[0048] The filtering module is used to filter the programming interfaces in the relay protocol based on the data source type, and determine the group of programming interfaces that are consistent with the data source type;

[0049] The matching unit is used to match the programming interface group based on the location of the data source to determine the programming interface corresponding to the data engine.

[0050] Optionally, the operating device of the data engine further includes:

[0051] The parsing module is used to parse the data configuration to obtain the data information in the data configuration;

[0052] The data information includes standard statements used when operating the data engine, and application data used when operating the data engine.

[0053] The update module is used to input the standard statement and the application data into the editing library required to obtain the first SQL statement, update the editing library, and obtain the updated editing library.

[0054] Optionally, the second acquisition module includes:

[0055] Obtain the second SQL statement input by the user, match the second SQL statement with a preset update and edit library, and obtain a group of SQL statements that match the second SQL statement;

[0056] Select the first SQL statement from the group of SQL statements.

[0057] This application also provides an operating device for a data engine, which is a physical node device. The operating device includes a memory, a processor, and a program for the operation method of the data engine stored in the memory and executable on the processor. When the program for the operation method of the data engine is executed by the processor, it can implement the steps of the operation method of the data engine as described above.

[0058] This application also provides a storage medium storing a program that implements the above-described data engine operation method. When the program is executed by a processor, it implements the steps of the above-described data engine operation method.

[0059] This application provides a method, apparatus, device, and storage medium for operating a data engine. Compared to existing technologies that require directly viewing all annual reports, financial statements, and other data to find the resources needed, resulting in low efficiency, this application determines the data engine selected by the user, obtains the data configuration corresponding to the data engine based on the data engine and a preset relay protocol, obtains the first SQL statement required by the user, and obtains operation instructions; based on the operation instructions, performs corresponding operations on the data configuration to obtain the operation result. In this application, as long as the user-selected data engine is determined, the data configuration corresponding to the data engine can be obtained through the preset relay protocol, and the operation result can be obtained by operating the data configuration through the SQL statement obtained by the user. That is, in this application, as long as the user-selected data engine is determined, the data configuration corresponding to the data engine can be directly obtained from the preset relay protocol, and the data configuration can be operated on. Therefore, it avoids excessive data volume, reduces page lag, and improves the efficiency of user operation of the data engine. Attached Figure Description

[0060] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application.

[0061] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, for those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0062] Figure 1 This is a flowchart illustrating the first embodiment of the operation method of the data engine in this application;

[0063] Figure 2 This is a flowchart illustrating the second embodiment of the operation method of the data engine in this application;

[0064] Figure 3 This is a schematic diagram of the device structure of the hardware operating environment involved in the embodiments of this application.

[0065] The purpose, features, and advantages of this application will be further explained in conjunction with the embodiments and with reference to the accompanying drawings. Detailed Implementation

[0066] It should be understood that the specific embodiments described herein are for illustrative purposes only and are not intended to limit the scope of this application.

[0067] This application provides a method for operating a data engine. In the first embodiment of this method for operating a data engine, refer to... Figure 1 The operation method of the data engine includes:

[0068] Step S10: Determine the data engine selected by the user, and obtain the data configuration corresponding to the data engine based on the data engine and the preset relay protocol.

[0069] Step S20: Obtain the first SQL statement required by the user and obtain the operation instructions;

[0070] Step S30: Based on the operation instruction, perform corresponding operations on the data configuration to obtain the operation result.

[0071] The specific steps are as follows:

[0072] Step S10: Determine the data engine selected by the user, and obtain the data configuration corresponding to the data engine based on the data engine and the preset relay protocol;

[0073] In this embodiment, it should be noted that the data engine operation method can be applied to the data engine operation device, which is subordinate to the data engine operation equipment, and the data engine operation equipment is the data engine operating system.

[0074] The operating system of the data engine has a built-in preset relay protocol. It should be noted that this relay protocol can connect to different data configurations based on different data engines.

[0075] It should be noted that users select the data engine through the front-end device.

[0076] The data configuration can be data from a database.

[0077] The front end must be compatible with at least one data engine.

[0078] The relay protocol serves as a relay station between the front-end and data configuration.

[0079] The transit protocol must contain at least the data types and location information corresponding to all data engines set up at the front end.

[0080] In this embodiment, the data engine selected by the user from multiple data engines set on the front end is determined. Based on the basic information of the data engine, the programming interface corresponding to the basic information is matched from the relay protocol, and the data configuration corresponding to the data engine is obtained based on the programming interface.

[0081] For example, the front end has two data engines, data engine A and data engine B. If the user selects data engine B, the programming interface corresponding to the basic information of data engine B is matched from the relay protocol based on the basic information of data engine B. Through the programming interface, the data configuration corresponding to data engine B is obtained.

[0082] Specifically, the step of obtaining the data configuration corresponding to the data engine based on the data engine and the preset relay protocol includes:

[0083] Step S11: Analyze the data engine to obtain its basic information;

[0084] Step S12: Match the basic information of the data engine with the relay protocol to determine the programming interface corresponding to the data engine;

[0085] Step S13: Obtain the data configuration based on the programming interface.

[0086] The basic information of a data engine includes at least the data source type and the data source location.

[0087] Specifically, the data source type can be, but is not limited to, structured data types, semi-structured data types, and unstructured data types.

[0088] Among them, structured data types are easy to maintain and manage, and are also the most convenient for querying, displaying, and analyzing.

[0089] Among them, structured data types usually refer to data output in formats such as log data, XML (Extensible Markup Language), and JSON (JavaScript Object Notation, a lightweight data exchange format), which are relatively standardized.

[0090] Unstructured data types refer to non-plain text data that lacks a standard format and cannot be directly parsed. Examples include rich text, images, audio, and video data.

[0091] In this embodiment, it should be noted that the programming interface can connect different components of the software system. Its main purpose is to allow developers to access the capabilities of a set of routines without needing to access the source code or understand the details of the internal workings. Here, a routine is a collection of functional interfaces or services provided by a system.

[0092] For example, if you need to access a specific data group in a database, you can connect to the database through a programming interface and directly access that data group without needing to understand its code or data source information.

[0093] In this embodiment, basic information such as the data source type and location of the data engine selected by the user is analyzed. Based on the basic information of the data engine, the programming interface corresponding to the data engine is determined from the relay protocol, and the data configuration corresponding to the data engine is obtained from the database through the programming interface.

[0094] Specifically, the step of matching the basic information of the data engine with the relay protocol to determine the programming interface corresponding to the data engine includes:

[0095] Step C10: Based on the data source type, filter the programming interfaces in the relay protocol to determine the programming interface group that is consistent with the data source type;

[0096] Step C20: Based on the location of the data source, match the programming interface group to determine the programming interface corresponding to the data engine.

[0097] The application programming interface (API) is a set of thousands of extremely complex functions and subroutines.

[0098] In this embodiment, since the functions and subroutines of the programming interface are very complex, it is necessary to reduce the analysis of the programming interface. First, based on the data source type, the programming interface group with the same data source type is selected from the relay protocol. Then, based on the data source location, the programming interface corresponding to the data source engine is quickly determined.

[0099] In this embodiment, the data engine selected by the user is first determined. The data engine can be obtained in the following ways:

[0100] Method 1: Acquire data via voice. If a voice command is detected, extract the voice information from the command. Parse the voice information to obtain the selected data engine.

[0101] Method 2: Access the data engine through the front-end access interface, based on the selection buttons on the access interface.

[0102] In this embodiment, multiple data engines can be set and compatible simultaneously in the front-end query interface. The multiple data engines can be set in the query interface through drop-down boxes or through matrix buttons.

[0103] In this embodiment, the user-selected data engine is first obtained through the front end. Based on the basic information of the data engine, the corresponding programming interface is quickly matched in the relay protocol. Through the programming interface, the configured data configuration corresponding to the data engine is obtained for direct use by the front end.

[0104] Step S20: Obtain the first SQL statement required by the user and obtain the operation instructions;

[0105] In this embodiment, the first SQL statement determined by the user is obtained through the front end, and the operation instructions required by the user are selected and determined on the front end.

[0106] It should be noted that the first SQL statement can be obtained either by inputting it or by referencing it from a template.

[0107] Specifically, the step of obtaining the first SQL statement required by the user includes:

[0108] Step S21: Obtain the second SQL statement input by the user, match the second SQL statement with the preset update and edit library, and obtain a group of SQL statements that match the second SQL statement;

[0109] Step S22: Select the first SQL statement from the SQL statement group.

[0110] In this embodiment, the second SQL statement input by the user can be the first character of an SQL statement, several non-contiguous characters of an SQL statement, or a complete SQL statement. The editor then uses this second SQL statement to match a group of SQL statements containing the user-inputted second SQL statement, allowing the user to select the desired first SQL statement from the SQL statements and input it into the editor.

[0111] The complete second SQL statement entered by the user through the editor can be saved into the template statement.

[0112] In this embodiment, the first SQL statement can also be selected from the historical SQL statements in the template statement and sent to the editor via a programming interface.

[0113] It should be noted that the first SQL statement obtained from the template statement cannot be modified by the user.

[0114] In this embodiment, the editor can be set or modified through a programming interface to allow users to quickly enter the first SQL statement.

[0115] Step S30: Based on the operation instruction, perform corresponding operations on the data configuration to obtain the operation result.

[0116] The operation commands can be query commands, access log commands, etc.

[0117] Specifically, if the data configuration operation is successful, the operation result will be output;

[0118] If the data configuration operation fails, a failure log will be output.

[0119] The failure log should include at least the reason for the failure, the failure data, and the suggested solutions.

[0120] In this embodiment, based on the operation instructions selected by the user on the front end, the data configuration is operated accordingly. If the operation is successful, the operation result is obtained; if the operation fails, the failure log is obtained.

[0121] In this embodiment, the data engine selected by the user at the front end is first determined, and the basic information of the data engine is analyzed. The basic information is used to match the programming interface corresponding to the data engine selected by the user in the transit protocol. The data configuration corresponding to the data engine is obtained from the database through the programming interface. The first SQL statement and operation instructions determined by the user are obtained, and the data configuration is operated based on the operation instructions. If the operation is successful, the operation result is obtained; if the operation fails, the failure log is obtained.

[0122] This application provides a method, apparatus, device, and storage medium for operating a data engine. Compared to existing technologies that require directly viewing all annual reports, financial statements, and other data to find the resources needed, resulting in low efficiency, this application determines the data engine selected by the user, obtains the data configuration corresponding to the data engine based on the data engine and a preset relay protocol, obtains the first SQL statement required by the user, and obtains operation instructions; based on the operation instructions, performs corresponding operations on the data configuration to obtain the operation result. In this application, as long as the user-selected data engine is determined, the data configuration corresponding to the data engine can be obtained through the preset relay protocol, and the operation result can be obtained by operating the data configuration through the SQL statement obtained by the user. That is, in this application, as long as the user-selected data engine is determined, the data configuration corresponding to the data engine can be directly obtained from the preset relay protocol, and the data configuration can be operated on. Therefore, it avoids excessive data volume, reduces page lag, and improves the efficiency of user operation of the data engine.

[0123] Furthermore, based on the above embodiments of this application, another embodiment of this application is provided. In this embodiment, before the step of obtaining the data configuration corresponding to the data engine based on the data engine and the preset relay protocol, the method includes:

[0124] Step D10: Obtain the data file corresponding to each of the data engines;

[0125] In this embodiment, the data engine set in the front end is first determined, and the script file containing all the data engines set in the front end is downloaded. The script information corresponding to each data engine is matched in the script file, that is, the data file corresponding to each data engine.

[0126] The script file can be a public script.

[0127] The script file can include at least the script information corresponding to all data engines in the front end.

[0128] Step D20: Write the data file into the configuration file of the corresponding data engine to obtain the data configuration of each data engine;

[0129] In this embodiment, each data file is written into the configuration file of the corresponding data engine, and the data files are integrated and packaged to obtain the data configuration for each data engine. Pre-packaging the data files corresponding to each data engine in this embodiment reduces the number of operations performed on the data engine by the front-end application, thus reducing operational lag.

[0130] Step D30: Based on the data configuration, integrate the connection configuration obtained by the preset Hue plugin to obtain the relay protocol.

[0131] Hue is an open-source Hadoop UI (distributed system infrastructure) system.

[0132] In this embodiment, the data configuration is analyzed to obtain its location and data type. This information is then input into the connection configuration obtained through a preset Hue plugin, resulting in a relay protocol between the front-end and the database. In this embodiment, the user-selected data engine can provide corresponding data configurations, preventing the entire database from being exposed to the client, thus improving database security.

[0133] Specifically, the step of integrating the connection configuration obtained by the preset Hue plugin based on the data configuration to obtain the relay protocol includes:

[0134] Step D31 analyzes each of the data configurations to determine the location information and data type of each data configuration;

[0135] Step D32: Input the location information and the data type into the connection configuration, and analyze and integrate the location information and the data type to obtain the relay protocol.

[0136] In this embodiment, the location information and data type of each data configuration are analyzed, and the location information and data type are input into the connection configuration to obtain an interactive relay protocol.

[0137] In this embodiment, the script files containing all the front-end data engines are downloaded in advance. From these script files, the corresponding data files for each data engine are matched, and each data file is written into the configuration file of its corresponding data engine to obtain the data configuration for each engine. Then, the basic information from the configuration files is input into the connection configuration to obtain the relay protocol. This reduces the amount of data processing required by the front-end, avoids completely exposing the database to the user, thus reducing operational lag and improving database security.

[0138] Furthermore, based on the above embodiments of this application, another embodiment of this application is provided. In this embodiment, before the step of obtaining the first SQL statement required by the user, the method includes:

[0139] Step E10: Parse the data configuration to obtain the data information in the data configuration;

[0140] The data information includes standard statements used when operating the data engine, and application data used when operating the data engine.

[0141] Step E20: Input the standard statement and the application data into the editing library required to obtain the first SQL statement, update the editing library, and obtain the updated editing library.

[0142] In this embodiment, the data configuration is parsed to obtain standard statements and application data for data engine operations. The standard statements and application data are then input into the editing library to update the editing library, resulting in an updated editing library.

[0143] In this embodiment, when obtaining the first SQL statement, it can be limited according to the update and edit library to avoid SQL statements that cannot be used in this data engine, thus reducing the probability of SQL statement errors.

[0144] Reference Figure 3 , Figure 3 This is a schematic diagram of the device structure of the hardware operating environment involved in the embodiments of this application.

[0145] like Figure 3 As shown, the operating devices of this data engine may include: a processor 1001, such as a CPU, a memory 1005, and a communication bus 1002. The communication bus 1002 is used to establish communication between the processor 1001 and the memory 1005. The memory 1005 may be a high-speed RAM or a stable, non-volatile memory, such as a disk drive. Optionally, the memory 1005 may also be a storage device independent of the aforementioned processor 1001.

[0146] Optionally, the operating device of the data engine may also include a rectangular user interface, a network interface, a camera, RF (Radio Frequency) circuitry, sensors, audio circuitry, and a WiFi module. The rectangular user interface may include a display screen and an input submodule such as a keyboard. Optionally, the rectangular user interface may also include a standard wired interface or a wireless interface. The network interface may optionally include a standard wired interface or a wireless interface (such as a Wi-Fi interface).

[0147] Those skilled in the art will understand that Figure 3 The operating device structure of the data engine shown does not constitute a limitation on the operating device of the data engine. It may include more or fewer components than shown, or combine certain components, or have different component arrangements.

[0148] like Figure 3 As shown, the memory 1005, as a storage medium, may include an operating system, a network communication module, and the operating program of the data engine. The operating system is a program that manages and controls the hardware and software resources of the data engine, supporting the operation of the data engine's operating program and other software and / or programs. The network communication module is used to enable communication between the various components within the memory 1005, as well as communication with other hardware and software in the data engine's operating system.

[0149] exist Figure 3 In the data engine operating device shown, the processor 1001 is used to execute the data engine operating program stored in the memory 1005 to implement the steps of the data engine operating method described in any of the above claims.

[0150] The specific implementation method of the data engine operating device in this application is basically the same as that of the above-described data engine operating method embodiments, and will not be repeated here.

[0151] This application also provides an operating device for a data engine, the operating device for the data engine comprising:

[0152] The first acquisition module is used to determine the data engine selected by the user, and based on the data engine and the preset relay protocol, acquire the data configuration corresponding to the data engine;

[0153] The second acquisition module is used to acquire the first SQL statement required by the user and to acquire the operation instructions;

[0154] The operation module is used to perform corresponding operations on the data configuration based on the operation instructions, and obtain the operation results.

[0155] Optionally, the operating device of the data engine further includes:

[0156] The acquisition submodule is used to acquire the data file corresponding to each of the data engines;

[0157] The writing module allows users to write the data file into the configuration file of the corresponding data engine, thereby obtaining the data configuration for each data engine.

[0158] The connection module is used to integrate the connection configuration obtained by the preset Hue plugin based on the data configuration to obtain the relay protocol.

[0159] Optionally, the connection module includes:

[0160] A connection unit is used to analyze each of the data configurations and determine the location information and data type of each data configuration;

[0161] The analysis and integration module is used to input the location information and the data type into the connection configuration, and to analyze and integrate the location information and the data type to obtain the relay protocol.

[0162] Optionally, the first acquisition module includes:

[0163] The analysis unit is used to analyze the data engine and obtain basic information about the data engine.

[0164] The matching module is used to match the basic information of the data engine with the relay protocol to determine the programming interface corresponding to the data engine.

[0165] The acquisition unit is used to acquire the data configuration based on the programming interface.

[0166] Optionally, the matching module includes:

[0167] The basic information includes at least the data source type and data source location of the data engine;

[0168] The filtering module is used to filter the programming interfaces in the relay protocol based on the data source type, and determine the group of programming interfaces that are consistent with the data source type;

[0169] The matching unit is used to match the programming interface group based on the location of the data source to determine the programming interface corresponding to the data engine.

[0170] Optionally, the operating device of the data engine further includes:

[0171] The parsing module is used to parse the data configuration to obtain the data information in the data configuration;

[0172] The data information includes standard statements used when operating the data engine, and application data used when operating the data engine.

[0173] The update module is used to input the standard statement and the application data into the editing library required to obtain the first SQL statement, update the editing library, and obtain the updated editing library.

[0174] Optionally, the second acquisition module includes:

[0175] Obtain the second SQL statement input by the user, match the second SQL statement with a preset update and edit library, and obtain a group of SQL statements that match the second SQL statement;

[0176] Select the first SQL statement from the group of SQL statements.

[0177] The specific implementation of the data engine operating device of this application is basically the same as the above-described embodiments of the data engine operating method, and will not be repeated here.

[0178] This application provides a storage medium that stores one or more programs, which can be executed by one or more processors to implement the steps of the data engine operation method described in any of the above claims.

[0179] The specific implementation method of the storage medium in this application is basically the same as the operation method of the data engine described above, and will not be repeated here.

[0180] It should be noted that, in this document, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Unless otherwise specified, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes that element.

[0181] The sequence numbers of the above embodiments of the present invention are for descriptive purposes only and do not represent the superiority or inferiority of the embodiments.

[0182] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus necessary general-purpose hardware platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) and includes several instructions to cause a terminal device (which may be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in the various embodiments of the present invention.

[0183] The above are merely preferred embodiments of the present invention and do not limit the scope of the patent. Any equivalent structural or procedural transformations made based on the description and drawings of the present invention, or direct or indirect applications in other related technical fields, are similarly included within the scope of patent protection of the present invention.

Claims

1. A method of operating a data engine, the method comprising: The operation method of the data engine comprises: determining a user-selected data engine, obtaining data configuration corresponding to the data engine based on the data engine and a preset transit protocol; obtaining a first SQL statement required by the user, and obtaining an operation instruction; based on the operation instruction, performing corresponding operation on the data configuration to obtain an operation result; Before the step of obtaining the data configuration corresponding to the data engine based on the data engine and the preset transit protocol, the method comprises: obtaining a data file corresponding to each data engine; write the data file into the configuration file of the corresponding data engine to obtain the data configuration of each data engine; based on the data configuration, the connection configuration obtained by the preset hue plug-in is integrated to obtain a transit protocol; The step of integrating the connection configuration obtained by the preset hue plug-in based on the data configuration to obtain the transit protocol comprises: analyze each data configuration to determine the position information and data type of each data configuration; input the position information and the data type into the connection configuration, and analyze and integrate the position information and the data type to obtain the transit protocol; The step of obtaining the data configuration corresponding to the data engine based on the data engine and the preset transit protocol comprises: analyze the data engine to obtain basic information of the data engine; match the basic information of the data engine with the transit protocol to determine a programming interface corresponding to the data engine; based on the programming interface, obtain the data configuration; Before the step of obtaining the first SQL statement required by the user, the method comprises: analyze the data configuration to obtain data information in the data configuration; wherein the data information comprises a standard statement for operating the data engine and application data for operating the data engine; input the standard statement and the application data into an editing library required for obtaining the first SQL statement, update the editing library to obtain an updated editing library.

2. The method of operating a data engine of claim 1, wherein, The step of matching the basic information of the data engine with the transit protocol to determine the programming interface corresponding to the data engine comprises: wherein the basic information at least includes the data source type and the data source position of the data engine; based on the data source type, filter the programming interfaces in the transit protocol to determine a programming interface group consistent with the data source type; based on the data source position, match the programming interface group to determine the programming interface corresponding to the data engine. The step of obtaining the first SQL statement required by the user comprises:

3. The method of claim 1, wherein, obtain a second SQL statement input by the user, match the second SQL statement with a preset updated editing library to obtain a SQL statement group matched with the second SQL statement; select the first SQL statement from the SQL statement group. The operation device of the data engine comprises:

4. An apparatus for operating a data engine, the apparatus comprising: ​ The first obtaining module is configured to determine a data engine selected by a user, and obtain a data configuration corresponding to the data engine based on the data engine and a preset transfer protocol; The second obtaining module is configured to obtain a first SQL statement required by the user, and obtain an operation instruction; The operation module is configured to perform corresponding operations on the data configuration based on the operation instruction, and obtain an operation result; The operation device of the data engine is configured to implement: Obtain a data file corresponding to each data engine; Write the data file into a configuration file of the corresponding data engine to obtain a data configuration of each data engine; Integrate a connection configuration obtained by a preset hue plug-in based on the data configuration to obtain a transfer protocol; The operation device of the data engine is configured to implement: Analyze each data configuration to determine position information and a data type of each data configuration; Input the position information and the data type into the connection configuration, and analyze and integrate the position information and the data type to obtain a transfer protocol; The operation device of the data engine is configured to implement: Analyze the data engine to obtain basic information of the data engine; Match the basic information of the data engine with the transfer protocol to determine a programming interface corresponding to the data engine; Obtain the data configuration based on the programming interface; The operation device of the data engine is configured to implement: Parse the data configuration to obtain data information in the data configuration; The data information includes a standard sentence for operating the data engine and application data for operating the data engine; Input the standard sentence and the application data into an editing library required for obtaining a first SQL statement, update the editing library to obtain an updated editing library.

5. An apparatus for operating a data engine, the apparatus comprising: The operation device of the data engine includes a memory, a processor, and a program stored in the memory for implementing the operation method of the data engine, The memory is configured to store the program for implementing the operation method of the data engine; The processor is configured to execute the program for implementing the operation method of the data engine to implement the steps of the operation method of the data engine according to any one of claims 1 to 3.

6. A storage medium, characterized by The storage medium has the program for implementing the operation method of the data engine stored thereon, and the program for implementing the operation method of the data engine is executed by the processor to implement the steps of the operation method of the data engine according to any one of claims 1 to 3.

Images