{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,3]],"date-time":"2026-05-03T23:45:56Z","timestamp":1777851956602,"version":"3.51.4"},"reference-count":41,"publisher":"SAGE Publications","issue":"2","license":[{"start":{"date-parts":[[2023,4,1]],"date-time":"2023-04-01T00:00:00Z","timestamp":1680307200000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"funder":[{"DOI":"10.13039\/501100001805","name":"Canada Foundation for Innovation","doi-asserted-by":"publisher","id":[{"id":"10.13039\/501100001805","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100000024","name":"Canadian Institute of Health Research","doi-asserted-by":"publisher","award":["126128"],"award-info":[{"award-number":["126128"]}],"id":[{"id":"10.13039\/501100000024","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["journals.sagepub.com"],"crossmark-restriction":true},"short-container-title":["Health Informatics J"],"published-print":{"date-parts":[[2023,4]]},"abstract":"<jats:p>Objective: To explore the application of online analytic processing (OLAP) to improve the efficiency of analytics using large administrative health data sets. Methods: 18 years of administrative health data (1994\/95 to 2012\/13) were obtained from the Alberta Ministry of Health in Canada. The data sets included hospitalization, ambulatory care and practitioner claims data. Reference files were obtained that provided information including patient demographics, resident postal code, facility, and provider details. Population counts and projections for each year, sex, age were included for rate calculations. These sources were used to develop a data cube using OLAP tools. Results: Time required for analyses was reduced to 5% of that required when comparing run-time for simple queries that did not require linkage of data sets. The data cube negated the need for many intermediary steps for data extraction and analyses for research activities. Conventional methods required over 250\u00a0GB of server space for multiple analytic subsets, compared to only 10.3\u00a0GB for the data cube. Conclusions: Cross-training in information technology and health analytics is recommended to provide capacity to better leverage OLAP tools which are available with many common applications.<\/jats:p>","DOI":"10.1177\/14604582231180581","type":"journal-article","created":{"date-parts":[[2023,6,3]],"date-time":"2023-06-03T02:07:51Z","timestamp":1685758071000},"update-policy":"https:\/\/doi.org\/10.1177\/sage-journals-update-policy","source":"Crossref","is-referenced-by-count":1,"title":["Breaking the 80:20 rule in health research using large administrative data sets"],"prefix":"10.1177","volume":"29","author":[{"ORCID":"https:\/\/orcid.org\/0000-0001-9977-8063","authenticated-orcid":false,"given":"Shelly","family":"Vik","sequence":"first","affiliation":[{"name":"Cumming School of Medicine, University of Calgary, Calgary, AB, Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Judy","family":"Seidel","sequence":"additional","affiliation":[{"name":"Cumming School of Medicine, University of Calgary, Calgary, AB, Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Christopher","family":"Smith","sequence":"additional","affiliation":[{"name":"Alberta Bone and Joint Institute, Calgary, AB, Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Deborah A","family":"Marshall","sequence":"additional","affiliation":[{"name":"Cumming School of Medicine, University of Calgary, Calgary, AB, Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"179","published-online":{"date-parts":[[2023,6,2]]},"reference":[{"key":"bibr1-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1136\/bmjhci-2020-100161"},{"key":"bibr2-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijmedinf.2008.06.005"},{"key":"bibr3-14604582231180581","doi-asserted-by":"publisher","DOI":"10.17269\/cjph.104.3775"},{"key":"bibr4-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1186\/2047-2501-2-3"},{"key":"bibr5-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1016\/B978-0-12-374765-5.00019-X"},{"key":"bibr6-14604582231180581","volume-title":"The importance of \u2018big data\u2019: a definition","author":"Beyer MA","year":"2012"},{"key":"bibr7-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1038\/nature.2015.17912"},{"key":"bibr8-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1038\/527S108a"},{"key":"bibr9-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1155\/2015\/370194"},{"key":"bibr10-14604582231180581","doi-asserted-by":"publisher","DOI":"10.15265\/iy-2016-019"},{"key":"bibr11-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1007\/s40273-015-0330-7"},{"key":"bibr12-14604582231180581","first-page":"43","volume":"14","author":"Hettler M","year":"1997","journal-title":"Healthc Inform"},{"key":"bibr13-14604582231180581","first-page":"155","volume":"15","author":"Silver M","year":"2001","journal-title":"J Healthc Inf Manag"},{"key":"bibr14-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1155\/JBB.2005.181"},{"key":"bibr15-14604582231180581","doi-asserted-by":"publisher","DOI":"10.4236\/jsea.2015.812058"},{"key":"bibr16-14604582231180581","first-page":"215","volume":"2000","author":"Dzeroski S","year":"2000","journal-title":"Proceedings\/AMIA. Annual Symposium AMIA Symposium"},{"key":"bibr17-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1093\/protein\/gzn015"},{"key":"bibr18-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1197\/j.aem.2004.08.015"},{"key":"bibr19-14604582231180581","first-page":"369","volume":"2000","author":"Hristovski D","year":"2000","journal-title":"Proceedings\/AMIA. Annual Symposium AMIA Symposium"},{"key":"bibr20-14604582231180581","doi-asserted-by":"publisher","DOI":"10.5210\/ojphi.v2i3.3348"},{"key":"bibr21-14604582231180581","doi-asserted-by":"publisher","DOI":"10.35940\/ijitee.f3957.049620"},{"key":"bibr22-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1109\/BigData50022.2020.9378407"},{"key":"bibr23-14604582231180581","doi-asserted-by":"publisher","DOI":"10.3390\/ijerph17155596"},{"key":"bibr24-14604582231180581","volume-title":"Health data for research","author":"Government of Alberta","year":"2022"},{"key":"bibr25-14604582231180581","volume-title":"Microsoft","year":"2017"},{"key":"bibr26-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-031-10548-7_26"},{"key":"bibr27-14604582231180581","volume-title":"SAS\u00ae OLAP server and SAS\u00ae OLAP cube studio","author":"SAS Institued Inc","year":"2006"},{"key":"bibr28-14604582231180581","doi-asserted-by":"publisher","DOI":"10.5120\/ijais2017451682"},{"key":"bibr29-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1197\/jamia.M2114"},{"key":"bibr30-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1186\/s13073-016-0323-y"},{"key":"bibr31-14604582231180581","first-page":"168","volume-title":"Competing on analytics: the new science of winning","author":"Davenport TH","year":"2006"},{"key":"bibr32-14604582231180581","volume":"255","author":"Vik S","year":"2021","journal-title":"Canadian Association for Health Services and Policy Research"},{"key":"bibr33-14604582231180581","doi-asserted-by":"publisher","DOI":"10.23889\/ijpds.v3i4.1035"},{"key":"bibr34-14604582231180581","doi-asserted-by":"publisher","DOI":"10.2147\/clep.s105613"},{"key":"bibr35-14604582231180581","doi-asserted-by":"publisher","DOI":"10.23889\/ijpds.v6i1.1653"},{"key":"bibr36-14604582231180581","doi-asserted-by":"publisher","DOI":"10.15265\/IY-2017-034"},{"key":"bibr37-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1016\/j.vhri.2021.05.002"},{"key":"bibr38-14604582231180581","first-page":"3","volume":"2","author":"Parmanto B","year":"2005","journal-title":"Perspect Health Inf Manag"},{"key":"bibr39-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1016\/S0840-4704(10)61000-9"},{"key":"bibr40-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1177\/1460458209337446"},{"key":"bibr41-14604582231180581","doi-asserted-by":"publisher","DOI":"10.1007\/s10796-021-10147-3"}],"container-title":["Health Informatics Journal"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/journals.sagepub.com\/doi\/pdf\/10.1177\/14604582231180581","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/journals.sagepub.com\/doi\/full-xml\/10.1177\/14604582231180581","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/journals.sagepub.com\/doi\/pdf\/10.1177\/14604582231180581","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,4,29]],"date-time":"2026-04-29T22:28:15Z","timestamp":1777501695000},"score":1,"resource":{"primary":{"URL":"https:\/\/journals.sagepub.com\/doi\/10.1177\/14604582231180581"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,4]]},"references-count":41,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2023,4]]}},"alternative-id":["10.1177\/14604582231180581"],"URL":"https:\/\/doi.org\/10.1177\/14604582231180581","relation":{},"ISSN":["1460-4582","1741-2811"],"issn-type":[{"value":"1460-4582","type":"print"},{"value":"1741-2811","type":"electronic"}],"subject":[],"published":{"date-parts":[[2023,4]]},"article-number":"14604582231180581"}}