CN114090975A - Cloud database resource processing method and device, electronic equipment and storage medium - Google Patents
Cloud database resource processing method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN114090975A CN114090975A CN202111262883.XA CN202111262883A CN114090975A CN 114090975 A CN114090975 A CN 114090975A CN 202111262883 A CN202111262883 A CN 202111262883A CN 114090975 A CN114090975 A CN 114090975A
- Authority
- CN
- China
- Prior art keywords
- user
- target
- database
- cloud
- information
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
- G06F21/33—User authentication using certificates
Abstract
The application discloses a processing method and device of cloud database resources, electronic equipment and a storage medium, wherein the method comprises the following steps: acquiring authentication information of a user, and authenticating the authentication information of the user; if the authentication is passed, acquiring the items of which the user has the authority from the background database, feeding the items back to the user, responding to the item selection operation of the user, and inquiring the cloud resource information of the target items belonging to the type of the target database selected by the user from the background database; the inquired cloud resource information is fed back to the user; responding to cloud resource selection operation of a user, and acquiring an address corresponding to a target cloud resource selected by the user and cloud account information to which the target cloud resource belongs; the method comprises the steps that an authorization server sends an authorization request by taking cloud account information to which target cloud resources belong as a parameter item, so that the authorization server is triggered to request to return a security token; and splicing the address corresponding to the target cloud resource with the security token to obtain a password-free login address, and feeding back the password-free login address to the user.
Description
Technical Field
The application relates to the technical field of database operation and maintenance, in particular to a cloud database resource processing method and device, electronic equipment and a storage medium.
Background
With the development of cloud technology and hybrid cloud, it has become a normal state that the same project uses cloud databases of different types and different environments. While the use of a cloudy, multi-type database enhances the robustness of a project, it increases the difficulty of managing cloud resources.
Since cloud databases in different types and different environments usually belong to different cloud vendors, database servers of different cloud vendors do not support each other to a sufficient degree. Therefore, services provided by various cloud vendors need to create corresponding sub-accounts, and therefore, a large number of sub-accounts need to be created for a cloudy scene. In the operation and maintenance process of the cloud database, a manager needs to continuously switch accounts to log in so as to use the databases in different environments and the services of different manufacturers and manage the databases.
Because a large number of sub-accounts need to be created, not only a large number of sub-accounts need to be associated, but also the accounts need to be continuously switched during operation and maintenance, so that different cloud resources are accessed, and therefore, the cloud resources are excessively complicated to manage based on the prior art, and the efficiency is relatively low.
Disclosure of Invention
Based on the defects of the prior art, the application provides a cloud database resource processing method and device, electronic equipment and a storage medium, so as to solve the problem that the cloud database resource is excessively fussy to manage based on the prior art.
In order to achieve the above object, the present application provides the following technical solutions:
a first aspect of the present application provides a method for processing cloud database resources, including:
acquiring authentication information of a user, and authenticating the authentication information of the user;
if the authentication information of the user passes the authentication, acquiring the item with the authority of the user from a background database and feeding back the item to the user,
responding to the item selection operation of the user, and inquiring cloud resource information of a target item belonging to the type of a target database from the background database; wherein the target item and the target database type are the item and the database type selected by the user, respectively;
the inquired cloud resource information is fed back to the user;
responding to the cloud resource selection operation of the user, and acquiring an address corresponding to the target cloud resource selected by the user and cloud account information to which the target cloud resource belongs;
taking the cloud account information of the target cloud resource as a parameter item, sending an authorization request by an authorization server, so as to trigger the authorization server to request to return a security token;
splicing the address corresponding to the target cloud resource with the security token to obtain a password-free login address, and feeding back the password-free login address to the user; the secret-free login address is used for secret-free access to the service corresponding to the target cloud resource.
Optionally, in the processing method of the cloud database resource, the obtaining an address corresponding to the target cloud resource selected by the user and cloud account information to which the target cloud resource belongs includes:
sending an access request for attempting to access the target database service to a cloud resource server where the target database service is located;
acquiring a redirection address returned by the cloud resource server;
inquiring cloud account information to which the target database instance belongs from the background database;
the splicing the address corresponding to the target cloud resource and the security token to obtain a password-free login address comprises the following steps:
and splicing the redirection address and the security token to obtain a password-free login address.
Optionally, in the processing method of cloud database resources provided above, the authenticating authentication information of the user includes:
detecting whether the authentication information of the user meets the format requirement;
if the authentication information of the user is detected to meet the format requirement, judging whether the authentication information of the user is correct or not based on the user information stored in the background database;
and if the authentication information of the user is judged to be correct, determining that the authentication information of the user passes authentication.
Optionally, in the processing method of cloud database resources provided above, further includes:
acquiring cloud primary account information of a target manufacturer;
constructing a database service access connection corresponding to the target manufacturer by using the decrypted cloud primary account information;
utilizing a database service access connection corresponding to the target manufacturer to call the database service of the target manufacturer so as to obtain a database instance list of a database to be synchronized of the target manufacturer;
and writing the information in the database instance list into a database.
A second aspect of the present application provides a processing apparatus for cloud database resources, including:
an authentication information acquisition unit for acquiring authentication information of a user;
the authentication unit is used for authenticating the authentication information of the user;
an item query unit, configured to, if the authentication information of the user passes authentication, obtain an item to which the user has an authority from a background database, and feed back the item to the user,
the resource query unit is used for responding to the item selection operation of the user and querying the cloud resource information of the target item belonging to the type of the target database from the background database; wherein the target item and the target database type are the item and the database type selected by the user, respectively;
the resource feedback unit is used for feeding the inquired cloud resource information back to the user;
a resource information obtaining unit, configured to respond to a cloud resource selection operation of the user, and obtain an address corresponding to a target cloud resource selected by the user and cloud account information to which the target cloud resource belongs;
the authorization request unit is used for sending an authorization request to an authorization server by taking the cloud account information to which the target cloud resource belongs as a parameter item so as to trigger the authorization server to request to return a security token;
the splicing unit is used for splicing the address corresponding to the target cloud resource with the security token to obtain a password-free login address and feeding the password-free login address back to the user; the secret-free login address is used for secret-free access to the service corresponding to the target cloud resource.
Optionally, in the processing apparatus for cloud database resources provided above, the target cloud resource includes a target database service and a target database instance, and the resource information obtaining unit includes:
the access unit is used for sending an access request for trying to access the target database service to a cloud resource server where the target database service is located;
the address acquisition unit is used for acquiring a redirection address returned by the cloud resource server;
the account information query unit is used for querying the cloud account information to which the target database instance belongs from the background database;
the splicing unit is used for splicing the address corresponding to the target cloud resource with the security token to obtain a password-free login address:
and splicing the redirection address and the security token to obtain a password-free login address.
Optionally, in the processing apparatus for cloud database resources provided above, the authentication unit includes:
the format checking unit is used for detecting whether the authentication information of the user meets the format requirement;
the judging unit is used for judging whether the authentication information of the user is correct or not based on the user information stored in the background database if the authentication information of the user is detected to meet the format requirement;
and the determining unit is used for determining that the authentication information of the user passes the authentication if the authentication information of the user is judged to be correct.
Optionally, in the processing apparatus for cloud database resources provided above, further includes:
the system comprises a primary account information acquisition unit, a primary account information acquisition unit and a cloud service information acquisition unit, wherein the primary account information acquisition unit is used for acquiring cloud primary account information of a target manufacturer;
the construction unit is used for constructing a database service access connection corresponding to the target manufacturer by using the decrypted cloud primary account information;
the calling unit is used for calling the database service of the target manufacturer by utilizing the database service access connection corresponding to the target manufacturer so as to obtain a database instance list of the database to be synchronized of the target manufacturer;
and the processing unit is used for writing the information in the database instance list into a database.
A third aspect of the present application provides an electronic device comprising:
a memory and a processor;
wherein the memory is used for storing programs;
the processor is configured to execute the program, and when the program is executed, the processor is specifically configured to implement the processing method of the cloud database resource according to any one of the above items.
A fourth aspect of the present application provides a computer storage medium for storing a computer program, which when executed, is configured to implement the processing method of cloud database resources as described in any one of the above.
The application provides a processing method of cloud database resources, which is used for acquiring authentication information of a user and authenticating the authentication information of the user. And if the authentication information of the user passes the authentication, acquiring the item with the authority of the user from a background database, and feeding back the item to the user for selection. And responding to the item selection operation of the user, inquiring the cloud resource information of the target item belonging to the type of the target database selected by the user from the background database, and feeding the inquired cloud resource information back to the user for selection. And then, responding to the cloud resource selection operation of the user, acquiring an address corresponding to the target cloud resource selected by the user and cloud account information to which the target cloud resource belongs, sending an authorization request by using the cloud account information to which the target cloud resource belongs as a parameter item, triggering an authorization server to request to return a security token, splicing the address corresponding to the target cloud resource and the security token to obtain a password-free login address, and feeding back the password-free login address to the user, wherein the user can directly utilize the password-free login address to access the service corresponding to the target cloud resource. Therefore, cloud resources of any type of databases can be selected only by once login, and the password-free login address is obtained to access the cloud resources, so that the cloud resources are managed more conveniently.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
Fig. 1 is a working schematic diagram of a cloud database operation and maintenance platform provided in an embodiment of the present application;
fig. 2 is a flowchart of a processing method for cloud database resources according to an embodiment of the present disclosure;
fig. 3 is a flowchart illustrating authentication of user authentication information according to an embodiment of the present disclosure;
fig. 4 is a flowchart of a manner of obtaining an address corresponding to a target cloud resource and cloud account information to which the target cloud resource belongs according to the embodiment of the present application;
FIG. 5 is a flowchart of a method for synchronizing database resources according to an embodiment of the present application;
fig. 6 is a schematic structural diagram of a processing apparatus for cloud database resources according to an embodiment of the present disclosure;
fig. 7 is a schematic structural diagram of a resource information obtaining unit according to an embodiment of the present application;
fig. 8 is a schematic structural diagram of an authentication unit according to an embodiment of the present application;
fig. 9 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
In this application, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The application provides a cloud database resource processing method, which aims to solve the problem that the management of cloud database resources is too complicated based on the prior art.
Optionally, in order to implement the processing method of the cloud database resource provided by the present application, an embodiment of the present application provides a cloud database operation and maintenance platform, which specifically includes a front end and a back end.
As shown in fig. 1, the back end includes a platform server, a background database, a cloud authorization server, and a cloud resource server.
The front end is used for responding to the operation of a user, interacting with the platform server, and accessing the cloud resource server through the password-free login address after the password-free login address is finally obtained.
Specifically, as shown in fig. 1, the front end is configured to send a login request of a user to the platform server for authentication, obtain a user item right returned by the platform server after the authentication is passed, and provide the user item right for selection. And then, sending the user selection items and the database types to a platform server to obtain corresponding cloud resources, and providing the corresponding cloud resources for the user to select. Subsequently, the cloud resources selected by the user are sent to the platform server, so that the password-free login address of the cloud resource server corresponding to the cloud resources selected by the user is obtained. And finally, accessing the corresponding cloud resource server by using the password-free login address to obtain the cloud resource selected by the user.
And the platform server is mainly used for responding to the request and the information sent by the front end, interacting with the background database, the cloud authorization server and the cloud resource server, and returning corresponding information to the front end.
Specifically, as also shown in fig. 1, the login request is authenticated through the user information stored in the background database, and when the authentication is passed, the subsequent user item right is fed back to the front end from the background database. And when the item and the database type selected by the front end are received, feeding back the source resources corresponding to the item and the database type from the background server to the front end. And when receiving the cloud resource selected by the user and sent by the front end, accessing the cloud resource server corresponding to the cloud resource to obtain the redirection address of the cloud resource server. And then, acquiring cloud account information of the cloud resource server from a background database, and sending a request to the cloud authorization server by using the cloud account information as a parameter so as to obtain a security token returned by the cloud authorization server. And finally, splicing the redirection address and the security token to obtain a secret-free login address, and feeding back the secret-free login address to the front end.
The background database is mainly used for storing information required in the maintenance process, such as user information, cloud account information and the like. Optionally, the subsequent database may specifically adopt MySQL.
The cloud authorization server is mainly used for returning a corresponding historical security token (token) when receiving an authorization request sent by the platform server.
The cloud resource server is used for providing cloud resources, and the user accesses the cloud resources in the cloud resource server through the front end by using the password-free login address.
Based on the cloud database operation and maintenance platform, the embodiment of the application provides a processing method of cloud database resources, an application and a platform server. As shown in fig. 2, a method for processing cloud database resources provided in an embodiment of the present application includes the following steps:
s201, obtaining the authentication information of the user and authenticating the authentication information of the user.
The authentication information may specifically include an account number and a password of the user.
Specifically, when the user applies for registration, the account and the password of the user can be stored in the background database. Therefore, when a user needs to log in the operation and maintenance platform, the corresponding authentication information is input, the platform server acquires the authentication information of the user at the moment, and the currently acquired authentication information of the user is authenticated by using the account and the password of each user stored in the background database.
Optionally, in this embodiment of the present application, a method for authenticating authentication information of a user, as shown in fig. 3, includes:
s301, detecting whether the authentication information of the user meets the format requirement.
In the embodiment of the present application, in order to avoid reducing unnecessary workload, it is first detected whether the format of the authentication information of the user meets the format requirement, and step S302 is executed when it is detected that the format of the authentication information of the user meets the format requirement.
Optionally, if it is detected that the authentication information of the user does not meet the format requirement, a prompt message indicating that the format has a problem may be fed back to the user through the front end.
S302, whether the authentication information of the user is correct or not is judged based on the user information stored in the background database.
Specifically, information consistent with the authentication information of the user is queried from a background database. If the information consistent with the authentication information of the user is inquired, the authentication information of the user is determined to be correct, at this time, step S303 is executed, and if the information consistent with the authentication information of the user is not inquired, the authentication information of the user is determined to be incorrect.
S303, determining that the authentication information of the user passes authentication.
S202, judging whether the authentication information of the user passes the authentication.
If the authentication information of the user is judged to pass the authentication, step S203 is executed.
And S203, acquiring the items with the authority of the user from the background database, and feeding back the items to the user.
Specifically, the information of each item which the user has the authority is acquired from the background database, and the information of the item is fed back to the front end and is provided for the user to select through the user interface of the front end.
And S204, responding to the item selection operation of the user, and inquiring the cloud resource information of the target item belonging to the type of the target database from the background database.
Wherein the target item and the target database type are an item and a database type selected by a user, respectively.
It should be noted that, while the items are provided to the user for selection, the user is also provided with corresponding, selectable respective database types. And after the user selects the item and the database type, determining the item selected by the user as a target item, and determining the database type selected by the user as a target database type. And then, inquiring a resource table of the target database type from the background database, and determining the cloud resource information belonging to the A project from the resource table. For example, if the user selects item a and the relational database, cloud resource information of the relational database of item a is returned.
And S205, feeding back the inquired cloud resource information to the user.
Specifically, the queried cloud resource information is fed back to the front end, and the front end provides the cloud resource information for the user to select through the user interface.
S206, responding to the cloud resource selection operation of the user, and acquiring the address corresponding to the target cloud resource selected by the user and the cloud account information of the target cloud resource.
And the address of the target resource corresponding to the target cloud resource in the cloud resource server.
And acquiring the winning address of the target cloud resource based on the pre-record, and inquiring the cloud account information of the target cloud resource from the background database.
Optionally, the cloud account information may be an access key ID and an access key Secret.
Optionally, in another embodiment of the present application, the target cloud resource includes a target database service and a target database instance, and in this embodiment of the present application, a specific implementation manner of step S206, as shown in fig. 4, includes:
s401, sending an access request for trying to access the target database service to a cloud resource server where the target database service is located.
It should be noted that, in the embodiment of the present application, the cloud resource selected by the user includes a database service and a database instance.
Since the address of the saved target database service is not necessarily the current address of the target database service in the cloud resource server, the target database server in the cloud resource server needs to be accessed to the view, and the cloud resource server returns a redirection address (url).
S402, acquiring a redirection address returned by the cloud resource server.
And S403, inquiring the cloud account information to which the target database instance belongs from the background database.
It should be noted that, in this embodiment of the present application, the address corresponding to the acquired target cloud resource is a redirection address, so in this embodiment, step S208 correspondingly includes:
and splicing the redirection address and the security token to obtain a password-free login address.
And S207, taking the cloud account information of the target cloud resource as a parameter item, sending an authorization request by the authorization server, so as to trigger the authorization server to request to return the security token.
Optionally, the cloud account information stored in the background database may be held in an encrypted manner, so as to ensure the security of the cloud account information. Therefore, after the cloud account information is obtained, the cloud account information needs to be decrypted first, and then the cloud authorization server initiates an authorization request by using the decrypted cloud account information as a parameter item. At this point, the login service in the authorization server will return a temporary security token.
And S208, splicing the address corresponding to the target cloud resource with the security token to obtain a password-free login address, and feeding back the password-free login address to the user.
The secret-free login address is used for secret-free access to the service corresponding to the target cloud resource.
Since the security token is acquired, the security token is contained in the address obtained by splicing the security token and the address corresponding to the target cloud resource, so that the address can be accessed without login. Therefore, after the secret-free login address is obtained, the secret-free login address is fed back to the front end and provided for the user, and the user directly orients the target cloud resource by using the secret-free login address through the front end.
Optionally, in another embodiment of the present application, a method for synchronizing database resources may be further included, specifically as shown in fig. 5, including the following steps:
s501, acquiring cloud primary account information of a target manufacturer.
Optionally, the database resources are synchronized to the background database of the platform every day through a timing task, so that the cloud resource information is input and updated. Specifically, a timing task may be initiated, at this time, a plurality of threads are invoked to perform resource synchronization, each database type of each cloud vendor corresponds to one thread, each cloud vendor is used as a target vendor, and the method is executed by using the corresponding thread.
Specifically, the cloud primary account information of the target scene is obtained, which may specifically include an access key ID and an access key Secret.
And S502, establishing a database service access connection corresponding to a target manufacturer by using the decrypted cloud primary account information.
Specifically, since the cloud primary account information is usually stored in an encrypted manner, the cloud primary account information needs to be decrypted, and then the corresponding database service access connection is constructed by using the decrypted cloud primary account information. For example, if an RDS database is accessed, a corresponding RDS SDK client is constructed.
S503, using the database service access connection corresponding to the target manufacturer, and calling the database service of the target manufacturer to obtain a database instance list of the database to be synchronized of the target manufacturer.
Specifically, a database service of a target manufacturer is called, and a database instance list of a database to be synchronized is returned through the database service. The database instance list comprises instance information, project exemptions, corresponding cloud account identification and other information.
S504, writing the information in the database instance list into the database.
Specifically, according to the method for dividing the resource group for the cloud instance, the item to which the instance belongs is determined, and therefore information is stored in the corresponding item.
The embodiment of the application provides a processing method of cloud database resources, which is used for acquiring authentication information of a user and authenticating the authentication information of the user. And if the authentication information of the user passes the authentication, acquiring the item with the authority of the user from a background database, and feeding back the item to the user for selection. And responding to the item selection operation of the user, inquiring the cloud resource information of the target item belonging to the type of the target database selected by the user from the background database, and feeding the inquired cloud resource information back to the user for selection. And then, responding to the cloud resource selection operation of the user, acquiring an address corresponding to the target cloud resource selected by the user and cloud account information to which the target cloud resource belongs, sending an authorization request by using the cloud account information to which the target cloud resource belongs as a parameter item, triggering an authorization server to request to return a security token, splicing the address corresponding to the target cloud resource and the security token to obtain a password-free login address, and feeding back the password-free login address to the user, wherein the user can directly utilize the password-free login address to access the service corresponding to the target cloud resource. Therefore, cloud resources of any type of databases can be selected only by once login, and the password-free login address is obtained to access the cloud resources, so that the cloud resources are managed more conveniently.
Another embodiment of the present application provides a processing apparatus for cloud database resources, as shown in fig. 6, including:
an authentication information acquisition unit 601 configured to acquire authentication information of a user.
An authentication unit 602, configured to authenticate authentication information of a user.
An item query unit 603, configured to, if the authentication information of the user passes the authentication, obtain an item that the user has an authority from the background database, and feed back the item to the user,
the resource query unit 604 is configured to query, in response to a project selection operation of a user, cloud resource information of a target project belonging to a target database type from the background database.
The target item and the target database type are respectively the item and the database type selected by the user.
And a resource feedback unit 605, configured to feed back the queried cloud resource information to the user.
A resource information obtaining unit 606, configured to respond to a cloud resource selection operation of a user, and obtain an address corresponding to a target cloud resource selected by the user and cloud account information to which the target cloud resource belongs.
The authorization request unit 607 is configured to send an authorization request to an authorization server by using the cloud account information to which the target cloud resource belongs as a parameter item, so as to trigger the authorization server to request to return the security token.
And the splicing unit 608 is configured to splice the address corresponding to the target cloud resource with the security token to obtain a password-free login address, and feed the password-free login address back to the user. The secret-free login address is used for secret-free access to the service corresponding to the target cloud resource.
Optionally, in the processing apparatus for cloud database resources provided in another embodiment of the present application, the target cloud resources include a target database service and a target database instance. As shown in fig. 7, the resource information obtaining unit in the embodiment of the present application includes:
an accessing unit 701 is configured to send an access request attempting to access the target database service to a cloud resource server where the target database service is located.
An address obtaining unit 702, configured to obtain a redirection address returned by the cloud resource server.
The account information querying unit 703 is configured to query, from the background database, cloud account information to which the target database instance belongs.
The splicing unit in the embodiment of the application performs splicing on the address corresponding to the target cloud resource and the security token to obtain the password-free login address, and is configured to:
and splicing the redirection address and the security token to obtain a password-free login address.
Optionally, in a processing apparatus of cloud database resources provided in another embodiment of the present application, as shown in fig. 8, an authentication unit includes:
the format checking unit 801 is configured to detect whether the authentication information of the user meets the format requirement.
A determining unit 802, configured to determine whether the authentication information of the user is correct based on the user information stored in the background database if it is detected that the authentication information of the user meets the format requirement.
The determining unit 803 is configured to determine that the authentication information of the user passes authentication if the authentication information of the user is determined to be correct.
Optionally, in a processing apparatus for cloud database resources provided in another embodiment of the present application, further includes:
and the primary account information acquisition unit is used for acquiring cloud primary account information of the target manufacturer.
And the construction unit is used for constructing the database service access connection corresponding to the target manufacturer by using the decrypted cloud primary account information.
And the calling unit is used for calling the database service of the target manufacturer by utilizing the database service access connection corresponding to the target manufacturer so as to obtain the database instance list of the database to be synchronized of the target manufacturer.
And the processing unit is used for writing the information in the database instance list into the database.
It should be noted that, for the specific working processes of each unit provided in the foregoing embodiments of the present application, corresponding steps in the foregoing method embodiments may be referred to accordingly, and are not described herein again.
Another embodiment of the present application provides an electronic device, as shown in fig. 9, including:
a memory 901 and a processor 902.
The memory 901 is used for storing programs.
The processor 902 is configured to execute the program stored in the memory 901, and when the program is executed, the processing method of the cloud database resource provided in any of the above embodiments is specifically implemented.
Another embodiment of the present application provides a computer storage medium for storing a computer program, and when the computer program is executed, the computer storage medium is used to implement the processing method for cloud database resources provided in any one of the above embodiments.
Computer storage media, including permanent and non-permanent, removable and non-removable media, may implement the information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A processing method of cloud database resources is characterized by comprising the following steps:
acquiring authentication information of a user, and authenticating the authentication information of the user;
if the authentication information of the user passes the authentication, acquiring the item with the authority of the user from a background database and feeding back the item to the user,
responding to the item selection operation of the user, and inquiring cloud resource information of a target item belonging to the type of a target database from the background database; wherein the target item and the target database type are the item and the database type selected by the user, respectively;
the inquired cloud resource information is fed back to the user;
responding to the cloud resource selection operation of the user, and acquiring an address corresponding to the target cloud resource selected by the user and cloud account information to which the target cloud resource belongs;
taking the cloud account information of the target cloud resource as a parameter item, sending an authorization request by an authorization server, so as to trigger the authorization server to request to return a security token;
splicing the address corresponding to the target cloud resource with the security token to obtain a password-free login address, and feeding back the password-free login address to the user; the secret-free login address is used for secret-free access to the service corresponding to the target cloud resource.
2. The method according to claim 1, wherein the target cloud resources include a target database service and a target database instance, and the acquiring the address corresponding to the target cloud resource selected by the user and the cloud account information to which the target cloud resource belongs includes:
sending an access request for attempting to access the target database service to a cloud resource server where the target database service is located;
acquiring a redirection address returned by the cloud resource server;
inquiring cloud account information to which the target database instance belongs from the background database;
the splicing the address corresponding to the target cloud resource and the security token to obtain a password-free login address comprises the following steps:
and splicing the redirection address and the security token to obtain a password-free login address.
3. The method of claim 1, wherein authenticating the authentication information of the user comprises:
detecting whether the authentication information of the user meets the format requirement;
if the authentication information of the user is detected to meet the format requirement, judging whether the authentication information of the user is correct or not based on the user information stored in the background database;
and if the authentication information of the user is judged to be correct, determining that the authentication information of the user passes authentication.
4. The method of claim 1, further comprising:
acquiring cloud primary account information of a target manufacturer;
constructing a database service access connection corresponding to the target manufacturer by using the decrypted cloud primary account information;
utilizing a database service access connection corresponding to the target manufacturer to call the database service of the target manufacturer so as to obtain a database instance list of a database to be synchronized of the target manufacturer;
and writing the information in the database instance list into a database.
5. A processing apparatus for cloud database resources, comprising:
an authentication information acquisition unit for acquiring authentication information of a user;
the authentication unit is used for authenticating the authentication information of the user;
an item query unit, configured to, if the authentication information of the user passes authentication, obtain an item to which the user has an authority from a background database, and feed back the item to the user,
the resource query unit is used for responding to the item selection operation of the user and querying the cloud resource information of the target item belonging to the type of the target database from the background database; wherein the target item and the target database type are the item and the database type selected by the user, respectively;
the resource feedback unit is used for feeding the inquired cloud resource information back to the user;
a resource information obtaining unit, configured to respond to a cloud resource selection operation of the user, and obtain an address corresponding to a target cloud resource selected by the user and cloud account information to which the target cloud resource belongs;
the authorization request unit is used for sending an authorization request to an authorization server by taking the cloud account information to which the target cloud resource belongs as a parameter item so as to trigger the authorization server to request to return a security token;
the splicing unit is used for splicing the address corresponding to the target cloud resource with the security token to obtain a password-free login address and feeding the password-free login address back to the user; the secret-free login address is used for secret-free access to the service corresponding to the target cloud resource.
6. The apparatus of claim 5, wherein the target cloud resource comprises a target database service and a target database instance, and the resource information obtaining unit comprises:
the access unit is used for sending an access request for trying to access the target database service to a cloud resource server where the target database service is located;
the address acquisition unit is used for acquiring a redirection address returned by the cloud resource server;
the account information query unit is used for querying the cloud account information to which the target database instance belongs from the background database;
the splicing unit is used for splicing the address corresponding to the target cloud resource with the security token to obtain a password-free login address:
and splicing the redirection address and the security token to obtain a password-free login address.
7. The apparatus of claim 5, wherein the authentication unit comprises:
the format checking unit is used for detecting whether the authentication information of the user meets the format requirement;
the judging unit is used for judging whether the authentication information of the user is correct or not based on the user information stored in the background database if the authentication information of the user is detected to meet the format requirement;
and the determining unit is used for determining that the authentication information of the user passes the authentication if the authentication information of the user is judged to be correct.
8. The apparatus of claim 5, further comprising:
the system comprises a primary account information acquisition unit, a primary account information acquisition unit and a cloud service information acquisition unit, wherein the primary account information acquisition unit is used for acquiring cloud primary account information of a target manufacturer;
the construction unit is used for constructing a database service access connection corresponding to the target manufacturer by using the decrypted cloud primary account information;
the calling unit is used for calling the database service of the target manufacturer by utilizing the database service access connection corresponding to the target manufacturer so as to obtain a database instance list of the database to be synchronized of the target manufacturer;
and the processing unit is used for writing the information in the database instance list into a database.
9. An electronic device, comprising:
a memory and a processor;
wherein the memory is used for storing programs;
the processor is configured to execute the program, and when the program is executed, the program is specifically configured to implement the processing method of the cloud database resource according to any one of claims 1 to 4.
10. A computer storage medium storing a computer program which, when executed, implements the processing method of the cloud database resource of any one of claims 1 to 4.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111262883.XA CN114090975A (en) | 2021-10-28 | 2021-10-28 | Cloud database resource processing method and device, electronic equipment and storage medium |
| PCT/CN2022/106267 WO2023071305A1 (en) | 2021-10-28 | 2022-07-18 | Cloud database resource processing method and apparatus, and electronic device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111262883.XA CN114090975A (en) | 2021-10-28 | 2021-10-28 | Cloud database resource processing method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114090975A true CN114090975A (en) | 2022-02-25 |
Family
ID=80297994
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111262883.XA Pending CN114090975A (en) | 2021-10-28 | 2021-10-28 | Cloud database resource processing method and device, electronic equipment and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN114090975A (en) |
| WO (1) | WO2023071305A1 (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114973761A (en) * | 2022-05-25 | 2022-08-30 | 重庆长安汽车股份有限公司 | System, method and storage medium for automatically parking vehicles in parking lot to pass through barrier gate |
| WO2023071305A1 (en) * | 2021-10-28 | 2023-05-04 | 青岛海尔科技有限公司 | Cloud database resource processing method and apparatus, and electronic device and storage medium |
| WO2023246060A1 (en) * | 2022-06-24 | 2023-12-28 | 中国电信股份有限公司 | User authentication and authorization method and apparatus, and medium and device |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116886763A (en) * | 2023-09-08 | 2023-10-13 | 江苏未来网络集团有限公司 | Butt joint method, service butt joint method and system of universal three-party access platform |
| CN117857217A (en) * | 2024-03-01 | 2024-04-09 | 浙江网商银行股份有限公司 | Cloud native platform resource verification method and device, storage medium and electronic equipment |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10348735B2 (en) * | 2017-09-01 | 2019-07-09 | Atlassian Pty Ltd | Systems and methods for accessing cloud resources from a local development environment |
| CN109286633A (en) * | 2018-10-26 | 2019-01-29 | 深圳市华云中盛科技有限公司 | Single sign-on method, device, computer equipment and storage medium |
| CN112995165B (en) * | 2021-02-10 | 2023-04-14 | 北京金山云网络技术有限公司 | Resource access authentication method and device, storage medium and electronic equipment |
| CN112995163B (en) * | 2021-02-10 | 2023-05-05 | 北京金山云网络技术有限公司 | Authentication method and device for resource access, storage medium and electronic equipment |
| CN113347242B (en) * | 2021-05-28 | 2023-04-18 | Oppo广东移动通信有限公司 | Cross-device resource access method and device, storage medium and electronic device |
| CN114090975A (en) * | 2021-10-28 | 2022-02-25 | 青岛海尔科技有限公司 | Cloud database resource processing method and device, electronic equipment and storage medium |
-
2021
- 2021-10-28 CN CN202111262883.XA patent/CN114090975A/en active Pending
-
2022
- 2022-07-18 WO PCT/CN2022/106267 patent/WO2023071305A1/en unknown
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023071305A1 (en) * | 2021-10-28 | 2023-05-04 | 青岛海尔科技有限公司 | Cloud database resource processing method and apparatus, and electronic device and storage medium |
| CN114973761A (en) * | 2022-05-25 | 2022-08-30 | 重庆长安汽车股份有限公司 | System, method and storage medium for automatically parking vehicles in parking lot to pass through barrier gate |
| WO2023246060A1 (en) * | 2022-06-24 | 2023-12-28 | 中国电信股份有限公司 | User authentication and authorization method and apparatus, and medium and device |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2023071305A1 (en) | 2023-05-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114090975A (en) | Cloud database resource processing method and device, electronic equipment and storage medium | |
| AU2017215589B2 (en) | Electronic payment service processing method and device, and electronic payment method and device | |
| CN108182581B (en) | Accounting method and device for block chain | |
| CN110213276B (en) | Authorization verification method under micro-service architecture, server, terminal and medium | |
| CN107276970B (en) | Unbinding and binding method and device | |
| CN107104923B (en) | Account binding and service processing method and device | |
| EP4109861A1 (en) | Data processing method, apparatus, computer device, and storage medium | |
| CN108933838B (en) | Application data processing method and device | |
| CN110909379A (en) | Storage cluster permission determination method, device, equipment and storage medium | |
| CN108289074B (en) | User account login method and device | |
| CN112733001B (en) | Method and device for acquiring subscription information and electronic equipment | |
| CN108804399B (en) | Form verification method and device | |
| CN112738021B (en) | Single sign-on method, terminal, application server, authentication server and medium | |
| CN115150419B (en) | Configuration and access method and system for hybrid cloud object storage | |
| CN115130075A (en) | Digital signature method and device, electronic equipment and storage medium | |
| CN114978752A (en) | Weak password detection method and device, electronic equipment and computer readable storage medium | |
| CN113225350B (en) | Network resource management method, device, medium and electronic equipment | |
| CN113676549A (en) | Application request distribution method, application gateway, electronic device and storage medium | |
| CN111431957A (en) | File processing method, device, equipment and system | |
| CN111327680B (en) | Authentication data synchronization method, device, system, computer equipment and storage medium | |
| CN111193900A (en) | Monitoring video sharing method and device and storage medium | |
| US10742802B2 (en) | Methods and devices for verifying a communication number | |
| CN109040161B (en) | Cloud manufacturing service management system, device and method | |
| CN113742664B (en) | Monitoring and auditing method, equipment and system | |
| CN113300867B (en) | CDN system, information processing method and device, and CDN node |
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 |