WO2014108800A2 - Method for comparing and reconsolidating geo-redundant database - Google Patents
Method for comparing and reconsolidating geo-redundant database Download PDFInfo
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 35
- 238000012550 audit Methods 0.000 claims abstract description 63
- 238000004891 communication Methods 0.000 claims abstract description 16
- 238000005070 sampling Methods 0.000 claims description 19
- 230000014759 maintenance of location Effects 0.000 claims description 8
- 238000003860 storage Methods 0.000 claims description 8
- 230000001360 synchronised effect Effects 0.000 claims description 7
- 238000013475 authorization Methods 0.000 claims description 4
- 238000010295 mobile communication Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 238000007796 conventional method Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000010076 replication Effects 0.000 description 1
- 238000012552 review Methods 0.000 description 1
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.
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)
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)
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 |
-
2013
- 2013-01-11 CN CN201310021273.XA patent/CN103929763A/en active Pending
-
2014
- 2014-01-07 WO PCT/IB2014/000074 patent/WO2014108800A2/en active Application Filing
Non-Patent Citations (1)
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 |