CN108462731B

CN108462731B - Data proxy method and device and electronic equipment

Info

Publication number: CN108462731B
Application number: CN201710089684.0A
Authority: CN
Inventors: 代立晨
Original assignee: Alibaba Group Holding Ltd
Current assignee: Alibaba Group Holding Ltd
Priority date: 2017-02-20
Filing date: 2017-02-20
Publication date: 2021-04-09
Anticipated expiration: 2037-02-20
Also published as: CN108462731A

Abstract

The application discloses a data proxy method, which sends a request for accessing data service to a data service provider; receiving service logic corresponding to the data service returned by the data service provider; submitting the selected data service selected based on the service logic to the data service provider; receiving a data operation instruction corresponding to the selected data service returned by the data service provider; sending the data operation instruction to a proxy server of user data; and receiving user data corresponding to the data operation instruction sent by the proxy server. When data proxy is carried out, data interaction between the data proxy method and the data proxy method is realized, direct access to user data is avoided, the user data is safer, and therefore network data safety in the data proxy process is improved.

Description

Data proxy method and device and electronic equipment

Technical Field

The application relates to the technical field of data proxy, in particular to a data proxy method. The application also relates to a data proxy device, a data proxy method and device based on a data provider, a data proxy method and device based on a proxy server, three electronic devices and a database proxy system based on big data.

Background

A data proxy is a special network service through which data access speed can be increased and resource access can be controlled, and generally speaking, the data proxy allows a client to make an indirect data connection with a server through the network service. With the rapid development of big data, data agents are widely applied and popularized in the field of big data, and when big data products provided by a plurality of enterprises are connected with a user database, the connection with the user database and the access of user data are realized through the data agents.

The data agent in the prior art establishes a connection with the user database through an interface provided by a data service provider, and accesses a data access protocol of user data in the user database, for example, a user accessing the service configures a connection between the agent server and the user database on a web page of a data service provided by the data service provider, and can request data in the user database through the configured data agent according to a query statement.

However, for the user, based on factors such as data security, the user does not want the proxy server to communicate with the user database through the network, thereby exposing the network of the user; the data service system is divided according to a data service provider and a user, configuration and query statements between a proxy server and a user database are on the side of the data service provider, the proxy server is also arranged on the side of the data service provider, the user database is arranged on the side of the user, the data service provider and the user necessarily use different servers, and the proxy server is necessarily connected with the user database when the proxy server wants to establish connection with the user database.

Disclosure of Invention

The application provides a data proxy method to solve the defects in the prior art. The application further provides a device for realizing data proxy, a data proxy method based on a data provider, a device for realizing data proxy based on a data provider, a data proxy method and device based on a proxy server, three electronic devices and a database proxy system based on big data.

The application provides a data proxy method, comprising:

sending a request to access a data service to a data service provider;

receiving service logic corresponding to the data service returned by the data service provider;

submitting the selected data service selected based on the service logic to the data service provider;

receiving a data operation instruction corresponding to the selected data service returned by the data service provider;

sending the data operation instruction to a proxy server of user data;

and receiving user data corresponding to the data operation instruction sent by the proxy server.

Optionally, the proxy server is deployed in the user lan.

Optionally, the user data is stored in a user database, and the user database is deployed in the user lan.

Optionally, the proxy server and the user database are deployed in the same user lan.

Optionally, the data service provider provides data services through a public network.

Optionally, the user data includes at least one of: user related data, APIs and static files stored in a user database.

Optionally, the data operation instruction includes: SQL query statements.

Optionally, the data operation instruction is data encrypted by adopting a preset encryption mode; wherein, the preset encryption mode comprises: symmetric encryption and asymmetric encryption.

Optionally, the data proxy method is implemented based on a browser; correspondingly, the proxy server comprises: an HTTP proxy server; the service logic includes: and HTML codes corresponding to the data services.

Optionally, the data operation instruction is sent to the proxy server by calling an Ajax interface of the browser.

The present application further provides a device for implementing data proxy, including:

a data service access request transmitting unit for transmitting a request for accessing a data service to a data service provider;

a service logic receiving unit, configured to receive a service logic corresponding to the data service returned by the data service provider;

a selected data service submitting unit for submitting the selected data service selected based on the service logic to the data service provider;

a data operation instruction receiving unit, configured to receive a data operation instruction corresponding to the selected data service, where the data operation instruction is returned by the data service provider;

the data operation instruction forwarding unit is used for sending the data operation instruction to a proxy server of user data;

and the user data receiving unit is used for receiving the user data corresponding to the data operation instruction sent by the proxy server.

The application also provides a data proxy method based on the data provider, which comprises the following steps:

receiving a request for accessing a data service sent by a client;

sending service logic of the data service to the client;

receiving a selected data service submitted by the client based on the service logic selection;

reading a data operation instruction corresponding to the selected data service in a pre-stored data operation instruction set;

and sending the read data operation instruction to the client.

Optionally, after the step of reading the data operation instruction corresponding to the selected data service in the pre-stored data operation instruction set is executed, and before the step of sending the read data operation instruction to the client is executed, the following steps are executed:

encrypting the data operation instruction by adopting a preset encryption mode;

correspondingly, the read data operation instruction sent by the step of sending the data operation instruction to the client is the data operation instruction encrypted by adopting the preset encryption mode; wherein, the preset encryption mode comprises: symmetric encryption and asymmetric encryption.

Optionally, the data proxy method based on the data provider is implemented based on a data server providing a data service.

The present application further provides a device for implementing data proxy based on a data provider, including:

the data service access request receiving unit is used for receiving a request for accessing the data service sent by the client;

a service logic sending unit, configured to send a service logic of the data service to the client;

a selected data service receiving unit, configured to receive a selected data service that is selected based on the service logic and submitted by the client;

the data operation instruction reading unit is used for reading a data operation instruction corresponding to the selected data service in a pre-stored data operation instruction set;

and the data operation instruction sending unit is used for sending the read data operation instruction to the client.

The application also provides a data proxy method based on the proxy server, which comprises the following steps:

receiving a data operation instruction sent by a client;

executing the data operation instruction by combining with pre-stored user data to obtain user data corresponding to the data operation instruction;

and sending the user data corresponding to the data operation instruction to the client.

Optionally, the user data is stored in the user database, and the user database is deployed in a user lan.

Optionally, the data operation instruction is executed in combination with pre-stored user data to obtain user data corresponding to the data operation instruction, and the following method is adopted:

and initiating a corresponding data request to the user database according to the data operation instruction, and acquiring user data corresponding to the data operation instruction from the user database.

Optionally, after the step of receiving the data operation instruction sent by the client is executed, and before the step of executing the data operation instruction by combining the pre-stored user data to obtain the user data corresponding to the data operation instruction is executed, the following steps are executed:

decrypting the data operation instruction;

correspondingly, the step of executing the data operation instruction by combining the pre-stored user data to obtain the user data corresponding to the data operation instruction is performed, and the executed data operation instruction is the data operation instruction obtained after decryption.

Optionally, the data proxy method based on the proxy server is implemented by a proxy server based on user data.

The present application further provides a data proxy apparatus based on a proxy server, including:

the data operation instruction receiving unit is used for receiving a data operation instruction sent by a client;

the user data acquisition unit is used for executing the data operation instruction by combining pre-stored user data to acquire user data corresponding to the data operation instruction;

and the user data sending unit is used for sending the user data corresponding to the data operation instruction to the client.

The present application further provides an electronic device, comprising:

a memory, and a processor;

the memory is to store computer-executable instructions, and the processor is to execute the computer-executable instructions to:

sending a request to access a data service to a data service provider;

sending the data operation instruction to a proxy server of user data;

The present application additionally provides an electronic device comprising:

a memory, and a processor;

receiving a request for accessing a data service sent by a client;

sending service logic of the data service to the client;

and sending the read data operation instruction to the client.

The third electronic device provided by the application comprises:

a memory, and a processor;

receiving a data operation instruction sent by a client;

The present application further provides a database proxy system based on big data, including:

the system comprises a client, a database proxy server, a user database and a data server for providing data service by a data provider;

wherein, the client sends a request of a user for accessing the data service to the data server, the data server returns a service logic corresponding to the data service to the client, the client submits a selected data service selected based on the service logic to the data server, the data server reads a data operation instruction corresponding to the selected data service in a pre-stored data operation instruction set and sends the read data operation instruction to the client, the client acquires user data by sending the data operation instruction to the database proxy server when performing data operation based on the received data operation instruction, the database proxy server executes the data operation instruction by combining with the user database storing the user data, and acquires the user data corresponding to the data operation instruction from the user database, and sending the user data to the client as a data basis for data operation of the user at the client.

The application provides a data proxy method, comprising: sending a request to access a data service to a data service provider; receiving service logic corresponding to the data service returned by the data service provider; submitting the selected data service selected based on the service logic to the data service provider; receiving a data operation instruction corresponding to the selected data service returned by the data service provider; sending the data operation instruction to a proxy server of user data; and receiving user data corresponding to the data operation instruction sent by the proxy server.

According to the data proxy method, when a user accesses a data service provided by a data service provider, a request of the user for accessing the data service is sent to the data service provider, and corresponding service logic returned by the data service provider aiming at the request is received. When the data proxy method is used for data proxy, the data provider and the proxy server of the user data are not directly connected in a network mode, data interaction between the data provider and the proxy server of the user data is achieved through the data proxy method, direct access to the user data is avoided, the user data are safer, and therefore network data safety in the data proxy process is improved.

Drawings

FIG. 1 is a process flow diagram of an embodiment of a data brokering method provided herein;

FIG. 2 is a schematic diagram of a data agent interaction approach provided by the present application;

FIG. 3 is a schematic diagram of an embodiment of an apparatus for implementing data brokering provided herein;

FIG. 4 is a process flow diagram of an embodiment of a data provider based data brokering method provided herein;

FIG. 5 is a schematic diagram of an embodiment of an apparatus for implementing data proxy based on a data provider provided by the present application;

FIG. 6 is a process flow diagram of an embodiment of a data proxy method based on a proxy server provided by the present application;

FIG. 7 is a schematic diagram of an embodiment of a proxy server-based data proxy apparatus provided herein;

FIG. 8 is a schematic diagram of an embodiment of an electronic device provided herein;

FIG. 9 is a schematic diagram of another embodiment of an electronic device provided herein;

FIG. 10 is a schematic diagram of a third electronic device embodiment provided herein;

FIG. 11 is a schematic diagram of an embodiment of a big data based database broker system provided by the present application.

Detailed Description

In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present application. This application is capable of implementation in many different ways than those herein set forth and of similar import by those skilled in the art without departing from the spirit of this application and is therefore not limited to the specific implementations disclosed below.

The application provides a data proxy method, and additionally provides a device for realizing data proxy, a data proxy method based on a data provider, a device for realizing data proxy based on a data provider, a data proxy method and device based on a proxy server, three electronic devices and a database proxy system based on big data. In a specific implementation, any two of the data proxy method, the data provider-based data proxy method and the proxy server-based data proxy method are matched with each other in the execution process, or the three are matched with each other in the execution process. The following detailed description and the description of the steps of the method are individually made with reference to the drawings of the embodiments provided in the present application.

The embodiment of the data proxy method provided by the application is as follows:

referring to fig. 1, a processing flow diagram of an embodiment of a data proxy method provided by the present application is shown, and referring to fig. 2, a schematic diagram of a data proxy interaction manner provided by the present application is shown.

In addition, since this embodiment is mutually matched with the data proxy method embodiment based on the data provider and the data proxy method embodiment based on the proxy server provided in this application, when reading this embodiment, please refer to the data proxy method embodiment based on the data provider and the data proxy method embodiment based on the proxy server provided in the following.

Step S101, a request for access to a data service is sent to a data service provider.

In the data proxy scenario, the data proxy system comprises three roles of a data service provider providing data services, a client accessing the data services provided by the data service provider, and a proxy server for user data, and data proxy is realized through the cooperation of the three roles. The data proxy method is realized based on a client accessing data services provided by a data service provider. In a specific implementation, the client may be a browser or an application program for providing data service access, which is not limited to this. In this embodiment, the client is a browser, and the data proxy method is implemented based on the browser. Based on this, connect through the network between stated customer end and stated proxy server, correspondingly, stated proxy server includes: an HTTP proxy server. In addition, in the implementation, the data service provider may be implemented based on a data server providing data services, and the data server provides the data services to the outside.

The user data comprises at least one of: user related data, APIs and static files stored in a user database. It should be noted that the user data is not limited to the three data types, and the user data further includes data other than the three data types according to the change of the actual usage scenario and the adjustment of the data service. In this embodiment, the user-related data stored in the user database is taken as an example for explanation, and correspondingly, when the HTTP proxy server accesses the user-related data stored in the user database, the HTTP proxy server obtains the required user-related data from the user database by initiating a request to the user database.

For the security of network data, many enterprises isolate an internal local area network (i.e. a user local area network) from a public network, and configure the internal local area network as a network environment that can access the public network but cannot be accessed by the public network, based on which, in this embodiment, the data server provides data services through the public network, and opens a webpage of the data server through a browser to access the data services provided by the data server; and the HTTP proxy server is deployed in an internal local area network, and data interaction is carried out between the data server and the HTTP proxy server through a browser, so that network intercommunication between the data server and the HTTP proxy server is avoided.

In addition, because the access speed of the internal local area network is much higher than that of the public network, according to the characteristic, the HTTP proxy server and the user database can be deployed in the same user local area network to reduce the time consumed by accessing the user data, thereby improving the data access efficiency.

When a user accesses the data service provided by the data server through the browser, the browser sends a request for accessing the data service to the data server according to an operation instruction initiated when the user accesses the data service. For example, as shown in fig. 2, the data server provides the report making service to the outside through the public network, the user opens a webpage of the report making service through the browser, and the browser sends a request for accessing the report making service to the data server.

And step S102, receiving the service logic corresponding to the data service returned by the data service provider.

And receiving the service logic corresponding to the data service returned by the data server. For example, as shown in fig. 2, the browser receives an HTML code corresponding to a web page of the report making service returned by the data server, and the browser displays corresponding content corresponding to the HTML code, that is, related content of the data service provided by the data server, on the front-end page according to the received HTML code corresponding to the web page of the report making service.

Step S103, submitting the selected data service selected based on the service logic to the data service provider.

The step S102 receives the service logic corresponding to the data service returned by the data server, and displays the corresponding content of the service logic corresponding to the data service through the browser; on this basis, in this step, when the user performs data operation through the browser, based on the corresponding content of the service logic corresponding to the data service displayed by the browser, the data service required by the user is displayed among the displayed data services, and the selected data service selected by the user is submitted to the data server. For example, as shown in fig. 2, through the related content of the report making service displayed on the front-end page of the browser, the user selects the report making service that the user needs to use or may use in making the report, and after the user selects the report making service, the browser submits the selected report making service currently selected by the user to the data server.

And step S104, receiving a data operation instruction corresponding to the selected data service returned by the data service provider.

In practical application, when a user uses a data service provided by the data server through a browser, the user needs to frequently enter the platform of the data service to perform corresponding data operation and perform customized data operation according to own needs or business needs, so that the data operation instruction can be stored on the data server providing the data service, and the data operation instruction is used for performing corresponding data operation according to the data service provided by the data server. The data operation instruction comprises: SQL query statements. It should be noted that the data operation instruction is not limited to the SQL query statement provided above, and in addition, the data operation instruction may also be an operation instruction for data operation other than the SQL query statement. For example, the data server provides a report making service to the outside through the public network, the user opens a webpage of the data server providing the report making service through the browser, the user performs data screening and corresponding report making in the user data by using the SQL query statement on the browser, and meanwhile, in the process of making the report, the report in the making process or the made report can be directly checked on the browser.

In step S103, the selected data service selected by the user is submitted to the data server through the browser, and after the selected data service is submitted to the data server, the data server side reads the data operation instruction corresponding to the selected data service from the pre-stored data operation instruction set, and sends the data operation instruction corresponding to the selected data service of the user to the browser. After that, this step receives a data operation instruction corresponding to the selected data service returned by the data service provider. For example, as shown in fig. 2, the browser receives an SQL query statement corresponding to the report making service currently selected by the user and returned by the data server.

In order to improve network security and prevent network sniffing, in specific implementation, the data operation instruction may also be encrypted in a preset encryption manner, the data server sends the encrypted data operation instruction to the browser, and correspondingly, the browser receives the encrypted data operation instruction sent by the data server. Wherein, the preset encryption mode comprises: symmetric encryption and asymmetric encryption.

And step S105, sending the data operation instruction to a proxy server of the user data.

In step S104, the browser receives the data operation instruction corresponding to the selected data service returned by the data server, and in this step, the browser sends the data operation instruction corresponding to the selected data service to the HTTP proxy server. For example, as shown in fig. 2, the browser forwards the received SQL query statement corresponding to the report making service selected by the user to the HTTP proxy server.

In specific implementation, in this step, a data operation instruction corresponding to the selected data service is sent to the HTTP proxy server through a browser, and the received data operation instruction corresponding to the selected data service may be forwarded to the HTTP proxy server by invoking an Ajax interface of the browser.

And step S106, receiving the user data corresponding to the data operation instruction sent by the proxy server.

In step S105, the HTTP proxy server forwards the data operation instruction corresponding to the selected data service through the browser, and after receiving the data operation instruction forwarded by the browser, the HTTP proxy server executes the data operation instruction in combination with the pre-stored user data to obtain the user data corresponding to the data operation instruction, and sends the obtained user data to the browser; after that, in this step, the user data corresponding to the data operation instruction sent by the HTTP proxy server is received by the browser. For example, as shown in fig. 2, user data corresponding to the data operation instruction sent by the HTTP proxy server is received.

In practical applications, for a large data product requiring connection with a user database, such as a DataV visualization product provided by airy cloud, when a user uses a data proxy service provided by the DataV visualization product, after configuring a connection of the user database and an SQL query string on a page of the DataV visualization product, the user may request user data from the user database through the currently configured data proxy service. Specifically, the DataV visualization product provides a platform of the report making service through the public network, when a user makes a report through the platform of the report making service, the user enters the platform of the report making service through a browser, report data comes from a user database, and a data operation instruction (such as a database query statement) required by the user to query the report data in the user database in the process of making the report is stored on the platform of the report making service. Meanwhile, a database proxy server is deployed in a network of a user, when the user needs to obtain report data (user data) from a user database in the process of making a report on a platform of a report making service, a browser is used as a bridge to transmit a data operation instruction required by the user to inquire the report data in the user database to the database proxy server in an encryption mode, the database proxy server inquires and reads the report data from the user database according to the data operation instruction, and the read report data is returned to the platform of the report making service to serve as a data basis for making the report by the user.

To sum up, according to the data proxy method provided by the application, when a user accesses a data service provided by a data service provider through a data server, a request of the user for accessing the data service is sent to the data service provider, and a corresponding service logic returned by the data service provider for the request is received. When the data proxy method is used for data proxy, the data provider and the proxy server of the user data are not directly connected in a network mode, data interaction between the data provider and the proxy server of the user data is achieved through the data proxy method, direct access to the user data is avoided, the user data are safer, and therefore network data safety in the data proxy process is improved.

The embodiment of the device for realizing data proxy provided by the application is as follows:

in the foregoing embodiment, a data proxy method is provided, and correspondingly, the present application also provides a device for implementing data proxy, which is described below with reference to the accompanying drawings.

Referring to fig. 3, a schematic diagram of an embodiment of an apparatus for implementing data proxy provided in the present application is shown.

Since the embodiment of the apparatus corresponds to the embodiment of the data proxy method provided above, please refer to the corresponding description of the embodiment of the data proxy method for reading the content of this embodiment. The device embodiments described below are merely illustrative.

The application provides a device for realizing data proxy, comprising:

a data service access request transmitting unit 301 for transmitting a request for accessing a data service to a data service provider;

a service logic receiving unit 302, configured to receive a service logic corresponding to the data service returned by the data service provider;

a selected data service submitting unit 303 configured to submit the selected data service selected based on the service logic to the data service provider;

a data operation instruction receiving unit 304, configured to receive a data operation instruction corresponding to the selected data service returned by the data service provider;

a data operation instruction forwarding unit 305, configured to send the data operation instruction to a proxy server of user data;

a user data receiving unit 306, configured to receive user data corresponding to the data operation instruction sent by the proxy server.

Optionally, the proxy server is deployed in the user lan.

Optionally, the data operation instruction includes: SQL query statements.

Optionally, the data proxy apparatus is implemented based on a browser; correspondingly, the proxy server comprises: an HTTP proxy server; the service logic includes: and the HTML code corresponding to the data service provided by the data service.

The embodiment of the data proxy method based on the data provider provided by the application is as follows:

in the above embodiments, a data proxy method is provided, and in addition, the present application also provides a data proxy method based on a data provider, which is cooperated with the data proxy method provided above, and is cooperated with a data proxy method based on a proxy server provided below, and the following description is provided with reference to the accompanying drawings.

Referring to fig. 4, it shows a process flow diagram of an embodiment of the data proxy method based on the data provider provided in the present application, and referring to fig. 2, it shows a schematic diagram of a data proxy interaction manner provided in the present application.

Since the data proxy method based on the data provider provided currently is matched with the data proxy method embodiment provided above, and is matched with the data proxy method embodiment based on the proxy server provided below, please refer to the corresponding descriptions of the resource arranging method embodiment provided above and the data proxy method embodiment based on the proxy server described below for reading the contents of this embodiment. The method embodiments described below are merely illustrative.

Step S401, receiving a request for accessing a data service sent by a client.

In the data proxy scenario, the data proxy system comprises three roles of a data service provider providing data services, a client accessing the data services provided by the data service provider, and a proxy server for user data, and data proxy is realized through the cooperation of the three roles. The data proxy method based on the data provider is realized based on a data server providing data service.

In this step, a request for accessing the data service provided by the data server, which is sent by the browser, is received. For example, as shown in fig. 2, the data server provides a report making service to the outside through the public network, when the user accesses the report making service, the web page of the data server providing the report making service is opened through the browser, and the data server receives a request sent by the browser to access the report making service.

Step S402, sending the service logic corresponding to the data service to the client.

The step S401 receives a request for accessing the data service provided by the data server sent by the browser, and after receiving the request for accessing the data service provided by the data server, the data server sends the service logic corresponding to the data service to the browser. For example, as shown in fig. 2, after receiving a request for accessing a report making service, a data server obtains relevant information of the report making service, generates an HTML code corresponding to a webpage of the report making service by rendering the obtained relevant information, and sends the generated HTML code to a browser.

Step S403, receiving the selected data service selected based on the service logic, submitted by the client.

In this step, the selected data service of the user submitted by the browser is received on the basis that the service logic corresponding to the data service is sent to the browser in the step S402. For example, as shown in FIG. 2, a selected reporting service selected by a user based on the relevant content of the reporting service presented on the browser front-end page is received.

Step S404, reading a data operation instruction corresponding to the selected data service in a pre-stored data operation instruction set.

In practical application, when a user uses a data service provided by the data server through a browser, the user needs to frequently enter a platform of the data service to perform corresponding data operation and perform customized data operation according to own needs or business needs, so that the data operation instruction is stored on the data server providing the data service, and the data operation instruction is used for performing corresponding data operation according to the data service provided by the data server. The data operation instruction comprises: SQL query statements. It should be noted that the data operation instruction is not limited to the SQL query statement provided above, and in addition, the data operation instruction may also be an operation instruction for data operation other than the SQL query statement.

In the step S403, the selected data service selected based on the service logic and submitted by the browser is received, and in this step, the data operation instruction corresponding to the selected data service selected by the user is read in the data operation instruction set. For example, as shown in fig. 2, after receiving the report making service selected by the user and submitted by the browser, the SQL query statement corresponding to the selected report making service currently selected by the user is read from the SQL query statement set stored in the data server by the user in advance.

In addition, in order to improve network security and prevent network sniffing, in a specific implementation, after the data operation instruction corresponding to the selected data service selected by the user is read in the data operation instruction set, the data operation instruction may be encrypted by using a preset encryption manner. Wherein, the preset encryption mode comprises: symmetric encryption and asymmetric encryption.

Step S405, sending the read data operation instruction to the client.

In this step, the data operation instruction corresponding to the selected data service obtained in step S404 is sent to the browser. For example, as shown in fig. 2, the SQL query statement corresponding to the report making service selected by the user is sent to the browser.

As described above, the data operation instruction may also be encrypted in the preset encryption manner, and correspondingly, the data operation instruction corresponding to the selected data service and sent to the browser in this step is a data operation instruction that is sent to the browser and encrypted in the preset encryption manner.

The embodiment of the device for realizing data proxy based on the data provider provided by the application is as follows:

in the foregoing embodiment, a data proxy method based on a data provider is provided, and correspondingly, the present application also provides an apparatus for implementing data proxy based on a data provider, which is described below with reference to the accompanying drawings.

Referring to fig. 5, a schematic diagram of an embodiment of an apparatus for implementing data proxy based on a data provider is shown.

As the embodiment of the present apparatus corresponds to the embodiment of the data proxy method based on the data provider provided above, please refer to the corresponding description of the embodiment of the method for reading the content of the present embodiment. The device embodiments described below are merely illustrative.

The application provides a device based on data provider realizes data agent, includes:

a data service access request receiving unit 501, configured to receive a request for accessing a data service sent by a client;

a service logic sending unit 502, configured to send a service logic of the data service to the client;

a selected data service receiving unit 503, configured to receive a selected data service that is selected based on the service logic and submitted by the client;

a data operation instruction reading unit 504, configured to read a data operation instruction corresponding to the selected data service in a pre-stored data operation instruction set;

and a data operation instruction sending unit 505, configured to send the read data operation instruction to the client.

Optionally, the apparatus for implementing data proxy based on data provider includes:

the data operation instruction encryption unit is used for encrypting the data operation instruction by adopting a preset encryption mode;

correspondingly, the data operation instruction sent by the data operation instruction sending unit 505 is the data operation instruction encrypted by adopting the preset encryption mode; wherein, the preset encryption mode comprises: symmetric encryption and asymmetric encryption.

Optionally, the device for implementing data proxy based on data provider is implemented based on a data server providing data service.

Optionally, the device for implementing data proxy based on data provider operates in the public network.

Optionally, the data operation instruction includes: SQL query statements.

The embodiment of the data proxy method based on the proxy server provided by the application is as follows:

in the above embodiments, a data proxy method and a data proxy method based on a data provider are provided, and in addition, a data proxy method based on a proxy server is provided in the present application, and the data proxy method based on a data provider are cooperated with each other, which is described below with reference to the accompanying drawings.

Referring to fig. 6, it shows a processing flow chart of an embodiment of the data proxy method based on the proxy server provided in the present application, and referring to fig. 2, it shows a schematic diagram of a data proxy interaction manner provided in the present application.

Since the currently provided data proxy method based on the proxy server is matched with the above provided embodiment of the resource arranging method, and is matched with the above provided embodiment of the data proxy method based on the data provider, please refer to the corresponding descriptions of the above provided embodiment of the resource arranging method and the data proxy method based on the data provider for reading the contents of this embodiment. The method embodiments described below are merely illustrative.

Step S601, receiving a data operation instruction sent by the client.

In the data proxy scenario, the data proxy system comprises three roles of a data service provider providing data services, a client accessing the data services provided by the data service provider, and a proxy server for user data, and data proxy is realized through the cooperation of the three roles. The data proxy method based on the proxy server is realized by the proxy server based on user data, namely realized by the HTTP proxy server.

In this step, a data operation instruction sent by the browser is received, that is: and the HTTP proxy server receives a data operation instruction corresponding to the selected data service, which is transmitted to the browser by the data server and forwarded by the browser. For example, as shown in fig. 2, the HTTP proxy server receives the SQL query statement forwarded by the browser and corresponding to the report making service selected by the user.

As described above, the data operation instruction may be sent to the HTTP proxy server after being encrypted in a preset encryption manner, and correspondingly, after receiving the data operation instruction corresponding to the selected data service sent by the browser, the data operation instruction may also be decrypted, where on this basis, the data operation instruction executed in the following step S602 refers to a data operation instruction obtained after decryption.

Step S602, combining the pre-stored user data to execute the data operation instruction, and obtaining the user data corresponding to the data operation instruction.

The user data comprises at least one of: user related data, APIs and static files stored in a user database. It should be noted that the user data is not limited to the three data types, and the user data further includes data other than the three data types according to the change of the actual usage scenario and the adjustment of the data service.

In this embodiment, the user-related data stored in the user database is taken as an example for explanation, and correspondingly, when the HTTP proxy server accesses the user-related data stored in the user database, the HTTP proxy server obtains the required user-related data from the user database by initiating a request to the user database. In addition, an HTTP proxy server of user data is deployed in an internal local area network, data interaction is carried out between the data server and the HTTP proxy server through a browser, and network intercommunication between the data server and the HTTP proxy server is avoided.

In the step S601, a data operation instruction corresponding to the selected data service, which is sent to the browser by the data server and forwarded by the browser, is received, in this step, a corresponding data request is initiated to the user database according to the data operation instruction, and user data corresponding to the data operation instruction is obtained from the user database. For example, as shown in fig. 2, according to the SQL query statement corresponding to the report making service selected by the user, the user data corresponding to the current SQL query statement is obtained from the user database by issuing a request to the user database.

Step S603, sending the user data corresponding to the data operation instruction to the client.

Step S602, based on the data operation instruction, initiates a corresponding data request to the user database, and obtains user data corresponding to the data operation instruction from the user database, and on this basis, this step sends the obtained user data corresponding to the data operation instruction to the browser. For example, as shown in fig. 2, the HTTP proxy server sends user data obtained from the user database to the browser.

The embodiment of the data proxy device based on the proxy server provided by the application is as follows:

in the foregoing embodiment, a data proxy method based on a proxy server is provided, and correspondingly, a data proxy apparatus based on a proxy server is also provided in the present application, which is described below with reference to the accompanying drawings.

Referring to fig. 7, a schematic diagram of an embodiment of a data proxy device based on a proxy server provided in the present application is shown.

As the embodiment of the present apparatus corresponds to the embodiment of the data proxy method based on the proxy server provided above, please refer to the corresponding description of the embodiment of the method for reading the content of the present embodiment. The device embodiments described below are merely illustrative.

The application provides a data agent side device based on proxy server, includes:

a data operation instruction receiving unit 701, configured to receive a data operation instruction sent by a client;

a user data obtaining unit 702, configured to execute the data operation instruction in combination with pre-stored user data, and obtain user data corresponding to the data operation instruction;

a user data sending unit 703, configured to send user data corresponding to the data operation instruction to the client.

Optionally, the user data obtaining unit 702 is specifically configured to initiate a corresponding data request to the user database according to the data operation instruction, and obtain user data corresponding to the data operation instruction from the user database.

Optionally, the data agent apparatus based on the proxy server includes:

the decryption unit is used for decrypting the data operation instruction; accordingly, the data operation instruction in the user data obtaining unit 702 is a data operation instruction obtained after decryption.

Optionally, the data proxy device based on the proxy server is implemented by a proxy server based on user data.

The embodiment of the electronic equipment provided by the application is as follows:

in the foregoing embodiment, a data proxy method is provided, and in addition, the present application also provides an electronic device for implementing the data proxy method, which is described below with reference to the accompanying drawings.

Referring to fig. 8, a schematic diagram of an electronic device provided in this embodiment is shown.

The electronic device provided by the present application is used for implementing the data proxy method provided by the present application, and this embodiment corresponds to the data proxy method embodiment provided above, and please refer to the corresponding description of the data proxy method embodiment provided above for reading the content of this embodiment. The embodiments described below are merely illustrative.

The application provides an electronic device, including:

a memory 801, and a processor 802;

the memory 801 is configured to store computer-executable instructions, and the processor 802 is configured to execute the computer-executable instructions to:

sending a request to access a data service to a data service provider;

sending the data operation instruction to a proxy server of user data;

Optionally, the proxy server is deployed in the user lan.

Optionally, the data operation instruction includes: SQL query statements.

Optionally, the processor 802 executes the computer-executable instructions based on a browser; correspondingly, the proxy server comprises: an HTTP proxy server; the service logic includes: and the HTML code corresponding to the data service provided by the data service.

Another embodiment of an electronic device provided by the present application is as follows:

in the foregoing embodiment, a data proxy method based on a data provider is provided, and in addition, the present application also provides an electronic device for implementing the data proxy method based on the data provider, which is described below with reference to the accompanying drawings.

Referring to fig. 9, a schematic diagram of an electronic device provided in this embodiment is shown.

The electronic device provided by the present application is configured to implement the data proxy method based on the data provider provided by the present application, and this embodiment corresponds to the above-mentioned data proxy method based on the data provider, and please refer to the corresponding description of the above-mentioned data proxy method based on the data provider for reading the content of this embodiment. The embodiments described below are merely illustrative.

The application provides an electronic device, including: a memory 901, and a processor 902;

the memory 901 is configured to store computer-executable instructions, and the processor 902 is configured to execute the computer-executable instructions to:

receiving a request for accessing a data service sent by a client;

sending a service logic corresponding to the data service to the client;

and sending the read data operation instruction to the client.

Optionally, after reading the data operation instruction corresponding to the selected data service in the pre-stored data operation instruction set and executing the data operation instruction, and before sending the read data operation instruction to the client to execute the data operation instruction, the processor 902 is further configured to execute the following computer-executable instructions:

encrypting the data operation instruction by adopting a preset encryption mode;

correspondingly, the read data operation instruction sent by the data operation instruction sending instruction to the client is the data operation instruction encrypted by adopting the preset encryption mode; wherein, the preset encryption mode comprises: symmetric encryption and asymmetric encryption.

Optionally, the processor 902 executes the computer-executable instructions based on a data server providing data services.

Optionally, the data operation instruction includes: SQL query statements.

The third electronic device provided by the application has the following embodiments:

in the foregoing embodiment, a data proxy method based on a proxy server is provided, and in addition, an electronic device for implementing the data proxy method based on the proxy server is also provided in the present application, which is described below with reference to the accompanying drawings.

Referring to fig. 10, a schematic diagram of an electronic device provided in this embodiment is shown.

The electronic device provided by the present application is used for implementing the data proxy method based on the proxy server provided by the present application, and this embodiment corresponds to the above-mentioned data proxy method based on the proxy server, and please refer to the corresponding description of the above-mentioned data proxy method based on the proxy server for reading the contents of this embodiment. The embodiments described below are merely illustrative.

The application provides an electronic device, including:

a memory 10-01, and a processor 10-02;

the memory 10-01 is configured to store computer-executable instructions, and the processor 10-02 is configured to execute the computer-executable instructions to:

receiving a data operation instruction sent by a client;

Optionally, after the data operation instruction sent by the receiving client is executed, and before the data operation instruction is executed in combination with the pre-stored user data to obtain the user data instruction corresponding to the data operation instruction, and the processor 10-02 is further configured to execute the following computer-executable instruction:

decrypting the data operation instruction;

correspondingly, the data operation instruction is executed by combining the pre-stored user data, the user data instruction corresponding to the data operation instruction is obtained, and the executed data operation instruction is the data operation instruction obtained after decryption.

Optionally, the processor 10-02 executes the computer-executable instructions based on a proxy server for user data.

The embodiment of the database proxy system based on big data provided by the application is as follows:

in the above embodiments, a data proxy device, a device for implementing data proxy based on a data provider, and a data proxy device based on a proxy server are provided, and in addition, the present application also provides a database proxy system based on big data, and the database proxy system based on big data includes the data proxy device, the device for implementing data proxy based on a data provider, and the data proxy device based on a proxy server, which will be described below with reference to the attached drawings. Referring to fig. 11, a flow chart of a process of an embodiment of a big data based database proxy system provided by the present application is shown.

Since the embodiment of the big data based database proxy system provided currently includes the data proxy apparatus, the apparatus for implementing data proxy based on data provider, and the data proxy apparatus based on proxy server provided above, please refer to the corresponding descriptions of the embodiment of the data proxy apparatus, the embodiment of the apparatus for implementing data proxy based on data provider, and the embodiment of the data proxy apparatus based on proxy server provided above for reading the contents of this embodiment. The system embodiments described below are merely illustrative.

The big data-based database proxy system provided by the application comprises: the system comprises a client 11-01, a database proxy server 11-02, a user database 11-03 and a data server 11-04 for providing data services by a data provider;

wherein, the client 11-01 sends a request of a user for accessing the data service to the data server 11-04, the data server 11-04 returns a service logic corresponding to the data service to the client 11-01, the client 11-01 submits a selected data service selected based on the service logic to the data server 11-04, the data server 11-04 reads a data operation instruction corresponding to the selected data service in a pre-stored data operation instruction set and sends the read data operation instruction to the client 11-01, and when the client 11-01 performs data operation based on the received data operation instruction, the client obtains user data by sending the data operation instruction to the database proxy server 11-02, the database proxy server 11-02 executes the data operation instruction in combination with the user database 11-03 storing user data, obtains the user data corresponding to the data operation instruction from the user database 11-03, and sends the user data to the client 11-01 as a data basis for data operation of the user at the client 11-01.

Optionally, the database proxy server 11-02 is deployed in a user lan.

Optionally, the user data is stored in a user database 11-03, and the user database 11-03 is deployed in the user lan.

Optionally, the database proxy server 11-02 and the user database 11-03 are deployed in the same user lan.

Optionally, the data server 11-04 provides data services through a public network.

Optionally, the user data includes at least one of: user related data, APIs and static files stored in the user database 11-03.

Optionally, the data operation instruction includes: SQL query statements.

Optionally, the client includes: a browser;

the database proxy server 11-02 includes: an HTTP proxy server;

the service logic includes: and HTML codes corresponding to the data services.

Although the present application has been described with reference to the preferred embodiments, it is not intended to limit the present application, and those skilled in the art can make variations and modifications without departing from the spirit and scope of the present application, therefore, the scope of the present application should be determined by the claims that follow.

In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.

Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include non-transitory computer readable media (transient media), such as modulated data signals and carrier waves.

As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

Claims

1. A data proxy method, comprising:

sending a request to access a data service to a data service provider;

sending the data operation instruction to a proxy server of user data;

receiving user data corresponding to the data operation instruction sent by the proxy server;

the data service provider is isolated from the proxy server for the user data to avoid direct access to the user data by the data service provider.

2. The data brokering method of claim 1, wherein said proxy server is deployed within a user's local area network.

3. The data brokering method of claim 2, wherein said user data is stored in a user database, and said user database is deployed within said user local area network.

4. The data brokering method of claim 3, wherein said proxy server and said subscriber database are deployed within the same subscriber lan.

5. The data brokering method of claim 1, wherein said data service provider provides data services over a public network.

6. The data brokering method of claim 1, wherein said user data comprises at least one of:

user related data, APIs and static files stored in a user database.

7. The data agent method of claim 1, wherein the data manipulation instruction comprises:

SQL query statements.

8. The data proxy method of claim 7, wherein the data operation command is data encrypted by a preset encryption method;

wherein, the preset encryption mode comprises: symmetric encryption and asymmetric encryption.

9. The data brokering method of any one of claims 1 to 8, wherein said data brokering method is implemented on the basis of a browser;

correspondingly, the proxy server comprises: an HTTP proxy server;

the service logic includes: and HTML codes corresponding to the data services.

10. The data proxy method of claim 9 wherein the data manipulation instruction is sent to the proxy server by invoking an Ajax interface of the browser.

11. An apparatus for implementing a data broker, comprising:

the user data receiving unit is used for receiving user data corresponding to the data operation instruction sent by the proxy server;

12. A data proxy method based on a data provider, comprising:

receiving a request for accessing a data service sent by a client;

sending service logic of the data service to the client;

sending the read data operation instruction to the client;

13. The data proxy method based on the data provider according to claim 12, wherein after the step of reading the data operation instruction corresponding to the selected data service in the pre-stored data operation instruction set is executed and before the step of sending the read data operation instruction to the client is executed, the following steps are executed:

encrypting the data operation instruction by adopting a preset encryption mode;

correspondingly, the read data operation instruction sent by the step of sending the data operation instruction to the client is the data operation instruction encrypted by adopting the preset encryption mode;

14. The data provider-based data brokering method according to claim 12 or 13, wherein said data provider-based data brokering method is implemented based on a data server providing data services.

15. An apparatus for implementing data proxy based on data provider, comprising:

the data operation instruction sending unit is used for sending the read data operation instruction to the client;

16. A data proxy method based on proxy server is characterized by comprising the following steps:

receiving a data operation instruction sent by a client;

sending user data corresponding to the data operation instruction to the client;

the data operation instruction is a corresponding data operation instruction returned by the data service provider according to the data service selected by the client; the selected data service is selected by the client according to service logic provided by the data service provider; the service logic is corresponding to the service logic returned by the data service provider according to the data service request sent by the client;

17. The proxy server-based data proxy method of claim 16, wherein the user data comprises at least one of:

user related data, APIs and static files stored in a user database.

18. The proxy server-based data proxy method of claim 17, wherein the user data is stored in the user database, and the user database is deployed within a user local area network.

19. The data proxy method based on the proxy server of claim 17, wherein the data operation command is executed in combination with pre-stored user data to obtain the user data corresponding to the data operation command, and the method is implemented as follows:

20. The data proxy method based on the proxy server of claim 16, wherein after the step of receiving the data operation command sent by the client is executed, and before the step of executing the data operation command by combining the pre-stored user data and obtaining the user data corresponding to the data operation command is executed, the following steps are executed:

decrypting the data operation instruction;

21. The proxy-based data proxy method of any one of claims 16 to 20, wherein the proxy-based data proxy method is implemented as a proxy based on user data.

22. A data proxy device based on a proxy server, comprising:

the user data sending unit is used for sending user data corresponding to the data operation instruction to the client;

23. An electronic device, comprising:

a memory, and a processor;

sending a request to access a data service to a data service provider;

sending the data operation instruction to a proxy server of user data;

24. An electronic device, comprising:

a memory, and a processor;

receiving a request for accessing a data service sent by a client;

sending service logic of the data service to the client;

sending the read data operation instruction to the client;

25. An electronic device, comprising:

a memory, and a processor;

receiving a data operation instruction sent by a client;

26. A big data based database proxy system, comprising:

wherein, the client sends a request of a user for accessing the data service to the data server, the data server returns a service logic corresponding to the data service to the client, the client submits a selected data service selected based on the service logic to the data server, the data server reads a data operation instruction corresponding to the selected data service in a pre-stored data operation instruction set and sends the read data operation instruction to the client, the client acquires user data by sending the data operation instruction to the database proxy server when performing data operation based on the received data operation instruction, the database proxy server executes the data operation instruction by combining with the user database storing the user data, and acquires the user data corresponding to the data operation instruction from the user database, sending the user data to the client as a data basis for data operation of the user at the client;