Subscriber Data Management

To deliver highly personalized communication services, it is necessary to create and maintain a unified, 360 degree view of the subscriber. Not just their identity and billing information, but also their service entitlements, preferences, presence, usage patterns, contacts, device information, etc.

All of this subscriber information exists today, but is scattered across multiple data stores, including HLR/HSS, CRM systems, network elements, AAA (RADIUS, DIAMETER, etc.) systems, LDAP servers and web portals.

Consolidating this data into fewer centralized databases is critical to accelerate service delivery, reduce operational expense and enhance personalization and targeting.

Benefits of MySQL Cluster Carrier Grade Edition for Subscriber Data Management:

• Standards Based, Open Source database allows vendors and users of subscriber data management solutions to easily integrate their applications with MySQL Cluster CGE using their preferred database-independent Subscriber API, e.g., SQL, C++, Java, JavaScript, HTTP, etc.
• High Performance with a Shared-Nothing, Distributed Database that provides real-time access to in-memory subscriber data, and can be scaled out by adding additional resources or by storing data on disk.
• 99.999% Availability achieved by synchronously replicating in-memory data across active nodes in the cluster with recovery data being asynchronously written to disk, and by optionally "geo"-replicating data off-site to a remote active or standby cluster.
• Self-Healing of data nodes with sub-second fail-over times, and an optimized node recovery protocol that automatically re-synchronizes data across re-starting data nodes. Geo-replication enables self-healing across dispersed sites, where the system can continue functioning correctly in the event of site failure.
• Distribution-Awareness in a Shared-Nothing Database is enabled in MySQL Cluster with the partitioning of tables by subscriber identifiers, and by using those identifiers when accessing subscriber data to ensure that reads/writes are localized to the data node(s) containing the subscriber data.
• Relational Database technology supports mature tools for analyzing and mining customer data via an SQL interface.
• Lowest Total Cost of Ownership accomplished through the use of the MySQL database server and scale-out architectures that utilize low-cost commodity hardware, CSPs are finding that they can achieve amazing levels of scalability and performance, all at a cost that is far less than those offered by proprietary and scale-up software vendors.

Additional Resources

• White Paper: Building Subscriber Databases with MySQL Cluster Carrier Grade Edition