WO2016086597A1 - Dispositif et procédé d'accès à des données d'un référentiel de profils d'abonnement (spr) - Google Patents

Dispositif et procédé d'accès à des données d'un référentiel de profils d'abonnement (spr) Download PDF

Info

Publication number
WO2016086597A1
WO2016086597A1 PCT/CN2015/078487 CN2015078487W WO2016086597A1 WO 2016086597 A1 WO2016086597 A1 WO 2016086597A1 CN 2015078487 W CN2015078487 W CN 2015078487W WO 2016086597 A1 WO2016086597 A1 WO 2016086597A1
Authority
WO
WIPO (PCT)
Prior art keywords
user
update request
data
database table
data update
Prior art date
Application number
PCT/CN2015/078487
Other languages
English (en)
Chinese (zh)
Inventor
许卫峰
Original Assignee
中兴通讯股份有限公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 中兴通讯股份有限公司 filed Critical 中兴通讯股份有限公司
Publication of WO2016086597A1 publication Critical patent/WO2016086597A1/fr

Links

Images

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

Definitions

  • This paper relates to the field of communication technologies, and in particular, to a method and apparatus for user subscription database SPR data access.
  • a Subscriber Profile is a user data storage unit in a Policy and Charging Control (PCC) system, and is provided through a Service Provider (SP) interface. Interact with the Policy Control and Charging Rules Function (PCRF) network element to provide the PCRF with user data read and write operations for decision making.
  • PCRF Policy Control and Charging Rules Function
  • the data such as traffic, short messages, and dynamic information generated by the user in the network session, need to be saved in the SPR in time for correctness of the policy decision of the next network session.
  • the dynamic data generated by this part of the user's session is growing with the increasing variety and variety of operators' data services.
  • the usual user data saving process first performs the read and verify operation of the user data, and then compares the difference between the previously saved old data and the currently updated new data, and finally completes the update and save of the user data. That is, the service processing module and the data storage module of the SPR need to interact twice, and consume the computing resources of the system, and there is a serious problem of low performance.
  • the operation mode of the original SPR system for storing user data cannot meet the increasing performance requirements.
  • the operator needs to expand the capacity of the device to cope with the business growth demand, and the pressure of the operation cost is gradually increased.
  • the embodiment of the invention provides a method and device for accessing the database SPR data of the user.
  • the embodiment of the present invention adopts the following technical solutions:
  • a user subscription database SPR data access comprising: receiving a user data update request sent by a policy and charging rule function entity PCRF; constructing a user database table update request according to the user data update request; The database table update request performs an update operation of the user database table.
  • the method further includes: returning a user data update response to the PCRF according to the update operation result of the user database table.
  • the user data update request includes: a user dynamic data update request and a user offline request.
  • the constructing the user database table update request according to the user data update request includes: if the user data update request is a user dynamic data update request, and the data content in the user dynamic data update request is to be
  • the modified data is configured to construct a user database table update request by using a first preset instruction, where the first preset instruction is used to perform an update recording operation when a record matching the data to be modified is found in the local database. , to increase the recording operation when no matching records are found.
  • the constructing the user database table update request according to the data content of the user data update request further includes: if the user data update request is a user dynamic data update request, and the user dynamic data update request If the data content is the data to be deleted, the second preset instruction is used to construct a user database table update request, where the second preset instruction is used to find a record matching the data to be deleted in the local database. The delete record operation is performed, and no processing is performed when no matching record is found.
  • the constructing the user database table update request according to the user data update request further includes: if the user data update request is a user offline request, constructing a user database table update request by using a third preset instruction, The third preset instruction is used to perform database record matching according to the PCRF end office information of the current user connection in the local database, and clear the end office information when the matching record is found.
  • a device for accessing a database SPR data access which is applied to an SPR system, and the device includes: a receiving module, configured to receive a policy and a charging rule function entity PCRF to send User data update request; construct module, set To construct a user database table update request according to the user data update request, the execution module is configured to perform an update operation of the user database table according to the user database table update request.
  • the apparatus further includes: a returning module, configured to return a user data update response to the PCRF according to an update operation result of the user database table.
  • a returning module configured to return a user data update response to the PCRF according to an update operation result of the user database table.
  • the user data update request includes: a user dynamic data update request and a user offline request.
  • the constructing module includes: a first constructing unit, configured to: if the user data update request is a user dynamic data update request, and the data content in the user dynamic data update request is data to be modified, Forming a user database table update request by using a first preset instruction, where the first preset instruction is used to perform an update record operation when a record matching the data to be modified is found in the local database, and no match is found. Increase the recording operation when recording.
  • a first constructing unit configured to: if the user data update request is a user dynamic data update request, and the data content in the user dynamic data update request is data to be modified, Forming a user database table update request by using a first preset instruction, where the first preset instruction is used to perform an update record operation when a record matching the data to be modified is found in the local database, and no match is found. Increase the recording operation when recording.
  • the constructing module further includes: a second constructing unit, configured to: if the user data update request is a user dynamic data update request, and the data content in the user dynamic data update request is data to be deleted, And the second preset instruction is used to construct a user database table update request, where the second preset instruction is used to delete the record operation when the record matching the data to be deleted is found in the local database, and the record deletion operation is not found. No processing is done when matching records.
  • the constructing module further includes: a third constructing unit, configured to: if the user data update request is a user offline request, construct a user database table update request by using a third preset instruction, where the third The preset command is used to perform database record matching according to the PCRF end office information of the current user connection in the local database, and clear the end office information when the matching record is found.
  • a third constructing unit configured to: if the user data update request is a user offline request, construct a user database table update request by using a third preset instruction, where the third The preset command is used to perform database record matching according to the PCRF end office information of the current user connection in the local database, and clear the end office information when the matching record is found.
  • the beneficial effects of the embodiments of the present invention when processing the user data saving process, according to the user data update request sent by the currently received PCRF, the user database table update request is directly constructed, and the user database table update operation is performed. Therefore, the comparison of the difference between the old and new data is omitted, the computing resource consumption of the system is reduced, the data update performance is improved, and the utilization rate of the device and the enterprise competitiveness of the operator are improved.
  • FIG. 1 is a flowchart of a method for data subscription of a user subscription database SPR according to an embodiment of the present invention
  • FIG. 2 is an application diagram of a method for data access of a user subscription database SPR according to an embodiment of the present invention
  • FIG. 3 is a diagram of an apparatus for user subscription database SPR data access according to an embodiment of the present invention.
  • An embodiment of the present invention provides a method for user subscription database SPR data access.
  • the method is applied to an SPR system, where the SPR system is a user data storage unit in a PCC system, where the SPR system includes: an SPR service processing module. And data storage modules.
  • FIG 1 shows the flow of the method applied to the SPR service processing module of the SPR system.
  • the method includes the following steps:
  • Step 101 Receive a user data update request sent by a policy and charging rule function entity PCRF.
  • Step 102 Construct a user database table update request according to the user data update request.
  • the user data update request may include: a user dynamic data update request and a user offline request.
  • Step 103 Perform an update operation of the user database table according to the user database table update request.
  • the SPR service processing module of the SPR system when processing the user data saving process, directly constructs the user database table update request to the SPR data storage module of the SPR system according to the user data update request sent by the currently received PCRF. So that the SPR data storage module performs the update operation of the user database table, thereby omitting the difference comparison between the old and new data, reducing the computing resource consumption of the system, reducing the message processing delay, improving the data update performance, and improving the device. Utilization and the competitiveness of the operator's business.
  • the method of the embodiment further includes: returning a user data update response to the PCRF according to an update operation result of the user database table.
  • the SPR storage module performs an update operation of the user database table, and returns a user database table update response to the SPR service processing module after the update operation of the user database table is completed, and the SPR service is performed.
  • the processing module returns a user data update response to the PCRF through the service provider SP interface.
  • step 102 in the foregoing embodiment of the present invention includes the following three configurations:
  • Manner 1 If the user data update request is a user dynamic data update request, and the data content in the user dynamic data update request is data to be modified, the first preset instruction is used to construct a user database table update request, where The first preset instruction is configured to perform an update recording operation when a record matching the data to be modified is found in the local database, and when the matching record is not found, perform an increase recording operation.
  • the second preset instruction is used to construct a user database table update request, where The second preset instruction is configured to perform a delete record operation when a record matching the data to be deleted is found in the local database, and no process is performed when no match record is found.
  • Manner 3 If the user data update request is a user offline request, construct a user database table update request by using a third preset instruction, where the third preset instruction is used in the local database according to the PCRF of the current user connection. End office information, matching database records, and clearing the end office information when a matching record is found.
  • FIG. 2 shows an application diagram of a method for data access of a user subscription database SPR according to an embodiment of the present invention. As shown in FIG. 2, the application includes the following steps:
  • the PCRF sends a user data update request to the SPR service processing module.
  • the user data update request may include: a user dynamic data update request and a user offline request.
  • Step 202 The SPR service processing module constructs a user database table update request according to the user data update request.
  • the SPR service processing module may separately construct an operation of the user database table according to the first preset instruction, the second preset instruction, and the third preset instruction according to the content of the user data update request, where the first preset instruction, the second The preset instruction and the third preset instruction have been mentioned and explained in the foregoing, and are not described herein.
  • Step 203 The SPR service processing module sends a user database table update request to the SPR data storage module.
  • Step 204 The SPR data storage module updates the request according to the received database table, and updates User database table.
  • Step 205 The SPR data storage module returns a user database table update response to the SPR service processing module.
  • Step 206 The SPR service processing module returns a user data update response to the PCRF according to the update operation result of the user database table.
  • an embodiment of the present invention provides an apparatus for user subscription database SPR data access, and the apparatus is applied to the SPR service processing module of the foregoing SPR system.
  • the device 30 includes: a receiving module 31, a constructing module 32, and an executing module 33, wherein
  • the receiving module 31 is configured to receive a user data update request sent by the policy and charging rule function entity PCRF.
  • the constructing module 32 is configured to construct a user database table update request according to the user data update request.
  • the user data update request may include: a user dynamic data update request and a user offline request.
  • the execution module 33 is configured to perform an update operation of the user database table according to the user database table update request.
  • the apparatus 30 further includes: a returning module, configured to return a user data update response to the PCRF according to an update operation result of the user database table.
  • a returning module configured to return a user data update response to the PCRF according to an update operation result of the user database table.
  • the constructing module 32 includes: a first structural unit, a second structural unit, and a third structural unit, wherein
  • the first constructing unit is configured to construct a user by using a first preset instruction if the user data update request is a user dynamic data update request, and the data content in the user dynamic data update request is data to be modified. And a database table update request, wherein the first preset instruction is used to perform an update record operation when a record matching the data to be modified is found in the local database, and when the matching record is not found, the record increase operation is performed.
  • the second constructing unit is configured to construct a user by using a second preset instruction if the user data update request is a user dynamic data update request, and the data content in the user dynamic data update request is data to be deleted.
  • a database table update request wherein the second preset instruction is used in When a record matching the data to be deleted is found in the local database, the delete record operation is performed, and when no match record is found, no processing is performed.
  • the third constructing unit is configured to: if the user data update request is a user offline request, construct a user database table update request by using a third preset instruction, where the third preset instruction is used in a local database According to the PCRF end office information connected by the current user, the database record is matched, and when the matching record is found, the end office information is cleared.
  • the device of the embodiment of the present invention When processing the user data saving process, the device of the embodiment of the present invention directly constructs a user database table update request to the SPR data storage module of the SPR system according to the user data update request sent by the currently received PCRF, so that the SPR data storage module executes the user.
  • the update operation of the database table thereby omitting the difference comparison between the old and new data, reducing the computing resource consumption of the system, reducing the message processing delay, improving the data update performance, and improving the utilization rate of the device and the competitiveness of the operator.
  • all or part of the steps of the above embodiments may also be implemented by using an integrated circuit. These steps may be separately fabricated into individual integrated circuit modules, or multiple modules or steps may be fabricated into a single integrated circuit module. achieve.
  • the devices/function modules/functional units in the above embodiments may be implemented by a general-purpose computing device, which may be centralized on a single computing device or distributed over a network of multiple computing devices.
  • each device/function module/functional unit in the above embodiment When each device/function module/functional unit in the above embodiment is implemented in the form of a software function module and sold or used as a stand-alone product, it can be stored in a computer readable storage medium.
  • the above mentioned computer readable storage medium may be a read only memory, a magnetic disk or an optical disk or the like.
  • the method of the embodiment of the invention reduces the computing resource consumption of the system, improves the data update performance, and improves the utilization rate of the device and the enterprise competitiveness of the operator.

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

La présente invention concerne un dispositif et un procédé d'accès à des données d'un référentiel de profils d'abonnement (SPR), lesdits dispositif et procédé étant appliqués à un système SPR. Le procédé comprend les étapes consistant à : recevoir une demande de mise à jour des données d'un utilisateur transmise par une fonction de règles de politique et de facturation (PCRF) ; construire une demande de mise à jour de la table de la base de données de l'utilisateur en fonction de la demande de mise à jour des données de l'utilisateur ; et exécuter une opération de mise à jour de la table de la base de données de l'utilisateur en fonction de la demande de mise à jour de la table de la base de données de l'utilisateur. Lorsqu'il exécute un processus de stockage des données de l'utilisateur, le procédé construit la demande de mise à jour de la table de la base de données de l'utilisateur directement en fonction de la demande de mise à jour des données de l'utilisateur reçue actuellement et transmise par la PCRF, ce qui met fin à la nécessité de comparer les différences entre les nouvelles et les anciennes données, réduit la consommation des ressources de calcul du système, et améliore les performances de mise à jour des données, l'utilisation du dispositif et la compétitivité de l'entreprise.
PCT/CN2015/078487 2014-12-04 2015-05-07 Dispositif et procédé d'accès à des données d'un référentiel de profils d'abonnement (spr) WO2016086597A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201410733623.XA CN105718483B (zh) 2014-12-04 2014-12-04 一种用户签约数据库spr数据访问的方法及装置
CN201410733623.X 2014-12-04

Publications (1)

Publication Number Publication Date
WO2016086597A1 true WO2016086597A1 (fr) 2016-06-09

Family

ID=56090917

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2015/078487 WO2016086597A1 (fr) 2014-12-04 2015-05-07 Dispositif et procédé d'accès à des données d'un référentiel de profils d'abonnement (spr)

Country Status (2)

Country Link
CN (1) CN105718483B (fr)
WO (1) WO2016086597A1 (fr)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112241408B (zh) * 2020-09-30 2024-06-04 航天信息股份有限公司 基于临时表的发票数据批量入库方法
CN114003661A (zh) * 2021-11-12 2022-02-01 招商局金融科技有限公司 离线数据录入方法、装置、电子设备及存储介质

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101546403A (zh) * 2008-03-27 2009-09-30 天津德智科技有限公司 一种在线服务系统和一种提供在线服务的方法
CN101931930A (zh) * 2009-06-26 2010-12-29 中兴通讯股份有限公司 一种更新用户签约数据库中的业务信息的方法及系统
CN102547648A (zh) * 2012-01-13 2012-07-04 华中科技大学 基于用户行为的智能管道流量控制方法
US20130107799A1 (en) * 2011-10-26 2013-05-02 Telefonaktiebolaget L M Ericsson (Publ) Device and Method for UE Aggregate Maximum Bit Rate

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN100536401C (zh) * 2006-06-15 2009-09-02 华为技术有限公司 策略与计费控制中用户签约信息的处理方法及装置
CN101730047B (zh) * 2009-06-26 2013-08-07 中兴通讯股份有限公司 策略制定方法及系统

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101546403A (zh) * 2008-03-27 2009-09-30 天津德智科技有限公司 一种在线服务系统和一种提供在线服务的方法
CN101931930A (zh) * 2009-06-26 2010-12-29 中兴通讯股份有限公司 一种更新用户签约数据库中的业务信息的方法及系统
US20130107799A1 (en) * 2011-10-26 2013-05-02 Telefonaktiebolaget L M Ericsson (Publ) Device and Method for UE Aggregate Maximum Bit Rate
CN102547648A (zh) * 2012-01-13 2012-07-04 华中科技大学 基于用户行为的智能管道流量控制方法

Also Published As

Publication number Publication date
CN105718483B (zh) 2020-10-16
CN105718483A (zh) 2016-06-29

Similar Documents

Publication Publication Date Title
US20190068690A1 (en) Automated management of resource attributes across network-based services
CN102541990B (zh) 利用虚拟分区的数据库重新分布方法和系统
US20140379656A1 (en) System and Method for Maintaining a Cluster Setup
US7937432B2 (en) State transition management according to a workflow management policy
WO2021103403A1 (fr) Procédé et dispositif de gestion d'informations de transaction de chaîne de blocs, dispositif informatique et support de stockage
US9910881B1 (en) Maintaining versions of control plane data for a network-based service control plane
US11210277B2 (en) Distributing and processing streams over one or more networks for on-the-fly schema evolution
US10599356B2 (en) Aggregating memory to create a network addressable storage volume for storing virtual machine files
CN105677789A (zh) 一种分布式文件系统的目录容量管理方法及系统
KR20170002415A (ko) 순회 맵-리듀스 아키텍처
US9952888B2 (en) Method and system to dynamically instantiate virtual repository for any services
WO2021164194A1 (fr) Procédé de gestion de points de récompense fondé sur une chaîne de blocs et appareil associé
CN103685517A (zh) 一种基于业务类别特征的存储分级调度方法及系统
CN107357592A (zh) 一种基于状态机机制的事件处理方法及装置
CN104468759A (zh) PaaS平台中实现应用迁移的方法和装置
WO2016086597A1 (fr) Dispositif et procédé d'accès à des données d'un référentiel de profils d'abonnement (spr)
CN104410511A (zh) 一种服务器管理方法及系统
US20220138220A1 (en) Dedicated replication channels for replicating records between regions
WO2021148047A1 (fr) Procédé et système pour traiter des csi de cellule non de desserte, dispositif électronique, et support
CN101789963A (zh) 数据同步系统
CN103095833B (zh) 云服务系统更新方法和装置
US9043274B1 (en) Updating local database and central database
CN112800066A (zh) 索引管理的方法、相关设备及存储介质
WO2017088528A1 (fr) Procédé et appareil de gestion d'informations de configuration et centre de maintenance de fonctionnement ou station de base
CN106557530B (zh) 业务系统、数据修复方法及装置

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 15865126

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 15865126

Country of ref document: EP

Kind code of ref document: A1