ESE : Presentation (DBMS)

Emergence of NOSQL

Presented by :- Guided by :-
Harshwardhan Bhadke 28 Prof. Anil Kadu
Krishna Heda 30
Omkar Hepat 31
Subodh Humne 32 CS-B Batch 2
Group 1 1
Vishwaraj Ingawale 33
{GROUP 1,Division B-2}
 INTRODUCTION

When people use the term “NoSQL database,” they typically use it
to refer to any non-relational database. Some say the term
“NoSQL” stands for “non SQL” while others say it stands for “not
only SQL.” Either way, most agree that NoSQL databases are
databases that store data in a format other than relational tables.

2
 All about NoSQL
NoSQL is an umbrella term for any alternative system to
traditional SQL databases.
NoSQL databases use a data model that has a different
structure than the rows and columns table structure used with
RDBMS.
There are four kinds of this database: document databases,
key-value stores, column-oriented databases, and graph
databases.

3
 Why NoSQL

NoSQL databases are used in nearly every industry.

NOSQL provides more flexibilty when it comes to data
handling
There is no requirement to specify the schema to start working
with the application
Also NOSQL database does not put a restriction on the types
of data you can store together

4
 When To Use?
Fast-paced Agile development

Storage of structured and semi-structured data

Document-based

Huge volumes of data

Requirements for scale-out architecture

New application paradigms can be easily supported

Data Persistence

5
 Types of NoSQL
Database

1 Graph Databases: Examples – Amazon Neptune, Neo4j

2 Key value store: Examples – Memcached, Redis, Coherence

3 Column-based : Examples – Hbase, Big Table, Accumulo

Document-based: Examples – MongoDB, CouchDB,

4
Cloudant

6
Document Databases
Document database stores and organizes data in the
form of semi-structured or unstructured documents,
typically using formats like JSON or BSON
Easy access, storage, and retrieval of documents,
minimizing translation efforts for application use.
Document databases allow developers to store data with
varying structures within the same database.
Document databases are horizontally scalable.
Document databases often support powerful query
capabilities, including indexing and full-text search.
Common use cases include eCommerce platforms,
trading platforms, and mobile app development.

7
8
 Key-Value Stores
This is the simplest type of NoSQL database.
Every element is stored as a key-value pair consisting
of an attribute name ("key") and a value.
This database is like an RDBMS with two columns: the
attribute name (such as "ID") and the value (such as
"Name").
Use cases for NoSQL databases include shopping carts,
user preferences, and user profiles.

Data Persistence

9
Column-Oriented Databases

This organizes data as a set of columns.

Direct access to specific columns for analytics, reducing

memory consumption.

Columns have the same type and benefit from efficient

compression, resulting in faster reads.

Adding values in a specific column is easier in column-

oriented databases, making them suitable for analytics.
Data Persistence
The column-oriented layout makes it efficient to read just the
columns you need for a query.
10
Difference between relational and columnar database
11
 Graph Databases
Data Representation: Graph structure with nodes and
edges.

Relationship-Centric: Optimized for complex relationship

management.

Traversal and Performance: Efficient navigation through

connected data.

Schema Flexibility: No predefined schemas, adaptable to

changes.
Data Persistence
Use Cases: Social networks, recommendations, fraud
detection, and more.
12
As you can see we can easily
represent complex
relationships in graph
structure
13
 MongoDB (Document DB)
Distributed NoSQL database with flexible data storage and
no strict relationships.
Easy restructuring of data storage to adapt to changing
application needs.
Schema validation to define and enforce data structure
requirements.
Joining documents and establishing relationships through
lookup and references.
High availability, eliminating single points of failure.
Transactions ensure atomicity for reads and writes across
Data Persistence
multiple documents.
7.

14
 Data stored in JSON like format

Data stored in rows and columns as per its schema

15
©IntelliPaat

16
 NEO4J (Graph DB)
A graph database storing data as nodes, relationships,
and properties for complex interconnected data.
ACID transactions for data integrity and reliability
during concurrent operations.
Flexible Data Modeling: Schema-less nature allows
rapid iterations and adjustments to the data structure.
High Performance: Graph-specific optimizations enable
faster insights and data retrieval.
5.

Data Persistence

17
 Coherence and BigTable
Key-value store - Coherence:
Simple data model: Frequently accessed Data stored as
key-value pairs, facilitating fast retrieval.
No complex relationships: Limited support for complex
queries and joins.

Column-based (Bigtable):
Column-family data model: Organized into column families
for efficient storage.
Wide column store: Handles vast columns per row, ideal for
Data Persistence
sparsely populated data.

18
 KEY FEATURES
D yn a m i c s ch e m a

H o r i z o n t a l s c a l a b ilit y

D o cu m e n t - b a s e d

K e y- v a lu e - b a se d

Column-based

F le xi b i l i t y
Data Persistence

P e r f o r m a n ce
19
 Advantages
1 . H ig h S c a l a b ili t y

2 . F le x i b il it y

3 . H ig h A v a i la b i lit y

4.Performance

5.Cost-effectiveness

6 .A g i l it y
Data Persistence

20
Disadvantages of NoSQL
Lack of st andar di zat i on

I nt egr at i on compl exi t i es

Secur i t y

Backup and r ecover y chal l enges

Management chal l enge

GUI i s not avai l abl e

Data Persistence

21
Literature Review

22
Literature Review

23
THANK YOU

Con t ent
De p a r t ment
24