WO2014108800A2 - Method for comparing and reconsolidating geo-redundant database - Google Patents

Method for comparing and reconsolidating geo-redundant database Download PDF

Info

Publication number
WO2014108800A2
WO2014108800A2 PCT/IB2014/000074 IB2014000074W WO2014108800A2 WO 2014108800 A2 WO2014108800 A2 WO 2014108800A2 IB 2014000074 W IB2014000074 W IB 2014000074W WO 2014108800 A2 WO2014108800 A2 WO 2014108800A2
Authority
WO
WIPO (PCT)
Prior art keywords
local
compare
controller module
fingerprint
audit
Prior art date
Application number
PCT/IB2014/000074
Other languages
French (fr)
Other versions
WO2014108800A3 (en
Inventor
Deyi YAO
Original Assignee
Alcatel Lucent
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 Alcatel Lucent filed Critical Alcatel Lucent
Publication of WO2014108800A2 publication Critical patent/WO2014108800A2/en
Publication of WO2014108800A3 publication Critical patent/WO2014108800A3/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21—Design, administration or maintenance of databases
    • G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Definitions

  • the present disclosure relates to the field of wireless communication technology, and particularly, to a method for comparing and reconsolidating a geo-redundant database in a wireless communication system.
  • HLR Home Location Register
  • HSS Home Subscriber Server
  • EIR Equipment Identity Register
  • AAA Authentication, Authorization and Accounting
  • the conventional method audits such databases periodically, such an audit compares all the contents in the databases every time. Since there are several millions (even several billions) of subscriber profiles in such databases, the data amount needed to be compared is too large. On one hand, such an audit has a high requirement for the network speed of such geo-redundant databases; on the other hand, the time duration of each audit is so long due to the huge data amount. This would give the limited network resources an unbearable load and make the operator's network layout costs significantly increased.
  • the present invention proposes a method for comparing and reconsolidating a geo-redundant database in a wireless communication system, the method comprises the following steps:
  • a compare & reconciliation controller module establishing a communication connection with at least two local agency modules, wherein the compare & reconciliation controller module is located at a data center and the at least two local agency modules are associated with a corresponding local database;
  • the compare & reconciliation controller module sending an audit start instruction to each of the at least two local agency modules and each of the local agency modules determining whether it is the first time to receive the audit start instruction:
  • each of the local agency modules transferring all identifiers associated with each subscriber profile and splitting all the identifiers into several chunks stored in the storages of the local agency modules, and transferring the several chunks of identifiers to the compare & reconciliation controller module,
  • each of the local agency modules transferring all identifiers associated with each subscriber profile updated after the last audit and splitting the identifiers into at least one chunk stored in the storages of the local agency modules, and transferring the at least one chunk of identifiers to the compare & reconciliation controller module;
  • the compare & reconciliation controller module analyzing the several or at least one chunk of identifiers to establish a first data list and sending a sampling instruction to the local agency modules based on the first data list, so as to instruct the local agency modules to sample the fingerprint of the corresponding subscriber profile simultaneously existing in the local databases associated with the at least two local agency modules, and transferring the fingerprint to the compare & reconciliation controller module in the form of a sampling response instruction;
  • the compare & reconciliation controller module establishing a second data list based on the sampling response instruction and storing the identifiers corresponding to the subscriber profiles having different fingerprints in each of the local databases as a reconsolidation list; and f. the compare & reconciliation controller module reconsolidating the corresponding subscriber profiles in each of the local databases based on the reconsolidation list until the fingerprints of all the subscriber profiles are the same.
  • the method according to the present invention realizes different handling for the first audit and the subsequent audit.
  • Full amount audit is only made when it is the first audit, while only the updated data items which are updated since the last audit are audited when it is the subsequent audit, and thus the data amount needed to be audited is significantly reduced and the required network speed is also lower, at the same time the audit speed is increased and thus the influence to other services is reduced.
  • the above mentioned advantages directly reduce the cost for the mobile operator and the users and thus make the mobile communication network more economical.
  • the geo-redundant database is a real-time database.
  • the online services of the real-time databases do not need to be stopped during the audit and reconsolidation procedure which further reduces the negative influence to the traditional services due to the audit according to the present invention.
  • the geo-redundant database is a database located at Home Location Register (HLR), Home Subscriber Server (HSS), Equipment Identity Register (EIR), Authentication, Authorization and Accounting (AAA).
  • HLR Home Location Register
  • HSS Home Subscriber Server
  • EIR Equipment Identity Register
  • AAA Authentication, Authorization and Accounting
  • the communication connection is a synchronized sampling and fingerprint comparison protocol based on SSL/TLS protocol.
  • the audit content is not the specific content of each database.
  • the fingerprint of each profile in the database is sampled based on the synchronized sampling and fingerprint comparison protocol and the data amount of the fingerprint is significantly reduced in comparison with the original data and thus the method according to the present invention further reduces the requirement for the network speed.
  • the local agency module sends heartbeat information to the compare & reconciliation controller module periodically and the compare & reconciliation controller module sends heartbeat response information to the local agency module in response to the heartbeat information.
  • the compare & reconsolidation controller module and each of the local agency modules acknowledge the alive-status of each other through the heart beat information.
  • the fingerprint is sampled according to Rabin fingerprint algorithm, MD5, SHA or CRC algorithm.
  • the each of the local databases is manually checked and reconsolidated by the operator of the geo-redundant databases if the fingerprint of part of the subscriber profiles are still inconsistent with each other after the step (f) is repeated for a predetermined times. In such a manner, the failure is manually eliminated while the automatically audit is failed and thus to make sure that the system works normally.
  • the first data list contains the identifier and a data item indicating whether the identifier exists in each of the local databases.
  • the second data list contains the identifier and a fingerprint information data item indicating the fingerprint of the subscriber profile corresponding to the identifier.
  • the second data list further contains a timestamp indicating the updated time of the subscriber profile corresponding to the identifier.
  • the method according to the present invention realizes different handling for the first audit and the subsequent audit.
  • Full amount audit is only made when it is the first audit, while only the updated data items which are updated since the last audit are audited when it is the subsequent audit, and thus the data amount needed to be audited is significantly reduced and the required network speed is also reduced, at the same time the audit speed is increased and thus the influence to other services is reduced.
  • the above mentioned advantages directly reduce the cost for the mobile operator and the users and thus make the mobile communication network more economical.
  • the audit content is not the specific content of each database.
  • the fingerprint of each profile in the database is sampled based on the synchronized sampling and fingerprint comparison protocol and the data amount of the fingerprint is significantly reduced in comparison with the original data and thus the method according to the present invention further reduces the requirement for the network speed.
  • Fig. l illustrates the schematic diagram of the topology structure of the geo-redundant database according to the present invention.
  • Fig.2 illustrates a flow diagram of the method for comparing and reconsolidating a geo-redundant database in a wireless communication system according to the invention.
  • Figure 1 illustrates the schematic diagram of the topology structure of the geo-redundant database according to the present invention.
  • the compare & reconciliation controller module is located at a data center and at least two (here it is three local agency modules) local agency modules are associated with the corresponding local databases.
  • the method according to the present invention illustrated in Figure 2 works based on the above described network architecture.
  • Fig.2 illustrates a flow diagram of the method for comparing and reconsolidating geo-redundant databases in a wireless communication system according to the invention.
  • a method 200 for comparing and reconsolidating geo-redundant databases in a wireless communication system comprises the following steps:
  • a compare & reconciliation controller module establishes a communication connection with at least two local agency modules, wherein the compare & reconciliation controller module is located at a data center and the at least two local agency modules are associated with a corresponding local database;
  • step 220 the compare & reconciliation controller module sends an audit start instruction to each of the at least two local agency modules and each of the local agency modules determines whether it is the first time to receive the audit start instruction:
  • the each of the local agency modules transfers all identifiers associated with each subscriber profile and splits all the identifiers into several chunks stored in the storages of the local agency modules, and transfers the several chunks of identifiers to the compare & reconciliation controller module,
  • the each of the local agency modules transfers all identifiers associated with each subscriber profile updated after the last audit and splits the identifiers into at least one chunk stored in the storages of the local agency modules, and transfers the at least one chunk of identifiers to the compare & reconciliation controller module;
  • the compare & reconciliation controller module analyzes the several or at least one chunk of identifiers to establish a first data list and sends a sampling instruction to the local agency modules based on the first data list, so as to instruct the local agency modules to sample the fingerprint of the corresponding subscriber profile simultaneously existing in the local databases associated with the at least two local agency modules, and transfers the fingerprint to the compare & reconciliation controller module in the form of a sampling response instruction;
  • step 250 the compare & reconciliation controller module establishes a second data list based on the sampling response instruction and stores the identifiers corresponding to the subscriber profiles having different fingerprints in each of the local databases as a reconsolidation list;
  • step 260 the compare & reconciliation controller module reconsolidates the corresponding subscriber profiles in each of the local databases based on the reconsolidation list until the fingerprints of all the subscriber profiles are same.
  • each data item is a ServiceObject (hereinafter referred to as SO)
  • SO ServiceObject
  • the compare & reconciliation controller module CRC
  • LA local agency modules
  • the compare & reconciliation controller module sends an audit start instruction (StartKeyListDumpRequest) to each of the at least two local agency modules and each of the local agency modules determines whether it is the first time to receive the audit start instruction;
  • the each of the local agency modules transfers all identifiers associated with each subscriber profile and splits all the identifiers into several chunks stored in the storages of the local agency modules, and transfers the several chunks of identifiers to the compare & reconciliation controller module in the form of StartKeyListDumpResponse,
  • the each of the local agency modules transfers all identifiers associated with each subscriber profile updated after the last audit and splits the identifiers into at least one chunk stored in the storages of the local agency modules, and transfers the at least one chunk of identifiers to the compare & reconciliation controller module in the form of StartKeyListDumpResponse;
  • the compare & reconciliation controller module analyzes the several or at least one chunk of identifiers to establish a first data list in the form of ⁇ sokey, existOnDb(l)Flag, ... existOnDb(n)Flag> and sends a sampling instruction StartSamplingRequest to the local agency modules based on the first data list, so as to instruct the local agency modules to sample the fingerprint of the corresponding subscriber profile simultaneously existing in the local databases associated with the at least two local agency modules, and transfers the fingerprint to the compare & reconciliation controller module in the form of sampling response instruction StartSamplingResponse;
  • the compare & reconciliation controller module establishes a second data list in the form of ⁇ sokey,fingerprint(l), SoUpdateTimestamp(l), fingerprint(2), SoUpdateTimestamp(2), fingerprint (n), SoUpdateTimestamp(n)> based on the sampling response instruction and stores the identifiers corresponding to the subscriber profiles having different fingerprints in each of the local databases as a reconsolidation list; and
  • the compare & reconciliation controller module reconsolidates the corresponding subscriber profiles in each of the local databases based on the reconsolidation list until the fingerprints of all the subscriber profiles are same.
  • the method according to the present invention realizes different handling for the first audit and the subsequent audit.
  • Full amount audit is only made when it is the first audit, while only the updated data items which are updated after the last audit are audited when it is the subsequent audit, and thus the data amount needed to be audited is significantly reduced and the required network speed is also lower, at the same time the audit speed is increased and thus the influence to other services is reduced.
  • the above mentioned advantages directly reduce the cost for the mobile operator and the users and thus make the mobile communication network more economical.
  • the geo-redimdant database is a real-time database.
  • the online services of the real-time databases do not need to be stopped during the audit and reconsolidation procedure which further reduces the negative influence to the traditional services due to the audit according to the present invention.
  • the geo-redundant database is a database located at Home Location Register (HLR), Home Subscriber Server (HSS), Equipment Identity Register (EIR), Authentication, Authorization and Accounting (AAA).
  • HLR Home Location Register
  • HSS Home Subscriber Server
  • EIR Equipment Identity Register
  • AAA Authentication, Authorization and Accounting
  • the communication connection is a synchronized sampling and fingerprint comparison protocol based on SSL/TLS protocol.
  • the audit content is not the specific content of each database.
  • the fingerprint of each profile in the database is sampled based on the synchronized sampling and fingerprint comparison protocol and the data amount of the fingerprint is significantly reduced in comparison with the original data and thus the method according to the present invention further reduces the required network speed.
  • the local agency module sends heartbeat information to the compare & reconciliation controller module periodically and the compare & reconciliation controller module sends heartbeat response information to the local agency module in response to the heartbeat information.
  • the compare & reconsolidation controller module and each of the local agency modules acknowledge the alive-status of each other through the heart beat information.
  • the fingerprint is sampled according to Rabin fingerprint algorithm, MD5, SHA or CRC algorithm.
  • the each of the local databases is manually checked and reconsolidated by the operator of the geo-redundant databases when the fingerprints of part of the subscriber profiles are still inconsistent with each other after the step (f) is repeated for a predetermined times. In such a manner, the failure is manually eliminated while the automatically audit is failed and thus to make sure that the system works normally.
  • the first data list contains the identifier and a data item indicating whether the identifier exists in each of the local databases.
  • the second data list contains the identifier and a fingerprint information data item indicating the fingerprint of the subscriber profile corresponding to the identifier.
  • the second data list further contains a timestamp indicating the updated time of the subscriber profile corresponding to the identifier.
  • the method according to the present invention realizes different handling for the first audit and the subsequent audit.
  • Full amount audit is only made when it is the first audit, while only the updated data items which are updated since the last audit are audited when it is the subsequent audit, and thus the data amount needed to be audited is significantly reduced and the required network speed is also reduced, at the same time the audit speed is increased and thus the influence to other services is reduced.
  • the above mentioned advantages directly reduce the cost for the mobile operator and the users and thus make the mobile communication network more economical.
  • the audit content is not the specific content of each database.
  • the fingerprint of each profile in the database is sampled based on the synchronized sampling and fingerprint comparison protocol and the data amount of the fingerprint is significantly reduced in comparison with the original data and thus the method according to the present invention further reduces the requirement for the network speed.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computing Systems (AREA)
  • Quality & Reliability (AREA)
  • Mobile Radio Communication Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Telephonic Communication Services (AREA)

Abstract

The invention relates to a method for comparing and reconsolidating a geo-redundant database in a wireless communication system, the method comprises the following steps: a compare & reconciliation controller module located at a data center establishing a communication connection with at least two local agency modules associated with a corresponding local database and sending an audit start instruction, and each of the local agency modules determining whether it is the first time to receive the audit start instruction: if yes, then detecting the full amount; else, then detecting the added amount; and then the compare & reconciliation controller module detecting the fingerprint of each chunk and storing the identifiers corresponding to the subscriber profiles having different fingerprints in each of the local databases as a reconsolidation list; and the compare & reconciliation controller module reconsolidating each of the local databases based on the reconsolidation list until the fingerprints of all the subscriber profiles are same. The method according to the present invention reduces the audit bandwidth requirement and speeds up the audit by only detecting the fingerprint.

Description

Method for Comparing and Reconsolidating Geo-redundant Database
Field of the invention
The present disclosure relates to the field of wireless communication technology, and particularly, to a method for comparing and reconsolidating a geo-redundant database in a wireless communication system. Background of the invention
In the core network of the mobile communication network, there are many real-time databases like Home Location Register(HLR), Home Subscriber Server(HSS), Equipment Identity Register(EIR), Authentication, Authorization and Accounting(AAA), etc. which are network replicated among multiple distributed sites for high availability purpose. The existence of such databases and the content therein are very important for the mobile communication.
In order to make sure that the contents in such geo-redundant databases are consistent with each other, the conventional method audits such databases periodically, such an audit compares all the contents in the databases every time. Since there are several millions (even several billions) of subscriber profiles in such databases, the data amount needed to be compared is too large. On one hand, such an audit has a high requirement for the network speed of such geo-redundant databases; on the other hand, the time duration of each audit is so long due to the huge data amount. This would give the limited network resources an unbearable load and make the operator's network layout costs significantly increased.
Summary of the invention In view of the prior art and the technical problem thereof identified as above, the present invention proposes a method for comparing and reconsolidating a geo-redundant database in a wireless communication system, the method comprises the following steps:
a. a compare & reconciliation controller module establishing a communication connection with at least two local agency modules, wherein the compare & reconciliation controller module is located at a data center and the at least two local agency modules are associated with a corresponding local database;
b. the compare & reconciliation controller module sending an audit start instruction to each of the at least two local agency modules and each of the local agency modules determining whether it is the first time to receive the audit start instruction:
if yes, then:
cl . the each of the local agency modules transferring all identifiers associated with each subscriber profile and splitting all the identifiers into several chunks stored in the storages of the local agency modules, and transferring the several chunks of identifiers to the compare & reconciliation controller module,
else, then:
c2. the each of the local agency modules transferring all identifiers associated with each subscriber profile updated after the last audit and splitting the identifiers into at least one chunk stored in the storages of the local agency modules, and transferring the at least one chunk of identifiers to the compare & reconciliation controller module;
d. the compare & reconciliation controller module analyzing the several or at least one chunk of identifiers to establish a first data list and sending a sampling instruction to the local agency modules based on the first data list, so as to instruct the local agency modules to sample the fingerprint of the corresponding subscriber profile simultaneously existing in the local databases associated with the at least two local agency modules, and transferring the fingerprint to the compare & reconciliation controller module in the form of a sampling response instruction;
e. the compare & reconciliation controller module establishing a second data list based on the sampling response instruction and storing the identifiers corresponding to the subscriber profiles having different fingerprints in each of the local databases as a reconsolidation list; and f. the compare & reconciliation controller module reconsolidating the corresponding subscriber profiles in each of the local databases based on the reconsolidation list until the fingerprints of all the subscriber profiles are the same.
The method according to the present invention realizes different handling for the first audit and the subsequent audit. Full amount audit is only made when it is the first audit, while only the updated data items which are updated since the last audit are audited when it is the subsequent audit, and thus the data amount needed to be audited is significantly reduced and the required network speed is also lower, at the same time the audit speed is increased and thus the influence to other services is reduced. The above mentioned advantages directly reduce the cost for the mobile operator and the users and thus make the mobile communication network more economical.
In one embodiment of the present invention, the geo-redundant database is a real-time database. The online services of the real-time databases do not need to be stopped during the audit and reconsolidation procedure which further reduces the negative influence to the traditional services due to the audit according to the present invention.
In one embodiment of the present invention, the geo-redundant database is a database located at Home Location Register (HLR), Home Subscriber Server (HSS), Equipment Identity Register (EIR), Authentication, Authorization and Accounting (AAA).
In one embodiment of the present invention, the communication connection is a synchronized sampling and fingerprint comparison protocol based on SSL/TLS protocol.
In such a manner, even if a full amount audit is made, the audit content is not the specific content of each database. In contrary, the fingerprint of each profile in the database is sampled based on the synchronized sampling and fingerprint comparison protocol and the data amount of the fingerprint is significantly reduced in comparison with the original data and thus the method according to the present invention further reduces the requirement for the network speed.
In one embodiment of the present invention, the local agency module sends heartbeat information to the compare & reconciliation controller module periodically and the compare & reconciliation controller module sends heartbeat response information to the local agency module in response to the heartbeat information.
In such a manner, the compare & reconsolidation controller module and each of the local agency modules acknowledge the alive-status of each other through the heart beat information.
In one embodiment of the present invention, in the step (d) the fingerprint is sampled according to Rabin fingerprint algorithm, MD5, SHA or CRC algorithm.
In one embodiment of the present invention, in the step (f) the each of the local databases is manually checked and reconsolidated by the operator of the geo-redundant databases if the fingerprint of part of the subscriber profiles are still inconsistent with each other after the step (f) is repeated for a predetermined times. In such a manner, the failure is manually eliminated while the automatically audit is failed and thus to make sure that the system works normally.
In one embodiment of the present invention, the first data list contains the identifier and a data item indicating whether the identifier exists in each of the local databases.
In one embodiment of the present invention, the second data list contains the identifier and a fingerprint information data item indicating the fingerprint of the subscriber profile corresponding to the identifier.
In one embodiment of the present invention, the second data list further contains a timestamp indicating the updated time of the subscriber profile corresponding to the identifier.
To sum up, the method according to the present invention realizes different handling for the first audit and the subsequent audit. Full amount audit is only made when it is the first audit, while only the updated data items which are updated since the last audit are audited when it is the subsequent audit, and thus the data amount needed to be audited is significantly reduced and the required network speed is also reduced, at the same time the audit speed is increased and thus the influence to other services is reduced. The above mentioned advantages directly reduce the cost for the mobile operator and the users and thus make the mobile communication network more economical. Moreover, even if a full amount audit is made in the method according to the present invention, the audit content is not the specific content of each database. In contrary, the fingerprint of each profile in the database is sampled based on the synchronized sampling and fingerprint comparison protocol and the data amount of the fingerprint is significantly reduced in comparison with the original data and thus the method according to the present invention further reduces the requirement for the network speed.
Brief description of drawings
Other features, objects and advantages of the invention will become more apparent upon review of the following detailed description of non-limiting embodiments taken with reference to the drawings, in which:
Fig. l illustrates the schematic diagram of the topology structure of the geo-redundant database according to the present invention; and
Fig.2 illustrates a flow diagram of the method for comparing and reconsolidating a geo-redundant database in a wireless communication system according to the invention.
Identical or similar devices (modules) or steps will be denoted by identical or similar reference numerals throughout the drawings.
Detailed description of embodiments
The following particular description of preferred embodiments will be given with reference to the drawings constituting a part of the invention. The drawings exemplarily illustrate particular embodiments, in which the invention can be practiced. The exemplary embodiments are not intended to exhaust all the embodiments of the invention. As can be appreciated, other embodiments can be possible or structural or logical modifications can be made without departing from the scope of the invention. Thus the following detailed description is not intended to be limiting, and the scope of the invention will be defined as in the appended claims.
Figure 1 illustrates the schematic diagram of the topology structure of the geo-redundant database according to the present invention. As can be seen from Fig. 1, the compare & reconciliation controller module is located at a data center and at least two (here it is three local agency modules) local agency modules are associated with the corresponding local databases. There is a Wide Area Network between all the local agency modules for database replication, while there is a database audit WAN between all the local agency modules and the compare & reconciliation controller module. The method according to the present invention illustrated in Figure 2 works based on the above described network architecture.
Fig.2 illustrates a flow diagram of the method for comparing and reconsolidating geo-redundant databases in a wireless communication system according to the invention. As can be seen from Fig. 2, a method 200 for comparing and reconsolidating geo-redundant databases in a wireless communication system comprises the following steps:
in step 210, a compare & reconciliation controller module establishes a communication connection with at least two local agency modules, wherein the compare & reconciliation controller module is located at a data center and the at least two local agency modules are associated with a corresponding local database;
in step 220, the compare & reconciliation controller module sends an audit start instruction to each of the at least two local agency modules and each of the local agency modules determines whether it is the first time to receive the audit start instruction:
if yes, then:
in step 231 , the each of the local agency modules transfers all identifiers associated with each subscriber profile and splits all the identifiers into several chunks stored in the storages of the local agency modules, and transfers the several chunks of identifiers to the compare & reconciliation controller module,
else, then:
in step 232, the each of the local agency modules transfers all identifiers associated with each subscriber profile updated after the last audit and splits the identifiers into at least one chunk stored in the storages of the local agency modules, and transfers the at least one chunk of identifiers to the compare & reconciliation controller module;
then, in step 240, the compare & reconciliation controller module analyzes the several or at least one chunk of identifiers to establish a first data list and sends a sampling instruction to the local agency modules based on the first data list, so as to instruct the local agency modules to sample the fingerprint of the corresponding subscriber profile simultaneously existing in the local databases associated with the at least two local agency modules, and transfers the fingerprint to the compare & reconciliation controller module in the form of a sampling response instruction;
then, in step 250, the compare & reconciliation controller module establishes a second data list based on the sampling response instruction and stores the identifiers corresponding to the subscriber profiles having different fingerprints in each of the local databases as a reconsolidation list; and
finally, in step 260, the compare & reconciliation controller module reconsolidates the corresponding subscriber profiles in each of the local databases based on the reconsolidation list until the fingerprints of all the subscriber profiles are same.
More specifically, in the following specification an example is given to illustrate the method according to the present invention. In the above mentioned geo-redundant database, each data item is a ServiceObject (hereinafter referred to as SO), after the compare & reconciliation controller module (CRC) establishes a communication connection with at least two local agency modules (LA) (the compare & reconciliation controller module locates in a data center and the at least two local agency modules are associated with a corresponding local database), the compare & reconciliation controller module sends an audit start instruction (StartKeyListDumpRequest) to each of the at least two local agency modules and each of the local agency modules determines whether it is the first time to receive the audit start instruction;
if yes, then:
the each of the local agency modules transfers all identifiers associated with each subscriber profile and splits all the identifiers into several chunks stored in the storages of the local agency modules, and transfers the several chunks of identifiers to the compare & reconciliation controller module in the form of StartKeyListDumpResponse,
else, then:
the each of the local agency modules transfers all identifiers associated with each subscriber profile updated after the last audit and splits the identifiers into at least one chunk stored in the storages of the local agency modules, and transfers the at least one chunk of identifiers to the compare & reconciliation controller module in the form of StartKeyListDumpResponse;
then, the compare & reconciliation controller module analyzes the several or at least one chunk of identifiers to establish a first data list in the form of <sokey, existOnDb(l)Flag, ... existOnDb(n)Flag> and sends a sampling instruction StartSamplingRequest to the local agency modules based on the first data list, so as to instruct the local agency modules to sample the fingerprint of the corresponding subscriber profile simultaneously existing in the local databases associated with the at least two local agency modules, and transfers the fingerprint to the compare & reconciliation controller module in the form of sampling response instruction StartSamplingResponse;
then, the compare & reconciliation controller module establishes a second data list in the form of <sokey,fingerprint(l), SoUpdateTimestamp(l), fingerprint(2), SoUpdateTimestamp(2), fingerprint (n), SoUpdateTimestamp(n)> based on the sampling response instruction and stores the identifiers corresponding to the subscriber profiles having different fingerprints in each of the local databases as a reconsolidation list; and
finally, the compare & reconciliation controller module reconsolidates the corresponding subscriber profiles in each of the local databases based on the reconsolidation list until the fingerprints of all the subscriber profiles are same.
The method according to the present invention realizes different handling for the first audit and the subsequent audit. Full amount audit is only made when it is the first audit, while only the updated data items which are updated after the last audit are audited when it is the subsequent audit, and thus the data amount needed to be audited is significantly reduced and the required network speed is also lower, at the same time the audit speed is increased and thus the influence to other services is reduced. The above mentioned advantages directly reduce the cost for the mobile operator and the users and thus make the mobile communication network more economical.
In one embodiment of the present invention, the geo-redimdant database is a real-time database. The online services of the real-time databases do not need to be stopped during the audit and reconsolidation procedure which further reduces the negative influence to the traditional services due to the audit according to the present invention.
In one embodiment of the present invention, the geo-redundant database is a database located at Home Location Register (HLR), Home Subscriber Server (HSS), Equipment Identity Register (EIR), Authentication, Authorization and Accounting (AAA).
In one embodiment of the present invention, the communication connection is a synchronized sampling and fingerprint comparison protocol based on SSL/TLS protocol.
In such a manner, even if a full amount audit is made, the audit content is not the specific content of each database. In contrary, the fingerprint of each profile in the database is sampled based on the synchronized sampling and fingerprint comparison protocol and the data amount of the fingerprint is significantly reduced in comparison with the original data and thus the method according to the present invention further reduces the required network speed.
In one embodiment of the present invention, the local agency module sends heartbeat information to the compare & reconciliation controller module periodically and the compare & reconciliation controller module sends heartbeat response information to the local agency module in response to the heartbeat information.
In such a manner, the compare & reconsolidation controller module and each of the local agency modules acknowledge the alive-status of each other through the heart beat information.
In one embodiment of the present invention, in the step 240 the fingerprint is sampled according to Rabin fingerprint algorithm, MD5, SHA or CRC algorithm. In one embodiment of the present invention, in the step 250 the each of the local databases is manually checked and reconsolidated by the operator of the geo-redundant databases when the fingerprints of part of the subscriber profiles are still inconsistent with each other after the step (f) is repeated for a predetermined times. In such a manner, the failure is manually eliminated while the automatically audit is failed and thus to make sure that the system works normally.
In one embodiment of the present invention, the first data list contains the identifier and a data item indicating whether the identifier exists in each of the local databases.
In one embodiment of the present invention, the second data list contains the identifier and a fingerprint information data item indicating the fingerprint of the subscriber profile corresponding to the identifier.
In one embodiment of the present invention, the second data list further contains a timestamp indicating the updated time of the subscriber profile corresponding to the identifier.
To sum up, the method according to the present invention realizes different handling for the first audit and the subsequent audit. Full amount audit is only made when it is the first audit, while only the updated data items which are updated since the last audit are audited when it is the subsequent audit, and thus the data amount needed to be audited is significantly reduced and the required network speed is also reduced, at the same time the audit speed is increased and thus the influence to other services is reduced. The above mentioned advantages directly reduce the cost for the mobile operator and the users and thus make the mobile communication network more economical. Moreover, even if a full amount audit is made in the method according to the present invention, the audit content is not the specific content of each database. In contrary, the fingerprint of each profile in the database is sampled based on the synchronized sampling and fingerprint comparison protocol and the data amount of the fingerprint is significantly reduced in comparison with the original data and thus the method according to the present invention further reduces the requirement for the network speed.
Those skilled in the art shall appreciate that the invention apparently will not be limited to the foregoing exemplary embodiments and can be embodied in other specific forms without departing from the spirit or essence of the invention. Accordingly the embodiments shall be construed anyway to be exemplary and non-limiting. Moreover apparently the term "comprising" will not preclude another element(s) or step(s), and the term "a" or "an" will not preclude plural. A plurality of elements stated in an apparatus claim can alternatively be embodied as a single element. The terms "first", "second", etc., are intended to designate a name but not to suggest any specific order.

Claims

1. A method for comparing and reconsolidating a geo-redimdant database in a wireless communication system, comprising:
a. a compare & reconciliation controller module establishing a communication connection with at least two local agency modules, wherein the compare & reconciliation controller module is located at a data center and the at least two local agency modules are associated with a corresponding local database;
b. the compare & reconciliation controller module sending an audit start instruction to each of the at least two local agency modules and each of the local agency modules determining whether it is the first time to receive the audit start instruction:
if yes, then:
cl . the each of the local agency modules transferring all identifiers associated with each subscriber profile and splitting all the identifiers into several chunks stored in the storages of the local agency modules, and transferring the several chunks of identifiers to the compare & reconciliation controller module,
else, then:
c2. the each of the local agency modules transferring all identifiers associated with each of the subscriber profiles updated after the last audit and splitting the identifiers into at least one chunk stored in the storages of the local agency modules, and transferring the at least one chunk of identifiers to the compare & reconciliation controller module;
d. the compare & reconciliation controller module analyzing the several or at least one chunk of identifiers to establish a first data list and sending a sampling instruction to the local agency modules based on the first data list, so as to instruct the local agency modules to sample the fingerprint of the corresponding subscriber profile simultaneously existing in the local databases associated with the at least two local agency modules, and transferring the fingerprint to the compare & reconciliation controller module in the form of a sampling response instruction;
e. the compare & reconciliation controller module establishing a second data list based on the sampling response instruction and storing the identifiers corresponding to the subscriber profiles having different fingerprints in each of the local databases as a reconsolidation list; and
f. the compare & reconciliation controller module reconsolidating the corresponding subscriber profiles in each of the local databases based on the reconsolidation list until the fingerprints of all the subscriber profiles are same.
2. The method according to claim 1 , wherein the geo-redundant database is a real-time database.
3. The method according to claim 2, wherein the geo-redundant database is a database located at Home Location Register (HLR), Home Subscriber Server (HSS), Equipment Identity Register (EIR), Authentication, Authorization and Accounting (AAA).
4. The method according to claim 1, wherein the communication connection is a synchronized sampling and fingerprint comparison protocol based on SSL/TLS protocol.
5. The method according to claim 1 , wherein the local agency module sends heartbeat information to the compare & reconciliation controller module periodically and the compare & reconciliation controller module sends heartbeat response information to the local agency module in response to the heartbeat information.
6. The method according to claim 1, wherein in the step (d) the fingerprint is sampled according to Rabin fingerprint algorithm, MD5, SHA or CRC algorithm.
7. The method according to claim 1 , wherein in the step (f) the each of the local databases is manually checked and reconsolidated by the operator of the geo-redundant databases if the fingerprints of part of the subscriber profiles are still inconsistent with each other after the step (f) is repeated for a predetermined times.
8. The method according to claim 1 , wherein the first data list contains the identifier and a data item indicating whether the identifier exists in each of the local databases.
9. The method according to claim 1 , wherein the second data list contains the identifier and a fingerprint information data item indicating the fingerprint of the subscriber profile corresponding to the identifier.
10. The method according to claim 9, wherein the second data list further contains a timestamp indicating the updated time of the subscriber profile corresponding to the identifier.
PCT/IB2014/000074 2013-01-11 2014-01-07 Method for comparing and reconsolidating geo-redundant database WO2014108800A2 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201310021273.X 2013-01-11
CN201310021273.XA CN103929763A (en) 2013-01-11 2013-01-11 Method for comparison and reconstruction of geographic redundancy database

Publications (2)

Publication Number Publication Date
WO2014108800A2 true WO2014108800A2 (en) 2014-07-17
WO2014108800A3 WO2014108800A3 (en) 2014-10-23

Family

ID=50442561

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/IB2014/000074 WO2014108800A2 (en) 2013-01-11 2014-01-07 Method for comparing and reconsolidating geo-redundant database

Country Status (2)

Country Link
CN (1) CN103929763A (en)
WO (1) WO2014108800A2 (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106407189A (en) * 2015-07-27 2017-02-15 中兴通讯股份有限公司 Business data incidence relation verification method and device
CN107015991B (en) * 2016-01-28 2020-10-30 创新先进技术有限公司 Self-checking method, device and system for data consistency and service device
CN109117300A (en) * 2018-07-03 2019-01-01 千寻位置网络有限公司 Method of calibration and system, the positioning terminal of data
CN110737642B (en) * 2019-09-05 2022-09-02 平安科技（深圳）有限公司 Database information analysis method, database information analysis device, computer device and storage medium

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA2472014C (en) * 2001-11-01 2012-07-10 Verisign, Inc. Method and system for updating a remote database
CN1764915B (en) * 2003-02-06 2012-01-25 捷讯研究有限公司 Apparatus and method for comparing hashed value synchronous database
US7788225B2 (en) * 2005-03-18 2010-08-31 Oracle International Corporation Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
None

Also Published As

Publication number Publication date
WO2014108800A3 (en) 2014-10-23
CN103929763A (en) 2014-07-16

Similar Documents

Publication Publication Date Title
US20210036907A1 (en) Methods and apparatuses for pushing a message
WO2020147331A1 (en) Micro-service monitoring method and system
US20180159928A1 (en) Network-Based File Cloud Synchronization Method
WO2014108800A2 (en) Method for comparing and reconsolidating geo-redundant database
CN105447046A (en) Distributed system data consistency processing method, device and system
EP2869495B1 (en) Node de-duplication in a network monitoring system
CN105915405A (en) Large-scale cluster node performance monitoring system
CN113364624B (en) Mixed cloud flow acquisition method and system based on edge computing
CN109583896A (en) Transaction verification method, block chain node and storage medium
CN106611001A (en) Method, device and system for checking consistency of data in database tables in virtual machines
CN105635218B (en) Software center system
WO2021136233A1 (en) Service upgrading method, device and system
CN104753960A (en) Single-point login based system configuration management method
CN111770022A (en) Link monitoring-based capacity expansion method, system, equipment and computer storage medium
WO2017054468A1 (en) Method and system implementing inspection
US10505844B2 (en) Network element federation controller and forwarding box
CN106888110B (en) Configuration data synchronization method and device
US20190171828A1 (en) Digital Data Processing System For Efficiently Storing, Moving, And/Or Processing Data Across A Plurality Of Computing Clusters
CN107105037B (en) Distributed video CDN resource management system and method based on file verification
CN110912979B (en) Method for solving multi-server resource synchronization conflict
US10674337B2 (en) Method and device for processing operation for device peripheral
US10447807B1 (en) Dynamic middleware source selection for optimizing data retrieval from network nodes
CN105429795A (en) Alarm monitoring system and method
US11860724B2 (en) Method and system for facilitating a self-healing network
CN111327666B (en) Service management method, device and system, computer equipment and storage medium

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: 14715985

Country of ref document: EP

Kind code of ref document: A2

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 05/10/2015)

122 Ep: pct application non-entry in european phase

Ref document number: 14715985

Country of ref document: EP

Kind code of ref document: A2