Database Systems Introduction to Databases and Data Warehouses

NOSQL DATABASES § NOSQL databases • Database that is not based on the relational model • Does not use SQL as a query language • Data does not have to be stored in structures described by an organized database schema Jukić, Vrbsky, Nestorov – Database Systems Copyright (c) 2016 Nenad Jukic and Prospect Press Appendix I – Slide

NOSQL DATABASES § NOSQL database example: Mongo. DB • A document-oriented No. SQL database • Organized around collections of documents o Collection – equivalent to a table o Documents – equivalent to a table row Jukić, Vrbsky, Nestorov – Database Systems Copyright (c) 2016 Nenad Jukic and Prospect Press Appendix I – Slide

Mongo. DB Example Code for document creation h 1 = {name: “Metro Blu”, address: “Chicago, IL”, rating: 3. 5} db. hotels. save(h 1) h 2 = {name: “Experiential”, address: “New York, NY”, rating: 4} db. hotels. save(h 2) h 3 = {name: “Zazu Hotel”, address: “San Francisco, CA”, rating: 4. 5} db. hotels. save(h 3) h 4 = {name: “Solace”, address: “Los Angeles, CA”} db. hotels. save(h 4) Jukić, Vrbsky, Nestorov – Database Systems Copyright (c) 2016 Nenad Jukic and Prospect Press Appendix I – Slide

Mongo. DB Example Queries db. hotels. find() db. hotels. find( { address : { $regex : “CA” } } ) Jukić, Vrbsky, Nestorov – Database Systems Copyright (c) 2016 Nenad Jukic and Prospect Press Appendix I – Slide

Mongo. DB Example Updates db. hotels. update( { name: “Zazu Hotel” }, { $set : {wifi: “free”} } ) db. hotels. update( { name: “Zazu Hotel” }, { $set : {parking: 45} } ) Jukić, Vrbsky, Nestorov – Database Systems Copyright (c) 2016 Nenad Jukic and Prospect Press Appendix I – Slide

NOSQL DATABASES § NOSQL databases vs. relational databases Fixed Schema Scalability Transaction Properties Standard Language Jukić, Vrbsky, Nestorov – Database Systems NOSQL No Horizontal BASE none Copyright (c) 2016 Nenad Jukic and Prospect Press Relational Yes Vertical ACID SQL Appendix I – Slide 7