A Study of Database Models for Social Network Analysis

  • Mariana D. A. Salgueiro Pontifícia Universidade Católica do Rio de Janeiro (PUC-Rio)
  • Sérgio Lifschitz Pontifícia Universidade Católica do Rio de Janeiro (PUC-Rio) http://orcid.org/0000-0003-3073-3734
  • Edward Hermann Haeusler Pontifícia Universidade Católica do Rio de Janeiro (PUC-Rio)
  • Verônica dos Santos Pontifícia Universidade Católica do Rio de Janeiro (PUC-Rio)
  • Alexandre A. P. Heine Pontifícia Universidade Católica do Rio de Janeiro (PUC-Rio)


This paper discusses conceptual and logical data models for social media datasets and applications. On the one hand, we focus on the data representation requirements from the available APIs of some social network systems. On the other hand, we consider those application requirements for information manipulation. We propose a conceptual meta-model and one possible instantiation. We also give preliminary practical results considering relational and graph database systems.

Palavras-chave: data model, conceptual model, social network


Angles, R., Prat-Pérez, A., Dominguez-Sal, D., and Larriba-Pey, J.-L. (2013). Benchmarking database systems for social network applications. In First International Workshop on Graph Data Management Experiences and Systems, page 15.

Borgatti, S. P. (2005). Centrality and network flow. Social Networks, 27(1):55-71.

Bouraga, S., Jureta, I., and Faulkner, S. (2016). Towards data portability between online social networks, a conceptual model of the portable user profile. Int. J. Virtual Communities Soc. Netw., 8(3):37–54.

Carr, C. T. and Hayes, R. A. (2015). Social media: Defining, developing, and divining. Atlantic Journal of Communication, 23(1):46-65.

Davoudian, A., Chen, L., and Liu, M. (2018). A survey on nosql stores. ACM Computing Surveys (CSUR), 51(2):1-43.

Fafalios, P., Iosifidis, V., Ntoutsi, E., and Dietze, S. (2018). Tweetskb: A public and large-scale rdf corpus of annotated tweets. In European Semantic Web Conference, pages 177-190. Springer.

Reinhardt, W., Varlemann, T., Moi, M., and Wilke, A. (2010). Modeling, obtaining and storing data from social media tools with artefact-actor-networks. In LWA 2010-Lernen, Wissen & Adaptivität, Workshop Proceedings, pages 323-330.

Stieglitz, S., Mirbabaie, M., Ross, B., and Neuberger, C. (2018). Social media analytics-challenges in topic discovery, data collection, and data preparation. International Journal of Information Management, 39:156-168.
Como Citar

Selecione um Formato
SALGUEIRO, Mariana D. A.; LIFSCHITZ, Sérgio; HAEUSLER, Edward Hermann; DOS SANTOS, Verônica; HEINE, Alexandre A. P.. A Study of Database Models for Social Network Analysis. In: SIMPÓSIO BRASILEIRO DE BANCO DE DADOS (SBBD), 37. , 2022, Búzios. Anais [...]. Porto Alegre: Sociedade Brasileira de Computação, 2022 . p. 397-402. ISSN 2763-8979. DOI: https://doi.org/10.5753/sbbd.2022.226197.