Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATABASES, API - Coggle Diagram
DATABASES
NoSQL
Can be scaled horizontally very well
Provides High Transactional Speed
Flexibility of storing data
Data is stored and structured in a free format (like JSON object)
No need to store null values as it is the case in RDBMS
Schema is easily changeable
Types of NoSQL DB
Document DBs
MongoDB
Data is stored in the form of JSON object schema
Key-Value DBs
Reddis DB
Data is stored in the form of key value pairs
Wide Column DBs
Cassandra DB
Stores all the data in columns instead of rows(these DBs can be scaled horizontally endlessly)
Graph/Node DBs
Neo4j
Compromised on
ACID
properties
Data can be insconsistent
All relevant data is contained together in a single blob.(
No need for joins
)
Insertions and retrievals are less costly as compared to RDBMS. JOIN is a costly operation.
Build specially for finding metrics/analysis/aggregations
Not build for many updates as
UPDATE=INSERT + DELETE
Not
Read optimized
comparatively slower transactions
API
Request
Website
REST(REpresentational State Transfer) API
A set of constraints to be used for creating APIs
Must follow
Client-Server architecture
Stateless
- API must not store any data about the client
Cacheable
- must cache the information so no need to call the same API again & again. Increases the same of loading website.
Layered
- Can call API from any layer
GET, PUT, POST, DELETE methods to be used in HTTP calls for various CRUD operations on DB
It is the set of rules that allows programs to talk to each other.
The developer creates the API on server and client talks to it.
Eg: Google Sign in, Youtube videos