CN101414917A - Method for saving internal memory space, data management network element and network system - Google Patents
Method for saving internal memory space, data management network element and network system Download PDFInfo
- Publication number
- CN101414917A CN101414917A CNA200710163368XA CN200710163368A CN101414917A CN 101414917 A CN101414917 A CN 101414917A CN A200710163368X A CNA200710163368X A CN A200710163368XA CN 200710163368 A CN200710163368 A CN 200710163368A CN 101414917 A CN101414917 A CN 101414917A
- Authority
- CN
- China
- Prior art keywords
- user
- data
- user data
- database
- physical 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.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention discloses a method for saving memory space. The method comprises the steps as follows: a loading strategy used for confirming the user of a physical database to be unloaded is transferred to obtain a user mark of the physical database to be unloaded; the data of the user of the physical database to be unloaded is obtained from a memory database according to the user mark, and the obtained user data is stored in the physical database; and the user data in the memory database is deleted. The technical proposal provided by the invention can save the space of the memory database.
Description
Technical field
The present invention relates to communication technical field, particularly a kind of method, data management network element and network system of saving memory headroom.
Background technology
Online Charging System (online charging system, OCS) be the billing mechanism that charge information can come into force in real time, being characterized in chargeing participates in whole service use, charges while using, and therefore needs the directly mutual of billing mechanism and session/service control.In order to support real time billing flexibly, and satisfy high concurrent call business simultaneously, the OCS system has adopted memory database to improve performance, and the OCS system all is stored in the user data that all chargings relate in the memory database.
In research and practice process to prior art, the inventor finds that there is following problem in prior art:
Because the user data that the OCS system relates to all chargings all is stored in the memory database, memory database is just very big to space requirement so.When number of users reaches 1,000,000 when above, need take huge memory headroom, the equipment cost of operation OCS system is increased.
Summary of the invention
The technical problem that the embodiment of the invention will solve provides a kind of method, data management network element and network system of saving memory headroom, can save the space of memory database.
In view of this, the embodiment of the invention provides:
A kind of method of saving memory headroom comprises:
Call the loading strategy that is used to determine treat the user of unloading physical database, obtain treating the user ID of unloading physical database;
According to described user ID, obtain the described user's data for the treatment of the unloading physical database from memory database, deposit the user data that is obtained in physical database;
Delete the described user data in the described memory database.
A kind of data management network element comprises: carries out loading policy unit, obtains user data cell, and the user data dump unit, the user data delete cells,
Described execution loads policy unit, is used to call the loading strategy that is used to determine treat the user of unloading physical database, obtains treating the user ID of unloading physical database;
The described user data cell that obtains is used for according to described user ID, obtains the described user's data for the treatment of the unloading physical database from memory database;
Described user data dump unit, the user data that is used for being obtained deposits physical database in;
Described user data delete cells is used for deleting the described user data of described memory database.
A kind of network system comprises: data management network element, and memory database, physical database,
Described data management network element is used to call the loading strategy that is used to determine treat the user of unloading physical database, obtains treating the user ID of unloading physical database; According to described user ID, obtain the described user's data for the treatment of the unloading physical database from memory database; Deposit the user data that is obtained in physical database, and delete the described user data in the described memory database.
A technical scheme in the technique scheme has following beneficial effect:
The embodiment of the invention loads strategy by calling, obtain treating the user of unloading physical database, these treat that the user of unloading physical database can be the user that non-excited users or statistics talk times are less than predetermined value, these user's data are not often used, so these user's data are taken out from memory database dump to physical database, and this user data in the deletion memory database, to save the space of memory database.
Description of drawings
The method flow diagram of the saving memory headroom that Fig. 1 provides for the embodiment of the invention one;
The method flow diagram of the saving memory headroom that Fig. 2 provides for the embodiment of the invention two;
The method flow diagram of the saving memory headroom that Fig. 3 provides for the embodiment of the invention three;
The data management network element structure chart that Fig. 4 provides for the embodiment of the invention four;
The network architecture figure that Fig. 5 provides for the embodiment of the invention five.
Embodiment
The embodiment of the invention provides a kind of method of saving memory headroom, comprising: call the loading strategy that is used to determine treat the user of unloading physical database, obtain treating the user ID of unloading physical database; According to described user ID, obtain the described user's data for the treatment of the unloading physical database from memory database, deposit the user data that is obtained in physical database; Delete the described user data in the described memory database.Use technical scheme provided by the invention, can save the space of memory database.
Consult Fig. 1, the embodiment of the invention one provides a kind of method of saving memory headroom, and this method specifically comprises:
Wherein, be used to determine that the loading strategy for the treatment of the user of unloading physical database can be: the user ID of obtaining non-excited users, perhaps, obtain the sign that every month talk times is less than the user of predetermined value, can also be other strategy of determining to treat the user of unloading physical database, not influence realization of the present invention.
Can regularly call in the embodiment of the invention and load strategy, obtain treating the user ID of unloading physical database.
Wherein, this step can just be carried out after step 102 gets access to user data from memory database, does not influence realization of the present invention.
Consult Fig. 2, the embodiment of the invention two provides a kind of method of saving memory headroom, before with user data unloading physical database, generates and is used for user data is carried out the control information that scheduled transaction is handled in this method, and this method specifically comprises:
Wherein, that be used for storing subscriber information in the physical database (physical DB) is physics table (userinfo_store), and the structure of this physics table is as shown in table 1.Wherein, user profile comprises: user ID, with SQL field form storage user data, control information.Wherein, this SQL field form storage user data only is used for preserving, and can not revise, and is generally only used when physical database is loaded into memory database at user data.Be modified if be loaded into the user data of memory database, when this user data stores physical database into once more so, the SQL field that is used for the user data after the memory modify will produce again.
| Field name | Field description |
| Key | User ID |
| Common | Control information |
| SQL | Insert user data Insert into subscribervalues (); |
Table 1, physics list structure
Wherein, this step can just be carried out after step 202 gets access to user data from memory database, does not influence realization of the present invention.
Consult Fig. 3, the embodiment of the invention three provides a kind of method of saving memory headroom, and this method specifically comprises:
Step 301-step 307 is identical with step 201-step 207;
Wherein, step 308 can be carried out after the user activates, following two kinds of active modes can be arranged: a kind ofly be: the user is from CRM system (Customer Relation Management, CRM) side is initiated activation manipulation, be the user from the business hall, website etc. triggers crm system, make crm system activate this user, write down being designated of this User Status in the crm system this moment: activated sign; Another kind of mode is: the user calls out as calling and called, and the OCS system carries out initial activation to this user, and this mode default user is activated when calling out first.
Wherein, first step is resulting among the embodiment of the invention two and the embodiment three treats that the user of unloading physical database can be: non-excited users, perhaps talk times is less than the user of predetermined value.
Certainly, the embodiment of the invention also can be kept at user's partial data in the memory database, these certain customers' data that are stored in the memory database are carried out scheduled transaction, with another part storage of subscriber data in physical database, when this certain customers' data extract is gone out physical database, replenish and carry out storage of subscriber data unenforced scheduled transaction during physical database, perhaps, the certain customers' data that are stored in the physical database are not need to carry out scheduled transaction, this certain customers' data extract is gone out physical database, when being loaded into memory database, these certain customers' data are not made amendment.
Initial user data in the embodiment of the invention be by CRM system (CustomerRelation Management CRM) generates, and with storage of subscriber data in memory database.
One of ordinary skill in the art will appreciate that all or part of step that realizes in the foregoing description method is to instruct relevant hardware to finish by program, described program can be stored in a kind of computer-readable recording medium, for example, read-only memory, disk or CD etc.
Consult Fig. 4, the embodiment of the invention four provides a kind of data management network element, and this network element comprises: carry out loading policy unit 401, obtain user data cell 402, and user data dump unit 403 and user data delete cells 404,
Carry out to load policy unit 401, call the loading strategy that is used to determine treat the user of unloading physical database, obtain treating the user ID of unloading physical database;
Obtain user data cell 402,, obtain the user's data for the treatment of the unloading physical database from memory database according to user ID;
User data dump unit 403 deposits the user data that is obtained in physical database;
User data delete cells 404, the described user data in the deletion memory database.
Wherein, for the technical scheme that makes the embodiment of the invention four clearer, the annexation of Managed Data Network meta structure and memory database, physical database has been shown among Fig. 4, but memory database and physical database are not positioned on the data management network element, are and data management network element physical entity independently.
Obtaining between user data cell 402 and the user data dump unit 403, this network element also comprises:
First converting unit 407 converts the user data that is obtained to the SQL field store form; User data dump unit 403 will store physical database into SQL field form storage user data.
First carries out charging policy unit 405, according to the user data that is obtained, calls charging policy, obtains being used for user data is carried out the control information that scheduled transaction is handled; Control information memory cell 406 deposits described control information in physical database.
This network element also comprises:
Customer location record cell 408, behind physical database, the described storage of subscriber data of record expression is in the user storage positional information of physical database in storage of subscriber data;
Second converting unit 411 will convert the data format that memory database is supported from the user data that described physical database obtains to;
Second carries out charging policy unit 413, is suction parameter with the control information, calls charging policy, replenishes and carries out storage of subscriber data unenforced scheduled transaction during physical database;
Authenticating unit 414 is carried out authentication according to user data to this user;
User profile processing unit 415 is after the subscription authentication warp, to operations such as the user data in the memory database charge.
Consult Fig. 5, the embodiment of the invention five provides a kind of network system, and this network system comprises: data management network element, memory database and physical database.
Data management network element calls the loading strategy that is used to determine treat the user of unloading physical database, obtains treating the user ID of unloading physical database; According to this user ID, obtain the user's data for the treatment of the unloading physical database from memory database; Deposit the user data that is obtained in physical database, and this user data in the deletion memory database; The message of the request user data of user ID is carried in reception, according to user ID, obtains user data from physical database, and converts the data format that memory database is supported to, is loaded into memory database.
This data management network element also is used for according to the user data that is obtained, calling charging policy after obtaining the user's data for the treatment of the unloading physical database from memory database, obtains being used for user data is carried out the control information that scheduled transaction is handled; And in the message that is receiving the request user data, described user data is loaded into after the memory database, be suction parameter with this control information, call charging policy, replenish and carry out storage of subscriber data unenforced scheduled transaction during physical database.
As seen from the above analysis, the embodiment of the invention has following beneficial effect:
The embodiment of the invention loads strategy by calling, obtain treating the user of unloading physical database, these treat that the user of unloading physical database can be the user that non-excited users or statistics talk times are less than predetermined value, these user's data are not often used, so these user's data are taken out from memory database dump to physical database, and this user data in the deletion memory database, to save the space of memory database.
More than a kind of method, data management network element and network system of saving memory headroom provided by the present invention is described in detail, for one of ordinary skill in the art, thought according to the embodiment of the invention, part in specific embodiments and applications all can change, in sum, this description should not be construed as limitation of the present invention.
Claims (15)
1, a kind of method of saving memory headroom is characterized in that, comprising:
Call the loading strategy that is used to determine treat the user of unloading physical database, obtain treating the user ID of unloading physical database;
According to described user ID, obtain the described user's data for the treatment of the unloading physical database from memory database, deposit the user data that is obtained in physical database;
Delete the described user data in the described memory database.
2, method according to claim 1 is characterized in that,
Before the user data that will be obtained deposited physical database in, this method also comprised:
Convert described user data to form with SQL SQL field store;
Depositing the user data that is obtained in physical database is specially:
Deposit described physical database with described in SQL field form storage user data.
3, method according to claim 1 and 2 is characterized in that,
After the user data that will be obtained deposited physical database in, this method also comprised:
Receive the message of request user data, carry user ID in the message of described request user data;
According to described user ID, obtain described user data from described physical database, and convert the data format that memory database is supported to, be loaded into memory database.
4, method according to claim 3 is characterized in that,
Described deposit the user data that is obtained in physical database after, this method also comprises:
Record expression storage of subscriber data is in the user storage positional information of physical database;
According to described user ID, obtain described user data from described physical database and be specially:
According to described user ID, obtain described user storage positional information, to know described storage of subscriber data,, obtain described user data from described physical database again according to described user ID at physical database.
5, method according to claim 3 is characterized in that,
This method also comprises:
To be used for that user data is carried out the control information that scheduled transaction handles is suction parameter, calls charging policy, and additional execution has been loaded into storage of subscriber data unenforced scheduled transaction during physical database of memory database.
6, method according to claim 5 is characterized in that,
Obtain the described user's data for the treatment of the unloading physical database from memory database after, this method also comprises:
According to the user data that is obtained, call charging policy, obtain the described control information that is used for described user data is carried out the scheduled transaction processing.
7, a kind of data management network element is characterized in that, comprising: carry out loading policy unit, obtain user data cell, and the user data dump unit, the user data delete cells,
Described execution loads policy unit, is used to call the loading strategy that is used to determine treat the user of unloading physical database, obtains treating the user ID of unloading physical database;
The described user data cell that obtains is used for according to described user ID, obtains the described user's data for the treatment of the unloading physical database from memory database;
Described user data dump unit, the user data that is used for being obtained deposits physical database in;
Described user data delete cells is used for deleting the described user data of described memory database.
8, network element according to claim 7 is characterized in that,
Obtain between user data cell and the described user data dump unit described, this network element also comprises:
First converting unit, the user data that is used for being obtained converts the form with the SQL field store to;
Described user data dump unit is used for and will stores physical database into SQL field form storage user data.
9, according to claim 7 or 8 described network elements, it is characterized in that,
This network element also comprises:
The message sink unit is used to receive the message of asking user data, carries user ID in the message of described request user data;
The data access unit is used for according to described user ID, obtains the user profile that comprises described user data from described physical database;
Second converting unit, the described user data that is used for obtaining from described physical database convert the data format that memory database is supported to;
Loading unit is used for the user data after the format conversion is loaded into memory database.
10, network element according to claim 9 is characterized in that,
This network element also comprises:
The customer location record cell is used in described storage of subscriber data behind physical database, and the described storage of subscriber data of record expression is in the user storage positional information of physical database;
Described data access unit, be used for according to described user ID, obtain described user storage positional information, to know that described storage of subscriber data is at physical database, according to described user ID, obtain the described user profile that comprises user data again from described physical database.
11, network element according to claim 9 is characterized in that,
Obtain between user data cell and the user data dump unit described, this network element also comprises:
First carries out the charging policy unit, is used for calling charging policy according to the user data that is obtained, and obtains being used for described user data is carried out the control information that scheduled transaction is handled;
The control information memory cell is used for depositing described control information in physical database.
12, network element according to claim 11 is characterized in that,
Described user profile also comprises: described control information;
This network element also comprises:
Second carries out the charging policy unit, and being used for described control information is suction parameter, calls charging policy, and additional execution has been loaded into storage of subscriber data unenforced scheduled transaction during physical database of memory database.
13, a kind of network system is characterized in that, comprising: data management network element, and memory database, physical database,
Described data management network element is used to call the loading strategy that is used to determine treat the user of unloading physical database, obtains treating the user ID of unloading physical database; According to described user ID, obtain the described user's data for the treatment of the unloading physical database from memory database; Deposit the user data that is obtained in physical database, and delete the described user data in the described memory database.
14, network system according to claim 13 is characterized in that,
Described data management network element also is used to receive the message of asking user data, carries user ID in the message of described request user data; According to described user ID, obtain described user data from described physical database, and convert the data format that memory database is supported to, be loaded into described memory database.
15, network system according to claim 14 is characterized in that,
Described data management network element, also be used for obtain the described user's data for the treatment of the unloading physical database from described memory database after, according to the user data that is obtained, call charging policy, obtain being used for described user data is carried out the control information that scheduled transaction is handled; And in the message that receives the request user data, described user data is loaded into after the described memory database, with described control information is suction parameter, call charging policy, additional execution has been loaded into described storage of subscriber data unenforced scheduled transaction during physical database of memory database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200710163368XA CN101414917B (en) | 2007-10-19 | 2007-10-19 | Method for saving internal memory space, data management network element and network system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200710163368XA CN101414917B (en) | 2007-10-19 | 2007-10-19 | Method for saving internal memory space, data management network element and network system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101414917A true CN101414917A (en) | 2009-04-22 |
| CN101414917B CN101414917B (en) | 2011-03-16 |
Family
ID=40595250
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200710163368XA Active CN101414917B (en) | 2007-10-19 | 2007-10-19 | Method for saving internal memory space, data management network element and network system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101414917B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761248A (en) * | 2013-12-23 | 2014-04-30 | 远光软件股份有限公司 | Method and system for querying data through main memory database |
| CN105049263A (en) * | 2015-08-24 | 2015-11-11 | 浪潮(北京)电子信息产业有限公司 | Data processing method and data processing system |
| CN105049264A (en) * | 2015-08-24 | 2015-11-11 | 浪潮(北京)电子信息产业有限公司 | Data processing method and server side |
| CN105162560A (en) * | 2015-08-24 | 2015-12-16 | 浪潮(北京)电子信息产业有限公司 | Data processing method and system |
| CN105159796A (en) * | 2015-08-24 | 2015-12-16 | 浪潮(北京)电子信息产业有限公司 | Data processing method and server end |
| US10938577B2 (en) | 2017-05-22 | 2021-03-02 | Advanced New Technologies Co., Ltd. | Blockchain service acceptance and consensus method and devices |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1428970A (en) * | 2001-12-26 | 2003-07-09 | 深圳市中兴通讯股份有限公司上海第二研究所 | Dynamic management method of great number object and its implement equipment |
| CN100365986C (en) * | 2003-12-17 | 2008-01-30 | 华为技术有限公司 | Method for saving BGP routing table memory consumption |
| CN101043695A (en) * | 2006-03-23 | 2007-09-26 | 上海宇梦通信科技有限公司 | Method for storing and maintaining user equipment information in mobile communication system |
-
2007
- 2007-10-19 CN CN200710163368XA patent/CN101414917B/en active Active
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761248A (en) * | 2013-12-23 | 2014-04-30 | 远光软件股份有限公司 | Method and system for querying data through main memory database |
| CN105049263A (en) * | 2015-08-24 | 2015-11-11 | 浪潮(北京)电子信息产业有限公司 | Data processing method and data processing system |
| CN105049264A (en) * | 2015-08-24 | 2015-11-11 | 浪潮(北京)电子信息产业有限公司 | Data processing method and server side |
| CN105162560A (en) * | 2015-08-24 | 2015-12-16 | 浪潮(北京)电子信息产业有限公司 | Data processing method and system |
| CN105159796A (en) * | 2015-08-24 | 2015-12-16 | 浪潮(北京)电子信息产业有限公司 | Data processing method and server end |
| US10938577B2 (en) | 2017-05-22 | 2021-03-02 | Advanced New Technologies Co., Ltd. | Blockchain service acceptance and consensus method and devices |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101414917B (en) | 2011-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101414917B (en) | Method for saving internal memory space, data management network element and network system | |
| CN102542071B (en) | Distributed data processing system and method | |
| CN111367984B (en) | Method and system for loading high-timeliness data into data lake | |
| US6396913B1 (en) | System and method for processing call detail records | |
| CN103003815B (en) | Shared data collections | |
| CN105302840B (en) | A kind of buffer memory management method and equipment | |
| US20130179476A1 (en) | Scalable billing usage data storage | |
| CN101556678A (en) | Processing method of batch processing services, system and service processing control equipment | |
| JP2009504030A (en) | Revenue management system and method | |
| CN105589881B (en) | Data processing method and device | |
| CN105045897B (en) | Support the transaction processing system and method for data-base capacity-enlarging | |
| CN110445828A (en) | A kind of data distribution formula processing method and its relevant device based on Redis | |
| CN102056120A (en) | Method and device for sharing communication resources | |
| CN106453500A (en) | Cache generation and control method, cache server and interface server | |
| CN102243597B (en) | Method and device for controlling and managing database connections | |
| CN102243655B (en) | Method and device for managing database connections | |
| CN102243653B (en) | Method and device for managing database connections | |
| CN105975614A (en) | Cluster configuration device and data updating method and device | |
| CN101729929A (en) | System for accessing mass data with intelligent network business libraries, device and method | |
| CN102243654B (en) | Method and device for controlling and managing database connections | |
| CN103475681A (en) | System and method for realizing intelligent services | |
| US11533588B2 (en) | Methods and systems for provisioning rate plan features in a wireless communication network | |
| CN110716948B (en) | Double-lock control method and medium based on data periodic processing | |
| CN114003203A (en) | Method, device and equipment for maintaining activity counting variable and readable medium | |
| CN102243651B (en) | Database connection control management method and device |
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 | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20201204 Address after: Unit 2414-2416, main building, no.371, Wushan Road, Tianhe District, Guangzhou City, Guangdong Province Patentee after: GUANGDONG GAOHANG INTELLECTUAL PROPERTY OPERATION Co.,Ltd. Address before: 518129 Bantian HUAWEI headquarters office building, Longgang District, Guangdong, Shenzhen Patentee before: HUAWEI TECHNOLOGIES Co.,Ltd. Effective date of registration: 20201204 Address after: Xinghua City, Jiangsu province Taizhou city 225722 Zhang Guo Zhen Luo Yao Industrial Zone Patentee after: TAIZHOU XINLONGXIANG METAL PRODUCT Co.,Ltd. Address before: Unit 2414-2416, main building, no.371, Wushan Road, Tianhe District, Guangzhou City, Guangdong Province Patentee before: GUANGDONG GAOHANG INTELLECTUAL PROPERTY OPERATION Co.,Ltd. |
|
| TR01 | Transfer of patent right |