Data sharing method, system and equipment for custom configuration SQL (Structured Query Language) based on data center and medium

Abstract

The invention discloses a data sharing method, system and equipment for custom configuration of SQL (Structured Query Language) based on a data center and a medium, belongs to the technical field of data sharing, and aims to solve the technical problem of how to improve the flexibility and efficiency of data sharing of the data center. According to the technical scheme, the method comprises the steps that a data sharing platform is constructed, wherein the data sharing platform is constructed based on a data center, and the data sharing platform supports MySQL, PostgreSQL, Oracle and SQL Server database types; an SQL statement is configured, specifically, the corresponding SQL statement is configured on the data sharing platform according to the actual requirement of a user, and the SQL statement is used for defining the query logic and the sharing mode of data; analyzing the SQL statement: analyzing the SQL statement configured by the user, and generating a corresponding data access plan; accessing the data accessing the corresponding database according to the analyzed data access plan to obtain the required data; and data sharing: performing necessary conversion and processing on the acquired required data, and sharing the converted data through a uniform interface or a data sharing platform.

Description

Technical Field

[0001] The present invention relates to the technical field of data sharing, and in particular to a data sharing method, system, device and medium based on a custom configured SQL of a data center. Background Art

[0002] Currently, data centers are facing a large number of data management and sharing needs. Traditional data sharing methods usually rely on fixed data interfaces or data warehouses, which limits the flexibility and scalability of data use. Especially when data sharing across systems and departments is required, fixed data interfaces often cannot meet complex and changing business needs. Therefore, how to improve the flexibility and efficiency of data center data sharing is a technical problem that needs to be solved urgently. Summary of the invention

[0003] The technical task of the present invention is to provide a data sharing method, system, device and medium based on custom configured SQL of a data center to solve the problem of how to improve the flexibility and efficiency of data sharing in a data center.

[0004] The technical task of the present invention is achieved in the following manner: a data sharing method based on a custom configured SQL of a data center, the method is specifically as follows:

[0005] Build a data sharing platform: Build a data sharing platform based on the data center. The data sharing platform supports MySQL, PostgreSQL, Oracle and SQL Server database types;

[0006] Configure SQL statements: Configure corresponding SQL statements on the data sharing platform according to actual user needs. SQL statements are used to define the query logic and sharing method of data.

[0007] Parse SQL statements: parse the SQL statements configured by the user and generate corresponding data access plans;

[0008] Access the database: access the corresponding database according to the parsed data access plan to obtain the required data;

[0009] Data sharing: The required data will be converted and processed as necessary to meet the data sharing requirements, and the converted data will be shared through a unified interface or data sharing platform.

[0010] Preferably, the data access plan content includes the data source of the data access, the parameters to be processed, and the data format.

[0011] Preferably, the method also provides a user interface, allowing users to easily configure and modify SQL statements and view and manage data access plans and shared data.

[0012] Preferably, the method also performs syntax checking and logic verification on the SQL statements configured by the user to ensure the correctness and validity of the SQL statements and avoid data access errors and sharing failures.

[0013] Preferably, the method also has a data query function, specifically: after the user submits a query request, the data sharing platform parses the SQL statement configured by the user, executes the corresponding data query, and displays the data query results to the user in a tabular form.

[0014] A data sharing system based on a custom configured SQL of a data center, the system comprising:

[0015] Construction module, used to build a data sharing platform based on the data center. The data sharing platform supports MySQL, PostgreSQL, Oracle and SQL Server database types;

[0016] The configuration module is used to configure the corresponding SQL statements on the data sharing platform according to the actual needs of users. The SQL statements are used to define the query logic and sharing method of data;

[0017] The parsing module is used to parse the SQL statement configured by the user and generate the corresponding data access plan; wherein the data access plan includes the data source of the data access, the parameters to be processed and the data format; the access module is used to access the corresponding database according to the parsed data access plan to obtain the required data;

[0018] The data sharing module is used to perform necessary conversion and processing on the acquired required data to meet the data sharing requirements, and to share the converted data through a unified interface or data sharing platform.

[0019] Preferably, the system also provides a user interface that enables users to easily configure and modify SQL statements and view and manage data access plans and shared data.

[0020] More preferably, the system further comprises:

[0021] The syntax check and logic verification module is used to perform syntax check and logic verification on the SQL statements configured by the user to ensure the correctness and validity of the SQL statements and avoid data access errors and sharing failures.

[0022] The data query module is used to parse the SQL statement configured by the user after the user submits a query request, and execute the corresponding data query, and display the data query results to the user in a tabular form.

[0023] An electronic device comprising: a memory and at least one processor;

[0024] Wherein, the memory stores a computer program;

[0025] The at least one processor executes the computer program stored in the memory, so that the at least one processor executes the data sharing method based on the custom configuration SQL of the data center as described above.

[0026] A computer-readable storage medium stores a computer program, which can be executed by a processor to implement the data sharing method based on custom configured SQL in a data center as described above.

[0027] The data sharing method, system, device and medium based on the custom configuration SQL of the data center of the present invention have the following advantages:

[0028] (1) The present invention can solve the problems of insufficient flexibility and poor scalability of data sharing in the prior art, and improve the flexibility and efficiency of data sharing;

[0029] (ii) The present invention allows users to customize SQL statements according to actual needs, realize flexible data access and sharing, and improve the flexibility of data access;

[0030] (iii) The present invention supports multiple database types and data formats, adapts to changing data needs, and enhances the scalability of data sharing;

[0031] (iv) Users of the present invention can share query results with other users or systems through an interface, and the data sharing platform also supports data sharing permissions and validity periods to ensure data security and privacy;

[0032] (V) Users of the present invention can select the data table to be queried through the interface of the data sharing platform and enter the corresponding SQL statement for query. The data sharing platform can also provide syntax checking and optimization suggestions for SQL statements to improve query efficiency;

[0033] (VI) The present invention performs syntax checking and logic verification on the SQL statements configured by the user to ensure the correctness and validity of the SQL statements and avoid data access errors and sharing failures. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] The present invention is further described below in conjunction with the accompanying drawings.

[0035] Attached Figure 1 A flowchart of a data sharing method for custom-configured SQL based on a data center. DETAILED DESCRIPTION

[0036] The data sharing method, system, device and medium based on the custom configuration SQL of the data center of the present invention are described in detail below with reference to the drawings and specific embodiments of the specification.

[0037] Embodiment 1:

[0038] As attached Figure 1 As shown, this embodiment provides a data sharing method based on a custom configured SQL of a data center. The method is to build a data sharing platform based on a data center. The data sharing platform supports MySQL, PostgreSQL, Oracle and SQL Server database types; the details are as follows:

[0039] S1. Configure SQL statements: Configure corresponding SQL statements on the data sharing platform according to actual user needs. SQL statements are used to define the query logic and sharing method of data.

[0040] S2. Verify the legitimacy of SQL: Perform syntax check and logic verification on the SQL statements configured by the user:

[0041] ① If legal, proceed to step S3;

[0042] ②If it is illegal, jump to step S1;

[0043] S3, parsing SQL statements: parsing the SQL statements configured by the user and generating corresponding data access plans; wherein the data access plan includes the data source of data access, the parameters to be processed, and the data format;

[0044] S4. Access the database: access the corresponding database according to the data access plan obtained by the analysis to obtain the required data;

[0045] S5. Data sharing: The required data will be converted and processed as necessary to meet the data sharing requirements, and the converted data will be shared through a unified interface or data sharing platform.

[0046] This embodiment also provides a user interface, allowing users to easily configure and modify SQL statements and view and manage data access plans and shared data.

[0047] This embodiment also has a data query function, specifically: after the user submits a query request, the data sharing platform parses the SQL statement configured by the user, executes the corresponding data query, and displays the data query results to the user in a table form.

[0048] Embodiment 2:

[0049] This embodiment provides a data sharing system based on a custom configured SQL of a data center, the system comprising:

[0050] Construction module, used to build a data sharing platform based on the data center. The data sharing platform supports MySQL, PostgreSQL, Oracle and SQL Server database types;

[0051] The configuration module is used to configure the corresponding SQL statements on the data sharing platform according to the actual needs of users. The SQL statements are used to define the query logic and sharing method of data;

[0052] The parsing module is used to parse the SQL statement configured by the user and generate the corresponding data access plan; wherein the data access plan includes the data source of the data access, the parameters to be processed and the data format; the access module is used to access the corresponding database according to the parsed data access plan to obtain the required data;

[0053] The data sharing module is used to convert and process the acquired required data to meet the data sharing requirements, and share the converted data through a unified interface or data sharing platform;

[0054] The syntax check and logic verification module is used to perform syntax check and logic verification on the SQL statements configured by the user to ensure the correctness and validity of the SQL statements and avoid data access errors and sharing failures.

[0055] The data query module is used to parse the SQL statement configured by the user after the user submits a query request, and execute the corresponding data query, and display the data query results to the user in a tabular form.

[0056] This embodiment also provides a user interface, allowing users to easily configure and modify SQL statements and view and manage data access plans and shared data.

[0057] Embodiment 3:

[0058] This embodiment also provides an electronic device, including: a memory and at least one processor;

[0059] Wherein, the memory stores computer-executable instructions;

[0060] The at least one processor executes the computer-executable instructions stored in the memory, so that the at least one processor executes the data sharing method based on the custom configuration SQL of the data center in any embodiment of the present invention.

[0061] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor may be a microprocessor or any conventional processor, etc.

[0062] The memory can be used to store computer programs and / or modules. The processor realizes various functions of the electronic device by running or executing the computer programs and / or modules stored in the memory, and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function, etc.; the data storage area can store data created according to the use of the terminal, etc. In addition, the memory can also include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (SMC), a secure digital (SD) card, a flash memory card, at least one disk storage period, a flash memory device, or other volatile solid-state storage devices.

[0063] Embodiment 4:

[0064] This embodiment also provides a computer-readable storage medium, in which a plurality of instructions are stored, and the instructions are loaded by a processor, so that the processor executes the data sharing method based on the custom configuration SQL of the data center in any embodiment of the present invention. Specifically, a system or device equipped with a storage medium can be provided, on which the software program code that implements the functions of any of the above embodiments is stored, and the computer (or CPU or MPU) of the system or device reads and executes the program code stored in the storage medium.

[0065] In this case, the program code itself read from the storage medium can realize the function of any one of the above-mentioned embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.

[0066] The storage medium embodiments for providing the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RYM, DVD-RW, DVD+RW), a magnetic tape, a non-volatile memory card, and a ROM. Alternatively, the program code can be downloaded from a server computer via a communication network.

[0067] In addition, it should be clear that the functions of any of the above embodiments can be implemented not only by executing the program code read by the computer, but also by enabling an operating system operating on the computer to complete part or all of the actual operations based on instructions from the program code.

[0068] In addition, it can be understood that the program code read from the storage medium is written to a memory provided in an expansion board inserted into the computer or written to a memory provided in an expansion unit connected to the computer, and then based on the instructions of the program code, a CPU installed on the expansion board or the expansion unit is enabled to perform part or all of the actual operations, thereby realizing the functions of any of the above-mentioned embodiments.

[0069] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data sharing method based on a custom configured SQL in a data center, characterized in that: The method is as follows: Build a data sharing platform: Build a data sharing platform based on the data center. The data sharing platform supports MySQL, PostgreSQL, Oracle and SQL Server database types; Configure SQL statements: Configure corresponding SQL statements on the data sharing platform according to actual user needs. SQL statements are used to define the query logic and sharing method of data. Parse SQL statements: parse the SQL statements configured by the user and generate corresponding data access plans; Access the database: access the corresponding database according to the parsed data access plan to obtain the required data; Data sharing: The required data will be converted and processed as necessary to meet the data sharing requirements, and the converted data will be shared through a unified interface or data sharing platform.

2. The data sharing method based on the custom configuration SQL of the data center according to claim 1 is characterized in that: The data access plan includes the data source for data access, the parameters to be processed, and the data format.

3. The data sharing method based on the custom configuration SQL of the data center according to claim 1 is characterized in that: The method also provides a user interface, enabling users to easily configure and modify SQL statements and view and manage data access plans and shared data.

4. The data sharing method based on the custom configuration SQL of the data center according to claim 1 is characterized in that: This method also performs syntax checking and logic verification on the SQL statements configured by the user.

5. The data sharing method based on the custom configuration SQL of the data center according to any one of claims 1 to 4, characterized in that: The method also has a data query function, specifically: after the user submits a query request, the data sharing platform parses the SQL statement configured by the user, executes the corresponding data query, and displays the data query results to the user in a table form.

6. A data sharing system based on a custom configured SQL in a data center, characterized in that: The system includes: Construction module, used to build a data sharing platform based on the data center. The data sharing platform supports MySQL, PostgreSQL, Oracle and SQL Server database types; The configuration module is used to configure the corresponding SQL statements on the data sharing platform according to the actual needs of users. The SQL statements are used to define the query logic and sharing method of data; The parsing module is used to parse the SQL statement configured by the user and generate the corresponding data access plan; wherein the data access plan includes the data source of the data access, the parameters to be processed and the data format; the access module is used to access the corresponding database according to the parsed data access plan to obtain the required data; The data sharing module is used to perform necessary conversion and processing on the acquired required data to meet the data sharing requirements, and to share the converted data through a unified interface or data sharing platform.

7. The data sharing system based on the custom configuration SQL of the data center according to claim 6 is characterized in that: The system also provides a user interface that enables users to easily configure and modify SQL statements as well as view and manage data access plans and shared data.

8. The data sharing system based on the custom configuration SQL of the data center according to claim 6 or 7, characterized in that: The system also includes: The syntax check and logic verification module is used to perform syntax check and logic verification on the SQL statements configured by the user; The data query module is used to parse the SQL statement configured by the user after the user submits a query request, and execute the corresponding data query, and display the data query results to the user in a tabular form.

9. An electronic device, characterized in that: include: memory and at least one processor; Wherein, the memory stores a computer program; The at least one processor executes the computer program stored in the memory, so that the at least one processor performs the data sharing method based on custom configuration SQL of a data center as described in any one of claims 1 to 5.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, which can be executed by a processor to implement the data sharing method based on a custom configured SQL of a data center as claimed in any one of claims 1 to 5.

Images