Database Management/NoSQL

From Wikiversity
Jump to navigation Jump to search

Objectives and Skills[edit | edit source]

This lesson assists users in learning about NoSQL databases and how the NoSQL data model handles big data using current applications.

Readings[edit | edit source]

  1. freeCodeCamp: The basics of NoSQL databases
  2. TutorialsPoint: What is SQL? and is it the next big trend in databases?
  3. Guru99: NoSQL Tutorial: Learn NoSQL Features, Types, What is, Advantages
  4. TutorialsPoint: Importance of NoSQL
  5. TutorialsPoint: Difference Between SQL and NoSQL
  6. w3resourcs: NoSQL introduction

Multimedia[edit | edit source]

  1. Youtube: NoSQL Tutorial for Beginners | Introduction to NoSQL Databases | NoSQL Databases Tutorial
  2. Youtube: NoSQL Tutorial For Beginners | RDBMS Vs NoSQL | NoSQL Database Tutorial | Simplilearn
  3. Youtube: Big Data and NoSQL Database (BaSE)
  4. Youtube: An Introduction To NoSQL Databases
  5. Youtube: SQL vs NoSQL

Activities[edit | edit source]

  1. Research the evolution of NoSQL. FreeCodeCamp: The basics of NoSQL databases Identify the differences on how data is stored between SQL and NoSQL database management systems.
  2. While comparing data with enterprise database management systems, identify the pros and cons of NoSQL as compared to relational database management systems.
  3. Describe how NoSQL can handle large volumes of data and provide a relatable data example you are familiar with.

Lesson Summary[edit | edit source]

  • NoSQL systems are also sometimes called "Not only SQL" to emphasize that they may support SQL-like query languages and are viewed as more flexible than relational database tables. [1]
  • A sequence of database operations that satisfies the ACID properties (and these can be perceived as a single logical operation on the data) is called a transaction. For example, a transfer of funds from one bank account to another, even involving multiple changes such as debiting one account and crediting another, is a single transaction.[2]

To be enhanced by course participants

Key Terms[edit | edit source]

ACID (Atomicity, Consistency, Isolation and Durability) is a set of RDBMS properties of database transactions intended to guarantee validity even in the event of errors. [3]
CAP theorem (Brewer's theorem)
CAP theorem (Brewer’s theorem) states that it is impossible for a distributed data store to simultaneously provide more than two out of the following three guarantees: Consistency, Availability of resources and Partition tolerance.[4]
BASE model (Basically Available, Soft state, Eventual consistency). NoSQL uses the BASE model as compared to the ACID data model to achieve improved scalability using larger amounts of data.[5]
A NoSQL (originally referring to "non SQL" or "non relational") database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.[6]
A transaction generally represents any change in a database. A transaction symbolizes a unit of work performed within a database management system (or similar system) against a database, and treated in a coherent and reliable way independent of other transactions. [7]

To be enhanced by course participants

Review Questions[edit | edit source]

To be added by course participants

See Also[edit | edit source]

References[edit | edit source]