DB2SNA : an All-in-one Tool for Extraction and Aggregation of underlying Social Networks from Relational Databases

Rania Soussi 1 Etienne Cuvelier 1 Marie-Aude Aufaure 1 Amine Louati 2 Yves Lechevallier 2
1 MAS - Mathématiques Appliquées aux Systèmes - EA 4037
2 AxIS - Usage-centered design, analysis and improvement of information systems
CRISAM - Inria Sophia Antipolis - Méditerranée , Inria Paris-Rocquencourt
Abstract : In the enterprise context, People need to visualize different types of interactions between heterogeneous objects (e.g. product and site, customers and product, people interaction (social network)...). The existing approaches focus on social networks extraction using web doc- ument. However a considerable amount of information is stored in relational databases. Therefore, relational databases can be seen as rich sources for extracting a social network. The extracted network has in general a huge size which makes it difficult to analyze and visualize. An aggregation step is needed in order to have more understandable graphs. In this chapter, we propose a heterogeneous object graph extraction approach from a relational database and we present its application to extract social network. This step is followed by an aggregation step in order to improve the visualisation and the analyse of the extracted social network. Then, we aggregate the resulting network using the k-SNAP algorithm which produces a summarized graph.
Keywords : relational database graph database social network analy- sis graph extraction and aggregation
Document type :
Book sections
Complete list of metadatas

Cited literature [33 references]  Display  Hide  Download
https://hal-ecp.archives-ouvertes.fr/hal-00830599
Contributor : Marie-Aude Aufaure <>
Submitted on : Wednesday, June 5, 2013 - 2:15:08 PM
Last modification on : Friday, May 25, 2018 - 12:02:04 PM
Long-term archiving on : Friday, September 6, 2013 - 4:12:11 AM

File

DB2SNA.pdf
Files produced by the author(s)

Identifiers

  • HAL Id : hal-00830599, version 1

Collections

EC-PARIS | INRIA | INRIA-ROCQ

Citation

Rania Soussi, Etienne Cuvelier, Marie-Aude Aufaure, Amine Louati, Yves Lechevallier. DB2SNA : an All-in-one Tool for Extraction and Aggregation of underlying Social Networks from Relational Databases. The influence of technology on social network analysis and Mining, Springer, pp.521-546, 2013, 978-3-7091-1345-5. ⟨hal-00830599⟩

Export

BibTeX TEI DC DCterms EndNote

Share

Metrics

Record views

823

Files downloads

488

Contact

support.ccsd.cnrs.fr
hal.support@ccsd.cnrs.fr
Logo CCSD