{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,8]],"date-time":"2026-02-08T08:23:43Z","timestamp":1770539023357,"version":"3.49.0"},"publisher-location":"Singapore","reference-count":22,"publisher":"Springer Singapore","isbn-type":[{"value":"9789811552311","type":"print"},{"value":"9789811552328","type":"electronic"}],"license":[{"start":{"date-parts":[[2020,1,1]],"date-time":"2020-01-01T00:00:00Z","timestamp":1577836800000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2020]]},"DOI":"10.1007\/978-981-15-5232-8_12","type":"book-chapter","created":{"date-parts":[[2020,5,8]],"date-time":"2020-05-08T08:02:53Z","timestamp":1588924973000},"page":"129-140","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":7,"title":["A Review of Star Schema and Snowflakes Schema"],"prefix":"10.1007","author":[{"given":"M. Zafar","family":"Iqbal","sequence":"first","affiliation":[]},{"given":"Ghulam","family":"Mustafa","sequence":"additional","affiliation":[]},{"given":"Nadeem","family":"Sarwar","sequence":"additional","affiliation":[]},{"given":"Syed Hamza","family":"Wajid","sequence":"additional","affiliation":[]},{"given":"Junaid","family":"Nasir","sequence":"additional","affiliation":[]},{"given":"Shaista","family":"Siddque","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2020,5,9]]},"reference":[{"issue":"13","key":"12_CR1","first-page":"11","volume":"134","author":"E Sidi","year":"2016","unstructured":"Sidi, E., El, M., Amin, E.: Star schema advantages on data warehouse: using bitmap index and partitioned fact tables. Int. J. Comput. Appl. 134(13), 11\u201313 (2016)","journal-title":"Int. J. Comput. Appl."},{"key":"12_CR2","doi-asserted-by":"crossref","unstructured":"Jan, B., Alharbi, M., Mujeeb-ur-rehman, Khan, F.A., Imran, M., Ahmad, A.: Efficient data access and performance improvement model for virtual data warehouse. Sustain. Cities Soc. 35, 232\u2013240 (2017)","DOI":"10.1016\/j.scs.2017.08.003"},{"key":"12_CR3","unstructured":"Yusuf, A.: A design comparison: data warehouse schema versus conventional relational database schema. In: CEUR Workshop Proceedings (2016)"},{"key":"12_CR4","first-page":"18","volume":"5","author":"M North","year":"2017","unstructured":"North, M., Thomas, L., Richardson, R., Akpess, P.: Data warehousing: a practical managerial approach. Comput. Sci. Inf. Technol. 5, 18\u201326 (2017)","journal-title":"Comput. Sci. Inf. Technol."},{"key":"12_CR5","series-title":"Studies in Big Data","doi-asserted-by":"publisher","first-page":"3","DOI":"10.1007\/978-3-319-61893-7_1","volume-title":"A Comprehensive Guide Through the Italian Database Research Over the Last 25 Years","author":"M Angelini","year":"2018","unstructured":"Angelini, M., Catarci, T., Mecella, M., Santucci, G.: The visual side of the data. In: Flesca, S., Greco, S., Masciari, E., Sacc\u00e0, D. (eds.) A Comprehensive Guide Through the Italian Database Research Over the Last 25 Years. SBD, vol. 31, pp. 3\u201325. Springer, Cham (2018). \nhttps:\/\/doi.org\/10.1007\/978-3-319-61893-7_1"},{"key":"12_CR6","series-title":"Studies in Big Data","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-61893-7","volume-title":"A Comprehensive Guide Through the Italian Database Research Over the Last 25 Years","year":"2018","unstructured":"Flesca, S., Greco, S., Masciari, E., Sacc\u00e0, D. (eds.): A Comprehensive Guide Through the Italian Database Research Over the Last 25 Years. SBD, vol. 31. Springer, Cham (2018). \nhttps:\/\/doi.org\/10.1007\/978-3-319-61893-7"},{"issue":"1","key":"12_CR7","doi-asserted-by":"publisher","first-page":"1","DOI":"10.5121\/ijfcst.2014.4101","volume":"4","author":"R Abdalaziz Ahmedl","year":"2014","unstructured":"Abdalaziz Ahmedl, R., Mohamed Ahmed, T.: Generating data warehouse schema. Int. J. Found. Comput. Sci. Technol. 4(1), 1\u201316 (2014)","journal-title":"Int. J. Found. Comput. Sci. Technol."},{"key":"12_CR8","first-page":"47","volume":"2","author":"MK Sandhu","year":"2015","unstructured":"Sandhu, M.K., Kaur, A., Kaur, R.: Data warehouse schemas. Int. J. Innov. Res. Adv. Eng. (IJIIRAE) 2, 47\u201351 (2015)","journal-title":"Int. J. Innov. Res. Adv. Eng. (IJIIRAE)"},{"key":"12_CR9","unstructured":"Cherniack, M., Lawande, S., Tran, N.: Optimizing snowflake schema queries (2014)"},{"issue":"1","key":"12_CR10","first-page":"1571","volume":"2","author":"C Priyadharsini","year":"2014","unstructured":"Priyadharsini, C., Thanamani, D.A.S.: An overview of knowledge discovery database and data mining techniques. Int. J. Innov. Res. Comput. Commun. Eng. 2(1), 1571\u20131578 (2014)","journal-title":"Int. J. Innov. Res. Comput. Commun. Eng."},{"key":"12_CR11","series-title":"Lecture Notes in Computer Science (Lecture Notes in Artificial Intelligence)","doi-asserted-by":"publisher","first-page":"288","DOI":"10.1007\/978-3-319-11812-3_25","volume-title":"Discovery Science","author":"P Ristoski","year":"2014","unstructured":"Ristoski, P., Paulheim, H.: Feature selection in hierarchical feature spaces. In: D\u017eeroski, S., Panov, P., Kocev, D., Todorovski, L. (eds.) DS 2014. LNCS (LNAI), vol. 8777, pp. 288\u2013300. Springer, Cham (2014). \nhttps:\/\/doi.org\/10.1007\/978-3-319-11812-3_25"},{"key":"12_CR12","doi-asserted-by":"crossref","unstructured":"Maimon, O., Rokach, L.: Introduction to Knowledge Discovery and Data Mining, pp. 1\u201315 (2016)","DOI":"10.1007\/978-0-387-09823-4_1"},{"issue":"6","key":"12_CR13","first-page":"594","volume":"2","author":"K Pavya","year":"2017","unstructured":"Pavya, K., Srinivasan, D.B.: Feature selection techniques in data mining: a study. Int. J. Sci. Dev. Res. 2(6), 594\u2013598 (2017)","journal-title":"Int. J. Sci. Dev. Res."},{"key":"12_CR14","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1007\/b107408","volume-title":"Data Mining and Knowledge Discovery Handbook","author":"O Maimon","year":"2005","unstructured":"Maimon, O., Rokach, L.: Data Mining and Knowledge Discovery Handbook, pp. 1\u201315. Springer, Boston (2005). \nhttps:\/\/doi.org\/10.1007\/b107408"},{"key":"12_CR15","series-title":"Studies in Big Data","doi-asserted-by":"publisher","first-page":"93","DOI":"10.1007\/978-3-319-61893-7_6","volume-title":"A Comprehensive Guide Through the Italian Database Research Over the Last 25 Years","author":"M Golfarelli","year":"2018","unstructured":"Golfarelli, M., Rizzi, S.: From star schemas to big data: 20+ years of data warehouse research. In: Flesca, S., Greco, S., Masciari, E., Sacc\u00e0, D. (eds.) A Comprehensive Guide Through the Italian Database Research Over the Last 25 Years. SBD, vol. 31, pp. 93\u2013107. Springer, Cham (2018). \nhttps:\/\/doi.org\/10.1007\/978-3-319-61893-7_6"},{"key":"12_CR16","unstructured":"Bhide, M.A., Mittapalli, S.K., Padmanabhan, S.: Star and snowflake schemas in extract, transform, load processes (2016)"},{"key":"12_CR17","first-page":"39","volume":"135","author":"E Sidi","year":"2016","unstructured":"Sidi, E., El, M., Amin, E.: The impact of partitioned fact tables and bitmap index on data warehouse performance. Int. J. Comput. Appl. 135, 39\u201341 (2016)","journal-title":"Int. J. Comput. Appl."},{"key":"12_CR18","unstructured":"Difference Between Star and Snowflake Schema. \nhttps:\/\/techdifferences.com\/difference-between-star-and-snowflake-schema.html"},{"issue":"15","key":"12_CR19","first-page":"33","volume":"180","author":"M Benjelloun","year":"2018","unstructured":"Benjelloun, M., El, M., Amin, E.: Impact of using snowflake schema and bitmap index on data warehouse querying. Int. J. Comput. Appl. 180(15), 33\u201335 (2018)","journal-title":"Int. J. Comput. Appl."},{"key":"12_CR20","doi-asserted-by":"crossref","unstructured":"Dageville, B., et al.: The snowflake elastic data warehouse. In: SIGMOD\/PODS 2016, San Francisco, CA, USA, 26 June\u201301 July 2016 (2016)","DOI":"10.1145\/2882903.2903741"},{"key":"12_CR21","unstructured":"Difference between snowflakes schema and star schema (2016). \nhttps:\/\/techdifferences.com\/difference-between-star-and-snowflake-schema.html#"},{"key":"12_CR22","unstructured":"Cheng, X., Schneider, P.: Star and snowflake join query performance (2017)"}],"container-title":["Communications in Computer and Information Science","Intelligent Technologies and Applications"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-981-15-5232-8_12","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,5,8]],"date-time":"2020-05-08T08:04:41Z","timestamp":1588925081000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-981-15-5232-8_12"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020]]},"ISBN":["9789811552311","9789811552328"],"references-count":22,"URL":"https:\/\/doi.org\/10.1007\/978-981-15-5232-8_12","relation":{},"ISSN":["1865-0929","1865-0937"],"issn-type":[{"value":"1865-0929","type":"print"},{"value":"1865-0937","type":"electronic"}],"subject":[],"published":{"date-parts":[[2020]]},"assertion":[{"value":"9 May 2020","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"INTAP","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Intelligent Technologies and Applications","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Bahawalpur","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Pakistan","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2019","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"6 November 2019","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"8 November 2019","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"intap2019","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/jdconline.net\/intap\/index.html","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":"EasyChair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"224","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":"60","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":"6","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":"27% - 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":"3","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":"5","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":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"1 Invited Paper","order":10,"name":"additional_info_on_review_process","label":"Additional Info on Review Process","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}