Document
Document
SCM222-1581/2024
STEPHEN MAINA grp B
Quiz.Discuss different data bases management systems available in
the market today.
1.distributed databases-is a database that stores data across multiple computers or
servers instead of a single machine.There are two types of distributed db.
Heterogenous database atype of database which can use different schema and software.
The distributed db include the cluster point,foundation db.they are applied in modern
computing environments and data intesive applications.
2.NoSQL DB-it reffers to a type of database that is not based on traditional relational
databases model using SQL instead focusing on flexible data structures like
documents,columns and graphs.They include mongo db,cassandra ,redis and amazon
dynamo.there are four types of NoSQL,
Key value store-which is a simple data structure where data is accessed using unique
keys, with Redis being prominent example.
Key value store-simple data structure where data is accesed using unique keys.
3.NewSQL
Data base that combines the scalability of NoSQL with consistency of SQL.They include
cockroach db ,Tidb,Nuodb.They have the following features.
Acid compliance-that is it can can adhere to ACID principles to ensure data consistency.
SQL interface-it uses the SQLas their primary intreface.
4.loud-based database
Microsoft azure-it allows users to store and serve data in the cloud.
5.Specialised databases
6.Object oriented db
It stores data as objects rather than tables with columns.They include object db,object
store,intersystemcatche.its components include classes,objects,attributes and method.
How it works
Examples of TSDBs include influsDB which is known for scalability and performance.
Reffers to a type of data base that stores data in a computers main memory,instead of on
the disc drive which allows faster accessof data which improves performance,
It has low latency,that is it can provide microsecond read latency and single read latency in
milliseconds.
It supports multiple data types that is it can store structured and unstructured data such
as voice video and documents.