CN112860705A - Database connection configuration information management method, system, device and storage medium - Google Patents
Database connection configuration information management method, system, device and storage medium Download PDFInfo
- Publication number
- CN112860705A CN112860705A CN202110256544.4A CN202110256544A CN112860705A CN 112860705 A CN112860705 A CN 112860705A CN 202110256544 A CN202110256544 A CN 202110256544A CN 112860705 A CN112860705 A CN 112860705A
- Authority
- CN
- China
- Prior art keywords
- configuration information
- connection configuration
- database connection
- database
- requester
- 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
- 238000007726 management method Methods 0.000 title claims description 96
- 238000000034 method Methods 0.000 claims abstract description 27
- 238000012545 processing Methods 0.000 claims description 15
- 238000012795 verification Methods 0.000 claims description 9
- 230000000875 corresponding effect Effects 0.000 description 27
- 238000010586 diagram Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 7
- 230000005540 biological transmission Effects 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000010485 coping Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000005012 migration Effects 0.000 description 1
- 238000013508 migration Methods 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/602—Providing cryptographic facilities or services
-
- 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/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
-
- 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/64—Protecting data integrity, e.g. using checksums, certificates or signatures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Computer Security & Cryptography (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Bioethics (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Storage Device Security (AREA)
Abstract
The invention provides a method, a system, equipment and a storage medium for managing database connection configuration information, wherein the method is deployed in a database management server and comprises the following steps: receiving a database connection configuration information acquisition request sent by a requester; acquiring database connection configuration information corresponding to the request query according to the database connection configuration information; encrypting the inquired database connection configuration information to obtain encrypted database connection configuration information; and sending the encrypted database connection configuration information to the requester. The invention maintains the database connection configuration information needed when all databases are connected on one database management server, thereby realizing the centralized management of all database connection configuration information, inquiring the corresponding database connection configuration information and returning the encrypted database connection configuration information to the application needing the information when the application requests to acquire the database connection configuration information, thereby facilitating the application to acquire the use related information.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method, a system, a device, and a storage medium for managing database connection configuration information.
Background
In the software development process, the database almost becomes a necessary data storage middleware. With the continuous change of software development industry technologies, micro-service architecture is becoming mainstream. Developers can enjoy various conveniences and benefits of microservices and also suffer from more troublesome problems, one of which is the problem of configuration management of database connection information.
Currently, there are several common methods for configuring database connection information in the industry as follows:
1. and directly packaging information such as database addresses, user names, passwords and the like together with the codes for deployment. The biggest defect of the method is that the database information is put together with the code, and the database information is easy to leak.
2. JNDI (Java Naming and Directory Interface) data sources provided using web containers. The method solves the problems in the method 1, is decoupled from codes, but each service needs to be configured with a JNDI data source independently, and cannot be managed in a centralized manner.
Disclosure of Invention
In view of the problems in the prior art, an object of the present invention is to provide a method, a system, a device, and a storage medium for managing database connection configuration information, which centrally manage all database connection configuration information, and facilitate application acquisition, use, and centralized management.
The embodiment of the invention provides a method for managing database connection configuration information, which is deployed in a database management server and comprises the following steps:
receiving a database connection configuration information acquisition request sent by a requester;
acquiring database connection configuration information corresponding to the request query according to the database connection configuration information;
encrypting the inquired database connection configuration information to obtain encrypted database connection configuration information;
and sending the encrypted database connection configuration information to the requester.
In some embodiments, the receiving between the database connection configuration information acquisition request sent by the requester and the database connection configuration information corresponding to the database connection configuration information acquisition request query further includes the following steps:
verifying the identity of the requesting party;
if the verification fails, rejecting the database connection configuration information acquisition request;
and if the verification is successful, continuously inquiring the corresponding database connection configuration information according to the database connection configuration information acquisition request.
In some embodiments, the encrypting the queried database connection configuration information includes the following steps:
inquiring a public key of the requester;
and encrypting the inquired database connection configuration information by adopting the public key of the requester.
In some embodiments, after sending the encrypted database connection configuration information to the requester, the method further includes the following steps:
after receiving the encrypted database connection configuration information, the requester decrypts the encrypted database connection configuration information by using a private key of the requester to obtain decrypted database connection configuration information;
the requester initiates a connection request to the corresponding database according to the decrypted database connection configuration information;
and the requester establishes connection with the corresponding database.
In some embodiments, after receiving the database connection configuration information acquisition request sent by the requester, the method includes the following steps:
selecting a management node for processing the database connection configuration information acquisition request from each management node according to the load state of each management node in the current database management server;
the selected management node performs: according to the database connection configuration information, acquiring database connection configuration information corresponding to the request query, encrypting the queried database connection configuration information to obtain encrypted database connection configuration information, and sending the encrypted database connection configuration information to the requester.
In some embodiments, querying the corresponding database connection configuration information according to the database connection configuration information acquisition request includes the following steps:
determining a database to be connected by the requester according to the database connection configuration information acquisition request;
and inquiring the latest database connection configuration information corresponding to the database to which the requester needs to connect.
In some embodiments, the database connection configuration information management method further includes the steps of:
receiving a database connection configuration information updating request;
determining a database needing to update configuration information and update content according to the database connection configuration information update request;
and updating the database connection configuration information of the database needing to update the configuration information according to the updating content, and recording the updating time.
The embodiment of the invention also provides a database connection configuration information management system, which is used for realizing the database connection configuration information management method, and the system comprises:
the request receiving module is used for receiving a database connection configuration information acquisition request sent by a requester;
the information query module is used for acquiring database connection configuration information corresponding to the query request according to the database connection configuration information;
the information encryption module is used for encrypting the inquired database connection configuration information to obtain encrypted database connection configuration information;
and the information sending module is used for sending the encrypted database connection configuration information to the requester.
An embodiment of the present invention further provides a database connection configuration information management device, including:
a processor;
a memory having stored therein executable instructions of the processor;
wherein the processor is configured to perform the steps of the database connection configuration information management method via execution of the executable instructions.
The embodiment of the invention also provides a computer-readable storage medium for storing a program, and the program realizes the steps of the database connection configuration information management method when being executed by a processor.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.
The database connection configuration information management method, system, device and storage medium of the invention have the following beneficial effects:
the invention maintains the database connection configuration information needed when all databases are connected on one database management server in a centralized way, thereby realizing the centralized management of all database connection configuration information, when an application requests to acquire the database connection configuration information, the corresponding database connection configuration information is inquired and encrypted and then returned to the application needing the information, the application can send a connection request to the database and establish connection based on the database connection configuration information, thereby facilitating the acquisition and use of the application, and meanwhile, the security in the data transmission process is improved and the data connection configuration information is ensured not to be leaked by encrypting the database connection configuration information and then sending the encrypted database connection configuration information.
Drawings
Other features, objects and advantages of the present invention will become more apparent upon reading of the following detailed description of non-limiting embodiments thereof, with reference to the accompanying drawings.
FIG. 1 is a flow chart of a database connection configuration information management method according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating a database connection configuration information management method according to an embodiment of the present invention;
FIG. 3 is a diagram of verifying identity of a requester and assigning nodes according to an embodiment of the present invention;
FIG. 4 is a flowchart of a requestor after receiving database connection configuration information, in accordance with an embodiment of the present invention;
FIG. 5 is a flow diagram of updating database connection configuration information, in accordance with an embodiment of the present invention;
FIG. 6 is a schematic structural diagram of a database connection configuration information management system according to an embodiment of the present invention;
fig. 7 is a schematic structural diagram of a database connection configuration information management device according to an embodiment of the present invention;
fig. 8 is a schematic structural diagram of a computer-readable storage medium according to an embodiment of the present invention.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus their repetitive description will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor devices and/or microcontroller devices.
The flow charts shown in the drawings are merely illustrative and do not necessarily include all of the steps. For example, some steps may be decomposed, and some steps may be combined or partially combined, so that the actual execution sequence may be changed according to the actual situation.
As shown in fig. 1, an embodiment of the present invention provides a method for managing database connection configuration information, which is deployed in a database management server, and the method includes the following steps:
s100: receiving a database connection configuration information acquisition request sent by a requester;
s200: acquiring database connection configuration information corresponding to the request query according to the database connection configuration information;
s300: encrypting the inquired database connection configuration information to obtain encrypted database connection configuration information;
s400: and sending the encrypted database connection configuration information to the requester.
In the database connection configuration information management method of the invention, the database connection configuration information required when all databases are connected is maintained on one database management server in a centralized way, thereby realizing the centralized management of all database connection configuration information, when an application requests to acquire the database connection configuration information, the database connection configuration information acquisition request is received through the step S100, the corresponding database connection configuration information is inquired through the step S200 and is encrypted through the step S300, the encrypted database connection configuration information is returned to the application needing the information through the step S400, the application can send the connection request to the database and establish the connection based on the database connection configuration information, thereby facilitating the application to acquire and use, and simultaneously, the security in the data transmission process is improved by encrypting and then sending the database connection configuration information, it is ensured that the data connection configuration information is not revealed.
In this embodiment, as shown in fig. 2, the requesting party may establish a connection with a database, which may be a MySQL database, an Oracle database, or the like, for each application that needs to establish a connection with the database. The requester firstly sends a database connection configuration information acquisition request to a database management server (DBManager server), sends a connection request to a corresponding database after acquiring the database connection configuration information, and can request to acquire data from the database after establishing connection. The database connection configuration information may include, but is not limited to, database addresses, database access protocols, database access keys, etc. that are required when a connection to the database is requested.
As shown in fig. 3, in this embodiment, the step S100: receiving a database connection configuration information acquisition request sent by a requester and the step S200: according to the database connection configuration information, obtaining the database connection configuration information corresponding to the request query, and further comprising the following steps:
s110: verifying the identity of the requesting party, wherein the verification can be, for example, verifying the type of the application, the name of the application, or the like, or verifying the user name and the password, or the like;
if the check fails, S120: refusing the database connection configuration information acquisition request;
if the check is successful, continue to step S200: and acquiring the database connection configuration information corresponding to the query request according to the database connection configuration information.
As shown in fig. 2, one or more management nodes are disposed in the database management server, and each management node can independently process a database connection configuration information acquisition request of a requester. Further, when the database management server receives a new database connection configuration information acquisition request, the new database connection configuration information acquisition request can be allocated to different management nodes for processing, so that the situation that a requester needs to wait for a long time to obtain a response when the concurrency of request data is large is avoided.
As shown in fig. 3, in this embodiment, the step S100: after receiving a database connection configuration information acquisition request sent by a requester, the method further comprises the following steps:
s130: selecting a management node for processing the database connection configuration information acquisition request from each management node according to the load state of each management node in the current database management server;
the selected management node performs: step S200: querying the corresponding database connection configuration information according to the database connection configuration information acquisition request, and step S300: encrypting the inquired database connection configuration information to obtain encrypted database connection configuration information, and step S400: and sending the encrypted database connection configuration information to the requester.
In this embodiment, in the step S130, when the management node for processing the request is selected, based on a preset load balancing algorithm, for example, the current database connection configuration information acquisition requests to be processed in the task list of each management node is queried, and the management node with the smallest number of the database connection configuration information acquisition requests to be processed is selected as the management node for processing the request. By adopting the load balancing algorithm, the high availability of the database connection configuration information query and acquisition service is ensured.
In this embodiment, the step S200: according to the database connection configuration information, acquiring the database connection configuration information corresponding to the query request, and the method comprises the following steps:
determining a database to be connected by the requester according to the database connection configuration information acquisition request, for example, the database connection configuration information acquisition request includes an identifier ID of the database, and the identifier ID of the requested database can be determined according to the database connection configuration information acquisition request;
and inquiring the latest database connection configuration information corresponding to the database to which the requester needs to connect.
In this embodiment, the step S300: in the encryption process of the queried database connection configuration information, an asymmetric encryption key is used to encrypt the database connection configuration information, so as to improve the encryption security of the database connection configuration information, specifically, the step S300 includes the following steps:
inquiring the public key of the requester, specifically, inquiring the public key which is disclosed by the requester according to the user name or the application name of the requester, etc.;
and encrypting the inquired database connection configuration information by adopting the public key of the requester. The encrypted database connection configuration information can be decrypted only by adopting the private key of the requesting party, so that the database connection configuration information is prevented from being leaked, and the requesting party with successful identity verification can successfully acquire the requested database connection configuration information.
As shown in fig. 4, in this embodiment, after sending the encrypted database connection configuration information to the requester, the method further includes the following steps:
s510: after receiving the encrypted database connection configuration information, the requester decrypts the encrypted database connection configuration information by using a private key of the requester to obtain decrypted database connection configuration information;
s520: the requester initiates a connection request to the corresponding database according to the decrypted database connection configuration information;
s530: and the requester establishes connection with the corresponding database. After the connection is established, the requesting party may initiate a data acquisition request to the corresponding database, and acquire the requested data from the database.
In the embodiment, the encryption process of the database connection configuration information is described by taking asymmetric encryption as an example. In other alternative embodiments, the database connection configuration information may also be encrypted by using symmetric encryption or the like, which all fall within the protection scope of the present invention.
As shown in fig. 5, in this embodiment, the database connection configuration information management method further includes the following steps:
s610: receiving a database connection configuration information updating request;
s620: determining a database needing to update configuration information and update content according to the database connection configuration information update request;
s630: and updating the database connection configuration information of the database needing to update the configuration information according to the updating content, and recording the updating time.
Therefore, because the database connection configuration information is maintained in the database management server in a centralized manner, if one or more database connection configuration information needs to be updated, the database management server only needs to update, and any modification is not needed at a requester, namely an application end, so that the application is very convenient. If large-scale database migration is needed, unified updating and maintenance can be easily carried out in the database management server.
To sum up, the database connection configuration information management method of the embodiment solves the problems of scattered database connection information, difficult management, easy leakage and the like in the operation and maintenance deployment process of the micro-service software system. The method adopts the modes of centralized management of database connection configuration information, safe encryption of data transmission, distributed calling based on a plurality of management nodes when providing query service and the like, thereby not only ensuring the safety of data, but also having enough flexibility and convenient maintenance, and leading enterprises to be capable of easily coping with fast business iteration.
As shown in fig. 6, an embodiment of the present invention further provides a database connection configuration information management system, configured to implement the database connection configuration information management method, where the system includes:
a request receiving module M100, configured to receive a database connection configuration information acquisition request sent by a requester;
the information query module M200 is configured to obtain database connection configuration information corresponding to the query request according to the database connection configuration information;
the information encryption module M300 is used for encrypting the inquired database connection configuration information to obtain encrypted database connection configuration information;
an information sending module M400, configured to send the encrypted database connection configuration information to the requester.
In the database connection configuration information management system of the invention, database connection configuration information required when all databases are connected is maintained on one database management server in a centralized way, thereby realizing the centralized management of all database connection configuration information, when an application requests to acquire the database connection configuration information, a request receiving module M100 receives a database connection configuration information acquisition request, an information query module M200 queries corresponding database connection configuration information and encrypts the database connection configuration information by an information encryption module M300, an information sending module M400 returns the encrypted database connection configuration information to the application needing the information, the application can send a connection request to the database and establish connection based on the database connection configuration information, thereby facilitating the application to acquire and use, and simultaneously, the database connection configuration information is encrypted and then sent, the safety in the data transmission process is improved, and the data connection configuration information is guaranteed not to be leaked.
In this embodiment, the database connection configuration information management system further includes an identity verification module, configured to verify the identity of the requester when the request receiving module M100 receives a database connection configuration information acquisition request sent by the requester, reject the database connection configuration information acquisition request if verification fails, and query, if verification succeeds, the information query module M200 queries the corresponding database connection configuration information according to the database connection configuration information acquisition request.
In this embodiment, a plurality of management nodes are deployed in the database management server, and each of the management nodes may be respectively deployed with one of the information query module M200, the information encryption module M300, and the information sending module M400.
In this embodiment, the database connection configuration information management system further includes a load balancing module, configured to, when the request receiving module M100 receives a database connection configuration information acquisition request sent by a requester, select a management node from the management nodes to process the database connection configuration information acquisition request according to a load state of each management node in a current database management server. The information query module M200, the information encryption module M300, and the information sending module M400 of the selected management node execute their corresponding actions to implement a response to the database connection configuration information acquisition request.
In this embodiment, the querying module M200 queries the corresponding database connection configuration information according to the database connection configuration information obtaining request, including: determining a database to be connected by the requester according to the database connection configuration information acquisition request; and inquiring the latest database connection configuration information corresponding to the database to which the requester needs to connect.
In this embodiment, the information encrypting module M300 encrypts the queried database connection configuration information to obtain encrypted database connection configuration information, including: the information encryption module M300 is configured to encrypt the database connection configuration information by using an asymmetric encryption key in the encryption process of the queried database connection configuration information, so as to improve the encryption security of the database connection configuration information, specifically, the information encryption module M300 is configured to query the public key of the requestor, and specifically, the public key that the requestor has disclosed may be queried according to the user name or the application name of the requestor, and the like; and encrypting the inquired database connection configuration information by adopting the public key of the requester. And encrypting the inquired database connection configuration information by adopting the public key of the requester. The encrypted database connection configuration information can be decrypted only by adopting the private key of the requester, so that the database connection configuration information is prevented from being leaked.
In this embodiment, the database connection configuration information management system further includes an information updating module, configured to determine, when receiving a database connection configuration information updating request, a database and an updating content that need to update configuration information according to the database connection configuration information updating request; and updating the database connection configuration information of the database needing to update the configuration information according to the updating content, and recording the updating time. Therefore, by adopting the database connection configuration management system, if one or more database connection configuration information needs to be updated, the update is only carried out on the database management server, and any modification is not required to be carried out at a requesting party, namely an application end.
The embodiment of the invention also provides a database connection configuration information management device, which comprises a processor; a memory having stored therein executable instructions of the processor; wherein the processor is configured to perform the steps of the database connection configuration information management method via execution of the executable instructions.
As will be appreciated by one skilled in the art, aspects of the present invention may be embodied as a system, method or program product. Thus, various aspects of the invention may be embodied in the form of: an entirely hardware embodiment, an entirely software embodiment (including firmware, microcode, etc.) or an embodiment combining hardware and software aspects that may all generally be referred to herein as a "circuit," module "or" platform.
An electronic device 600 according to this embodiment of the invention is described below with reference to fig. 7. The electronic device 600 shown in fig. 7 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 7, the electronic device 600 is embodied in the form of a general purpose computing device. The components of the electronic device 600 may include, but are not limited to: at least one processing unit 610, at least one storage unit 620, a bus 630 that connects the various system components (including the storage unit 620 and the processing unit 610), a display unit 640, and the like.
Wherein the storage unit stores program code executable by the processing unit 610 to cause the processing unit 610 to perform steps according to various exemplary embodiments of the present invention described in the above-mentioned database connection configuration information management method section of the present specification. For example, the processing unit 610 may perform the steps as shown in fig. 1.
The storage unit 620 may include readable media in the form of volatile memory units, such as a random access memory unit (RAM)6201 and/or a cache memory unit 6202, and may further include a read-only memory unit (ROM) 6203.
The memory unit 620 may also include a program/utility 6204 having a set (at least one) of program modules 6205, such program modules 6205 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may comprise an implementation of a network environment.
The electronic device 600 may also communicate with one or more external devices 700 (e.g., keyboard, pointing device, bluetooth device, etc.), with one or more devices that enable a user to interact with the electronic device 600, and/or with any devices (e.g., router, modem, etc.) that enable the electronic device 600 to communicate with one or more other computing devices. Such communication may occur via an input/output (I/O) interface 650. Also, the electronic device 600 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via the network adapter 660. The network adapter 660 may communicate with other modules of the electronic device 600 via the bus 630. It should be appreciated that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the electronic device 600, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.
In the database connection configuration information management device, the program in the memory is executed by the processor to realize the steps of the database connection configuration information management method, so the device can also obtain the technical effect of the database connection configuration information management method.
The embodiment of the invention also provides a computer-readable storage medium for storing a program, and the program realizes the steps of the database connection configuration information management method when being executed by a processor. In some possible embodiments, aspects of the present invention may also be implemented in the form of a program product comprising program code for causing a terminal device to perform the steps according to various exemplary embodiments of the present invention described in the database connection configuration information management method section above of this specification when the program product is executed on the terminal device.
Referring to fig. 8, a program product 800 for implementing the above method according to an embodiment of the present invention is described, which may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be executed on a terminal device, such as a personal computer. However, the program product of the present invention is not limited in this regard and, in the present document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
The computer readable storage medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable storage medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).
The computer storage medium may also obtain the technical effects of the database connection configuration information management method, because the program in the computer storage medium implements the steps of the database connection configuration information management method when executed by the processor.
The foregoing is a more detailed description of the invention in connection with specific preferred embodiments and it is not intended that the invention be limited to these specific details. For those skilled in the art to which the invention pertains, several simple deductions or substitutions can be made without departing from the spirit of the invention, and all shall be considered as belonging to the protection scope of the invention.
Claims (10)
1. A database connection configuration information management method is deployed in a database management server, and comprises the following steps:
receiving a database connection configuration information acquisition request sent by a requester;
acquiring database connection configuration information corresponding to the request query according to the database connection configuration information;
encrypting the inquired database connection configuration information to obtain encrypted database connection configuration information;
and sending the encrypted database connection configuration information to the requester.
2. The database connection configuration information management method according to claim 1, wherein the step of receiving the database connection configuration information acquisition request sent by the requester and querying the corresponding database connection configuration information according to the database connection configuration information acquisition request further comprises the steps of:
verifying the identity of the requesting party;
if the verification fails, rejecting the database connection configuration information acquisition request;
and if the verification is successful, continuously inquiring the corresponding database connection configuration information according to the database connection configuration information acquisition request.
3. The database connection configuration information management method according to claim 1, wherein the encryption processing of the queried database connection configuration information includes the steps of:
inquiring a public key of the requester;
and encrypting the inquired database connection configuration information by adopting the public key of the requester.
4. The database connection configuration information management method according to claim 3, wherein after sending the encrypted database connection configuration information to the requester, further comprising the steps of:
after receiving the encrypted database connection configuration information, the requester decrypts the encrypted database connection configuration information by using a private key of the requester to obtain decrypted database connection configuration information;
the requester initiates a connection request to the corresponding database according to the decrypted database connection configuration information;
and the requester establishes connection with the corresponding database.
5. The database connection configuration information management method according to claim 1, wherein after receiving the database connection configuration information acquisition request sent by the requester, the method comprises the following steps:
selecting a management node for processing the database connection configuration information acquisition request from each management node according to the load state of each management node in the current database management server;
the selected management node performs: according to the database connection configuration information, acquiring database connection configuration information corresponding to the request query, encrypting the queried database connection configuration information to obtain encrypted database connection configuration information, and sending the encrypted database connection configuration information to the requester.
6. The database connection configuration information management method according to claim 1, wherein querying the corresponding database connection configuration information according to the database connection configuration information acquisition request includes the following steps:
determining a database to be connected by the requester according to the database connection configuration information acquisition request;
and inquiring the latest database connection configuration information corresponding to the database to which the requester needs to connect.
7. The database connection configuration information management method according to claim 1, further comprising the steps of:
receiving a database connection configuration information updating request;
determining a database needing to update configuration information and update content according to the database connection configuration information update request;
and updating the database connection configuration information of the database needing to update the configuration information according to the updating content, and recording the updating time.
8. A database connection configuration information management system for implementing the database connection configuration information management method according to any one of claims 1 to 7, the system comprising:
the request receiving module is used for receiving a database connection configuration information acquisition request sent by a requester;
the information query module is used for acquiring database connection configuration information corresponding to the query request according to the database connection configuration information;
the information encryption module is used for encrypting the inquired database connection configuration information to obtain encrypted database connection configuration information;
and the information sending module is used for sending the encrypted database connection configuration information to the requester.
9. A database connection configuration information management device, characterized by comprising:
a processor;
a memory having stored therein executable instructions of the processor;
wherein the processor is configured to perform the steps of the database connection configuration information management method of any of claims 1 to 7 via execution of the executable instructions.
10. A computer-readable storage medium storing a program, wherein the program, when executed by a processor, implements the steps of the database connection configuration information management method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110256544.4A CN112860705A (en) | 2021-03-09 | 2021-03-09 | Database connection configuration information management method, system, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110256544.4A CN112860705A (en) | 2021-03-09 | 2021-03-09 | Database connection configuration information management method, system, device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112860705A true CN112860705A (en) | 2021-05-28 |
Family
ID=75993506
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110256544.4A Pending CN112860705A (en) | 2021-03-09 | 2021-03-09 | Database connection configuration information management method, system, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112860705A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115544096A (en) * | 2022-11-22 | 2022-12-30 | 深圳市东信时代信息技术有限公司 | Data query method and device, computer equipment and storage medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060200665A1 (en) * | 2005-03-03 | 2006-09-07 | Microsoft Corporation | System and method for protecting configuration settings in distributed text-based configuration files |
| US20110153675A1 (en) * | 2009-12-23 | 2011-06-23 | International Business Machines Corporation | Common connection definitions for database clients |
| US20160117521A1 (en) * | 2014-05-12 | 2016-04-28 | CompuGroup Medical AG | Computer system for storing and retrieval of encrypted data items, client computer, computer program product and computer-implemented method |
| US20170344646A1 (en) * | 2016-05-25 | 2017-11-30 | Microsoft Technology Licensing, Llc | Database query processing on encrypted data |
| US20180013549A1 (en) * | 2016-07-06 | 2018-01-11 | Sap Se | Managing user-controlled security keys in cloud-based scenarios |
| US20180268013A1 (en) * | 2017-03-17 | 2018-09-20 | Apple Inc. | Elastic data storage system |
| CN110716960A (en) * | 2019-10-22 | 2020-01-21 | 北京锐安科技有限公司 | Database query method, device, equipment and storage medium |
| CN112307515A (en) * | 2020-11-27 | 2021-02-02 | 北京锐安科技有限公司 | Database-based data processing method and device, electronic equipment and medium |
| CN112434094A (en) * | 2020-11-24 | 2021-03-02 | 平安普惠企业管理有限公司 | Database connection method and device based on encryption algorithm and computer equipment |
-
2021
- 2021-03-09 CN CN202110256544.4A patent/CN112860705A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060200665A1 (en) * | 2005-03-03 | 2006-09-07 | Microsoft Corporation | System and method for protecting configuration settings in distributed text-based configuration files |
| US20110153675A1 (en) * | 2009-12-23 | 2011-06-23 | International Business Machines Corporation | Common connection definitions for database clients |
| US20160117521A1 (en) * | 2014-05-12 | 2016-04-28 | CompuGroup Medical AG | Computer system for storing and retrieval of encrypted data items, client computer, computer program product and computer-implemented method |
| US20170344646A1 (en) * | 2016-05-25 | 2017-11-30 | Microsoft Technology Licensing, Llc | Database query processing on encrypted data |
| US20180013549A1 (en) * | 2016-07-06 | 2018-01-11 | Sap Se | Managing user-controlled security keys in cloud-based scenarios |
| US20180268013A1 (en) * | 2017-03-17 | 2018-09-20 | Apple Inc. | Elastic data storage system |
| CN110716960A (en) * | 2019-10-22 | 2020-01-21 | 北京锐安科技有限公司 | Database query method, device, equipment and storage medium |
| CN112434094A (en) * | 2020-11-24 | 2021-03-02 | 平安普惠企业管理有限公司 | Database connection method and device based on encryption algorithm and computer equipment |
| CN112307515A (en) * | 2020-11-27 | 2021-02-02 | 北京锐安科技有限公司 | Database-based data processing method and device, electronic equipment and medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115544096A (en) * | 2022-11-22 | 2022-12-30 | 深圳市东信时代信息技术有限公司 | Data query method and device, computer equipment and storage medium |
| CN115544096B (en) * | 2022-11-22 | 2023-03-28 | 深圳市东信时代信息技术有限公司 | Data query method and device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2021197432A1 (en) | Routing method and apparatus for database cluster | |
| US10656972B2 (en) | Managing idempotent operations while interacting with a system of record | |
| CN105493099A (en) | Cryptographically attested resources for hosting virtual machines | |
| CN111783075A (en) | Authority management method, device and medium based on secret key and electronic equipment | |
| CN1953393B (en) | Software installation within a federation | |
| CN102299914A (en) | Trusted intermediary of access controlfor for enabling network layer claims | |
| US8060464B2 (en) | Data-centric distributed computing | |
| CN102299915A (en) | Access control based on network layer claims | |
| CN111177789A (en) | Authority management method, system, device and storage medium | |
| WO2021059051A1 (en) | Processing data of a database system | |
| CN113761552A (en) | Access control method, device, system, server and storage medium | |
| US10685019B2 (en) | Secure query interface | |
| CN111814131A (en) | Method and device for equipment registration and configuration management | |
| CN112860705A (en) | Database connection configuration information management method, system, device and storage medium | |
| CN103902637B (en) | Method and apparatus for providing computing resources to a user | |
| CN109683942B (en) | Script management method, script management device, script management medium and electronic equipment | |
| CN115934640A (en) | Data storage method, system, electronic equipment and storage medium | |
| CN114095200A (en) | Resource access authority management method and device, electronic equipment and medium | |
| US11297065B2 (en) | Technology for computing resource liaison | |
| WO2022146676A1 (en) | Recommendation and implementation systems and methods for edge computing | |
| CN110765445B (en) | Method and device for processing request | |
| CN114528140A (en) | Method and device for service degradation | |
| US10884621B2 (en) | Block volume mount synchronization to prevent data corruption | |
| CN111158649A (en) | Method and device for configuring multi-level parameters | |
| CN116842546B (en) | Distributed data access authorization and data service method and device, equipment and medium |
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 |