{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,27]],"date-time":"2025-03-27T01:11:13Z","timestamp":1743037873204,"version":"3.40.3"},"publisher-location":"Singapore","reference-count":19,"publisher":"Springer Singapore","isbn-type":[{"type":"print","value":"9789811385803"},{"type":"electronic","value":"9789811385810"}],"license":[{"start":{"date-parts":[[2019,1,1]],"date-time":"2019-01-01T00:00:00Z","timestamp":1546300800000},"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":[[2019]]},"DOI":"10.1007\/978-981-13-8581-0_23","type":"book-chapter","created":{"date-parts":[[2019,6,25]],"date-time":"2019-06-25T11:04:44Z","timestamp":1561460684000},"page":"278-290","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["Design and Implementation of an Improved Data Warehouse on Clinical Data"],"prefix":"10.1007","author":[{"given":"Nilkantha","family":"Garain","sequence":"first","affiliation":[]},{"given":"Samiran","family":"Chattopadhyay","sequence":"additional","affiliation":[]},{"given":"Gautam","family":"Mahapatra","sequence":"additional","affiliation":[]},{"given":"Santanu","family":"Chatterjee","sequence":"additional","affiliation":[]},{"given":"Kartick Chandra","family":"Mondal","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2019,6,26]]},"reference":[{"key":"23_CR1","volume-title":"The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling","author":"R Kimball","year":"2011","unstructured":"Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley, New York (2011)"},{"key":"23_CR2","volume-title":"Building the Data Warehouse","author":"WH Inmon","year":"2005","unstructured":"Inmon, W.H.: Building the Data Warehouse. Wiley, USA (2005)"},{"issue":"2","key":"23_CR3","first-page":"138","volume":"16","author":"A Ado","year":"2014","unstructured":"Ado, A., Aliyu, A., Bello, S.A., Garba, A.U.: Building a diabetes data warehouse to support decision making in healthcare industry. Int. Organ. Sci. Res. J. Comput. Eng. (IOSR-JCE) 16(2), 138\u2013143 (2014)","journal-title":"Int. Organ. Sci. Res. J. Comput. Eng. (IOSR-JCE)"},{"key":"23_CR4","doi-asserted-by":"crossref","unstructured":"Nealon, J., Rahayu, W., Pardede, E.: Improving clinical data warehouse performance via a windowing data structure architecture. In: International Conference on Computational Science and Its Applications (ICCSA 2009), pp. 243\u2013253. IEEE (2009)","DOI":"10.1109\/ICCSA.2009.23"},{"issue":"8","key":"23_CR5","doi-asserted-by":"publisher","first-page":"88","DOI":"10.1145\/1978542.1978562","volume":"54","author":"S Chaudhuri","year":"2011","unstructured":"Chaudhuri, S., Dayal, U., Narasayya, V.: An overview of business intelligence technology. Commun. ACM 54(8), 88\u201398 (2011)","journal-title":"Commun. ACM"},{"issue":"5","key":"23_CR6","doi-asserted-by":"publisher","first-page":"857","DOI":"10.4304\/jsw.6.5.857-865","volume":"6","author":"Z Ni","year":"2011","unstructured":"Ni, Z., Guo, J., Wang, L., Gao, Y.: An efficient method for improving query efficiency in data warehouse. JSW 6(5), 857\u2013865 (2011)","journal-title":"JSW"},{"key":"23_CR7","unstructured":"Pentaho Analysis Service: Mondrian Project. \n                    http:\/\/mondrian.pentaho.org\/\n                    \n                  . Accessed 29 Dec 2017"},{"key":"23_CR8","first-page":"1","volume":"23","author":"V Jovanovic","year":"2012","unstructured":"Jovanovic, V., Bojicic, I.: Conceptual data vault model. Proc. SAIS 23, 1\u20136 (2012)","journal-title":"Proc. SAIS"},{"key":"23_CR9","doi-asserted-by":"crossref","unstructured":"Kim, J.W., Cho, S., Kim, I.: Column partitioning to improve data warehouse queryperformance. In: International Workshop on Ubiquitous Science and Engineering, Jeju, South Korea (2015)","DOI":"10.14257\/astl.2015.86.02"},{"key":"23_CR10","unstructured":"Bellatreche, L., Karlapalem, K., Mohania, M., Schneider, M.: What can partitioning do for your data warehouses and data marts? In: 2000 International Database Engineering and Applications Symposium, pp. 437\u2013445. IEEE (2000)"},{"issue":"3","key":"23_CR11","doi-asserted-by":"publisher","first-page":"225","DOI":"10.1016\/S0306-4379(02)00021-2","volume":"28","author":"M Levene","year":"2003","unstructured":"Levene, M., Loizou, G.: Why is the snowflake schema a good data warehouse design? Inf. Syst. 28(3), 225\u2013240 (2003)","journal-title":"Inf. Syst."},{"issue":"1","key":"23_CR12","doi-asserted-by":"publisher","first-page":"98","DOI":"10.1016\/j.infsof.2008.01.003","volume":"51","author":"J Chmiel","year":"2009","unstructured":"Chmiel, J., Morzy, T., Wrembel, R.: Multiversion join index for multiversion data warehouse. Inf. Softw. Technol. 51(1), 98\u2013108 (2009)","journal-title":"Inf. Softw. Technol."},{"key":"23_CR13","doi-asserted-by":"publisher","first-page":"447","DOI":"10.1145\/235968.233361","volume":"25","author":"KA Ross","year":"1996","unstructured":"Ross, K.A., Srivastava, D., Sudarshan, S.: Materialized view maintenance and integrity constraint checking: trading space for time. ACM SIGMOD Rec. 25, 447\u2013458 (1996)","journal-title":"ACM SIGMOD Rec."},{"issue":"3","key":"23_CR14","doi-asserted-by":"publisher","first-page":"282","DOI":"10.1109\/5326.971656","volume":"31","author":"C Zhang","year":"2001","unstructured":"Zhang, C., Yao, X., Yang, J.: An evolutionary approach to materialized views selection in a data warehouse environment. IEEE Trans. Syst. Man Cybern. Part C Appl. Rev. 31(3), 282\u2013294 (2001)","journal-title":"IEEE Trans. Syst. Man Cybern. Part C Appl. Rev."},{"key":"23_CR15","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"502","DOI":"10.1007\/3-540-45017-3_34","volume-title":"Advanced Information Systems Engineering","author":"S Rizzi","year":"2003","unstructured":"Rizzi, S., Saltarelli, E.: View materialization vs. indexing: balancing space constraints in data warehouse design. In: Eder, J., Missikoff, M. (eds.) CAiSE 2003. LNCS, vol. 2681, pp. 502\u2013519. Springer, Heidelberg (2003). \n                    https:\/\/doi.org\/10.1007\/3-540-45017-3_34"},{"key":"23_CR16","unstructured":"Wu, M.C., Buchmann, A.P.: Encoded bitmap indexing for data warehouses. In: 1998 Proceedings of the 14th International Conference on Data Engineering, pp. 220\u2013230. IEEE (1998)"},{"key":"23_CR17","doi-asserted-by":"crossref","unstructured":"Koudas, N.: Space efficient bitmap indexing. In: Proceedings of the 9th International Conference on Information and Knowledge Management, pp. 194\u2013201. ACM (2000)","DOI":"10.1145\/354756.354819"},{"key":"23_CR18","unstructured":"DeWitt, D.J., Madden, S., Stonebraker, M.: How to build a high-performance data warehouse (2005). \n                    http:\/\/db.lcs.mit.edu\/madden\/high_perf.pdf\n                    \n                  . Accessed June 2011"},{"key":"23_CR19","unstructured":"V. G. H. Information, Information about Health Data Standards and Systems (HDSS) used in Victoria\u2019s Hospital (2008). \n                    http:\/\/www.health.vic.gov.au\/hdss\/index.html\n                    \n                  . Accessed 23 Dec 2017"}],"container-title":["Communications in Computer and Information Science","Computational Intelligence, Communications, and Business Analytics"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-981-13-8581-0_23","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,6,25]],"date-time":"2019-06-25T19:04:45Z","timestamp":1561489485000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-981-13-8581-0_23"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019]]},"ISBN":["9789811385803","9789811385810"],"references-count":19,"URL":"https:\/\/doi.org\/10.1007\/978-981-13-8581-0_23","relation":{},"ISSN":["1865-0929","1865-0937"],"issn-type":[{"type":"print","value":"1865-0929"},{"type":"electronic","value":"1865-0937"}],"subject":[],"published":{"date-parts":[[2019]]},"assertion":[{"value":"26 June 2019","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"CICBA","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Computational Intelligence, Communications, and Business Analytics","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Kalyani","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"India","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2018","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"27 July 2018","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"28 July 2018","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":"cicba2018","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/www.cicba.in","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Double-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information"}},{"value":"easychair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information"}},{"value":"240","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information"}},{"value":"76","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information"}},{"value":"0","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information"}},{"value":"32% - 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"}},{"value":"2.74","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information"}},{"value":"3.3","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information"}},{"value":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information"}}]}}