Enhancing Data Consistency Through Referential Integrity In Document Oriented NoSQL Databases

Abstract

The purpose of this paper is to present an efficient strategy for managing the data integrity among the documents of document-oriented NoSQL databases in distributed environment. Most of the document-oriented NoSQL databases do not provide any built-in mechanism for maintaining data integrity through establishing document relationships through managing referential integrity constraints which restrict applications to use these databases where data integrity and consistency is essential. In document-oriented NoSQL databases, generally data consistency is negotiated or it has been given not much important as relational database systems. So, we have proposed various strategies that not only manage data integrity in terms of establishing referential integrity constraints but also maintain data consistency among the documents of document-oriented NoSQL databases. For deciding the efficient strategy among the proposed strategies, various database operations are executed in a document-oriented NoSQL database and the results are obtained and analysed by measuring the execution time.