Database locking using logical lock mechanism
Systems and methods for locking databases during database operations, such as logical mechanisms for locking a local number portability (LNP) database associated with the Number Portability Administration Center (NPAC), are described. For example, the systems and methods may utilize various logical constructs, such as parameters that identify items or records within a database (e.g., object type and value information), and lock records that include such parameters.
1. A method for locking a number portability database during a database operation performed on one or more records stored within the number portability database, the method comprising:
accessing a database operation, including a read operation, a write operation, or a combination thereof to be performed by an application when updating the one or more records;
extracting an object identifier and a value associated with the database operation; and
locking the one or more records stored within the number portability database that include the extracted object identifier and the value and, in a cascading manner, the one or more records related to the extracted object identifier and the value, while the database operation is performed on the one or more records;
locking a record within the number portability database that does not include the extracted object identifier and the value;
upon locking the record, creating an initial entry comprising the extracted object identifier and the value; and
wherein the one or more records stored form a hierarchy and wherein the locking in the cascading manner is performed based on the hierarchy.
2. The method of claim 1 , wherein the number portability database stores information associated with porting of telephone numbers from one carrier to another carrier; and
wherein extracting the object identifier and the value associated with the database operation includes extracting an alphanumeric string as the object identifier that identifies an object type of a telephone number (TN) and the value that includes ten digits representative of a unique telephone number.
3. The method of claim 1 , wherein the number portability database stores information associated with porting of telephone numbers from one carrier to another carrier; and
wherein extracting the object identifier and the value associated with the database operation includes extracting an alphanumeric string as the object identifier that identifies an object type of a location routing number (LRN) and the value that includes ten digits representative of a unique location routing number.
4. The method of claim 1 , wherein the number portability database stores information associated with porting of telephone numbers from one carrier to another carrier; and
wherein extracting the object identifier and the value associated with the database operation includes extracting an alphanumeric string as the object identifier that identifies an object type of a service provider (SP) and the value that includes four digits representative of a unique service provider.
5. The method of claim 1 , wherein the number portability database stores information associated with porting of telephone numbers from one carrier to another carrier; and
wherein extracting the object identifier and the value associated with the database operation includes extracting an alphanumeric string as the object identifier that identifies an object type of a telephone number block (NPA-NXX) and the value that includes six digits representative of a unique telephone number block.
6. The method of claim 1 , wherein the number portability database stores information associated with porting of telephone numbers from one carrier to another carrier; and
wherein locking the one or more records includes locking the records that include:
a ported numbers record that stores information associated with telephone numbers previously ported between carriers; and
a pending numbers record that stores information associated with telephone numbers to be ported between carriers.
7. The method of claim 1 , wherein at least one record of the one or more records is created within the number portability database after the object identifier and the value are extracted from the database operation.
8. The method of claim 1 , further comprising:
determining the database operation was performed by the application; and
unlocking the one or more records that include the extracted object identifier and the value.
9. The method of claim 1 , further comprising:
providing, for a user, via a lock manager, a view of the locked one or more records; and
causing a creation and release of a lock of a record for testing purposes.
10. A non-transitory computer-readable medium with instructions stored thereon that, when executed by a system for locking a number portability database during a database operation performed on one or more records stored within the number portability database, cause the system to perform operations comprising:
accessing a database operation, including a read operation, a write operation, or a combination thereof to be performed by an application when updating the one or more records;
extracting an object identifier and a value associated with the database operation; and
locking the one or more records stored within the number portability database that include the extracted object identifier and the value and, in a cascading manner, the one or more records related to the extracted object identifier and the value, while the database operation is performed on the one or more records;
locking a record within the number portability database that does not include the extracted object identifier and the value;
upon locking the record, creating an initial entry comprising the extracted object identifier and the value; and
wherein the one or more records stored form a hierarchy and wherein the locking in the cascading manner is performed based on the hierarchy.
11. The non-transitory computer-readable medium of claim 10 with instructions operations, wherein extracting the object identifier and the value associated with the database operation includes extracting an alphanumeric string as the object identifier that identifies an object type of a telephone number (TN) and the value that includes ten digits representative of a unique telephone number.
12. The non-transitory computer-readable medium of claim 10 with instructions operations, wherein extracting the object identifier and the value associated with the database operation includes extracting an alphanumeric string as the object identifier that identifies an object type of a location routing number (LRN) and the value that includes ten digits representative of a unique location routing number.
13. The non-transitory computer-readable medium of claim 10 with instructions operations, wherein extracting the object identifier and the value associated with the database operation includes extracting an alphanumeric string as the object identifier that identifies an object type of a service provider (SP) and the value that includes four digits representative of a unique service provider.
14. The non-transitory computer-readable medium of claim 10 with instructions operations, wherein extracting the object identifier and the value associated with the database operation includes extracting an alphanumeric string as the object identifier that identifies an object type of a telephone number block (NPA-NXX) and the value that includes six digits representative of a unique telephone number block.
15. The non-transitory computer-readable medium of claim 10 with instructions operations, wherein locking the one or more records includes locking the records that include:
a ported numbers record that stores information associated with telephone numbers previously ported between carriers; and
a pending numbers record that stores information associated with telephone numbers to be ported between carriers.
16. The non-transitory computer-readable medium of claim 10 with instructions operations, wherein at least one of the one or more records is created within the number portability database after the object identifier and the value are extracted from the database operation.
17. The non-transitory computer-readable medium of claim 10 with instructions operations, further comprising:
determining the database operation was performed by the application; and unlocking the one or more records that include the extracted object identifier and the value.
18. A system for locking items stored within a number portability database during a database operation performed on one or more records stored within the number portability database comprising:
a processor configured to:
access a database operation, including a read operation, a write operation, or a combination thereof to be performed by an application when updating the one or more records,
extract an object identifier and a value associated with the database operation, and
lock the one or more records stored within the number portability database that include the extracted object identifier and the value and, in a cascading manner, the one or more records related to the extracted object identifier and the value, while the database operation is performed on the one or more records;
lock a record within the number portability database that does not include the extracted object identifier and the value;
upon locking the record, create an initial entry comprising the extracted object identifier and the value;
wherein the one or more records stored form a hierarchy and wherein the locking in the cascading manner is performed based on the hierarchy; and
a storage device, coupled to the processor, configured to:
store the one or more records.
19. The system of claim 18 , wherein the number portability database stores information associated with porting of telephone numbers from one carrier to another carrier; and
wherein the processor is further configured to lock a ported numbers record and a pending numbers record in response to identifying that data having a specific item type of a telephone number (TN) and an associated ten digit value for the telephone number is stored within the ported numbers record and the pending numbers record.
20. The system of claim 18 , wherein the processor is further configured to:
provide, for a user, a view of the locked one or more records; and
cause a creation and release of a lock of a record for testing purposes.