{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,1]],"date-time":"2026-04-01T18:13:26Z","timestamp":1775067206259,"version":"3.50.1"},"reference-count":34,"publisher":"Institute of Electrical and Electronics Engineers (IEEE)","issue":"2","license":[{"start":{"date-parts":[[2016,3,1]],"date-time":"2016-03-01T00:00:00Z","timestamp":1456790400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/ieeexplore.ieee.org\/Xplorehelp\/downloads\/license-information\/IEEE.html"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["IEEE J. Biomed. Health Inform."],"published-print":{"date-parts":[[2016,3]]},"DOI":"10.1109\/jbhi.2015.2392553","type":"journal-article","created":{"date-parts":[[2015,1,15]],"date-time":"2015-01-15T19:31:01Z","timestamp":1421350261000},"page":"644-654","source":"Crossref","is-referenced-by-count":9,"title":["Efficient Execution Methods of Pivoting for Bulk Extraction of Entity-Attribute-Value-Modeled Data"],"prefix":"10.1109","volume":"20","author":[{"given":"Gang","family":"Luo","sequence":"first","affiliation":[]},{"given":"Lewis J.","family":"Frey","sequence":"additional","affiliation":[]}],"member":"263","reference":[{"key":"ref33","doi-asserted-by":"publisher","DOI":"10.1097\/CCM.0b013e31820a92c6"},{"key":"ref32","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2009.08.007"},{"key":"ref31","first-page":"1298","article-title":"Increasing buffer-locality for multiple index based scans through intelligent placement and index scan speed control","author":"lang","year":"0","journal-title":"Proc Int Conf Very Large Data Bases"},{"key":"ref30","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2007.368972"},{"key":"ref34","doi-asserted-by":"publisher","DOI":"10.1161\/01.CIR.101.23.e215"},{"key":"ref10","year":"2014"},{"key":"ref11","doi-asserted-by":"publisher","DOI":"10.1016\/S0197-2456(00)00070-2"},{"key":"ref12","year":"2014"},{"key":"ref13","doi-asserted-by":"publisher","DOI":"10.1016\/j.jbi.2008.08.010"},{"key":"ref14","doi-asserted-by":"publisher","DOI":"10.1007\/978-0-85729-510-1"},{"key":"ref15","doi-asserted-by":"publisher","DOI":"10.1016\/S1386-5056(02)00047-3"},{"key":"ref16","first-page":"149","article-title":"Storage and querying of E-commerce data","author":"agrawal","year":"0","journal-title":"Proc 27th Int Conf Very Large Data Bases"},{"key":"ref17","doi-asserted-by":"publisher","DOI":"10.1016\/B978-012088469-8.50087-5"},{"key":"ref18","first-page":"471","article-title":"On efficiently implementing SchemaSQL on an SQL database system","author":"lakshmanan","year":"0","journal-title":"Proc Int Conf Very Large Data Bases"},{"key":"ref19","doi-asserted-by":"publisher","DOI":"10.1016\/j.cll.2007.10.003"},{"key":"ref28","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335419"},{"key":"ref4","first-page":"34","article-title":"The Regenstrief medical records","volume":"5","author":"mcdonald","year":"1988","journal-title":"MD Comput"},{"key":"ref27","doi-asserted-by":"publisher","DOI":"10.1136\/jamia.1998.0050511"},{"key":"ref3","doi-asserted-by":"publisher","DOI":"10.1197\/jamia.M2189"},{"key":"ref6","doi-asserted-by":"publisher","DOI":"10.1007\/BF00995117"},{"key":"ref29","doi-asserted-by":"publisher","DOI":"10.1145\/42201.42203"},{"key":"ref5","first-page":"335","article-title":"A generalized relational schema for an integrated clinical patient database","author":"friedman","year":"0","journal-title":"Proc Annu Symp Comput Appl Med Care"},{"key":"ref8","year":"2014"},{"key":"ref7","doi-asserted-by":"publisher","DOI":"10.1016\/0010-4809(72)90007-9"},{"key":"ref2","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2006.67"},{"key":"ref9","year":"2014"},{"key":"ref1","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijmedinf.2006.09.023"},{"key":"ref20","first-page":"189","article-title":"Clinical use of an enterprise data warehouse","author":"evans","year":"0","journal-title":"Proc AMIA Annu Symp"},{"key":"ref22","first-page":"951","article-title":"Role of materialized view maintenance with PIVOT and UNPIVOT operators","author":"rashid","year":"0","journal-title":"Proc IEEE Int Conf Adv Comput Commun"},{"key":"ref21","doi-asserted-by":"publisher","DOI":"10.1016\/j.cmpb.2006.02.001"},{"key":"ref24","author":"garcia-molina","year":"2008","journal-title":"Database Systems The Complete Book"},{"key":"ref23","first-page":"552","article-title":"GPIVOT: Efficient incremental maintenance of complex ROLAP views","author":"chen","year":"0","journal-title":"Proc Int Conf Data Eng"},{"key":"ref26","doi-asserted-by":"publisher","DOI":"10.1136\/jamia.1999.0060478"},{"key":"ref25","doi-asserted-by":"publisher","DOI":"10.1561\/0400000014"}],"container-title":["IEEE Journal of Biomedical and Health Informatics"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx7\/6221020\/7425118\/7010922.pdf?arnumber=7010922","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,1,12]],"date-time":"2022-01-12T16:48:27Z","timestamp":1642006107000},"score":1,"resource":{"primary":{"URL":"http:\/\/ieeexplore.ieee.org\/document\/7010922\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2016,3]]},"references-count":34,"journal-issue":{"issue":"2"},"URL":"https:\/\/doi.org\/10.1109\/jbhi.2015.2392553","relation":{},"ISSN":["2168-2194","2168-2208"],"issn-type":[{"value":"2168-2194","type":"print"},{"value":"2168-2208","type":"electronic"}],"subject":[],"published":{"date-parts":[[2016,3]]}}}