{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,19]],"date-time":"2025-06-19T04:07:56Z","timestamp":1750306076148,"version":"3.41.0"},"publisher-location":"New York, New York, USA","reference-count":62,"publisher":"ACM Press","license":[{"start":{"date-parts":[[2017,1,1]],"date-time":"2017-01-01T00:00:00Z","timestamp":1483228800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"name":"COMPETE","award":["POCI-01-0145- FEDER- 007043"],"award-info":[{"award-number":["POCI-01-0145- FEDER- 007043"]}]},{"name":"FCT","award":["UID\/CEC\/00319\/2013"],"award-info":[{"award-number":["UID\/CEC\/00319\/2013"]}]},{"DOI":"10.13039\/501100001871","name":"Fundacao para a Ciencia e a Tecnologia","doi-asserted-by":"publisher","award":["MITP-TB\/CS\/0026\/2013"],"award-info":[{"award-number":["MITP-TB\/CS\/0026\/2013"]}],"id":[{"id":"10.13039\/501100001871","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2017]]},"DOI":"10.1145\/3105831.3105841","type":"proceedings-article","created":{"date-parts":[[2017,7,28]],"date-time":"2017-07-28T19:35:01Z","timestamp":1501270501000},"page":"264-273","source":"Crossref","is-referenced-by-count":17,"title":["The SusCity Big Data Warehousing Approach for Smart Cities"],"prefix":"10.1145","author":[{"given":"Carlos","family":"Costa","sequence":"first","affiliation":[{"name":"ALGORITMI Research Centre, University of Minho, Guimar\u00e3es, Portugal"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Maribel Yasmina","family":"Santos","sequence":"additional","affiliation":[{"name":"ALGORITMI Research Centre, University of Minho, Guimar\u00e3es, Portugal"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","reference":[{"key":"key-10.1145\/3105831.3105841-1","unstructured":"Anderson, J.C. et al. 2010. CouchDB: the definitive guide. O'Reilly Media, Inc."},{"key":"key-10.1145\/3105831.3105841-2","unstructured":"Apache Kafka Homepage: 2017. https:\/\/kafka.apache.org\/. Accessed: 2017-03-05."},{"key":"key-10.1145\/3105831.3105841-3","doi-asserted-by":"crossref","unstructured":"Cattell, R. 2011. Scalable SQL and NoSQL data stores. ACM SIGMOD Record. 39, 4 (2011), 12--27.","DOI":"10.1145\/1978915.1978919"},{"key":"key-10.1145\/3105831.3105841-4","unstructured":"Chart.js | Open source HTML5 Charts: 2017. http:\/\/www.chartjs.org\/. Accessed: 2017-03-05."},{"key":"key-10.1145\/3105831.3105841-5","unstructured":"Cheng, B. et al. 2015. Building a big data platform for smart cities: Experience and lessons from santander. Big Data (BigData Congress), 2015 IEEE International Congress on (2015), 592--599."},{"key":"key-10.1145\/3105831.3105841-6","unstructured":"Chevalier, M. et al. 2017. Document-oriented Models for Data Warehouses - NoSQL Document-oriented for Data Warehouses. (Mar. 2017), 142--149."},{"key":"key-10.1145\/3105831.3105841-7","unstructured":"Chevalier, M. et al. 2015. Implementing multidimensional data warehouses into NoSQL. International Conference on Enterprise Information Systems (ICEIS 2015) (2015), 172--183."},{"key":"key-10.1145\/3105831.3105841-8","unstructured":"Clegg, D. 2015. Evolving data warehouse and BI architectures: The big data challenge. TDWI Business Intelligence Journal. 20, 1 (2015), 19--24."},{"key":"key-10.1145\/3105831.3105841-9","doi-asserted-by":"crossref","unstructured":"Costa, C. and Santos, M.Y. 2017. A Conceptual Model for the Professional Profile of a Data Scientist. (Apr. 2017).","DOI":"10.1007\/978-3-319-56538-5_46"},{"key":"key-10.1145\/3105831.3105841-10","doi-asserted-by":"crossref","unstructured":"Costa, C. and Santos, M.Y. 2016. BASIS: A big data architecture for smart cities. 2016 SAI Computing Conference (SAI) (Jul. 2016), 1247--1256.","DOI":"10.1109\/SAI.2016.7556139"},{"key":"key-10.1145\/3105831.3105841-11","unstructured":"Costa, C. and Santos, M.Y. 2015. Improving cities sustainability through the use of data mining in a context of big city data. The 2015 International Conference of Data Mining and Knowledge Engineering (2015), 320--325."},{"key":"key-10.1145\/3105831.3105841-12","unstructured":"Costa, C. and Santos, M.Y. 2016. Reinventing the Energy Bill in Smart Cities with NoSQL Technologies. Transactions on Engineering Technologies. S. Ao et al., eds. Springer Singapore. 383--396."},{"key":"key-10.1145\/3105831.3105841-13","doi-asserted-by":"crossref","unstructured":"Dean, J. and Ghemawat, S. 2008. MapReduce: Simplified Data Processing on Large Clusters. Commun. ACM. 51, 1 (Jan. 2008), 107--113.","DOI":"10.1145\/1327452.1327492"},{"key":"key-10.1145\/3105831.3105841-14","doi-asserted-by":"crossref","unstructured":"Floratou, A. et al. 2014. SQL-on-Hadoop: Full Circle Back to Shared-nothing Database Architectures. Proc. VLDB Endow. 7, 12 (Aug. 2014), 1295--1306.","DOI":"10.14778\/2732977.2733002"},{"key":"key-10.1145\/3105831.3105841-15","unstructured":"Foo, A. 2013. Is the data warehouse dead? IBM Data Management Magazine. 5 (2013)."},{"key":"key-10.1145\/3105831.3105841-16","unstructured":"Girtelschmid, S. et al. 2013. Big data in large scale intelligent smart city installations. Proceedings of International Conference on Information Integration and Web-based Applications & Services (2013), 428."},{"key":"key-10.1145\/3105831.3105841-17","unstructured":"Golab, L. and Johnson, T. 2014. Data stream warehousing. 2014 IEEE 30th International Conference on Data Engineering (ICDE) (Mar. 2014), 1290--1293."},{"key":"key-10.1145\/3105831.3105841-18","unstructured":"Google Maps JavaScript API: 2017. https:\/\/developers.google.com\/maps\/documentation\/javascript\/. Accessed: 2017-03-05."},{"key":"key-10.1145\/3105831.3105841-19","unstructured":"Goss, R.G. and Veeramuthu, K. 2013. Heading towards big data building a better data warehouse for more data, more speed, and more users. Advanced Semiconductor Manufacturing Conference (ASMC), 2013 24th Annual SEMI (2013), 220--225."},{"key":"key-10.1145\/3105831.3105841-20","unstructured":"Gröger, C. et al. 2014. The Deep Data Warehouse: Link-Based Integration and Enrichment of Warehouse Data and Unstructured Content. IEEE 18th International Enterprise Distributed Object Computing Conference (EDOC) (Sep. 2014), 210--217."},{"key":"key-10.1145\/3105831.3105841-21","unstructured":"Hall, M. et al. 2009. The WEKA data mining software: an update. ACM SIGKDD explorations newsletter. 11, 1 (2009), 10--18."},{"key":"key-10.1145\/3105831.3105841-22","unstructured":"Hevner, A.R. et al. 2004. Design Science in Information Systems Research. MIS Q. 28, 1 (Mar. 2004), 75--105."},{"key":"key-10.1145\/3105831.3105841-23","unstructured":"Hive Transactions - Apache Hive - Apache Software Foundation: 2017. https:\/\/cwiki.apache.org\/confluence\/display\/Hive\/Hive+Transactions. Accessed: 2017-01-30."},{"key":"key-10.1145\/3105831.3105841-24","unstructured":"Hortonworks 2016. Solving Apache Hadoop Security: A Holistic Approach to a Secure Data Lake. Hortonworks."},{"key":"key-10.1145\/3105831.3105841-25","doi-asserted-by":"crossref","unstructured":"Huai, Y. et al. 2014. Major Technical Advancements in Apache Hive. Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data (New York, NY, USA, 2014), 1235--1246.","DOI":"10.1145\/2588555.2595630"},{"key":"key-10.1145\/3105831.3105841-26","unstructured":"Jara, A.J. et al. 2013. Determining human dynamics through the internet of things. Proceedings of the 2013 IEEE\/WIC\/ACM International Joint Conferences on Web Intelligence (WI) and Intelligent Agent Technologies (IAT)-Volume 03 (2013), 109--113."},{"key":"key-10.1145\/3105831.3105841-27","unstructured":"jQuery: 2017. https:\/\/jquery.com\/. Accessed: 2017-03-05."},{"key":"key-10.1145\/3105831.3105841-28","unstructured":"Kearney, M. 2012. Embracing big data from the warehouse. IBM Data Management Magazine."},{"key":"key-10.1145\/3105831.3105841-29","unstructured":"Khan, Z. et al. 2013. Cloud based big data analytics for smart future cities. Proceedings of the 2013 IEEE\/ACM 6th international conference on utility and cloud computing (2013), 381--386."},{"key":"key-10.1145\/3105831.3105841-30","unstructured":"Kimball, R. and Ross, M. 2013. The data warehouse toolkit: The definitive guide to dimensional modeling. John Wiley & Sons."},{"key":"key-10.1145\/3105831.3105841-31","unstructured":"Kobielus, J. 2012. Hadoop: Nucleus of the next-generation big data warehouse. IBM Data Management Magazine."},{"key":"key-10.1145\/3105831.3105841-32","unstructured":"Kornacker, M. et al. 2015. Impala: A modern, open-source sql engine for hadoop. Proc. CIDR'15 (California, USA, 2015)."},{"key":"key-10.1145\/3105831.3105841-33","doi-asserted-by":"crossref","unstructured":"Krishnan, K. 2013. Data Warehousing in the Age of Big Data. Morgan Kaufmann Publishers Inc.","DOI":"10.1016\/B978-0-12-405891-0.00006-4"},{"key":"key-10.1145\/3105831.3105841-34","doi-asserted-by":"crossref","unstructured":"Li, X. and Mao, Y. 2015. Real-Time data ETL framework for big realtime data analysis. 2015 IEEE International Conference on Information and Automation (Aug. 2015), 1289--1294.","DOI":"10.1109\/ICInfA.2015.7279485"},{"key":"key-10.1145\/3105831.3105841-35","unstructured":"Lipcon, T. et al. 2015. Kudu: Storage for Fast Analytics on Fast Data. Cloudera."},{"key":"key-10.1145\/3105831.3105841-36","doi-asserted-by":"crossref","unstructured":"Madden, S. 2012. From databases to big data. IEEE Internet Computing. 16, 3 (2012), 4--6.","DOI":"10.1109\/MIC.2012.50"},{"key":"key-10.1145\/3105831.3105841-37","unstructured":"Marz, N. and Warren, J. 2015. Big Data: Principles and best practices of scalable realtime data systems. Manning Publications Co."},{"key":"key-10.1145\/3105831.3105841-38","doi-asserted-by":"crossref","unstructured":"Mohanty, S. et al. 2013. Big Data imperatives: enterprise Big Data warehouse, BI implementations and analytics. Apress.","DOI":"10.1007\/978-1-4302-4873-6"},{"key":"key-10.1145\/3105831.3105841-39","unstructured":"NBD-PWG 2015. NIST Big Data Interoperability Framework: Volume 6, Reference Architecture. Technical Report #NIST SP 1500-6. National Institute of Standards and Technology."},{"key":"key-10.1145\/3105831.3105841-40","doi-asserted-by":"crossref","unstructured":"Peffers, K. et al. 2007. A Design Science Research Methodology for Information Systems Research. J. Manage. Inf. Syst. 24, 3 (Dec. 2007), 45--77.","DOI":"10.2753\/MIS0742-1222240302"},{"key":"key-10.1145\/3105831.3105841-41","doi-asserted-by":"crossref","unstructured":"Philip Chen, C.L. and Zhang, C.-Y. 2014. Data-intensive applications, challenges, techniques and technologies: A survey on Big Data. Information Sciences. 275, (Aug. 2014), 314--347.","DOI":"10.1016\/j.ins.2014.01.015"},{"key":"key-10.1145\/3105831.3105841-42","unstructured":"Presto | Distributed SQL Query Engine for Big Data: 2016. https:\/\/prestodb.io\/. Accessed: 2016-10-23."},{"key":"key-10.1145\/3105831.3105841-43","doi-asserted-by":"crossref","unstructured":"Qiao, L. et al. 2015. Gobblin: Unifying data ingestion for Hadoop. Proceedings of the VLDB Endowment. 8, 12 (2015), 1764--1769.","DOI":"10.14778\/2824032.2824073"},{"key":"key-10.1145\/3105831.3105841-44","unstructured":"Russom, P. 2016. Data Warehouse Modernization in the Age of Big Data Analytics. The Data Warehouse Institute."},{"key":"key-10.1145\/3105831.3105841-45","unstructured":"Russom, P. 2014. Evolving Data Warehouse Architectures in the Age of Big Data. The Data Warehouse Institute."},{"key":"key-10.1145\/3105831.3105841-46","unstructured":"Santos, M.Y. and Costa, C. 2016. Data Models in NoSQL Databases for Big Data Contexts. 2016 International Conference of Data Mining and Big Data (DMBD) (2016), 1--11."},{"key":"key-10.1145\/3105831.3105841-47","unstructured":"Santos, M.Y. and Costa, C. 2016. Data Warehousing in Big Data: From Multidimensional to Tabular Data Models. Ninth International C* Conference on Computer Science & Software Engineering (C3S2E) (2016), 51--60."},{"key":"key-10.1145\/3105831.3105841-48","doi-asserted-by":"crossref","unstructured":"Shanahan, J.G. and Dai, L. 2015. Large scale distributed data science using apache spark. Proceedings of the 21th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining (2015), 2323--2324.","DOI":"10.1145\/2783258.2789993"},{"key":"key-10.1145\/3105831.3105841-49","unstructured":"Shvachko, K. et al. 2010. The Hadoop Distributed File System. 2010 IEEE 26th Symposium on Mass Storage Systems and Technologies (MSST) (May 2010), 1--10."},{"key":"key-10.1145\/3105831.3105841-50","doi-asserted-by":"crossref","unstructured":"Simmhan, Y. et al. 2013. Cloud-based software platform for big data analytics in smart grids. Computing in Science & Engineering. 15, 4 (2013), 38--47.","DOI":"10.1109\/MCSE.2013.39"},{"key":"key-10.1145\/3105831.3105841-51","doi-asserted-by":"crossref","unstructured":"Song, J. et al. 2015. HaoLap: A Hadoop based OLAP system for big data. Journal of Systems and Software. 102, (Apr. 2015), 167--181.","DOI":"10.1016\/j.jss.2014.09.024"},{"key":"key-10.1145\/3105831.3105841-52","unstructured":"SUSCITY -- An MIT Portugal Project: 2016. http:\/\/suscity-project.eu\/inicio\/. Accessed: 2016-05-04."},{"key":"key-10.1145\/3105831.3105841-53","unstructured":"Talend Open Studio for Big Data Product Details: 2017. https:\/\/www.talend.com\/download_page_type\/talend-open-studio\/. Accessed: 2017-03-05."},{"key":"key-10.1145\/3105831.3105841-54","doi-asserted-by":"crossref","unstructured":"Thusoo, A. et al. 2010. Data Warehousing and Analytics Infrastructure at Facebook. Proceedings of the 2010 ACM SIGMOD International Conference on Management of Data (New York, NY, USA, 2010), 1013--1020.","DOI":"10.1145\/1807167.1807278"},{"key":"key-10.1145\/3105831.3105841-55","unstructured":"Thusoo, A. et al. 2010. Hive-a petabyte scale data warehouse using hadoop. IEEE 26th International Conference on Data Engineering (ICDE) (2010), 996--1005."},{"key":"key-10.1145\/3105831.3105841-56","doi-asserted-by":"crossref","unstructured":"Vilajosana, I. et al. 2013. Bootstrapping smart cities through a self-sustainable model based on big data flows. IEEE Communications magazine. 51, 6 (2013), 128--134.","DOI":"10.1109\/MCOM.2013.6525605"},{"key":"key-10.1145\/3105831.3105841-57","doi-asserted-by":"crossref","unstructured":"Wang, H. et al. 2015. Efficient query processing framework for big data warehouse: an almost join-free approach. Frontiers of Computer Science. 9, 2 (2015), 224--236.","DOI":"10.1007\/s11704-014-4025-6"},{"key":"key-10.1145\/3105831.3105841-58","unstructured":"Wang, H. et al. 2011. LinearDB: A Relational Approach to Make Data Warehouse Scale Like MapReduce. Database Systems for Advanced Applications. J.X. Yu et al., eds. Springer Berlin Heidelberg. 306--320."},{"key":"key-10.1145\/3105831.3105841-59","doi-asserted-by":"crossref","unstructured":"Wang, S. et al. 2014. High dimensional biological data retrieval optimization with NoSQL technology. BMC Genomics. 15 Suppl 8, (2014), S3--S3.","DOI":"10.1186\/1471-2164-15-S8-S3"},{"key":"key-10.1145\/3105831.3105841-60","unstructured":"Ward, J.S. and Barker, A. 2013. Undefined By Data: A Survey of Big Data Definitions. arXiv:1309.5821 [cs.DB]. (Sep. 2013)."},{"key":"key-10.1145\/3105831.3105841-61","unstructured":"Welcome to Apache Hadoop: 2016. https:\/\/hadoop.apache.org\/. Accessed: 2017-02-01."},{"key":"key-10.1145\/3105831.3105841-62","unstructured":"Zikopoulos, P. and Eaton, C. 2011. Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data. McGraw-Hill Osborne Media."}],"event":{"number":"21","sponsor":["Univ of the West of England, University of the West of England","BytePress","Concordia University"],"acronym":"IDEAS 2017","name":"the 21st International Database Engineering & Applications Symposium","start":{"date-parts":[[2017,7,12]]},"location":"Bristol, United Kingdom","end":{"date-parts":[[2017,7,14]]}},"container-title":["Proceedings of the 21st International Database Engineering & Applications Symposium on - IDEAS 2017"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3105831.3105841","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/dl.acm.org\/ft_gateway.cfm?id=3105841&ftid=1896561&dwn=1","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T03:30:04Z","timestamp":1750217404000},"score":1,"resource":{"primary":{"URL":"http:\/\/dl.acm.org\/citation.cfm?doid=3105831.3105841"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017]]},"references-count":62,"URL":"https:\/\/doi.org\/10.1145\/3105831.3105841","relation":{},"subject":[],"published":{"date-parts":[[2017]]}}}