Skip to main content
SpringerLink
Log in

Pattern Queries for Mobile Phone-Call Databases

  • Chapter
  • First Online:
Spatio-Temporal Databases

Part of the book series: SpringerBriefs in Computer Science ((BRIEFSCOMPUTER))

  • 1040 Accesses

Abstract

Call Detail Record (CDR) databases contain many millions of records with information about mobile phone calls, including the users’ location, when the call was made/received, and call duration, among other data. This huge amount of spatio-temporal data opens the door for the study of human trajectories on a large scale without the bias that other sources, like GPS or WLAN networks, introduce in the population studied. Furthermore, it provides a platform for the development of a wide variety of studies ranging from the spread of diseases to planning of public transportation. Nevertheless, previous work on spatio-temporal queries does not provide a framework flexible enough for expressing the complexity of human trajectories. In this chapter, we present Spatio-Temporal Pattern System (STPS) to query spatio-temporal patterns in very large CDR databases. STPS uses a regular-expression query language that is intuitive and that allows for any combination of spatial and temporal predicates with constraints, including the use of variables. The design of the language takes into consideration the layout of the areas being covered by the cellular towers, as well as “areas” that label places of interested (e.g. neighborhoods, parks). An extensive performance evaluation of the STPS shows that it can efficiently find very complex mobility patterns in large CDR databases.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
eBook
USD 16.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 16.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Dasgupta, K., Singh, R., Viswanathan, B., Chakraborty, D., Mukherjea, S., Nanavati, A.A., Joshi, A.: Social ties and their relevance to churn in mobile telecom networks. In: Proceedings of the International Conference on Extending Database Technology (EDBT), pp. 668–677 (2008). http://dx.doi.org/10.1145/1353343.1353424

  2. Nanavati, A.A., Gurumurthy, S., Das, G., Chakraborty, D., Dasgupta, K., Mukherjea, S., Joshi, A.: On the structural properties of massive telecom call graphs: findings and implications. In: Proceedings of the ACM International Conference on Information and Knowledge Management (CIKM), pp. 435–444. ACM (2006). http://dx.doi.org/10.1145/1183614.1183678

  3. Seshadri, M., Machiraju, S., Sridharan, A., Bolot, J., Faloutsos, C., Leskove, J.: Mobile call graphs: beyond power-law and lognormal distributions. In: Proceedings of the ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, pp. 596–604. ACM (2008). http://dx.doi.org/10.1145/1401890.1401963

  4. Gonzalez, M.C., Hidalgo, C.A., Barabasi, A.L.: Understanding individual human mobility patterns. Nature 453, 779–782 (2008). http://dx.doi.org/10.1038/nature06958

    Google Scholar 

  5. Halepovic, E., Williamson, C.: Characterizing and modeling user mobility in a cellular data network. In: Proceedings of the ACM International Workshop on Performance evaluation of wireless ad hoc, sensor, and ubiquitous networks (PE-WASUN), pp. 71–78. ACM (2005). http://dx.doi.org/10.1145/1089803.1089969

  6. Zang, H., Bolot, J.: Mining call and mobility data to improve paging efficiency in cellular networks. In: Proceedings of the ACM International Conference on Mobile Computing and Networking (MobiCom), pp. 123–134. ACM (2007). http://dx.doi.org/10.1145/1287853.1287868

  7. Knuth, D.E., Jr., J.H.M., Pratt, V.R.: Fast pattern matching in strings. SIAM J. Comput. 6(2), 323–350 (1977). http://dx.doi.org/10.1145/1146809.1146812

  8. Sadri, R., Zaniolo, C., Zarkesh, A., Adibi, J.: Expressing and optimizing sequence queries in database systems. ACM Trans. Database Syst. 29(2), 282–318 (2004). http://dx.doi.org/10.1145/1005566.1005568

  9. Seshadri, P., Livny, M., Ramakrishnan, R.: SEQ: A model for sequence databases. In: Proceedings of the IEEE International Conference on Data Engineering (ICDE), pp. 232–239. IEEE Computer Society (1995). http://dx.doi.org/10.1109/ICDE.1995.380388

  10. Agrawal, J., Diao, Y., Gyllstrom, D., Immerman, N.: Efficient pattern matching over event streams. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, pp. 147–160. ACM (2008). http://dx.doi.org/10.1145/1376616.1376634

  11. Erwig, M., Schneider, M.: Spatio-temporal predicates. IEEE Trans. on Knowl. and Data Eng. 14(4), 881–901 (2002). http://dx.doi.org/10.1109/TKDE.2002.1019220

  12. Mokhtar, H., Su, J., Ibarra, O.: On moving object queries. In: Proceedings of the ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems (PODS), pp. 188–198. ACM (2002). http://dx.doi.org/10.1145/543613.543638

  13. Hadjieleftheriou, M., Kollios, G., Bakalov, P., Tsotras, V.J.: Complex spatio-temporal pattern queries. In: Proceedings of the International Conference on Very Large Data Bases (VLDB), pp. 877–888 (2005).

    Google Scholar 

  14. Anagnostopoulos, A., Vlachos, M., Hadjieleftheriou, M., Keogh, E.J., Yu, P.S.: Global distance-based segmentation of trajectories. In: Proceedings of the ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, pp. 34–43. ACM (2006). http://dx.doi.org/10.1145/1150402.1150411

  15. Cai, Y., Ng, R.: Indexing spatio-temporal trajectories with Chebyshev polynomials. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, pp. 599–610. ACM (2004). http://dx.doi.org/10.1145/1007568.1007636

  16. Ni, J., Ravishankar, C.V.: PA-Tree: A parametric indexing scheme for spatio-temporal trajectories. In: Proceedings of the International Symposium on Advances in Spatial and Temporal Databases (SSTD), Lecture Notes in Computer Science, vol. 3633, pp. 254–272. Springer-Verlag Angra dos Reis, Brazil (2005). http://dx.doi.org/10.1007/11535331_15

  17. Vlachos, M., Kollios, G., Gunopulos, D.: Discovering similar multidimensional trajectories. In: Proceedings of the IEEE International Conference on Data Engineering (ICDE), pp. 673–684. IEEE Computer Society (2002). http://dx.doi.org/10.1109/ICDE.2002.994784

  18. Pfoser, D., Jensen, C.S., Theodoridis, Y.: Novel approaches in query processing for moving object trajectories. In: Proceedings of the International Conference on Very Large Data Bases (VLDB), pp. 395–406 (2000).

    Google Scholar 

  19. Hadjieleftheriou, M., Kollios, G., Tsotras, V.J., Gunopulos, D.: Indexing spatiotemporal archives. VLDB J. 15(2), 143–164 (2006). http://dx.doi.org/10.1007/s00778-004-0151-3

    Google Scholar 

  20. Tao, Y., Papadias, D.: MV3R-Tree: A spatio-temporal access method for timestamp and interval queries. In: Proceedings of the International Conference on Very Large Data Bases (VLDB), pp. 431–440 (2001)

    Google Scholar 

  21. du Mouza, C., Rigaux, P., Scholl, M.: Efficient evaluation of parameterized pattern queries. In: Proceedings of the ACM International Conference on Information and Knowledge Management (CIKM), pp. 728–735. ACM (2005). http://dx.doi.org/10.1145/1099554.1099731

Download references

Author information

Authors and Affiliations

  1. IBM Research Laboratory Brazil, Rio de Janeiro, RJ, Brazil

    Marcos R. Vieira

  2. Department of Computer Science and Engineering, Bourns College of Engineering, University of California, Riverside, CA, USA

    Vassilis J. Tsotras

Authors
  1. Marcos R. Vieira
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Vassilis J. Tsotras
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Marcos R. Vieira .

Rights and permissions

Reprints and permissions

Copyright information

© 2013 The Author(s)

About this chapter

Cite this chapter

Vieira, M.R., Tsotras, V.J. (2013). Pattern Queries for Mobile Phone-Call Databases. In: Spatio-Temporal Databases. SpringerBriefs in Computer Science. Springer, Cham. https://doi.org/10.1007/978-3-319-02408-0_3

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-02408-0_3

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-02407-3

  • Online ISBN: 978-3-319-02408-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation