This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
2012 IEEE Fifth International Conference on Cloud Computing
Sensor Data Storage Performance: SQL or NoSQL, Physical or Virtual
Honolulu, HI, USA USA
June 24-June 29
ISBN: 978-1-4673-2892-0
Sensors are used to monitor certain aspects of the physical or virtual world and databases are typically used to store the data that these sensors provide. The use of sensors is increasing, which leads to an increasing demand on sensor data storage platforms. Some sensor monitoring applications need to automatically add new databases as the size of the sensor network increases. Cloud computing and virtualization are key technologies to enable these applications. A key issue therefore becomes the performance of virtualized databases and how this relates to physical ones. Traditional SQL databases have been used for a long time and have proven to be reliable tools for all kinds of applications. NoSQL databases have gained momentum in the last couple of years however, because of growing scalability and availability requirements. This paper compares three databases on their relative performance with regards to sensor data storage: one open source SQL database(PostgreSQL) and two open source NoSQL databases (Cassandra and MongoDB). A comparison is also made between running these databases on a physical server and running them on a virtual machine. A minimal sensor data structure is used and tested using four operations: a single write, a single read, multiple writes in one statement and multiple reads in one statement.
Index Terms:
Servers,Indexes,Virtual machining,Data structures,Data systems,Memory,Virtual Machine,Sensor Data,Data Storage,Performance,SQL,NoSQL,Physical Server
Citation:
Jan Sipke van der Veen, Bram van der Waaij, Robert J. Meijer, "Sensor Data Storage Performance: SQL or NoSQL, Physical or Virtual," cloud, pp.431-438, 2012 IEEE Fifth International Conference on Cloud Computing, 2012
Usage of this product signifies your acceptance of the Terms of Use.