Study on Potential Capabilities of a Nodb System

Abstract

There is a need of optimal data to query processing technique to handle the increasing database size, complexity, diversity of use. With the introduction of commercial website, social network, expectations are that the high scalability, more flexible database will replace the RDBMS. Complex application and Big Table require highly optimized queries. Users are facing the increasing bottlenecks in their data analysis. A growing part of the database community recognizes the need for significant and fundamental changes to database design. A new philosophy for creating database systems called noDB aims at minimizing the datato-query time, most prominently by removing the need to load data before launching queries. That will process queries without any data preparation or loading steps. There may not need to store data. User can pipe raw data from websites, DBs, excel sheets into two promise sample inputs without storing anything. This study is based on PostgreSQL systems. A series of the baseline experiment are executed to evaluate the Performance of this system as per-a. Data loading cost, b-Query processing timing, c-Avoidance of Collision and Deadlock, d-Enabling the Big data storage and e-Optimize query processing etc. The study found significant possible capabilities of noDB system over the traditional database management system.