CN117951120B - Method and device for integrating CloudBeaver database management system into cloud platform - Google Patents
Method and device for integrating CloudBeaver database management system into cloud platform Download PDFInfo
- Publication number
- CN117951120B CN117951120B CN202410346457.1A CN202410346457A CN117951120B CN 117951120 B CN117951120 B CN 117951120B CN 202410346457 A CN202410346457 A CN 202410346457A CN 117951120 B CN117951120 B CN 117951120B
- Authority
- CN
- China
- Prior art keywords
- cloud platform
- cloudbeaver
- user
- database
- instance
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 39
- 238000013507 mapping Methods 0.000 claims abstract description 11
- 230000008569 process Effects 0.000 claims description 16
- 235000014510 cooky Nutrition 0.000 claims description 11
- 230000010354 integration Effects 0.000 claims description 10
- 239000000284 extract Substances 0.000 claims description 3
- 238000007726 management method Methods 0.000 description 37
- 238000012423 maintenance Methods 0.000 description 5
- 238000013523 data management Methods 0.000 description 3
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000003780 insertion Methods 0.000 description 2
- 230000037431 insertion Effects 0.000 description 2
- 240000000594 Heliconia bihai Species 0.000 description 1
- 230000006978 adaptation Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 239000002071 nanotube Substances 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Classifications
-
- 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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- 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/25—Integrating or interfacing systems involving database management systems
-
- 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/45—Structures or tools for the administration of authentication
- G06F21/46—Structures or tools for the administration of authentication by designing passwords or checking the strength of passwords
-
- 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/60—Protecting data
- G06F21/604—Tools and structures for managing or administering access control systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Computer Hardware Design (AREA)
- Data Mining & Analysis (AREA)
- General Health & Medical Sciences (AREA)
- Bioethics (AREA)
- Health & Medical Sciences (AREA)
- Automation & Control Theory (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a device for integrating CloudBeaver database management systems into a cloud platform, and relates to the technical field of cloud computing; comprising the following steps: step 1: cloudBeaver is integrated to a cloud platform, and user relation mapping between the cloud platform and CloudBeaver is established for a user to log in CloudBeaver through the cloud platform; step 2: reading CloudBeaver configuration files through CloudBeaver a Guan Yunping b cloud database instance, obtaining an address of cloud platform database instance connection information, calling the cloud platform database instance connection information address by using a cloud platform token, obtaining connection information of the cloud platform database instance, and updating CloudBeaver a database connection list according to the connection information of the cloud platform database instance; and unified management of various databases such as a cloud platform relational database is realized.
Description
Technical Field
The invention discloses a method and a device, relates to the technical field of cloud computing, and particularly relates to a method and a device for integrating CloudBeaver database management systems into a cloud platform.
Background
Along with the rapid development of cloud computing, the cloud platform is rapidly built, some cloud platform database product lines lack unified operation and maintenance management tools, the cloud center cannot rapidly locate anomalies, and the operation and maintenance complexity is too high. Most management tools on the market at present cannot provide standard and self-service services for application, transportation and application development teams, and meanwhile, a large amount of adaptation, such as configuration of monitoring index items and thresholds, is required, deep intervention of original manufacturers is required, and the management tools are difficult to realize for new requirements, long in period and very low in use efficiency. And the method can not provide a unified management function for the database, so that the operation and maintenance management cost is high, the efficiency is low, and the safety and the controllability of the data are difficult to ensure.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides a method and a device for integrating CloudBeaver database management systems into a cloud platform, which help users to realize unified management of multiple types of databases such as relational databases and the like on the cloud platform.
The specific scheme provided by the invention is as follows:
The invention provides a method for integrating CloudBeaver database management systems into a cloud platform, which comprises the following steps: step 1: integrating CloudBeaver into a cloud platform, establishing user relation mapping between the cloud platform and CloudBeaver, and using the user relation mapping for logging in CloudBeaver through the cloud platform, wherein an interceptor is additionally arranged at the front end of CloudBeaver, intercepting a user request through the interceptor, checking whether the user logs in the cloud platform, if so, acquiring a carried cloud platform token from the request, analyzing the token, extracting a unique identifier of the cloud platform user corresponding to the token, and logging in CloudBeaver by using the unique identifier of the cloud platform user as a user name of CloudBeaver;
Step 2: after CloudBeaver is logged in, a configuration file of CloudBeaver is read through CloudBeaver na Guan Yunping platform cloud database instance, an address of cloud platform database instance connection information is obtained, a cloud platform token is utilized to call the cloud platform database instance connection information address, connection information of the cloud platform database instance is obtained, and a database connection list of CloudBeaver is updated according to the connection information of the cloud platform database instance.
Further, in the method for integrating CloudBeaver database management system into cloud platform, if the user does not log in the cloud platform, the user forwards the request to the unified identity and access management center IAM of the cloud platform through the interceptor, the user logs in through the IAM using the cloud platform account, if the user successfully logs in, the IAM writes a login identifier and a login token into the cache cookie, and when the user accesses CloudBeaver again, the user does not need to log in any more.
Further, in step 1 of the method for integrating the CloudBeaver database management system into the cloud platform, login is performed by using the cloud platform account through the IAM, including:
Step 11, obtaining a cloud platform token in a cache cookie through the front end of CloudBeaver, analyzing the token, extracting the unique identifier of a cloud platform user corresponding to the token, using the unique identifier of the cloud platform user as a user name when logging in CloudBeaver, sending a login request to the rear end,
Step 12, when the back end receives the login request, the user name is obtained from the request, whether the user is registered is inquired, and if the user is not registered, the back end jumps to step 13; otherwise the process goes to step 14,
Step 13, creating a new account for the user by CloudBeaver using the newly registered username and default password, logging in CloudBeaver using the new account after the account has been created,
And 14, performing login operation by directly using the user name and the default password through CloudBeaver.
Further, in step 2 of the method for integrating CloudBeaver the database management system into the cloud platform, updating CloudBeaver the database connection list includes:
a set of database connection information lists already in CloudBeaver is obtained,
Traversing a cloud platform database instance list set, wherein the cloud platform database instance list set comprises all available cloud platform database instances, and in the traversing process, verifying whether each cloud platform database instance exists in CloudBeaver, if so, skipping the instance to enter the next instance; otherwise, updating the instance connection information in CloudBeaver, and adding the connection information of the instance to the corresponding database connection information set in CloudBeaver.
The invention also provides a CloudBeaver device for integrating the database management system into the cloud platform, which comprises an integration module and an instance module,
The integration module integrates CloudBeaver into a cloud platform, establishes user relation mapping between the cloud platform and CloudBeaver and is used for a user to log in CloudBeaver through the cloud platform, wherein an interceptor is additionally arranged at the front end of CloudBeaver, intercepts a user request through the interceptor, checks whether the user logs in the cloud platform, acquires a carried cloud platform token from the request if the user logs in the cloud platform, analyzes the token, extracts a unique identifier of the cloud platform user corresponding to the token, and logs in CloudBeaver by using the unique identifier of the cloud platform user as a user name of CloudBeaver;
After the instance module logs in CloudBeaver, a cloud platform database instance is obtained by reading CloudBeaver a configuration file through CloudBeaver na Guan Yunping platform cloud database instance, obtaining an address of cloud platform database instance connection information, calling the cloud platform database instance connection information address by using a cloud platform token, obtaining connection information of the cloud platform database instance, and updating CloudBeaver a database connection list according to the connection information of the cloud platform database instance.
Further, the integration module in the device integrated with the cloud platform by the CloudBeaver database management system checks whether the user logs in the cloud platform, if the user does not log in the cloud platform, the user forwards the request to the unified identity and access management center (IAM) of the cloud platform through the interceptor, the user logs in through the IAM by using the cloud platform account, and if the user successfully logs in, the IAM writes a login identification and a login token into a cache cookie, and when the user accesses CloudBeaver again, the user does not need to log in again.
Further, the integration module in the device integrating the CloudBeaver database management system into the cloud platform logs in by using the cloud platform account through the IAM, including:
Step 11, obtaining a cloud platform token in a cache cookie through the front end of CloudBeaver, analyzing the token, extracting the unique identifier of a cloud platform user corresponding to the token, using the unique identifier of the cloud platform user as a user name when logging in CloudBeaver, sending a login request to the rear end,
Step 12, when the back end receives the login request, the user name is obtained from the request, whether the user is registered is inquired, and if the user is not registered, the back end jumps to step 13; otherwise the process goes to step 14,
Step 13, creating a new account for the user by CloudBeaver using the newly registered username and default password, logging in CloudBeaver using the new account after the account has been created,
And 14, performing login operation by directly using the user name and the default password through CloudBeaver.
Further, the database connection list updated CloudBeaver by the instance module in the device integrated into the cloud platform by the CloudBeaver database management system includes:
a set of database connection information lists already in CloudBeaver is obtained,
Traversing a cloud platform database instance list set, wherein the cloud platform database instance list set comprises all available cloud platform database instances, and in the traversing process, verifying whether each cloud platform database instance exists in CloudBeaver, if so, skipping the instance to enter the next instance; otherwise, updating the instance connection information in CloudBeaver, and adding the connection information of the instance to the corresponding database connection information set in CloudBeaver.
The invention has the advantages that:
The invention provides a method for integrating CloudBeaver a database management system into a cloud platform, which can easily manage and operate a database on the cloud platform by integrating CloudBeaver into the cloud platform. In terms of data management, cloudBeaver provides rich functionality to process and manage data in the database. Database objects such as tables, views, indexes and the like can be created and managed, and operations such as insertion, updating, deletion, inquiry and the like can be performed on the data. In terms of structure management, cloudBeaver provides a flexible structural design tool that enables users to define the schema and architecture of the database. The user may define relationships between tables, data types of fields, constraints, etc. to meet specific business needs. By integrating the database management system into the cloud platform, the CloudBeaver database management system can realize the function of unified management of the database. The user does not need to log in and manage tools of different database management systems or cloud service providers respectively, and can complete all database management work by using one unified interface. This not only improves the work efficiency but also reduces the workload of management and maintenance.
Drawings
FIG. 1 is a schematic flow chart of the method of the invention.
FIG. 2 is a flowchart of an example database of CloudBeaver nanotube cloud platform according to the method of the present invention.
Detailed Description
CloudBeaver is a Web-based cloud database management tool supporting databases such as PostgreSQL, mySQL, mariaDB, SQLite and Firebird. The server itself is based on Java, the Web part is written in TYPESCRIPT and compact, can process data like a conventional spreadsheet, is written in a modular architecture, allows expansion using its own plug-in, and can run on Linux, windows and MacOS X.
The present invention will be further described with reference to the accompanying drawings and specific examples, which are not intended to be limiting, so that those skilled in the art will better understand the invention and practice it.
The invention provides a method for integrating CloudBeaver database management systems into a cloud platform, which comprises the following steps: step 1: integrating CloudBeaver into a cloud platform, establishing user relation mapping between the cloud platform and CloudBeaver, and using the user relation mapping for logging in CloudBeaver through the cloud platform, wherein an interceptor is additionally arranged at the front end of CloudBeaver, intercepting a user request through the interceptor, checking whether the user logs in the cloud platform, if so, acquiring a carried cloud platform token from the request, analyzing the token, extracting a unique identifier of the cloud platform user corresponding to the token, and logging in CloudBeaver by using the unique identifier of the cloud platform user as a user name of CloudBeaver;
Step 2: after CloudBeaver is logged in, a configuration file of CloudBeaver is read through CloudBeaver na Guan Yunping platform cloud database instance, an address of cloud platform database instance connection information is obtained, a cloud platform token is utilized to call the cloud platform database instance connection information address, connection information of the cloud platform database instance is obtained, and a database connection list of CloudBeaver is updated according to the connection information of the cloud platform database instance.
The method of the invention can provide the cloud platform with the functions of data management, structure management, performance display, optimization and the like, and uniformly manage the service of the database, thereby greatly improving the research and development efficiency and ensuring that the database management is safer and more convenient.
In particular applications, in some embodiments of the method of the present invention, the process may be referred to as follows:
Step 1: cloudBeaver is integrated to the cloud platform, and a user relationship mapping between the cloud platform and CloudBeaver is established for a user to log in CloudBeaver through the cloud platform. Through the mapping, a user can log in and use the CloudBeaver system simultaneously by logging in on the cloud platform. In addition, to ensure the security and isolation of the system, database resources of different users will be implemented isolated from each other and not visible from each other. This prevents one user from illegally accessing or operating the database of the other user. An interceptor is additionally arranged at the front end of CloudBeaver, a user request is intercepted through the interceptor, whether the user logs in the cloud platform or not is checked, if the user logs in the cloud platform, a cloud platform token carried in the request is obtained, the cloud platform token is analyzed, a unique identifier of a cloud platform user corresponding to the token is extracted, and the unique identifier of the cloud platform user is used as a user name login CloudBeaver of CloudBeaver.
In step 1, when checking whether the user logs in the cloud platform, if the user does not log in the cloud platform, forwarding the request to the unified identity and access management center IAM of the cloud platform through the interceptor, logging in through the IAM by using the cloud platform account, and if logging in successfully, writing a login identifier and a login token into the cache cookie by the IAM, and when the user accesses CloudBeaver again, no logging operation is needed. Thus, when the user accesses CloudBeaver the system again, they do not need to log in again, as this information is already stored in the cache cookie.
Further, logging in by using the cloud platform account through the IAM includes:
Step 11, obtaining a cloud platform token in a cache cookie through the front end of CloudBeaver, analyzing the token, extracting the unique identifier of a cloud platform user corresponding to the token, using the unique identifier of the cloud platform user as a user name when logging in CloudBeaver, sending a login request to the rear end,
Step 12, when the back end receives the login request, the user name is obtained from the request, whether the user is registered is inquired, and if the user is not registered, the back end jumps to step 13; otherwise the process goes to step 14,
Step 13, creating a new account for the user by CloudBeaver using the newly registered username and default password, logging in CloudBeaver using the new account after the account has been created,
And 14, performing login operation by directly using the user name and the default password through CloudBeaver.
Step 2: after CloudBeaver is logged in, a configuration file of CloudBeaver is read through CloudBeaver na Guan Yunping platform cloud database instance, an address of cloud platform database instance connection information is obtained, a cloud platform token is utilized to call the cloud platform database instance connection information address, connection information of the cloud platform database instance is obtained, and a database connection list of CloudBeaver is updated according to the connection information of the cloud platform database instance.
Wherein in step 2, further, updating CloudBeaver the database connection list includes:
a set of database connection information lists already in CloudBeaver is obtained,
Traversing a cloud platform database instance list set, wherein the cloud platform database instance list set comprises all available cloud platform database instances, and in the traversing process, verifying whether each cloud platform database instance exists in CloudBeaver, if so, skipping the instance to enter the next instance; otherwise, updating the instance connection information in CloudBeaver, and adding the connection information of the instance to the corresponding database connection information set in CloudBeaver. The database connection information for the instance is deleted from the CloudBeaver system. This ensures that the database connection information in the CloudBeaver system is up-to-date and most accurate.
After the above steps are completed, it is checked CloudBeaver whether the database connection information list set in the system is empty. If the collection is not empty, it is stated that there are some cloud platform instances that have been deleted. To maintain consistency and accuracy of the system, we need to delete these database connections synchronously. This may remove these cloud platform deleted instances from the CloudBeaver system by invoking the delete database connection function of the CloudBeaver system.
Likewise, referring to fig. 2, when the method of the present invention is used to pass through CloudBeaver na Guan Yunping cloud database instances, the cloud platform database instance information can be synchronized:
the address of the cloud platform providing the database instance connection information is obtained in the CloudBeaver configuration file,
The database instance connection information address provided by the cloud platform is invoked using the cloud platform token CloudBeaver,
A set of cloud platform database instance listings is obtained at CloudBeaver,
A set of system database connection information lists is obtained at CloudBeaver,
And at CloudBeaver, synchronizing the cloud platform database instance information in comparison to the two sets.
The invention also provides a CloudBeaver device for integrating the database management system into the cloud platform, which comprises an integration module and an instance module,
The integration module integrates CloudBeaver into a cloud platform, establishes user relation mapping between the cloud platform and CloudBeaver and is used for a user to log in CloudBeaver through the cloud platform, wherein an interceptor is additionally arranged at the front end of CloudBeaver, intercepts a user request through the interceptor, checks whether the user logs in the cloud platform, acquires a carried cloud platform token from the request if the user logs in the cloud platform, analyzes the token, extracts a unique identifier of the cloud platform user corresponding to the token, and logs in CloudBeaver by using the unique identifier of the cloud platform user as a user name of CloudBeaver;
After the instance module logs in CloudBeaver, a cloud platform database instance is obtained by reading CloudBeaver a configuration file through CloudBeaver na Guan Yunping platform cloud database instance, obtaining an address of cloud platform database instance connection information, calling the cloud platform database instance connection information address by using a cloud platform token, obtaining connection information of the cloud platform database instance, and updating CloudBeaver a database connection list according to the connection information of the cloud platform database instance.
The content of information interaction and execution process among the modules in the device is based on the same conception as the embodiment of the method of the present invention, and specific content can be referred to the description in the embodiment of the method of the present invention, which is not repeated here.
Likewise, the device can easily manage and operate the database on the cloud platform by integrating CloudBeaver into the cloud platform. In terms of data management, cloudBeaver provides rich functionality to process and manage data in the database. Database objects such as tables, views, indexes and the like can be created and managed, and operations such as insertion, updating, deletion, inquiry and the like can be performed on the data. In terms of structure management, cloudBeaver provides a flexible structural design tool that enables users to define the schema and architecture of the database. The user may define relationships between tables, data types of fields, constraints, etc. to meet specific business needs. By integrating the database management system into the cloud platform, the CloudBeaver database management system can realize the function of unified management of the database. The user does not need to log in and manage tools of different database management systems or cloud service providers respectively, and can complete all database management work by using one unified interface. This not only improves the work efficiency but also reduces the workload of management and maintenance.
It should be noted that not all the steps and modules in the above processes and the structures of the devices are necessary, and some steps or modules may be omitted according to actual needs. The execution sequence of the steps is not fixed and can be adjusted as required. The system structure described in the above embodiments may be a physical structure or a logical structure, that is, some modules may be implemented by the same physical entity, or some modules may be implemented by multiple physical entities, or may be implemented jointly by some components in multiple independent devices.
The above-described embodiments are merely preferred embodiments for fully explaining the present invention, and the scope of the present invention is not limited thereto. Equivalent substitutions and modifications will occur to those skilled in the art based on the present invention, and are intended to be within the scope of the present invention. The protection scope of the invention is subject to the claims.
Claims (6)
1. A method for integrating CloudBeaver database management systems into a cloud platform, comprising:
Step 1: integrating CloudBeaver into a cloud platform, establishing a user relation mapping between the cloud platform and CloudBeaver for a user to log in CloudBeaver through the cloud platform, wherein an interceptor is additionally arranged at the front end of CloudBeaver, intercepting a user request through the interceptor, checking whether the user logs in the cloud platform, if so, acquiring a carried cloud platform token from the request, analyzing the token, extracting a unique identification of the cloud platform user corresponding to the token, logging in CloudBeaver by using the unique identification of the cloud platform user as a user name of CloudBeaver,
If the user does not log in the cloud platform, the user forwards the request to a unified identity and access management center (IAM) of the cloud platform through an interceptor, the IAM uses a cloud platform account to log in, if the user successfully logs in, a login identifier and a login token are written into a cache cookie through the IAM, and when the user accesses CloudBeaver again, login operation is not needed;
Step 2: after CloudBeaver is logged in, a configuration file of CloudBeaver is read through CloudBeaver na Guan Yunping platform cloud database instance, an address of cloud platform database instance connection information is obtained, a cloud platform token is utilized to call the cloud platform database instance connection information address, connection information of the cloud platform database instance is obtained, and a database connection list of CloudBeaver is updated according to the connection information of the cloud platform database instance.
2. The method for integrating CloudBeaver database management systems into a cloud platform according to claim 1, wherein in step 1, login is performed by using a cloud platform account through IAM, including:
Step 11, obtaining a cloud platform token in a cache cookie through the front end of CloudBeaver, analyzing the token, extracting the unique identifier of a cloud platform user corresponding to the token, using the unique identifier of the cloud platform user as a user name when logging in CloudBeaver, sending a login request to the rear end,
Step 12, when the back end receives the login request, the user name is obtained from the request, whether the user is registered is inquired, and if the user is not registered, the back end jumps to step 13; otherwise the process goes to step 14,
Step 13, creating a new account for the user by CloudBeaver using the newly registered username and default password, logging in CloudBeaver using the new account after the account has been created,
And 14, performing login operation by directly using the user name and the default password through CloudBeaver.
3. The method of integrating CloudBeaver database management system into a cloud platform of claim 1, wherein updating CloudBeaver the database connection list in step 2 comprises:
a set of database connection information lists already in CloudBeaver is obtained,
Traversing a cloud platform database instance list set, wherein the cloud platform database instance list set comprises all available cloud platform database instances, and in the traversing process, verifying whether each cloud platform database instance exists in CloudBeaver, if so, skipping the instance to enter the next instance; otherwise, updating the instance connection information in CloudBeaver, and adding the connection information of the instance to the corresponding database connection information set in CloudBeaver.
4. A CloudBeaver database management system is integrated into a cloud platform device, which is characterized by comprising an integration module and an instance module,
The integration module integrates CloudBeaver into the cloud platform, establishes user relation mapping between the cloud platform and CloudBeaver for a user to log in CloudBeaver through the cloud platform, wherein an interceptor is additionally arranged at the front end of CloudBeaver, intercepts a user request through the interceptor, the integration module checks whether the user logs in the cloud platform, if so, acquires a carried cloud platform token from the request, analyzes the token, extracts a unique identifier of the cloud platform user corresponding to the token, logs in CloudBeaver by using the unique identifier of the cloud platform user as a user name of CloudBeaver,
If the user does not log in the cloud platform, the user forwards the request to a unified identity and access management center (IAM) of the cloud platform through an interceptor, the IAM uses a cloud platform account to log in, if the user successfully logs in, the IAM writes a login identification and a login token into a cache cookie, and when the user accesses CloudBeaver again, login operation is not needed;
After the instance module logs in CloudBeaver, a cloud platform database instance is obtained by reading CloudBeaver a configuration file through CloudBeaver na Guan Yunping platform cloud database instance, obtaining an address of cloud platform database instance connection information, calling the cloud platform database instance connection information address by using a cloud platform token, obtaining connection information of the cloud platform database instance, and updating CloudBeaver a database connection list according to the connection information of the cloud platform database instance.
5. The apparatus for integrating CloudBeaver database management systems into a cloud platform as claimed in claim 4, wherein the integration module logs in through an IAM using a cloud platform account, comprising:
Step 11, obtaining a cloud platform token in a cache cookie through the front end of CloudBeaver, analyzing the token, extracting the unique identifier of a cloud platform user corresponding to the token, using the unique identifier of the cloud platform user as a user name when logging in CloudBeaver, sending a login request to the rear end,
Step 12, when the back end receives the login request, the user name is obtained from the request, whether the user is registered is inquired, and if the user is not registered, the back end jumps to step 13; otherwise the process goes to step 14,
Step 13, creating a new account for the user by CloudBeaver using the newly registered username and default password, logging in CloudBeaver using the new account after the account has been created,
And 14, performing login operation by directly using the user name and the default password through CloudBeaver.
6. The apparatus for integrating CloudBeaver database management systems into a cloud platform as recited in claim 4, wherein the instance module updates CloudBeaver the database connection list comprising:
a set of database connection information lists already in CloudBeaver is obtained,
Traversing a cloud platform database instance list set, wherein the cloud platform database instance list set comprises all available cloud platform database instances, and in the traversing process, verifying whether each cloud platform database instance exists in CloudBeaver, if so, skipping the instance to enter the next instance; otherwise, updating the instance connection information in CloudBeaver, and adding the connection information of the instance to the corresponding database connection information set in CloudBeaver.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410346457.1A CN117951120B (en) | 2024-03-26 | 2024-03-26 | Method and device for integrating CloudBeaver database management system into cloud platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410346457.1A CN117951120B (en) | 2024-03-26 | 2024-03-26 | Method and device for integrating CloudBeaver database management system into cloud platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117951120A CN117951120A (en) | 2024-04-30 |
| CN117951120B true CN117951120B (en) | 2024-07-23 |
Family
ID=90799824
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410346457.1A Active CN117951120B (en) | 2024-03-26 | 2024-03-26 | Method and device for integrating CloudBeaver database management system into cloud platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117951120B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113688376A (en) * | 2021-07-15 | 2021-11-23 | 上海浦东发展银行股份有限公司 | Tenant authority control method for realizing container cloud platform based on CMDB system and RBAC model |
| WO2024016049A1 (en) * | 2022-07-18 | 2024-01-25 | Nansen Pty Ltd | A system and method for implementing responsive, cost-effective immutability and data integrity validation in cloud and distributed storage systems using distributed ledger and smart contract technology |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103051631B (en) * | 2012-12-21 | 2015-07-15 | 国云科技股份有限公司 | Unified security authentication method for PaaS (Platform as a Service) platform and SaaS (Software as a Service) application system |
| CN113595968B (en) * | 2020-04-30 | 2023-02-03 | 华为云计算技术有限公司 | Login method and system based on cloud application instance and related equipment |
| WO2022011055A2 (en) * | 2020-07-07 | 2022-01-13 | Fp Complete Corporation | A System and Method for Simplifying User Authentication and Authorization Workflows |
| CN112118237A (en) * | 2020-09-04 | 2020-12-22 | 紫光云(南京)数字技术有限公司 | Resource access management method |
| CN112532723B (en) * | 2020-11-27 | 2023-04-18 | 北京浪潮数据技术有限公司 | Account management method, cloud management layer, equipment and medium |
-
2024
- 2024-03-26 CN CN202410346457.1A patent/CN117951120B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113688376A (en) * | 2021-07-15 | 2021-11-23 | 上海浦东发展银行股份有限公司 | Tenant authority control method for realizing container cloud platform based on CMDB system and RBAC model |
| WO2024016049A1 (en) * | 2022-07-18 | 2024-01-25 | Nansen Pty Ltd | A system and method for implementing responsive, cost-effective immutability and data integrity validation in cloud and distributed storage systems using distributed ledger and smart contract technology |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117951120A (en) | 2024-04-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107506451B (en) | Abnormal information monitoring method and device for data interaction | |
| US9037555B2 (en) | Asynchronous collection and correlation of trace and communications event data | |
| US10545981B2 (en) | Virtual repository management | |
| CN102054025B (en) | Traffic information resource integration processing method and system | |
| CN111949693B (en) | Data processing device, data processing method, storage medium and electronic equipment | |
| CN112181393B (en) | Front-end and back-end code generation method and device, computer equipment and storage medium | |
| US9515948B2 (en) | Techniques for generically accessing data | |
| CN111831755B (en) | Cross-database data synchronization method, system, medium and device | |
| CN112351024B (en) | Public network communication safety monitoring system and method | |
| CN113360519B (en) | Data processing method, device, equipment and storage medium | |
| US11301475B1 (en) | Transmission handling of analytics query response | |
| CN113791586A (en) | Novel industrial APP and identification registration analysis integration method | |
| US10685019B2 (en) | Secure query interface | |
| CN111241189A (en) | Method and device for synchronizing data | |
| US20070130157A1 (en) | Techniques for performing file operations involving a link at a database management system | |
| CN111767574A (en) | User permission determining method and device, electronic equipment and readable storage medium | |
| CN117951120B (en) | Method and device for integrating CloudBeaver database management system into cloud platform | |
| CN113010208B (en) | Version information generation method, device, equipment and storage medium | |
| CN111753141A (en) | Data management method and related equipment | |
| CN112948306A (en) | Method and device for expanding system interface | |
| CN111581227A (en) | Event pushing method and device, computer equipment and storage medium | |
| CN112579632A (en) | Data verification method, device, equipment and medium | |
| US20180004767A1 (en) | REST APIs for Data Services | |
| KR20040077535A (en) | System and method for generating a request for information about selected objects | |
| US10620946B1 (en) | Dynamic modeling for opaque code during static analysis |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |