CN115757589A - Data exchange and sharing method and device of database and readable storage medium - Google Patents
Data exchange and sharing method and device of database and readable storage medium Download PDFInfo
- Publication number
- CN115757589A CN115757589A CN202211535571.6A CN202211535571A CN115757589A CN 115757589 A CN115757589 A CN 115757589A CN 202211535571 A CN202211535571 A CN 202211535571A CN 115757589 A CN115757589 A CN 115757589A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- information
- metadata
- request
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method, a device and a readable storage medium for exchanging and sharing data of a database, wherein the method for exchanging and sharing the data of the database comprises the following steps: configuring connection information of various types of databases to acquire various types of data; determining one of a plurality of types of databases to be a sharable database based on the input instruction; determining metadata needing to be shared in a sharable database; configuring service information and generating an API (application program interface); acquiring data request information and authentication information of a data requester through an API (application programming interface); and when the authentication information meets the condition of the API interface, outputting metadata to be shared in the sharable database according to the configured service information and the data request information.
Description
Technical Field
The present application belongs to the field of data sharing technology, and in particular, to a method, an apparatus, and a readable storage medium for data exchange and sharing of a database.
Background
In addition, when multiple departments in an enterprise cooperate to work, data is often used for inquiry or verification and other working scenes, so that the database information is exposed, the data required by all parties cannot be completely opened, the database information is unsafe, excel tables provide data with poor timeliness and the like.
For these reasons, enterprise organizations often choose to exchange and share data, for example, internal and internal data exchange sharing, and data exchange sharing between enterprises.
In the metadata management, information resources can be fully developed and utilized only through exchange and sharing, the exchange and sharing of data are a key ring for exerting value in the whole life cycle of the data, and data sharing can be carried out only under specific conditions in the related technology, and no related sharing method exists for cross-platform and cross-enterprise.
Therefore, the invention provides a data exchange and sharing method capable of crossing platforms and crossing enterprises, which becomes a problem to be solved urgently.
Disclosure of Invention
The present invention is directed to solving or improving at least one of the above technical problems.
The technical scheme of the first aspect of the invention provides a data exchange and sharing method of a database.
The technical scheme of the second aspect of the invention provides a data exchange and sharing device of a database.
The technical scheme of the third aspect of the invention provides a data exchange and sharing device of a database.
The technical scheme of the fourth aspect of the invention provides a readable storage medium.
The first aspect of the present invention provides a method for exchanging and sharing data of a database, comprising the following steps: configuring connection information of various databases to obtain various data; determining one of a plurality of types of databases to be a sharable database based on the input instruction; determining metadata needing to be shared in a sharable database; configuring service information and generating an API (application program interface); acquiring data request information and authentication information of a data requester through an API (application programming interface); and when the authentication information meets the condition of an Application Programming Interface (API), outputting metadata to be shared in a sharable database according to the configured service information and the data request information.
The data exchange and sharing method of the database provided by the invention has the advantages that the at least two types of databases are adapted, so that when data in one database needs to be shared, the database needing to be shared is determined, the metadata needing to be shared is determined in the database, and then the API interface is generated according to the configured service information, so that the data sharing can be realized according to the configured service information, and the cross-platform and cross-network data sharing is further realized.
In the above technical solution, the step of determining the metadata to be shared in the sharable database includes: and creating a data directory of the sharable database, and determining metadata needing to be shared in the sharable database according to the data directory.
In the technical scheme, by means of creating the data directory of the sharable database, on one hand, the data management system has a hierarchical directory structure, so that data management is more convenient, and on the other hand, all associated metadata information can be quickly determined, so that all associated data can be conveniently shared.
In the above technical solution, the step of configuring the service information and generating the API interface includes: configuring an analysis mode of metadata in a sharable database and generating an API (application programming interface); the step of outputting the metadata to be shared in the sharable database according to the configured service information and the data request information comprises the following steps: and analyzing the metadata to be shared according to the configured analysis mode, and outputting the analyzed metadata according to the data request information.
In the technical scheme, by configuring an analysis mode of metadata in a sharable database and generating an API interface, when a data sharing request is obtained, metadata to be shared can be analyzed through the configured analysis mode, and then the metadata can be shared through the API interface, for example, the metadata can be analyzed through one of a configurable sql (Structured Query Language) or physical table format.
In the above technical solution, the step of configuring the service information and generating the API interface includes: configuring request types corresponding to different request modes and generating an API (application program interface); the step of outputting the metadata to be shared in the sharable database according to the configured service information and the data request information comprises the following steps: and determining a request mode of a requester according to the data request information, and determining a corresponding request type according to the request mode to transmit data so as to share the data.
In the technical scheme, the request types corresponding to different request modes can be configured, the API interface is generated, so that after the data request information is obtained, the request mode of a requester can be determined, the corresponding request type is determined according to the request mode to transmit data so as to share the data, and the different request types are imported into the interface according to the different request modes, so that different interfaces can be called according to the different request modes to transmit parameters.
In the above technical solution, the step of configuring the request types corresponding to different request modes includes: the configuration request type is at least one of POST (a request for submitting data to the server) and GET (a request for requesting data from the server).
In the technical scheme, the configurable request type is one of POST and GET, so that different request types can be selected according to different metadata types, for example, for simple data, GET is selected to be more convenient and faster to operate, parameters can be transmitted through the POST request type for data which cannot be transmitted by GET, and certainly, both the POST request type and the GET request type can be configured in advance, so that the corresponding request type can be selected to transmit the parameters according to the acquired data request mode, and the sharing efficiency is improved.
In the above technical solution, the step of configuring the service information and generating the API interface includes: configuring the secret grade of metadata needing to be shared in a sharable database, configuring the corresponding relation between the metadata with different secret grades and different user identities, and generating an API (application program interface); the step of outputting the metadata to be shared in the sharable database according to the configured service information and the data request information comprises the following steps: and determining the identity of a user according to the data request information of the requester, determining the metadata of the secret level capable of being output according to the identity of the user, and outputting the metadata of the secret level according to the service information.
According to the technical scheme, the information display of the data is controlled according to different authorities, the metadata are divided into a plurality of secret classes, so that the data information of different secret classes can be checked according to different authorities, the risk of data leakage can be avoided, and the safety of the data is ensured.
In the above technical solution, the authentication information includes at least one of request time, name of data requester, name of data to be shared, and password information.
In the technical scheme, the request time of the user request party is limited, so that when the request time is exceeded, the sharing system automatically associates to ensure the safety of data, and meanwhile, the name of the request party, the shared data name and the password information need to be identified during data sharing, so that the data can be prevented from being leaked, and the sharing safety is improved.
In the above technical solution, the plurality of types of databases include at least two databases of Mysql database, oracle database, postgresql database, greenplus database, and Sqlserver database.
In the technical scheme, at least two databases of a Mysql database, an Oracle database, a Postgresql database, a Greenplus database and a Sqlserver database can be configured, so that mutual sharing can be performed in the various databases, and cross-network, cross-enterprise and cross-platform sharing is realized.
A second aspect of the present invention provides a data exchange and sharing apparatus for a database, including: the configuration unit is used for configuring the connection information of various databases so as to obtain various data, configuring service information and generating an API (application program interface); the determining unit is used for determining one of the multiple types of databases to be a sharable database based on the input instruction and is also used for determining metadata needing to be shared in the sharable database; the acquisition unit is used for acquiring data request information and authentication information of a data requester through an API (application program interface); and the processing unit is used for outputting metadata to be shared in the sharable database according to the configured service information and the data request information when the authentication information meets the condition of the API.
The third aspect of the present invention provides a data exchange and sharing apparatus for a database, including a storage and a processor, where the storage stores a computer program or an instruction, and the processor executes the program or the instruction to implement the data exchange and sharing method for the database according to any one of the technical solutions of the first aspect of the present application.
A fourth aspect of the present invention provides a readable storage medium, where a program or an instruction is stored, and when the program or the instruction is executed by a processor, the processor implements the method for exchanging and sharing data of a database according to any one of the technical solutions of the first aspect of the present application.
Additional aspects and advantages in accordance with the present invention will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the invention.
Drawings
FIG. 1 is a flow chart diagram illustrating a method for data exchange and sharing of a database provided by an embodiment of the invention;
FIG. 2 is a flow chart of a method for exchanging and sharing data of a database according to another embodiment of the present invention;
fig. 3 is a schematic flow chart illustrating adding authentication information in data exchange and sharing of a database according to an embodiment of the present invention;
FIG. 4 is a flow chart of a method for exchanging and sharing data of a database according to another embodiment of the present invention;
FIG. 5 is a block diagram of a data exchange and sharing apparatus for a database provided by an embodiment of the present invention;
fig. 6 shows a block diagram of a data exchange and sharing apparatus for a database according to another embodiment of the present invention.
The correspondence between the part names and the reference numbers in fig. 5 and 6 is as follows:
1 data exchange and sharing device of database, 11 configuration unit, 12 determination unit, 13 acquisition unit, 14 processing unit, 15 storage and 16 processor.
Detailed Description
In order that the above aspects, features and advantages of the embodiments according to the present invention can be more clearly understood, embodiments according to the present invention will be described in further detail below with reference to the accompanying drawings and detailed description. It should be noted that the embodiments and features of the embodiments of the present application may be combined with each other without conflict.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of embodiments according to the invention, however, embodiments according to the invention may be practiced in other ways than those described herein, and thus, the protection afforded embodiments according to the invention is not limited to the specific embodiments disclosed below.
It is noted that, in all the contents of the present invention, the definition of API is an application programming interface, the definition of URL is an interface address, the definition of Token is authentication information used for identity verification, the definition of Path is service information corresponding to the interface, the definition of param is a sharing parameter, the definition of sql is a structured query language, the definition of POST is a request for submitting data to the server, and the definition of GET is a request for sending data to the server.
Example one
As shown in fig. 1, a first embodiment of the present invention provides a method for exchanging and sharing data of a database, including the following steps:
s102: configuring connection information of various databases to obtain various data;
s104: determining one of a plurality of types of databases to be a sharable database based on the input instruction;
s106: determining metadata needing to be shared in a sharable database;
s108: configuring service information and generating an API (application program interface);
s110: acquiring data request information and authentication information of a data requester through an API (application programming interface);
s112: and when the authentication information meets the condition of the API interface, outputting metadata to be shared in the sharable database according to the configured service information and the data request information.
The method for exchanging and sharing the data of the database comprises the steps of firstly configuring connection information of various databases to obtain various data, for example, configuring at least two of a Mysql database, an Oracle database, a Postgresql database, a Greenplus database and a Sqlserver database, then determining one of the various databases to be a sharable database based on an input instruction, and then determining metadata needing to be shared in the sharable database, wherein when the shared metadata is determined, a data directory mode of the sharable database can be created. For example, the data directory may be an item directory composed of a plurality of items, so that when a certain item needs to be shared, since the service directory is created in advance in the entire database, when the item needs to be shared is obtained, all associated metadata information can be immediately and quickly determined according to the item directory, so that all associated metadata can be conveniently shared, and after the metadata information needs to be shared is determined, the service information is configured and the API interface is generated; the configuration service information may be understood as service information shared by configuration data, and may include, for example, a data analysis mode, a data transmission mode, data privacy management, data right management, and the like, the corresponding service information is imported into the interface, data request information and authentication information of a data requester are obtained through the API interface, and when the authentication information meets the conditions of the API interface, metadata to be shared is output in the sharable database according to the configured service information and the data request information. According to the method and the device, at least two types of databases are adapted, so that when metadata in one database needs to be shared, the database needing to be shared is determined, the metadata needing to be shared are determined in the database, and then the API interface is generated according to the configured service information, so that data sharing can be achieved according to the configured service information, and further cross-platform and cross-network data sharing is achieved.
In the above embodiment, the configuration service information may be an analysis mode of metadata in a sharable database, and an API interface is generated by configuring an analysis mode of metadata in the sharable database, so that when a data sharing request is obtained, metadata to be shared may be analyzed in the configured analysis mode, and then shared through the API interface, for example, one of the configurable sql or physical table formats may be used to analyze the metadata. The sql form is a pseudo sql form which is handwritten and inquired by a user based on metadata table information, the request parameter in the inquired pseudo sql is occupied by a special symbol to achieve subsequent transmission and replacement when the API interface is called, the physical table form is to control data output directly through table field information of the metadata table information, a inquired pseudo sql with the occupation of the special symbol is dynamically generated according to the table information and the field information of the physical table, the sql and the physical table form are provided that one piece of metadata is selected, finally, an inquired pseudo sql with the occupation of the special symbol is generated, and the occupation symbol of the inquired pseudo sql is replaced and recombined into a real inquired sql in the subsequent interface calling to perform inquiry results.
In the above embodiment, configuring the service information may also include configuring request types corresponding to different request manners, and generating an API interface, so that after the data request information is obtained, the request manner of a requester can be determined, the corresponding request type is determined according to the request manner, data is transferred to share data, and different request types are imported into the interface according to different request manners, so that different interfaces can be called according to different request manners to transfer parameters. For example, the configurable request type is one of POST and GET, so that different request types can be selected for different metadata types, for example, for simple data, GET is selected to be more convenient and faster to operate, parameters can be transmitted for data which cannot be transmitted by GET through the POST request type, of course, both the POST and GET request types can be configured in advance, so that the corresponding request type can be selected to transmit the parameters according to the acquired data request mode, and the sharing efficiency is improved.
In the above embodiment, configuring the service information may also include configuring a secret level of metadata that needs to be shared in the sharable database, configuring a correspondence between metadata of different secret levels and different user identities, generating an API interface, determining a user identity according to data request information of a requester, determining metadata of a secret level that can be output according to the user identity, and finally outputting the metadata of the secret level according to service information (e.g., different parsing manners or different reference manners mentioned above). According to the information display of different authority control data, the metadata is divided into a plurality of secret classes, so that the data information with different secret classes can be checked according to different authorities, the risk of data leakage can be avoided, and the data safety is ensured.
In the above embodiment, the authentication information includes at least one of a request time, a name of a data requester, a name of data to be shared, and password information. By limiting the request time of the user request party, the sharing system can automatically realize the relation when the request time is exceeded, the data safety is ensured, and meanwhile, the name of the request party, the shared data name and the password information need to be identified during data sharing, so that the data can be prevented from being leaked, and the sharing safety is improved.
Example two
In this embodiment, service information may be configured first, and then metadata that needs to be shared is determined, that is, the difference of the first embodiment is that, first, service information is configured for all data in the sharable database, then, when metadata that needs to be shared is determined, the metadata that needs to be shared is not determined first, and then, service information is configured for the metadata that needs to be shared, as shown in fig. 2, the data exchange and sharing method for a database of this embodiment includes the following steps:
s202: determining a sharable database;
s204: configuring metadata information;
s206: determining shareable metadata;
s208: configuring data service information for data sharing;
s210: outputting the processed shared data;
compared with the first embodiment, the sharing method of the embodiment configures all data in the database in advance, which is equivalent to that only one time of configuration is needed in all sharing processes, and when other data need to be shared, sharing can be directly performed according to configured service information, so that the frequency of configuring the service information is reduced.
EXAMPLE III
In this embodiment, different from the first embodiment and the second embodiment, the present embodiment further sets authentication information in data sharing, and as shown in fig. 3, the method for exchanging and sharing data of a database of the present embodiment includes the following steps:
s302: creating a data directory;
s304: configuring a request type;
s306: configuring a data source type;
s308: configuring a request mode;
s310: configuring request parameters and returning parameter information;
s312: completing data service configuration to generate service information;
s314: and generating an API interface and adding Token authentication.
In this embodiment, a data directory is created according to metadata, and then service information is configured according to the metadata, where the configuration service information includes a configuration data source type, that is, an analysis mode of the metadata in a sharable database is configured, and an API interface is generated, so when a data sharing request is obtained, the metadata to be shared may be analyzed in a configured analysis mode, and then the metadata may be shared through the API interface, for example, one of configurable sql or physical table formats may be used to analyze the metadata, the configuration service information further includes a configuration request type and a configuration request mode, that is, request types corresponding to different request modes are configured, so after the data request information is obtained, the request mode of a requester may be determined, and a corresponding request type may be determined according to the request mode to perform data transfer, so as to perform data sharing. The configuration service information also comprises configuration request parameters and return parameter information, and after the data service configuration is completed, the service information is generated, an API interface is generated at the same time, and Token authentication is added. The sharing method of the embodiment configures Token information with a time limit for configured service information, the created Token information is used for interface authentication, the Token comprises request time, a name of a data requester, a data name to be shared and password information, meanwhile, an expiration time limit is added for Token creation, exceeding the time sharing automatic relationship, the time can be deleted in a prolonged way, and data security interaction across networks and enterprises is ensured through the encrypted Token authentication with an expiration mechanism.
Example four
As shown in fig. 4, the method for exchanging and sharing data of a database provided in this embodiment includes the following steps:
s402: configuring an API interface;
s404: token information of the URL request API interface;
s406: analyzing Token information, path information and Param information;
s408: whether the authentication information of Token meets the standard or not; if yes, executing S410, otherwise, executing S412;
s410: analyzing the data request information; then, S414 is executed;
s412: outputting the authentication information error;
s414: acquiring a sharing parameter and transmitting according to the service information;
s416: and outputting the parameter information.
The method for exchanging and sharing data of the database includes configuring an API interface, calling the API interface, requesting Token information of the API interface through a URL, analyzing the Token information, path information and Param information, wherein the Path information is service information corresponding to the interface, and analyzing the service information corresponding to the interface, so that the configured service can be adopted to transmit and share parameters, wherein the Param information is parameter information needing to be shared, the Token information is authentication information, judging whether the authentication information of the Token meets the standard, if so, analyzing the data request information, acquiring shared parameters and transmitting according to the service information, and finally outputting the parameter information, and if the authentication information of the Token does not meet the standard, outputting an error authentication information.
The data exchange and sharing method of the database of the embodiment analyzes an incoming parameter list and analyzes Token information in parameters for access of an API (application program interface), if no error result can be directly returned, if Token authentication information is obtained, comparison and deadline check are carried out on Token standard authentication information in the database, if the verification is invalid, an error result is returned, the verification carries out next-step parameter analysis and processing, numerical value conversion and mapping are completed through analyzing request parameters, final sql is dynamically generated according to configured service information and metadata information, execution results are obtained by adopting different metadata policies and omitting the execution sql according to metadata types, and the execution results are analyzed and repackaged according to data parameter configuration to finish data sharing. The data management and data sharing method provided by the invention is characterized in that the data in the metadatabase is used as a foundation stone, and the configuration of API service information is used for realizing the carding and data output transmission of a huge data structure in the metadatabase, so as to complete the data sharing operation of the data after the data management.
EXAMPLE five
The method for exchanging and sharing data of the database supports data exchange and sharing of various types of metadata, including database types such as Mysql, oracle, postgresql, greenplus, sqlserver and the like, and mainly comprises the following steps in the process of exchanging data:
the method comprises the following steps: configuring connection information of each type of database to ensure that sql (structured query language) can be executed in each type of metadata, providing a precondition for data sharing, having multiple metadata type drives for multiple database types, having different generation strategies for different metadata, and ensuring that each supported metadata type can complete data sharing operation.
Step two: after the database is selected, a service information directory is created firstly, a hierarchical directory structure is provided, data management is more convenient, and metadata information related to a table structure in the metadata database is selected through the data directory to perform data sharing operation.
In the process of data sharing, data sharing and result output are mainly performed in a configuration service information generation API (application programming interface) mode, service information configuration information is generated based on metadata base information, and service information creation is completed by configuration parameter information.
The configuration service information comprises different API (application programming interface) request types and protocol modes, an API call link path and different request modes are generated to meet interface call and output results of different forms, so that when the API obtains the data request information of a data requester, a specific request mode can be determined according to the data request information, and then data sharing is performed according to the corresponding request type and protocol mode; at present, the method is limited to two types, namely POST (creating a new resource on a server) and GET (requesting to obtain a specific resource from the server), and the method is characterized in that the method is driven into an interface according to different request modes, and different interfaces are called according to different request modes to analyze parameters so as to complete data transmission.
The configuration service information also comprises different API authorities and security classification, the information display of the service information in the data directory is controlled according to different authorities, and the security classification controls the viewing operation authority in the directory, so that data with different security levels can be shared according to different user authorities, and the risk of data leakage is avoided.
The configuration service information also comprises source data configuration, service information can be configured through an sql and a physical table form based on data in a metadata database, the sql form is that data output is flexibly controlled through a pseudo sql form which is handwritten and inquired based on metadata table information, request parameters in the inquired pseudo sql are occupied by special symbols to achieve parameter transferring replacement when the API interface is called subsequently, the physical table form is that data output is controlled through table field information of the metadata table information directly, an inquiry pseudo sql with a special symbol occupancy is dynamically generated according to the table information and the field information of the physical table, the sql and the physical table form are premised on selecting one piece of metadata, finally, an inquiry pseudo sql with a special symbol occupancy is generated, and occupancy symbols of the inquiry pseudo sql are replaced and recombined into a real inquiry sql in subsequent interface calling to perform inquiry results.
The configuration service information also comprises configuration request parameters and return parameter information to respectively control incoming parameters and return output parameters called by the API interface, the incoming parameters are expressed as field information of the physical table in the form of the physical table, the incoming parameters are expressed as field information of sql analyzed by a statement analyzer in the form of sql, after the configuration, pseudo sql generated according to the configured information table, the request parameters and the return parameters is generated, an external interface is generated according to the overall configuration, the request parameters are analyzed by calling an interface address, numerical value conversion and mapping are completed, final sql is dynamically generated according to the configured service information and metadata information, execution results are obtained by adopting different metadata strategies to execute sql according to metadata types, and the execution results are analyzed and repackaged to final return data according to data parameter configuration to complete data sharing. Request parameter and return parameter configurable value replacement operations, such as configuration value replacement 0: male, 1: female, then 0 is passed in when parameter transmission is requested, the corresponding value mapped in sql is male, and 1 is passed in, the mapping is female.
Step three: configuring time-limited Token information for configured service information, wherein the created Token information is used for interface authentication, and comprises request time, a name of a data requester, a data name to be shared and password information; and calling the configured data sharing interface through the configured service information rule to output data corresponding to the service information rule so as to complete the cross-network and cross-platform secure data sharing.
The data management and data sharing method provided by the invention is characterized in that the data in the metadata database is used as a foundation stone, and the large data structure in the metadata database is combed and the data is output and transmitted by configuring API service information, so that the data sharing operation of the data after the data management is completed.
As shown in fig. 5, a second aspect of the present invention provides a data exchange and sharing apparatus 1 for a database, comprising: the configuration unit 11 is configured to configure connection information of multiple types of databases to obtain multiple types of data, configure service information, and generate an API interface; the determining unit 12 is configured to determine one of the multiple types of databases as a sharable database based on the input instruction, and is further configured to determine metadata that needs to be shared in the sharable database; an obtaining unit 13, configured to obtain data request information and authentication information of a data requester through an API interface; and the processing unit 14 is configured to output metadata to be shared in the sharable database according to the configured service information and the data request information when the authentication information meets the condition of the API interface.
As shown in fig. 6, a third aspect of the present invention provides a data exchange and sharing apparatus 1 for a database, including a storage 15 and a processor 16, where the storage 15 stores a computer program or an instruction, and the processor 16, when executing the computer program or the instruction, implements the data exchange and sharing method for the database according to any one of the technical solutions of the first aspect of the present application.
A fourth aspect of the present invention provides a readable storage medium, where a program or an instruction is stored, and when the program or the instruction is executed by a processor, the processor implements the method for exchanging and sharing data of a database according to any one of the technical solutions of the first aspect of the present application.
In embodiments according to the invention, the terms "first", "second", "third" are used only for descriptive purposes and are not to be construed as indicating or implying relative importance; the term "plurality" means two or more unless expressly limited otherwise. The terms "mounted," "connected," "fixed," and the like are used broadly and should be construed to include, for example, "connected" may be a fixed connection, a detachable connection, or an integral connection; "connected" may be directly connected or indirectly connected through an intermediate. Specific meanings of the above terms in the embodiments according to the present invention can be understood by those of ordinary skill in the art according to specific situations.
Further, while operations are depicted in a particular order, this should be understood as requiring that such operations be performed in the particular order shown or in sequential order, or that all illustrated operations be performed, to achieve desirable results. Under certain circumstances, multitasking and parallel processing may be advantageous. Likewise, while several specific implementation details are included in the above discussion, these should not be construed as limitations on the scope of the invention. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single implementation. Conversely, various features that are described in the context of a single implementation can also be implemented in multiple implementations separately or in any suitable subcombination.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims.
The above is only a preferred embodiment according to the present invention, and is not intended to limit the embodiment according to the present invention, and various modifications and variations may be made to the embodiment according to the present invention by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the embodiment according to the present invention should be included in the protection scope of the embodiment according to the present invention.
Claims (10)
1. A method for exchanging and sharing data of a database is characterized by comprising the following steps:
configuring connection information of various types of databases to acquire various types of data;
determining one of a plurality of types of databases to be a sharable database based on the input instruction;
determining metadata needing to be shared in the sharable database;
configuring service information and generating an API (application program interface);
acquiring data request information and authentication information of a data requester through the API;
and when the authentication information meets the condition of the API interface, outputting metadata to be shared in the sharable database according to the configured service information and the data request information.
2. The method of claim 1, wherein the step of determining the metadata to be shared in the sharable database comprises:
and creating a data directory of the sharable database, and determining metadata needing to be shared in the sharable database according to the data directory.
3. The method of claim 1, wherein the database is a database of a plurality of databases,
the step of configuring service information and generating an API interface includes:
configuring an analysis mode of metadata in a sharable database and generating an API (application programming interface);
the step of outputting metadata to be shared in the sharable database according to the configured service information and the configured data request information includes:
and analyzing the metadata to be shared according to the configured analysis mode, and outputting the analyzed metadata according to the data request information.
4. The method of claim 1,
the step of configuring service information and generating an API interface includes:
configuring request types corresponding to different request modes and generating an API (application program interface);
the step of outputting metadata to be shared in the sharable database according to the configured service information and the configured data request information includes:
and determining a request mode of the requester according to the data request information, and determining the corresponding request type according to the request mode to transmit data so as to share data.
5. The database data exchange and sharing method of claim 4, wherein the step of configuring the request types corresponding to the different request modes comprises:
the configuration request type is at least one of POST and GET.
6. The method of claim 1,
the step of configuring service information and generating an API interface includes:
configuring the secret grade of metadata to be shared in the sharable database, configuring the corresponding relation between the metadata with different secret grades and different user identities, and generating an API (application programming interface);
the step of outputting metadata to be shared in the sharable database according to the configured service information and the configured data request information includes:
and determining the user identity according to the data request information of the requester, determining the metadata of the secret grade capable of being output according to the user identity, and outputting the metadata of the secret grade according to the service information.
7. Method for data exchange and sharing of a database according to any of the claims 1 to 6,
the authentication information comprises at least one of request time, the name of a data requester, the name of data to be shared and password information; and/or
The multiple types of databases include at least two of a Mysql database, an Oracle database, a Postgresql database, a greenplus database, and a Sqlserver database.
8. An apparatus for exchanging and sharing data in a database, comprising:
the configuration unit is used for configuring the connection information of various databases to acquire various data, configuring service information and generating an API (application program interface);
the device comprises a determining unit, a sharing unit and a sharing unit, wherein the determining unit is used for determining one of a plurality of types of databases to be a sharable database based on an input instruction and is also used for determining metadata needing to be shared in the sharable database;
the acquisition unit is used for acquiring data request information and authentication information of a data requester through the API;
and the processing unit is used for outputting metadata to be shared in the sharable database according to the configured service information and the data request information when the authentication information meets the condition of the API.
9. An apparatus for exchanging and sharing data in a database, comprising:
a storage having stored thereon a computer program or instructions, and a processor which, when executing said program or instructions, implements a method of data exchange and sharing of a database according to any of claims 1 to 7.
10. A readable storage medium, characterized in that said readable storage medium has stored thereon a program or instructions which, when executed by a processor, implements a data exchange and sharing arrangement of a database according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211535571.6A CN115757589A (en) | 2022-12-02 | 2022-12-02 | Data exchange and sharing method and device of database and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211535571.6A CN115757589A (en) | 2022-12-02 | 2022-12-02 | Data exchange and sharing method and device of database and readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115757589A true CN115757589A (en) | 2023-03-07 |
Family
ID=85342528
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211535571.6A Pending CN115757589A (en) | 2022-12-02 | 2022-12-02 | Data exchange and sharing method and device of database and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115757589A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116702110A (en) * | 2023-06-15 | 2023-09-05 | 深圳千岸科技股份有限公司 | Method, device, equipment and storage medium for sharing big data of supply chain |
-
2022
- 2022-12-02 CN CN202211535571.6A patent/CN115757589A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116702110A (en) * | 2023-06-15 | 2023-09-05 | 深圳千岸科技股份有限公司 | Method, device, equipment and storage medium for sharing big data of supply chain |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP7222036B2 (en) | Model training system and method and storage medium | |
| CN112615849B (en) | Micro-service access method, device, equipment and storage medium | |
| CN106874461B (en) | A kind of workflow engine supports multi-data source configuration security access system and method | |
| JP2022000757A5 (en) | ||
| US8060931B2 (en) | Security authorization queries | |
| CN106534199B (en) | Distributed system certification and rights management platform under big data environment based on XACML and SAML | |
| Pan et al. | Semantic access control for information interoperation | |
| US8745088B2 (en) | System and method of performing risk analysis using a portal | |
| EP3890270A1 (en) | Access controls for a dedicated database system storing user-generated content input to a multitenant service of a collaborative work environment | |
| WO2020233361A1 (en) | Internal service invoking method and apparatus based on gateway, and terminal device | |
| CN112835977B (en) | Database management method and system based on block chain | |
| CN113468511B (en) | Data processing method and device, computer readable medium and electronic equipment | |
| CN110765484A (en) | Credit investigation data processing method and electronic equipment | |
| CN115757589A (en) | Data exchange and sharing method and device of database and readable storage medium | |
| CN112307501A (en) | Big data system based on block chain technology, storage method and using method | |
| CN114448648B (en) | Sensitive credential management method and system based on RPA | |
| CN100440892C (en) | Gridding safety communication system and gridding safety communication method | |
| CN114417428A (en) | Privacy calculation method and system based on distributed cooperation | |
| KR20070076342A (en) | User Group Role / Permission Management System and Access Control Methods in a Grid Environment | |
| JP3951638B2 (en) | Authentication application service system | |
| CN103957173A (en) | Semantic switch | |
| CN115396229A (en) | Cross-domain resource isolation sharing system based on block chain | |
| KR20120077830A (en) | Method, device and server for providing automated information extraction service | |
| CN115906178B (en) | Database management method, data subscription terminal and data publishing terminal | |
| CN117668053B (en) | Data acquisition and analysis system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |