CN100555282C - A kind of method of EMS memory data-base capacity-enlarging - Google Patents
A kind of method of EMS memory data-base capacity-enlarging Download PDFInfo
- Publication number
- CN100555282C CN100555282C CNB2006101402021A CN200610140202A CN100555282C CN 100555282 C CN100555282 C CN 100555282C CN B2006101402021 A CNB2006101402021 A CN B2006101402021A CN 200610140202 A CN200610140202 A CN 200610140202A CN 100555282 C CN100555282 C CN 100555282C
- Authority
- CN
- China
- Prior art keywords
- dilatation
- memory database
- increment
- memory
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
Images
Abstract
The invention discloses a kind of method of EMS memory data-base capacity-enlarging, it may further comprise the steps: be set, so that memory database could start dilatation operation with good conditionsi in the section at the appointed time the dilatation time period of memory database; Following operation is carried out in the 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.The inventive method is 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
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, the dilatation time period and the time cycle of memory database are set, at the memory database run duration, the increment of statistics remaining idle recording capacity and service recorder in the time cycle, and preserve; In the dilatation time period of memory database, and satisfy the dilatation condition and could start dilatation operation;
Following operation is carried out in B, dilatation operation successively: the increment that the dilatation of memory database needs is set according to the increment of described service recorder, the parameter of initialization memory database, suspend the service that memory database externally provides, be written into the database data table again and in internal memory, finish the dilatation operation.
Described method, the generation of the increment of service recorder comprises:
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;
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.
Described method wherein, if do not carry out the dilatation operation, then repeats beginning cycle statistics.
Described dilatation condition is:
The service recorder increment of current preservation multiply by 2, greater than the idle recording capacity of memory database, then carries out the operation of dilatation.
The described dilatation time period is 3:00 AM to 3 thirty.
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 (5)
1, a kind of method of EMS memory data-base capacity-enlarging, it may further comprise the steps:
A, the dilatation time period and the time cycle of memory database are set, at the memory database run duration, the increment of statistics remaining idle recording capacity and service recorder in the time cycle, and preserve; In the dilatation time period of memory database, and satisfy the dilatation condition and could start dilatation operation;
Following operation is carried out in B, dilatation operation successively: the increment that the dilatation of memory database needs is set according to the increment of described service recorder, the parameter of initialization memory database, suspend the service that memory database externally provides, be written into the database data table again and in internal memory, finish the dilatation operation.
2, method according to claim 1 is characterized in that, the generation of the increment of described service recorder comprises:
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;
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.
3, method according to claim 2 is characterized in that, if do not carry out the dilatation operation, then repeats beginning cycle statistics.
4, method according to claim 1 is characterized in that, described dilatation condition is:
The service recorder increment of current preservation multiply by 2, greater than the idle recording capacity of memory database, then carries out the operation of dilatation.
5, method according to claim 1 is characterized in that, the described dilatation time period is 3:00 AM to 3 thirty.
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 CN101162461A (en) | 2008-04-16 |
| CN100555282C true 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 (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104142943A (en) * | 2013-05-07 | 2014-11-12 | 上海盛大网络发展有限公司 | Database expansion method and database |
| CN106897332A (en) * | 2016-06-14 | 2017-06-27 | 阿里巴巴集团控股有限公司 | Data-base capacity-enlarging method and device |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103377073B (en) * | 2012-04-26 | 2016-09-28 | 中国银联股份有限公司 | Processing data information device and method |
| CN102799456B (en) * | 2012-07-24 | 2015-11-25 | 上海晨思电子科技有限公司 | A kind of game engine loads the method for resource file, device and computing machine |
| CN103019956B (en) * | 2012-10-23 | 2015-11-25 | 北京奇虎科技有限公司 | A kind of to data cached method of operating and device |
-
2006
- 2006-10-09 CN CNB2006101402021A patent/CN100555282C/en not_active Expired - Fee Related
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104142943A (en) * | 2013-05-07 | 2014-11-12 | 上海盛大网络发展有限公司 | Database expansion method and database |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101162461A (en) | 2008-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100555282C (en) | A kind of method of EMS memory data-base capacity-enlarging | |
| CN103309729A (en) | Terminal and application program management method | |
| CN101183979B (en) | Method and device of configuration backup | |
| CN103560919B (en) | A kind of method for evaluating quality and equipment based on speech business | |
| CN109344071A (en) | The method for automatically generating LoadRunner performance test script | |
| CN107402870A (en) | The processing method and processing device of daily record section in a kind of meta data server | |
| CN108650334A (en) | A kind of setting method and device of session failed | |
| CN101436924B (en) | Method, apparatus and system for synchronizing data | |
| CN101924821A (en) | Mobile communication terminal as well as method and system for starting application program by same | |
| CN105308589A (en) | Compacting data based on data content | |
| CN109656784A (en) | A kind of log processing method and device | |
| CN106371856A (en) | Menu statistical method and user terminal and application backstage terminal | |
| CN109710623A (en) | A kind of intelligence order synchronous method | |
| CN105872731A (en) | Data processing method and device | |
| CN111078588B (en) | Garbage recycling method, device, equipment and storage medium | |
| CN104572751A (en) | Compression storage method and system for calling center sound recording files | |
| CN110109865A (en) | A kind of date storage method, device, equipment and readable storage medium storing program for executing | |
| CN105306742A (en) | Intelligent handset App page detention time statistical software method and system | |
| CN110087232A (en) | A kind of call processing method based on smart machine, device and server | |
| CN107589886A (en) | The display control method and device of a kind of icon, terminal and readable storage medium storing program for executing | |
| CN103379461A (en) | Data service traffic statistical method and terminal | |
| CN101557291B (en) | Method for log aggregation and device thereof | |
| CN104754270A (en) | Maximum video acquisition method and device and terminal | |
| CN112468387A (en) | Template message sending method, computer equipment and computer storage medium | |
| CN104954567A (en) | Power utilization control method and device of mobile terminal |
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 |