Anomaly free search using multi table entity attribute value data model
by Shivani Batra; Shelly Sachdeva
International Journal of Computational Science and Engineering (IJCSE), Vol. 16, No. 4, 2018

Abstract: In this paper, the authors are proposing a principled extension of dynamic tables (DT). It is termed multi table entity attribute value (MTEAV) model which offers a search efficient avenue for storing database. The authors present precise semantics of MTEAV and demonstrate the following: 1) MTEAV possesses consistency and availability; 2) MTEAV outperforms other existing models (entity attribute value model, dynamic tables, optimised entity attribute value and optimised column oriented model) under various query scenarios and varying datasets size; 3) MTEAV retains flavour of EAV in terms of handling sparseness and self-adapting schema changing capability. To heighten adaptability of MTEAV, authors implement a translation layer over existing SQL engine in a non-intrusive way. Translation layer transforms conventional SQL query (as per horizontal row representation) to a new SQL query (as per MTEAV structure) to maintain user friendliness. Translation layer makes user feel as if he/she is interacting with the conventional horizontal row approach. The authors also critically analyse maximum percentage of non-null density appropriate for choosing MTEAV as a storage option.

Online publication date: Mon, 06-Aug-2018

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Computational Science and Engineering (IJCSE):
Login with your Inderscience username and password:

Username:        Password:          Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com