Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

nosql features and applications, Cheat Sheet of Database Management Systems (DBMS)

This document contains the intel about nsql features and applications

Typology: Cheat Sheet

2018/2019

Available from 11/08/2021

joyful-programmer
joyful-programmer 🇮🇳

5 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
FEATURES:
Schema agnostic(Scalability): A database schema is the description of all possible data
and data structures in a relational database. With a NoSQL database, a schema isn’t
required, giving you the freedom to store information without doing up‐front schema
design.
Nonrelational: Relations in a database establish connections between tables of data. For
example, a list of transaction details can be connected to a separate list of delivery details.
With a NoSQL database, this information is stored as an aggregate a single record
with everything about the transaction, including the delivery address.
Commodity hardware: Some databases are designed to operate best (or only) with
specialized storage and processing hardware. With a NoSQL database, cheap off‐the‐
shelf servers can be used. Adding more of these cheap servers allows NoSQL databases
to scale to handle more data.
Highly distributable: Distributed databases can store and process a set of information on
more than one device. With a NoSQL database, a cluster of servers can be used to hold a
single large database.
Applications: There is a large number of companies using NoSQL.
Google
Google’s Bigtable was created to provide wide-column storage for a range of Google’s
applications, including Orkut, Google Earth, web indexing, Google Maps, Google Books,
YouTube, blogger.com, Google Code and Google Mail.
Facebook
Apache Cassandra was created by Facebook to power their Inbox.
Cassandra worked by doing the following:
Cassandra indexed users’ messages and the terms (words, and so on) in the messages
and drove a search over all the content in those messages. The user ID was the
primary key. Each term became a super column, and the message IDs were the
column names.
pf2

Partial preview of the text

Download nosql features and applications and more Cheat Sheet Database Management Systems (DBMS) in PDF only on Docsity!

FEATURES :

  • Schema agnostic(Scalability): A database schema is the description of all possible data and data structures in a relational database. With a NoSQL database, a schema isn’t required, giving you the freedom to store information without doing up‐front schema design.
  • Nonrelational: Relations in a database establish connections between tables of data. For example, a list of transaction details can be connected to a separate list of delivery details. With a NoSQL database, this information is stored as an aggregate — a single record with everything about the transaction, including the delivery address.
  • Commodity hardware: Some databases are designed to operate best (or only) with specialized storage and processing hardware. With a NoSQL database, cheap off‐the‐ shelf servers can be used. Adding more of these cheap servers allows NoSQL databases to scale to handle more data.
  • Highly distributable: Distributed databases can store and process a set of information on more than one device. With a NoSQL database, a cluster of servers can be used to hold a single large database.

Applications : There is a large number of companies using NoSQL.

  • Google Google’s Bigtable was created to provide wide-column storage for a range of Google’s applications, including Orkut, Google Earth, web indexing, Google Maps, Google Books, YouTube, blogger.com, Google Code and Google Mail.
  • Facebook Apache Cassandra was created by Facebook to power their Inbox. Cassandra worked by doing the following:
  • Cassandra indexed users’ messages and the terms (words, and so on) in the messages and drove a search over all the content in those messages. The user ID was the primary key. Each term became a super column, and the message IDs were the column names.
  • Cassandra provided the ability to list all messages sent to and from a particular user. Here the user id was the primary key, the recipient IDs were the super columns, and the message IDs were the column names.
  • Amazon Amazon has created a separate database called DynamoDB as a service offered on the Amazon Web Services marketplace site.
  • LinkedIn LinkedIn has used Hadoop to churn information about relationships overnight and to push the latest graph information to the Voldemort key-value NoSQL store for query the next day. In this way, LinkedIn maintained a rolling view of all data in the service. Other Applications :
  • Adobe
  • Healthcare.gov
  • Foursquare
  • Digg
  • McGraw-Hill Education
  • Vermont Public Radio