SQL vs NOSQL

Differences between Sql and Nosql Database:





Comments

Post a Comment

Popular posts from this blog

FC Barcelona vs Real Madrid -El Clasico Rivalry.

Image
                              El Clasico The Story of the Rivalry between FC Barcelona and Real Madrid  The rivalry comes about as  Madrid  and  Barcelona  are the two largest cities in Spain, and they are sometimes  identified  with opposing political positions, with Real Madrid viewed as representing  Spanish nationalism  and Barcelona viewed as representing  Catalan nationalism . It is considered one of the biggest club  football  games in the world, and is among the most viewed annual sporting events.  It has always been a heated match, from both sides. Political background: The rivalry between the the two most successful clubs in football started with an oft-ignored political backstory and contrasts in how both clubs were made.  FC Barcelona was founded by --> Joan Gamper along with several foreign-...
Read more

How DNS Works?

Image
DNS- (domain name service ): The Internet's system for converting alphabetic names into numeric IP addresses. For example, when a Web address (URL) is typed into a browser,  DNS servers return the IP address of the Web server associated with that name. ->DNS uses UDP.-(Because as DNS need to be fast TCP is not prefered as TCP has a large                               overhead). ->DNS servers bind to UDP port no 53. HOW IT WORKS ❓❓❓❓ Terms you should know: Resolving Name Server. Root Server TLD Server. Authoritati ve Name Server.
Read more

Different Type of keys in Database Managemenet System.

Image
All super, candidate and primary, secondary keys are used to uniquely distinguish all rows in data base. But the main difference between them is. Super 🔑 -superset of candidate keys Candidate 🔑 -subset of super key, it is a single key or least combination of feild that uniquely  identifies every tuple. Primary 🔑- it is a candidate key that is most appropriate to become main key for the table. Secondary 🔑- candidate keys which are not selected as primary keys. Non-key attributes (attributes other than candidate keys) Non prime attributes (attributes other than primary key) Foreign 🔑?? It is a feild in one table that uniquely identifies a row in another table They are constraints between column of tables. Example:
Read more