Systems and methods for updating an LDAP

• US 20020138489A1
• Filed: 03/15/2002
• Published: 09/26/2002
• Est. Priority Date: 03/20/2001
• Status: Active Grant

• Current Assignee: Verizon Patent and Licensing Incorporated (Verizon Communications Inc.)
• Original Assignee: Verizon Business Global LLC (Verizon Communications Inc.)
• Inventors: Robohm, Kurt W., Trivedi, Prakash A.
• Granted Patent: US 8,341,116 B2
• Time in Patent Office: Days
• US Class Current: 707/10
• CPC Class Codes: H04L 12/14 Charging , metering or billing arrangements for data wireline or wireless communications
• CPC Class Codes: H04L 12/1403 Architecture for metering, charging or billing
• CPC Class Codes: H04L 12/1446 inter-operator billing
• CPC Class Codes: H04L 41/00 Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
• CPC Class Codes: H04L 47/10 Flow control; Congestion control
• CPC Class Codes: H04L 47/125 by balancing the load, e.g. traffic engineering
• CPC Class Codes: H04L 47/2408 for supporting different services, e.g. a differentiated services [DiffServ] type of service
• CPC Class Codes: H04L 47/2433 Allocation of priorities to traffic types
• CPC Class Codes: H04L 47/2441 relying on flow classification, e.g. using integrated services [IntServ]
• CPC Class Codes: H04L 61/4523 using lightweight directory access protocol [LDAP]
• CPC Class Codes: H04L 61/4535 using an address exchange platform which sets up a session between two nodes, e.g. rendezvous servers, session initiation protocols [SIP] registrars or H.323 gatekeepers
• CPC Class Codes: H04L 61/4557 Directories for hybrid networks, e.g. including telephone numbers
• CPC Class Codes: H04L 65/103 in the network
• CPC Class Codes: H04L 65/104 in the network
• CPC Class Codes: H04L 65/1043 Gateway controllers, e.g. media gateway control protocol [MGCP] controllers
• CPC Class Codes: H04L 65/1069 Session establishment or de-establishment
• CPC Class Codes: H04L 65/1096 Supplementary features, e.g. call forwarding or call holding systems providing special services or facilities to telephony subscribers H04M3/42
• CPC Class Codes: H04L 65/1101 Session protocols
• CPC Class Codes: H04L 65/1104 Session initiation protocol [SIP]
• CPC Class Codes: H04L 65/612 for unicast
• CPC Class Codes: H04L 65/762 : at the source reformatting of additional data in video distribution servers H04N21/2355
• CPC Class Codes: H04L 67/06 : specially adapted for file transfer, e.g. file transfer protocol [FTP]
• CPC Class Codes: H04L 67/1095 : Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
• CPC Class Codes: H04L 67/14 : Session management for real-time applications in data packet communications networks H04L65/1066
• CPC Class Codes: H04L 67/303 : Terminal profiles
• CPC Class Codes: H04L 67/306 : User profiles
• CPC Class Codes: H04L 67/34 : involving the movement of software or configuration parameters network booting or remote initial program loading [RIPL] G06F9/4416
• CPC Class Codes: H04L 67/51 : Discovery or management thereof, e.g. service location protocol [SLP] or web services
• CPC Class Codes: H04L 67/52 : specially adapted for the location of the user terminal
• CPC Class Codes: H04L 69/08 : Protocols for interworking; Protocol conversion
• CPC Class Codes: H04M 15/00 : Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP
• CPC Class Codes: H04M 15/43 : Billing software details
• CPC Class Codes: H04M 15/47 : Fraud detection or prevention means
• CPC Class Codes: H04M 15/53 : using mediation
• CPC Class Codes: H04M 15/55 : for hybrid networks
• CPC Class Codes: H04M 15/56 : for VoIP communications
• CPC Class Codes: H04M 15/63 : based on the content carried by the session initiation protocol [SIP] messages
• CPC Class Codes: H04M 15/8292 : Charging for signaling or unsuccessful connection
• CPC Class Codes: H04M 2215/0148 : Fraud detection or prevention means
• CPC Class Codes: H04M 2215/0172 : Mediation, i.e. device or program to reformat CDRS from one or more switches in order to adapt to one or more billing programs formats
• CPC Class Codes: H04M 2215/202 : VoIP; Packet switched telephony
• CPC Class Codes: H04M 2215/22 : Bandwidth or usage-sensitve billing
• CPC Class Codes: H04M 2215/44 : Charging/billing arrangements for connection made over different networks, e.g. wireless and PSTN, ISDN, etc.
• CPC Class Codes: H04Q 3/0029 : Provisions for intelligent networking

Abstract

A system updates a lightweight directory access protocol (LDAP) database based on changes made to a second database. The system determines differences between Internet Protocol (IP) communication service records stored in the second database and IP communication service records stored in the LDAP database and creates a transaction file based on the differences. The system updates the LDAP database using the transaction file.

Claims

1. A method for updating a lightweight directory access protocol (LDAP) database based on changes made to a second database, comprising:

determining differences between Internet Protocol (IP) communication service records stored in the second database and IP communication service records stored in the LDAP database; and

creating a transaction file based on the differences; and

updating the LDAP database using the transaction file.

2. The method of claim 1 wherein the determining occurs automatically at predetermined time intervals.

3. The method of claim 1 wherein the determining is performed hourly.

4. The method of claim 1 wherein the determining occurs in response to a command from a system administrator.

5. The method of claim 1 wherein the determining includes:

comparing one or more first tables containing current IP communication service records with one or more second tables containing IP communication service records from a previous comparison operation, and

determining, for each difference between the one or more first tables and the one or more second tables, a transaction type.

6. The method of claim 5 wherein the transaction file includes a list of the differences between the one or more first tables and the one or more second tables and an indication, corresponding to each difference, of the transaction type.

7. The method of claim 6 wherein the transaction type includes at least one of addition, deletion, and modification.

8. The method of claim 1 further comprising:

determining whether the updating was successful; and

appending the transaction file to a new transaction file when the updating was unsuccessful.

9. The method of claim 1 wherein the second database includes an operational data store.

10. A system for updating a lightweight directory access protocol (LDAP) database based on changes made to a second database, comprising:

a memory configured to store a plurality of instructions; and

a processor configured to execute the instructions to;

compare a first set of tables to a second set of tables, the first set of table comprising current Internet Protocol (IP) communications information, the second set of tables comprising IP communications information from a previous LDAP database update, identify, based on the comparing, differences between first set of tables and the second set of tables, create a transaction file based on the identified differences, and update the LDAP database using the transaction file.

11. The system of claim 10 wherein, when identifying, the processor is configured to:

identify, for each difference, a transaction type.

12. The system of claim 11 wherein, when creating, the processor is configured to:

store the transaction type with each difference in the transaction file.

13. The system of claim 10 wherein the processor is further configured to:

determine whether the LDAP database update was successful, and

append the transaction file to a new transaction file when the LDAP database update was unsuccessful.

14. The system of claim 10 wherein the second database comprises the first set of tables and the second set of tables.

15. The system of claim 14 wherein the second database includes an operational data store.

16. The system of claim 10 wherein the processor is configured to compare the first set of tables to the second set of tables automatically at predetermined time intervals.

17. The system of claim 10 wherein the processor is configured to compare the first set of tables to the second set of tables on an hourly basis.

18. The system of claim 10 wherein the processor is configured to compare the first set of tables to the second set of tables in response to a command from a system administrator.

20. The method of claim 19 wherein the second database includes an operational data store.

21. The method of claim 19 further comprising:

storing the one or more identified transactions in a transaction file, and wherein the updating includes;

updating the LDAP database using the transaction file.

22. The method of claim 21 further comprising:

associating a transaction type with each identified transaction.

23. The method of claim 22 wherein the storing includes:

storing the one or more identified transactions and the associated transaction types in the transaction file.

24. The method of claim 21 further comprising:

determining whether the LDAP database update was successful; and

appending the transaction file to a new transaction file when the LDAP database update was unsuccessful.

25. The method of claim 19 wherein the comparing occurs automatically at predetermined time intervals.

26. The method of claim 19 wherein the comparing occurs in response to a command from a system administrator.

28. The system of claim 27 further comprising:

means for storing the one or more identified transactions in a transaction file, and

wherein the means for updating includes;

means for updating the LDAP database using the transaction file.

29. The system of claim 28 further comprising:

means for determining whether the LDAP database update was successful; and

means for appending the transaction file to a new transaction file when the LDAP database update was unsuccessful.

30. The system of claim 27 further comprising:

means for updating the one or more second tables based on the identified one or more transactions.

19. A method for updating a lightweight directory access protocol (LDAP) database, comprising:

comparing one or more first tables to one or more second tables, the one or more first tables comprising a set of current records, the one or more second tables comprising records from the LDAP database, the one or more first tables and the one or more second tables being stored in a second database;

identifying one or more transactions based on the comparing; and

updating the LDAP database based on the one or more identified transactions.

27. A system for updating a lightweight directory access protocol (LDAP) database, comprising:

means for comparing one or more first tables to one or more second tables, the one or more first tables comprising a set of current records, the one or more second tables comprising records from the LDAP database;

means for identifying one or more transactions based on the comparing; and

means for updating the LDAP database based on the one or more identified transactions.