CN105718483A - Method and apparatus for data access of SPR (Subscription Profile Repository) - Google Patents
Method and apparatus for data access of SPR (Subscription Profile Repository) Download PDFInfo
- Publication number
- CN105718483A CN105718483A CN201410733623.XA CN201410733623A CN105718483A CN 105718483 A CN105718483 A CN 105718483A CN 201410733623 A CN201410733623 A CN 201410733623A CN 105718483 A CN105718483 A CN 105718483A
- Authority
- CN
- China
- Prior art keywords
- user
- data
- newly requested
- record
- preset instructions
- 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
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W4/00—Services specially adapted for wireless communication networks; Facilities therefor
- H04W4/24—Accounting or billing
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and an apparatus for data access of an SPR (Subscription Profile Repository), which are applied to an SPR system. The method comprises the steps of: receiving a user data updating request sent by a PCRF (Policy and Charging Rules Function); according to the user data updating request, constructing a user database table updating request; and according to the user database table updating request, executing an updating operation on a user database table. According to the method provided by the invention, when the user data saving flow is processed, the user database table updating request is directly constructed according to the currently received user data updating request sent by the PCRF, and the updating operation on the user database table is executed, so that difference comparison between new and old data is omitted, computation resource consumption of the system is reduced, data updating performance is improved, and a utilization rate of equipment and enterprise competitiveness of an operator are improved.
Description
Technical field
The present invention relates to communication technical field, particularly relate to method and the device of a kind of user-subscribed database SPR data access.
Background technology
In current mobile communications network, user-subscribed database (SPR, SubscriptionProfileRepository) it is strategy and charging control (PCC, PolicyandChargingControl) the user data memory element in system, by service provider (SP, ServiceProvider) interface and policy control and charging regulation function entity (PCRF, PolicyandChargingRulesFunction) network element interacts, and provides the user data read-write operation for decision-making for PCRF.
Wherein, the data such as user produces in BlueDrama flow, note, multidate information, it is necessary to be saved in time in SPR, for the strategic decision-making correctness of BlueDrama next time.The dynamic data that the session of this certain customers produces, along with becoming increasingly abundant of carrying out of carrier data business and various and constantly increase.
In current SPR system, common user data preserves flow process, all can first carry out the reading verification operation of user data then the difference of relatively more original legacy data preserved and the current new data updated, and the renewal being finally completed user data preserves.Namely the Service Processing Module of SPR and data memory module need mutual twice, and consume the calculating resource of system, there is serious degraded performance problem.
Under the prospect of mobile communication data business great outburst, original SPR system preserves the mode of operation of user data cannot meet growing performance requirement, operator requires over equipment dilatation could tackle business increased requirement, and the pressure of operation cost incrementally increases.
Summary of the invention
In order to save calculating resource consumption during SPR system data access, improve data more new capability, embodiments provide method and the device of a kind of user-subscribed database SPR data access.
In order to solve above-mentioned technical problem, the embodiment of the present invention adopts the following technical scheme that
An aspect according to the embodiment of the present invention, it is provided that a kind of method of user-subscribed database SPR data access, is applied to a SPR system, and described method includes: receive the "Policy and Charging Rules Function entity PCRF user data update sent request；Asking according to described user data update, structuring user's database table is more newly requested；More newly requested according to described customer data base table, perform the renewal operation of customer data base table.
Alternatively, more newly requested according to described customer data base table, after performing the step updating operation of customer data base table, described method also includes: the renewal operating result according to customer data base table, returns user data update response to described PCRF.
Alternatively, the request of described user data update includes: user's dynamic data is more newly requested asks with user offline.
Alternatively, described ask according to described user data update, structuring user's database table is more newly requested to be included: if the request of described user data update is more newly requested for user's dynamic data, and described user's dynamic data more newly requested in data content be data to be modified, then use the first preset instructions structuring user's database table more newly requested, when wherein said first preset instructions is for finding the record with described data match to be modified in the local database, it is updated record operation, carries out when not finding coupling record increasing record operation.
Alternatively, the described data content asked according to described user data update, structuring user's database table is more newly requested also to be included: if the request of described user data update is more newly requested for user's dynamic data, and described user's dynamic data more newly requested in data content be data to be deleted, then use the second preset instructions structuring user's database table more newly requested, when wherein said second preset instructions is for finding the record with described data match to be deleted in the local database, carry out deletion record operation, do not process when not finding coupling record.
Alternatively, described ask according to described user data update, structuring user's database table is more newly requested also to be included: if the request of described user data update is asked for user offline, then use the 3rd preset instructions structuring user's database table more newly requested, wherein said 3rd preset instructions PCRF end office (EO) information for connecting according to active user in the local database, carry out the coupling of data-base recording, and remove this end office's information when finding coupling record.
Another aspect according to the embodiment of the present invention, additionally provide the device of a kind of user-subscribed database SPR data access, being applied to a SPR system, described device includes: receiver module, for receiving the "Policy and Charging Rules Function entity PCRF user data update sent request；Constructing module, for asking according to described user data update, structuring user's database table is more newly requested；Perform module, for more newly requested according to described customer data base table, perform the renewal operation of customer data base table.
Alternatively, described device also includes: return module, for the renewal operating result according to customer data base table, returns user data update response to described PCRF.
Alternatively, the request of described user data update includes: user's dynamic data is more newly requested asks with user offline.
Alternatively, described constructing module includes: the first structural unit, if it is more newly requested for user's dynamic data for the request of described user data update, and described user's dynamic data more newly requested in data content be data to be modified, then use the first preset instructions structuring user's database table more newly requested, when wherein said first preset instructions is for finding the record with described data match to be modified in the local database, it is updated record operation, carries out when not finding coupling record increasing record operation.
Alternatively, described constructing module also includes: the second structural unit, if it is more newly requested for user's dynamic data for the request of described user data update, and described user's dynamic data more newly requested in data content be data to be deleted, then use the second preset instructions structuring user's database table more newly requested, when wherein said second preset instructions is for finding the record with described data match to be deleted in the local database, carry out deletion record operation, do not process when not finding coupling record.
Alternatively, described constructing module also includes: the 3rd structural unit, if asking for user offline for the request of described user data update, then use the 3rd preset instructions structuring user's database table more newly requested, wherein said 3rd preset instructions PCRF end office (EO) information for connecting according to active user in the local database, carry out the coupling of data-base recording, and remove this end office's information when finding coupling record.
The beneficial effect of the embodiment of the present invention: the method for the embodiment of the present invention is when processes user data preserves flow process, ask according to the currently received PCRF user data update sent, direct structuring user's database table is more newly requested, perform the renewal operation of customer data base table, thus eliminating the comparison in difference of new legacy data, decrease the calculating resource consumption of system, improve data more new capability, and improve the utilization rate of equipment and the enterprise competitiveness of operator.
Accompanying drawing explanation
Fig. 1 is the flow chart of the method for the user-subscribed database SPR data access of the embodiment of the present invention；
Fig. 2 is the application drawing of the method for the user-subscribed database SPR data access of the embodiment of the present invention；
Fig. 3 is the device of the user-subscribed database SPR data access of the embodiment of the present invention.
Detailed description of the invention
For making the technical problem to be solved in the present invention, technical scheme and advantage clearly, it is described in detail below in conjunction with the accompanying drawings and the specific embodiments.
A kind of method that The embodiment provides user-subscribed database SPR data access, the method is applied to a SPR system, described SPR system is the user data memory element in PCC system, and wherein this SPR system includes: SPR Service Processing Module and data memory module.
Fig. 1 illustrates the flow process of described method, and the method is applied particularly to the SPR Service Processing Module of SPR system.With reference to Fig. 1, the method comprises the following steps:
Step 101, receives the "Policy and Charging Rules Function entity PCRF user data update sent request.
Step 102, asks according to described user data update, and structuring user's database table is more newly requested.
Specifically, the request of this user data update may include that user's dynamic data is more newly requested and user offline request.
Step 103, more newly requested according to described customer data base table, perform the renewal operation of customer data base table.In an embodiment of the present invention, the SPR Service Processing Module of SPR system is when processes user data preserves flow process, ask according to the currently received PCRF user data update sent, direct structuring user's database table updates request to the SPR data memory module of SPR system, so that SPR data memory module performs the renewal operation of customer data base table, thus eliminating the comparison in difference of new legacy data, decrease the calculating resource consumption of system, reduce Message Processing time delay, improve data more new capability, and improve the utilization rate of equipment and the enterprise competitiveness of operator.
Further, after the step 103 of the above embodiment of the present invention, the method for the present embodiment also includes: the renewal operating result according to customer data base table, returns user data update response to described PCRF.Specifically, after SPR memory module receives the instruction of SPR Service Processing Module, perform the renewal operation of customer data base table, and after the renewal of customer data base table has operated, returning customer data base table to SPR Service Processing Module and update response, SPR Service Processing Module returns user data update response by service provider SP interface to PCRF further.
Further, the step 102 in the above embodiment of the present invention specifically includes following three kinds of makes:
Mode one: if the request of described user data update is more newly requested for user's dynamic data, and described user's dynamic data more newly requested in data content be data to be modified, then use the first preset instructions structuring user's database table more newly requested, when wherein said first preset instructions is for finding the record with described data match to be modified in the local database, it is updated record operation, carries out when not finding coupling record increasing record operation.
Mode two: if the request of described user data update is more newly requested for user's dynamic data, and described user's dynamic data more newly requested in data content be data to be deleted, then use the second preset instructions structuring user's database table more newly requested, when wherein said second preset instructions is for finding the record with described data match to be deleted in the local database, carry out deletion record operation, do not process when not finding coupling record.
Mode three: if the request of described user data update is asked for user offline, then use the 3rd preset instructions structuring user's database table more newly requested, wherein said 3rd preset instructions PCRF end office (EO) information for connecting according to active user in the local database, carry out the coupling of data-base recording, and remove this end office's information when finding coupling record.
For the method better setting forth the embodiment of the present invention, Fig. 2 illustrates the application drawing of the method for the user-subscribed database SPR data access of the embodiment of the present invention, as in figure 2 it is shown, this application comprises the steps:
Step 201, PCRF sends user data update and asks to SPR Service Processing Module.Specifically, the request of this user data update may include that user's dynamic data is more newly requested and user offline request.
Step 202, SPR Service Processing Module is asked according to user data update, and structuring user's database table is more newly requested.Wherein, SPR Service Processing Module can according to the particular content of user data update request, operation according to the first preset instructions, the second preset instructions and the 3rd preset instructions structuring user's database table respectively, wherein the first preset instructions, the second preset instructions and the 3rd preset instructions, aforementioned already mentioned above and explain, do not repeating at this.
Step 203, it is more newly requested that SPR Service Processing Module sends customer data base table to SPR data memory module.
Step 204, SPR data memory module is more newly requested according to the database table received, and updates customer data base table.
Step 205, SPR data memory module returns the renewal of customer data base table and responds to SPR Service Processing Module.
Step 206, the SPR Service Processing Module renewal operating result according to customer data base table, return user data update response to described PCRF.
In order to better implement above-mentioned purpose, as it is shown on figure 3, embodiments provide the device of a kind of user-subscribed database SPR data access, this device is applied to the SPR Service Processing Module of aforementioned SPR system.This device 30 includes: receiver module 31, constructing module 32 and execution module 33, wherein,
Described receiver module 31, for receiving the "Policy and Charging Rules Function entity PCRF user data update sent request.
Described constructing module 32, for asking according to described user data update, structuring user's database table is more newly requested.
Specifically, the request of described user data update may include that user's dynamic data is more newly requested and user offline request.
Described execution module 33, for more newly requested according to described customer data base table, performs the renewal operation of customer data base table.
Further, described device 30 also includes: return module, for the renewal operating result according to customer data base table, returns user data update response to described PCRF.
Specifically, described constructing module 32 includes: the first structural unit, the second structural unit and the 3rd structural unit, wherein,
Described first structural unit, if it is more newly requested for user's dynamic data for the request of described user data update, and described user's dynamic data more newly requested in data content be data to be modified, then use the first preset instructions structuring user's database table more newly requested, when wherein said first preset instructions is for finding the record with described data match to be modified in the local database, it is updated record operation, carries out when not finding coupling record increasing record operation.
Described second structural unit, if it is more newly requested for user's dynamic data for the request of described user data update, and described user's dynamic data more newly requested in data content be data to be deleted, then use the second preset instructions structuring user's database table more newly requested, when wherein said second preset instructions is for finding the record with described data match to be deleted in the local database, carry out deletion record operation, do not process when not finding coupling record.
Described 3rd structural unit, if asking for user offline for the request of described user data update, then use the 3rd preset instructions structuring user's database table more newly requested, wherein said 3rd preset instructions PCRF end office (EO) information for connecting according to active user in the local database, carry out the coupling of data-base recording, and remove this end office's information when finding coupling record.
The device of the embodiment of the present invention is when processes user data preserves flow process, ask according to the currently received PCRF user data update sent, direct structuring user's database table updates request to the SPR data memory module of SPR system, so that SPR data memory module performs the renewal operation of customer data base table, thus eliminating the comparison in difference of new legacy data, decrease the calculating resource consumption of system, reduce Message Processing time delay, improve data more new capability, and improve the utilization rate of equipment and the enterprise competitiveness of operator.
The above is the preferred embodiment of the present invention; it should be pointed out that, for those skilled in the art, under the premise without departing from principle of the present invention; can also making some improvements and modifications, these improvements and modifications also should be regarded as protection scope of the present invention.
Claims (12)
1. a method for user-subscribed database SPR data access, is applied to a SPR system, it is characterised in that described method includes:
Receive the "Policy and Charging Rules Function entity PCRF user data update sent request；
Asking according to described user data update, structuring user's database table is more newly requested；
More newly requested according to described customer data base table, perform the renewal operation of customer data base table.
2. method according to claim 1, it is characterised in that described more newly requested according to described customer data base table, after performing the step updating operation of customer data base table, described method also includes:
Renewal operating result according to customer data base table, returns user data update response to described PCRF.
3. method according to claim 1, it is characterised in that the request of described user data update includes: user's dynamic data is more newly requested asks with user offline.
4. method according to claim 3, it is characterised in that described ask according to described user data update, structuring user's database table is more newly requested to be included:
If the request of described user data update is more newly requested for user's dynamic data, and described user's dynamic data more newly requested in data content be data to be modified, then use the first preset instructions structuring user's database table more newly requested, when wherein said first preset instructions is for finding the record with described data match to be modified in the local database, it is updated record operation, carries out when not finding coupling record increasing record operation.
5. method according to claim 4, it is characterised in that the described data content asked according to described user data update, structuring user's database table is more newly requested also to be included:
If the request of described user data update is more newly requested for user's dynamic data, and described user's dynamic data more newly requested in data content be data to be deleted, then use the second preset instructions structuring user's database table more newly requested, when wherein said second preset instructions is for finding the record with described data match to be deleted in the local database, carry out deletion record operation, do not process when not finding coupling record.
6. method according to claim 5, it is characterised in that described ask according to described user data update, structuring user's database table is more newly requested also to be included:
If the request of described user data update is asked for user offline, then use the 3rd preset instructions structuring user's database table more newly requested, wherein said 3rd preset instructions PCRF end office (EO) information for connecting according to active user in the local database, carry out the coupling of data-base recording, and remove this end office's information when finding coupling record.
7. a device for user-subscribed database SPR data access, is applied to a SPR system, it is characterised in that described device includes:
Receiver module, for receiving the "Policy and Charging Rules Function entity PCRF user data update sent request；
Constructing module, for asking according to described user data update, structuring user's database table is more newly requested；
Perform module, for more newly requested according to described customer data base table, perform the renewal operation of customer data base table.
8. device according to claim 7, it is characterised in that described device also includes:
Return module, for the renewal operating result according to customer data base table, return user data update response to described PCRF.
9. device according to claim 7, it is characterised in that the request of described user data update includes: user's dynamic data is more newly requested asks with user offline.
10. device according to claim 9, it is characterised in that described constructing module includes:
First structural unit, if it is more newly requested for user's dynamic data for the request of described user data update, and described user's dynamic data more newly requested in data content be data to be modified, then use the first preset instructions structuring user's database table more newly requested, when wherein said first preset instructions is for finding the record with described data match to be modified in the local database, it is updated record operation, carries out when not finding coupling record increasing record operation.
11. device according to claim 10, it is characterised in that described constructing module also includes:
Second structural unit, if it is more newly requested for user's dynamic data for the request of described user data update, and described user's dynamic data more newly requested in data content be data to be deleted, then use the second preset instructions structuring user's database table more newly requested, when wherein said second preset instructions is for finding the record with described data match to be deleted in the local database, carry out deletion record operation, do not process when not finding coupling record.
12. device according to claim 11, it is characterised in that described constructing module also includes:
3rd structural unit, if asking for user offline for the request of described user data update, then use the 3rd preset instructions structuring user's database table more newly requested, wherein said 3rd preset instructions PCRF end office (EO) information for connecting according to active user in the local database, carry out the coupling of data-base recording, and remove this end office's information when finding coupling record.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410733623.XA CN105718483B (en) | 2014-12-04 | 2014-12-04 | Method and device for SPR data access of user subscription database |
| PCT/CN2015/078487 WO2016086597A1 (en) | 2014-12-04 | 2015-05-07 | Subscription profile repository (spr) data access method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410733623.XA CN105718483B (en) | 2014-12-04 | 2014-12-04 | Method and device for SPR data access of user subscription database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105718483A true CN105718483A (en) | 2016-06-29 |
| CN105718483B CN105718483B (en) | 2020-10-16 |
Family
ID=56090917
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410733623.XA Active CN105718483B (en) | 2014-12-04 | 2014-12-04 | Method and device for SPR data access of user subscription database |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN105718483B (en) |
| WO (1) | WO2016086597A1 (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112241408A (en) * | 2020-09-30 | 2021-01-19 | 航天信息股份有限公司 | Temporary table-based invoice data batch storage method |
| CN114003661A (en) * | 2021-11-12 | 2022-02-01 | 招商局金融科技有限公司 | Offline data entry method and device, electronic equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1968139A (en) * | 2006-06-15 | 2007-05-23 | 华为技术有限公司 | Subscriber contract information processing method and apparatus in strategy and charging control |
| CN101730047A (en) * | 2009-06-26 | 2010-06-09 | 中兴通讯股份有限公司 | Method and system for formulating strategy |
| CN101931930A (en) * | 2009-06-26 | 2010-12-29 | 中兴通讯股份有限公司 | Method and system for updating service information in subscription profile repository |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101546403A (en) * | 2008-03-27 | 2009-09-30 | 天津德智科技有限公司 | Online service system and method for providing online service |
| IN2014KN01045A (en) * | 2011-10-26 | 2015-10-09 | Ericsson Telefon Ab L M | |
| CN102547648B (en) * | 2012-01-13 | 2014-08-27 | 华中科技大学 | Intelligent pipeline flow control method based on user behavior |
-
2014
- 2014-12-04 CN CN201410733623.XA patent/CN105718483B/en active Active
-
2015
- 2015-05-07 WO PCT/CN2015/078487 patent/WO2016086597A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1968139A (en) * | 2006-06-15 | 2007-05-23 | 华为技术有限公司 | Subscriber contract information processing method and apparatus in strategy and charging control |
| CN100536401C (en) * | 2006-06-15 | 2009-09-02 | 华为技术有限公司 | Subscriber contract information processing method and apparatus in strategy and charging control |
| CN101730047A (en) * | 2009-06-26 | 2010-06-09 | 中兴通讯股份有限公司 | Method and system for formulating strategy |
| CN101931930A (en) * | 2009-06-26 | 2010-12-29 | 中兴通讯股份有限公司 | Method and system for updating service information in subscription profile repository |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112241408A (en) * | 2020-09-30 | 2021-01-19 | 航天信息股份有限公司 | Temporary table-based invoice data batch storage method |
| CN112241408B (en) * | 2020-09-30 | 2024-06-04 | 航天信息股份有限公司 | Invoice data batch warehousing method based on temporary table |
| CN114003661A (en) * | 2021-11-12 | 2022-02-01 | 招商局金融科技有限公司 | Offline data entry method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105718483B (en) | 2020-10-16 |
| WO2016086597A1 (en) | 2016-06-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP2878139B1 (en) | Methods and apparatuses for facilitating utilization of cloud services | |
| US11026236B2 (en) | Facilitation of efficient software downloads for vehicles | |
| CN102821150B (en) | Based on application management method and the Cloud Server of cloud service | |
| CN101316256A (en) | Data updating method | |
| CN104113576A (en) | Method and device for updating client | |
| CN103874139A (en) | Idle-state discontinuous reception cycle negotiation method, system and device | |
| US11019565B2 (en) | Automated power-aware green radio resource management (RRM) | |
| WO2020119716A1 (en) | Message processing method, related apparatus, and system | |
| US9952888B2 (en) | Method and system to dynamically instantiate virtual repository for any services | |
| CN103987030B (en) | A kind of method for realizing the number of taking upgrading networking, apparatus and system | |
| CN110351270A (en) | A kind of method and system improving concurrent data treatment effeciency | |
| CN109412826B (en) | SDON architecture model optimization method, device, system and computer readable storage medium | |
| CN115735193A (en) | Method and system for managing the lifecycle of an edge configuration server | |
| CN105718483A (en) | Method and apparatus for data access of SPR (Subscription Profile Repository) | |
| CN103944805A (en) | Information updating method and system based on Wechat platform | |
| CN106558126A (en) | A kind of gate inhibition's key code management method and system | |
| CN106302390A (en) | A kind of method limited based on NGINX access frequency and system | |
| CN112583873B (en) | Service discovery method, device and functional network element | |
| US10991017B2 (en) | Methods and systems for provisioning of customer product | |
| CN109429266A (en) | Control method and edge arithmetic device for network communication system | |
| CN103533452A (en) | Transmission control method and device for streaming media | |
| CN114742235A (en) | Federal learning method, data analysis model training method and device, and storage medium | |
| US20180041607A1 (en) | Facilitating dynamic establishment of virtual enterprise service platforms and on-demand service provisioning | |
| CN115715389A (en) | Method and apparatus for edge-enabled server lifecycle management | |
| CN102223610A (en) | Method for realizing data exchange among mobile devices and mobile device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200909 Address after: Yuhuatai District of Nanjing City, Jiangsu province 210012 Bauhinia Road No. 68 Applicant after: Nanjing Zhongxing New Software Co.,Ltd. Address before: 518057 Nanshan District Guangdong high tech Industrial Park, South Road, science and technology, ZTE building, Ministry of Justice Applicant before: ZTE Corp. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |