CN101162461A - EMS memory data-base capacity-enlarging method - Google Patents
EMS memory data-base capacity-enlarging method Download PDFInfo
- Publication number
- CN101162461A CN101162461A CNA2006101402021A CN200610140202A CN101162461A CN 101162461 A CN101162461 A CN 101162461A CN A2006101402021 A CNA2006101402021 A CN A2006101402021A CN 200610140202 A CN200610140202 A CN 200610140202A CN 101162461 A CN101162461 A CN 101162461A
- Authority
- CN
- China
- Prior art keywords
- memory database
- dilatation
- capacity
- increment
- memory
- 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.)
- Granted
Links
Images
Abstract
The present invention discloses a capacity enlarging method of memory database, comprising the following steps that a capacity enlarging time segment of a memory database is set, which ensures that the memory database can start conditional capacity enlarging operation only in the set time segment; the capacity enlarging operation orderly executes the following operation of setting the increment of the memory database needing capacity enlargement, initializing the parameter of the memory database, suspending the service provided to external by the memory database and load a datasheet of the database into a memory again to accomplish the capacity enlarging operation. As the method of the present invention adopts a mode that all the capacity enlarging operation of the memory database is executed in the time segment with the least user amount of a client service system, the whole system is in a steady state during the capacity enlargement of the memory database, and the operation of the system cannot be affected, therefore, the capacity enlarging method of the present invention greatly guarantees the stability of the client service system.
Description
Technical field
The present invention relates to the main memory DBM method that a kind of field of telecommunications uses, particularly be the method for a kind of memory database intelligence dilatation.
Background technology
In the content delivery process of the field of telecommunications of prior art, the visit of general logarithm certificate has very high performance requirement, when particularly facing the data of a large number of users use, not only requiring will have very high performance to the visit and the storage of data, more requires to have reliable dilatation function and deals with the constant data that increase in the field of telecommunications.
Therefore in the telecommunications application, the memory technology of use must satisfy the dilatation function with high reliability, and memory database can satisfy above-mentioned requirements as a kind of high-performance data visit memory technology, is adopted widely in the application of telecommunications.
Existing EMS memory data-base capacity-enlarging scheme all has fixing dilatation mechanism, it comprises: at first detect its capacity in the memory database operational process, start dilatation mechanism immediately and carry out dilatation when the idle recording capacity of memory database is lower than the fixedly threshold values capacity of setting.Because the singularity of memory database, the EMS memory data-base capacity-enlarging operation is very consuming time, minute being unit, according to 1 to 2 minute at least consuming time of the different EMS memory data-base capacity-enlargings operations of environment, reaches several minutes at most.
And, having a large number of users using in the telecommunication service system at memory database place at field of telecommunications, the situation that causes memory database to start dilatation mechanism often occurs.At this moment, all telecommunication services that are based upon on the memory database all can be affected: gently then cause system's denial of service, and heavy then make total system collapse, and cause the complaint of a large number of users, make operator suffer a large amount of economic losses.
Therefore, need consider the dilatation operation influence to operation system when memory database carries out dilatation, prior art also exists and remains improvements.
Summary of the invention
The object of the present invention is to provide a kind of method of EMS memory data-base capacity-enlarging, solve the negative effect that the dilatation operation produces the whole service system.
The implementation of the inventive method is as follows:
A kind of method of EMS memory data-base capacity-enlarging, it may further comprise the steps:
A, dilatation time period of memory database is set, operates so that memory database could start dilatation with good conditionsi in the section at the appointed time;
Following operation is carried out in B, dilatation operation successively: the increment that memory database needs dilatation is set, and the parameter of initialization memory database is suspended the service that memory database externally provides, and is written into the database data table again and finishes the dilatation operation in internal memory.
Described method, wherein, described steps A also comprises:
A1, be set the time cycle, and in the increment of memory database run duration statistics remaining idle recording capacity and service recorder in this time cycle, and preserve;
If A2, in the critical point in described memory database run duration entry time cycle then adds up the capacity of the idle record of maximum service recorder increment and memory database, in the dilatation time period of memory database, judge whether to carry out the dilatation operation.
Described method, wherein, described steps A 2 also comprises:
A21, the critical point of timing statistics cycle be the capacity of the idle record of memory database constantly, and preserves;
A22, and calculate the increment of memory database service recorder in cycle current time according to the idle recording capacity of preserving in a last time cycle critical point;
A23, the memory database service recorder increment that the increment of the memory database service recorder in the current period and last time cycle are preserved compare, preserve value maximum in these two increments, only write down the service recorder increment of first time cycle if memory database starts for the first time.
Described method wherein, if do not carry out the dilatation operation, then repeats beginning cycle statistics.
The method of a kind of EMS memory data-base capacity-enlarging provided by the present invention, because the mode that the dilatation operation of adopting memory database is all carried out in the time period of the customer volume minimum of customer service system, make total system during EMS memory data-base capacity-enlarging, be in a stable status, can not have influence on the operation of system, so expansion method of the present invention has greatly guaranteed the stability of customer service system.
Description of drawings
Fig. 1 is the schematic flow sheet of the inventive method.
Embodiment
Below in conjunction with accompanying drawing, will be described in more detail each preferred embodiment of the present invention.
The method of EMS memory data-base capacity-enlarging of the present invention, as shown in Figure 1, the concrete application in customer service system comprises that step is as follows:
The time period of the startup dilatation operation of memory database A), at first is set by configuration file, makes memory database start the dilatation operation of having ready conditions in the section at the appointed time.
According to the characteristics of telecommunication service, EMS memory data-base capacity-enlarging should carry out in the time period of customer volume minimum.In customer service system, the dilatation that memory database can be set operates in morning 3:00 to carrying out between the 3:30, because be the time period of customer volume minimum during this period of time, whole customer service system is in the state of a underload, and the dilatation operation can not exerting an influence to total system.
B, with the starting point of the dilatation time period that is provided with in the steps A as with reference to value, be the 3:00 in morning every day, time cycle is set, and the critical point of each time cycle also is 3:00 in morning every day, and the setting of time cycle also can be provided with in configuration file according to the concrete business of telecommunications.The higher customer service system of telephone traffic in actual applications with 24 hours as one-period, for example color tinkling of pieces of jade of other system can be provided with 48 hours as one-period.The increment of idle recording capacity of memory database run duration statistics memory database in this cycle and service recorder, and preserve;
C, set the parameter of customer service system EMS memory data-base capacity-enlarging operation after, as shown in Figure 1,, then carry out following operation if the memory database run duration enters the critical point of the time cycle of setting:
C.1) capacity of the idle record of residue of the memory database of the critical point moment in timing statistics cycle customer service system;
C.2) and according to step c 1) the idle recording capacity of preserving in the critical point of last one-period calculates the increment of memory database service recorder in cycle current time;
C.3) the memory database service recorder increment of the increment of the memory database service recorder in the current period and last time cycle preservation is compared, preserve value maximum in these two increments, only write down the service recorder increment of first time cycle if memory database starts for the first time, the increment size of the customer service system memory database service recorder of current period preservation is maximal value all the time like this;
D, in the dilatation time period of memory database, according to the traffic performance of customer service system, if the service recorder increment in time cycle multiply by 2 greater than the idle recording capacity of memory database then carry out the dilatation operation;
E, according to the detection of step D, if do not carry out the dilatation operation, then enter step C and repeat beginning cycle statistics;
F, according to the detection of step D, if carry out the dilatation operation, the increment of memory database needs dilatation then is set according to step C statistics, the service recorder increment that the value of dilatation is set to one-period in the customer service system multiply by 2, the parameter of initialization memory database then, suspend the service that memory database externally provides, be written into the database data table again and in internal memory, finish the dilatation operation, enter steps A after the dilatation operation is finished and repeat process of the present invention.
The inventive method is according to the ruuning situation of the customer service system of ZTE Corporation, and its EMS memory data-base capacity-enlarging method has greatly improved the stability of customer service system.Because the dilatation of memory database of the present invention operation is all carried out in the time period of the customer volume minimum of customer service system, makes total system be in a stable status during EMS memory data-base capacity-enlarging, does not have influence on the operation of system.
In the use of reality, in the customer service system of ZTE, memory database is used to write down the recording of customer service, and requires the recording of customer service was preserved 90 days at least.Owing to have a large amount of clients to enter system and obtain service every day, the capacity of memory database is all increasing every day sharp, and the dilatation operation is unavoidable.And because the expansion method that the present invention describes is well used in this system, the dilatation operation of memory database does not have influence on the stability of total system, has improved the service ability of operator greatly.
Should be understood that above-mentioned description at specific embodiment is comparatively detailed, can not therefore be interpreted as the restriction to scope of patent protection of the present invention, scope of patent protection of the present invention should be as the criterion with claims.
Claims (4)
1. the method for an EMS memory data-base capacity-enlarging, it may further comprise the steps:
A, dilatation time period of memory database is set, operates so that memory database could start dilatation with good conditionsi in the section at the appointed time;
Following operation is carried out in B, dilatation operation successively: the increment that memory database needs dilatation is set, and the parameter of initialization memory database is suspended the service that memory database externally provides, and is written into the database data table again and finishes the dilatation operation in internal memory.
2. method according to claim 1 is characterized in that, described steps A also comprises:
A1, be set the time cycle, and in the increment of memory database run duration statistics remaining idle recording capacity and service recorder in this time cycle, and preserve;
If A2, in the critical point in described memory database run duration entry time cycle then adds up the capacity of the idle record of maximum service recorder increment and memory database, in the dilatation time period of memory database, judge whether to carry out the dilatation operation.
3. method according to claim 2 is characterized in that, described steps A 2 also comprises:
A21, the critical point of timing statistics cycle be the capacity of the idle record of memory database constantly, and preserves;
A22, and calculate the increment of memory database service recorder in cycle current time according to the idle recording capacity of preserving in a last time cycle critical point;
A23, the memory database service recorder increment that the increment of the memory database service recorder in the current period and last time cycle are preserved compare, preserve value maximum in these two increments, only write down the service recorder increment of first time cycle if memory database starts for the first time.
4. method according to claim 2 is characterized in that, if do not carry out the dilatation operation, then repeats beginning cycle statistics.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006101402021A CN100555282C (en) | 2006-10-09 | 2006-10-09 | A kind of method of EMS memory data-base capacity-enlarging |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006101402021A CN100555282C (en) | 2006-10-09 | 2006-10-09 | A kind of method of EMS memory data-base capacity-enlarging |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101162461A true CN101162461A (en) | 2008-04-16 |
| CN100555282C CN100555282C (en) | 2009-10-28 |
Family
ID=39297386
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2006101402021A Expired - Fee Related CN100555282C (en) | 2006-10-09 | 2006-10-09 | A kind of method of EMS memory data-base capacity-enlarging |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100555282C (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102799456A (en) * | 2012-07-24 | 2012-11-28 | 上海晨思电子科技有限公司 | Method and device for uploading resource files by game engine, and computer |
| CN103019956A (en) * | 2012-10-23 | 2013-04-03 | 北京奇虎科技有限公司 | Method and device for operating cache data |
| CN103377073A (en) * | 2012-04-26 | 2013-10-30 | 中国银联股份有限公司 | Data information processing device and method |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104142943B (en) * | 2013-05-07 | 2019-03-29 | 上海盛大网络发展有限公司 | A kind of data-base capacity-enlarging method and a kind of database |
| CN106897332A (en) * | 2016-06-14 | 2017-06-27 | 阿里巴巴集团控股有限公司 | Data-base capacity-enlarging method and device |
-
2006
- 2006-10-09 CN CNB2006101402021A patent/CN100555282C/en not_active Expired - Fee Related
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103377073A (en) * | 2012-04-26 | 2013-10-30 | 中国银联股份有限公司 | Data information processing device and method |
| CN102799456A (en) * | 2012-07-24 | 2012-11-28 | 上海晨思电子科技有限公司 | Method and device for uploading resource files by game engine, and computer |
| CN102799456B (en) * | 2012-07-24 | 2015-11-25 | 上海晨思电子科技有限公司 | A kind of game engine loads the method for resource file, device and computing machine |
| CN103019956A (en) * | 2012-10-23 | 2013-04-03 | 北京奇虎科技有限公司 | Method and device for operating cache data |
| CN103019956B (en) * | 2012-10-23 | 2015-11-25 | 北京奇虎科技有限公司 | A kind of to data cached method of operating and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100555282C (en) | 2009-10-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9864597B1 (en) | Systems and methods for providing software updates | |
| US7707573B1 (en) | Systems and methods for providing and installing software | |
| CN102790727B (en) | A kind of method and system of dynamic propelling movement individual subscriber label | |
| CN100555282C (en) | A kind of method of EMS memory data-base capacity-enlarging | |
| CN102023973A (en) | Method, device and system for synchronizing database with application cache server | |
| CN104038632A (en) | Method and device for managing intelligent terminal | |
| CN102890628A (en) | Method and device for displaying target object | |
| CN106878525A (en) | A kind of incoming information reminds the display methods and device at interface | |
| CN108650334A (en) | A kind of setting method and device of session failed | |
| CN110019024A (en) | A kind of directory method, system and electronic equipment and storage medium | |
| CN106371856A (en) | Menu statistical method and user terminal and application backstage terminal | |
| CN107332966A (en) | A kind of backup method of address list information | |
| CN105302702A (en) | Method and apparatus for testing performance of terminal | |
| CN102937923A (en) | Method for automatically storing state of user interface | |
| CN104166650B (en) | Data storage device and date storage method | |
| CN109840182A (en) | A kind of resource monitoring method, device and electronic equipment | |
| CN110109865A (en) | A kind of date storage method, device, equipment and readable storage medium storing program for executing | |
| US7778660B2 (en) | Mobile communications terminal, information transmitting system and information receiving method | |
| WO2012109915A1 (en) | Telephone traffic data storage method and system | |
| CN103078766B (en) | The auditing method of network traffics, device and the network equipment | |
| CN114880071A (en) | Cluster configuration method and device, equipment, medium and product thereof | |
| CN110688610B (en) | Weight calculation method and device for graph data and electronic equipment | |
| CN111158837B (en) | Bank software function interface generation method and device | |
| US20120264480A1 (en) | System and method of intelligent data sharing for advanced features on mobile platforms | |
| CN114500128A (en) | Flow control charging method, device, system, electronic equipment, medium and product |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20091028 Termination date: 20151009 |
|
| EXPY | Termination of patent right or utility model |