1. Data Modeling in Telecoms

2. AmanziTel / DingLi Customer Experience Management Cellular Telephone Networks Neo4j OEM since 2009 AmanziTel in Sweden DingLi in China 3. Who are we? 4. Playing on the Edge 5. AWE-2009 Neo4j graph database extremely high performance on deep traversals and mining of complex data, rapid schema evolution for changing business requirements, and simplified development through perfect match between domain model and database schema. 6. AWE-2009 7. Splash-Neo4j = a1 + ' ' + a2 = sum(a1..a3) 8. Neo4j Spatial 2010 9. Critical Infrastructure 2011-2012 10. Data Collection Process 11. Graph Data Models Cellular Network Topology Tree Geographic/Spatial Index OpenStreetMap User Access Management Event Log Correlation Network Management / Critical Infrastructure Business Intelligence / Statistics 12. Cellular Network Topology 13. Cellular Network Topology ID Site Latitude Longitude 1 ABC 55.678 12.567 2 XYZ 55.890 12.123 3 PRQ 55.543 12.890 ID Sector SiteID Azimuth Beamwidth 1 1 1 0 100 2 2 1 120 100 3 3 1 240 100 4 1 2 0 90 5 2 2 120 110 6 3 2 240 90 7 1 3 0 180 8 2 3 180 180 O(N) O(ln(N)) O(1) 14. = a1 + ' ' + a2 = sum(a1..a3) 15. Spatial Index 16. Spatial Index 17. Spatial Index 18. OpenStreetMap 19. OpenStreetMap 20. OpenStreetMap 21. OpenStreetMap OSM RTree namic ayers Dynamic Layers 22. Data Mining OSM timestamp > 1207014810000 and timestamp < 1208310810000 and ( user = 'Zenon' or user = 'tomasCY' or user = 'muffu' or user = 'dcp' or user = 'cartOMike' or user = 'djanda' or user = 'Peter14' or user = 'toaster' or user = 'user_7363' or user = 'lyx' ) 23. User Access Management 24. Event Log Correlation 25. Event Log Correlation 26. Event Log Correlation gps call sms 27. Network / Critical Infrastructure 28. Business Intelligence 29. Business Intelligence 30. Performance Implications Know your domain Know your queries Examples