A Review Of Leading Databases: Relational & Non-Relational Database
i-manager s Journal on Information Technology · 2016
Relational databases have been around for so many years and are the choice of most technologies for their database needs, for most traditional data-intensive storage and retrieval capabilities for filtering, data transformation & management. Retrieval of data is normally achieved using SQL, query language. Relational database or traditional database systems are normally efficient unless database requires to process, update or modify, and join relationships of large database tables. In recent years, there has been much interest in fast data retrieval from data stores because of Structured Query Language (SQL) environment, which is not fast enough, so a new structure for database is used exclusively, the socalled NoSQL movement. Relational database system is very effective with robustness, scalability requirements reliability and flexibility, but when it's a question of need of modern application which are generating huge data & generally unstructured data, the relational database fails. Non-relational database system shows true usability in such case. Basis of characteristics, tool which are commonly used in both DB technologies are mentioned in this paper for brief introduction of tools. By comparing tools, we can find the distinctive features of both database systems (relational and non-relational database). The research comprises of studying various relational and non-relational databases for storing and retrieval of large mass of data. The attributes and features of both are listed below.