CN110597783B - Database management method, device, equipment and storage medium - Google Patents
Database management method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN110597783B CN110597783B CN201910749294.0A CN201910749294A CN110597783B CN 110597783 B CN110597783 B CN 110597783B CN 201910749294 A CN201910749294 A CN 201910749294A CN 110597783 B CN110597783 B CN 110597783B
- Authority
- CN
- China
- Prior art keywords
- database
- target
- forwarding interface
- connection
- format type
- 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
- 238000007726 management method Methods 0.000 title claims abstract description 56
- 238000000034 method Methods 0.000 claims abstract description 33
- 238000012795 verification Methods 0.000 claims description 10
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 238000013507 mapping Methods 0.000 claims description 6
- 238000011217 control strategy Methods 0.000 claims description 5
- 238000004458 analytical method Methods 0.000 claims description 4
- 238000004590 computer program Methods 0.000 claims description 4
- 238000012986 modification Methods 0.000 description 9
- 230000004048 modification Effects 0.000 description 9
- 238000012217 deletion Methods 0.000 description 8
- 230000037430 deletion Effects 0.000 description 8
- 238000012545 processing Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 5
- 238000011161 development Methods 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000010354 integration Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000003416 augmentation Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000008570 general process Effects 0.000 description 2
- 230000002688 persistence Effects 0.000 description 2
- 239000000969 carrier Substances 0.000 description 1
- 239000000470 constituent Substances 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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
Abstract
The invention relates to the technical field of big data, and discloses a database management method, a device, equipment and a storage medium, which are used for forwarding the operation of a terminal through a database forwarding interface to finish the operation of a database, thereby increasing the call flexibility of a database system and improving the working efficiency. The method comprises the following steps: receiving a database operation instruction sent by a terminal, wherein the database operation instruction is used for accessing a target database; analyzing the database operation instruction to generate target parameters, wherein the target parameters comprise a database connection string, a database account number, a database password and an SQL sentence; deploying a database forwarding interface according to the target parameters; sending the database operation instruction to the target database through the database forwarding interface; and receiving feedback data of the target database.
Description
Technical Field
The present invention relates to the field of big data technologies, and in particular, to a method, an apparatus, a device, and a storage medium for database management.
Background
A database is a unit or a general data processing system in an application area that stores a collection of related data pertaining to businesses and institutions, communities and individuals. The data in the database is established from the global point of view, and is organized, described and stored according to a certain data model. The structure is based on the natural connection between the data, so that all necessary access paths can be provided, and the data is not aimed at a certain application any more, but is oriented to the whole organization, and has integral structural characteristics.
With the widespread use of enterprise informatization systems, databases have become critical to maintaining business operations for enterprises. As the size of enterprises changes, databases need to provide data services for enterprise branch structures in different places.
When the database and the control server cannot communicate directly, the control server cannot call the database, and the working efficiency is affected.
Disclosure of Invention
The invention provides a database management method, a device, equipment and a storage medium, which are used for forwarding the operation of a terminal through a database forwarding interface to finish the operation of a database, so that the call flexibility of a database system is improved, and the working efficiency is improved.
A first aspect of an embodiment of the present invention provides a database management method, including: receiving a database operation instruction sent by a terminal, wherein the database operation instruction is used for accessing a target database; analyzing the database operation instruction to generate target parameters, wherein the target parameters comprise a database connection string, a database account number, a database password and a Structured Query Language (SQL) statement; deploying a database forwarding interface according to the target parameters; sending the database operation instruction to the target database through the database forwarding interface; and receiving feedback data of the target database.
Optionally, in a first implementation manner of the first aspect of the embodiment of the present invention, the deploying a database forwarding interface according to the target parameter includes: invoking a preset spring model view controller spring MVC frame to build a WEB environment; creating an initial interface in a controller layer of a preset spring framework; creating a database forwarding interface by taking the database connection string, the database account number, the database password and the SQL sentence in the target parameters as the parameters of the initial interface; and calling a preset mapping configuration mybatis framework to deploy the database forwarding interface.
Optionally, in a second implementation manner of the first aspect of the embodiment of the present invention, the creating a database forwarding interface using the database connection string, the database account, the database password, and the SQL statement as the parameters of the initial interface includes: determining a format type to be selected according to the specification of the initial interface, wherein the format type to be selected comprises a Jessen json format, a list format and/or an array format; determining a first format type corresponding to the database connection string, a second format type corresponding to the database account, a third format type corresponding to the database password and a fourth format type corresponding to the SQL sentence according to the format type to be selected; performing format conversion on the database connection string, the database account number, the database password and the SQL sentence based on the first format type, the second format type, the third format type and the fourth format type; and creating a database forwarding interface based on the converted database connection string, the converted database account number, the converted database password and the converted SQL sentence.
Optionally, in a third implementation manner of the first aspect of the embodiment of the present invention, after the deploying a database forwarding interface according to the target parameter, before the sending, by the database forwarding interface, the database operation instruction to the target database, the method further includes: and establishing network connection between the database forwarding interface and the target database.
Optionally, in a fourth implementation manner of the first aspect of the embodiment of the present invention, the establishing a network connection between the database forwarding interface and the target database includes: determining an Internet Protocol (IP) address and a network port according to the database connection string; determining the database name according to the IP address and the network port; logging in a target database corresponding to the database name through the database account number and the database password; generating a connection object of the target database; establishing network connection with the database forwarding interface through the connect object; and feeding back a connection success message to the terminal, wherein the connection success message is used for indicating that the database forwarding interface is successfully connected to the target database.
Optionally, in a fifth implementation manner of the first aspect of the embodiment of the present invention, after the establishing a network connection with the database forwarding interface through the connect object, before the feeding back a connection success message to the terminal, the connection success message is used to indicate that the database forwarding interface is successfully connected to the target database, the method further includes: judging whether the waiting time length exceeds a preset time length;
and if the waiting time exceeds the preset time, restarting the network connection request between the database forwarding interface and the target database.
Optionally, in a sixth implementation manner of the first aspect of the embodiment of the present invention, after the receiving feedback data of the target database, the method further includes: checking the feedback data; and if the feedback data passes the verification, forwarding the feedback data to the terminal according to a preset flow control strategy.
A second aspect of an embodiment of the present invention provides a database management apparatus, including: the first receiving unit is used for receiving a database operation instruction sent by the terminal, wherein the database operation instruction is used for accessing a target database; the analysis generating unit is used for analyzing the database operation instruction to generate target parameters, wherein the target parameters comprise a database connection string, a database account number, a database password and an SQL sentence; the deployment unit is used for deploying the database forwarding interface according to the target parameters; the sending unit is used for sending the database operation instruction to the target database through the database forwarding interface; and the second receiving unit is used for receiving the feedback data of the target database.
Optionally, in a first implementation manner of the second aspect of the embodiment of the present invention, the deployment unit includes: the building module is used for calling a spring MVC frame of a preset spring model view controller to build a WEB environment; the first creation module is used for creating an initial interface in a controller layer of a preset spring frame; the second creating module is used for creating a database forwarding interface by taking the database connection string, the database account number, the database password and the SQL sentence in the target parameters as the parameters of the initial interface; the deployment module is used for calling a preset mapping configuration mybatis framework to deploy the database forwarding interface.
Optionally, in a second implementation manner of the second aspect of the embodiment of the present invention, the second creating module is specifically configured to: determining a format type to be selected according to the specification of the initial interface, wherein the format type to be selected comprises a Jessen json format, a list format and/or an array format; determining a first format type corresponding to the database connection string, a second format type corresponding to the database account, a third format type corresponding to the database password and a fourth format type corresponding to the SQL sentence according to the format type to be selected; performing format conversion on the database connection string, the database account number, the database password and the SQL sentence based on the first format type, the second format type, the third format type and the fourth format type; and creating a database forwarding interface based on the converted database connection string, the converted database account number, the converted database password and the converted SQL sentence.
Optionally, in a third implementation manner of the second aspect of the embodiment of the present invention, the database management device further includes: and the connection unit is used for establishing network connection between the database forwarding interface and the target database.
Optionally, in a fourth implementation manner of the second aspect of the embodiment of the present invention, the connection unit includes: a first determining module, configured to determine an internet protocol IP address and a network port according to the database connection string; a second determining module, configured to determine the database name according to the IP address and the network port; the login module is used for logging in a target database corresponding to the database name through the database account number and the database password; the generation module is used for generating a connection object of the target database; the connection module is used for establishing network connection with the database forwarding interface through the connect object; and the feedback module is used for feeding back a connection success message to the terminal, wherein the connection success message is used for indicating that the database forwarding interface is successfully connected to the target database.
Optionally, in a fifth implementation manner of the second aspect of the embodiment of the present invention, the connection unit further includes: the judging module is used for judging whether the waiting time exceeds the preset time; and the reconnection module is used for reinitiating the network connection request between the database forwarding interface and the target database if the waiting time exceeds the preset time.
Optionally, in a sixth implementation manner of the second aspect of the embodiment of the present invention, the database management device further includes: the verification unit is used for verifying the feedback data; and the forwarding unit is used for forwarding the feedback data to the terminal according to a preset flow control strategy if the feedback data passes the verification.
A third aspect of the embodiment of the present invention provides a database management apparatus, including a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor implements the database management method according to any one of the foregoing embodiments when executing the computer program.
A fourth aspect of the embodiments of the present invention provides a computer-readable storage medium comprising instructions which, when executed on a computer, cause the computer to perform the steps of the database management method according to any of the embodiments described above.
In the technical scheme provided by the embodiment of the invention, a database operation instruction sent by a terminal is received, wherein the database operation instruction is used for accessing a target database; analyzing the database operation instruction to generate target parameters, wherein the target parameters comprise a database connection string, a database account number, a database password and an SQL sentence; deploying a database forwarding interface according to the target parameters; sending the database operation instruction to the target database through the database forwarding interface; and receiving feedback data of the target database. According to the embodiment of the invention, the operation of the terminal is forwarded through the database forwarding interface, so that the operation of the database is completed, the call flexibility of the database system is improved, and the working efficiency is improved.
Drawings
FIG. 1 is a schematic diagram of an embodiment of a database management method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of another embodiment of a database management method according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of an embodiment of a database management apparatus according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of another embodiment of a database management apparatus according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of an embodiment of a database management apparatus according to an embodiment of the present invention.
Detailed Description
The invention provides a database management method, a device, equipment and a storage medium, which are used for forwarding the operation of a terminal through a database forwarding interface to finish the operation of a database, so that the call flexibility of a database system is improved, and the working efficiency is improved.
In order to enable those skilled in the art to better understand the present invention, embodiments of the present invention will be described below with reference to the accompanying drawings.
The terms "first," "second," "third," "fourth" and the like in the description and in the claims and in the above drawings, if any, are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments described herein may be implemented in other sequences than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed or inherent to such process, method, article, or apparatus.
Referring to fig. 1, a flowchart of a database management method provided in an embodiment of the present invention specifically includes:
101. and receiving a database operation instruction sent by the terminal, wherein the database operation instruction is used for accessing the target database.
And the server receives a database operation instruction sent by the terminal, wherein the database operation instruction is used for accessing the target database. Wherein different database operation instructions correspond to different structured query language (structured query language, SQL) statements. The database operation instructions may include database query instructions, database modification instructions, database deletion instructions, and database addition instructions. For example, the database query instruction may be: select id from user where name = 'li si'; the database modification instruction may be: update user set name = 'wang wu' where id= '0002'; the database deletion instruction may be: delete from user where id = '0001'; the database augmentation instruction may be: insert inter user (id, name) values ('0003', 'Zhao Qian').
It should be noted that, in the embodiment of the present invention, the database operation instruction is an operation instruction set according to actual needs, and related operations are executed on the database.
It is to be understood that the execution subject of the present invention may be a database management device, a terminal or a server, and is not limited herein. The embodiment of the invention is described by taking a server as an execution main body as an example.
102. Analyzing the database operation instruction to generate target parameters, wherein the target parameters comprise a database connection string, a database account number, a database password and a structured query language SQL sentence.
The server analyzes the database operation instruction to obtain target parameters, wherein the target parameters comprise a database connection string, a database account number, a database password and a structured query language SQL sentence.
It will be appreciated that the target parameters may include, in addition to a database connection string, a database account number, a database password, and a structured query language SQL statement, where the database connection string is represented by a uniform resource locator (uniform resource locator, URL), and URL has the same meaning in this embodiment; the database account number is represented by a user, the database password is represented by a passwd, and the SQL statement is represented by content; the target parameters may also include other parameters, such as a specified parameter name (params), a parameter value (values), etc., and are not limited in particular herein.
For example, when the target parameters include only a database connection string (url), a database account number (user), a database password (passwd), and a structured query language SQL statement (content), the specific contents are as follows:
the specific structure of the database connection string is that,
url:(DESCRIPTION＝(ADDRESS＝(PROTOCOL＝tcp)(HOST＝30.4.4.197)(PORT＝1539))(CONNECT_DATA＝(SID＝t0phacp)))；
the specific structure of the database account number is user: admin;
the specific structure of the database password is that the password is 123456;
the specific structure of the structured query language sentence is content select id from user where name = 'Lifour'.
And when the target parameter also comprises the parameters of variable params and value values, the specific contents are as follows:
the specific structure of the database connection string is that,
url:(DESCRIPTION＝(ADDRESS＝(PROTOCOL＝tcp)(HOST＝30.4.4.197)(PORT＝1539))(CONNECT_DATA＝(SID＝t0phacp)))；
the specific structure of the database account number is user: admin;
the specific structure of the database password is that the password is 123456;
the specific structure of the structured query language statement is content select id from user where name = '# { name }' and age= '# { age }';
the specific structure of the variable is params, name & age;
the specific structure of the values is that the values are [ { 'Lifour', 27}, { 'Wangwu', 25} ].
103. And deploying the database forwarding interface according to the target parameters.
The server deploys the database forwarding interface according to the target parameters. Specifically, the server calls a preset spring MVC frame to build a WEB environment; the method comprises the steps that a server creates an initial interface in a controller layer of a controller of a preset spring framework; the server takes the database connection string, the database account number, the database password and the SQL sentence as the parameters of the initial interface to create a database forwarding interface; and the server calls a preset mapping configuration mybatis framework to deploy the database forwarding interface.
Among them, spring model view controller (spring model view controller, spring MVC) is a development framework for developing web engineering. Integration spring, mybatis framework is also required during development. The interface service is developed by using spring+spring MVC+mybatis, and the general process is as follows: an interface is developed in the controller layer, an execution method is developed for the interface, and processing codes are written in the method, so that the codes realize logic for operating a database. The transmitted database connection string, database account number, database password and SQL sentence are used as entry parameters, the entry parameters are used in the code to establish database connection and operation, and then the operation result is returned to the calling party.
For example, a database connection string refers to a string of characters:
(database= (address= (process=tcp) (host= 30.4.4.197) (port=1539)) (connect_data= (sid=t0phacp))), the database connection string identifying the IP, PORT, database of the connected server.
It should be noted that the format types include jessen format, list format, and/or array format. The specific format is as follows: json format, such as { "msg": "success", "flag": "1" }; list format, such as [ {3,6}, {2,11}, {4,6} ]; array formats, e.g. 4,7,2,5
For example, assuming that the values of the msg and flag fields in the database table now need to be checked, then an entry in json format { "msg": "success", "flag": "1" }; assuming that it is now necessary to query the data in the database table when the values of flag1 and flag2 are different combinations, a List may be entered: [ {3,6}, {2,11}, {4,6} ]; assuming that the data in the database table when the values of the flag fields are different values are required to be queried, an array [4,7,2,5] can be transmitted; according to the different types of the input parameters, the database service interface can perform corresponding analysis and give the parameter values to SQL sentences for operation.
104. And sending the database operation instruction to the target database through the database forwarding interface.
The server sends the database operation instruction to the target database through the database forwarding interface. Specifically, when the server invokes the database forwarding interface service, for different types of incoming parameters, the field names to be received by the values of the incoming parameters are designated at the same time of incoming, so that the values are assigned to corresponding variables in sequence by the background. For example, two parameter names of [ {3,6}, {2,11}, {4,6} ], and two parameter names of the flag1 and the flag2 are simultaneously introduced, so that in the background, three groups of values of {3,6}, {2,11}, and {4,6} are sequentially introduced into the flag1 and the flag2 respectively. Assuming that this is a query statement, the query statement is executed 3 times by the target database, and the query condition is that flag1 and flag2 respectively take the three sets of values.
It should be noted that, when supporting connection, an execution statement may be transferred in, that is, when the database forwarding interface is called to forward, an operation statement to be applied to the target database is also transferred in as a parameter, so that the forwarding interface returns not only a connect object but also an operation result. Support the addition, deletion, querying, modification and storage of data in the operational database while forwarding.
It can be appreciated that the forwarding process is not only forwarding, but also needs to encapsulate database objects, develop control layer, service layer, and persistence layer logic, so that parameter expansion can be flexibly supported, and the method is not limited herein.
105. Feedback data of the target database is received.
The server receives feedback data of the target database. It should be noted that, a plurality of database instructions sent by the server may be performed simultaneously. For example, the server may receive multiple database operation instructions from multiple users' terminals at the same time, and then the server may initiate the addition, deletion, query, modification, and storage operations on different (or the same) databases, each of which may be performed at the same time.
For example, if the database operation instruction is used to find "identity information of the plum four" in the target database, the information of the identity card number, the age, the issuing authority, the native place, etc. of the "plum four" is extracted in the target database and packaged into a feedback data packet.
According to the embodiment of the invention, the database forwarding interface is deployed on the server, and the operation of the terminal is forwarded through the database forwarding interface, so that the problem that the database and the terminal cannot be directly communicated is solved, the operation of the database is realized, the call flexibility of the system is improved, and the working efficiency is improved.
Referring to fig. 2, another flowchart of a database management method according to an embodiment of the present invention specifically includes:
201. and receiving a database operation instruction sent by the terminal, wherein the database operation instruction is used for accessing the target database.
And the server receives a database operation instruction sent by the terminal, wherein the database operation instruction is used for accessing the target database. Wherein different database operation instructions correspond to different structured query language (structured query language, SQL) statements. The database operation instructions may include database query instructions, database modification instructions, database deletion instructions, and database addition instructions. For example, the database query instruction may be: select id from user where name = 'li si'; the database modification instruction may be: update user set name = 'wang wu' where id= '0002'; the database deletion instruction may be: delete from user where id = '0001'; the database augmentation instruction may be: insert inter user (id, name) values ('0003', 'Zhao Qian').
It should be noted that, in the embodiment of the present invention, the database operation instruction is an operation instruction set according to actual needs, and related operations are executed on the database.
It is to be understood that the execution subject of the present invention may be a database management device, a terminal or a server, and is not limited herein. The embodiment of the invention is described by taking a server as an execution main body as an example.
202. Analyzing the database operation instruction to generate target parameters, wherein the target parameters comprise a database connection string, a database account number, a database password and a structured query language SQL sentence.
The server analyzes the database operation instruction to obtain target parameters, wherein the target parameters comprise a database connection string, a database account number, a database password and a structured query language SQL sentence. It will be appreciated that the target parameters may include, in addition to a database connection string, a database account number, a database password, and a structured query language SQL statement, where the database connection string is represented by a uniform resource locator (uniform resource locator, URL), and URL has the same meaning in this embodiment; the database account number is represented by a user, the database password is represented by a passwd, and the SQL statement is represented by content; the target parameters may also include other parameters, such as a specified parameter name (params), a parameter value (values), etc., and are not limited in particular herein.
For example, when the target parameters include only a database connection string (url), a database account number (user), a database password (passwd), and a structured query language SQL statement (content), the specific contents are as follows:
the specific structure of the database connection string is that,
url:(DESCRIPTION＝(ADDRESS＝(PROTOCOL＝tcp)(HOST＝30.4.4.197)(PORT＝1539))(CONNECT_DATA＝(SID＝t0phacp)))；
the specific structure of the database account number is user: admin;
the specific structure of the database password is that the password is 123456;
the specific structure of the structured query language sentence is content select id from user where name = 'Lifour'.
And when the target parameter also comprises the parameters of variable params and value values, the specific contents are as follows:
the specific structure of the database connection string is that,
url:(DESCRIPTION＝(ADDRESS＝(PROTOCOL＝tcp)(HOST＝30.4.4.197)(PORT＝1539))(CONNECT_DATA＝(SID＝t0phacp)))；
the specific structure of the database account number is user: admin;
the specific structure of the database password is that the password is 123456;
the specific structure of the structured query language statement is content select id from user where name = '# { name }' and age= '# { age }';
the specific structure of the variable is params, name & age;
the specific structure of the values is that the values are [ { 'Lifour', 27}, { 'Wangwu', 25} ].
203. And deploying the database forwarding interface according to the target parameters.
The server deploys the database forwarding interface according to the target parameters. Specifically, the server calls a preset spring MVC frame to build a WEB environment; the method comprises the steps that a server creates an initial interface in a controller layer of a preset spring framework; the server takes the database connection string, the database account number, the database password and the SQL sentence as the parameters of the initial interface to create a database forwarding interface; and the server calls a preset mybatis framework to deploy the database forwarding interface.
Among them, spring MVC is a development framework for developing web engineering. Integration spring, mybatis framework is also required during development. The interface service is developed by using spring+spring MVC+mybatis, and the general process is as follows: an interface is developed in the controller layer, an execution method is developed for the interface, and processing codes are written in the method, so that the codes realize logic for operating a database. The transmitted database connection string, database account number, database password and SQL sentence are used as entry parameters, the entry parameters are used in the code to establish database connection and operation, and then the operation result is returned to the calling party.
For example, a database connection string refers to a string of characters:
(database= (address= (process=tcp) (host= 30.4.4.197) (port=1539)) (connect_data= (sid=t0phacp))), the database connection string represents the IP, PORT, database of connected servers.
The server takes a database connection string, a database account number, a database password and an SQL sentence as parameters of an initial interface to obtain a database forwarding interface, and the method comprises the following steps: the server determines the format type according to the specification of the initial interface, wherein the format type comprises json format, list format and/or array format; the server determines a first format type corresponding to the database connection string, a second format type corresponding to the database account, a third format type corresponding to the database password and a fourth format type corresponding to the SQL sentence in the preset data types; the server performs format conversion on the database connection string, the database account number, the database password and the SQL sentence based on the first format type, the second format type, the third format type and the fourth format type; the server creates a database forwarding interface based on the converted database connection string, the converted database account number, the converted database password, and the converted SQL statement.
It should be noted that the format types include json format, list format, and tuple format. The specific format is as follows: json format, such as { "msg": "success", "flag": "1" }; list format, such as [ {3,6}, {2,11}, {4,6} ]; array formats, e.g. 4,7,2,5
For example, assuming that the values of the msg and flag fields in the database table now need to be checked, then an entry in json format { "msg": "success", "flag": "1" }; assuming that it is now necessary to query the data in the database table when the values of flag1 and flag2 are different combinations, a List may be entered: [ {3,6}, {2,11}, {4,6} ]; assuming that the data in the database table when the values of the flag fields are different values are required to be queried, an array [4,7,2,5] can be transmitted; according to the different types of the input parameters, the database service interface can perform corresponding analysis and give the parameter values to SQL sentences for operation.
204. A network connection is established between the database forwarding interface and the target database.
The server establishes a network connection between the database forwarding interface and the target database. Specifically, the server determines an IP address and a network port according to the database connection string; the server determines the name of the database according to the IP address and the network port; the server logs in a target database corresponding to the database name through the database account number and the database password; the server generates a connect object of the target database; the server establishes network connection with the database forwarding interface through the connect object; the server feeds back a connection success message to the terminal, wherein the connection success message is used for indicating that the database forwarding interface is successfully connected to the target database.
Optionally, after the server establishes network connection with the database forwarding interface through the connect object, before the server feeds back a connection success message to the terminal, the connection success message is used to indicate that the database forwarding interface is successfully connected to the target database, the method further includes: the server judges whether the waiting time length exceeds a preset time length; if the waiting time exceeds the preset time, the server reinitiates the network connection request between the database forwarding interface and the target database.
205. And sending the database operation instruction to the target database through the database forwarding interface.
The server sends the database operation instruction to the target database through the database forwarding interface. Specifically, when the server invokes the database forwarding interface service, for different types of incoming parameters, the field names to be received by the values of the incoming parameters are designated at the same time of incoming, so that the values are assigned to corresponding variables in sequence by the background. For example, two parameter names of [ {3,6}, {2,11}, {4,6} ], and two parameter names of the flag1 and the flag2 are simultaneously introduced, so that in the background, three groups of values of {3,6}, {2,11}, and {4,6} are sequentially introduced into the flag1 and the flag2 respectively. Assuming that this is a query statement, the query statement is executed 3 times by the target database, and the query condition is that flag1 and flag2 respectively take the three sets of values.
It should be noted that, when supporting connection, an execution statement may be transferred in, that is, when the database forwarding interface is called to forward, an operation statement to be applied to the target database is also transferred in as a parameter, so that the forwarding interface returns not only a connect object but also an operation result. Support the addition, deletion, querying, modification and storage of data in the operational database while forwarding.
It can be appreciated that the forwarding process is not only forwarding, but also needs to encapsulate database objects, develop control layer, service layer, and persistence layer logic, so that parameter expansion can be flexibly supported, and the method is not limited herein.
206. Feedback data of the target database is received.
The server receives feedback data of the target database. It should be noted that, a plurality of database instructions sent by the server may be performed simultaneously. For example, the server may receive multiple database operation instructions from multiple users' terminals at the same time, and then the server may initiate the addition, deletion, query, modification, and storage operations on different (or the same) databases, each of which may be performed at the same time.
The embodiment of the invention solves the problem that the database and the control server cannot communicate directly, and the operation of the control server is forwarded through the database forwarding interface by deploying the database forwarding interface on the forwarding server, so that the access to the database is realized, the operation to the database is completed, the call flexibility of the system is increased, and the working efficiency is improved.
207. And checking the feedback data.
And the server checks the feedback data. Specifically, the server acquires an instruction execution identifier from feedback data; the server judges whether the instruction execution identification is matched with the identification of the database operation instruction; if the instruction execution identification is matched with the identification of the database operation instruction, the server determines that the database operation instruction is executed correctly and is checked to be qualified; if the instruction execution identification is not matched with the identification of the database operation instruction, the server determines that the database operation instruction is in error execution and is unqualified in verification.
208. And if the feedback data passes the verification, forwarding the feedback data to the terminal according to a preset flow control strategy.
If the feedback data passes the verification, the server forwards the feedback data to the terminal according to a preset flow control strategy. The preset flow control policy, that is, according to the access amount of the database, may appropriately adjust the database operation instruction in a manner of a fixed duration or a time interval, for example, delay execution, terminate execution, or the like, which is not limited herein.
According to the embodiment of the invention, the database forwarding interface is deployed on the server, and the operation of the terminal is forwarded through the database forwarding interface, so that the problem that the database and the terminal cannot be directly communicated is solved, the operation of the database is realized, the call flexibility of the system is improved, and the working efficiency is improved.
The database management method in the embodiment of the present invention is described above, and the database management device in the embodiment of the present invention is described below, referring to fig. 3, where an embodiment of the database management device in the embodiment of the present invention includes:
a first receiving unit 301, configured to receive a database operation instruction sent by a terminal, where the database operation instruction is used to access a target database;
the parsing generation unit 302 is configured to parse the database operation instruction to generate target parameters, where the target parameters include a database connection string, a database account number, a database password, and an SQL statement;
a deployment unit 303, configured to deploy a database forwarding interface according to the target parameter;
a sending unit 304, configured to send the database operation instruction to the target database through the database forwarding interface;
and a second receiving unit 305, configured to receive feedback data of the target database.
According to the embodiment of the invention, the database forwarding interface is deployed on the server, and the operation of the terminal is forwarded through the database forwarding interface, so that the problem that the database and the terminal cannot be directly communicated is solved, the operation of the database is realized, the call flexibility of the system is improved, and the working efficiency is improved.
Referring to fig. 4, another embodiment of the database management apparatus according to the present invention includes:
a first receiving unit 301, configured to receive a database operation instruction sent by a terminal, where the database operation instruction is used to access a target database;
the parsing generation unit 302 is configured to parse the database operation instruction to generate target parameters, where the target parameters include a database connection string, a database account number, a database password, and an SQL statement;
a deployment unit 303, configured to deploy a database forwarding interface according to the target parameter;
a sending unit 304, configured to send the database operation instruction to the target database through the database forwarding interface;
and a second receiving unit 305, configured to receive feedback data of the target database.
Optionally, the deployment unit 303 includes:
a building module 3031, configured to invoke a preset spring model view controller spring MVC frame to build a WEB environment;
a first creating module 3032, configured to create an initial interface in a controller layer of a preset spring framework;
a second creating module 3033, configured to create a database forwarding interface by using the database connection string, the database account number, the database password, and the SQL statement in the target parameter as parameters of the initial interface;
And the deployment module 3034 is used for calling a preset mapping configuration mybatis framework to deploy the database forwarding interface.
Optionally, the second creating module 3033 is specifically configured to:
determining a format type to be selected according to the specification of the initial interface, wherein the format type to be selected comprises a Jessen json format, a list format and/or an array format; determining a first format type corresponding to the database connection string, a second format type corresponding to the database account, a third format type corresponding to the database password and a fourth format type corresponding to the SQL sentence according to the format type to be selected; performing format conversion on the database connection string, the database account number, the database password and the SQL sentence based on the first format type, the second format type, the third format type and the fourth format type; and creating a database forwarding interface based on the converted database connection string, the converted database account number, the converted database password and the converted SQL sentence.
Optionally, the database management device further includes:
a connection unit 306, configured to establish a network connection between the database forwarding interface and the target database.
Optionally, the connection unit 306 is specifically configured to:
a first determining module 3061, configured to determine an internet protocol IP address and a network port according to the database connection string;
a second determining module 3062, configured to determine the database name according to the IP address and the network port;
a login module 3063, configured to login, through the database account number and the database password, a target database corresponding to the database name;
a generating module 3064, configured to generate a connection object of the target database;
the connection module 3065 is configured to establish a network connection with the database forwarding interface through the connect object;
and the feedback module 3066 is configured to feed back a connection success message to the terminal, where the connection success message is used to indicate that the database forwarding interface is successfully connected to the target database.
Optionally, the connection unit 306 further includes:
a judging module 3067, configured to judge whether the waiting duration exceeds a preset duration;
and the reconnection module 3068 is configured to reinitiate a network connection request between the database forwarding interface and the target database if the waiting duration exceeds a preset duration.
Optionally, the database management device further includes:
A verification unit 307, configured to verify the feedback data;
and the forwarding unit 308 is configured to forward the feedback data to the terminal according to a preset flow control policy if the feedback data passes the verification.
According to the embodiment of the invention, the database forwarding interface is deployed on the server, and the operation of the terminal is forwarded through the database forwarding interface, so that the problem that the database and the terminal cannot be directly communicated is solved, the operation of the database is realized, the call flexibility of the system is improved, and the working efficiency is improved.
The database management apparatus in the embodiment of the present invention is described in detail above in fig. 3 to 4 from the point of view of the modularized functional entity, and the database management device in the embodiment of the present invention is described in detail below from the point of view of hardware processing.
Fig. 5 is a schematic structural diagram of a database management device according to an embodiment of the present invention, where the database management device 500 may have a relatively large difference due to different configurations or performances, and may include one or more processors (central processing units, CPU) 501 (e.g., one or more processors) and a memory 509, and one or more storage media 508 (e.g., one or more mass storage devices) storing application programs 507 or data 506. Wherein the memory 509 and storage medium 508 may be transitory or persistent storage. The program stored on the storage medium 508 may include one or more modules (not shown), each of which may include a series of instruction operations on the database management device. Still further, the processor 501 may be configured to communicate with a storage medium 508 and execute a series of instruction operations in the storage medium 508 on the database management device 500.
The database management device 500 may also include one or more power supplies 502, one or more wired or wireless network interfaces 503, one or more input/output interfaces 504, and/or one or more operating systems 505, such as Windows Serve, mac OS X, unix, linux, freeBSD, and the like. It will be appreciated by those skilled in the art that the database management device structure shown in fig. 5 is not limiting of the database management device and may include more or fewer components than shown, or may combine certain components, or a different arrangement of components. The processor 501 may perform the functions of the parsing generating unit 302, the deployment unit 303, the connection unit 306, and the verification unit 307 in the above-described embodiments.
The following describes the respective constituent elements of the database management apparatus in detail with reference to fig. 5:
the processor 501 is a control center of the database management apparatus, and can perform processing according to a set database management method. The processor 501 connects each part of the whole database management device by various interfaces and lines, executes various functions of the database management device and processes data by running or executing software programs and/or modules stored in the memory 509 and calling data stored in the memory 509, and forwards the operation of the terminal through the database forwarding interface, thereby solving the problem that the database and the terminal cannot communicate directly, realizing the operation of the database, increasing the calling flexibility of the system and improving the working efficiency. The storage medium 508 and the memory 509 are both carriers for storing data, and in the embodiment of the present invention, the storage medium 508 may refer to an internal memory with a small storage capacity but a fast speed, and the memory 509 may be an external memory with a large storage capacity but a slow storage speed.
The memory 509 may be used to store software programs and modules, and the processor 501 performs various functional applications and data processing of the database management device 500 by running the software programs and modules stored in the memory 509. The memory 509 may mainly comprise a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function (such as deploying a database forwarding interface according to the target parameter), etc.; the storage data area may store data created according to the use of the database management device (such as target parameters), and the like. In addition, the memory 509 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid-state storage device. The database management method program and received data streams provided in embodiments of the present invention are stored in memory and when needed, processor 501 is invoked from memory 509.
When loaded and executed on a computer, produces a flow or function in accordance with embodiments of the present invention, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center by a wired (e.g., coaxial cable, fiber optic, twisted pair), or wireless (e.g., infrared, wireless, microwave, etc.) means. The computer readable storage medium may be any available medium that can be stored by a computer or a data storage device such as a server, data center, etc. that contains an integration of one or more available media. The usable medium may be a magnetic medium (e.g., a floppy disk, a hard disk, a magnetic tape), an optical medium (e.g., an optical disk), or a semiconductor medium (e.g., a Solid State Disk (SSD)), or the like.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
In the several embodiments provided in the present invention, it should be understood that the disclosed systems, devices, and methods may be implemented in other manners. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiment of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a random access memory (random access memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A method of database management, comprising:
receiving a database operation instruction sent by a terminal, wherein the database operation instruction is used for accessing a target database;
analyzing the database operation instruction to generate target parameters, wherein the target parameters comprise a database connection string, a database account number, a database password and a Structured Query Language (SQL) statement;
deploying a database forwarding interface according to the target parameters;
sending the database operation instruction to the target database through the database forwarding interface;
receiving feedback data of the target database;
the deploying a database forwarding interface according to the target parameters comprises:
Invoking a preset spring model view controller spring MVC frame to build a WEB environment;
creating an initial interface in a controller layer of a preset spring framework;
creating a database forwarding interface by taking the database connection string, the database account number, the database password and the SQL sentence in the target parameters as the parameters of the initial interface;
calling a preset mapping configuration mybatis framework to deploy the database forwarding interface;
the creating a database forwarding interface by taking the database connection string, the database account number, the database password and the SQL sentence in the target parameter as the parameters of the initial interface includes:
determining a format type to be selected according to the specification of the initial interface, wherein the format type to be selected comprises a Jessen json format, a list format and/or an array format;
determining a first format type corresponding to the database connection string, a second format type corresponding to the database account, a third format type corresponding to the database password and a fourth format type corresponding to the SQL sentence according to the format type to be selected;
performing format conversion on the database connection string, the database account number, the database password and the SQL sentence based on the first format type, the second format type, the third format type and the fourth format type;
And creating a database forwarding interface based on the converted database connection string, the converted database account number, the converted database password and the converted SQL sentence.
2. The database management method according to claim 1, wherein after said deploying a database forwarding interface according to said target parameter, before said sending said database operation instruction to said target database through said database forwarding interface, said method further comprises:
and establishing network connection between the database forwarding interface and the target database.
3. The database management method according to claim 2, wherein said establishing a network connection between said database forwarding interface and said target database comprises:
determining an Internet Protocol (IP) address and a network port according to the database connection string;
determining the database name according to the IP address and the network port;
logging in a target database corresponding to the database name through the database account number and the database password;
generating a connection object of the target database;
establishing network connection with the database forwarding interface through the connect object;
And feeding back a connection success message to the terminal, wherein the connection success message is used for indicating that the database forwarding interface is successfully connected to the target database.
4. A database management method according to claim 3, wherein after said establishing a network connection with said database forwarding interface through said connect object, before said feeding back a connection success message to said terminal, said connection success message indicating that said database forwarding interface is successfully connected to said target database, said method further comprises:
judging whether the waiting time length exceeds a preset time length;
and if the waiting time exceeds the preset time, restarting the network connection request between the database forwarding interface and the target database.
5. The database management method according to any one of claims 1 to 4, wherein after the receiving of the feedback data of the target database, the method further comprises:
checking the feedback data;
and if the feedback data passes the verification, forwarding the feedback data to the terminal according to a preset flow control strategy.
6. A database management apparatus, comprising:
The first receiving unit is used for receiving a database operation instruction sent by the terminal, wherein the database operation instruction is used for accessing a target database;
the analysis generating unit is used for analyzing the database operation instruction to generate target parameters, wherein the target parameters comprise a database connection string, a database account number, a database password and an SQL sentence;
the deployment unit is used for deploying the database forwarding interface according to the target parameters;
the sending unit is used for sending the database operation instruction to the target database through the database forwarding interface;
the second receiving unit is used for receiving feedback data of the target database;
the deployment unit includes: the building module is used for calling a spring MVC frame of a preset spring model view controller to build a WEB environment; the first creation module is used for creating an initial interface in a controller layer of a preset spring frame; the second creating module is used for creating a database forwarding interface by taking the database connection string, the database account number, the database password and the SQL sentence in the target parameters as the parameters of the initial interface; the deployment module is used for calling a preset mapping configuration mybatis framework to deploy the database forwarding interface;
The second creation module is specifically configured to: determining a format type to be selected according to the specification of the initial interface, wherein the format type to be selected comprises a Jessen json format, a list format and/or an array format; determining a first format type corresponding to the database connection string, a second format type corresponding to the database account, a third format type corresponding to the database password and a fourth format type corresponding to the SQL sentence according to the format type to be selected; performing format conversion on the database connection string, the database account number, the database password and the SQL sentence based on the first format type, the second format type, the third format type and the fourth format type; and creating a database forwarding interface based on the converted database connection string, the converted database account number, the converted database password and the converted SQL sentence.
7. The database management apparatus according to claim 6, wherein the database management apparatus further comprises: and the connection unit is used for establishing network connection between the database forwarding interface and the target database.
8. The database management apparatus according to claim 7, wherein the connection unit includes:
A first determining module, configured to determine an internet protocol IP address and a network port according to the database connection string;
a second determining module, configured to determine the database name according to the IP address and the network port;
the login module is used for logging in a target database corresponding to the database name through the database account number and the database password;
the generation module is used for generating a connection object of the target database;
the connection module is used for establishing network connection with the database forwarding interface through the connect object;
and the feedback module is used for feeding back a connection success message to the terminal, wherein the connection success message is used for indicating that the database forwarding interface is successfully connected to the target database.
9. A database management device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the database management method according to any one of claims 1-5 when executing the computer program.
10. A computer readable storage medium comprising instructions which, when run on a computer, cause the computer to perform the database management method of any of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910749294.0A CN110597783B (en) | 2019-08-14 | 2019-08-14 | Database management method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910749294.0A CN110597783B (en) | 2019-08-14 | 2019-08-14 | Database management method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110597783A CN110597783A (en) | 2019-12-20 |
| CN110597783B true CN110597783B (en) | 2024-01-05 |
Family
ID=68854313
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910749294.0A Active CN110597783B (en) | 2019-08-14 | 2019-08-14 | Database management method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110597783B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112286911B (en) * | 2020-12-15 | 2021-06-04 | 中移(苏州)软件技术有限公司 | Database management method and device, equipment and storage medium |
| CN116244361B (en) * | 2022-12-23 | 2023-10-10 | 北京柏睿数据技术股份有限公司 | Method and system for dynamic persistence processing of database connection |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101004683A (en) * | 2007-01-31 | 2007-07-25 | 华为技术有限公司 | Method and device for accessing database |
| CN103455591A (en) * | 2013-08-30 | 2013-12-18 | 国家电网公司 | Standard data exchange interface method of parallel cooperative system |
| CN104252501A (en) * | 2013-06-29 | 2014-12-31 | 华为技术有限公司 | Computing equipment and method for executing database operating command |
| CA2941728A1 (en) * | 2015-09-18 | 2017-03-18 | Fmr Llc | Real-time monitoring of computer system processor and transaction performance during an ongoing performance test |
-
2019
- 2019-08-14 CN CN201910749294.0A patent/CN110597783B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101004683A (en) * | 2007-01-31 | 2007-07-25 | 华为技术有限公司 | Method and device for accessing database |
| CN104252501A (en) * | 2013-06-29 | 2014-12-31 | 华为技术有限公司 | Computing equipment and method for executing database operating command |
| CN103455591A (en) * | 2013-08-30 | 2013-12-18 | 国家电网公司 | Standard data exchange interface method of parallel cooperative system |
| CA2941728A1 (en) * | 2015-09-18 | 2017-03-18 | Fmr Llc | Real-time monitoring of computer system processor and transaction performance during an ongoing performance test |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110597783A (en) | 2019-12-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102029277B1 (en) | Device Identifier-Dependent Operation Processing for Packet-Based Data Communications | |
| US7743147B2 (en) | Automated provisioning of computing networks using a network database data model | |
| US8019835B2 (en) | Automated provisioning of computing networks using a network database data model | |
| US7152109B2 (en) | Automated provisioning of computing networks according to customer accounts using a network database data model | |
| EP3389219A1 (en) | Access request conversion method and device | |
| US7124289B1 (en) | Automated provisioning framework for internet site servers | |
| US8250570B2 (en) | Automated provisioning framework for internet site servers | |
| CN106656650B (en) | Method and system for generating service test environment, and method, device and system for service test | |
| US20020194584A1 (en) | Automated provisioning of computing networks using a network database model | |
| WO2019237594A1 (en) | Session persistence method and apparatus, and computer device and storage medium | |
| CN110677383B (en) | Firewall wall opening method and device, storage medium and computer equipment | |
| US10051035B2 (en) | Method and apparatus for providing secure file transmission | |
| CN110381167A (en) | Block chain node based on cloud actively discovers system and method | |
| CN110597783B (en) | Database management method, device, equipment and storage medium | |
| CN111200523B (en) | Method, device, equipment and storage medium for configuring middle platform system | |
| CN109104368B (en) | Connection request method, device, server and computer readable storage medium | |
| CN105955790B (en) | Data processing method and device | |
| US20200228478A1 (en) | Electronic message control | |
| CN112968965A (en) | Metadata service method, server and storage medium for NFV network node | |
| US10623523B2 (en) | Distributed communication and task handling to facilitate operations of application system | |
| US20100296637A1 (en) | Service Processing Method, Communication System and Related Device | |
| WO2022121492A1 (en) | File transmission method and apparatus, computer device, and storage medium | |
| CN115102857A (en) | Method, device, equipment and storage medium for updating client configuration data | |
| US11861386B1 (en) | Application gateways in an on-demand network code execution system | |
| CN112929453A (en) | Method and device for sharing session data |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20231213 Address after: Room 2203, 19th Floor, Building 15, No. 39 East Third Ring Middle Road, Chaoyang District, Beijing, 100000 Applicant after: Beijing Aiche Unlimited Network Technology Co.,Ltd. Address before: Room 528, 5th Floor, Building D, Building 33, No. 99 Kechuang 14th Street, Beijing Economic and Technological Development Zone, Daxing District, Beijing, 100000 (Yizhuang Cluster, High end Industrial Zone, Beijing Pilot Free Trade Zone) Applicant before: Beijing Peihong Wangzhi Technology Co.,Ltd. Effective date of registration: 20231213 Address after: Room 528, 5th Floor, Building D, Building 33, No. 99 Kechuang 14th Street, Beijing Economic and Technological Development Zone, Daxing District, Beijing, 100000 (Yizhuang Cluster, High end Industrial Zone, Beijing Pilot Free Trade Zone) Applicant after: Beijing Peihong Wangzhi Technology Co.,Ltd. Address before: Room 201, building a, No.1 Qianwan 1st Road, Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong Province (settled in Shenzhen Qianhai business secretary Co., Ltd.) Applicant before: PING AN PUHUI ENTERPRISE MANAGEMENT Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |