{"id":"https://openalex.org/W2955514960","doi":"https://doi.org/10.1007/978-981-13-8581-0_23","title":"Design and Implementation of an Improved Data Warehouse on Clinical Data","display_name":"Design and Implementation of an Improved Data Warehouse on Clinical Data","publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W2955514960","doi":"https://doi.org/10.1007/978-981-13-8581-0_23","mag":"2955514960"},"language":"en","primary_location":{"id":"doi:10.1007/978-981-13-8581-0_23","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-981-13-8581-0_23","pdf_url":null,"source":{"id":"https://openalex.org/S2764900261","display_name":"Communications in computer and information science","issn_l":"1865-0929","issn":["1865-0929","1865-0937"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Communications in Computer and Information Science","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5070127502","display_name":"Nilkantha Garain","orcid":null},"institutions":[{"id":"https://openalex.org/I170979836","display_name":"Jadavpur University","ror":"https://ror.org/02af4h012","country_code":"IN","type":"education","lineage":["https://openalex.org/I170979836"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Nilkantha Garain","raw_affiliation_strings":["Department of Information Technology, Jadavpur University, Kolkata, India"],"affiliations":[{"raw_affiliation_string":"Department of Information Technology, Jadavpur University, Kolkata, India","institution_ids":["https://openalex.org/I170979836"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075720299","display_name":"Samiran Chattopadhyay","orcid":"https://orcid.org/0000-0002-8929-9605"},"institutions":[{"id":"https://openalex.org/I170979836","display_name":"Jadavpur University","ror":"https://ror.org/02af4h012","country_code":"IN","type":"education","lineage":["https://openalex.org/I170979836"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Samiran Chattopadhyay","raw_affiliation_strings":["Department of Information Technology, Jadavpur University, Kolkata, India"],"affiliations":[{"raw_affiliation_string":"Department of Information Technology, Jadavpur University, Kolkata, India","institution_ids":["https://openalex.org/I170979836"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5080671730","display_name":"Gautam Mahapatra","orcid":null},"institutions":[{"id":"https://openalex.org/I4210138561","display_name":"Research Centre Imarat","ror":"https://ror.org/03mw5zj47","country_code":"IN","type":"facility","lineage":["https://openalex.org/I1340206300","https://openalex.org/I4210138561","https://openalex.org/I4210150591"]},{"id":"https://openalex.org/I4210150591","display_name":"Ministry of Defence","ror":"https://ror.org/03wejsv15","country_code":"IN","type":"government","lineage":["https://openalex.org/I4210150591"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Gautam Mahapatra","raw_affiliation_strings":["Research Centre Imarat, DRDO, Ministry of Defence, Govt of India, Hyderabad, India"],"affiliations":[{"raw_affiliation_string":"Research Centre Imarat, DRDO, Ministry of Defence, Govt of India, Hyderabad, India","institution_ids":["https://openalex.org/I4210138561","https://openalex.org/I4210150591"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021634467","display_name":"Santanu Chatterjee","orcid":"https://orcid.org/0000-0002-5139-7605"},"institutions":[{"id":"https://openalex.org/I4210150591","display_name":"Ministry of Defence","ror":"https://ror.org/03wejsv15","country_code":"IN","type":"government","lineage":["https://openalex.org/I4210150591"]},{"id":"https://openalex.org/I4210138561","display_name":"Research Centre Imarat","ror":"https://ror.org/03mw5zj47","country_code":"IN","type":"facility","lineage":["https://openalex.org/I1340206300","https://openalex.org/I4210138561","https://openalex.org/I4210150591"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Santanu Chatterjee","raw_affiliation_strings":["Research Centre Imarat, DRDO, Ministry of Defence, Govt of India, Hyderabad, India"],"affiliations":[{"raw_affiliation_string":"Research Centre Imarat, DRDO, Ministry of Defence, Govt of India, Hyderabad, India","institution_ids":["https://openalex.org/I4210138561","https://openalex.org/I4210150591"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056512425","display_name":"Kartick Chandra Mondal","orcid":"https://orcid.org/0000-0003-3647-5799"},"institutions":[{"id":"https://openalex.org/I170979836","display_name":"Jadavpur University","ror":"https://ror.org/02af4h012","country_code":"IN","type":"education","lineage":["https://openalex.org/I170979836"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Kartick Chandra Mondal","raw_affiliation_strings":["Department of Information Technology, Jadavpur University, Kolkata, India"],"affiliations":[{"raw_affiliation_string":"Department of Information Technology, Jadavpur University, Kolkata, India","institution_ids":["https://openalex.org/I170979836"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5070127502"],"corresponding_institution_ids":["https://openalex.org/I170979836"],"apc_list":null,"apc_paid":null,"fwci":0.4549,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.59517893,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"278","last_page":"290"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9962999820709229,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.9465200901031494},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.8189775943756104},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7910839319229126},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6713533401489258},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5816110372543335},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.5547020435333252},{"id":"https://openalex.org/keywords/logical-data-model","display_name":"Logical data model","score":0.5429520010948181},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.48163264989852905},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4666905999183655},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.45877915620803833},{"id":"https://openalex.org/keywords/data-cube","display_name":"Data cube","score":0.44013482332229614},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.29931357502937317},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.20635470747947693},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1076849102973938}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9465200901031494},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.8189775943756104},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7910839319229126},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6713533401489258},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5816110372543335},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5547020435333252},{"id":"https://openalex.org/C203702819","wikidata":"https://www.wikidata.org/wiki/Q17146953","display_name":"Logical data model","level":3,"score":0.5429520010948181},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.48163264989852905},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4666905999183655},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.45877915620803833},{"id":"https://openalex.org/C78168278","wikidata":"https://www.wikidata.org/wiki/Q5227269","display_name":"Data cube","level":2,"score":0.44013482332229614},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.29931357502937317},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.20635470747947693},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1076849102973938}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-981-13-8581-0_23","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-981-13-8581-0_23","pdf_url":null,"source":{"id":"https://openalex.org/S2764900261","display_name":"Communications in computer and information science","issn_l":"1865-0929","issn":["1865-0929","1865-0937"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Communications in Computer and Information Science","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W756609968","https://openalex.org/W1495859460","https://openalex.org/W1496130826","https://openalex.org/W1975616538","https://openalex.org/W2003584736","https://openalex.org/W2006148350","https://openalex.org/W2020958835","https://openalex.org/W2036613237","https://openalex.org/W2108971776","https://openalex.org/W2117716920","https://openalex.org/W2129203637","https://openalex.org/W2143515359","https://openalex.org/W2167445883","https://openalex.org/W2170515491","https://openalex.org/W2319768862","https://openalex.org/W2350573227","https://openalex.org/W3004349271","https://openalex.org/W4232942793","https://openalex.org/W6605029265"],"related_works":["https://openalex.org/W2746835778","https://openalex.org/W2753164228","https://openalex.org/W2383931363","https://openalex.org/W2348604092","https://openalex.org/W1505685679","https://openalex.org/W2106325388","https://openalex.org/W2277528925","https://openalex.org/W2541662483","https://openalex.org/W2473783532","https://openalex.org/W2349098690"],"abstract_inverted_index":null,"counts_by_year":[{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}