{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,22]],"date-time":"2026-04-22T04:56:42Z","timestamp":1776833802374,"version":"3.51.2"},"reference-count":45,"publisher":"MDPI AG","issue":"3","license":[{"start":{"date-parts":[[2018,8,1]],"date-time":"2018-08-01T00:00:00Z","timestamp":1533081600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"name":"Universitat Jaume I, Plan de Promoci\u00f3n de la Investigaci\u00f3n","award":["PREDOC\/2017\/28"],"award-info":[{"award-number":["PREDOC\/2017\/28"]}]},{"DOI":"10.13039\/501100010198","name":"Ministerio de Econom\u00eda, Industria y Competitividad, Gobierno de Espa\u00f1a","doi-asserted-by":"publisher","award":["TIN2017-88805-R"],"award-info":[{"award-number":["TIN2017-88805-R"]}],"id":[{"id":"10.13039\/501100010198","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Informatics"],"abstract":"<jats:p>Social Business Intelligence (SBI) enables companies to capture strategic information from public social networks. Contrary to traditional Business Intelligence (BI), SBI has to face the high dynamicity of both the social network\u2019s contents and the company\u2019s analytical requests, as well as the enormous amount of noisy data. Effective exploitation of these continuous sources of data requires efficient processing of the streamed data to be semantically shaped into insightful facts. In this paper, we propose a multidimensional formalism to represent and evaluate social indicators directly from fact streams derived in turn from social network data. This formalism relies on two main aspects: the semantic representation of facts via Linked Open Data and the support of OLAP-like multidimensional analysis models. Contrary to traditional BI formalisms, we start the process by modeling the required social indicators according to the strategic goals of the company. From these specifications, all the required fact streams are modeled and deployed to trace the indicators. The main advantages of this approach are the easy definition of on-demand social indicators, and the treatment of changing dimensions and metrics through streamed facts. We demonstrate its usefulness by introducing a real scenario user case in the automotive sector.<\/jats:p>","DOI":"10.3390\/informatics5030033","type":"journal-article","created":{"date-parts":[[2018,8,1]],"date-time":"2018-08-01T11:22:34Z","timestamp":1533122554000},"page":"33","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":10,"title":["Modeling Analytical Streams for Social Business Intelligence"],"prefix":"10.3390","volume":"5","author":[{"ORCID":"https:\/\/orcid.org\/0000-0003-2413-2799","authenticated-orcid":false,"given":"Indira","family":"Lanza-Cruz","sequence":"first","affiliation":[{"name":"Department de Llenguatges i Sistemes Inform\u00e0tics, Universitat Jaume I, 12071 Castell\u00f3 de la Plana, Spain"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-9155-269X","authenticated-orcid":false,"given":"Rafael","family":"Berlanga","sequence":"additional","affiliation":[{"name":"Department de Llenguatges i Sistemes Inform\u00e0tics, Universitat Jaume I, 12071 Castell\u00f3 de la Plana, Spain"}]},{"given":"Mar\u00eda Jos\u00e9","family":"Aramburu","sequence":"additional","affiliation":[{"name":"Department de\u2019Enginyeria i Ci\u00e8ncia dels Computadors, Universitat Jaume I, 12071 Castell\u00f3 de la Plana, Spain"}]}],"member":"1968","published-online":{"date-parts":[[2018,8,1]]},"reference":[{"key":"ref_1","unstructured":"Inmon, W. (2005). Building the Data Warehouse, John Wiley & Sons, Inc."},{"key":"ref_2","unstructured":"Kreps, J. (2018, June 11). Questioning the Lambda Architecture 2014. Available online: https:\/\/www.oreilly.com\/ideas\/questioning-the-lambda-architecture."},{"key":"ref_3","doi-asserted-by":"crossref","first-page":"1","DOI":"10.4018\/ijdwm.2015100101","article-title":"SLOD-BI: An Open Data Infrastructure for Enabling Social Business Intelligence","volume":"11","author":"Berlanga","year":"2015","journal-title":"Int. J. Data Warehous. Data Min."},{"key":"ref_4","doi-asserted-by":"crossref","unstructured":"Liu, X., Tang, K., Hancock, J., Han, J., Song, M., Xu, R., and Pokorny, B. (2013, January 2\u20135). A Text Cube Approach to Human, Social, Cultural Behavior in the Twitter Stream. Proceedings of the International Conference on Social Computing, Behavioral-Cultural Modeling, and Prediction, Washington, DC, USA.","DOI":"10.1007\/978-3-642-37210-0_35"},{"key":"ref_5","doi-asserted-by":"crossref","unstructured":"Rosenthal, S., Farra, N., and Nakov, P. (2017, January 3\u20134). SemEval-2017 Task 4: Sentiment Analysis in Twitter. Proceedings of the 11th International Workshop on Semantic Evaluations (SemEval-2017), Vancouver, BC, Canada.","DOI":"10.18653\/v1\/S17-2088"},{"key":"ref_6","doi-asserted-by":"crossref","first-page":"93","DOI":"10.1016\/j.csl.2013.04.001","article-title":"Ranked Wordnet graph for sentiment polarity classification in Twitter","volume":"28","year":"2014","journal-title":"Comp. Speech Lang."},{"key":"ref_7","doi-asserted-by":"crossref","unstructured":"Volkova, S., Bachrach, Y., Armstrong, M., and Sharma, V. (2015, January 25\u201330). Inferring Latent User Properties from Texts Published in Social Media. Proceedings of the Twenty-Ninth AAAI Conference on Artificial Intelligence, Austin, TX, USA.","DOI":"10.1609\/aaai.v29i1.9271"},{"key":"ref_8","unstructured":"Pennacchiotti, M., and Popescu, A.-M. (2011, January 17\u201321). A Machine Learning Approach to Twitter User Classification. Proceedings of the Fifth International AAAI Conference on Weblogs and Social Media, Catalonia, Spain."},{"key":"ref_9","doi-asserted-by":"crossref","first-page":"317","DOI":"10.1111\/jcom.12084","article-title":"Echo Chamber or Public Sphere? Predicting Political Orientation and Measuring Political Homophily in Twitter Using Big Data","volume":"64","author":"Colleoni","year":"2014","journal-title":"J. Commun."},{"key":"ref_10","unstructured":"Kapanipathi, P., Jain, P., and Venkataramani, A.C. (June, January 28). User interests identification on twitter using a hierarchical knowledge base. Proceedings of the 11th European Semantic Web Conference ESWC 2017, Portoro\u017e, Slovenia."},{"key":"ref_11","doi-asserted-by":"crossref","first-page":"64","DOI":"10.1016\/j.ins.2013.11.016","article-title":"Twitter spammer detection using data stream clustering","volume":"260","author":"Miller","year":"2014","journal-title":"Inf. Sci."},{"key":"ref_12","doi-asserted-by":"crossref","unstructured":"Varol, O., Ferrara, E., Davis, C., Menczer, F., and Flammini, A. (2018, June 11). Online Human-Bot Interactions: Detection, Estimation, and Characterization. Available online: https:\/\/arxiv.org\/abs\/1703.03107.","DOI":"10.1609\/icwsm.v11i1.14871"},{"key":"ref_13","doi-asserted-by":"crossref","first-page":"38","DOI":"10.1109\/MC.2016.183","article-title":"The DARPA Twitter Bot Challenge","volume":"49","author":"Subrahmanian","year":"2016","journal-title":"Computer"},{"key":"ref_14","doi-asserted-by":"crossref","first-page":"96","DOI":"10.1145\/2818717","article-title":"The Rise of Social Bots","volume":"59","author":"Ferrara","year":"2016","journal-title":"Commun. ACM"},{"key":"ref_15","doi-asserted-by":"crossref","unstructured":"Li, H., Mukherjee, A., Liu, B., Kornfield, R., and Emery, S. (2014, January 14\u201317). Detecting Campaign Promoters on Twitter using Markov Random Fields. Proceedings of the IEEE International Conference on Data Mining, Shenzhen, China.","DOI":"10.1109\/ICDM.2014.59"},{"key":"ref_16","doi-asserted-by":"crossref","first-page":"25","DOI":"10.1016\/j.dss.2016.07.005","article-title":"Identifying influencers in a social network: The value of real referral data","volume":"91","author":"Roelens","year":"2016","journal-title":"Decis. Support Syst."},{"key":"ref_17","doi-asserted-by":"crossref","first-page":"2216","DOI":"10.1109\/TKDE.2016.2556661","article-title":"TopicSketch: Real-Time Bursty Topic Detection from Twitter","volume":"28","author":"Xie","year":"2016","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"ref_18","doi-asserted-by":"crossref","unstructured":"Feng, W., Zhang, C., Zhang, W., Han, J., Wang, J., Aggarwal, C., and Huang, J. (2015, January 13\u201317). STREAMCUBE: Hierarchical spatio-temporal hashtag clustering for event exploration over the Twitter stream. Proceedings of the 2015 IEEE 31st International Conference on Data Engineering, Seoul, Korea.","DOI":"10.1109\/ICDE.2015.7113425"},{"key":"ref_19","doi-asserted-by":"crossref","unstructured":"Zhang, C., Zhou, G., Yuan, Q., Zhuang, H., Zheng, Y., Kaplan, L., Wang, S., and Han, J. (2016, January 17\u201321). GeoBurst: Real-Time Local Event Detection in Geo-Tagged Tweet Streams. Proceedings of the 39th International ACM SIGIR conference on Research and Development in Information Retrieval, Pisa, Italy.","DOI":"10.1145\/2911451.2911519"},{"key":"ref_20","doi-asserted-by":"crossref","first-page":"381","DOI":"10.1007\/s00778-013-0320-3","article-title":"Event detection over twitter social media streams","volume":"23","author":"Zhou","year":"2014","journal-title":"VLDB J."},{"key":"ref_21","doi-asserted-by":"crossref","first-page":"132","DOI":"10.1111\/coin.12017","article-title":"A Survey of Techniques for Event Detection in Twitter","volume":"31","author":"Atefeh","year":"2013","journal-title":"Comput. Intell."},{"key":"ref_22","doi-asserted-by":"crossref","first-page":"462","DOI":"10.1002\/asi.23186","article-title":"Real-time classification of Twitter trends","volume":"66","author":"Zubiaga","year":"2015","journal-title":"J. Assoc. Inf. Sci. Technol."},{"key":"ref_23","doi-asserted-by":"crossref","first-page":"70","DOI":"10.1016\/j.compenvurbsys.2015.01.002","article-title":"A scalable framework for spatiotemporal analysis of location-based social media data","volume":"51","author":"Cao","year":"2015","journal-title":"Comput. Environ. Urban Syst."},{"key":"ref_24","doi-asserted-by":"crossref","unstructured":"Smith, M.A. (2014). NodeXL: Simple Network Analysis for Social Media. Encyclopedia of Social Network Analysis and Mining, Springer.","DOI":"10.1007\/978-1-4614-6170-8_308"},{"key":"ref_25","doi-asserted-by":"crossref","first-page":"32","DOI":"10.1109\/MIS.2010.142","article-title":"Deductive and Inductive Stream Reasoning for Semantic Social Media Analytics","volume":"25","author":"Barbieri","year":"2010","journal-title":"IEEE Intell. Syst."},{"key":"ref_26","doi-asserted-by":"crossref","unstructured":"Smith, M.A., Shneiderman, B., Milic-Frayling, N., Mendes Rodrigues, E., Barash, V., Dunne, C., Capone, T., Perer, A., and Gleave, E. (2009, January 25\u201327). Analyzing (Social Media) Networks with NodeXL. Proceedings of the Fourth International Conference on Communities and Technologies, New York, NY, USA.","DOI":"10.1145\/1556460.1556497"},{"key":"ref_27","doi-asserted-by":"crossref","unstructured":"Berlanga, R., Aramburu, M., Llid\u00f3, D., and Garc\u00eda-Moya, L. (2014). Towards a Semantic Data Infrastructure for Social Business Intelligence. New Trends in Databases and Information Systems, Springer.","DOI":"10.1007\/978-3-319-01863-8_34"},{"key":"ref_28","doi-asserted-by":"crossref","first-page":"15","DOI":"10.1016\/j.knosys.2016.07.010","article-title":"Statistically-driven generation of multidimensional analytical schemas from linked data","volume":"110","author":"Nebot","year":"2016","journal-title":"Knowl.-Based Syst."},{"key":"ref_29","doi-asserted-by":"crossref","unstructured":"Francia, M., Gallinucci, E., Golfarelli, M., and Rizzi, S. (2016, January 13\u201317). Social Business Intelligence in Action. Proceedings of the Advanced Information Systems Engineering: 28th International Conference CAiSE, Ljubljana, Slovenia.","DOI":"10.1007\/978-3-319-39696-5_3"},{"key":"ref_30","doi-asserted-by":"crossref","first-page":"120","DOI":"10.1016\/j.is.2013.09.002","article-title":"Discovering OLAP dimensions in semi-structured data","volume":"44","author":"Scholl","year":"2014","journal-title":"Inf. Syst."},{"key":"ref_31","doi-asserted-by":"crossref","unstructured":"Mauri, A., Calbimonte, J., Dell\u2019Aglio, D., Balduini, M., Brambilla, M., and Della Valle, E. (2016, January 17\u201321). TripleWave: Spreading RDF Streams on the Web. Proceedings of the Semantic Web\u2014ISWC 2016. ISWC 2016, Kobe, Japan.","DOI":"10.1007\/978-3-319-46547-0_15"},{"key":"ref_32","doi-asserted-by":"crossref","unstructured":"Balduini, M., Della Valle, E., Dell\u2019Aglio, D., Tsytsarau, M., Palpanas, T., and Confalonieri, C. (2013). Social Listening of City Scale Events Using the Streaming Linked Data Framework, Springer.","DOI":"10.1007\/978-3-642-41338-4_1"},{"key":"ref_33","doi-asserted-by":"crossref","first-page":"13","DOI":"10.1109\/MIS.2010.151","article-title":"Social Media Analytics and Intelligence","volume":"25","author":"Zeng","year":"2010","journal-title":"IEEE Intell. Syst."},{"key":"ref_34","doi-asserted-by":"crossref","first-page":"75","DOI":"10.1016\/j.infsof.2017.06.001","article-title":"A software reference architecture for semantic-aware Big Data systems","volume":"90","author":"Nadal","year":"2017","journal-title":"Inf. Softw. Technol."},{"key":"ref_35","doi-asserted-by":"crossref","first-page":"42","DOI":"10.1145\/1107499.1107504","article-title":"The 8 Requirements of Real-Time Stream Processing","volume":"34","author":"Stonebraker","year":"2005","journal-title":"SIGMOD Rec."},{"key":"ref_36","unstructured":"Marz, N., and Warren, J. (2015). Big Data: Principles and Best Practices of Scalable Realtime Data Systems, Manning Publications Co.. [1st ed.]."},{"key":"ref_37","doi-asserted-by":"crossref","unstructured":"Javed, M.H., Lu, X., and Panda, D.K. (2017, January 5\u20138). Characterization of Big Data Stream Processing Pipeline: A Case Study using Flink, Kafka. Proceedings of the Fourth IEEE\/ACM International Conference on Big Data Computing, Applications, Technologies, New York, NY, USA.","DOI":"10.1145\/3148055.3148068"},{"key":"ref_38","unstructured":"Hebeler, J., Fisher, M., Blace, R., and Perez-Lopez, A. (2009). Semantic Web Programming, John Wiley & Sons."},{"key":"ref_39","unstructured":"(2018, June 20). DBPedia Live. Available online: https:\/\/wiki.dbpedia.org\/online-access\/DBpediaLive."},{"key":"ref_40","unstructured":"(2018, June 20). BabelNet Live. Available online: http:\/\/live.babelnet.org\/."},{"key":"ref_41","doi-asserted-by":"crossref","first-page":"1138","DOI":"10.1016\/j.datak.2010.07.007","article-title":"A framework for multidimensional design of data warehouses from ontologies","volume":"69","author":"Romero","year":"2010","journal-title":"Data Knowl. Eng."},{"key":"ref_42","doi-asserted-by":"crossref","first-page":"20","DOI":"10.1145\/1860702.1860705","article-title":"Querying RDF streams with C-SPARQL","volume":"39","author":"Barbieri","year":"2010","journal-title":"SIGMOD Rec."},{"key":"ref_43","unstructured":"(2018, June 20). OWL Language. Available online: https:\/\/www.w3.org\/OWL\/."},{"key":"ref_44","unstructured":"(2018, June 20). JSON-LD. Available online: https:\/\/json-ld.org\/."},{"key":"ref_45","unstructured":"(2018, June 20). Anaconda. Available online: https:\/\/anaconda.org\/."}],"container-title":["Informatics"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2227-9709\/5\/3\/33\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,11]],"date-time":"2025-10-11T15:15:48Z","timestamp":1760195748000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2227-9709\/5\/3\/33"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018,8,1]]},"references-count":45,"journal-issue":{"issue":"3","published-online":{"date-parts":[[2018,9]]}},"alternative-id":["informatics5030033"],"URL":"https:\/\/doi.org\/10.3390\/informatics5030033","relation":{"has-preprint":[{"id-type":"doi","id":"10.20944\/preprints201806.0419.v1","asserted-by":"object"}]},"ISSN":["2227-9709"],"issn-type":[{"value":"2227-9709","type":"electronic"}],"subject":[],"published":{"date-parts":[[2018,8,1]]}}}