{"id":"https://openalex.org/W825331328","doi":"https://doi.org/10.3233/978-1-61499-538-8-139","title":"Data Warehouse Design from HL7 Clinical Document Architecture Schema","display_name":"Data Warehouse Design from HL7 Clinical Document Architecture Schema","publication_year":2015,"publication_date":"2015-01-01","ids":{"openalex":"https://openalex.org/W825331328","doi":"https://doi.org/10.3233/978-1-61499-538-8-139","mag":"825331328","pmid":"https://pubmed.ncbi.nlm.nih.gov/26152975"},"language":"en","primary_location":{"id":"doi:10.3233/978-1-61499-538-8-139","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-538-8-139","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"type":"article","indexed_in":["crossref","pubmed"],"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/A5061292206","display_name":"Fabrizio Pecoraro","orcid":"https://orcid.org/0000-0001-5718-4240"},"institutions":[{"id":"https://openalex.org/I4210155236","display_name":"National Research Council","ror":"https://ror.org/04zaypm56","country_code":"IT","type":"funder","lineage":["https://openalex.org/I4210155236"]},{"id":"https://openalex.org/I4210117484","display_name":"Institute for Research on Population and Social Policies","ror":"https://ror.org/01n1ayq61","country_code":"IT","type":"facility","lineage":["https://openalex.org/I4210117484","https://openalex.org/I4210155236"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Pecoraro Fabrizio","raw_affiliation_strings":["Institute for Research on Population and Social Policies, National Research Council, Italy"],"affiliations":[{"raw_affiliation_string":"Institute for Research on Population and Social Policies, National Research Council, Italy","institution_ids":["https://openalex.org/I4210117484","https://openalex.org/I4210155236"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010067486","display_name":"Daniela Luzi","orcid":"https://orcid.org/0000-0003-3404-3271"},"institutions":[{"id":"https://openalex.org/I4210155236","display_name":"National Research Council","ror":"https://ror.org/04zaypm56","country_code":"IT","type":"funder","lineage":["https://openalex.org/I4210155236"]},{"id":"https://openalex.org/I4210117484","display_name":"Institute for Research on Population and Social Policies","ror":"https://ror.org/01n1ayq61","country_code":"IT","type":"facility","lineage":["https://openalex.org/I4210117484","https://openalex.org/I4210155236"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Luzi Daniela","raw_affiliation_strings":["Institute for Research on Population and Social Policies, National Research Council, Italy"],"affiliations":[{"raw_affiliation_string":"Institute for Research on Population and Social Policies, National Research Council, Italy","institution_ids":["https://openalex.org/I4210117484","https://openalex.org/I4210155236"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102868767","display_name":"Fabrizio L. Ricci","orcid":"https://orcid.org/0000-0002-6110-7712"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ricci Fabrizio L.","raw_affiliation_strings":["Institute for System Analysis and Computer Science, National Research Council, Italy"],"affiliations":[{"raw_affiliation_string":"Institute for System Analysis and Computer Science, National Research Council, Italy","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5061292206"],"corresponding_institution_ids":["https://openalex.org/I4210117484","https://openalex.org/I4210155236"],"apc_list":null,"apc_paid":null,"fwci":0.8167,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.76140793,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"213","issue":null,"first_page":"139","last_page":"42"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9901999831199646,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9901999831199646,"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.9876000285148621,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9789000153541565,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8416037559509277},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.8206663131713867},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7667485475540161},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.6021043062210083},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5807273387908936},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.48997989296913147},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.45143112540245056},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.42630550265312195},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.41783323884010315},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41009700298309326},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.2328902781009674},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.13211172819137573}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8416037559509277},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.8206663131713867},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7667485475540161},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.6021043062210083},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5807273387908936},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.48997989296913147},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.45143112540245056},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.42630550265312195},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.41783323884010315},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41009700298309326},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.2328902781009674},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.13211172819137573},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.0}],"mesh":[{"descriptor_ui":"D003266","descriptor_name":"Continuity of Patient Care","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D003266","descriptor_name":"Continuity of Patient Care","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D003266","descriptor_name":"Continuity of Patient Care","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D003266","descriptor_name":"Continuity of Patient Care","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D003266","descriptor_name":"Continuity of Patient Care","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D003266","descriptor_name":"Continuity of Patient Care","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D004282","descriptor_name":"Documentation","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D004282","descriptor_name":"Documentation","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D004282","descriptor_name":"Documentation","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D007256","descriptor_name":"Information Systems","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D007256","descriptor_name":"Information Systems","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D007256","descriptor_name":"Information Systems","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D007256","descriptor_name":"Information Systems","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D007256","descriptor_name":"Information Systems","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D007256","descriptor_name":"Information Systems","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D008962","descriptor_name":"Models, Theoretical","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008962","descriptor_name":"Models, Theoretical","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008962","descriptor_name":"Models, Theoretical","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057208","descriptor_name":"Health Level Seven","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057208","descriptor_name":"Health Level Seven","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057208","descriptor_name":"Health Level Seven","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false}],"locations_count":2,"locations":[{"id":"doi:10.3233/978-1-61499-538-8-139","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-538-8-139","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},{"id":"pmid:26152975","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/26152975","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in health technology and informatics","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6100000143051147,"display_name":"Sustainable cities and communities","id":"https://metadata.un.org/sdg/11"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2584861411","https://openalex.org/W3211811865","https://openalex.org/W2163009032","https://openalex.org/W155596183","https://openalex.org/W2359588502","https://openalex.org/W3184524636","https://openalex.org/W629399385","https://openalex.org/W2373231791","https://openalex.org/W2522980826","https://openalex.org/W2075785658"],"abstract_inverted_index":{"This":[0],"paper":[1],"proposes":[2],"a":[3,12,22,32,37,54],"semi-automatic":[4],"approach":[5],"to":[6],"extract":[7],"clinical":[8],"information":[9],"structured":[10],"in":[11,21,36],"HL7":[13],"Clinical":[14],"Document":[15],"Architecture":[16],"(CDA)":[17],"and":[18],"transform":[19],"it":[20],"data":[23],"warehouse":[24],"dimensional":[25,43],"model":[26,44],"schema.":[27],"It":[28],"is":[29,51],"based":[30,57],"on":[31,58],"conceptual":[33],"framework":[34],"published":[35],"previous":[38],"work":[39],"that":[40],"maps":[41],"the":[42,59],"primitives":[45],"with":[46],"CDA":[47],"elements.":[48],"Its":[49],"feasibility":[50],"demonstrated":[52],"providing":[53],"case":[55],"study":[56],"analysis":[60],"of":[61],"vital":[62],"signs":[63],"gathered":[64],"during":[65],"laboratory":[66],"tests.":[67]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}