Optimized Entity Attribute Value Model: A Search Efficient Representation of High Dimensional and Sparse Data
Razan Paul, Abu Sayed Md. Latiful Hoque · Interdisciplinary Bio Central · 2011
Entity Attribute Value (EAV) is the widely used solution to represent high dimensional and sparse data, but EAV is not search efficient for knowledge extraction. In this paper, we have proposed a search efficient data model: Optimized Entity Attribute Value (OEAV) for physical representation of high dimensional and sparse data as an alternative of widely used EAV. We have implemented both EAV and OEAV models in a data warehousing en-vironment and performed different relational and warehouse queries on both the models. The experimental results show that OEAV is dramatically search efficient and occupy less storage space compared to EAV.