DATABASE
- What is data base :-It is a collection of data and the Data is stores in the number of tables .That tables contains Data in a form of rows and columns.The datas are managed in the server called Database sever.
Types of Databases
1.SQL— Stuctured Query language.
2.MQL — Mongodb Query language.
3.Comments(set,get,del,etc) — To use the comments.
4.CQL — cassandra Query language.
Get Babuloob’s stories in your inbox
Join Medium for free to get updates from this writer.
5.Cypher — It is a language.
Let see detailed about it.
1.MYSQL,postgresql,Azure SQL server,oracle — It is the databases and it can only able to store the tabled structure of data so using the structured query language(SQL) to get a tabled output it can able to store the large amount of data and it is a RDBMS(relational database management system) becoz it can able to merge the data(tables)
#Table 1(data A,B,C,D)
#Table 2(data Q,W,E,R)
Merge table 1 and 2 (A,B,E,R)what ever we want just merge the tables it only can able to do in the relational management system
2.Mango db — It is a database it can only able to store the json,bson formatted data so using the (mango db query language) it will covert the raw data to the json,bson formatted data the languge contains the key value pairs of data.And it is (non relational ) so It could not able to relate the data.
3.Redis db — The relational data base stores the data in key value pairs of data it is also be a non-relational database because we didn’t able to combine or merge the two another data .
4.Apache cassandra — the apache cassandra have a same syntax of the (SQL) same using same query and same output but two different
- The SQL store and process the large amount of data butt in cassandra it store and contain very large amount of data with large column output.
- The SQL relational management system and the Cassandra is the not (relational) so its not able to merge or combine the data like SQL.
5.Neo4j (Graph database)— in neo4j is used the cypher to access the data it have the Graphical output .
