CN117056311A - Method, device, equipment and storage medium for storing business data - Google Patents

Abstract

The disclosure provides a method, a device, equipment and a storage medium for storing business data, which can be applied to the technical field of cloud computing and the technical field of financial science and technology. The method for storing the service data comprises the following steps: determining connection information of a configuration platform according to database configuration parameters in a configuration file, wherein the configuration platform is used for expanding the database capacity through configurable operation; acquiring database information from a configuration platform according to the connection information, wherein the database information characterizes information of a target database obtained after the operation of expanding the database capacity is performed; and storing the business data according to the database information in response to receiving the request for storing the business data.

Description

Method, device, equipment and storage medium for storing business data

Technical Field

The disclosure relates to the technical field of cloud computing and the technical field of financial science and technology, in particular to a method, a device, equipment and a storage medium for storing business data.

Background

With the continuous development of computer technology, the number of users using online services is gradually increasing. Enterprises can provide online services to more users through the capacity-expanding database.

In the related art, when expanding the database of the target service, the configuration file of the target service needs to be modified, and the expanded database or data table information is updated into the configuration file.

In carrying out the above inventive concept, the inventors found that: because the configuration file needs to be modified when the database is expanded, the target application can only acquire and utilize the updated configuration file after restarting, so that the technical problems of complex modification operation, efficiency influence and customer use experience influence exist.

Disclosure of Invention

In view of the above, the present disclosure provides a method, apparatus, device and storage medium for storing service data.

According to a first aspect of the present disclosure, there is provided a method for storing service data, including:

determining connection information of a configuration platform according to database configuration parameters in a configuration file, wherein the configuration platform is used for expanding the database capacity through configurable operation;

acquiring database information from a configuration platform according to the connection information, wherein the database information characterizes information of a target database obtained after the operation of expanding the database capacity is performed; and

in response to receiving a request for storing the business data, the business data is stored according to the database information.

According to an embodiment of the present disclosure, the connection information includes information configuring an internet protocol address and a port of the platform;

according to the connection information, acquiring database information from the configuration platform, including:

generating a request message, wherein the request message comprises business service information related to the configuration file;

sending a request message to a configuration platform through the information of the Internet protocol address and the port; and

database information returned by the configuration platform is received.

According to an embodiment of the present disclosure, after obtaining the database information from the configuration platform according to the connection information, the method further includes:

and replacing the original database information in the local cache by using the database information so as to synchronously update the information of the target database obtained after the operation of expanding the database is performed.

According to an embodiment of the present disclosure, wherein the target database information includes a database capacity;

storing the business data according to the target database information in response to receiving the request for storing the business data, comprising:

determining an actual storage amount of the target database in response to receiving a request for storing the service data; and

in the case where the actual storage amount is smaller than the database capacity, an instruction for storing the business data is sent to the target database so that the target database stores the business data.

According to the embodiment of the disclosure, under the condition that the actual storage amount is equal to the capacity of the database, a configuration request is sent to a configuration platform according to the connection information;

and in response to receiving the updated database information returned by the configuration platform, sending an instruction for storing service data to an updated database characterized by the updated database information according to the newly added database information so as to store the service data in the updated database, wherein the newly added database information corresponds to the configuration request.

According to an embodiment of the present disclosure, further comprising:

determining a database table of service data to be stored; and

and generating an instruction for storing the service data according to the database table to be stored.

According to an embodiment of the present disclosure, determining a database table for service data to be stored includes:

determining a user number corresponding to the service data; and

and carrying out hash modulo operation on the user numbers, and determining a database table of the service data to be stored.

A second aspect of the present disclosure provides a storage device for service data, including:

the determining module is used for determining connection information of the configuration platform according to the database configuration parameters in the configuration file, wherein the configuration platform is used for expanding the database capacity through configurable operation;

The acquisition module is used for acquiring database information from the configuration platform according to the connection information, wherein the database information characterizes the information of the target database obtained after the operation of expanding the database capacity is performed; and

and the storage module is used for responding to the received request for storing the service data and storing the service data according to the database information.

A third aspect of the present disclosure provides an electronic device, comprising:

one or more processors;

storage means for storing one or more programs,

wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method described above.

A fourth aspect of the present disclosure provides a computer-readable storage medium having stored thereon executable instructions that, when executed by a processor, cause the processor to perform the method described above.

A fifth aspect of the present disclosure provides a computer program product comprising a computer program which, when executed by a processor, implements the method described above.

The embodiment of the disclosure starts from a configuration platform, and determines connection information of the configuration platform according to database configuration parameters in a configuration file; according to the connection information, acquiring database information from a configuration platform; in response to receiving a request for storing the service data, storing the service data according to the database information can quickly and accurately store the service data to a determination target database, thereby realizing database capacity expansion and storage of the service data. In the embodiment of the disclosure, the configuration parameters of the database in the configuration file are updated into the information of the configuration platform, and the dynamic configuration is realized through the configuration platform, so that the configuration file does not need to be updated or restarted when the database is expanded through the configuration platform because the address of the configuration platform is not changed, the complexity of the database expansion operation is reduced, the database expansion efficiency is improved, and the user experience is improved.

Drawings

The foregoing and other objects, features and advantages of the disclosure will be more apparent from the following description of embodiments of the disclosure with reference to the accompanying drawings, in which:

FIG. 1 schematically illustrates an application scenario diagram to which the storage method of business data of the present disclosure may be applied;

FIG. 2 schematically illustrates a flow chart of a method of storing business data according to an embodiment of the disclosure;

FIG. 3 schematically illustrates a data interaction diagram for obtaining database information according to an embodiment of the present disclosure;

FIG. 4 schematically illustrates a flow diagram of dynamic database expansion according to an embodiment of the present disclosure;

fig. 5 schematically illustrates a data interaction diagram of a method of storing business data according to an embodiment of the present disclosure;

fig. 6 schematically illustrates a data interaction diagram of a method of storing business data according to another embodiment of the present disclosure;

FIG. 7 schematically illustrates a block diagram of a storage device for business data according to yet another embodiment of the present disclosure;

fig. 8 schematically illustrates a block diagram of a computer system of a method of storing business data according to an embodiment of the disclosure.

Detailed Description

Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is only exemplary and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. In addition, in the following description, descriptions of well-known structures and techniques are omitted so as not to unnecessarily obscure the concepts of the present disclosure.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and/or the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It should be noted that the terms used herein should be construed to have meanings consistent with the context of the present specification and should not be construed in an idealized or overly formal manner.

Where expressions like at least one of "A, B and C, etc. are used, the expressions should generally be interpreted in accordance with the meaning as commonly understood by those skilled in the art (e.g.," a system having at least one of A, B and C "shall include, but not be limited to, a system having a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).

In the technical scheme of the disclosure, the related data (such as including but not limited to personal information of a user) are collected, stored, used, processed, transmitted, provided, disclosed, applied and the like, all conform to the regulations of related laws and regulations, necessary security measures are adopted, and the public welcome is not violated.

In the practical application process, because the capacity limitation of the hardware equipment of the database generally realizes capacity expansion by dividing the database into different types, so as to reduce the storage pressure of the database and store the newly added user or the newly added business information in the database in time.

However, whether the database is newly added or modified, it is necessary to modify the database parameters in the target application and restart the target application after modification. Because the modification of the parameters of the database needs to be manually participated and the restarting of the application needs to consume a great deal of time, the related technology has the technical problems of complex modification operation, low database capacity expansion efficiency and poor customer use experience.

In view of this, an embodiment of the present disclosure provides a method for storing service data, including: determining connection information of a configuration platform according to database configuration parameters in a configuration file, wherein the configuration platform is used for expanding the database capacity through configurable operation; acquiring database information from a configuration platform according to the connection information, wherein the database information characterizes information of a target database obtained after the operation of expanding the database capacity is performed; and storing the business data according to the database information in response to receiving the request for storing the business data.

Fig. 1 schematically illustrates an application scenario diagram of a method for storing service data according to an embodiment of the present disclosure.

As shown in fig. 1, an application scenario 100 according to this embodiment may include a first terminal device 101, a second terminal device 102, a third terminal device 103, a network 104, and a server 105. The network 104 is a medium used to provide a communication link between the first terminal device 101, the second terminal device 102, the third terminal device 103, and the server 105. The network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.

The user may interact with the server 105 through the network 104 using at least one of the first terminal device 101, the second terminal device 102, the third terminal device 103, to receive or send messages, etc. Various communication client applications, such as a shopping class application, a web browser application, a search class application, an instant messaging tool, a mailbox client, social platform software, etc. (by way of example only) may be installed on the first terminal device 101, the second terminal device 102, and the third terminal device 103.

For example, the user may send a service request to the server 105 equipped with the service system using a bank client installed in the first terminal device 101, the second terminal device 102, the third terminal device 103.

The first terminal device 101, the second terminal device 102, the third terminal device 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (by way of example only) providing support for websites browsed by the user using the first terminal device 101, the second terminal device 102, and the third terminal device 103. The background management server may analyze and process the received data such as the user request, and feed back the processing result (e.g., the web page, information, or data obtained or generated according to the user request) to the terminal device.

For example, server 105 may be a distributed server, a cloud server, and a centralized server. The server 105 may be installed with both the old version service system and the new version service server and test the storage method of the service data.

It should be noted that, the method for storing service data provided by the embodiments of the present disclosure may be generally performed by the server 105. Accordingly, the storage device of the service data provided by the embodiments of the present disclosure may be generally disposed in the server 105. The storage method of service data provided by the embodiments of the present disclosure may also be performed by a server or a server cluster that is different from the server 105 and is capable of communicating with the first terminal device 101, the second terminal device 102, the third terminal device 103, and/or the server 105. Accordingly, the storage means of the service data provided by the embodiments of the present disclosure may also be provided in a server or a server cluster, which is different from the server 105 and is capable of communicating with the first terminal device 101, the second terminal device 102, the third terminal device 103 and/or the server 105.

For example, the server 105 obtains a storage request of service data from any one of the first terminal device 101, the second terminal device 102, and the third terminal device 103, and determines connection information of a configuration platform according to a database configuration parameter in a configuration file, where the configuration platform is used to expand a database capacity through a configurable operation; acquiring database information from a configuration platform according to the connection information, wherein the database information characterizes information of a target database obtained after the operation of expanding the database capacity is performed; and storing the business data according to the database information in response to receiving the request for storing the business data.

It should be understood that the number of terminal devices, networks and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

The method of storing service data of the disclosed embodiment will be described in detail with reference to fig. 2 to 6 based on the scenario described in fig. 1.

Fig. 2 schematically illustrates a flowchart of a method of storing business data according to an embodiment of the present disclosure.

As shown in fig. 2, the method 200 includes operations S210 to S230.

In operation S210, connection information of the configuration platform is determined according to the database configuration parameters in the configuration file.

According to embodiments of the present disclosure, a configuration platform is a platform that receives messages, sends messages, and dynamically configures information. The configuration platform is used for carrying out dynamic configuration through interactive operation to realize database capacity expansion. Such as a newly added database, a newly added database table, etc. Wherein dynamic configuration is the modification of the application information being used without restarting the configuration operation of the application.

For example, the configuration platform may be a server that receives a request message sent by a service system for storing service data; and sending the obtained service feedback information to a service system.

According to an embodiment of the present disclosure, the configuration file includes code writing rules for describing application software, field information, information of other terminal devices or network connections. The database configuration parameters in the configuration file are used for representing information of a database connected with the target application, and the database is used for storing service data generated by the target application.

In the embodiment of the disclosure, the configuration platform is used as a database, and the configuration parameters of the database can characterize the connection information of the configuration platform.

According to an embodiment of the present disclosure, the connection information includes information of a port, an ip address, a location, etc. of the configuration platform. For example, the server of the service system determines, according to the database configuration parameters in the configuration file, that the location of the configuration platform for transmitting the information is a, the port B, and the password is C.

According to an embodiment of the present disclosure, a configuration platform is used to expand database capacity through configurable operations.

According to an embodiment of the present disclosure, the configuring operation may be an operation of reconfiguring or modifying information such as a database ip, a port, a user library, an order library, a payment library, a user name, a password, a maximum number of rentals, and the like. For example, the configuration platform may modify database port a to database port B through a configuration operation. The configuration platform can also realize the address transfer of the database of the service data by modifying the database ip.

In operation S220, database information is acquired from the configuration platform according to the connection information.

According to an embodiment of the present disclosure, database information characterizes information of a target database obtained after performing an operation of expanding a database capacity. The database information may include information of a target database name, number, ip, port, etc.

For example, a server of the service system is connected to the configuration platform according to the port a and the ip address of the configuration platform, and obtains the ip address a and the number 01 of the target database of the service data to be stored from the configuration platform.

In response to receiving the request for storing the service data, the service data is stored according to the database information in operation S230.

For example, the user generates service data a after the terminal device performs an operation such as a transaction, and then the terminal device transmits the service data a to the service system so as to store the service data a. After receiving a request for storing service data A, a server of the service system stores the service data A to be stored into a target database with the ip address A and the number 01 according to the obtained target database ip address A and the target database number 01, and completes the storage of the service data A.

In the embodiment of the disclosure, starting from the configuration platform, connection information of the configuration platform is determined according to the database configuration parameters in the configuration file; according to the connection information, acquiring database information from a configuration platform; and in response to receiving the request for storing the service data, storing the service data according to the database information, and rapidly and accurately storing the service data to a target database to realize database capacity expansion and service data storage. In the embodiment of the disclosure, the configuration parameters of the database in the configuration file are updated into the information of the configuration platform, and the dynamic configuration is realized through the configuration platform, so that the configuration file does not need to be updated or restarted when the database is expanded through the configuration platform because the address of the configuration platform is not changed, the complexity of the database expansion operation is reduced, the database expansion efficiency is improved, and the user experience is improved.

According to an embodiment of the present disclosure, the connection information includes information configuring an internet protocol address and a port of the platform. According to the connection information, acquiring database information from the configuration platform, including: generating a request message, wherein the request message comprises business service information related to the configuration file; sending a request message to a configuration platform through the information of the Internet protocol address and the port; and receiving database information returned by the configuration platform.

According to the embodiment of the disclosure, in response to an operation performed by a user at a target application, a server of a service system generates a request message according to the operation of the user. .

According to the embodiment of the disclosure, the request message includes various information such as user information, operation information executed by the user, message generation information, message type and the like.

For example, a new user transacts a new banking business at a mobile banking web page end, the mobile banking web page end sends an instruction for requesting to store the business data to a server of a business system through a terminal device according to the business data, and after receiving the request instruction, the server of the business system generates a request message for storing the business data so as to send the request message to a configuration platform.

According to an embodiment of the present disclosure, the connection information includes information of an internet protocol address and a port. After determining the connection information of the configuration platform according to the database configuration parameters, a variety of information may be transmitted to the configuration file based on the connection information.

According to an embodiment of the present disclosure, database information is characterized as information of a target database obtained after a configuration platform performs an operation of expanding database capacity.

For example, the configuration platform may pre-configure the expanded target database for the target application software or target business system. The configuration platform receives the request message sent by the server of the service system, and returns the database information representing the expanded target database to the service system so that the server of the service system stores the service data in the expanded target database.

According to an embodiment of the present disclosure, after acquiring database information from the configuration platform according to the connection information, further includes: and replacing the original database information in the local cache by using the database information so as to synchronously update the information of the target database obtained after the operation of expanding the database is performed.

According to embodiments of the present disclosure, the original database information may be characterized as information of the database prior to the update. For example, the original database information may be the database information that the configuration platform returned to the business system for the first time, and the original database information may also be characterized as the database information that the configuration platform returned to the business system last time.

For example, the business system may periodically obtain database information from the configuration platform based on the connection information of the configuration platform and update the database information in the local cache.

Or when the capacity expansion operation is needed, replacing the original database information in the local cache by using the expanded database information.

According to embodiments of the present disclosure, local cache refers to an area or address used to temporarily save information in the local area of a server of a business system.

For example, the server stores the database information returned by the configuration platform into a local server, so that the database information can be timely referred to, called, and the like in the server.

For example, the original database information in the server of the service system is "the storage amount of the target database a is 699 and can be stored", and the service system replaces "the storage amount of the target database a is 699 and can be stored" with "the storage amount of the target database a is 698 and can be stored" according to the database information sent by the configuration platform, such as "the storage amount of the target database a is 698 and can be stored".

According to an embodiment of the present disclosure, original database information in a local cache is replaced with database information so as to synchronously update information of a target database obtained after performing an enlarged database operation.

According to the embodiment of the disclosure, the synchronous update can be characterized as that the server of the service system synchronizes the capacity of the target database of the service to be stored in real time according to the database information sent by the configuration platform, and stores the capacity to the local server, so that the server of the service system can inquire autonomously, and the working efficiency is improved.

In the embodiment of the disclosure, the configuration platform returns the database information to the local cache of the server of the service system, so that the information of the target database obtained after the database expansion operation is synchronously updated, the storage capacity of the target database can be observed in the server of the service system, the storage efficiency is improved, and preparation such as capacity expansion of the target database is performed in advance.

Fig. 3 schematically illustrates a data interaction diagram for obtaining database information according to an embodiment of the present disclosure.

As shown in fig. 3, the server may be a server of a business system for providing a variety of business services to users.

As shown in fig. 3, the database information acquisition method 300 of this embodiment includes operations S301 to S304.

In operation S301, a request message is generated.

In operation S302, a request message is sent to the configuration platform through information of an internet protocol address and a port.

In operation S303, database information returned by the configuration platform is received.

In operation S304, the original database information in the local cache is replaced with the database information.

In operation S304, the original database information in the local cache is replaced with the database information.

According to an embodiment of the present disclosure, the target database information includes database capacity. The database capacity is used to characterize the amount of data that a target database can accommodate.

According to an embodiment of the present disclosure, in response to receiving a request for storing service data, storing the service data according to target database information, includes: determining an actual storage amount of the target database in response to receiving a request for storing the service data; and sending an instruction for storing the business data to the target database in the case that the actual storage amount is smaller than the database capacity, so that the target database stores the business data.

According to embodiments of the present disclosure, the actual storage of the target database may be characterized by a specific number value that the target database has now stored.

For example, the actual storage amount of the target database is 999, or the actual storage amount of the target database is 138, or the actual storage amount of the target database is 0.

According to the embodiment of the disclosure, since the database information acquired from the configuration platform according to the connection information characterizes the information of the target database obtained after the operation of expanding the database capacity is performed, the actual storage amount of the target database can be stored in the local cache in the service system service in advance. Under the condition that the actual storage amount needs to be acquired, the actual storage amount is directly acquired from the local cache.

For example, after determining the connection information of the configuration platform according to the configuration file of the service system, the "target database a is stored 682, the remaining storage capacity of the target database a is 218" may be acquired from the configuration platform according to the connection information, and the information may be stored in the local cache of the service system server.

According to the embodiment of the present disclosure, before performing the operation of storing the service data, the configuration platform has returned the target database information, and in the operation of performing the storage of the service data, it may be determined in the server of the service system whether the actual storage amount is smaller than the database capacity.

For example, the configuration platform sends the target database stored 699 with a database capacity of 999 to the server, which determines that the target database stored 699 with a database capacity of 999 determines that the target database stored 699 is less than the database capacity of 999.

According to an embodiment of the present disclosure, in the case where the actual storage amount is smaller than the database capacity, an instruction for storing the business data is transmitted to the target database.

For example, the actual storage amount is 623 and the database capacity is 999, and at this time, it is determined that the actual storage amount is smaller than the database capacity, and the server transmits an instruction for storing the service data to the target database a according to the ip address and port of the target database a obtained from the configuration platform, and stores the service data. According to an embodiment of the present disclosure, an instruction for storing business data is sent to a target database so that the target database stores the business data.

According to the embodiment of the disclosure, under the condition that the actual storage amount is equal to the capacity of the database, a configuration request is sent to a configuration platform according to the connection information; and in response to receiving the updated database information returned by the configuration platform, sending an instruction for storing service data to an updated database characterized by the updated database information according to the newly added database information so as to store the service data in the updated database, wherein the newly added database information corresponds to the configuration request.

According to the embodiment of the disclosure, in the case that the actual storage amount is equal to the capacity of the database, the target database is indicated to be full, and the service data cannot be stored continuously, and a new database needs to be added or the target database needs to be updated to be a larger database so as to accommodate the service data to be stored. Thus, a configuration request may be sent to the configuration platform to obtain newly added or updated database information.

According to embodiments of the present disclosure, a configuration request may be characterized as information requesting an expansion of the database capacity.

According to an embodiment of the present disclosure, in the case where it is determined that the actual storage amount is equal to the database capacity, the server of the service system transmits information requesting to expand the database capacity to the configuration platform.

For example, the actual storage amount is 999, the database capacity is 999, the server of the service system confirms that the actual storage amount is equal to the database capacity, new service data cannot be stored in the existing target database, and the server of the service system sends information requesting to expand the database capacity to the configuration platform.

According to the embodiment of the disclosure, after receiving a configuration request sent by a service of a service system, the configuration platform determines a new database through a pre-configured database corresponding table or through interactive operation, and sends updated database information to a server of the service system.

According to an embodiment of the present disclosure, the update database information may include information of an actual storage amount of the update database, a database capacity of the update database, a remaining storage capacity of the update database, an ip address of the update database, a port of the update database, and the like. The update database information corresponds to the configuration request.

According to embodiments of the present disclosure, the update database may be a newly added database, a replaced other database; the update database may also be a database after the data table operation is extended to the target database.

According to embodiments of the present disclosure, the update database may be characterized as a target database after expanding the database capacity. After the update database information is obtained, the server of the service system may send an instruction for storing service data to the update database represented by the update database information according to the update database information, so as to store the service data to be stored in the update database, thereby implementing a storage operation.

For example, in the case where the actual storage amount is 999 and the database capacity is 999, the server of the service system determines that the actual storage amount is equal to the database capacity, and newly added service data cannot be stored in the existing target database, the server of the service system transmits information requesting for expanding the database capacity to the configuration platform, and the configuration platform configures updated database information and transmits the updated database information to the server according to the information requesting for expanding the database capacity. The updated database information includes 999 actual storage, 9999 database capacity, and 9000 remaining storage capacity. And sending the command to the server, and sending the command for storing the service data to the update database by the server of the service system according to the ip address and the port of the update database to store the service data.

According to an embodiment of the present disclosure, a database table of business data to be stored is determined; and generating an instruction for storing the service data according to the database table to be stored.

According to embodiments of the present disclosure, a database table may be used to store one or more business data.

According to embodiments of the present disclosure, different business data may be stored in the same data table in the same database. Different service data may also be stored in different data tables of the same database. Different service data may also be stored in different data tables of different databases.

For example, the service data a may be stored in the database table a of the database a, the service data B may be also stored in the database table B of the database a, and the service data B may be also stored in the database table C of the database B.

According to the embodiment of the disclosure, the service data may be randomly distributed in a certain database table, or the service data may be distributed in a certain database table one by one according to the receiving order.

According to the embodiment of the disclosure, after the data table for storing the service data is determined, the database table to be stored can be directly written into the storage instruction to obtain the instruction for storing the service data.

For example, the server of the business system writes the table name of the database table a of the banking counter business data to be stored in the instruction, and generates an instruction for storing the banking counter business data.

According to the embodiments of the present disclosure, there are two ways to implement the library and table splitting: vertical segmentation and horizontal segmentation. The vertical segmentation is to split according to service and function dimensions, and store service data into different databases respectively; horizontal splitting is to store the same table structure in different databases and different data tables in a decentralized manner.

In the embodiment of the disclosure, the service data may be stored in other database tables of the current target database through horizontal splitting, where the updated database is still the target database, but the updated database information includes the newly added database table. The service data may also be stored in a new database table in the new database by vertical splitting, where the database is updated to be the newly added database.

In the embodiment of the disclosure, since the service data can be stored in the database table, according to the capacity of the database table as a standard of horizontal capacity expansion, the database table to be stored does not need to be fixed on the configuration platform, but is flexibly determined by the server, so that the flexibility of capacity expansion is further improved.

According to an embodiment of the present disclosure, determining a database table for traffic data to be stored includes: determining a user number corresponding to the service data; and carrying out hash modulo operation on the user number to determine a database table of the service data to be stored.

According to the embodiment of the disclosure, since the service data is initiated by the user, the user identification can uniquely determine the user, and therefore, the user identification can be directly obtained according to the acquired service data; and then determining the user number according to the user identification. As a specific embodiment, the user identifier and the user number may be used as two fields of the same data table, and the corresponding user number may be determined from the data table according to the user identifier.

According to an embodiment of the present disclosure, the user identification is present in a request instruction sent by the terminal device of the user to the server.

According to embodiments of the present disclosure, the user number is unique.

For example, the user number of the a user is 01 and the user number of the b user is 02.

According to an embodiment of the present disclosure, the hash modulo operation on the user number may be: and according to the user numbers, performing modular operation on the user numbers by utilizing a hash algorithm, and dispersing the business data corresponding to different user numbers into different database tables.

For example, it is determined that the user number of the service data a to be stored is 01, the user number of the service data B to be stored is 02, and the user number of the service data C to be stored is 03. The hash module operation is carried out on each user number by utilizing a hash algorithm, the service data A to be stored is stored in the database table 10, the service data B to be stored is stored in the database table 20, the service data C to be stored is stored in the database table 30, and service data storage instructions are respectively generated according to three different database tables.

In the embodiment of the disclosure, the stored database table is determined by utilizing hash modulus to the service data to be stored in the server of the service system, so that the risk of frequent access is further reduced, the inquiry congestion is avoided, and the storage efficiency and the flexibility of capacity expansion are improved.

Fig. 4 schematically illustrates a flow diagram of dynamic capacity expansion of a database according to an embodiment of the disclosure.

As shown in fig. 4, the dynamic capacity expansion 400 of this embodiment includes operations S401 to S406.

In operation S401, an actual storage amount of a target database is determined in response to receiving a request for storing service data.

In operation S402, whether the actual storage amount is smaller than the database capacity. In the case where it is determined that the actual storage amount is smaller than the database capacity, the operation proceeds to operation S403; in the case where it is determined that the actual storage amount is not less than the database capacity, operation S404 is entered.

In operation S403, an instruction for storing service data is transmitted to the target database.

In operation S404, a configuration request is sent to the configuration platform according to the connection information.

In operation S405, update database information is returned.

In operation S406, an instruction for storing the service data is transmitted to the update database characterized by the update database information.

Fig. 5 schematically illustrates a data interaction diagram of a method of storing business data according to an embodiment of the present disclosure.

As shown in fig. 5, the method 500 for storing service data of this embodiment includes operations S501 to S510.

In operation S501, a request message is generated at a timing. Specifically, the local cache can be updated in real time by periodically generating a request message and acquiring update database information from the configuration platform.

In operation S502, a request message is sent to the configuration platform.

In operation S503, database information is returned. Specifically, after receiving the request message, the configuration platform obtains and returns database information to the server by processing the request message.

In operation S504, the original database information in the local cache is updated. Specifically, operations S501 to S504 may be performed in a timed loop, with the local cache updated.

In operation S505, in response to receiving a request for storing service data.

In operation S506, a relationship between the actual storage amount and the database capacity is determined.

In operation S507, in the case where the actual storage amount is smaller than the database capacity, the user number is determined.

In operation S508, a hash modulo operation is performed on the user number to determine a database table in which service data is to be stored.

In operation S509, an instruction for storing service data is generated according to the database table to be stored.

In operation S510, a store instruction is transmitted to a target database.

For example, the server may determine the internet protocol address a and the port B of the configuration platform according to the connection information of the configuration platform at regular time, and send a request message to the configuration platform through the internet protocol address a and the port B of the configuration platform, so as to obtain database information for storing service data generated by the mobile banking client. The database information comprises a database name C, an actual storage capacity 784, a database capacity 999, a database ip address D and a database port E, and the configuration platform sends the database name C, the actual storage capacity 784, the database capacity 999, the database ip address D and the database port E to the server. The service may then cache the database name C, the actual storage 784, the database capacity 999, the database ip address D, and the database port E locally.

When the user F transacts deposit business in the mobile phone bank, the mobile phone bank client sends a request for storing deposit business data to the server. After the server receives the request to store deposit business data, it determines that the actual storage amount 784 is smaller than the database capacity 999, and thus the server can perform a storage operation.

Specifically, according to the user identification of the client F handling the deposit service, the user number 01 is determined, the hash modulo operation is performed on the user number 01, and the database storing the deposit service data is determined as G and the database table as 01. Then, an instruction to store deposit service data is generated from the database table 01 of the database table G and transmitted to the database G.

Fig. 6 schematically illustrates a signaling diagram of a method of storing traffic data according to another embodiment of the present disclosure.

As shown in fig. 6, the storing method 600 of service data of this embodiment includes operations S601 to S609.

In operation S601, in response to receiving a request for storing service data.

In operation S602, a relationship between the actual storage amount and the database capacity is determined.

In operation S603, in the case where the actual storage amount is equal to the database capacity, a configuration request is sent to the configuration platform.

In operation S604, updated database information is received.

In operation S605, the original database information in the local cache is replaced with the updated database information.

In operation S606, a user number corresponding to the service data is determined.

In operation S607, a hash modulo operation is performed on the user number to determine a database table in which service data is to be stored.

In operation S608, an instruction for storing service data is generated according to the database table to be stored.

In operation S609, a store instruction is transmitted to the update database.

Taking the example that the client F handles the deposit business in the mobile banking, when the actual storage amount of the target database is 999, the server judges that the actual storage amount 999 is equal to the database capacity 999, and the existing database C cannot store deposit business data, so that the server sends a configuration request to the configuration platform to request to expand the volume of the database C or newly add the database H to store deposit business data. The configuration platform sends the database information of the newly added database H to the server, and the server replaces the original database information in the local cache by the database information of the newly added database H. Then, the server transmits an instruction to store deposit service data to the newly added database H to perform a data storage operation.

Fig. 7 schematically illustrates a block diagram of a storage device for traffic data according to still another embodiment of the present disclosure.

As shown in fig. 7, the storage device 700 of service data in this embodiment includes a determining module 710, an acquiring module 720, and a storing module 730.

And the determining module 710 is configured to determine connection information of a configuration platform according to the database configuration parameters in the configuration file, where the configuration platform is configured to expand the database capacity through a configurable operation.

And an obtaining module 720, configured to obtain database information from the configuration platform according to the connection information, where the database information characterizes information of the target database obtained after the operation of expanding the database capacity is performed.

And a storage module 730 for storing the service data according to the database information in response to receiving the request for storing the service data.

According to an embodiment of the present disclosure, the connection information includes information configuring an internet protocol address and a port of the platform.

According to an embodiment of the present disclosure, the obtaining module 720 includes: generating unit, transmitting unit, receiving unit.

And the generating unit is used for generating a request message, wherein the request message comprises business service information related to the configuration file.

And the sending unit is used for sending the request message to the configuration platform through the information of the Internet protocol address and the port.

And the receiving unit is used for receiving the database information returned by the configuration platform.

According to an embodiment of the present disclosure, after the obtaining module 720, a synchronization unit is further included.

And the synchronization unit is used for replacing the original database information in the local cache by utilizing the database information so as to synchronously update the information of the target database obtained after the database expansion operation is performed.

According to an embodiment of the present disclosure, the target database information includes database capacity.

According to an embodiment of the present disclosure, the storage module 730 includes: the first determining unit and the first sending instruction unit.

And the first determining unit is used for determining the actual storage amount of the target database in response to receiving the request for storing the service data.

And the first sending instruction unit is used for sending an instruction for storing the service data to the target database so that the target database stores the service data under the condition that the actual storage amount is smaller than the capacity of the database.

According to an embodiment of the present disclosure, the storage module 730 further includes: the second determining unit and the second sending instruction unit.

And the second determining unit is used for sending a configuration request to the configuration platform according to the connection information under the condition that the actual storage amount is equal to the database capacity.

And the second sending instruction unit is used for responding to the received updated database information returned by the configuration platform, and sending an instruction for storing service data to an updated database represented by the updated database information according to the newly added database information so as to store the service data in the updated database, wherein the newly added database information corresponds to the configuration request.

According to an embodiment of the present disclosure, the storage module 730 further includes: determining a database table unit and generating an instruction unit.

And the database table determining unit is used for determining a database table of the service data to be stored.

And the generation instruction unit is used for generating an instruction for storing the service data according to the database table to be stored.

According to an embodiment of the present disclosure, the first determination database table unit includes: determining a user coding subunit and determining a database table subunit.

And the user number determining subunit is used for determining the user number corresponding to the service data.

And the database table determining subunit is used for performing hash modulo operation on the user numbers and determining a database table of the service data to be stored.

Any number of modules, sub-modules, units, sub-units, or at least some of the functionality of any number of the sub-units according to embodiments of the present disclosure may be implemented in one module. Any one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be implemented as split into multiple modules. Any one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be implemented at least in part as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system-on-chip, a system-on-substrate, a system-on-package, an Application Specific Integrated Circuit (ASIC), or in any other reasonable manner of hardware or firmware that integrates or encapsulates the circuit, or in any one of or a suitable combination of three of software, hardware, and firmware. Alternatively, one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be at least partially implemented as computer program modules, which when executed, may perform the corresponding functions.

Any of the determining module 710, the acquiring module 720, and the storing module 730 may be combined in one module to be implemented, or any of the modules may be split into a plurality of modules according to an embodiment of the present disclosure. Alternatively, at least some of the functionality of one or more of the modules may be combined with at least some of the functionality of other modules and implemented in one module.

According to embodiments of the present disclosure, at least one of the determination module 710, the acquisition module 720, and the storage module 730 may be implemented at least in part as hardware circuitry, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system-on-chip, a system-on-substrate, a system-on-package, an Application Specific Integrated Circuit (ASIC), or in hardware or firmware, such as any other reasonable manner of integrating or packaging the circuitry, or in any one of or a suitable combination of any of three implementations of software, hardware, and firmware. Alternatively, at least one of the determination module 710, the acquisition module 720 and the storage module 730 may be at least partially implemented as a computer program module, which when executed may perform the corresponding functions.

It should be noted that, in the embodiment of the present disclosure, the portion of the storage device for service data corresponds to the portion of the storage method for service data in the embodiment of the present disclosure, and the description of the portion of the storage device for service data specifically refers to the portion of the storage method for service data, which is not described herein again.

Fig. 8 schematically illustrates a block diagram of a computer system of a method of storing business data according to an embodiment of the disclosure. The computer system illustrated in fig. 8 is merely an example, and should not be construed as limiting the functionality and scope of use of the embodiments of the present disclosure.

As shown in fig. 8, an electronic device 800 according to an embodiment of the present disclosure includes a processor 801 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 802 or a program loaded from a storage section 808 into a Random Access Memory (RAM) 803. The processor 801 may include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or an associated chipset and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), or the like. The processor 801 may also include on-board memory for caching purposes. The processor 801 may include a single processing unit or multiple processing units for performing the different actions of the method flows according to embodiments of the disclosure.

In the RAM 803, various programs and data required for the operation of the electronic device 800 are stored. The processor 801, the ROM 802, and the RAM 803 are connected to each other by a bus 804. The processor 801 performs various operations of the method flow according to the embodiments of the present disclosure by executing programs in the ROM 802 and/or the RAM 803. Note that the program may be stored in one or more memories other than the ROM 802 and the RAM 803. The processor 801 may also perform various operations of the method flows according to embodiments of the present disclosure by executing programs stored in the one or more memories.

According to an embodiment of the present disclosure, the electronic device 800 may also include an input/output (I/O) interface 805, the input/output (I/O) interface 805 also being connected to the bus 804. The electronic device 800 may also include one or more of the following components connected to the input/output I/O interface 805: an input portion 806 including a keyboard, mouse, etc.; an output portion 807 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and a speaker; a storage section 808 including a hard disk or the like; and a communication section 809 including a network interface card such as a LAN card, a modem, or the like. The communication section 809 performs communication processing via a network such as the internet. The drive 810 is also connected to the I/O interface 805 as needed. A removable medium 811 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 810 as needed so that a computer program read out therefrom is mounted into the storage section 808 as needed.

The present disclosure also provides a computer-readable storage medium that may be embodied in the apparatus/device/system described in the above embodiments; or may exist alone without being assembled into the apparatus/device/system. The computer-readable storage medium carries one or more programs which, when executed, implement methods in accordance with embodiments of the present disclosure.

According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example, but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to embodiments of the present disclosure, the computer-readable storage medium may include ROM 802 and/or RAM 803 and/or one or more memories other than ROM 802 and RAM 803 described above.

Embodiments of the present disclosure also include a computer program product comprising a computer program containing program code for performing the methods shown in the flowcharts. The program code, when executed in a computer system, causes the computer system to perform the methods provided by embodiments of the present disclosure.

The above-described functions defined in the system/apparatus of the embodiments of the present disclosure are performed when the computer program is executed by the processor 801. The systems, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.

In one embodiment, the computer program may be based on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted, distributed, and downloaded and installed in the form of a signal on a network medium, and/or from a removable medium 811 via a communication portion 809. The computer program may include program code that may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.

In such an embodiment, the computer program may be downloaded and installed from a network via the communication section 809, and/or installed from the removable media 811. The above-described functions defined in the system of the embodiments of the present disclosure are performed when the computer program is executed by the processor 801. The systems, devices, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.

According to embodiments of the present disclosure, program code for performing computer programs provided by embodiments of the present disclosure may be written in any combination of one or more programming languages, and in particular, such computer programs may be implemented in high-level procedural and/or object-oriented programming languages, and/or assembly/machine languages. Programming languages include, but are not limited to, such as Java, c++, python, "C" or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).

The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

Those skilled in the art will appreciate that the features recited in the various embodiments of the disclosure and/or in the claims may be provided in a variety of combinations and/or combinations, even if such combinations or combinations are not explicitly recited in the disclosure. In particular, the features recited in the various embodiments of the present disclosure and/or the claims may be variously combined and/or combined without departing from the spirit and teachings of the present disclosure. All such combinations and/or combinations fall within the scope of the present disclosure.

While the foregoing is directed to embodiments of the present disclosure, other and further details of the invention may be had by the present application, it is to be understood that the foregoing description is merely exemplary of the present disclosure and that no limitations are intended to the scope of the disclosure, except insofar as modifications, equivalents, improvements or modifications may be made without departing from the spirit and principles of the present disclosure.

Claims (11)

1. A method of storing business data, comprising:

determining connection information of a configuration platform according to database configuration parameters in a configuration file, wherein the configuration platform is used for expanding the database capacity through configurable operation;

acquiring database information from the configuration platform according to the connection information, wherein the database information characterizes information of a target database obtained after the operation of expanding the database capacity is performed; and

and in response to receiving a request for storing service data, storing the service data according to the database information.

2. The method of claim 1, wherein the connection information includes information of an internet protocol address and a port of the configuration platform;

the step of obtaining database information from the configuration platform according to the connection information comprises the following steps:

Generating a request message, wherein the request message comprises business service information related to the configuration file;

sending the request message to the configuration platform through the Internet protocol address and the information of the port; and

and receiving the database information returned by the configuration platform.

3. The method according to claim 1 or 2, wherein after said obtaining database information from said configuration platform according to said connection information, further comprising:

and replacing the original database information in the local cache by using the database information so as to synchronously update the information of the target database obtained after the operation of expanding the database is performed.

4. The method of claim 1, wherein the target database information comprises database capacity;

the responding to the receiving of the request for storing the service data, storing the service data according to the target database information, and comprises the following steps:

determining an actual storage amount of the target database in response to receiving a request for storing business data; and

and sending an instruction for storing the service data to the target database under the condition that the actual storage amount is smaller than the database capacity so that the target database stores the service data.

5. The method of claim 4, further comprising:

sending a configuration request to the configuration platform according to the connection information under the condition that the actual storage capacity is equal to the database capacity;

and in response to receiving updated database information returned by the configuration platform, sending an instruction for storing the service data to an updated database characterized by the updated database information according to the newly added database information so that the updated database stores the service data, wherein the newly added database information corresponds to the configuration request.

6. The method of claim 4 or 5, further comprising:

determining a database table in which the service data is to be stored; and

and generating the instruction for storing the service data according to the database table to be stored.

7. The method of claim 6, wherein the determining a database table in which the business data is to be stored comprises:

determining a user number corresponding to the service data; and

and carrying out hash modulo operation on the user number, and determining a database table for storing the service data.

8. A storage device for service data, comprising:

The determining module is used for determining connection information of the configuration platform according to database configuration parameters in the configuration file, wherein the configuration platform is used for expanding the database capacity through configurable operation;

the acquisition module is used for acquiring database information from the configuration platform according to the connection information, wherein the database information characterizes information of a target database obtained after the operation of expanding the database capacity is performed; and

and the storage module is used for responding to the received request for storing the service data and storing the service data according to the database information.

9. An electronic device, comprising:

one or more processors;

storage means for storing one or more programs,

wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method of any of claims 1-7.

10. A computer readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to perform the method according to any of claims 1-7.

11. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 7.