{"id":"https://openalex.org/W7208820677","doi":"https://doi.org/10.63158/journalisi.v8i4.1651","title":"Temporal Healthcare Data Warehouse with SCD Type 2 for OLAPBased Executive Information Systems: A Galaxy Schema Approach","display_name":"Temporal Healthcare Data Warehouse with SCD Type 2 for OLAPBased Executive Information Systems: A Galaxy Schema Approach","alternate_titles":[],"publication_year":2026,"publication_date":"2026-08-29","ids":{"openalex":"https://openalex.org/W7208820677","doi":"https://doi.org/10.63158/journalisi.v8i4.1651"},"language":"en","primary_location":{"id":"doi:10.63158/journalisi.v8i4.1651","doi":"https://doi.org/10.63158/journalisi.v8i4.1651","is_oa":true,"landing_page_url":"https://doi.org/10.63158/journalisi.v8i4.1651","pdf_url":null,"source":{"id":"https://openalex.org/S4210216117","display_name":"Journal of Information Systems and Informatics","issn_l":"2656-5935","issn":["2656-5935","2656-4882"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj"],"host_organization":"https://openalex.org/I4210113646","host_organization_name":"Universitas Bina Darma","host_organization_lineage":["https://openalex.org/I4210113646"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Information Systems and Informatics","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W7208820677"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.63158/journalisi.v8i4.1651","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5048186063","display_name":"muhammad mukhlis khoirudin","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I21881038","display_name":"IPB University","ror":"https://ror.org/05smgpd89","country_code":"ID","type":"education","lineage":["https://openalex.org/I21881038"]},{"id":"https://openalex.org/I4405260306","display_name":"RSUD Prof. Dr. Margono Soekarjo","ror":"https://ror.org/03j8kgx82","country_code":"ID","type":"healthcare","lineage":["https://openalex.org/I4405260306"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Muhammad Mukhlis Khoirudin","raw_affiliation_strings":["IPB University","Prof. Dr. Margono Soekarjo Regional Public Hospital"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IPB University","institution_ids":["https://openalex.org/I21881038"]},{"raw_affiliation_string":"Prof. Dr. Margono Soekarjo Regional Public Hospital","institution_ids":["https://openalex.org/I4405260306"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5139084352","display_name":"Irman Hermadi","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I21881038","display_name":"IPB University","ror":"https://ror.org/05smgpd89","country_code":"ID","type":"education","lineage":["https://openalex.org/I21881038"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Irman Hermadi","raw_affiliation_strings":["IPB University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IPB University","institution_ids":["https://openalex.org/I21881038"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5000436380","display_name":"Hari Agung Adrianto","orcid":"https://orcid.org/0000-0001-8345-1867","observed_orcids":["https://orcid.org/0000-0001-8345-1867"]},"institutions":[{"id":"https://openalex.org/I21881038","display_name":"IPB University","ror":"https://ror.org/05smgpd89","country_code":"ID","type":"education","lineage":["https://openalex.org/I21881038"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Hari Agung Adrianto","raw_affiliation_strings":["IPB University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IPB University","institution_ids":["https://openalex.org/I21881038"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":500000,"currency":"IDR","value_usd":32},"apc_paid":{"value":500000,"currency":"IDR","value_usd":32},"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"8","issue":"4","first_page":"4894","last_page":"4912"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9994999766349792,"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"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9994999766349792,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.0003000000142492354,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10350","display_name":"Electronic Health Records Systems","score":0.0,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/hospital-information-systems","display_name":"hospital information systems","score":0.8069999814033508},{"id":"https://openalex.org/keywords/power-bi-dashboard","display_name":"Power BI dashboard","score":0.871999979019165}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8140000104904175},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7462000250816345},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7211999893188477},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5663999915122986},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.5239999890327454},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.47130000591278076},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.44130000472068787},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.429500013589859},{"id":"https://openalex.org/C20136886","wikidata":"https://www.wikidata.org/wiki/Q749647","display_name":"Interoperability","level":2,"score":0.426800012588501},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4244000017642975},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.421099990606308},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.388700008392334},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3815999925136566},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.3718000054359436},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.3702999949455261},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3702000081539154},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.3434000015258789},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.3393999934196472},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.3237000107765198},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.3203999996185303},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.3190000057220459},{"id":"https://openalex.org/C138958017","wikidata":"https://www.wikidata.org/wiki/Q190087","display_name":"Data type","level":2,"score":0.30880001187324524},{"id":"https://openalex.org/C145642194","wikidata":"https://www.wikidata.org/wiki/Q870895","display_name":"Health informatics","level":3,"score":0.29820001125335693},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.2915000021457672},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.2833999991416931},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.2750999927520752},{"id":"https://openalex.org/C160735492","wikidata":"https://www.wikidata.org/wiki/Q31207","display_name":"Health care","level":2,"score":0.2637999951839447},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.26100000739097595},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.26010000705718994},{"id":"https://openalex.org/C2777019752","wikidata":"https://www.wikidata.org/wiki/Q1509084","display_name":"Hospital information system","level":3,"score":0.25929999351501465},{"id":"https://openalex.org/C127722929","wikidata":"https://www.wikidata.org/wiki/Q7833714","display_name":"Transaction data","level":3,"score":0.2565999925136566},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.25450000166893005},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.2531999945640564}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.63158/journalisi.v8i4.1651","doi":"https://doi.org/10.63158/journalisi.v8i4.1651","is_oa":true,"landing_page_url":"https://doi.org/10.63158/journalisi.v8i4.1651","pdf_url":null,"source":{"id":"https://openalex.org/S4210216117","display_name":"Journal of Information Systems and Informatics","issn_l":"2656-5935","issn":["2656-5935","2656-4882"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj"],"host_organization":"https://openalex.org/I4210113646","host_organization_name":"Universitas Bina Darma","host_organization_lineage":["https://openalex.org/I4210113646"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Information Systems and Informatics","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:0dd350c51dc14bddaafb6383edda99e7","doi":null,"is_oa":false,"landing_page_url":"https://doaj.org/article/0dd350c51dc14bddaafb6383edda99e7","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Journal of Information Systems and Informatics, Vol 8, Iss 4 (2026)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.63158/journalisi.v8i4.1651","doi":"https://doi.org/10.63158/journalisi.v8i4.1651","is_oa":true,"landing_page_url":"https://doi.org/10.63158/journalisi.v8i4.1651","pdf_url":null,"source":{"id":"https://openalex.org/S4210216117","display_name":"Journal of Information Systems and Informatics","issn_l":"2656-5935","issn":["2656-5935","2656-4882"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj"],"host_organization":"https://openalex.org/I4210113646","host_organization_name":"Universitas Bina Darma","host_organization_lineage":["https://openalex.org/I4210113646"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Information Systems and Informatics","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.5683000087738037,"display_name":"Good health and well-being","id":"https://metadata.un.org/sdg/3"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2361153280","https://openalex.org/W2373424218","https://openalex.org/W2353697015","https://openalex.org/W947252784","https://openalex.org/W7147093430","https://openalex.org/W7165382770","https://openalex.org/W2377934729","https://openalex.org/W2185984366","https://openalex.org/W157786810"],"abstract_inverted_index":{"Modern":[0],"hospital":[1,200],"information":[2],"systems":[3],"operate":[4],"within":[5,188],"fragmented":[6],"and":[7,23,37,70,96,111,166,202],"heterogeneous":[8,59,199],"OLTP":[9,60],"environments":[10],"designed":[11],"for":[12,30],"transaction":[13],"recording":[14],"rather":[15],"than":[16],"strategic":[17],"analytical":[18],"workloads.":[19],"This":[20],"study":[21],"designs":[22],"implements":[24],"a":[25,63,82,116,131,181,189],"temporal":[26,186],"healthcare":[27,192],"Data":[28],"Warehouse":[29],"OLAP":[31,100,138],"analytics":[32],"supporting":[33],"historical":[34],"data":[35,193,201],"consistency":[36],"multidimensional":[38],"performance":[39],"monitoring":[40],"aligned":[41,204],"with":[42,81,107,159],"Indonesian":[43],"Ministry":[44],"of":[45,141],"Health":[46],"(Kemenkes":[47],"RI)":[48],"standards.":[49,206],"The":[50,74,99,176],"Kimball":[51],"bottom-up":[52],"methodology":[53],"was":[54,77,102],"applied":[55],"to":[56,156],"integrate":[57],"two":[58,67],"sources":[61],"into":[62],"Galaxy":[64,190],"Schema":[65,191],"comprising":[66],"fact":[68],"tables":[69],"seventeen":[71],"dimension":[72,91],"tables.":[73],"ETL":[75],"pipeline":[76],"implemented":[78],"using":[79,104,125],"SSIS":[80],"complete":[83,182],"SCD":[84,183],"Type":[85,184],"2":[86,185],"workflow":[87],"preserving":[88],"full":[89],"patient":[90,128],"history":[92],"across":[93,148,170],"ward":[94],"transfers":[95],"physician":[97],"reassignments.":[98],"layer":[101],"constructed":[103],"SSAS":[105],"Tabular":[106],"VertiPaq":[108],"in-memory":[109],"engine":[110],"DAX-based":[112],"measures,":[113],"visualized":[114],"through":[115],"Power":[117],"BI":[118],"Executive":[119],"Information":[120],"System":[121],"dashboard.":[122],"Empirical":[123],"validation":[124],"52,321":[126],"discharged":[127],"records":[129],"over":[130,143],"one-year":[132],"observation":[133],"period":[134],"demonstrated":[135],"an":[136],"average":[137],"Speedup":[139],"Ratio":[140],"30.27\u00d7":[142],"equivalent":[144],"relational":[145],"SQL":[146],"queries":[147],"ten":[149],"benchmark":[150],"runs,":[151],"ranging":[152],"from":[153],"2.98\u00d7":[154],"(Slice)":[155],"79.18\u00d7":[157],"(Dice),":[158],"all":[160,171],"response":[161],"times":[162],"below":[163],"40":[164],"ms":[165],"100%":[167],"computational":[168],"accuracy":[169],"six":[172],"Kemenkes":[173],"RI":[174],"KPIs.":[175],"novelty":[177],"lies":[178],"in":[179],"integrating":[180],"model":[187],"warehouse,":[194],"empirically":[195],"validated":[196],"against":[197],"live":[198],"nationally":[203],"KPI":[205]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W7208820677","counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2026-09-06T00:00:00"}
