Data sharing method, device and system
By using the query instructions of the target mapping table to read the metadata cluster connection information in a multi-tenant cloud computing environment, data sharing is realized, data isolation and collaboration efficiency problems are solved, and a safe and efficient data sharing mechanism is provided.
Patent Information
- Application Number
- CN202411390680.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-08
- Publication Date
- 2024-12-31
- Estimated Expiration
- 2044-10-08
AI Technical Summary
In a cloud computing environment with multi-tenant architecture, there is a lack of an effective data sharing mechanism, which limits data liquidity and collaboration among tenants.
Through the query instructions of the target mapping table, the metadata cluster connection information related to the target sharing table is read from the shared terminal, and the target data information is read from the target metadata cluster based on this information, realizing data sharing, ensuring data isolation and tenant There are processing permissions between them.
It provides a secure, efficient and flexible data sharing mechanism, allowing tenants to realize real-time or snapshot sharing of data while maintaining data isolation, improving data availability and collaboration between tenants.
Smart Images

Figure CN118972403B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer and cloud computing technology, and more specifically, to a data sharing method, device and system. Background Art
[0002] With the development of cloud computing technology, data management systems with multi-tenant architecture are becoming more and more common. In this architecture, data isolation between different tenants is the mainstream to ensure security. However, in this scenario, the relevant systems usually lack an effective data sharing mechanism, which limits the mobility of data and collaboration between tenants. Summary of the invention
[0003] In view of this, the present invention provides a data sharing method, device and system.
[0004] One aspect of the present invention provides a method for reading target metadata cluster connection information related to a target sharing table from a sharing terminal in response to a query instruction for a target mapping table, wherein the target mapping table represents a mapping representation of a target sharing table shared by the sharing terminal, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal and the data managed by the shared terminal that responds to the query instruction, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal; in response to obtaining the target metadata cluster connection information, according to the target metadata cluster connection information, the target sharing table metadata information of the target sharing table is read from the target metadata cluster, wherein the target sharing table metadata information includes the target row / column attribute information and the target cloud storage cluster connection information of the target cloud storage cluster for storing the target data information; and in response to obtaining the target sharing table metadata information, according to the target row / column attribute information, the target data information is read from the target cloud storage cluster to obtain a query result related to the query instruction.
[0005] Another aspect of the present invention provides a data sharing method, comprising: generating a target sharing information record in response to a sharing instruction for a target sharing table; and sending the target sharing information record to a sharing terminal for storage, so that the shared terminal responds to a query instruction for a target mapping table, executes the data sharing method of the present invention, and obtains a query result, wherein the target mapping table represents a mapping representation of the target sharing table, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include target row / column attribute information and target data information, there is data isolation between the data managed by the sharing terminal that responds to the sharing instruction and the data managed by the shared terminal, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal.
[0006] Another aspect of the present invention provides a data sharing device, including: a connection information reading module, which is used to respond to a query instruction for a target mapping table and read target metadata cluster connection information related to a target sharing table from a sharing terminal, wherein the target mapping table represents a mapping representation of a target sharing table shared by the sharing terminal, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal and the data managed by the shared terminal that responds to the query instruction, and the shared terminal is The sharing terminal and the sharing terminal both have processing authority for the data managed by the sharing terminal; a metadata information reading module, used to respond to obtaining the target metadata cluster connection information, and read the target sharing table metadata information of the target sharing table from the target metadata cluster according to the target metadata cluster connection information, wherein the target sharing table metadata information includes the target row / column attribute information and the target cloud storage cluster connection information of the target cloud storage cluster for storing the target data information; and a data information reading module, used to respond to obtaining the target sharing table metadata information, and read the target data information from the target cloud storage cluster according to the target row / column attribute information to obtain the query result related to the query instruction.
[0007] Another aspect of the present invention provides a data sharing device, including: a sharing information record generation module, used to generate a target sharing information record in response to a sharing instruction for a target sharing table; and a sharing information record storage module, used to send the target sharing information record to a sharing terminal for storage, so that the shared terminal responds to a query instruction for a target mapping table, executes the method executed by the data sharing device of the present invention, and obtains a query result, wherein the target mapping table represents a mapping representation of the target sharing table, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include target row / column attribute information and target data information, there is data isolation between the data managed by the sharing terminal that responds to the sharing instruction and the data managed by the shared terminal, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal.
[0008] Another aspect of the present invention provides a data sharing system, comprising: a sharing terminal, for generating a target data information sharing record in response to a sharing instruction for a target sharing table; a sharing terminal, for storing the target data information sharing record; a shared terminal, for reading target metadata cluster connection information related to the target sharing table from the sharing terminal in response to a query instruction for a target mapping table; in response to obtaining the target metadata cluster connection information, reading target sharing table metadata information of the target sharing table from the target metadata cluster according to the target metadata cluster connection information, wherein the target sharing table metadata information includes target row / column attribute information of the target sharing table and target cloud storage cluster connection information of the target cloud storage cluster, The target cloud storage cluster is used to store target data information in a target sharing table, the target data information represents the value of target row / column attribute information; and in response to obtaining metadata information of the target sharing table, the target data information is read from the target cloud storage cluster according to the target row / column attribute information to obtain query results related to the query instruction; and a cloud storage cluster is used to store target data information; wherein, the target mapping table represents a mapping representation of the target sharing table, the target mapping table has the same table structure as the target sharing table, the target mapping table does not include target row / column attribute information and target data information, there is data isolation between the data managed by the sharing terminal and the data managed by the shared terminal, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal. BRIEF DESCRIPTION OF THE DRAWINGS
[0009] The above and other objects, features and advantages of the present invention will become more apparent through the following description of the embodiments of the present invention with reference to the accompanying drawings, in which:
[0010] Figure 1An exemplary system architecture to which a data sharing method according to an embodiment of the present invention can be applied is shown;
[0011] Figure 2 A flow chart showing a data sharing method applied to a sharing terminal according to an embodiment of the present invention is shown;
[0012] Figure 3 A flow chart showing a data sharing method applied to a shared terminal according to an embodiment of the present invention is shown;
[0013] Figure 4 A schematic diagram of a data sharing system according to an embodiment of the present invention is shown;
[0014] Figure 5 A block diagram showing a data sharing device applied to a shared terminal according to an embodiment of the present invention is shown;
[0015] Figure 6 A block diagram showing a data sharing device applied to a sharing terminal according to an embodiment of the present invention; and
[0016] Figure 7 A block diagram of an electronic device suitable for implementing a data sharing method according to an embodiment of the present invention is shown. DETAILED DESCRIPTION
[0017] Below, embodiments of the present invention will be described with reference to the accompanying drawings. However, it should be understood that these descriptions are exemplary only and are not intended to limit the scope of the present invention. In the following detailed description, for ease of explanation, many specific details are set forth to provide a comprehensive understanding of embodiments of the present invention. However, it is apparent that one or more embodiments may also be implemented without these specific details. In addition, in the following description, descriptions of known structures and technologies are omitted to avoid unnecessary confusion of concepts of the present invention.
[0018] The terms used herein are only for describing specific embodiments and are not intended to limit the present invention. The terms "comprise", "include", etc. used herein indicate the existence of the features, steps, operations and / or components, but do not exclude the existence or addition of one or more other features, steps, operations or components.
[0019] All terms (including technical and scientific terms) used herein have the meanings commonly understood by those skilled in the art unless otherwise defined. It should be noted that the terms used herein should be interpreted as having a meaning consistent with the context of this specification and should not be interpreted in an idealized or overly rigid manner.
[0020] When using expressions such as "at least one of A, B, and C, etc.", they should generally be interpreted according to the meaning of the expression commonly understood by those skilled in the art (for example, "a system having at least one of A, B, and C" should include but is not limited to a system having A alone, B alone, C alone, A and B, A and C, B and C, and / or A, B, C, etc.).
[0021] In the embodiments of the present invention, the collection, updating, analysis, processing, use, transmission, provision, disclosure, storage, etc. of the data involved (for example, including but not limited to user personal information) are in compliance with the provisions of relevant laws and regulations, are used for legitimate purposes, and do not violate public order and good morals. In particular, necessary measures are taken for user personal information to prevent illegal access to user personal information data and maintain information security.
[0022] In the embodiment of the present invention, before obtaining or collecting the user's personal information, the user's authorization or consent is obtained.
[0023] An embodiment of the present invention provides a data sharing method, device and system, the method comprising: in response to a query instruction for a target mapping table, reading target metadata cluster connection information related to the target sharing table from a sharing terminal, wherein the target mapping table represents a mapping representation of the target sharing table shared by the sharing terminal, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, the data managed by the sharing terminal and the data managed by the shared terminal that responds to the query instruction are There is data isolation between the shared terminals and the sharing terminals, and both the shared terminals and the sharing terminals have processing permissions for the data managed by the sharing terminals; in response to obtaining the target metadata cluster connection information, according to the target metadata cluster connection information, the target sharing table metadata information of the target sharing table is read from the target metadata cluster, wherein the target sharing table metadata information includes target row / column attribute information and target cloud storage cluster connection information of the target cloud storage cluster for storing the target data information; and in response to obtaining the target sharing table metadata information, according to the target row / column attribute information, the target data information is read from the target cloud storage cluster to obtain the query result related to the query instruction.
[0024] Figure 1 An exemplary system architecture 100 to which a data sharing method according to an embodiment of the present invention can be applied is shown. It should be noted that: Figure 1 The examples shown are merely examples of system architectures to which the embodiments of the present invention may be applied, to help those skilled in the art understand the technical content of the present invention, but do not mean that the embodiments of the present invention may not be used in other devices, systems, environments or scenarios.
[0025] like Figure 1 As shown, the system architecture 100 according to this embodiment may include a first terminal device 101, a second terminal device 102, a third terminal device 103, a network 104, and a server 105. The network 104 is used to provide a medium for a communication link between the first terminal device 101, the second terminal device 102, the third terminal device 103, and the server 105. The network 104 may include various connection types, such as wired and / or wireless communication links, etc.
[0026] The user may use the first terminal device 101, the second terminal device 102, and the third terminal device 103 to interact with the server 105 through the network 104 to receive or send messages, etc. Various communication client applications may be installed on the first terminal device 101, the second terminal device 102, and the third terminal device 103, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients, and / or social platform software, etc. (only for example).
[0027] The first terminal device 101, the second terminal device 102, and the third terminal device 103 may be various electronic devices having display screens and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, desktop computers, and the like.
[0028] The server 105 may be a server that provides various services, such as a background management server (only as an example) that provides support for websites browsed by users using the first terminal device 101, the second terminal device 102, and the third terminal device 103. The background management server may analyze and process the received data such as user requests, and feed back the processing results (such as web pages, information, or data obtained or generated according to user requests) to the terminal device.
[0029] It should be noted that the data sharing method provided in the embodiment of the present invention can generally be executed by the server 105. Accordingly, the data sharing device and / or system provided in the embodiment of the present invention can generally be set in the server 105. The data sharing method provided in the embodiment of the present invention can also be executed by a server or server cluster that is different from the server 105 and can communicate with the first terminal device 101, the second terminal device 102, the third terminal device 103 and / or the server 105. Correspondingly, the data sharing device and / or system provided in the embodiment of the present invention can also be set in a server or server cluster that is different from the server 105 and can communicate with the first terminal device 101, the second terminal device 102, the third terminal device 103 and / or the server 105. Alternatively, the data sharing method provided in the embodiment of the present invention can also be executed by the first terminal device 101, the second terminal device 102, or the third terminal device 103, or can also be executed by other terminal devices different from the first terminal device 101, the second terminal device 102, or the third terminal device 103. Accordingly, the data sharing device and / or system provided by the embodiment of the present invention may also be arranged in the first terminal device 101, the second terminal device 102, or the third terminal device 103, or in other terminal devices different from the first terminal device 101, the second terminal device 102, or the third terminal device 103.
[0030] For example, the target mapping table or the target sharing table may be originally stored in any one of the first terminal device 101, the second terminal device 102, or the third terminal device 103 (for example, the first terminal device 101, but not limited thereto), or may be stored on an external storage device and may be imported into the first terminal device 101. Then, the first terminal device 101 may locally execute the data sharing method provided by the embodiment of the present invention, or send the target mapping table or the target sharing table to other terminal devices, servers, or server clusters, and the other terminal devices, servers, or server clusters that receive the target mapping table or the target sharing table may execute the data sharing method provided by the embodiment of the present invention.
[0031] It should be understood that Figure 1 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.
[0032] Figure 2 A flow chart of a data sharing method applied to a sharing terminal according to an embodiment of the present invention is shown.
[0033] like Figure 2 As shown, the method includes operations S201~S202.
[0034] In operation S201 , in response to a sharing instruction for a target sharing table, a target sharing information record is generated.
[0035] According to an embodiment of the present invention, the target sharing table may represent part of the data to be shared by the sharing terminal, and the part of the data may be shared in the form of a table, a key-value, etc., and may not be limited thereto. The sharing instruction may represent an instruction for the sharing terminal to share the target sharing table to the shared terminal. The target sharing information record may include a record of identification information of the target sharing table, the sharing terminal, the shared terminal, etc.
[0036] In operation S202, the target sharing information record is sent to the sharing terminal for storage, so that the shared terminal responds to the query instruction for the target mapping table, executes the data sharing method, and obtains the query result, wherein the target mapping table represents the mapping representation of the target sharing table, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal that responds to the sharing instruction and the data managed by the shared terminal, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal.
[0037] According to an embodiment of the present invention, a sharing terminal and a shared terminal can represent any two storage spaces with data isolation, for example, different virtual spaces occupied by different tenants in the same terminal can be included, or different terminals can be represented, which is not limited here. The sharing terminal can be a part of the sharing terminal, or a part of the shared terminal, or other terminals independent of the sharing terminal and the shared terminal, as long as the sharing terminal and the shared terminal can access the internal data of the sharing terminal. The sharing terminal, the shared terminal and the sharing terminal can all be implemented using various electronic devices such as smart phones, tablet computers, laptops, desktop computers and other electronic devices with data storage functions.
[0038] According to an embodiment of the present invention, the target sharing table may not be directly shared to the shared terminal, but a target mapping table obtained by mapping the target sharing table is created in the shared terminal to express that the shared terminal can read the relevant information of the target sharing table based on the query instruction constructed for the target mapping table to realize data query. The mapping table may not have row / column attribute information, data information and other information, and actually only records at least one of the table name, library name, table id, library id and other basic information of the mapping table, such as the index used to locate the target sharing information record. The sharing table may record other row / column attribute information, data information and the like, and is not limited to this.
[0039] For example, users can create data sharing based on sharing devices to initiate sharing tasks. In the process of creating data sharing, the system can first verify the sharing permissions, table types and attributes. For example, data without sharing permissions and encrypted tables, mapping tables, temporary tables, etc. cannot be shared as sharing tables to ensure that only legal and shareable tables are shared. Then, users can use corresponding operations to choose to share the sharing table as a snapshot or share it with other tenants in the form of real-time data, and generate corresponding sharing instructions. The visibility of data is determined by the transaction id. Therefore, when creating data sharing, the table name, table id, transaction id representing the version number of the current data, sharing terminal id, shared terminal id and other sharing information records of the sharing table can be recorded, and it is not limited to this, so that the actual data can be read based on the sharing information record. When creating data sharing, you only need to store the above-mentioned sharing information records in a sharing terminal that can be accessed by both the sharing terminal and the shared terminal, and the shared terminal can create a mapping table and read the data.
[0040] According to an embodiment of the present invention, the sharing terminal may further include: in response to detecting that the sharing table has been generated in the sharing terminal, generating sharing table metadata information according to the row / column attribute information of the sharing table. Sending the sharing table metadata information to the metadata cluster for storage. Sending the data information of the sharing table to the cloud storage cluster for storage.
[0041] According to an embodiment of the present invention, the metadata cluster may provide metadata cluster connection information, which may include the cluster ID of the metadata cluster and information such as an account number and password for supporting access to the metadata cluster or other information capable of obtaining access rights to the metadata cluster, and may not be limited thereto. After obtaining the metadata cluster connection information, the shared terminal may obtain access rights to the metadata cluster and may perform processing such as reading and writing on the data managed by the metadata cluster.
[0042] According to an embodiment of the present invention, the cloud storage cluster may provide cloud storage cluster connection information, which may include the cluster ID of the cloud storage cluster and information such as an account number and password for supporting access to the cloud storage cluster or other information capable of obtaining access rights to the cloud storage cluster, and may not be limited thereto. After obtaining the cloud storage cluster connection information, the shared terminal may obtain access rights to the cloud storage cluster and may perform processing such as reading and writing on the data managed by the cloud storage cluster.
[0043] According to an embodiment of the present invention, the sharing table metadata information may represent information of key fields in the sharing table, such as table ID, transaction ID, etc., and may also include cloud storage cluster connection information of a cloud storage cluster used to store data in the sharing table. The sharing table metadata information may be adaptively determined according to business needs, but is not limited thereto.
[0044] According to an embodiment of the present invention, the shared terminal may include: in response to detecting that a sharing information record representing that the sharing terminal shares the sharing table to the shared terminal has been generated in the sharing terminal, according to the sharing information record, constructing a mapping table having the same table structure as the sharing table in the shared terminal. In response to detecting that the mapping table has been generated, generating mapping table metadata information.
[0045] According to an embodiment of the present invention, the sharing information record may further include metadata cluster connection information, which may be used to locate the metadata cluster storing the metadata information of the sharing table. The shared terminal may create a mapping table based on the sharing information record. For example, a mapping table may be created based on index information created for the sharing information record. A mapping table may also be created based on the sharing information record itself. It is sufficient to ensure that the created mapping table is consistent with the sharing table in terms of table structure and column type.
[0046] According to an embodiment of the present invention, the mapping table metadata information can be directly determined based on the information of the mapping table. The mapping table metadata information can represent the information of the more critical fields in the mapping table, such as at least one of the table name, table ID, library name, library ID, etc. of the mapping table, and information such as an index for locating the target sharing information record. The mapping table metadata information can be adaptively determined according to business needs, but is not limited thereto.
[0047] Figure 3 A flow chart of a data sharing method applied to a shared terminal according to an embodiment of the present invention is shown.
[0048] like Figure 3 As shown, the method includes operations S301 to S303.
[0049] In operation S301, in response to a query instruction for a target mapping table, target metadata cluster connection information related to the target sharing table is read from a sharing terminal, wherein the target mapping table represents a mapping representation of the target sharing table shared by the sharing terminal, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal and the data managed by the shared terminal that responds to the query instruction, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal.
[0050] According to an embodiment of the present invention, the target metadata cluster connection information associated with the target sharing table may be pre-stored in the sharing terminal, so that the target metadata cluster connection information may be directly read in response to a query instruction for the target mapping table.
[0051] In operation S302, in response to obtaining the target metadata cluster connection information, the target sharing table metadata information of the target sharing table is read from the target metadata cluster according to the target metadata cluster connection information, wherein the target sharing table metadata information includes target row / column attribute information and target cloud storage cluster connection information of the target cloud storage cluster for storing the target data information.
[0052] In operation S303, in response to obtaining the target sharing table metadata information, target data information is read from the target cloud storage cluster according to the target row / column attribute information to obtain a query result related to the query instruction.
[0053] According to an embodiment of the present invention, the row / column attribute information and data information of the mapping table can be directly associated with the row / column attribute information and data information of the sharing table through the target metadata cluster connection information and the target cloud storage cluster connection information, and will not be recorded in the mapping table metadata information itself. Later, the query of the mapping table can directly query the relevant data of the sharing table, such as the row / column attribute information and data information, with the help of the target metadata cluster connection information and the target cloud storage cluster connection information.
[0054] According to an embodiment of the present invention, the above operation S301 may include: in response to a query instruction for a target mapping table, obtaining target mapping table metadata information of the target mapping table, wherein the target mapping table metadata information includes a target index related to a target sharing information record, and the target sharing information record represents a sharing information record in which the target sharing table is shared by the sharing terminal to the shared terminal. According to the target index, the target sharing information record is read from the sharing terminal. The target sharing information record is parsed to obtain target metadata cluster connection information.
[0055] According to an embodiment of the present invention, the target mapping table metadata information can record the data sharing of which sharing table the corresponding target mapping table actually maps by recording the target index. Therefore, the target sharing information record can be read from the sharing terminal storing the sharing information record according to the information representing the target index in the target mapping table metadata information. It is also possible to search for the record that best matches the target mapping table metadata information in the sharing information records stored in the sharing terminal according to the target mapping table metadata information as the target sharing information record. Afterwards, since the target sharing information record includes the target metadata cluster connection information of the target metadata cluster for storing the target sharing table metadata information. Therefore, the target metadata cluster connection information can be read from the sharing terminal.
[0056] According to an embodiment of the present invention, the target sharing table metadata information also includes at least one version information corresponding to the target row / column attribute information. The above operation S303 may include: parsing the query instruction to determine the target version information to be queried by the query instruction. According to the target version information and the target row / column attribute information, reading the target data information matching the target version information from the target cloud storage cluster.
[0057] According to an embodiment of the present invention, the version information can be present as a field value of the transaction id in the sharing information record and the target sharing table metadata information. When the query instruction is parsed to determine the target version information to be queried, the target data information corresponding to the target row / column attribute information of the corresponding version targeted by this query can be queried in combination with the version information saved during sharing, thereby realizing the query of the shared data actually to be read in the sharing table.
[0058] Through the above-mentioned embodiments of the present invention, a safe, efficient and flexible data sharing mechanism is provided, which allows tenants to achieve real-time or snapshot sharing of data while maintaining data isolation, thereby improving data availability and collaboration efficiency among tenants.
[0059] According to an embodiment of the present invention, the target metadata cluster connection information represents a plurality of metadata clusters, and data isolation exists between the data managed by each of the plurality of metadata clusters.
[0060] According to an embodiment of the present invention, both the sharing terminal and the shared terminal can support simultaneous connection to multiple metadata cluster services, which can be achieved by dynamically creating multiple metadata client connections. In addition, with the help of the tablespace (a logical structure that provides usage space for the database) function, the function of supporting multi-source storage services can be built to realize the reading of data in multiple cloud storage clusters. The service of reading multiple metadata clusters is transparent to the upper-level business, but the dynamic switching client logic is added to the underlying implementation. Users do not need to switch manually, and the client switching can be automatically realized internally, which is transparent to user use. For the information of which metadata cluster service and which table to read, the relevant information can be recorded when the data is shared, and when querying the mapping table, you only need to retrieve the information from the corresponding sharing information record to directly query.
[0061] According to an embodiment of the present invention, the target cloud storage cluster connection information represents multiple cloud storage clusters, and data isolation exists between the data managed by each of the multiple cloud storage clusters.
[0062] According to an embodiment of the present invention, data supports multiple versions, and the data query module supports querying data from multiple cloud storage platforms at the same time. The mapping table implementation can rely on the functional support of multi-version data and multi-source cloud storage platforms.
[0063] For example, if you want to share data in table t1 of a shared terminal on cluster 1, its data is stored on the cloud1 platform. The data of the shared terminal on cluster 2 is stored on the cloud2 platform by default. On cluster 2, the data sharing of table t1 is mapped and a mapping table m1 is created. When users query m1, they can directly query the data of cloud1 in a transparent way without any additional processing by the users, which is consistent with the usage rules of ordinary tables.
[0064] Through the above-mentioned embodiments of the present invention, cross-cluster management and access to shared data can be achieved through shared terminals and multi-data service connection support, thereby improving data availability and collaboration efficiency among tenants.
[0065] According to an embodiment of the present invention, there is further provided a data sharing system, comprising: a sharing terminal, a sharing terminal, a shared terminal and a cloud storage cluster.
[0066] The sharing terminal is used to generate a target sharing information record in response to a sharing instruction for the target sharing table.
[0067] The sharing terminal is used to store target sharing information records.
[0068] The shared terminal is used to respond to a query instruction for a target mapping table and read target metadata cluster connection information related to a target sharing table from a sharing terminal; in response to obtaining the target metadata cluster connection information, read target sharing table metadata information of the target sharing table from the target metadata cluster according to the target metadata cluster connection information, wherein the target sharing table metadata information includes target row / column attribute information of the target sharing table and target cloud storage cluster connection information of a target cloud storage cluster, the target cloud storage cluster is used to store target data information in the target sharing table, and the target data information represents the value of the target row / column attribute information; and in response to obtaining the target sharing table metadata information, read the target data information from the target cloud storage cluster according to the target row / column attribute information to obtain a query result related to the query instruction.
[0069] Cloud storage cluster, used to store target data information.
[0070] Among them, the target mapping table represents the mapping representation of the target sharing table. The target mapping table and the target sharing table have the same table structure. The target mapping table does not include target row / column attribute information and target data information. There is data isolation between the data managed by the sharing terminal and the data managed by the shared terminal. Both the shared terminal and the sharing terminal have processing rights for the data managed by the sharing terminal.
[0071] Figure 4 A schematic diagram of a data sharing system according to an embodiment of the present invention is shown.
[0072] like Figure 4 As shown, the data sharing system 400 includes a sharing terminal 410 , a sharing terminal 420 , a sharing-end metadata cluster 421 , a cloud storage cluster 422 , a shared terminal 430 , and a shared-end metadata cluster 431 .
[0073] According to an embodiment of the present invention, data isolation exists between the sharing terminal 420 and the shared terminal 430. The sharing terminal 420 and the shared terminal 430 both have processing rights for the data managed by the sharing terminal 410. The sharing-end metadata cluster 421 and the cloud storage cluster 422 can be a part of the sharing terminal 420, or a cluster that exists independently of the sharing terminal 420. The shared-end metadata cluster 431 can be a part of the shared terminal 430, or a cluster that exists independently of the shared terminal 430. The sharing-end metadata cluster 421, the cloud storage cluster 422, and the shared-end metadata cluster 431 can also be a part of the sharing terminal 410 and have the same external rights as the sharing terminal 410. The sharing terminal 420 has operation rights for the sharing-end metadata cluster 421 and the cloud storage cluster 422. The shared terminal 430 can obtain processing rights for the sharing-end metadata cluster 421 and the cloud storage cluster 422 only when it obtains the corresponding cluster connection information. The shared terminal 430 has processing rights for the shared-end metadata cluster 431.
[0074] According to an embodiment of the present invention, in the process of creating a sharing task, the sharing terminal 420 may provide a sharing table. Its sharing table metadata information may be sent to the sharing terminal metadata cluster 421 for storage in response to the sharing table being generated. The data information of the sharing table may be sent to the cloud storage cluster 422 for storage. In response to the sharing instruction representing sharing the sharing table to the shared terminal 430, a sharing information record for describing the task of sharing the sharing table to the shared terminal 430 may also be generated, and the sharing information record may be sent to the sharing terminal 410 for storage.
[0075] According to an embodiment of the present invention, in the process of creating a mapping table, the shared terminal 430 can create a mapping table by reading mapping information such as column attributes in the sharing information record when detecting that the sharing terminal 410 has stored a sharing information record in which the shared terminal 430 is a sharee. In response to the mapping table being generated, the mapping table metadata information can be sent to the shared terminal metadata cluster 431 for storage.
[0076] According to an embodiment of the present invention, in the process of creating a query task based on a mapping table, in response to a query instruction for a mapping table generated by a shared terminal 430, the sharing table metadata cluster connection information and the sharing table information can be first read from the sharing information record stored in the sharing terminal 410, and the sharing table metadata cluster connection information, for example, represents the sharing end metadata cluster 421. Then, the cloud storage cluster connection information of the cloud storage cluster for storing the data information of the corresponding sharing table can be read from the sharing table metadata information stored in the sharing end metadata cluster 421, for example, represents the cloud storage cluster 422. Afterwards, the query result that the query instruction wants to query can be read from the cloud storage cluster 422.
[0077] Through the above-mentioned embodiments of the present invention, a system and method for data sharing between tenants in a cloud storage environment are provided through a series of innovative technical means, allowing real-time or snapshot sharing of data between different tenants. The system realizes efficient data sharing by adding sharing terminals, implementing mapping data functions in the cluster and adapting query data. Users can create data sharing, select sharing types, such as real-time or snapshot, and create mapping tables to access shared data. The system also supports multi-data service connections to realize metadata reading across clusters, and shares information through the storage and management of the shared terminal system, which has high practicality and promotion value.
[0078] Figure 5 A block diagram of a data sharing device applied to a shared terminal according to an embodiment of the present invention is shown.
[0079] like Figure 5 As shown, the data sharing device 500 includes a connection information reading module 510 , a metadata information reading module 520 and a data information reading module 530 .
[0080] The connection information reading module 510 is used to respond to a query instruction for a target mapping table and read the target metadata cluster connection information related to the target sharing table from the sharing terminal, wherein the target mapping table represents a mapping representation of the target sharing table shared by the sharing terminal, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal and the data managed by the shared terminal that responds to the query instruction, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal.
[0081] The metadata information reading module 520 is used to respond to obtaining the target metadata cluster connection information and read the target sharing table metadata information of the target sharing table from the target metadata cluster according to the target metadata cluster connection information, wherein the target sharing table metadata information includes target row / column attribute information and target cloud storage cluster connection information of the target cloud storage cluster for storing the target data information.
[0082] The data information reading module 530 is used to respond to obtaining the target sharing table metadata information and read the target data information from the target cloud storage cluster according to the target row / column attribute information to obtain the query result related to the query instruction.
[0083] According to an embodiment of the present invention, the data sharing device further includes a mapping table construction module and a mapping table metadata information generation module.
[0084] The mapping table building module is used to construct a mapping table having the same table structure as the sharing table in the shared terminal according to the sharing information record in response to detecting that a sharing information record representing sharing of the sharing table from the sharing terminal to the shared terminal has been generated in the sharing terminal.
[0085] The mapping table metadata information generating module is used to generate mapping table metadata information in response to detecting that the mapping table has been generated.
[0086] According to an embodiment of the present invention, the connection information reading module includes a mapping table metadata information acquisition unit, a sharing information record reading unit and a record parsing unit.
[0087] A mapping table metadata information acquisition unit is used to obtain target mapping table metadata information of the target mapping table in response to a query instruction for the target mapping table, wherein the target mapping table metadata information includes a target index related to a target sharing information record, and the target sharing information record represents a sharing information record in which the sharing terminal shares the target sharing table to the shared terminal.
[0088] The sharing information record reading unit is used to read the target sharing information record from the sharing terminal according to the target index.
[0089] The record parsing unit is used to parse the target sharing information record to obtain the target metadata cluster connection information.
[0090] According to an embodiment of the present invention, the target sharing table metadata information further includes at least one version information corresponding to the target row / column attribute information. The data information reading module includes an instruction parsing unit and a data information reading unit.
[0091] The instruction parsing unit is used to parse the query instruction and determine the target version information to be queried by the query instruction.
[0092] The data information reading unit is used to read target data information matching the target version information from the target cloud storage cluster according to the target version information and the target row / column attribute information.
[0093] According to an embodiment of the present invention, the target metadata cluster connection information represents a plurality of metadata clusters, and data isolation exists between the data managed by each of the plurality of metadata clusters.
[0094] According to an embodiment of the present invention, the target cloud storage cluster connection information represents multiple cloud storage clusters, and data isolation exists between the data managed by each of the multiple cloud storage clusters.
[0095] Figure 6 A block diagram of a data sharing device applied to a sharing terminal according to an embodiment of the present invention is shown.
[0096] like Figure 6 As shown, the data sharing device 600 includes a sharing information record generating module 610 and a sharing information record storing module 620 .
[0097] The sharing information record generating module 610 is used to generate a target sharing information record in response to a sharing instruction for a target sharing table.
[0098] The sharing information record storage module 620 is used to send the target sharing information record to the sharing terminal for storage, so that the shared terminal can respond to the query instruction for the target mapping table, execute the data sharing method, and obtain the query result, wherein the target mapping table represents the mapping representation of the target sharing table, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal that responds to the sharing instruction and the data managed by the shared terminal, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal.
[0099] According to an embodiment of the present invention, the data sharing device further includes a sharing table metadata information generation module, a sharing table metadata information storage module and a sharing table data information storage module.
[0100] The sharing table metadata information generating module is configured to generate sharing table metadata information according to row / column attribute information of the sharing table in response to detecting that the sharing table has been generated in the sharing terminal.
[0101] The sharing table metadata information storage module is used to send the sharing table metadata information to the metadata cluster for storage.
[0102] The sharing table data information storage module is used to send the sharing table data information to the cloud storage cluster for storage.
[0103] According to the embodiments of the present invention, any multiple of the modules and units, or at least part of the functions of any multiple of them, can be implemented in one module. According to the embodiments of the present invention, any one or more of the modules and units can be split into multiple modules for implementation. According to the embodiments of the present invention, any one or more of the modules and units can be at least partially implemented as a hardware circuit, such as a field programmable gate array (FPGA), a programmable logic array (PLA), a system on a chip, a system on a substrate, a system on a package, an application-specific integrated circuit (ASIC), or can be implemented by hardware or firmware in any other reasonable way of integrating or packaging the circuit, or implemented in any one of the three implementation methods of software, hardware and firmware, or in any appropriate combination of any of them. Alternatively, according to the embodiments of the present invention, one or more of the modules and units can be at least partially implemented as a computer program module, and when the computer program module is run, the corresponding function can be executed.
[0104] For example, any of the connection information reading module 510, the metadata information reading module 520 and the data information reading module 530, or the sharing information record generation module 610 and the sharing information record storage module 620 can be combined in one module / unit for implementation, or any of the modules / units can be split into multiple modules / units. Alternatively, at least part of the functions of one or more of these modules / units can be combined with at least part of the functions of other modules / units and implemented in one module / unit. According to an embodiment of the present invention, at least one of the connection information reading module 510, the metadata information reading module 520 and the data information reading module 530, or the sharing information record generation module 610 and the sharing information record storage module 620 can be at least partially implemented as a hardware circuit, such as a field programmable gate array (FPGA), a programmable logic array (PLA), a system on a chip, a system on a substrate, a system on a package, an application specific integrated circuit (ASIC), or can be implemented by hardware or firmware such as any other reasonable way of integrating or packaging the circuit, or implemented in any one of the three implementation methods of software, hardware and firmware or in a suitable combination of any of them. Alternatively, the connection information reading module 510, the metadata information reading module 520 and the data information reading module 530, or at least one of the sharing information record generation module 610 and the sharing information record storage module 620 can be at least partially implemented as a computer program module, and when the computer program module is executed, the corresponding function can be executed.
[0105] It should be noted that the data sharing device part in the embodiment of the present invention corresponds to the data sharing method part in the embodiment of the present invention. The description of the data sharing device part specifically refers to the data sharing method part, which will not be repeated here.
[0106] Figure 7 A block diagram of an electronic device suitable for implementing a data sharing method according to an embodiment of the present invention is shown. Figure 7 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.
[0107] like Figure 7 As shown, the electronic device 700 according to an embodiment of the present invention includes a processor 701, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 702 or a program loaded from a storage part 708 to a random access memory (RAM) 703. The processor 701 may include, for example, a general-purpose microprocessor (e.g., a CPU), an instruction set processor and / or a related chipset and / or a special-purpose microprocessor (e.g., an application-specific integrated circuit (ASIC)), etc. The processor 701 may also include an onboard memory for caching purposes. The processor 701 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present invention.
[0108] In RAM 703, various programs and data required for the operation of electronic device 700 are stored. Processor 701, ROM 702 and RAM 703 are connected to each other via bus 704. Processor 701 performs various operations of the method flow according to the embodiment of the present invention by executing the programs in ROM 702 and / or RAM 703. It should be noted that the program can also be stored in one or more memories other than ROM 702 and RAM 703. Processor 701 can also perform various operations of the method flow according to the embodiment of the present invention by executing the programs stored in the one or more memories.
[0109] According to an embodiment of the present invention, the electronic device 700 may further include an input / output (I / O) interface 705, which is also connected to the bus 704. The system 700 may further include one or more of the following components connected to the input / output (I / O) interface 705: an input portion 706 including a keyboard, a mouse, etc.; an output portion 707 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage portion 708 including a hard disk, etc.; and a communication portion 709 including a network interface card such as a LAN card, a modem, etc. The communication portion 709 performs communication processing via a network such as the Internet. A drive 710 is also connected to the input / output (I / O) interface 705 as needed. A removable medium 711, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 710 as needed, so that a computer program read therefrom is installed into the storage portion 708 as needed.
[0110] According to an embodiment of the present invention, the method flow according to an embodiment of the present invention can be implemented as a computer software program. For example, an embodiment of the present invention includes a computer program product, which includes a computer program carried on a computer-readable storage medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 709, and / or installed from the removable medium 711. When the computer program is executed by the processor 701, the above-mentioned functions defined in the system of the embodiment of the present invention are executed. According to an embodiment of the present invention, the system, equipment, device, module, unit, etc. described above can be implemented by a computer program module.
[0111] The present invention also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiment; or may exist independently without being assembled into the device / apparatus / system. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed, the method according to the embodiment of the present invention is implemented.
[0112] According to an embodiment of the present invention, the computer-readable storage medium may be a non-volatile computer-readable storage medium. For example, it may include but is not limited to: a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present invention, the computer-readable storage medium may be any tangible medium containing or storing a program, which may be used by or in combination with an instruction execution system, an apparatus or a device.
[0113] For example, according to an embodiment of the present invention, the computer-readable storage medium may include the ROM 702 and / or the RAM 703 described above and / or one or more memories other than the ROM 702 and the RAM 703 .
[0114] An embodiment of the present invention also includes a computer program product, which includes a computer program, and the computer program contains program code for executing the method provided by the embodiment of the present invention. When the computer program product runs on an electronic device, the program code is used to enable the electronic device to implement the method provided by the embodiment of the present invention.
[0115] When the computer program is executed by the processor 701, the above functions defined in the system / device of the embodiment of the present invention are executed. According to the embodiment of the present invention, the system, device, module, unit, etc. described above can be implemented by a computer program module.
[0116] In one embodiment, the computer program may rely on tangible storage media such as optical storage devices, magnetic storage devices, etc. In another embodiment, the computer program may also be transmitted and distributed in the form of signals on a network medium, and downloaded and installed through the communication part 709, and / or installed from the removable medium 711. The program code contained in the computer program may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the above.
[0117] According to an embodiment of the present invention, the program code for executing the computer program provided by the embodiment of the present invention can be written in any combination of one or more programming languages. Specifically, these computing programs can be implemented using high-level process and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages include, but are not limited to, Java, C++, python, "C" language or similar programming languages. The program code can be executed entirely on the user computing device, partially on the user device, partially on the remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computing device (e.g., using an Internet service provider to connect through the Internet).
[0118] The flowcharts and block diagrams in the accompanying drawings illustrate the possible architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present invention. In this regard, each box in the flowchart or block diagram may represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of the code contains one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box may also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flowchart, and the combination of boxes in the block diagram or flowchart, can be implemented with a dedicated hardware-based system that performs the specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions. It can be understood by those skilled in the art that the features recorded in the various embodiments and / or claims of the present invention can be combined and / or combined in various ways, even if such a combination or combination is not explicitly recorded in the present invention. In particular, without departing from the spirit and teaching of the present invention, the features described in the various embodiments and / or claims of the present invention may be combined and / or combined in a variety of ways. All of these combinations and / or combinations fall within the scope of the present invention.
[0119] The embodiments of the present invention are described above. However, these embodiments are only for the purpose of illustration, and are not intended to limit the scope of the present invention. Although each embodiment is described above, it does not mean that the measures in each embodiment cannot be used in combination. The scope of the present invention is defined by the attached claims and their equivalents. Without departing from the scope of the present invention, those skilled in the art may make various substitutions and modifications, which should all fall within the scope of the present invention.
Claims
1. A data sharing method, characterized in that: The method comprises: In response to a query instruction for a target mapping table, target metadata cluster connection information related to the target sharing table is read from a sharing terminal, wherein the target mapping table represents a mapping representation of the target sharing table shared by the sharing terminal, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal and the data managed by the shared terminal that responds to the query instruction, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal; In response to obtaining the target metadata cluster connection information, reading the target sharing table metadata information of the target sharing table from the target metadata cluster according to the target metadata cluster connection information, wherein the target sharing table metadata information includes the target row / column attribute information and the target cloud storage cluster connection information of the target cloud storage cluster for storing the target data information; and In response to obtaining the target sharing table metadata information, the target data information is read from the target cloud storage cluster according to the target row / column attribute information to obtain a query result related to the query instruction.
2. The method according to claim 1, characterized in that The method further comprises: In response to detecting that a sharing information record indicating that the sharing terminal shares the sharing table to the shared terminal has been generated in the sharing terminal, constructing a mapping table having the same table structure as the sharing table in the shared terminal according to the sharing information record; and In response to detecting that the mapping table has been generated, mapping table metadata information is generated.
3. The method according to claim 1 or 2, characterized in that: The step of reading target metadata cluster connection information related to the target sharing table from the sharing terminal in response to a query instruction for the target mapping table includes: In response to a query instruction for a target mapping table, target mapping table metadata information of the target mapping table is obtained, wherein the target mapping table metadata information includes a target index related to a target sharing information record, and the target sharing information record represents a sharing information record in which the target sharing table is shared by the sharing terminal to the shared terminal; Reading the target sharing information record from the sharing terminal according to the target index; and The target sharing information record is parsed to obtain the target metadata cluster connection information.
4. The method according to claim 1, characterized in that: The target sharing table metadata information also includes at least one version information corresponding to the target row / column attribute information; and reading the target data information from the target cloud storage cluster according to the target row / column attribute information includes: Parsing the query instruction to determine the target version information to be queried by the query instruction; and According to the target version information and the target row / column attribute information, target data information matching the target version information is read from the target cloud storage cluster.
5. The method according to claim 1, characterized in that The target metadata cluster connection information represents a plurality of metadata clusters, and there is data isolation between the data managed by each of the plurality of metadata clusters; and / or The target cloud storage cluster connection information represents a plurality of cloud storage clusters, and data isolation exists between data managed by each of the plurality of cloud storage clusters.
6. A data sharing method, characterized in that: The method comprises: generating a target sharing information record in response to a sharing instruction for the target sharing table; and The target sharing information record is sent to the sharing terminal for storage, so that the shared terminal responds to the query instruction for the target mapping table, executes the method as described in any one of claims 1 to 5, and obtains the query result, wherein the target mapping table represents the mapping representation of the target sharing table, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal that responds to the sharing instruction and the data managed by the shared terminal, and the shared terminal and the sharing terminal both have processing authority for the data managed by the sharing terminal.
7. The method according to claim 6, characterized in that The method further comprises: In response to detecting that the sharing table has been generated in the sharing terminal, generating sharing table metadata information according to row / column attribute information of the sharing table; Sending the sharing table metadata information to a metadata cluster for storage; and The data information of the sharing table is sent to the cloud storage cluster for storage.
8. A data sharing device, characterized in that: The device comprises: A connection information reading module, configured to read target metadata cluster connection information related to a target sharing table from a sharing terminal in response to a query instruction for a target mapping table, wherein the target mapping table represents a mapping representation of the target sharing table shared by the sharing terminal, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal and the data managed by the shared terminal that responds to the query instruction, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal; a metadata information reading module, configured to, in response to obtaining the target metadata cluster connection information, read the target sharing table metadata information of the target sharing table from the target metadata cluster according to the target metadata cluster connection information, wherein the target sharing table metadata information includes the target row / column attribute information and the target cloud storage cluster connection information of the target cloud storage cluster for storing the target data information; and The data information reading module is used to respond to obtaining the target sharing table metadata information and read the target data information from the target cloud storage cluster according to the target row / column attribute information to obtain a query result related to the query instruction.
9. A data sharing device, characterized in that: The device comprises: a sharing information record generating module, configured to generate a target sharing information record in response to a sharing instruction for a target sharing table; and A sharing information record storage module is used to send the target sharing information record to a sharing terminal for storage, so that the shared terminal responds to a query instruction for a target mapping table, executes the method executed by the device as described in claim 8, and obtains a query result, wherein the target mapping table represents a mapping representation of the target sharing table, the target mapping table and the target sharing table have the same table structure, the target sharing table includes target row / column attribute information and target data information representing the value of the target row / column attribute information, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal that responds to the sharing instruction and the data managed by the shared terminal, and both the shared terminal and the sharing terminal have processing authority for the data managed by the sharing terminal.
10. A data sharing system, characterized in that: The system comprises: A sharing terminal, configured to generate a target sharing information record in response to a sharing instruction for a target sharing table; A sharing terminal, used for storing the target sharing information record; The shared terminal is used to respond to a query instruction for a target mapping table, read target metadata cluster connection information related to the target sharing table from the sharing terminal; in response to obtaining the target metadata cluster connection information, read target sharing table metadata information of the target sharing table from the target metadata cluster according to the target metadata cluster connection information, wherein the target sharing table metadata information includes target row / column attribute information of the target sharing table and target cloud storage cluster connection information of a target cloud storage cluster, the target cloud storage cluster is used to store target data information in the target sharing table, the target data information represents the value of the target row / column attribute information; and in response to obtaining the target sharing table metadata information, read the target data information from the target cloud storage cluster according to the target row / column attribute information to obtain a query result related to the query instruction; and A cloud storage cluster, used to store the target data information; Among them, the target mapping table represents the mapping representation of the target sharing table, the target mapping table has the same table structure as the target sharing table, the target mapping table does not include the target row / column attribute information and the target data information, there is data isolation between the data managed by the sharing terminal and the data managed by the shared terminal, and the shared terminal and the sharing terminal both have processing authority for the data managed by the sharing terminal.