{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,21]],"date-time":"2025-06-21T22:40:09Z","timestamp":1750545609407,"version":"3.41.0"},"publisher-location":"Cham","reference-count":45,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783030791490"},{"type":"electronic","value":"9783030791506"}],"license":[{"start":{"date-parts":[[2021,1,1]],"date-time":"2021-01-01T00:00:00Z","timestamp":1609459200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2021,1,1]],"date-time":"2021-01-01T00:00:00Z","timestamp":1609459200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2021]]},"DOI":"10.1007\/978-3-030-79150-6_56","type":"book-chapter","created":{"date-parts":[[2021,6,21]],"date-time":"2021-06-21T23:35:17Z","timestamp":1624318517000},"page":"715-728","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["Recommending Database Architectures for Social Queries: A Twitter Case Study"],"prefix":"10.1007","author":[{"given":"Michael","family":"Marountas","sequence":"first","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0002-0975-1877","authenticated-orcid":false,"given":"Georgios","family":"Drakopoulos","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0002-6916-3129","authenticated-orcid":false,"given":"Phivos","family":"Mylonas","sequence":"additional","affiliation":[]},{"given":"Spyros","family":"Sioutas","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2021,6,22]]},"reference":[{"issue":"6","key":"56_CR1","doi-asserted-by":"publisher","first-page":"671","DOI":"10.1007\/s41324-016-0059-1","volume":"24","author":"S Agarwal","year":"2016","unstructured":"Agarwal, S., Rajan, K.: Performance analysis of MongoDB versus PostGIS\/PostgreSQL databases for line intersection and point containment spatial queries. Spat. Inf. Res. 24(6), 671\u2013677 (2016)","journal-title":"Spat. Inf. Res."},{"key":"56_CR2","doi-asserted-by":"crossref","unstructured":"Antonakaki, D., Fragopoulou, P., Ioannidis, S.: A survey of Twitter research: Data model, graph structure, sentiment analysis and attacks. Expert Syst. Appl. 164, (2021)","DOI":"10.1016\/j.eswa.2020.114006"},{"key":"56_CR3","doi-asserted-by":"crossref","unstructured":"Badawy, A., Ferrara, E., Lerman, K.: Analyzing the digital traces of political manipulation: The 2016 Russian interference Twitter campaign. In: ASONAM, pp. 258\u2013265. IEEE (2018)","DOI":"10.1109\/ASONAM.2018.8508646"},{"key":"56_CR4","series-title":"Lecture Notes in Electrical Engineering","doi-asserted-by":"publisher","first-page":"51","DOI":"10.1007\/978-981-15-8297-4_5","volume-title":"Recent Innovations in Computing","author":"S Bagga","year":"2021","unstructured":"Bagga, S., Sharma, A.: A comparative study of NoSQL databases. In: Singh, P.K., Singh, Y., Kolekar, M.H., Kar, A.K., Chhabra, J.K., Sen, A. (eds.) ICRIC 2020. LNEE, vol. 701, pp. 51\u201361. Springer, Singapore (2021). https:\/\/doi.org\/10.1007\/978-981-15-8297-4_5"},{"key":"56_CR5","series-title":"Communications in Computer and Information Science","doi-asserted-by":"publisher","first-page":"291","DOI":"10.1007\/978-3-030-19093-4_22","volume-title":"Beyond Databases, Architectures and Structures. Paving the Road to Smart Data Processing and Analysis","author":"D Bartoszewski","year":"2019","unstructured":"Bartoszewski, D., Piorkowski, A., Lupa, M.: The comparison of processing efficiency of spatial data for PostGIS and MongoDB databases. In: Kozielski, S., Mrozek, D., Kasprowski, P., Ma\u0142ysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2019. CCIS, vol. 1018, pp. 291\u2013302. Springer, Cham (2019). https:\/\/doi.org\/10.1007\/978-3-030-19093-4_22"},{"key":"56_CR6","doi-asserted-by":"publisher","first-page":"79182","DOI":"10.1109\/ACCESS.2020.2990799","volume":"8","author":"A Belhadi","year":"2020","unstructured":"Belhadi, A., Djenouri, Y., Lin, J.C.W., Cano, A.: A data-driven approach for Twitter hashtag recommendation. IEEE Access 8, 79182\u201379191 (2020)","journal-title":"IEEE Access"},{"key":"56_CR7","doi-asserted-by":"publisher","first-page":"68580","DOI":"10.1109\/ACCESS.2020.2983859","volume":"8","author":"M Bibi","year":"2020","unstructured":"Bibi, M., Aziz, W., Almaraashi, M., Khan, I.H., Nadeem, M.S.A., Habib, N.: A cooperative binary-clustering framework based on majority voting for Twitter sentiment analysis. IEEE Access 8, 68580\u201368592 (2020)","journal-title":"IEEE Access"},{"key":"56_CR8","unstructured":"Botoeva, E., Calvanese, D., Cogrel, B., Xiao, G.: Expressivity and complexity of MongoDB queries. In: ICDT. Schloss Dagstuhl-Leibniz-Zentrum f\u00fcr Informatik (2018)"},{"key":"56_CR9","doi-asserted-by":"crossref","unstructured":"Cheng, Y., Zhou, K., Wang, J.: Performance analysis of PostgreSQL and MongoDB databases for unstructured data. In: MBDASM. Atlantis Press (2019)","DOI":"10.2991\/mbdasm-19.2019.14"},{"key":"56_CR10","doi-asserted-by":"crossref","unstructured":"Clarke, I., Grieve, J.: Stylistic variation on the Donald Trump Twitter account: a linguistic analysis of tweets posted between 2009 and 2018. PLoS One 14(9), (2019)","DOI":"10.1371\/journal.pone.0222062"},{"key":"56_CR11","doi-asserted-by":"crossref","unstructured":"Co\u015fkun, \u0130., Sertok, S., Anbaro\u011flu, B.: k-nearest neighbour query performance analysis on a large scale taxi dataset: PostgreSQL vs MongoDB. International archives of the photogrammetry, remote sensing, and spatial information sciences (2019)","DOI":"10.5194\/isprs-archives-XLII-2-W13-1531-2019"},{"key":"56_CR12","doi-asserted-by":"publisher","unstructured":"Drakopoulos, D., Giotopoulos, K.C., Giannoukou, I., Sioutas, S.: Unsupervised discovery of semantically aware communities with tensor Kruskal decomposition: a case study in Twitter. SMAP. IEEE (2020). https:\/\/doi.org\/10.1109\/SMAP49528.2020.9248469","DOI":"10.1109\/SMAP49528.2020.9248469"},{"key":"56_CR13","doi-asserted-by":"publisher","unstructured":"Drakopoulos, G., Kafeza, E.: One dimensional cross-correlation methods for deterministic and stochastic graph signals with a Twitter application in Julia. SEEDA-CECNSM. IEEE (2020). https:\/\/doi.org\/10.1109\/SEEDA-CECNSM49515.2020.9221815","DOI":"10.1109\/SEEDA-CECNSM49515.2020.9221815"},{"issue":"3","key":"56_CR14","doi-asserted-by":"publisher","first-page":"491","DOI":"10.1007\/s12530-019-09274-9","volume":"11","author":"G Drakopoulos","year":"2019","unstructured":"Drakopoulos, G., et al.: A genetic algorithm for spatiosocial tensor clustering. Evol. Syst. 11(3), 491\u2013501 (2019). https:\/\/doi.org\/10.1007\/s12530-019-09274-9","journal-title":"Evol. Syst."},{"key":"56_CR15","doi-asserted-by":"crossref","unstructured":"Fotache, M., Cogean, D.: NoSQL and SQL databases for mobile applications. Case study: MongoDB versus PostgreSQL. Informatica Economica 17(2), 41\u201358 (2013)","DOI":"10.12948\/issn14531305\/17.2.2013.04"},{"issue":"12","key":"56_CR16","first-page":"1891","volume":"13","author":"M Freitag","year":"2020","unstructured":"Freitag, M., Bandle, M., Schmidt, T., Kemper, A., Neumann, T.: Adopting worst-case optimal joins in relational database systems. PVLDB 13(12), 1891\u20131904 (2020)","journal-title":"PVLDB"},{"key":"56_CR17","doi-asserted-by":"crossref","unstructured":"Gorbenko, A., Karpenko, A., Tarasyuk, O.: Analysis of trade-offs in fault-tolerant distributed computing and replicated databases. In: DESSERT, pp. 1\u20136. IEEE (2020)","DOI":"10.1109\/DESSERT50317.2020.9125078"},{"key":"56_CR18","doi-asserted-by":"publisher","first-page":"85","DOI":"10.1016\/j.ijinfomgt.2018.07.003","volume":"43","author":"P Grover","year":"2018","unstructured":"Grover, P., Kar, A.K., Davies, G.: Technology enabled health - Insights from Twitter analytics with a socio-technical perspective. Int. J. Inf. Manage. 43, 85\u201397 (2018)","journal-title":"Int. J. Inf. Manage."},{"key":"56_CR19","doi-asserted-by":"crossref","unstructured":"Jung, M.G., Youn, S.A., Bae, J., Choi, Y.L.: A study on data input and output performance comparison of MongoDB and PostgreSQL in the big data environment. In: DTA. IEEE (2015)","DOI":"10.1109\/DTA.2015.14"},{"key":"56_CR20","doi-asserted-by":"crossref","unstructured":"Kanade, A., Gopal, A., Kanade, S.: A study of normalization and embedding in MongoDB. In: IACC. IEEE (2014)","DOI":"10.1109\/IAdCC.2014.6779360"},{"key":"56_CR21","doi-asserted-by":"publisher","first-page":"67698","DOI":"10.1109\/ACCESS.2020.2983656","volume":"8","author":"A Karami","year":"2020","unstructured":"Karami, A., Lundy, M., Webb, F., Dwivedi, Y.K.: Twitter and research: a systematic literature review through text mining. IEEE Access 8, 67698\u201367717 (2020)","journal-title":"IEEE Access"},{"key":"56_CR22","doi-asserted-by":"crossref","unstructured":"Kearney, M.W.: rtweet: collecting and analyzing Twitter data. J. Open Source Softw. 4(42), 1829 (2019)","DOI":"10.21105\/joss.01829"},{"key":"56_CR23","doi-asserted-by":"crossref","unstructured":"Khan, H.U., Nasir, S., Nasim, K., Shabbir, D., Mahmood, A.: Twitter trends: S ranking algorithm analysis on real time data. Expert Syst. Appl. 164, 45\u201367 (2021)","DOI":"10.1016\/j.eswa.2020.113990"},{"key":"56_CR24","doi-asserted-by":"crossref","unstructured":"Khan, M.I., O\u2019Sullivan, B., Foley, S.N.: Towards modelling insiders behaviour as rare behaviour to detect malicious RDBMS access. In: Big Data, pp. 3094\u20133099. IEEE (2018)","DOI":"10.1109\/BigData.2018.8622047"},{"key":"56_CR25","doi-asserted-by":"publisher","unstructured":"Kontopoulos, S., Drakopoulos, G.: A space efficient scheme for graph representation. ICTAI. IEEE (2014). https:\/\/doi.org\/10.1109\/ICTAI.2014.52","DOI":"10.1109\/ICTAI.2014.52"},{"key":"56_CR26","doi-asserted-by":"publisher","unstructured":"Kyriazidou, I., Drakopoulos, G., Kanavos, A., Makris, C., Mylonas, P.: Towards predicting mentions to verified Twitter accounts: building prediction models over MongoDB with Keras. WEBIST. SCITEPRESS (2019). https:\/\/doi.org\/10.5220\/0007810200250033","DOI":"10.5220\/0007810200250033"},{"issue":"7","key":"56_CR27","first-page":"1224","volume":"31","author":"S Luo","year":"2018","unstructured":"Luo, S., Gao, Z.J., Gubanov, M., Perez, L.L., Jermaine, C.: Scalable linear algebra on a relational database system. TKDE 31(7), 1224\u20131238 (2018)","journal-title":"TKDE"},{"key":"56_CR28","unstructured":"Makris, A., Tserpes, K., Spiliopoulos, G., Anagnostopoulos, D.: Performance evaluation of MongoDB and PostgreSQL for spatio-temporal data. In: EDBT\/ICDT Workshops (2019)"},{"key":"56_CR29","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1007\/978-1-4842-4209-4_1","volume-title":"Developing Data Migrations and Integrations with Salesforce","author":"D Masri","year":"2019","unstructured":"Masri, D.: Relational databases and normalization. Developing Data Migrations and Integrations with Salesforce, pp. 1\u201311. Apress, Berkeley, CA (2019). https:\/\/doi.org\/10.1007\/978-1-4842-4209-4_1"},{"key":"56_CR30","doi-asserted-by":"publisher","first-page":"90","DOI":"10.1016\/j.fss.2017.09.008","volume":"351","author":"JM Medina","year":"2018","unstructured":"Medina, J.M., Barranco, C.D., Pons, O.: Indexing techniques to improve the performance of necessity-based fuzzy queries using classical indexing of RDBMS. Fuzzy Sets Syst. 351, 90\u2013107 (2018)","journal-title":"Fuzzy Sets Syst."},{"issue":"1","key":"56_CR31","doi-asserted-by":"publisher","first-page":"195","DOI":"10.1111\/sum.12485","volume":"35","author":"J Mills","year":"2019","unstructured":"Mills, J., Reed, M., Skaalsveen, K., Ingram, J.: The use of Twitter for knowledge exchange on sustainable soil management. Soil Use Manag. 35(1), 195\u2013203 (2019)","journal-title":"Soil Use Manag."},{"issue":"6","key":"56_CR32","doi-asserted-by":"publisher","first-page":"542","DOI":"10.1038\/s41567-018-0076-1","volume":"14","author":"ME Newman","year":"2018","unstructured":"Newman, M.E.: Network structure from rich but noisy data. Nat. Phys. 14(6), 542\u2013545 (2018)","journal-title":"Nat. Phys."},{"issue":"7","key":"56_CR33","doi-asserted-by":"publisher","first-page":"2485","DOI":"10.1007\/s10115-019-01429-z","volume":"62","author":"R Nugroho","year":"2020","unstructured":"Nugroho, R., Paris, C., Nepal, S., Yang, J., Zhao, W.: A survey of recent methods on deriving topics from Twitter: Algorithm to evaluation. Knowl. Inf. Syst. 62(7), 2485\u20132519 (2020)","journal-title":"Knowl. Inf. Syst."},{"key":"56_CR34","doi-asserted-by":"crossref","unstructured":"Osorio-Arjona, J., Horak, J., Svoboda, R., Garc\u00eda-Ru\u00edz, Y.: Social media semantic perceptions on Madrid Metro system: using Twitter data to link complaints to space. Sustainable Cities Society 64, (2021)","DOI":"10.1016\/j.scs.2020.102530"},{"key":"56_CR35","doi-asserted-by":"crossref","unstructured":"Ott, B.L.: The age of Twitter: Donald J. Trump and the politics of debasement. Critical Studi. Media Commun. 34(1), 59\u201368 (2017)","DOI":"10.1080\/15295036.2016.1266686"},{"issue":"9","key":"56_CR36","doi-asserted-by":"publisher","first-page":"3481","DOI":"10.1007\/s10115-020-01459-y","volume":"62","author":"B Rezaie","year":"2020","unstructured":"Rezaie, B., Zahedi, M., Mashayekhi, H.: Measuring time-sensitive user influence in Twitter. Knowl. Inf. Syst. 62(9), 3481\u20133508 (2020). https:\/\/doi.org\/10.1007\/s10115-020-01459-y","journal-title":"Knowl. Inf. Syst."},{"key":"56_CR37","unstructured":"Rutishauser, N., Noureldin, A.: TPC-H applied to MongoDB: How a NoSQL database performs. Department of Informatik Vertiefung, University Zurich, Technical report (2012)"},{"key":"56_CR38","doi-asserted-by":"crossref","unstructured":"Shanbhag, A., Madden, S., Yu, X.: A study of the fundamental performance characteristics of GPUs and CPUs for database analytics. In: SIGMOD, pp. 1617\u20131632 (2020)","DOI":"10.1145\/3318464.3380595"},{"key":"56_CR39","doi-asserted-by":"crossref","unstructured":"Sharma, M., Sharma, V.D., Bundele, M.M.: Performance analysis of RDBMS and NoSQL databases: PostgreSQL, MongoDB, and Neo4j. In: ICRAIE, pp. 1\u20135. IEEE (2018)","DOI":"10.1109\/ICRAIE.2018.8710439"},{"issue":"1","key":"56_CR40","doi-asserted-by":"publisher","first-page":"147","DOI":"10.1086\/694755","volume":"6","author":"G Stolee","year":"2018","unstructured":"Stolee, G., Caton, S.: Twitter, trump, and the base: a shift to a new form of presidential talk? Signs Soc. 6(1), 147\u2013165 (2018)","journal-title":"Signs Soc."},{"key":"56_CR41","doi-asserted-by":"crossref","unstructured":"Taipalus, T.: The effects of database complexity on SQL query formulation. J. Syst. Softw. 165, 110576 (2020)","DOI":"10.1016\/j.jss.2020.110576"},{"issue":"13","key":"56_CR42","first-page":"2168","volume":"11","author":"A Thomas","year":"2018","unstructured":"Thomas, A., Kumar, A.: A comparative evaluation of systems for scalable linear algebra-based analytics. PVLDB 11(13), 2168\u20132182 (2018)","journal-title":"PVLDB"},{"key":"56_CR43","doi-asserted-by":"crossref","unstructured":"Van der Veen, J.S., Van der Waaij, B., Meijer, R.J.: Sensor data storage performance: SQL or NoSQL, physical or virtual. In: International Conference on Cloud Computing. IEEE (2012)","DOI":"10.1109\/CLOUD.2012.18"},{"key":"56_CR44","doi-asserted-by":"publisher","first-page":"87","DOI":"10.1016\/j.chb.2019.08.006","volume":"102","author":"S Xu","year":"2020","unstructured":"Xu, S., Zhou, A.: Hashtag homophily in Twitter network: examining a controversial cause-related marketing campaign. Comput. Hum. Behav. 102, 87\u201396 (2020)","journal-title":"Comput. Hum. Behav."},{"issue":"4","key":"56_CR45","doi-asserted-by":"publisher","first-page":"613","DOI":"10.1016\/j.giq.2017.11.001","volume":"34","author":"U Yaqub","year":"2017","unstructured":"Yaqub, U., Chun, S.A., Atluri, V., Vaidya, J.: Analysis of political discourse on Twitter in the context of the 2016 US presidential elections. Gov. Inf. Q. 34(4), 613\u2013626 (2017)","journal-title":"Gov. Inf. Q."}],"container-title":["IFIP Advances in Information and Communication Technology","Artificial Intelligence Applications and Innovations"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-79150-6_56","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,21]],"date-time":"2025-06-21T22:02:53Z","timestamp":1750543373000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-030-79150-6_56"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021]]},"ISBN":["9783030791490","9783030791506"],"references-count":45,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-79150-6_56","relation":{},"ISSN":["1868-4238","1868-422X"],"issn-type":[{"type":"print","value":"1868-4238"},{"type":"electronic","value":"1868-422X"}],"subject":[],"published":{"date-parts":[[2021]]},"assertion":[{"value":"22 June 2021","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"AIAI","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"IFIP International Conference on Artificial Intelligence Applications and Innovations","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Hersonissos, Crete","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Greece","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2021","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"25 June 2021","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"27 June 2021","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"17","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"aiai2021","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/www.aiai2021.eu\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Single-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"easyacademia.org","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"113","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"50","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"11","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"44% - The value is computed by the equation \"Number of Full Papers Accepted \/ Number of Submissions Sent for Review * 100\" and then rounded to a whole number.","order":6,"name":"acceptance_rate_of_full_papers","label":"Acceptance Rate of Full Papers","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"2.7","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"2.8","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"No","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}