{"id":"https://openalex.org/W2157700837","doi":"https://doi.org/10.1109/asonam.2012.230","title":"Building a Data Warehouse for Twitter Stream Exploration","display_name":"Building a Data Warehouse for Twitter Stream Exploration","publication_year":2012,"publication_date":"2012-08-01","ids":{"openalex":"https://openalex.org/W2157700837","doi":"https://doi.org/10.1109/asonam.2012.230","mag":"2157700837"},"language":"en","primary_location":{"id":"doi:10.1109/asonam.2012.230","doi":"https://doi.org/10.1109/asonam.2012.230","is_oa":false,"landing_page_url":"https://doi.org/10.1109/asonam.2012.230","pdf_url":null,"source":{"id":"https://openalex.org/S4363608003","display_name":"IEEE/ACM International Conference on Advances in Social Networks Analysis and Mining (ASONAM)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2012 IEEE/ACM International Conference on Advances in Social Networks Analysis and Mining","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://kops.uni-konstanz.de/server/api/core/bitstreams/d46a0284-c6ca-4457-b766-878c72286997/content","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5111192352","display_name":"Naseem Ur Rehman","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I189712700","display_name":"University of Konstanz","ror":"https://ror.org/0546hnb39","country_code":"DE","type":"education","lineage":["https://openalex.org/I189712700"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"N. U. Rehman","raw_affiliation_strings":["University of Konstanz, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Konstanz, Germany","institution_ids":["https://openalex.org/I189712700"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007836199","display_name":"Svetlana Mansmann","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I189712700","display_name":"University of Konstanz","ror":"https://ror.org/0546hnb39","country_code":"DE","type":"education","lineage":["https://openalex.org/I189712700"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"S. Mansmann","raw_affiliation_strings":["University of Konstanz, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Konstanz, Germany","institution_ids":["https://openalex.org/I189712700"]}]},{"author_position":"middle","author":{"id":null,"display_name":"A. Weiler","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I189712700","display_name":"University of Konstanz","ror":"https://ror.org/0546hnb39","country_code":"DE","type":"education","lineage":["https://openalex.org/I189712700"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"A. Weiler","raw_affiliation_strings":["University of Konstanz, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Konstanz, Germany","institution_ids":["https://openalex.org/I189712700"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071659666","display_name":"Marc H. Scholl","orcid":"https://orcid.org/0000-0002-4304-4092","observed_orcids":["https://orcid.org/0000-0002-4304-4092"]},"institutions":[{"id":"https://openalex.org/I189712700","display_name":"University of Konstanz","ror":"https://ror.org/0546hnb39","country_code":"DE","type":"education","lineage":["https://openalex.org/I189712700"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"M. H. Scholl","raw_affiliation_strings":["University of Konstanz, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Konstanz, Germany","institution_ids":["https://openalex.org/I189712700"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I189712700"],"apc_list":null,"apc_paid":null,"fwci":4.928,"has_fulltext":true,"cited_by_count":40,"citation_normalized_percentile":{"value":0.95443581,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1341","last_page":"1348"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9110999703407288,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9110999703407288,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.03060000017285347,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T14435","display_name":"Information Retrieval and Data Mining","score":0.012299999594688416,"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/data-warehouse","display_name":"data warehouse","score":0.8360000252723694},{"id":"https://openalex.org/keywords/twitter-streams","display_name":"tweet stream","score":0.7799999713897705},{"id":"https://openalex.org/keywords/social-network-analysis","display_name":"social network analysis","score":0.796999990940094},{"id":"https://openalex.org/keywords/multidimensional-model","display_name":"multidimensional model","score":0.7670000195503235},{"id":"https://openalex.org/keywords/olap","display_name":"OLAP","score":0.8029999732971191},{"id":"https://openalex.org/keywords/etl","display_name":"ETL","score":0.9319999814033508},{"id":"https://openalex.org/keywords/data-mining","display_name":"data mining","score":0.7170000076293945},{"id":"https://openalex.org/keywords/knowledge-discovery","display_name":"knowledge discovery","score":0.8899999856948853},{"id":"https://openalex.org/keywords/social-media-analytics","display_name":"social media analytics","score":0.6399999856948853},{"id":"https://openalex.org/keywords/data-cubes","display_name":"data cubes","score":0.4359999895095825}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8344693183898926},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8054894208908081},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8047800064086914},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.6643272638320923},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.586349606513977},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5860185623168945},{"id":"https://openalex.org/C120567893","wikidata":"https://www.wikidata.org/wiki/Q1582085","display_name":"Knowledge extraction","level":2,"score":0.5754892230033875},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.5338754653930664},{"id":"https://openalex.org/C518677369","wikidata":"https://www.wikidata.org/wiki/Q202833","display_name":"Social media","level":2,"score":0.5251402854919434},{"id":"https://openalex.org/C2777516300","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data discovery","level":3,"score":0.5105267763137817},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.5099102258682251},{"id":"https://openalex.org/C78168278","wikidata":"https://www.wikidata.org/wiki/Q5227269","display_name":"Data cube","level":2,"score":0.507777750492096},{"id":"https://openalex.org/C89198739","wikidata":"https://www.wikidata.org/wiki/Q3079880","display_name":"Data stream mining","level":2,"score":0.4414496123790741},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.43739891052246094},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3443848788738251},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.07911980152130127},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/asonam.2012.230","doi":"https://doi.org/10.1109/asonam.2012.230","is_oa":false,"landing_page_url":"https://doi.org/10.1109/asonam.2012.230","pdf_url":null,"source":{"id":"https://openalex.org/S4363608003","display_name":"IEEE/ACM International Conference on Advances in Social Networks Analysis and Mining (ASONAM)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2012 IEEE/ACM International Conference on Advances in Social Networks Analysis and Mining","raw_type":"proceedings-article"},{"id":"pmh:oai:kops.uni-konstanz.de:123456789/25232","doi":null,"is_oa":true,"landing_page_url":"http://nbn-resolving.de/urn:nbn:de:bsz:352-252327","pdf_url":"https://kops.uni-konstanz.de/server/api/core/bitstreams/d46a0284-c6ca-4457-b766-878c72286997/content","source":{"id":"https://openalex.org/S4306401487","display_name":"KOPS (University of Konstanz)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I189712700","host_organization_name":"University of Konstanz","host_organization_lineage":["https://openalex.org/I189712700"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"2012 IEEE/ACM International Conference on Advances in Social Networks Analysis and Mining. IEEE, 2012, S. 1341-1348. ISBN 978-1-4673-2497-7. Verf\u00fcgbar unter: doi: 10.1109/ASONAM.2012.230","raw_type":"doc-type:conferenceObject"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.1011.221","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.1011.221","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://kops.uni-konstanz.de/bitstream/handle/123456789/25232/Rehmann_252327.pdf%3Bjsessionid%3D070A91D68849E2EF144DBCBD4D15EF5F?sequence%3D2","raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:kops.uni-konstanz.de:123456789/25232","doi":null,"is_oa":true,"landing_page_url":"http://nbn-resolving.de/urn:nbn:de:bsz:352-252327","pdf_url":"https://kops.uni-konstanz.de/server/api/core/bitstreams/d46a0284-c6ca-4457-b766-878c72286997/content","source":{"id":"https://openalex.org/S4306401487","display_name":"KOPS (University of Konstanz)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I189712700","host_organization_name":"University of Konstanz","host_organization_lineage":["https://openalex.org/I189712700"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"2012 IEEE/ACM International Conference on Advances in Social Networks Analysis and Mining. IEEE, 2012, S. 1341-1348. ISBN 978-1-4673-2497-7. Verf\u00fcgbar unter: doi: 10.1109/ASONAM.2012.230","raw_type":"doc-type:conferenceObject"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2157700837.pdf","grobid_xml":"https://content.openalex.org/works/W2157700837.grobid-xml"},"referenced_works_count":18,"referenced_works":["https://openalex.org/W1508412218","https://openalex.org/W2008120802","https://openalex.org/W2018165284","https://openalex.org/W2046804949","https://openalex.org/W2101196063","https://openalex.org/W2116235440","https://openalex.org/W2119528150","https://openalex.org/W2127785456","https://openalex.org/W2128685975","https://openalex.org/W2137422308","https://openalex.org/W2138668415","https://openalex.org/W2151378814","https://openalex.org/W2151451758","https://openalex.org/W2153846040","https://openalex.org/W2170157136","https://openalex.org/W2336179579","https://openalex.org/W2986143039","https://openalex.org/W3162744413"],"related_works":["https://openalex.org/W7098332879","https://openalex.org/W7064066607","https://openalex.org/W1460085105","https://openalex.org/W2000731659","https://openalex.org/W2887975379","https://openalex.org/W4298203160","https://openalex.org/W2092589915","https://openalex.org/W2082481758","https://openalex.org/W2477497747","https://openalex.org/W2007973154"],"abstract_inverted_index":{"In":[0,135],"the":[1,16,24,52,64,99,125,140,144,157,181],"recent":[2],"year":[3],"Twitter":[4,37],"has":[5,14,38],"evolved":[6],"into":[7,147],"an":[8,80],"extremely":[9],"popular":[10],"social":[11,185],"network":[12],"and":[13,20,48,57,66,84,94,115,127,154],"revolutionized":[15],"ways":[17],"of":[18,35,42,63,78,92,142,150,168,183],"interacting":[19],"exchanging":[21],"information":[22],"on":[23],"Internet.":[25],"By":[26],"making":[27],"its":[28,55,106],"public":[29],"stream":[30,146],"available":[31],"through":[32],"a":[33,40,76,148,166],"set":[34,149],"APIs":[36],"triggered":[39],"wave":[41],"research":[43],"initiatives":[44],"aimed":[45],"at":[46],"analysis":[47,93],"knowledge":[49,95],"discovery":[50],"from":[51,118],"data":[53,102,109,117,126,128,159,182],"about":[54],"users":[56],"their":[58],"messaging":[59],"activities.":[60],"While":[61],"most":[62],"projects":[65],"tools":[67,130],"are":[68],"tailored":[69],"towards":[70],"solving":[71,165],"specific":[72],"tasks,":[73],"we":[74,138],"pursue":[75],"goal":[77],"providing":[79],"application":[81],"in":[82],"dependent":[83],"universal":[85],"analytical":[86,169],"platform":[87],"for":[88,113,123,131,164,179],"supporting":[89],"any":[90],"kind":[91],"discovery.":[96],"We":[97,171],"employ":[98],"well":[100],"established":[101],"warehousing":[103],"technology":[104],"with":[105],"underlying":[107],"multidimensional":[108,152],"model,":[110],"ETL":[111],"routine":[112],"loading":[114],"consolidating":[116],"different":[119],"sources,":[120],"OLAP":[121],"functionality":[122],"exploring":[124],"mining":[129],"more":[132],"sophisticated":[133],"analysis.":[134],"this":[136],"work":[137],"describe":[139],"process":[141],"transforming":[143],"original":[145],"related":[151],"cubes":[153],"demonstrate":[155],"how":[156],"resulting":[158],"warehouse":[160],"can":[161],"be":[162,177],"used":[163],"variety":[167],"tasks.":[170],"expect":[172],"our":[173],"proposed":[174],"approach":[175],"to":[176],"applicable":[178],"analyzing":[180],"other":[184],"networks":[186],"as":[187],"well.":[188]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":7},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2016-06-24T00:00:00"}