CN110012075B - Data transmission method and related equipment - Google Patents
Data transmission method and related equipment Download PDFInfo
- Publication number
- CN110012075B CN110012075B CN201910184071.4A CN201910184071A CN110012075B CN 110012075 B CN110012075 B CN 110012075B CN 201910184071 A CN201910184071 A CN 201910184071A CN 110012075 B CN110012075 B CN 110012075B
- Authority
- CN
- China
- Prior art keywords
- data transmission
- connection pool
- transmission request
- threads
- database
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/50—Network services
- H04L67/60—Scheduling or organising the servicing of application requests, e.g. requests for application data transmissions using the analysis and optimisation of the required network resources
- H04L67/61—Scheduling or organising the servicing of application requests, e.g. requests for application data transmissions using the analysis and optimisation of the required network resources taking into account QoS or priority requirements
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/50—Network services
- H04L67/60—Scheduling or organising the servicing of application requests, e.g. requests for application data transmissions using the analysis and optimisation of the required network resources
- H04L67/63—Routing a service request depending on the request content or context
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Signal Processing (AREA)
- Computer Networks & Wireless Communication (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application discloses a data transmission method and related equipment, which are applied to a bank server, and the method comprises the following steps: acquiring the number of at least one data transmission request aiming at a first database received currently; acquiring state information of a database connection pool of the first database; and executing the data transmission operation aiming at each data transmission request in the at least one data transmission request according to the quantity of the at least one data transmission request and the state information. Therefore, in the embodiment of the application, the bank server can dynamically adjust the data transmission strategy so as to rapidly and orderly enter and/or read information required in the data transmission request from the first database, so that the data transmission speed is increased, and the data processing efficiency of the bank server is further increased.
Description
Technical Field
The present application relates to the technical field of server information, and in particular, to a data transmission method and related devices.
Background
With the continuous progress of society and the development of internet technology, more and more services are transacted from off-line to on-line. The banking service industry is an indispensable ring in daily life, and the banking service industry brings great convenience to people after online transaction, so that users can transact services such as balance inquiry, account transfer, loan and the like online. Along with the promotion of convenience of business handling, the abundance of financial consumption mode, more and more users choose to use the online business of handling, and because of the time of the online business of user comparatively random, lead to the emergence of the condition such as bank server short time data transmission load is too high easily, data processing inefficiency, server jam.
Disclosure of Invention
The embodiment of the application provides a data transmission method and related equipment, so that the safety of important information of a bank server in a data transmission process is ensured, the data transmission efficiency of the bank server is improved, and the data processing efficiency of the bank server is accelerated.
In a first aspect, an embodiment of the present application provides a data transmission method, which is applied to a bank server, and includes:
acquiring the number of at least one data transmission request aiming at a first database received currently;
acquiring state information of a database connection pool of the first database;
and executing the data transmission operation aiming at each data transmission request in the at least one data transmission request according to the quantity of the at least one data transmission request and the state information.
In a second aspect, an embodiment of the present application provides a data transmission apparatus, including a processing unit and a communication unit, wherein,
the processing unit is used for acquiring the number of at least one data transmission request aiming at a first database received currently; acquiring the state information of a database connection pool of the first database through the communication unit; and performing a data transfer operation for each of the at least one data transfer request according to the number of the at least one data transfer request and the status information.
In a third aspect, an embodiment of the present application provides a server, including a processor, a memory, a communication interface, and one or more programs, where the one or more programs are stored in the memory and configured to be executed by the processor, and the program includes instructions for executing steps in any method of the first aspect of the embodiment of the present application.
In a fourth aspect, the present application provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program for electronic data exchange, where the computer program makes a computer perform part or all of the steps described in any one of the methods of the first aspect of the present application.
In a fifth aspect, the present application provides a computer program product, wherein the computer program product includes a non-transitory computer-readable storage medium storing a computer program, and the computer program is operable to cause a computer to perform some or all of the steps as described in any one of the methods of the first aspect of the embodiments of the present application. The computer program product may be a software installation package.
It can be seen that, in the embodiment of the present application, the bank server obtains the number of at least one data transmission request currently received for the first database; acquiring state information of a database connection pool of the first database; and executing the data transmission operation aiming at each data transmission request in the at least one data transmission request according to the quantity of the at least one data transmission request and the state information. Therefore, the bank server can dynamically adjust the data transmission strategy according to the number of the currently received data transmission requests aiming at the first database and the state of the database connection pool of the first database so as to be convenient for quickly and orderly inputting and/or reading information required in the data transmission requests from the first database, the effect of accelerating data transmission is achieved, and the data processing efficiency of the bank server is accelerated.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic diagram of a data transmission method provided in an embodiment of the present application;
fig. 2 is a schematic flowchart of a data transmission method provided in an embodiment of the present application;
fig. 3 is a schematic flowchart of another data transmission method provided in an embodiment of the present application;
fig. 4 is a schematic flowchart of another data transmission method provided in the embodiment of the present application;
fig. 5 is a schematic structural diagram of a server provided in an embodiment of the present application;
fig. 6 is a block diagram of functional units of a data transmission method apparatus according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terms "first," "second," and the like in the description and claims of the present application and in the above-described drawings are used for distinguishing between different objects and not for describing a particular order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the application. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is explicitly and implicitly understood by one skilled in the art that the embodiments described herein can be combined with other embodiments.
The server according to the embodiment of the present application may include various handheld devices, vehicle-mounted devices, wearable devices, computing devices or other processing devices connected to a wireless modem, and various forms of User Equipment (UE), Mobile Stations (MS), terminal devices (terminal device), and the like.
As shown in fig. 1, fig. 1 is a schematic diagram of a data transmission method provided in an embodiment of the present application.
Fig. 1 includes: bank server 110, database connection pool 120, database 130. Among them, the database connection pool 120 is provided with a used connection pool 121 and a free connection pool 122. Wherein unused threads in database connection pool 120 are in free connection pool 122 and used threads are in used connection pool 121. When the bank server 110 receives at least one data transmission request for the database 130, acquiring status information of the database connection pool 120; if it is detected that threads exist in the idle connection pool 122 and the number of the threads is greater than the number of the at least one data transmission request, directly using the threads in the idle connection pool 122, determining the corresponding relationship between the threads and the data transmission requests, and putting the used threads into the used connection pool 121; if the threads exist in the idle connection pool 122 and the number of the threads is smaller than the number of the at least one data transmission request, determining a priority sequence of the at least one data transmission request, sequentially determining the corresponding relation between the threads in the idle connection pool 122 from front to back according to the priority sequence, and detecting whether the threads in the database connection pool 120 reach a maximum thread threshold value; if yes, sequentially determining the corresponding relation between the remaining data transmission requests in the at least one data transmission request and the threads according to the priority sequence when the threads are detected to appear in the idle connection pool 122; if not, establishing at least one thread belonging to the idle connection pool 122 so that the number of the threads of the database connection pool reaches the maximum value; and determines the correspondence between the newly established thread and the remaining data transmission requests in the at least one data transmission request according to the priority sequence, and sequentially determines the correspondence between the remaining data transmission requests in the at least one data transmission request and the thread according to the priority sequence when detecting that the thread occurs in the idle connection pool 122.
The present application provides a data transmission method, and the following describes embodiments of the present application in detail.
Referring to fig. 2, fig. 2 is a schematic flowchart of a data transmission method applied to a bank server according to an embodiment of the present application. As shown in the figure, the data transmission method includes:
in step 201, the bank server obtains the number of at least one data transmission request currently received for the first database.
The first database may be a component of the bank server, or may be an external database communicatively connected to the bank server. The data transmission request is information extracted by the bank server from data request information sent by the electronic equipment in communication connection with the bank server.
The first database is provided with a database connection pool, and the database connection pool is provided with a minimum thread connection number and a maximum thread connection number. The bank server can adjust the number of threads in the database connection pool according to the current data transmission number and the number of data transmission requests of a period of time after the current time point is estimated; the floating interval of the threads is between the minimum thread connection number and the maximum thread connection number.
It can be seen that, in the embodiment of the present application, the bank server obtains the number of at least one data transmission request currently received for the first database; acquiring state information of a database connection pool of the first database; and executing the data transmission operation aiming at each data transmission request in the at least one data transmission request according to the quantity of the at least one data transmission request and the state information. Therefore, the bank server can dynamically adjust the data transmission strategy according to the number of the currently received data transmission requests aiming at the first database and the state of the database connection pool of the first database so as to be convenient for quickly and orderly inputting and/or reading information required in the data transmission requests from the first database, the effect of accelerating data transmission is achieved, and the data processing efficiency of the bank server is accelerated.
In one possible example, the database connection pool includes a free connection pool and a used connection pool; the state information comprises a first number of threads in the free connection pool and a second number of threads that have used a connection pool; the bank server executes a data transmission operation for each data transmission request in the at least one data transmission request according to the number of the at least one data transmission request and the status information, and the data transmission operation includes: determining whether the number of the at least one data transmission request is greater than the first number; if yes, determining a priority sequence of the at least one data transmission request; screening out the data transmission requests of the first number of bits from the priority sequence, and determining the corresponding relation between the threads in the idle connection pool and the data transmission requests of the first number of bits; and putting the threads in the free connection pool into the used connection pool.
The used threads in the database connection pool are in the used connection pool, and the unused threads are in the idle connection pool; when the thread in the used connection pool is released, automatically putting the used connection pool into an idle connection pool; when the thread in the idle connection pool is used, the used connection pool is automatically put into the database connection pool.
For example, if the number of threads in the current free connection pool is 500 and the number of data transmission requests is 400, the bank server directly uses 400 threads in the free connection pool in the database connection pool. If the thread number of the current idle connection pool is 500 and the number of the data transmission requests is 600, the bank server analyzes the 600 data transmission requests, generates a priority sequence of the 600 data transmission requests, and screens out the data transmission requests with the priority sequence positioned at the first 500 bits; determining the corresponding relation between 500 threads in the idle connection pool and the data transmission request of which the priority sequence is positioned at the first 500 bits; then 500 threads belonging to the free connection pool are put into the used connection pool.
Therefore, in this example, the bank server can flexibly adjust the configuration scheme of data transmission according to the number of threads in the current database connection pool and the number of current data transmission requests, so that the intelligence of the bank server is improved; meanwhile, when the threads in the idle connection pool are not enough, the priority of the data transmission request can be generated, so that the data transmission request with high importance degree and emergency can be timely completed, the bank server can transmit data more orderly, and the data transmission efficiency is accelerated.
In one possible example, the bank server determines a priority sequence of the at least one data transmission request, including: obtaining a target service type for each data transmission request in the at least one data transmission request; taking the target service type as a query identifier, querying a first preset mapping relation to obtain a security level corresponding to the target service type, wherein the first preset mapping relation comprises a corresponding relation between the service type and the security level; determining a security level associated with each data transmission request according to the target service type targeted by each data transmission request and the security level corresponding to the target service type; and determining the priority sequence of the at least one data transmission request according to the security level associated with each data transmission request.
Wherein, the corresponding relation between the service type and the security level is preset; the setting method can be set according to the service types of information registration or information modification, account transfer, money deposit, money buying and financing products and the like of the current service transacted by the user; services such as information registration, information modification and the like do not relate to fund transfer-in and transfer-out, so that the security level is generally low; if the registered information is related to the information of the enterprise, the security level is relatively high, and if the transacted business is enterprise information modification, the security level is higher than that of personal information modification; similarly, for financial products, money transfers, money accesses and the like, the relevant security level is determined according to different amount values.
Therefore, in this example, the bank server may determine different security levels according to different service types, and then preferentially process the data transmission request with a higher security level, so that the risk of important information leakage is reduced under the condition of limited resources, and the security of important data in the bank server is improved.
Alternatively, the bank server may determine the priority sequence of the at least one data transmission request in combination with specific characteristics of the type of service. The bank server may determine a priority sequence of the at least one data transmission request according to a response time of the service type, and the credit. Specifically, the bank server acquires a service type targeted by at least one data transmission request, inquires a preset corresponding relation according to the service type, acquires response time corresponding to the service type, and divides the at least one data transmission request into a timely response service, a service needing to be responded within 1 hour, a service needing to be responded within 1 day and a service with response time longer than 1 day according to the response time. The response time coefficient of the timely response service is 1, the response time coefficient of the service needing to be responded in 1 hour is 0.8, the response time coefficient of the service needing to be responded in 1 day is 0.5, and the response time coefficient of the service with the response time longer than 1 day is 0.3. Meanwhile, the service types are divided into three categories, namely an information registration/modification category, a fund transfer-in/transfer-out category and a financing product category, the set service coefficient of the financing product is 1, the fund transfer-in/transfer-out category service coefficient is 0.7, and the information registration/modification category service type service coefficient is 0.2. Simultaneously acquiring the amount of money related to each data transmission request in at least one data transmission request, and determining the minimum amount of money except 0 as a first preset amount of money and the maximum amount of money as a second preset amount of money; and determining the first difference value as the second preset amount value-the first preset amount value. Calculating the priority score of each data transmission request in at least one data transmission request according to the information, wherein the specific calculation formula is as follows: the priority score is 100 response time factor 0.4+100 traffic factor 0.2+100 (amount involved in at least one data transmission request-first preset amount) 0.4/first difference. And determining the priority sequence of the at least one data transmission request from front to back according to the priority scores from high to low.
In one possible example, after the bank server determines the priority sequence of the at least one data transmission request according to the security level associated with each data transmission request, the method further includes: detecting that at least two data transmission requests with the same sequence position exist in the priority sequence; acquiring account information associated with each data transmission request in the at least two data transmission requests; taking the account information as a query identifier, querying a second preset mapping relation to obtain an account type corresponding to the account information, wherein the second preset mapping relation comprises a corresponding relation between the account information and the account type, the account type comprises a personal account and an enterprise account, and the priority of the enterprise account is greater than that of the personal account; determining the priority of the at least two data transmission requests according to the account category; updating the priority sequence according to the priorities of the at least two data transmission requests.
And updating the positions of the other data transmission requests in the priority sequence after the priority sequence according to the priorities of the at least two data transmission requests, except that the positions of the at least two data transmission requests in the priority sequence are changed, and keeping the positions of the other data transmission requests in the priority sequence unchanged.
Therefore, in this example, the bank server reorders the data transmission requests ordered at the same position in the priority sequence according to the account information, so that the bank server completes the data transmission requests orderly according to the priority sequence, the data transmission efficiency is improved, and the intelligence of the bank server is improved.
In one possible example, after the bank server puts the thread in the free connection pool into the used connection pool, the method further comprises: judging whether the sum of the number of the at least one data transmission request and the second number is greater than the maximum thread threshold of the database connection pool; if not, determining a difference value between the at least one data transmission request and the thread number of the idle connection pool; establishing the difference threads belonging to the idle connection pool; detecting that the establishment of the different threads belonging to the idle connection pool is completed; determining the corresponding relation between the different threads belonging to the idle connection pool and the rest data transmission requests in the at least one data transmission request; putting the difference threads belonging to the idle connection pool into the used connection pool; if yes, M threads belonging to the idle connection pool are established so that the number of the threads of the database connection pool reaches the maximum thread threshold value; detecting that the M threads belonging to the idle connection pool are established; determining a corresponding relation between the M threads belonging to the idle connection pool and the data transmission requests with the priority sequences from the first number of +1 bits to the first number of + M bits in the at least one data transmission request; and putting the M threads belonging to the idle connection pool into the used connection pool.
For example, the original number of threads and the second number in the used connection pool are 400, the original number of threads and the first number in the free connection pool are 300, and the original number of threads and the first number in the free connection pool are already put into the used connection pool, if the number of the data transmission requests is 700, and the maximum thread threshold of the database connection pool is 1000, 400+700>1000, 300 threads belonging to the free connection pool are established so that the number of threads in the database connection pool reaches the maximum thread threshold, and simultaneously, the corresponding relationship between the data transmission requests located from 301 th bit to 600 th bit in the priority sequence of at least one data transmission request and the newly established 300 threads is determined, and then, the newly established 300 threads are put into the used data connection pool. When the use of a certain thread in the used connection pool is finished, the thread is released and then automatically placed into the idle connection pool; when the bank server detects that a thread appears in the idle connection pool, 601 bits and 602 bits are determined according to the priority sequence until the corresponding relation between the data transmission request of the 1000 th bit in the priority sequence and the thread is determined to be completed.
As can be seen, in this example, the bank server may arrange a correspondence between each data transmission request in the at least one data transmission request and the thread according to the number of the data transmission requests, the maximum thread threshold of the database connection pool, and the priority sequence, so as to transmit the data transmission request with a higher priority in time, thereby improving the intelligence of the bank server.
In one possible example, the database connection pool includes a free connection pool and a used connection pool; the state information comprises the thread number in the idle connection pool and the thread number of the used connection pool; the bank server performs data connection operation according to the number of the at least one data transmission request and the state information, and the data connection operation includes: judging whether the number of the at least one data transmission request is larger than the thread number in the idle connection pool or not; if not, extracting the available connection threads of the number of the at least one data transmission request in the idle connection pool; determining a correspondence between the available connection thread and the at least one data transmission request; placing the available connection thread into the used connection pool.
Therefore, in this example, the bank server can directly use the idle thread in the database connection pool, and a data transmission channel does not need to be reestablished, so that the time of the data transmission process is saved, and the efficiency of data transmission is improved.
In one possible example, before the bank server obtains the number of the at least one data transmission request currently received, the method further includes: acquiring current system time; determining a time period to which the system time belongs; taking the time period as a query identifier, querying a third preset mapping relation to obtain a minimum thread number corresponding to the time period, wherein the third preset mapping relation comprises a corresponding relation between the time period and the minimum thread number; establishing the minimum number of threads between the database connection pool and the database.
Therefore, in this example, the bank server may predict the number of the current data transmission requests according to the current time point, and establish a plurality of threads with the minimum thread according to the prediction condition, thereby avoiding the resource of the database connection pool being consumed by establishing excessive threads while ensuring the data transmission rate when there is a data transmission request.
Referring to fig. 3, fig. 3 is a schematic flowchart of a data transmission method provided in the embodiment of the present application, and is applied to a bank server, consistent with the embodiment shown in fig. 2. As shown in the figure, the data transmission method includes:
in step 301, the bank server obtains the number of at least one data transmission request currently received for the first database.
It can be seen that, in the embodiment of the present application, the bank server obtains the number of at least one data transmission request currently received for the first database; acquiring state information of a database connection pool of the first database; and executing the data transmission operation aiming at each data transmission request in the at least one data transmission request according to the quantity of the at least one data transmission request and the state information. Therefore, the bank server can dynamically adjust the data transmission strategy according to the number of the currently received data transmission requests aiming at the first database and the state of the database connection pool of the first database so as to be convenient for quickly and orderly inputting and/or reading information required in the data transmission requests from the first database, the effect of accelerating data transmission is achieved, and the data processing efficiency of the bank server is accelerated.
In addition, the bank server can determine different security levels according to different service types, and then preferentially process the data transmission request with higher security level, thereby reducing the risk of important information leakage under the condition of limited resources and improving the security of important data in the bank server. .
Referring to fig. 4, fig. 4 is a schematic flowchart of a data transmission method provided in the embodiment of the present application, and is applied to a bank server, consistent with the embodiment shown in fig. 2. As shown in the figure, the data transmission method includes:
in step 401, the bank server obtains the number of at least one data transmission request currently received for the first database.
In step 403, the bank server determines whether the number of the at least one data transmission request is greater than the first number.
It can be seen that, in the embodiment of the present application, the bank server obtains the number of at least one data transmission request currently received for the first database; acquiring state information of a database connection pool of the first database; and executing the data transmission operation aiming at each data transmission request in the at least one data transmission request according to the quantity of the at least one data transmission request and the state information. Therefore, the bank server can dynamically adjust the data transmission strategy according to the number of the currently received data transmission requests aiming at the first database and the state of the database connection pool of the first database so as to be convenient for quickly and orderly inputting and/or reading information required in the data transmission requests from the first database, the effect of accelerating data transmission is achieved, and the data processing efficiency of the bank server is accelerated.
In addition, the bank server can arrange the corresponding relation between each data transmission request and the thread in at least one data transmission request according to the number of the data transmission requests, the maximum thread threshold value of the database connection pool and the priority sequence, so that the data transmission requests with higher priority can be transmitted timely, and the intelligence of the bank server is improved.
In accordance with the embodiments shown in fig. 2, fig. 3, and fig. 4, please refer to fig. 5, and fig. 5 is a schematic structural diagram of a server 500 according to an embodiment of the present application, as shown in the figure, the server 500 includes an application processor 510, a memory 520, a communication interface 530, and one or more programs 521, where the one or more programs 521 are stored in the memory 520 and configured to be executed by the application processor 510, and the one or more programs 521 include instructions for:
acquiring the number of at least one data transmission request aiming at a first database received currently;
acquiring state information of a database connection pool of the first database;
and executing the data transmission operation aiming at each data transmission request in the at least one data transmission request according to the quantity of the at least one data transmission request and the state information.
It can be seen that, in the embodiment of the present application, the bank server obtains the number of at least one data transmission request currently received for the first database; acquiring state information of a database connection pool of the first database; and executing the data transmission operation aiming at each data transmission request in the at least one data transmission request according to the quantity of the at least one data transmission request and the state information. Therefore, the bank server can dynamically adjust the data transmission strategy according to the number of the currently received data transmission requests aiming at the first database and the state of the database connection pool of the first database so as to be convenient for quickly and orderly inputting and/or reading information required in the data transmission requests from the first database, the effect of accelerating data transmission is achieved, and the data processing efficiency of the bank server is accelerated.
In one possible example, the database connection pool includes a free connection pool and a used connection pool; the state information comprises a first number of threads in the free connection pool and a second number of threads that have used a connection pool; in respect of performing the data transfer operation for each of the at least one data transfer request in dependence on the number of the at least one data transfer request and the status information, the instructions in the program are specifically configured to perform the following: determining whether the number of the at least one data transmission request is greater than the first number; if yes, determining a priority sequence of the at least one data transmission request; screening out a first number of data transmission requests from the priority sequence, and determining a corresponding relation between the threads in the idle connection pool and the first number of data transmission requests; and putting the threads in the free connection pool into the used connection pool.
In one possible example, in said determining the priority sequence of the at least one data transmission request, the instructions in the program are specifically configured to: obtaining a target service type for each data transmission request in the at least one data transmission request; taking the target service type as a query identifier, querying a first preset mapping relation to obtain a security level corresponding to the target service type, wherein the first preset mapping relation comprises a corresponding relation between the service type and the security level; determining a security level associated with each data transmission request according to the target service type targeted by each data transmission request and the security level corresponding to the target service type; and determining the priority sequence of the at least one data transmission request according to the security level associated with each data transmission request.
In one possible example, after said determining the priority sequence of the at least one data transmission request according to the security level associated with each data transmission request, the instructions in the program are further configured to: detecting that at least two data transmission requests with the same sequence position exist in the priority sequence; acquiring account information associated with each data transmission request in the at least two data transmission requests; taking the account information as a query identifier, querying a second preset mapping relation to obtain an account type corresponding to the account information, wherein the second preset mapping relation comprises a corresponding relation between the account information and the account type, the account type comprises a personal account and an enterprise account, and the priority of the enterprise account is greater than that of the personal account; determining the priority of the at least two data transmission requests according to the account category; updating the priority sequence according to the priorities of the at least two data transmission requests.
In one possible example, after the placing the threads in the free connection pool into the used connection pool, the instructions in the program are further to: judging whether the sum of the number of the at least one data transmission request and the second number is greater than the maximum thread threshold of the database connection pool; if not, determining a difference value between the at least one data transmission request and the thread number of the idle connection pool; establishing the difference threads belonging to the idle connection pool; detecting that the establishment of the different threads belonging to the idle connection pool is completed; determining the corresponding relation between the different threads belonging to the idle connection pool and the rest data transmission requests in the at least one data transmission request; putting the difference threads belonging to the idle connection pool into the used connection pool; if yes, M threads belonging to the idle connection pool are established so that the number of the threads of the database connection pool reaches the maximum thread threshold value; detecting that the M threads belonging to the idle connection pool are established; determining a corresponding relation between the M threads belonging to the idle connection pool and the data transmission requests with the priority sequences from the first number of +1 bits to the first number of + M bits in the at least one data transmission request; and putting the M threads belonging to the idle connection pool into the used connection pool.
In one possible example, the database connection pool includes a free connection pool and a used connection pool; the state information comprises the thread number in the idle connection pool and the thread number of the used connection pool; in said performing data connection operations based on said number of at least one data transfer request and said state information, instructions in said program are further operable to: judging whether the number of the at least one data transmission request is larger than the thread number in the idle connection pool or not; if not, extracting the available connection threads of the number of the at least one data transmission request in the idle connection pool; determining a correspondence between the available connection thread and the at least one data transmission request; placing the available connection thread into the used connection pool.
In one possible example, before the obtaining the number of the currently received at least one data transmission request, the instructions in the program are further configured to: acquiring current system time; determining a time period to which the system time belongs; taking the time period as a query identifier, querying a third preset mapping relation to obtain a minimum thread number corresponding to the time period, wherein the third preset mapping relation comprises a corresponding relation between the time period and the minimum thread number; establishing the minimum number of threads between the database connection pool and the database.
The above description has introduced the solution of the embodiment of the present application mainly from the perspective of the method-side implementation process. It is understood that the electronic device comprises corresponding hardware structures and/or software modules for performing the respective functions in order to realize the above-mentioned functions. Those of skill in the art will readily appreciate that the present application is capable of hardware or a combination of hardware and computer software implementing the various illustrative elements and algorithm steps described in connection with the embodiments provided herein. Whether a function is performed as hardware or computer software drives hardware depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In the embodiment of the present application, the electronic device may be divided into the functional units according to the method example, for example, each functional unit may be divided corresponding to each function, or two or more functions may be integrated into one processing unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit. It should be noted that the division of the unit in the embodiment of the present application is schematic, and is only a logic function division, and there may be another division manner in actual implementation.
Fig. 6 is a block diagram of functional units of a data transmission device 600 according to an embodiment of the present application. The data transmission device 600 is applied to a bank server, and comprises a processing unit 601 and a communication unit 602, wherein,
the processing unit 601 is configured to obtain a number of at least one currently received data transmission request for the first database; and acquiring status information of a database connection pool of the first database through the communication unit 602; and performing a data transfer operation for each of the at least one data transfer request according to the number of the at least one data transfer request and the status information.
The data transmission apparatus may further include a storage unit 603 for storing program codes and data of the electronic device. The processing unit 601 may be an application processor, the communication unit 602 may be a global communication bus, a transceiver, etc., and the storage unit 603 may be a memory.
It can be seen that, in the embodiment of the present application, the bank server obtains the number of at least one data transmission request currently received for the first database; acquiring state information of a database connection pool of the first database; and executing the data transmission operation aiming at each data transmission request in the at least one data transmission request according to the quantity of the at least one data transmission request and the state information. Therefore, the bank server can dynamically adjust the data transmission strategy according to the number of the currently received data transmission requests aiming at the first database and the state of the database connection pool of the first database so as to be convenient for quickly and orderly inputting and/or reading information required in the data transmission requests from the first database, the effect of accelerating data transmission is achieved, and the data processing efficiency of the bank server is accelerated.
In one possible example, the database connection pool includes a free connection pool and a used connection pool; the state information comprises a first number of threads in the free connection pool and a second number of threads that have used a connection pool; in terms of the performing the data transmission operation for each data transmission request of the at least one data transmission request according to the number of the at least one data transmission request and the status information, the processing unit 601 is configured to: determining whether the number of the at least one data transmission request is greater than the first number; if yes, determining a priority sequence of the at least one data transmission request; screening out a first number of data transmission requests from the priority sequence, and determining a corresponding relation between the threads in the idle connection pool and the first number of data transmission requests; and putting the threads in the free connection pool into the used connection pool.
In one possible example, in terms of the determining the priority sequence of the at least one data transmission request, the processing unit 601 is configured to: obtaining a target service type for each data transmission request in the at least one data transmission request; taking the target service type as a query identifier, querying a first preset mapping relation to obtain a security level corresponding to the target service type, wherein the first preset mapping relation comprises a corresponding relation between the service type and the security level; determining a security level associated with each data transmission request according to the target service type targeted by each data transmission request and the security level corresponding to the target service type; and determining the priority sequence of the at least one data transmission request according to the security level associated with each data transmission request.
In one possible example, after said determining the priority sequence of the at least one data transmission request according to the security level associated with each data transmission request, the processing unit 601 is further configured to: detecting that at least two data transmission requests with the same sequence position exist in the priority sequence; acquiring account information associated with each data transmission request in the at least two data transmission requests; taking the account information as a query identifier, querying a second preset mapping relation to obtain an account type corresponding to the account information, wherein the second preset mapping relation comprises a corresponding relation between the account information and the account type, the account type comprises a personal account and an enterprise account, and the priority of the enterprise account is greater than that of the personal account; determining the priority of the at least two data transmission requests according to the account category; updating the priority sequence according to the priorities of the at least two data transmission requests.
In one possible example, after the putting the threads in the free connection pool into the used connection pool, the processing unit 601 is further configured to: judging whether the sum of the number of the at least one data transmission request and the second number is greater than the maximum thread threshold of the database connection pool; if not, determining a difference value between the at least one data transmission request and the thread number of the idle connection pool; establishing the difference threads belonging to the idle connection pool; detecting that the establishment of the different threads belonging to the idle connection pool is completed; determining the corresponding relation between the different threads belonging to the idle connection pool and the rest data transmission requests in the at least one data transmission request; putting the difference threads belonging to the idle connection pool into the used connection pool; if yes, M threads belonging to the idle connection pool are established so that the number of the threads of the database connection pool reaches the maximum thread threshold value; detecting that the M threads belonging to the idle connection pool are established; determining a corresponding relation between the M threads belonging to the idle connection pool and the data transmission requests with the priority sequences from the first number of +1 bits to the first number of + M bits in the at least one data transmission request; and putting the M threads belonging to the idle connection pool into the used connection pool.
In one possible example, the database connection pool includes a free connection pool and a used connection pool; the state information comprises the thread number in the idle connection pool and the thread number of the used connection pool; in terms of the performing the data connection operation according to the number of the at least one data transmission request and the status information, the processing unit 601 is further configured to: judging whether the number of the at least one data transmission request is larger than the thread number in the idle connection pool or not; if not, extracting the available connection threads of the number of the at least one data transmission request in the idle connection pool; determining a correspondence between the available connection thread and the at least one data transmission request; placing the available connection thread into the used connection pool.
In one possible example, before the obtaining of the number of the currently received at least one data transmission request, the processing unit 601 is further configured to: acquiring current system time; determining a time period to which the system time belongs; taking the time period as a query identifier, querying a third preset mapping relation to obtain a minimum thread number corresponding to the time period, wherein the third preset mapping relation comprises a corresponding relation between the time period and the minimum thread number; establishing the minimum number of threads between the database connection pool and the database.
Embodiments of the present application also provide a computer storage medium, where the computer storage medium stores a computer program for electronic data exchange, the computer program enabling a computer to execute part or all of the steps of any one of the methods described in the above method embodiments, and the computer includes an electronic device.
Embodiments of the present application also provide a computer program product comprising a non-transitory computer readable storage medium storing a computer program operable to cause a computer to perform some or all of the steps of any of the methods as described in the above method embodiments. The computer program product may be a software installation package, the computer comprising an electronic device.
It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present application is not limited by the order of acts described, as some steps may occur in other orders or concurrently depending on the application. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required in this application.
In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus may be implemented in other manners. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, the above-described division of the units is only one type of division of logical functions, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of some interfaces, devices or units, and may be an electric or other form.
The units described as separate parts may or may not be physically separate, and parts displayed 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 can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit may be stored in a computer readable memory if it is implemented in the form of a software functional unit and sold or used as a stand-alone product. Based on such understanding, the technical solution of the present application may be substantially implemented or a part of or all or part of the technical solution contributing to the prior art may be embodied in the form of a software product stored in a memory, and including several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the above-mentioned method of the embodiments of the present application. And the aforementioned memory comprises: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
Those skilled in the art will appreciate that all or part of the steps in the methods of the above embodiments may be implemented by associated hardware instructed by a program, which may be stored in a computer-readable memory, which may include: flash Memory disks, Read-Only memories (ROMs), Random Access Memories (RAMs), magnetic or optical disks, and the like.
The foregoing detailed description of the embodiments of the present application has been presented to illustrate the principles and implementations of the present application, and the above description of the embodiments is only provided to help understand the method and the core concept of the present application; meanwhile, for a person skilled in the art, according to the idea of the present application, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present application.
Claims (8)
1. A data transmission method is applied to a bank server, and the method comprises the following steps:
acquiring the number of at least one data transmission request aiming at a first database received currently;
acquiring state information of a database connection pool of the first database; the database connection pool comprises an idle connection pool and a used connection pool; the state information comprises a first number of threads in the free connection pool and a second number of threads that have used a connection pool;
determining whether the number of the at least one data transmission request is greater than the first number;
if yes, determining a priority sequence of the at least one data transmission request;
screening out data transmission requests with sequence positions located at the first number of bits from the priority sequence, and determining the corresponding relation between the threads in the idle connection pool and the data transmission requests with the first number of bits;
and putting the threads in the free connection pool into the used connection pool.
2. The method of claim 1, wherein the determining the priority sequence of the at least one data transmission request comprises:
obtaining a target service type for each data transmission request in the at least one data transmission request;
taking the target service type as a query identifier, querying a first preset mapping relation to obtain a security level corresponding to the target service type, wherein the first preset mapping relation comprises a corresponding relation between the service type and the security level;
determining a security level associated with each data transmission request according to the target service type targeted by each data transmission request and the security level corresponding to the target service type;
and determining the priority sequence of the at least one data transmission request according to the security level associated with each data transmission request.
3. The method of claim 2, wherein after determining the priority sequence of the at least one data transmission request according to the security level associated with each data transmission request, the method further comprises:
detecting that at least two data transmission requests with the same sequence position exist in the priority sequence;
acquiring account information associated with each data transmission request in the at least two data transmission requests;
taking the account information as a query identifier, querying a second preset mapping relation to obtain an account type corresponding to the account information, wherein the second preset mapping relation comprises a corresponding relation between the account information and the account type, the account type comprises a personal account and an enterprise account, and the priority of the enterprise account is greater than that of the personal account;
determining the priority of the at least two data transmission requests according to the account category;
updating the priority sequence according to the priorities of the at least two data transmission requests.
4. The method of any of claims 1-3, wherein after placing the threads in the free connection pool into the used connection pool, the method further comprises:
judging whether the sum of the number of the at least one data transmission request and the second number is greater than the maximum thread threshold of the database connection pool;
if not, determining a difference value between the at least one data transmission request and the thread number of the idle connection pool; establishing the difference threads belonging to the idle connection pool; detecting that the establishment of the different threads belonging to the idle connection pool is completed; determining the corresponding relation between the different threads belonging to the idle connection pool and the rest data transmission requests in the at least one data transmission request according to the priority sequence; putting the difference threads belonging to the idle connection pool into the used connection pool;
if yes, M threads belonging to the idle connection pool are established so that the number of the threads of the database connection pool reaches the maximum thread threshold value; detecting that the M threads belonging to the idle connection pool are established; determining the corresponding relation between the M threads belonging to the idle connection pool and the data transmission requests with the priority sequence from the first number of +1 bits to the first number of + M bits in the at least one data transmission request according to the priority sequence; and putting the M threads belonging to the idle connection pool into the used connection pool.
5. The method according to any of claims 1-3, wherein before obtaining the number of currently received at least one data transmission request, the method further comprises:
acquiring current system time;
determining a time period to which the system time belongs;
taking the time period as a query identifier, querying a third preset mapping relation to obtain a minimum thread number corresponding to the time period, wherein the third preset mapping relation comprises a corresponding relation between the time period and the minimum thread number;
establishing the minimum number of threads between the database connection pool and the database.
6. A data transmission device, applied to a bank server, comprising a processing unit and a communication unit, wherein,
the processing unit is used for acquiring the number of at least one data transmission request aiming at a first database received currently; acquiring state information of a database connection pool of the first database through the communication unit, wherein the database connection pool comprises an idle connection pool and a used connection pool, and the state information comprises a first number of threads in the idle connection pool and a second number of threads in the used connection pool; determining whether the number of the at least one data transmission request is greater than the first number; if yes, determining a priority sequence of the at least one data transmission request; screening out data transmission requests with sequence positions located at the first number of bits from the priority sequence, and determining the corresponding relation between the threads in the idle connection pool and the data transmission requests with the first number of bits; and putting the threads in the free connection pool into the used connection pool.
7. A server, comprising a processor, memory, a communication interface, and one or more programs stored in the memory and configured to be executed by the processor, the programs including instructions for performing the steps in the method of any of claims 1-5.
8. A computer-readable storage medium, characterized in that a computer program for electronic data exchange is stored, wherein the computer program causes a computer to perform the method according to any one of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910184071.4A CN110012075B (en) | 2019-03-12 | 2019-03-12 | Data transmission method and related equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910184071.4A CN110012075B (en) | 2019-03-12 | 2019-03-12 | Data transmission method and related equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110012075A CN110012075A (en) | 2019-07-12 |
| CN110012075B true CN110012075B (en) | 2022-02-18 |
Family
ID=67166840
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910184071.4A Active CN110012075B (en) | 2019-03-12 | 2019-03-12 | Data transmission method and related equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110012075B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112448968B (en) * | 2019-08-28 | 2022-08-09 | 华为云计算技术有限公司 | Method for processing network request, related device and storage system |
| US11176155B2 (en) * | 2019-12-13 | 2021-11-16 | Paypal, Inc | Self-adjusting connection pool in a distributed system |
| CN114205372A (en) * | 2021-12-08 | 2022-03-18 | 南方电网深圳数字电网研究院有限公司 | Data storage method and device of Internet of things |
| CN115174611A (en) * | 2022-05-31 | 2022-10-11 | 通号城市轨道交通技术有限公司 | Vehicle-mounted virtualization platform |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102243654A (en) * | 2011-06-16 | 2011-11-16 | 苏州阔地网络科技有限公司 | Method and device for controlling and managing database connections |
| CN102346767A (en) * | 2011-09-19 | 2012-02-08 | 北京金和软件股份有限公司 | Database connection method based on double connection pools |
| CN104063451A (en) * | 2014-06-23 | 2014-09-24 | 北京京东尚科信息技术有限公司 | Database connection management method and system |
| CN105512188A (en) * | 2015-11-25 | 2016-04-20 | 用友网络科技股份有限公司 | Data connection method and data connection system |
| CN106302794A (en) * | 2016-08-31 | 2017-01-04 | 东软集团股份有限公司 | The dynamic setting method of Connecting quantity and device |
| CN108124003A (en) * | 2017-12-11 | 2018-06-05 | 中盈优创资讯科技有限公司 | Network management device connection processing method, apparatus and system |
| CN108846763A (en) * | 2018-06-05 | 2018-11-20 | 中国平安人寿保险股份有限公司 | Core protects request processing method, device, computer equipment and storage medium |
| CN109284311A (en) * | 2018-08-14 | 2019-01-29 | 四川虹美智能科技有限公司 | A kind of method and apparatus obtaining database connection |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10833958B2 (en) * | 2014-09-03 | 2020-11-10 | International Business Machines Corporation | Service level agreement (SLA) cognizent self-managing database connection pools in a multi-tenant environment |
-
2019
- 2019-03-12 CN CN201910184071.4A patent/CN110012075B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102243654A (en) * | 2011-06-16 | 2011-11-16 | 苏州阔地网络科技有限公司 | Method and device for controlling and managing database connections |
| CN102346767A (en) * | 2011-09-19 | 2012-02-08 | 北京金和软件股份有限公司 | Database connection method based on double connection pools |
| CN104063451A (en) * | 2014-06-23 | 2014-09-24 | 北京京东尚科信息技术有限公司 | Database connection management method and system |
| CN105512188A (en) * | 2015-11-25 | 2016-04-20 | 用友网络科技股份有限公司 | Data connection method and data connection system |
| CN106302794A (en) * | 2016-08-31 | 2017-01-04 | 东软集团股份有限公司 | The dynamic setting method of Connecting quantity and device |
| CN108124003A (en) * | 2017-12-11 | 2018-06-05 | 中盈优创资讯科技有限公司 | Network management device connection processing method, apparatus and system |
| CN108846763A (en) * | 2018-06-05 | 2018-11-20 | 中国平安人寿保险股份有限公司 | Core protects request processing method, device, computer equipment and storage medium |
| CN109284311A (en) * | 2018-08-14 | 2019-01-29 | 四川虹美智能科技有限公司 | A kind of method and apparatus obtaining database connection |
Non-Patent Citations (1)
| Title |
|---|
| JSP软件开发中数据库连接池技术的探讨与应用;鲍宏图等;《内蒙古大学学报(自然科学版)》;20070515(第03期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110012075A (en) | 2019-07-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110012075B (en) | Data transmission method and related equipment | |
| CN111404887B (en) | Service processing method and device | |
| CN110413416B (en) | Current limiting method and device for distributed server | |
| WO2016177249A1 (en) | Method and device for processing refund information | |
| CN107871234A (en) | Electric paying method and application server | |
| CN106911780A (en) | Traffic ID generation method, apparatus and system | |
| CN103546388B (en) | A kind of flow control methods and device | |
| CN107871278A (en) | The method and storage medium of server, customer relationship network display | |
| CN111460504B (en) | Service processing method, device, node equipment and storage medium | |
| CN108173698A (en) | Network service management method, apparatus, server and storage medium | |
| CN106851779A (en) | A kind of method and mobile terminal for recognizing access point and focus | |
| CN107517306B (en) | Resource allocation method and related product | |
| CN110458572B (en) | User risk determining method and target risk recognition model establishing method | |
| CN106651368A (en) | Order-scalping-preventing payment mode control method and control system | |
| CN108492109B (en) | Electronic device, dynamic code request processing method and storage medium | |
| CN110543317A (en) | transaction request processing method, device, gateway and storage medium | |
| CN115421922A (en) | Current limiting method, device, equipment, medium and product of distributed system | |
| CN109429190A (en) | Short message classification display method and device | |
| CN107945034A (en) | Financial analysis method, application server and computer-readable recording medium based on microblogging finance and economics event | |
| CN107102799A (en) | A kind of method and its intelligent terminal for adjusting the screen time of going out | |
| CN111443962A (en) | Transaction limiting method and device | |
| CN107124353A (en) | A kind of method of Message Processing, device, computer installation and storage medium | |
| CN107229424A (en) | A kind of distributed memory system method for writing data and distributed memory system | |
| CN110532516A (en) | Account checking method that digital asset transfers, apparatus and system | |
| CN109246686B (en) | Multi-card user address book updating method and device based on cloud technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |