CN110019148B - Database capacity management method and device, storage medium and computer equipment - Google Patents
Database capacity management method and device, storage medium and computer equipment Download PDFInfo
- Publication number
- CN110019148B CN110019148B CN201811044560.1A CN201811044560A CN110019148B CN 110019148 B CN110019148 B CN 110019148B CN 201811044560 A CN201811044560 A CN 201811044560A CN 110019148 B CN110019148 B CN 110019148B
- Authority
- CN
- China
- Prior art keywords
- database
- management
- capacity
- data
- processing center
- 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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a database capacity management method, a device, a storage medium and computer equipment, which are applied to online management of database capacity; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; and pushing the data after capacity management to a target database indicated by the management configuration information so as to perform online management on the capacity of the target database. By the invention, online lossless management can be realized in the process of managing the background database of the liquidation platform, foreground service access is not influenced, and the management effect of the database is improved.
Description
Technical Field
The present invention relates to the field of clearing technology, and in particular, to a database capacity management method, apparatus, storage medium, and computer device.
Background
In the related art, when a background database of a clearing platform is managed (for example, capacity expansion or capacity reduction of the database or fault detection), historical service data needs to be migrated, an online service needs to be suspended, and online management is not supported.
Disclosure of Invention
The present invention is directed to solving, at least to some extent, one of the technical problems in the related art.
Therefore, an object of the present invention is to provide a database capacity management method, which can implement online lossless management in the process of managing a background database of a clearing platform, does not affect foreground service access, and improves the management effect of the database.
Another object of the present invention is to provide a database capacity management apparatus.
It is another object of the invention to propose a non-transitory computer-readable storage medium.
It is a further object of the invention to propose a computer program product.
Another object of the invention is to propose a computer device.
To achieve the above object, a database capacity management method provided in an embodiment of a first aspect of the present invention is applied to perform online management on database capacity, and includes: receiving a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; and pushing the data after capacity management to a target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
In the method for managing the capacity of the database provided by the embodiment of the first aspect of the invention, a database management request is received; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
In order to achieve the above object, a database capacity management apparatus according to an embodiment of a second aspect of the present invention is applied to online management of database capacity, and includes: the first receiving module is used for receiving a database management request; the analysis module is used for analyzing the database management request to obtain management configuration information; the capacity management module is used for carrying out capacity management on the data of the database processing center according to the management configuration information; and the pushing module is used for pushing the data after capacity management to a target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
The database capacity management device provided by the embodiment of the second aspect of the invention receives the database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
To achieve the above object, a non-transitory computer-readable storage medium according to a third embodiment of the present invention is a non-transitory computer-readable storage medium, when instructions in the storage medium are executed by a processor of a mobile terminal, the instructions enabling the mobile terminal to perform a database capacity management method, the method including: the embodiment of the first aspect of the invention provides a database capacity management method.
A non-transitory computer readable storage medium according to an embodiment of a third aspect of the present invention, receives a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
To achieve the above object, a computer program product according to a fourth aspect of the present invention is a computer program product, wherein when instructions of the computer program product are executed by a processor, a database capacity management method is performed, where the method is applied to online management of database capacity, and the method includes: receiving a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; and pushing the data after capacity management to a target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
A computer program product according to a fourth aspect of the present invention is created by receiving a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
The fifth aspect of the present invention further provides a computer device, which includes a housing, a processor, a memory, a circuit board, and a power circuit, wherein the circuit board is disposed inside a space enclosed by the housing, and the processor and the memory are disposed on the circuit board; the power supply circuit is used for supplying power to each circuit or device of the computer equipment; the memory is used for storing executable program codes; the processor executes a program corresponding to the executable program code by reading the executable program code stored in the memory, for performing: receiving a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; and pushing the data after capacity management to a target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
The computer device according to the fifth embodiment of the present invention receives a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
Additional aspects and advantages of the invention will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the invention.
Drawings
The foregoing and/or additional aspects and advantages of the present invention will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
fig. 1 is a schematic flow chart of a database capacity management method according to an embodiment of the present invention;
FIG. 2 is a flow chart illustrating a database capacity management method according to another embodiment of the present invention;
fig. 3 is a schematic structural diagram of a database capacity management apparatus according to an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of a database capacity management apparatus according to another embodiment of the present invention;
fig. 5 is a schematic structural diagram of a computer device according to an embodiment of the present invention.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the accompanying drawings are illustrative only for the purpose of explaining the present invention, and are not to be construed as limiting the present invention. On the contrary, the embodiments of the invention include all changes, modifications and equivalents coming within the spirit and terms of the claims appended hereto.
Fig. 1 is a flowchart illustrating a database capacity management method according to an embodiment of the present invention.
The present embodiment is exemplified in that the database capacity management method is configured as a database capacity management apparatus.
The database capacity management method in this embodiment may be configured in the database capacity management device, and the database capacity management device may be disposed in the server, or may also be disposed in the electronic device, which is not limited in this embodiment of the present invention.
The present embodiment takes the case where the database capacity management method is configured in an electronic device as an example.
The database capacity management method in the embodiment of the invention can be particularly applied to the background database capacity management process of the clearing platform, and is not limited.
The electronic device is, for example, a Personal Computer (PC), a cloud device or a mobile device, and the mobile device is, for example, a smart phone or a tablet Computer.
It should be noted that, the execution main body of the embodiment of the present invention may be, for example, a Central Processing Unit (CPU) in a server or an electronic device in terms of hardware, and may be, for example, a related background service in the server or the electronic device in terms of software, which is not limited to this.
In the related art, when a background database of a clearing platform is managed (for example, capacity expansion or capacity reduction of the database or fault detection), historical service data needs to be migrated, an online service needs to be suspended, and online management is not supported.
In order to solve the above technical problem, an embodiment of the present invention provides a database capacity management method, which receives a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
Referring to fig. 1, the method includes:
s101: a database management request is received.
The database management request may be used to perform online capacity expansion on the capacity of the database, or may be used to perform online capacity reduction on the capacity of the database, or may also be used to perform offline control on the database, which is not limited to this.
The database management request may be sent from the server side, for example, a background management server of the database may monitor the database in real time, and if it is monitored that the database needs to be managed, determine an identifier of the database that needs to be managed, generate a corresponding database management request based on the identifier, and send the database management request to the database processing center.
Or, the database management request may also be generated by being triggered by a manager of the background database, for example, the manager may select an item to be managed on a human-computer interaction interface of the database management platform, then upload an execution file or a script file of the updated database, trigger the database management platform to generate a corresponding database management request, and send the database management request to the database processing center, which is not limited to this.
S102: and analyzing the database management request to obtain management configuration information.
The management configuration information is configuration information required for managing the database.
The management configuration information may include, for example, some configuration parameters required for managing the database, an instruction for expanding or contracting the database, and information such as an identifier, an execution file, or a script file for managing the database.
In the specific execution process of the embodiment of the present invention, the receiving of the database management request and the analyzing of the database management request to obtain the management configuration information may be performed when the liquidation platform is in an online state, and specifically, the database processing center may call a preset Application Programming Interface (API) to analyze the database management request to obtain the management configuration information, and obtain an identifier of a database (which may be referred to as a target database) to be managed, and information such as an execution file or a script file for management.
S103: and carrying out capacity management on the data of the database processing center according to the management configuration information.
In the specific execution process, in order to realize online nondestructive management in the process of managing the background database of the liquidation platform without influencing foreground service access, the embodiment of the invention maintains a set of database processing centers and performs capacity management on the data of the database processing centers according to the management configuration information.
Optionally, in some embodiments, the database processing center may be configured prior to receiving the database management request, see fig. 2, the method further comprising:
s201: and acquiring the identification of each database of the background of the liquidation platform and the data table stored in each database.
It can be understood that, based on the actual service execution scenario of the clearing platform, there are generally a plurality of background databases, and therefore, in the embodiment of the present invention, the identifiers of the databases in the background of the clearing platform and the data tables stored in the databases may be obtained, and a database processing center is maintained according to the data tables of the obtained identifiers.
S202: and positioning each database according to the identification, and splitting the data table stored in each database according to a preset rule.
In a specific implementation process of the embodiment of the present invention, in order to make management (capacity expansion or capacity reduction) on the databases not limited to integral multiple capacity expansion or capacity reduction, the data tables stored in the databases may be split according to a preset rule, where the preset rule may be, for example: the method includes the steps of horizontally splitting according to preset days, splitting a data table of each preset day in an application scene with large data volume of the databases, for example, if the preset days are one day, horizontally splitting the data table according to one day, correspondingly splitting the data table of each day into fraction data tables of preset number, positioning the databases according to the identification, splitting the data tables stored in the databases according to preset rules, managing each fraction data table, refining management, and not being limited by architectural design of the databases, so that the management of the databases is flexible.
S203: and correspondingly storing the identification of each database and the split data table belonging to the database corresponding to the identification to a database processing center.
In the specific implementation process of the embodiment of the invention, after the data tables stored in the databases are split according to the preset rules, the serial numbers of each split data table are configured, and each data table is correspondingly stored based on the identification of each database, the serial numbers of each data table and the corresponding data table, so that each data table is finely stored from the technical point of view, and the subsequent storage management is facilitated.
In the specific implementation process of the embodiment of the present invention, in order to enable online lossless management without affecting foreground service access, the database is managed online while the access effect of the database is guaranteed, and after the identifier of each database and the split data table belonging to the database corresponding to the identifier are correspondingly stored in the database processing center, referring to fig. 2, the method may further include:
s204: and synchronously storing the identifier of each database and the split data table of the database corresponding to the identifier into a cache of the database processing center.
In the specific implementation process of the embodiment of the present invention, the identifier of each database and the split data table belonging to the database corresponding to the identifier may be synchronously stored in the cache of the database processing center, or the identifier of each database and the split data table belonging to the database corresponding to the identifier may be obtained at each preset time interval (for example, 10s) and stored in the cache of the database processing center, so that when the database is managed online, the foreground service may access the data in the cache, and the dependency on the database processing center may be reduced.
S104: and pushing the data after capacity management to a target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
The target database is a database which needs to manage the capacity of the target database.
In the specific implementation process of the embodiment of the present invention, after the capacity management is performed on the data in the database processing center according to the management configuration information, the data after the capacity management is triggered to be pushed to the target database indicated by the management configuration information, and specifically, the data after the capacity management may be copied to the target database indicated by the management configuration information to replace the corresponding data in the target database.
In the specific execution process, when the database management request is received and the first data table requested to be accessed by the database management request can be triggered to be managed, the state of the first data table in the database processing center is set to be an unavailable state.
Through the steps, when a service processing request sent by the clearing platform is received, whether the data table of the database processing center is read or the data table in the corresponding cache is read is determined according to the state of the data table in the database processing center, and the state flag bit is configured to trigger switching to accessing the corresponding data table from the cache in real time when the state of the data table of the database processing center is in an unavailable state, so that the continuity of foreground service access is guaranteed.
In the specific execution process, the embodiment of the invention can also receive a service processing request sent by the clearing platform in the process of managing the database capacity; and when the second data table requested by the service processing request is determined to be in an unavailable state, accessing the second data table synchronously stored in the cache of the database processing center, so that the front service access is not influenced.
In the specific implementation process of the embodiment of the present invention, in order to ensure that the data of the database processing center can be updated in real time and ensure the management accuracy of the database, after receiving the service processing request sent by the clearing platform, the method further includes: acquiring related data in a service processing process; and synchronously updating corresponding data tables in the database processing center and the cache according to the related data.
In this embodiment, a database management request is received; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
Fig. 3 is a schematic structural diagram of a database capacity management apparatus according to an embodiment of the present invention.
The method is applied to online management of database capacity.
Referring to fig. 3, the apparatus 300 includes: a first receiving module 301, a parsing module 302, a capacity management module 303, and a pushing module 304, wherein,
the first receiving module 301 is configured to receive a database management request.
The parsing module 302 is configured to parse the database management request to obtain management configuration information.
And the capacity management module 303 is configured to perform capacity management on the data of the database processing center according to the management configuration information.
The pushing module 304 is configured to push the data after capacity management to a target database indicated by the management configuration information, so as to perform online management on the capacity of the target database.
Optionally, in some embodiments, referring to fig. 4, further comprising:
the first obtaining module 305 is configured to obtain an identifier of each database in the background of the clearing platform, and a data table stored in each database.
And the processing module 306 is configured to locate each database according to the identifier, and split the data table stored in each database according to a preset rule.
The storage module 307 is configured to correspondingly store the identifier of each database and the split data table belonging to the database corresponding to the identifier to the database processing center.
Optionally, in some embodiments, the storage module 307 is further configured to:
and synchronously storing the identifier of each database and the split data table of the database corresponding to the identifier into a cache of the database processing center.
Optionally, in some embodiments, referring to fig. 4, further comprising:
the state setting module 308 is configured to set the state of the first data table in the database processing center to an unavailable state when receiving the database management request and triggering management of the first data table requested to be accessed by the database management request.
Optionally, in some embodiments, referring to fig. 4, further comprising:
and a second receiving module 309, configured to receive the service processing request sent by the clearing platform.
And the accessing module 310 is configured to, when it is determined that the second data table requested by the service processing request is in an unavailable state, access the second data table synchronously stored in the cache of the database processing center.
Optionally, in some embodiments, referring to fig. 4, further comprising:
the second obtaining module 311 is configured to obtain data related to a service processing process.
And an updating module 312, configured to perform synchronous updating on the corresponding data tables in the database processing center and the cache according to the relevant data.
It should be noted that the explanation of the embodiment of the database capacity management method in the foregoing embodiments of fig. 1-2 also applies to the database capacity management apparatus 300 of this embodiment, and the implementation principle is similar, and is not described herein again.
In this embodiment, a database management request is received; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
Fig. 5 is a schematic structural diagram of a computer device according to an embodiment of the present invention.
The computer device may be a mobile phone, a tablet computer, etc.
Referring to fig. 5, the computer apparatus 50 of the present embodiment includes: the electronic device comprises a shell 501, a processor 502, a memory 503, a circuit board 504 and a power supply circuit 505, wherein the circuit board 504 is arranged inside a space enclosed by the shell 501, and the processor 502 and the memory 503 are arranged on the circuit board 504; a power supply circuit 505 for supplying power to each circuit or device of the computer apparatus 50; the memory 503 is used to store executable program code; the processor 502 runs a program corresponding to the executable program code by reading the executable program code stored in the memory 503, so as to execute:
receiving a database management request;
analyzing the database management request to obtain management configuration information;
carrying out capacity management on the data of the database processing center according to the management configuration information;
and pushing the data after capacity management to a target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
It should be noted that the foregoing explanation on the embodiment of the database capacity management method in fig. 1-fig. 2 also applies to the computer device 50 of this embodiment, and the implementation principle is similar and will not be described again here.
The computer device in this embodiment receives a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
In order to implement the foregoing embodiments, the present invention also proposes a non-transitory computer-readable storage medium, wherein instructions of the storage medium, when executed by a processor of a terminal, enable the terminal to execute a database capacity management method for online management of database capacity, the method comprising: receiving a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; and pushing the data after capacity management to a target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
The non-transitory computer readable storage medium of the present embodiment, by receiving a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
In order to implement the foregoing embodiments, the present invention further provides a computer program product, wherein when instructions in the computer program product are executed by a processor, a database capacity management method is performed, which is applied to online management of database capacity, and the method includes: receiving a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; and pushing the data after capacity management to a target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
The computer program product in this embodiment, by receiving a database management request; analyzing the database management request to obtain management configuration information; carrying out capacity management on the data of the database processing center according to the management configuration information; the data after capacity management is pushed to the target database indicated by the management configuration information so as to perform online management on the capacity of the target database.
It should be noted that the terms "first," "second," and the like in the description of the present invention are used for descriptive purposes only and are not to be construed as indicating or implying relative importance. In addition, in the description of the present invention, "a plurality" means two or more unless otherwise specified.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps of the process, and alternate implementations are included within the scope of the preferred embodiment of the present invention in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present invention.
It should be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.
In addition, functional units in the embodiments of the present invention may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.
The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc.
In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present invention, and that variations, modifications, substitutions and alterations can be made to the above embodiments by those of ordinary skill in the art within the scope of the present invention.
Claims (15)
1. A database capacity management method is applied to online management of the database capacity, and comprises the following steps:
receiving a database management request when a clearing platform is in an online state, and sending the database management request to a database processing center, wherein the database processing center is maintained by a background of the clearing platform according to the identification of each database and a data table stored in the database corresponding to the identification;
analyzing the database management request to obtain management configuration information;
carrying out capacity management on the data of the database processing center according to the management configuration information;
and pushing the data after capacity management to a target database indicated by the management configuration information to replace corresponding data in the target database, wherein the target database is a database which needs capacity management in the database.
2. The database capacity management method of claim 1, further comprising, prior to said receiving a database management request:
acquiring identifiers of databases of a background of a clearing platform and data tables stored in the databases;
positioning each database according to the identification, and splitting a data table stored in each database according to a preset rule;
and correspondingly storing the identification of each database and the split data table belonging to the database corresponding to the identification to the database processing center.
3. The database capacity management method according to claim 2, wherein after the identifier of each database and the split data table belonging to the database corresponding to the identifier are correspondingly stored in the database processing center, the method further comprises:
and synchronously storing the identification of each database and the split data table belonging to the database corresponding to the identification into a cache of the database processing center.
4. The database capacity management method according to claim 3, further comprising:
and when the database management request is received and the first data table requested to be accessed by the database management request is triggered to be managed, setting the state of the first data table in the database processing center to be an unavailable state.
5. The database capacity management method according to claim 4, further comprising:
receiving a service processing request sent by the clearing platform;
and when determining that the second data table requested by the service processing request is in an unavailable state, accessing the second data table synchronously stored in the cache of the database processing center.
6. The database capacity management method according to claim 5, wherein after receiving the service processing request sent by the clearing platform, the method further comprises:
acquiring related data in a service processing process;
and synchronously updating the corresponding data tables in the database processing center and the cache according to the related data.
7. A database capacity management apparatus, for performing online management on the database capacity, the apparatus comprising:
the system comprises a first receiving module, a database processing center and a clearing platform background, wherein the first receiving module is used for receiving a database management request when the clearing platform is in an online state and sending the database management request to the database processing center, and the database processing center is maintained by the clearing platform background according to the identification of each database and a data table stored in the database corresponding to the identification;
the analysis module is used for analyzing the database management request to obtain management configuration information;
the capacity management module is used for carrying out capacity management on the data of the database processing center according to the management configuration information;
and the pushing module is used for pushing the data after capacity management to a target database indicated by the management configuration information so as to replace the corresponding data in the target database, wherein the target database is a database which needs capacity management in the database.
8. The database capacity management apparatus according to claim 7, further comprising:
the first acquisition module is used for acquiring the identification of each database of the background of the liquidation platform and the data table stored in each database;
the processing module is used for positioning each database according to the identification and splitting the data table stored in each database according to a preset rule;
and the storage module is used for correspondingly storing the identification of each database and the split data table belonging to the database corresponding to the identification to the database processing center.
9. The database capacity management apparatus of claim 8, wherein the storage module is further configured to:
and synchronously storing the identification of each database and the split data table belonging to the database corresponding to the identification into a cache of the database processing center.
10. The database capacity management apparatus according to claim 9, further comprising:
and the state setting module is used for setting the state of the first data table in the database processing center to be an unavailable state when the database management request is received and the first data table requested to be accessed by the database management request is triggered to be managed.
11. The database capacity management apparatus according to claim 10, further comprising:
the second receiving module is used for receiving the service processing request sent by the liquidation platform;
and the access module is used for accessing the second data table synchronously stored in the cache of the database processing center when the second data table requested by the service processing request is determined to be in an unavailable state.
12. The database capacity management apparatus according to claim 11, further comprising:
the second acquisition module is used for acquiring related data in the service processing process;
and the updating module is used for synchronously updating the corresponding data tables in the database processing center and the cache according to the related data.
13. A non-transitory computer-readable storage medium having stored thereon a computer program, wherein the program, when executed by a processor, implements the database capacity management method according to any one of claims 1 to 6.
14. A computer program product in which instructions, when executed by a processor, perform a database capacity management method for online management of the database capacity, the method comprising:
receiving a database management request when a clearing platform is in an online state, and sending the database management request to a database processing center, wherein the database processing center is maintained by a background of the clearing platform according to the identification of each database and a data table stored in the database corresponding to the identification;
analyzing the database management request to obtain management configuration information;
carrying out capacity management on the data of the database processing center according to the management configuration information;
and pushing the data after capacity management to a target database indicated by the management configuration information to replace corresponding data in the target database, wherein the target database is a database which needs capacity management in the database.
15. A computer device comprising a housing, a processor, a memory, a circuit board, and a power circuit, wherein the circuit board is disposed inside a space enclosed by the housing, the processor and the memory being disposed on the circuit board; the power supply circuit is used for supplying power to each circuit or device of the computer equipment; the memory is used for storing executable program codes; the processor executes a program corresponding to the executable program code by reading the executable program code stored in the memory, for performing:
receiving a database management request when a clearing platform is in an online state, and sending the database management request to a database processing center, wherein the database processing center is maintained by a background of the clearing platform according to the identification of each database and a data table stored in the database corresponding to the identification;
analyzing the database management request to obtain management configuration information;
carrying out capacity management on the data of the database processing center according to the management configuration information;
and pushing the data after capacity management to a target database indicated by the management configuration information to replace corresponding data in the target database, wherein the target database is a database which needs capacity management in the database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811044560.1A CN110019148B (en) | 2018-09-07 | 2018-09-07 | Database capacity management method and device, storage medium and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811044560.1A CN110019148B (en) | 2018-09-07 | 2018-09-07 | Database capacity management method and device, storage medium and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110019148A CN110019148A (en) | 2019-07-16 |
| CN110019148B true CN110019148B (en) | 2021-05-25 |
Family
ID=67188457
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811044560.1A Active CN110019148B (en) | 2018-09-07 | 2018-09-07 | Database capacity management method and device, storage medium and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110019148B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115271971B (en) * | 2022-09-30 | 2023-03-10 | 深圳迅策科技有限公司 | Automatic clearing method and system for money fund system |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102880475A (en) * | 2012-10-23 | 2013-01-16 | 上海普元信息技术股份有限公司 | Real-time event handling system and method based on cloud computing in computer software system |
| CN103617231A (en) * | 2013-11-26 | 2014-03-05 | 国家电网公司 | Large data management system |
| CN104699807A (en) * | 2015-03-23 | 2015-06-10 | 上海新炬网络信息技术有限公司 | Automatic monitoring and expansion method for ORACLE data table space |
| CN104765794A (en) * | 2015-03-25 | 2015-07-08 | 深圳市创梦天地科技有限公司 | Database partitioning method and device |
| CN106777031A (en) * | 2016-12-08 | 2017-05-31 | 腾讯音乐娱乐（深圳）有限公司 | A kind of data-base capacity-enlarging method and device |
| CN106897345A (en) * | 2016-07-22 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of method and device of data storage |
| CN107357896A (en) * | 2017-07-13 | 2017-11-17 | 北京小度信息科技有限公司 | Expansion method, device, system and the data base cluster system of data-base cluster |
| CN107919977A (en) * | 2016-10-11 | 2018-04-17 | 阿里巴巴集团控股有限公司 | A kind of on-line rapid estimation of the distributed consensus system based on Paxos agreements, the method and apparatus of online capacity reducing |
| CN108399262A (en) * | 2018-03-14 | 2018-08-14 | 北京思特奇信息技术股份有限公司 | A kind of data-base capacity-enlarging method and system |
Family Cites Families (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101321319A (en) * | 2008-07-16 | 2008-12-10 | 中兴通讯股份有限公司 | Monitoring and recovery apparatus and method for invalid connection of business database |
| US8074107B2 (en) * | 2009-10-26 | 2011-12-06 | Amazon Technologies, Inc. | Failover and recovery for replicated data instances |
| US9152688B2 (en) * | 2013-03-08 | 2015-10-06 | International Business Machines Corporation | Summarizing a stream of multidimensional, axis-aligned rectangles |
| CN103886104A (en) * | 2014-04-11 | 2014-06-25 | 江苏瑞中数据股份有限公司 | Distributed real-time database management system and implementation method applicable to electric system |
| CN104539713B (en) * | 2014-12-31 | 2018-10-09 | 北京奇虎科技有限公司 | service request processing method and device |
| CN106909563B (en) * | 2015-12-23 | 2021-01-08 | 上海热璞网络科技有限公司 | Distributed system |
| US20170286471A1 (en) * | 2016-03-31 | 2017-10-05 | Mckesson Corporation | Methods and apparatuses for enterprise revision-based auditing of database management systems |
| CN105933391B (en) * | 2016-04-11 | 2019-06-21 | 聚好看科技股份有限公司 | A kind of node expansion method, apparatus and system |
| US10872074B2 (en) * | 2016-09-30 | 2020-12-22 | Microsoft Technology Licensing, Llc | Distributed availability groups of databases for data centers |
| CN108319596A (en) * | 2017-01-16 | 2018-07-24 | 阿里巴巴集团控股有限公司 | A kind of expansion method and device of database |
-
2018
- 2018-09-07 CN CN201811044560.1A patent/CN110019148B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102880475A (en) * | 2012-10-23 | 2013-01-16 | 上海普元信息技术股份有限公司 | Real-time event handling system and method based on cloud computing in computer software system |
| CN103617231A (en) * | 2013-11-26 | 2014-03-05 | 国家电网公司 | Large data management system |
| CN104699807A (en) * | 2015-03-23 | 2015-06-10 | 上海新炬网络信息技术有限公司 | Automatic monitoring and expansion method for ORACLE data table space |
| CN104765794A (en) * | 2015-03-25 | 2015-07-08 | 深圳市创梦天地科技有限公司 | Database partitioning method and device |
| CN106897345A (en) * | 2016-07-22 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of method and device of data storage |
| CN107919977A (en) * | 2016-10-11 | 2018-04-17 | 阿里巴巴集团控股有限公司 | A kind of on-line rapid estimation of the distributed consensus system based on Paxos agreements, the method and apparatus of online capacity reducing |
| CN106777031A (en) * | 2016-12-08 | 2017-05-31 | 腾讯音乐娱乐（深圳）有限公司 | A kind of data-base capacity-enlarging method and device |
| CN107357896A (en) * | 2017-07-13 | 2017-11-17 | 北京小度信息科技有限公司 | Expansion method, device, system and the data base cluster system of data-base cluster |
| CN108399262A (en) * | 2018-03-14 | 2018-08-14 | 北京思特奇信息技术股份有限公司 | A kind of data-base capacity-enlarging method and system |
Non-Patent Citations (1)
| Title |
|---|
| 在线云存储系统的设计与应用;吴超龙;《中国优秀硕士学位论文全文数据库 信息科技辑》;20100215(第02期);I137-39 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110019148A (en) | 2019-07-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110019004B (en) | Data processing method, device and system | |
| CN110597595A (en) | Method for providing multi-language information, method for configuring multi-language information, device, equipment and medium | |
| US10402100B2 (en) | Techniques for path optimization in storage networks | |
| CN106874281B (en) | Method and device for realizing database read-write separation | |
| CN111198859B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN112636992B (en) | Dynamic routing method, device, equipment and storage medium | |
| CN109857723B (en) | Dynamic data migration method based on expandable database cluster and related equipment | |
| CN104267872A (en) | Application program APP information display method and device and mobile terminal | |
| CN111290871A (en) | Method and device for acquiring crash information of application program | |
| CN110019148B (en) | Database capacity management method and device, storage medium and computer equipment | |
| CN113064919B (en) | Data processing method, data storage system, computer device and storage medium | |
| CN110554992B (en) | Distributed metadata path management method, system, terminal and storage medium | |
| CN107239303B (en) | Application program update package generation method and device and application program update method and device | |
| CN112199176A (en) | Service processing method, device and related equipment | |
| CN112115149A (en) | Method and device for providing data | |
| CN115982148A (en) | Database table processing method and device, electronic equipment and storage medium | |
| CN112799642B (en) | Method, apparatus, device and storage medium for processing data | |
| CN115080164A (en) | Micro front-end page jump method, device and storage medium | |
| CN110019535B (en) | Database management method, database management device, storage medium and computer equipment | |
| CN114020214A (en) | Storage cluster capacity expansion method and device, electronic equipment and readable storage medium | |
| CN108874560B (en) | Method and communication device for communication | |
| CN113094041A (en) | Component management method and device of application program and computer equipment | |
| CN109726053B (en) | Switching method and device of database control center and computer equipment | |
| CN111190549A (en) | Method, device, equipment and medium for acquiring available capacity of shared volume | |
| CN113127430A (en) | Mirror image information processing method and device, computer readable medium and electronic equipment |
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 |