SociQL: A Query Language for the SocialWeb

  • Diego Serrano
  • Eleni Stroulia
  • Denilson Barbosa
  • Victor Guana
Part of the Mathematics in Industry book series (MATHINDUSTRY, volume 18)


Social-networking sites are becoming increasingly popular with users of all ages. With much of our social activity happening online, these sites are now becoming the subject of scholarly study and research. Unfortunately, despite the fact that they collect similar content and support similar relations and activities, the current generation of these sites are hard to query programmatically, offering limited views of their data, effectively becoming disconnected islands of information. We describe SociQL, a high-level query language, and a corresponding service, to which social-networking sites can subscribe, that supports the integrated representation, querying and exploration of disparate social networks. Unlike generic web query languages, SociQL is designed specifically to support the integration of networks through a common information model for the purpose of examining sociological questions, motivated by social theories. The paper discusses the design and rationale for the SociQL language elements and syntax, as well as our experience using the SociQL service to query a variety of social-network sites.


Social Network Social Network Analysis Query Language Query Result Object Identifier 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. 1.
    S. Abiteboul, R. Hull, and V. Vianu. Foundations of Databases. Addison-Wesley, 1995.Google Scholar
  2. 2.
    R. G. Adams. Placing Friendship in Context. Cambridge University Press, 1999.Google Scholar
  3. 3.
    A. Anagnostopoulos, R. Kumar, and M. Mahdian. Influence and correlation in social networks. In Proceeding of the 14th ACM SIGKDD international conference on Knowledge discovery and data mining, KDD ’08, pages 7–15, New York, NY, USA, 2008.Google Scholar
  4. 4.
    G. O. Arocena and A. O. Mendelzon. Weboql: Restructuring documents, databases, and webs. In Proceedings of the Fourteenth International Conference on Data Engineering, ICDE ’98, pages 24–33, Washington, DC, USA, 1998.Google Scholar
  5. 5.
    S. Auer, C. Bizer, G. Kobilarov, J. Lehmann, and Z. Ives. Dbpedia: A nucleus for a web of open data. In 6th International Semantic Web Conference, pages 11–15, Busan, Korea, 2007.Google Scholar
  6. 6.
    M. Berger and R. M. MacIver. Freedom and control in modern society. Octagon Books, New York, 1964.Google Scholar
  7. 7.
    I. Bhattacharya and L. Getoor. Collective entity resolution in relational data. ACM Transactions on Knowledge Discovery from Data (TKDD), 1(1):5–es, 2007.Google Scholar
  8. 8.
    U. Bojars and A. Passant. Sioc project: Semantically interlinked online communities. In Proceedings of the Second Multi-Agent Logics, Languages, and Organisations Federated Workshops, MALLOW ’09, pages 7–10, Turin, Italy, 2009.Google Scholar
  9. 9.
    S. Bortoli, H. Stoermer, P. Bouquet, and H. Wache. Foaf-o-matic - solving the identity problem in the foaf network. In Proceedings of the Fourth Italian Semantic Web Workshop, SWAP 2007, pages 130–139, Bari, Italy, 2007.Google Scholar
  10. 10.
    K. K. Cetina. Sociality with objects: Social relations in postsocial knowledge societies. Theory, Culture & Society, 14(4):1–30, November 1997.Google Scholar
  11. 11.
    N. A. Christakis and J. H. Fowler. Connected: The Surprising Power of Our Social Networks and How They Shape Our Lives. Little, Brown and Company, September 2009.Google Scholar
  12. 12.
    Facebook. Fql facebook developers wiki. Retrieved March 5, 2010, from:, 2007.
  13. 13.
    A. Flex. Computer software. Adobe Systems Incorporated, 2009.Google Scholar
  14. 14.
    V. Ganev, Z. Guo, D. Serrano, B. Tansey, D. Barbosa, and E. Stroulia. An environment for building, exploring and querying academic social networks. In Proceedings of the International Conference on Management of Emergent Digital EcoSystems, MEDES ’09, pages 282–289, Lyon, France, 2009.Google Scholar
  15. 15.
    H. Hwang, V. Hristidis, and Y. Papakonstantinou. Objectrank: a system for authority-based search on databases. In Proceedings of the 2006 ACM SIGMOD international conference on Management of data, pages 796–798. ACM, 2006.Google Scholar
  16. 16.
    J. J. Jung and J. Euzenat. Towards semantic social networks. In Proceedings of the 4th European conference on The Semantic Web, ESWC ’07, pages 267–280, Berlin, Heidelberg, 2007.Google Scholar
  17. 17.
    C. Kadushin. Making Connections: An Introduction to Social Network Concepts, Theories and Findings, chapter Some Basic Network Concepts and Propositions. Oxford University Press, 2011. In-press.Google Scholar
  18. 18.
    L. Katz. A new status index derived from sociometric analysis. Psychometrika, 18(1):39–43, 1953.zbMATHCrossRefGoogle Scholar
  19. 19.
    W.-S. Li, J. Shim, K. S. Candan, and Y. Hara. Webdb: A web query system and its modeling, language, and implementation. In Proceedings of the Advances in Digital Libraries Conference, ADL ’98, page 216, Washington, DC, USA, 1998.Google Scholar
  20. 20.
    M. McPherson, L. Smith-Lovin, and J. M. Cook. Birds of a feather: Homophily in social networks. Annual Review of Sociology, 27(1):415–444, 2001.CrossRefGoogle Scholar
  21. 21.
    L. Page, S. Brin, R. Motwani, and T. Winograd. The pagerank citation ranking: Bringing order to the web. Technical report, Stanford Digital Library Technologies Project, 1998.Google Scholar
  22. 22.
    J. Perez, M. Arenas, and C. Gutierrez. Semantics and complexity of sparql. In I. Cruz, S. Decker, D. Allemang, C. Preist, D. Schwabe, P. Mika, M. Uschold, and L. Aroyo, editors, The Semantic Web - ISWC 2006, Lecture Notes in Computer Science. Springer Berlin / Heidelberg, 2006.Google Scholar
  23. 23.
    R. Ronen and O. Shmueli. Soql: A language for querying and creating data in social networks. In Proceedings of the IEEE 25th International Conference on Data Engineering, ICDE ’09, pages 1595–1602, 2009.Google Scholar
  24. 24.
    A. Seaborne and E. Prud’hommeaux. SPARQL query language for RDF. W3C recommendation (January 2008).Google Scholar
  25. 25.
    Yahoo. Query language guide. Retrieved 4 April, 2010, from, 2008.

Copyright information

© Springer-Verlag Berlin Heidelberg 2012

Authors and Affiliations

  • Diego Serrano
    • 1
  • Eleni Stroulia
    • 1
  • Denilson Barbosa
    • 1
  • Victor Guana
    • 1
  1. 1.Computing Science DepartmentUniversity of AlbertaEdmontonCanada

Personalised recommendations