{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,14]],"date-time":"2026-02-14T10:31:11Z","timestamp":1771065071061,"version":"3.50.1"},"reference-count":73,"publisher":"MDPI AG","issue":"1","license":[{"start":{"date-parts":[[2017,12,29]],"date-time":"2017-12-29T00:00:00Z","timestamp":1514505600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Information"],"abstract":"<jats:p>Entity Attribute Value (EAV) storage model is extensively used to manage healthcare data in existing systems, however it lacks search efficiency. This study examines an entity attribute value style modeling approach for standardized Electronic Health Records (EHRs) database. It sustains qualities of EAV (i.e., handling sparseness and frequent schema evolution) and provides better performance for queries in comparison to EAV. It is termed as the Two Dimensional Entity Attribute Value (2D EAV) model. Support for ad-hoc queries is provided through a user interface for better user-interaction. 2D EAV focuses on how to handle template-centric queries as well as other health query scenarios. 2D EAV is analyzed (in terms of minimum non-null density) to make a judgment about the adoption of 2D EAV over n-ary storage model of RDBMS. The primary aim of current research is to handle sparseness, frequent schema evolution, and efficient query support altogether for standardized EHRs. 2D EAV will benefit data administrators to handle standardized heterogeneous data that demands high search efficiency. It will also benefit both skilled and semi-skilled database users (such as, doctors, nurses, and patients) by providing a global semantic interoperable mechanism of data retrieval.<\/jats:p>","DOI":"10.3390\/info9010002","type":"journal-article","created":{"date-parts":[[2017,12,29]],"date-time":"2017-12-29T10:58:47Z","timestamp":1514545127000},"page":"2","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":8,"title":["Entity Attribute Value Style Modeling Approach for Archetype Based Data"],"prefix":"10.3390","volume":"9","author":[{"given":"Shivani","family":"Batra","sequence":"first","affiliation":[{"name":"Department of Computer Science and Engineering, Jaypee Institute of Information Technology University, Noida 201304, India"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shelly","family":"Sachdeva","sequence":"additional","affiliation":[{"name":"Department of Computer Science and Engineering, Jaypee Institute of Information Technology University, Noida 201304, India"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-3294-9013","authenticated-orcid":false,"given":"Subhash","family":"Bhalla","sequence":"additional","affiliation":[{"name":"Division of Information Systems, University of Aizu, Fukushima 965-8580, Japan"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"1968","published-online":{"date-parts":[[2017,12,29]]},"reference":[{"key":"ref_1","doi-asserted-by":"crossref","first-page":"769","DOI":"10.1016\/j.ijmedinf.2006.09.023","article-title":"Guidelines for the effective use of entity\u2013attribute\u2013value modeling for biomedical databases","volume":"76","author":"Dinu","year":"2007","journal-title":"Int. J. Med. Inform."},{"key":"ref_2","unstructured":"Ramakrishnan, R., and Gehrke, J. (2000). Database Management Systems, McGraw Hill."},{"key":"ref_3","unstructured":"Agrawal, R., Somani, A., and Xu, Y. (2001). Storage and Querying of E-Commerce Data, VLDB."},{"key":"ref_4","doi-asserted-by":"crossref","unstructured":"Chu, E., Beckmann, J., and Naughton, J. (2007, January 11\u201314). The case for a wide-table approach to manage sparse relational data sets. Proceedings of the 2007 ACM SIGMOD International Conference on Management of Data, Beijing, China.","DOI":"10.1145\/1247480.1247571"},{"key":"ref_5","doi-asserted-by":"crossref","unstructured":"Beckmann, J.L., Halverson, A., Krishnamurthy, R., and Naughton, J.F. (2006, January 3\u20137). Extending RDBMSs to support sparse datasets using an interpreted attribute storage format. Proceedings of the 22nd International Conference on Data Engineering (ICDE\u201906), Atlanta, GA, USA.","DOI":"10.1109\/ICDE.2006.67"},{"key":"ref_6","doi-asserted-by":"crossref","first-page":"268","DOI":"10.1145\/971699.318923","article-title":"A decomposition storage model","volume":"14","author":"Copeland","year":"1985","journal-title":"ACM SIGMOD Rec."},{"key":"ref_7","unstructured":"Freire, S.M., Sundvall, E., Karlsson, D., and Lambrix, P. (2012, January 2\u20133). Performance of xml databases for epidemiological queries in archetype-based ehrs. Proceedings of the Scandinavian Conference on Health Informatics 2012, Link\u00f6ping, Sweden. No. 070."},{"key":"ref_8","unstructured":"(2016, February 18). Node+Path Persistence. Available online: https:\/\/openehr.atlassian.net\/wiki\/pages\/viewpage.action?pageId=6553626."},{"key":"ref_9","doi-asserted-by":"crossref","unstructured":"Wang, L., Min, L., Wang, R., Lu, X., and Duan, H. (2015). Archetype relational mapping-a practical openEHR persistence solution. BMC Med. Inform. Decis. Mak., 15.","DOI":"10.1186\/s12911-015-0212-0"},{"key":"ref_10","doi-asserted-by":"crossref","first-page":"86","DOI":"10.1197\/jamia.M2189","article-title":"Dynamic tables: An architecture for managing evolving, heterogeneous biomedical data in relational database management systems","volume":"14","author":"Corwin","year":"2007","journal-title":"J. Am. Med. Inform. Assoc."},{"key":"ref_11","doi-asserted-by":"crossref","first-page":"644","DOI":"10.1109\/JBHI.2015.2392553","article-title":"Efficient execution methods of pivoting for bulk extraction of Entity-Attribute-Value-modeled data","volume":"20","author":"Luo","year":"2016","journal-title":"IEEE J. Biomed. Health Inform."},{"key":"ref_12","doi-asserted-by":"crossref","first-page":"585","DOI":"10.1016\/j.ijmedinf.2010.04.007","article-title":"Extraction of standardized archetyped data from Electronic Health Record Systems based on the Entity-Attribute-Value Model","volume":"79","author":"Duftschmid","year":"2010","journal-title":"Int. J. Med. Inform."},{"key":"ref_13","doi-asserted-by":"crossref","first-page":"328","DOI":"10.1136\/jamia.1996.97035024","article-title":"Generic data modeling for clinical repositories","volume":"3","author":"Johnson","year":"1996","journal-title":"J. Am. Med. Inform. Assoc."},{"key":"ref_14","doi-asserted-by":"crossref","first-page":"385","DOI":"10.1007\/s00778-008-0125-y","article-title":"SW-Store: A vertically partitioned DBMS for Semantic Web data management","volume":"18","author":"Abadi","year":"2009","journal-title":"VLDB J."},{"key":"ref_15","doi-asserted-by":"crossref","first-page":"103","DOI":"10.1007\/BF00995117","article-title":"A chartless record\u2014Is it adequate?","volume":"7","author":"Stead","year":"1983","journal-title":"J. Med. Syst."},{"key":"ref_16","doi-asserted-by":"crossref","first-page":"65","DOI":"10.1016\/0010-4809(72)90007-9","article-title":"HELP\u2014A program for medical decision making","volume":"5","author":"Warner","year":"1972","journal-title":"Comput. Biomed. Res."},{"key":"ref_17","first-page":"22","article-title":"The HELP medical record system","volume":"5","author":"Pryor","year":"1988","journal-title":"MD Comput."},{"key":"ref_18","unstructured":"Huff, S.M., Haug, D.J., Stevens, L.E., Dupont, C.C., and Pryor, T.A. (1994, January 5\u20139). HELP the next generation: A new clientserver architecture. Proceedings of the 18th Symposium on Computer Applications in Medical Care, Washington, DC, USA."},{"key":"ref_19","doi-asserted-by":"crossref","first-page":"139","DOI":"10.1136\/jamia.1998.0050139","article-title":"Managing attribute-value clinical trials data using the ACT\/DB client\u2014Server database system","volume":"5","author":"Nadkarni","year":"1998","journal-title":"J. Am. Med. Inform. Assoc."},{"key":"ref_20","doi-asserted-by":"crossref","first-page":"440","DOI":"10.1016\/S0197-2456(00)00070-2","article-title":"Reengineering a database for clinical trials management: Lessons for system architects","volume":"21","author":"Brandt","year":"2000","journal-title":"Control. Clin. Trials"},{"key":"ref_21","doi-asserted-by":"crossref","first-page":"478","DOI":"10.1136\/jamia.1999.0060478","article-title":"Organization of Heterogeneous Scientific Data Using the EAV\/CR Representation","volume":"6","author":"Nadkarni","year":"1999","journal-title":"J. Am. Med. Inform. Assoc."},{"key":"ref_22","unstructured":"Koslow, S.H., and Huerta, M.F. (1997). Senselab: A project in multidisciplinary, multilevel sensory integration. Neuroinformatics: An Overview of the Human Brain Project, Lawrence Erlbaum Associates, Inc."},{"key":"ref_23","doi-asserted-by":"crossref","unstructured":"Marenco, L., Nadkarni, P., Skoufos, E., Shepherd, G., and Miller, P. (1999, January 6\u201310). Neuronal database integration: The Senselab EAV data model. Proceedings of the AMIA Symposium, Washington, DC, USA.","DOI":"10.1136\/jamia.1999.0060478"},{"key":"ref_24","unstructured":"(2016, August 10). Oracle Health Sciences Clintrial|Oracle. Available online: http:\/\/www.oracle.com\/us\/industries\/life-sciences\/health-sciences-clintrial-363570.html."},{"key":"ref_25","unstructured":"(2016, August 14). Oracle Clinical\u2014Overview|Oracle. Available online: http:\/\/www.oracle.com\/us\/products\/applications\/health-sciences\/e-clinical\/clinical\/index.html."},{"key":"ref_26","unstructured":"(2016, August 14). Oracle Designer Product Information. Available online: http:\/\/www.oracle.com\/technetwork\/developer-tools\/designer\/overview\/index-082236.html."},{"key":"ref_27","unstructured":"(2016, August 14). Kalido\u2014Home. Available online: http:\/\/kalido.com\/."},{"key":"ref_28","unstructured":"Evans, R.S., Lloyd, J.F., and Pierce, L.A. (2012, January 3\u20137). Clinical use of an enterprise data warehouse. Proceedings of the AMIA Annual Symposium Proceedings, Chicago, IL, USA."},{"key":"ref_29","unstructured":"(2017, September 12). Entity\u2013Attribute\u2013Value Model\u2014Wikipedia. Available online: https:\/\/en.wikipedia.org\/wiki\/Entity%E2%80%93attribute%E2%80%93value_model."},{"key":"ref_30","doi-asserted-by":"crossref","first-page":"1061","DOI":"10.1109\/JBHI.2014.2357025","article-title":"Semantic normalization and query abstraction based on SNOMED-CT and HL7: Supporting multicentric clinical Trials","volume":"19","author":"Bucur","year":"2015","journal-title":"IEEE J. Biomed. Health Inform."},{"key":"ref_31","unstructured":"(2016, October 10). OpenEHR Community. Available online: http:\/\/www.openehr.org\/."},{"key":"ref_32","unstructured":"(2016, July 11). CEN\u2014European Committee for Standardization: Standards. Available online: http:\/\/www.cen.eu\/CEN\/Sectors\/TechnicalCommitteesWorkshops\/CENTechnicalCommittees\/Pages\/Standards.aspx?param=6232&title=CEN\/TC+251."},{"key":"ref_33","unstructured":"ISO 13606-1 (2008). Health Informatics: Electronic Health Record Communication. Part 1: RM, International Organization for Standardization (ISO). [1st ed.]."},{"key":"ref_34","unstructured":"ISO 13606-2 (2008). Health Informatics: Electronic Health Record Communication. Part 2: Archetype Interchange Specification, International Organization for Standardization (ISO). [1st ed.]."},{"key":"ref_35","unstructured":"HL7 (2013, October 23). Health Level 7. Available online: www.hl7.org."},{"key":"ref_36","unstructured":"Beale, T., and Heard, S. (2008). The openEHR architecture: Architecture\/overview. openEHR Release 1.0.2, openEHR Foundation."},{"key":"ref_37","doi-asserted-by":"crossref","first-page":"124","DOI":"10.1109\/4233.735777","article-title":"A CORBA-based integration of distributed electronic healthcare records using the synapses approach","volume":"2","author":"Grimson","year":"1998","journal-title":"IEEE Trans. Inf. Technol. Biomed."},{"key":"ref_38","doi-asserted-by":"crossref","first-page":"271","DOI":"10.4258\/hir.2013.19.4.271","article-title":"Archetype model-driven development framework for EHR web system","volume":"19","author":"Kobayashi","year":"2013","journal-title":"Healthc. Inform. Res."},{"key":"ref_39","doi-asserted-by":"crossref","first-page":"872","DOI":"10.1109\/JBHI.2013.2285441","article-title":"On the seamless, harmonized use of ISO\/IEEE11073 and openEHR","volume":"18","author":"Trigo","year":"2014","journal-title":"IEEE J. Biomed. Health Inform."},{"key":"ref_40","doi-asserted-by":"crossref","unstructured":"Sachdeva, S., and Bhalla, S. (2012). Semantic interoperability in standardized electronic health record databases. J. Data Inf. Qual. (JDIQ), 3.","DOI":"10.1145\/2166788.2166789"},{"key":"ref_41","unstructured":"CKM (2016, December 12). Clinical Knowledge Manager. Available online: http:\/\/www.openehr.org\/knowledge\/."},{"key":"ref_42","unstructured":"International Health Terminology Standards Development Organisation (2016, September 14). Systematized Nomenclature of Medicine-Clinical Terms (SNOMED CT). Available online: http:\/\/www.ihtsdo.org\/snomed-ct\/."},{"key":"ref_43","unstructured":"Nadkarni, P. (2016). Clinical Research Computing: A Practitioner\u2019s Handbook, Academic Press. Chapter 3."},{"key":"ref_44","doi-asserted-by":"crossref","unstructured":"Tahara, D., Diamond, T., and Abadi, D.J. (2014, January 22\u201327). Sinew: A SQL system for multi-structured data. Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, Snowbird, UT, USA.","DOI":"10.1145\/2588555.2612183"},{"key":"ref_45","doi-asserted-by":"crossref","first-page":"45","DOI":"10.1145\/3003665.3003674","article-title":"What\u2019s Really New with NewSQL?","volume":"45","author":"Pavlo","year":"2016","journal-title":"ACM SIGMOD Rec."},{"key":"ref_46","doi-asserted-by":"crossref","first-page":"219","DOI":"10.1109\/TKDE.2009.66","article-title":"Exploring correlated subspaces for efficient query processing in sparse databases","volume":"22","author":"Cui","year":"2010","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"ref_47","unstructured":"(2017, September 24). Use Sparse Columns|Microsoft Docs. Available online: https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/tables\/use-sparse-columns."},{"key":"ref_48","unstructured":"Abadi, D.J. (2007). Column Stores for Wide and Sparse Data, CIDR."},{"key":"ref_49","doi-asserted-by":"crossref","unstructured":"Larson, P.A., Clinciu, C., Fraser, C., Hanson, E.N., Mokhtar, M., Nowakiewicz, M., Papadimos, V., Price, S.L., Rangarajan, S., and Rusanu, R. (2013, January 22\u201327). Enhancements to SQL server column stores. Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data, New York, NY, USA.","DOI":"10.1145\/2463676.2463708"},{"key":"ref_50","unstructured":"Ailamaki, A., DeWitt, D.J., Hill, M.D., and Skounakis, M. (2001, January 11\u201314). Weaving Relations for Cache Performance. Proceedings of the 27th International Conference on Very Large Data Bases, Rome, Italy."},{"key":"ref_51","doi-asserted-by":"crossref","first-page":"89","DOI":"10.1007\/s00778-003-0093-1","article-title":"A case for fractured mirrors","volume":"12","author":"Ramamurthy","year":"2003","journal-title":"VLDB J."},{"key":"ref_52","doi-asserted-by":"crossref","first-page":"105","DOI":"10.14778\/1921071.1921077","article-title":"HYRISE: A main memory hybrid storage engine","volume":"4","author":"Grund","year":"2010","journal-title":"Proc. VLDB Endow."},{"key":"ref_53","doi-asserted-by":"crossref","unstructured":"Pinnecke, M., Broneske, D., Durand, G.C., and Saake, G. (2017, January 19\u201322). Are Databases Fit for Hybrid Workloads on GPUs? A Storage Engine\u2019s Perspective. Proceedings of the 2017 IEEE 33rd International Conference on Data Engineering (ICDE), San Diego, CA, USA.","DOI":"10.1109\/ICDE.2017.237"},{"key":"ref_54","unstructured":"Bornhoevd, C., and Werner, H. (2013). Dynamic Database Schemas for Highly Irregularly Structured or Heterogeneous Data. (8,352,510), U.S. Patent."},{"key":"ref_55","unstructured":"Baumgartner, C., Plant, C., Railing, K., Kriegel, H.P., and Kroger, P. (2004, January 1\u20134). Subspace selection for clustering high-dimensional data. Proceedings of the Fourth IEEE International Conference on Data Mining (ICDM\u201904), Brighton, UK."},{"key":"ref_56","unstructured":"Zhang, D., Chee, Y.M., Mondal, A., Tung, A.K., and Kitsuregawa, M. (April, January 29). Keyword search in spatial databases: Towards searching by document. Proceedings of the IEEE 25th International Conference on Data Engineering (ICDE\u201909), Shanghai, China."},{"key":"ref_57","doi-asserted-by":"crossref","unstructured":"Abadi, D.J., Myers, D.S., DeWitt, D.J., and Madden, S.R. (2007, January 15\u201320). Materialization strategies in a column-oriented DBMS. Proceedings of the IEEE 23rd International Conference on Data Engineering (ICDE 2007), Istanbul, Turkey.","DOI":"10.1109\/ICDE.2007.367892"},{"key":"ref_58","doi-asserted-by":"crossref","first-page":"124","DOI":"10.1136\/jamia.2009.000893","article-title":"Serving the enterprise and beyond with informatics for integrating biology and the bedside (i2b2)","volume":"17","author":"Murphy","year":"2010","journal-title":"J. Am. Med. Inform. Assoc."},{"key":"ref_59","doi-asserted-by":"crossref","unstructured":"Deshmukh, V.G., Meystre, S.M., and Mitchell, J.A. (2009). Evaluating the informatics for integrating biology and the bedside system for clinical research. BMC Med. Res. Methodol., 9.","DOI":"10.1186\/1471-2288-9-70"},{"key":"ref_60","doi-asserted-by":"crossref","first-page":"277","DOI":"10.1016\/j.jbi.2016.08.007","article-title":"Automated population of an i2b2 clinical data warehouse from an openEHR-based data repository","volume":"63","author":"Haarbrandt","year":"2016","journal-title":"J. Biomed. Inform."},{"key":"ref_61","doi-asserted-by":"crossref","unstructured":"Ramachandran, R., Nair, D.P., and Jasmi, J. (2016, January 15\u201317). A horizontal fragmentation method based on data semantics. Proceedings of the 2016 IEEE International Conference on Computational Intelligence and Computing Research (ICCIC), Chennai, India.","DOI":"10.1109\/ICCIC.2016.7919539"},{"key":"ref_62","unstructured":"(2016, December 10). OpenEHR\u2014Wikipedia. Available online: https:\/\/en.wikipedia.org\/wiki\/OpenEHR."},{"key":"ref_63","unstructured":"(2016, December 10). Ocean Informatics. Available online: https:\/\/code4health.org\/_attachment\/modellingintro\/2015_11_Modelling_Intro.pdf."},{"key":"ref_64","unstructured":"(2016, December 10). Poll Results\u2014Top 10 Archetypes for Use in an Emergency\u2014Health Information Model\u2014openEHR Wiki. Available online: https:\/\/openehr.atlassian.net\/wiki\/display\/healthmod\/Poll+Results+Top+10+archetypes+for+use+in+an+Emergency."},{"key":"ref_65","unstructured":"(2016, December 10). openEHR-Modelling Tools. Available online: http:\/\/www.openehr.org\/downloads\/modellingtools."},{"key":"ref_66","doi-asserted-by":"crossref","unstructured":"Batra, S., Sachdeva, S., Mehndiratta, P., and Parashar, H.J. (2014). Mining standardized semantic interoperable electronic healthcare records. Biomedical Informatics and Technology, Springer.","DOI":"10.1007\/978-3-642-54121-6_16"},{"key":"ref_67","unstructured":"CNET Networks, Inc. (2016, September 12). CNET Product Directory. Available online: http:\/\/shopper.cnet.com\/4296-3000_9-0-0-0.html."},{"key":"ref_68","unstructured":"(2016, September 12). UCI Machine Learning Repository: Liver Disorders Data Set. Available online: https:\/\/archive.ics.uci.edu\/ml\/datasets\/Liver+Disorders."},{"key":"ref_69","unstructured":"(2016, September 12). UCI Machine Learning Repository: Thyroid Disease Data Set. Available online: https:\/\/archive.ics.uci.edu\/ml\/datasets\/Thyroid+Disease."},{"key":"ref_70","unstructured":"(2016, September 12). The Facts about High Blood Pressure\u2014American Heart Association. Available online: http:\/\/www.heart.org\/HEARTORG\/Conditions\/HighBloodPressure\/GettheFactsAboutHighBloodPressure\/The-Facts-About-High-Blood-Pressure_UCM_002050_Article.jsp#.WSpqPGiGPIU."},{"key":"ref_71","unstructured":"(2017, November 15). DB-Engines Ranking\u2014Popularity Ranking of Database Management Systems. Available online: http:\/\/db-engines.com\/en\/ranking."},{"key":"ref_72","unstructured":"(2017, November 15). Our Customers|MongoDB. Available online: https:\/\/www.mongodb.com\/who-uses-mongodb."},{"key":"ref_73","unstructured":"Beale, T., and Heard, S. (2008). The openEHR Archetype Model\u2014Archetype Definition Language ADL 1.4. openEHR Release 1.0.2, openEHR Foundation."}],"container-title":["Information"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2078-2489\/9\/1\/2\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,11]],"date-time":"2025-10-11T18:55:59Z","timestamp":1760208959000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2078-2489\/9\/1\/2"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017,12,29]]},"references-count":73,"journal-issue":{"issue":"1","published-online":{"date-parts":[[2018,1]]}},"alternative-id":["info9010002"],"URL":"https:\/\/doi.org\/10.3390\/info9010002","relation":{},"ISSN":["2078-2489"],"issn-type":[{"value":"2078-2489","type":"electronic"}],"subject":[],"published":{"date-parts":[[2017,12,29]]}}}