{"id":"https://openalex.org/W87770517","doi":"https://doi.org/10.1007/978-3-7091-1346-2_23","title":"DB2SNA: An All-in-One Tool for Extraction and Aggregation of Underlying Social Networks from Relational Databases","display_name":"DB2SNA: An All-in-One Tool for Extraction and Aggregation of Underlying Social Networks from Relational Databases","publication_year":2012,"publication_date":"2012-12-21","ids":{"openalex":"https://openalex.org/W87770517","doi":"https://doi.org/10.1007/978-3-7091-1346-2_23","mag":"87770517"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-7091-1346-2_23","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-7091-1346-2_23","pdf_url":null,"source":{"id":"https://openalex.org/S4210173728","display_name":"Lecture notes in social networks","issn_l":"2190-5428","issn":["2190-5428","2190-5436"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310321666","host_organization_name":"Springer Vienna","host_organization_lineage":["https://openalex.org/P4310321666","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Vienna","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Social Networks","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5058537042","display_name":"Rania Soussi","orcid":null},"institutions":[{"id":"https://openalex.org/I216852786","display_name":"\u00c9cole Centrale Paris","ror":"https://ror.org/00v0y5771","country_code":"FR","type":"education","lineage":["https://openalex.org/I216852786"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"Rania Soussi","raw_affiliation_strings":["Ecole Centrale Paris, MAS Laboratory, Business Intelligence Team, Grande Voie des Vignes, 92 295, Chatenay-Malabry, France"],"affiliations":[{"raw_affiliation_string":"Ecole Centrale Paris, MAS Laboratory, Business Intelligence Team, Grande Voie des Vignes, 92 295, Chatenay-Malabry, France","institution_ids":["https://openalex.org/I216852786"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074282574","display_name":"\u00c9tienne Cuvelier","orcid":null},"institutions":[{"id":"https://openalex.org/I216852786","display_name":"\u00c9cole Centrale Paris","ror":"https://ror.org/00v0y5771","country_code":"FR","type":"education","lineage":["https://openalex.org/I216852786"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Etienne Cuvelier","raw_affiliation_strings":["Ecole Centrale Paris, MAS Laboratory, Business Intelligence Team, Grande Voie des Vignes, 92 295, Chatenay-Malabry, France"],"affiliations":[{"raw_affiliation_string":"Ecole Centrale Paris, MAS Laboratory, Business Intelligence Team, Grande Voie des Vignes, 92 295, Chatenay-Malabry, France","institution_ids":["https://openalex.org/I216852786"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105833326","display_name":"Marie-Aude Aufaure","orcid":null},"institutions":[{"id":"https://openalex.org/I1326498283","display_name":"Institut national de recherche en informatique et en automatique","ror":"https://ror.org/02kvxyf05","country_code":"FR","type":"funder","lineage":["https://openalex.org/I1326498283"]},{"id":"https://openalex.org/I216852786","display_name":"\u00c9cole Centrale Paris","ror":"https://ror.org/00v0y5771","country_code":"FR","type":"education","lineage":["https://openalex.org/I216852786"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Marie-Aude Aufaure","raw_affiliation_strings":["Ecole Centrale Paris, MAS Laboratory, Business Intelligence Team, Grande Voie des Vignes, 92 295, Chatenay-Malabry, France","INRIA Paris-Rocquencourt, Axis Team, Domaine de Voluceau, 78150, Rocquencourt, France"],"affiliations":[{"raw_affiliation_string":"Ecole Centrale Paris, MAS Laboratory, Business Intelligence Team, Grande Voie des Vignes, 92 295, Chatenay-Malabry, France","institution_ids":["https://openalex.org/I216852786"]},{"raw_affiliation_string":"INRIA Paris-Rocquencourt, Axis Team, Domaine de Voluceau, 78150, Rocquencourt, France","institution_ids":["https://openalex.org/I1326498283"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056787683","display_name":"Amine Louati","orcid":null},"institutions":[{"id":"https://openalex.org/I1326498283","display_name":"Institut national de recherche en informatique et en automatique","ror":"https://ror.org/02kvxyf05","country_code":"FR","type":"funder","lineage":["https://openalex.org/I1326498283"]},{"id":"https://openalex.org/I83259278","display_name":"Manouba University","ror":"https://ror.org/0503ejf32","country_code":"TN","type":"education","lineage":["https://openalex.org/I83259278"]}],"countries":["FR","TN"],"is_corresponding":false,"raw_author_name":"Amine Louati","raw_affiliation_strings":["ENSI, RIADI-GDL Laboratory, Campus Universitaire de la Manouba, 2010, Manouba, Tunisia","INRIA Paris-Rocquencourt, Axis Team, Domaine de Voluceau, 78150, Rocquencourt, France"],"affiliations":[{"raw_affiliation_string":"ENSI, RIADI-GDL Laboratory, Campus Universitaire de la Manouba, 2010, Manouba, Tunisia","institution_ids":["https://openalex.org/I83259278"]},{"raw_affiliation_string":"INRIA Paris-Rocquencourt, Axis Team, Domaine de Voluceau, 78150, Rocquencourt, France","institution_ids":["https://openalex.org/I1326498283"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110144643","display_name":"Yves Lechevallier","orcid":null},"institutions":[{"id":"https://openalex.org/I1326498283","display_name":"Institut national de recherche en informatique et en automatique","ror":"https://ror.org/02kvxyf05","country_code":"FR","type":"funder","lineage":["https://openalex.org/I1326498283"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Yves Lechevallier","raw_affiliation_strings":["INRIA Paris-Rocquencourt, Axis Team, Domaine de Voluceau, 78150, Rocquencourt, France"],"affiliations":[{"raw_affiliation_string":"INRIA Paris-Rocquencourt, Axis Team, Domaine de Voluceau, 78150, Rocquencourt, France","institution_ids":["https://openalex.org/I1326498283"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5058537042"],"corresponding_institution_ids":["https://openalex.org/I216852786"],"apc_list":null,"apc_paid":null,"fwci":1.2803,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.80504587,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"521","last_page":"545"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10064","display_name":"Complex Network Analysis Techniques","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/3109","display_name":"Statistical and Nonlinear Physics"},"field":{"id":"https://openalex.org/fields/31","display_name":"Physics and Astronomy"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10064","display_name":"Complex Network Analysis Techniques","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/3109","display_name":"Statistical and Nonlinear Physics"},"field":{"id":"https://openalex.org/fields/31","display_name":"Physics and Astronomy"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.996399998664856,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13976","display_name":"Web visibility and informetrics","score":0.9731000065803528,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.721816897392273},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6419909000396729},{"id":"https://openalex.org/keywords/social-network","display_name":"Social network (sociolinguistics)","score":0.6053867340087891},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.5618161559104919},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.5244764685630798},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.5081307888031006},{"id":"https://openalex.org/keywords/graph-database","display_name":"Graph database","score":0.46844202280044556},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.46514761447906494},{"id":"https://openalex.org/keywords/deep-web","display_name":"Deep Web","score":0.457821249961853},{"id":"https://openalex.org/keywords/social-network-analysis","display_name":"Social network analysis","score":0.4457733929157257},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.44477930665016174},{"id":"https://openalex.org/keywords/product","display_name":"Product (mathematics)","score":0.4439104497432709},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.42318448424339294},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4128348231315613},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.357052206993103},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3129690885543823},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.2788551449775696},{"id":"https://openalex.org/keywords/social-media","display_name":"Social media","score":0.19033455848693848},{"id":"https://openalex.org/keywords/the-internet","display_name":"The Internet","score":0.18751990795135498},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.10445165634155273},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.09769418835639954}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.721816897392273},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6419909000396729},{"id":"https://openalex.org/C4727928","wikidata":"https://www.wikidata.org/wiki/Q17164759","display_name":"Social network (sociolinguistics)","level":3,"score":0.6053867340087891},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5618161559104919},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.5244764685630798},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.5081307888031006},{"id":"https://openalex.org/C176225458","wikidata":"https://www.wikidata.org/wiki/Q595971","display_name":"Graph database","level":3,"score":0.46844202280044556},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.46514761447906494},{"id":"https://openalex.org/C46721378","wikidata":"https://www.wikidata.org/wiki/Q221989","display_name":"Deep Web","level":3,"score":0.457821249961853},{"id":"https://openalex.org/C114713312","wikidata":"https://www.wikidata.org/wiki/Q7551269","display_name":"Social network analysis","level":3,"score":0.4457733929157257},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.44477930665016174},{"id":"https://openalex.org/C90673727","wikidata":"https://www.wikidata.org/wiki/Q901718","display_name":"Product (mathematics)","level":2,"score":0.4439104497432709},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.42318448424339294},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4128348231315613},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.357052206993103},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3129690885543823},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.2788551449775696},{"id":"https://openalex.org/C518677369","wikidata":"https://www.wikidata.org/wiki/Q202833","display_name":"Social media","level":2,"score":0.19033455848693848},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.18751990795135498},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10445165634155273},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.09769418835639954},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-3-7091-1346-2_23","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-7091-1346-2_23","pdf_url":null,"source":{"id":"https://openalex.org/S4210173728","display_name":"Lecture notes in social networks","issn_l":"2190-5428","issn":["2190-5428","2190-5436"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310321666","host_organization_name":"Springer Vienna","host_organization_lineage":["https://openalex.org/P4310321666","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Vienna","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Social Networks","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/10","score":0.44999998807907104,"display_name":"Reduced inequalities"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W143174683","https://openalex.org/W186400395","https://openalex.org/W1506843617","https://openalex.org/W1543676373","https://openalex.org/W1572711613","https://openalex.org/W1864092012","https://openalex.org/W1966860954","https://openalex.org/W1971421925","https://openalex.org/W1971937094","https://openalex.org/W2015455166","https://openalex.org/W2036461602","https://openalex.org/W2043748616","https://openalex.org/W2056433419","https://openalex.org/W2095293504","https://openalex.org/W2098061691","https://openalex.org/W2112090702","https://openalex.org/W2114507260","https://openalex.org/W2115482205","https://openalex.org/W2121947440","https://openalex.org/W2125050594","https://openalex.org/W2125580539","https://openalex.org/W2127048411","https://openalex.org/W2127218421","https://openalex.org/W2130426318","https://openalex.org/W2130966700","https://openalex.org/W2132914434","https://openalex.org/W2134877269","https://openalex.org/W2142276227","https://openalex.org/W2148606196","https://openalex.org/W2150475776","https://openalex.org/W2165734786","https://openalex.org/W2165874743","https://openalex.org/W2170726034","https://openalex.org/W2294734161","https://openalex.org/W3102641634","https://openalex.org/W4242038295"],"related_works":["https://openalex.org/W2952662149","https://openalex.org/W4281562483","https://openalex.org/W2793616590","https://openalex.org/W2800353001","https://openalex.org/W2183090405","https://openalex.org/W2075666982","https://openalex.org/W2065835655","https://openalex.org/W3160699245","https://openalex.org/W2782955270","https://openalex.org/W2349928170"],"abstract_inverted_index":null,"counts_by_year":[{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}