Problem Description
- Our client needed to handle top numbers (gold and premium numbers) in a more efficient way. The existing system was based on some VB applications using Excel sheet and it was slow and not well integrated
- Challenge: Handle the Top Numbers within the same system in charge of handling MSISDNs (ERM) seamlessly.
Answer: Top Number Management
- With ERM Top Number Classification, the number classes and categories are stored in BSCS database.
- The number classes and categories are linked to MSISDNs and they are available for searching MSISDNs of a specific class and/or category.
- The classification is performed by calling the procedure ClassifyTopNumbers in package ERM.
Top Number Management – Strengths
- High-performance top number handling
- Search and immediate availability for sale of top numbers
- Flexible configuration: Top number patterns can be customized as per customer’s wishes
- External clients can search for a certain number category or value class and get unbelievably fast responses
Overview:
Sample Top Numbers Classes and Categories
| Value Class |
Number Category |
Description |
| B | M1 | 7 Identical Digits at the End – 079 555 55 55 |
| B | M2 | 3 Identical 3-Digit Blocks – 0 794 794 794 |
| B | M3 | 6 Identical Digits at the End – 079 6 444 444 |
| B | M4 | 5 Identical Digits at the End – 079 24 777 77 |
| C | M5 | 3 Identical 2-Digit Blocks – 079 5 61 61 61 |
| C | M6 | 2 Identical 3-Digit Blocks – 0 797 198 797 |
| C | M7 | 2 Straight 3-Digit Blocks – 079 4 222 888 |
| C | M8 | 3 Identical Ten/One Parts in the 3-Digit Blocks – 0 792 592 892 |
| C | M9 | 2 Hundred Blocks at the End – 079 3 500 600 |
| C | M10 | Ascending 3-Digit-Block Triplet (One Up) – 0 793 794 795 |
| C | M10a | Ascending 3-Digit-Block Triplet (Ten or Hundred Up) – 0 793 893 993 |
| C | M11 | Descending 3-Digit-Block Triplet (One Down) – 0 794 793 792 |
| C | M11a | Descending 3-Digit-Block Triplet (Ten or Hundred Down) – 0 794 784 774 |
| C | M12 | 3 Straight Blocks at the End (7 digits) – 079 333 22 88 |
| D | M13 | 3 Straight 2-Digit Blocks at the End – 079 5 33 22 88 |
| D | M14 | 2 Identical 2-Digit Blocks at the End – 079 457 23 23 |
| D | M15 | Ascending 2-Digit-Block Triplet (One Up) – 079 6 63 64 65 |
| D | M15a | Ascending 2-Digit-Block Triplet (Ten Up) – 079 6 63 73 83 |
| D | M16 | Descending 2-Digit-Block Triplet (One Down) – 079 6 37 36 35 |
| D | M16a | Descending 2-Digit-Block Triplet (Ten Down) – 079 6 37 27 17 |
| D | M17 | Thousand Block at the End – 079 45 26 000 |
| E | M18 | Any numbers not classified in any of the above categories |
Intended Use
- Top numbers handling
- Out of the box or customizable top number definition algorithms
- Top numbers is a nice source of revenue for operators
- Top numbers search
- Interface can be made available to external systems, including self-care allowing customers to choose their own top number
Technical Requirements
- Works on top of an ERM installation but can also be adapted to work as a separate module on an existing resource management system
- An admin user in database who has privileges to create tables and stored procedures and has access to resource (MSISDNs) tables
Configuration Options
- Customizable number format
- Customizable number range
- Customizable target pool id
- TNC_SEARCH_MASK_MIN_DIGITS: Minimum number of initial digits, not including initial 0, for Top Number Classification.
- TNC_COMMIT_SIZE: Default value for commit size. Specifies how often entries should be committed in database during Top Number Classification.
- TNC_MAX_WARNINGS: Maximum number of warning reported in TNC_ERROR. Over this number warnings are not reported in details but with a summary warning
Professional Services
- Trainings delivered on customer sites for educating the operations personnel on the module
- Consulting services for supporting complicated top number pattern definitions and other customer requirements
- Remote support for configuration and troubleshooting