Optimized Entity Attribute Value Model: A Search Efficient Representation of High Dimensional and Sparse Data

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 imple-mented both EAV and OEAV models in a data ware-housing environment and performed different relational and warehouse queries on both the models. The experi-mental results show that OEAV is dramatically search efficient and occupy less storage space compared to EAV.