Encyclopedia of Social Network Analysis and Mining

2014 Edition
| Editors: Reda Alhajj, Jon Rokne

Transforming and Integrating Social Networks and Social Media Data

  • Mauro San Martín
  • Claudio Gutierrez
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-6170-8_389



Data Model

An abstraction that defines a data structure (data elements and their relations), a set of operations (a language), and a set of integrity constraints


Collection of data organized following a data model and collected and maintained with a purpose

Data Base Management System (DBMS)

A software system that implements a data model and provide data management services to other applications


Metadata that describes and defines the constraints (e.g., types, domains, and dependencies) over the data in a database

Transformation Language

A set of operations to map a database from one schema to another

Social Networks (SN)

A set of actors and the relations among them; both actors and relations may be described by attributes

Social Media

Social networks that include diverse types of media (e.g., text, photographies, and videos)



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


  1. Abiteboul S, Hull R, Vianu V (1995) Foundations of databases, 1st edn. Addison-Wesley, BostonzbMATHGoogle Scholar
  2. Amer-Yahia S, Lakshmanan LVS, Yu C (2009) SocialScope: enabling information discovery on social content sites. In: CIDR, Asilomar. http://www.crdrdb.org Google Scholar
  3. Angles R, Gutierrez C (2008) Survey of graph database models. ACM Comput Surv (CSUR) 40(1): 1–39Google Scholar
  4. Blau H, Immerman N, Jensen D (2002) A visual language for querying and updating graphs. Computer Science Technical Report 2002–037, University of Massachusetts, AmherstGoogle Scholar
  5. Consens MP, Mendelzon AO (1990) GraphLog: a visual formalism for real life recursion. In: PODS, Nashville. ACM, New York, pp 404–416Google Scholar
  6. de Nooy W, Mrvar A, Batagelj V (2005) Exploratory social network analysis with Pajek. Cambridge University Press, CambridgeGoogle Scholar
  7. Dries A, Nijssen S, Raedt LD (2009) A query language for analyzing networks. In: Cheung DWL, Song IY, Chu WW, Hu X, Lin JJ (eds) CIKM, Hong Kong. ACM, New York, pp 485–494Google Scholar
  8. Fagin R, Kolaitis PG, Popa L, Tan WC (2005) Composing schema mappings: second-order dependencies to the rescue. ACM Trans Database Syst 30(4): 994–1055Google Scholar
  9. Florescu D, Levy A, Mendelzon A (1998) Database techniques for the World-Wide Web: a survey. SIGMOD Rec 27(3):59–74Google Scholar
  10. Freeman LC (2004) The development of social network analysis. Empirical, VancouverGoogle Scholar
  11. Freeman LC (2011) The development of social network analysis - with an emphasis on recent events. In: Scott J, Carrington PJ (eds) The SAGE handbook of social network analysis. Sage, London, pp 26–39Google Scholar
  12. Freeman LC, Romney AK, Douglas R White (1992) Research methods in social network analysis. Transaction, New BrunswickGoogle Scholar
  13. Furche T, Bry F, Schaffert S, Orsini R, Horrocks I, Krauss M, Bolzer O (2004) Survey over existing query and transformation languages. http://rewerse.net/deliverables/m24/i4-d9a.pdf. Accesed 23 Jan 2013
  14. Guting R (1994) GraphDB: modeling and querying graphs in databases. In: 20th VLDB conference, Santiago de Chile, pp 297–308Google Scholar
  15. Lakshmanan LVS, Sadri F, Subramanian SN (2001) SchemaSQL: an extension to SQL for multidatabase interoperability. ACM Trans Database Syst 26(4): 476–519zbMATHGoogle Scholar
  16. Ronen R, Shmueli O (2009) SoQL: a language for querying and creating data in social networks. In: ICDE, Shanghai. IEEE, Piscataway, pp 1595–1602Google Scholar
  17. San Martín M (2012) A model for social networks data management. PhD thesis, Universidad de Chile. http://www.tesis.uchile.cl/handle/2250/111467
  18. San Martín M, Gutierrez C, Wood PT (2011) SNQL: a social networks query and transformation language. In: Barcelo P, Tannen V (eds) AMW, CEUR workshop proceedings, Santiago, vol 749. CEUR-WS.orgGoogle Scholar
  19. Scott J (2000) Social network analysis, 2nd edn. Sage, LondonGoogle Scholar
  20. Wasserman S, Faust K (1994) Social network analysis: methods and applications, 1st edn. Structural analysis in the social sciences. Cambridge University Press, CambridgeGoogle Scholar

Recommended Reading

  1. • For the base requirements for the common standard data model for SN&M data transformation and integration, see Freeman et al. (1992, Chap. 1).Google Scholar
  2. • For the complete discussion and formal definition of the common standard data model, see San Martín (2012).Google Scholar
  3. • For a discussion on transformation languages on the Web, see Florescu et al. (1998).Google Scholar

Copyright information

© Springer Science+Business Media New York 2014

Authors and Affiliations

  • Mauro San Martín
    • 1
  • Claudio Gutierrez
    • 2
  1. 1.Department of MathematicsUniversidad de La SerenaLa SerenaChile
  2. 2.Department of Computer ScienceUniversidad de ChileSantiagoChile