Skip to main content

MongoDB vs SQL

MongoDB vs SQL

MongoDB vs SQL
(Image by - Sharma Guides | Subham232330)


MongoDB

  • MongoDB is used to store both structured and unstructured data
  • Data stored in JSON-like documents
  • MongoDB does not support JOIN and global transactions
  • MongoDB is fast and scalable
  • Schemaless


SQL

  • SQL is used to store only structured data
  • Data stored in table form
  • SQL support JOIN and global transactions
  • SQL is slow
  • Require Schema



Labels:

Comments

Post a Comment

Please do not enter any spam link in the comment box.

Popular posts from this blog

Access Control Methods in DBMS

Access control in DBMS Database access control is a method of allowing access to a company’s sensitive data only to those people (database users) who are allowed to access such data and to restrict access to unauthorized persons. It includes two main components: authentication and authorization. Authentication is a method of verifying the identity of a person who is accessing your database. Note that authentication isn’t enough to protect data. An additional layer of security is required, authorization, which determines whether a user should be allowed to access the data or make the transaction he’s attempting. Without authentication and authorization, there is no data security. Any company whose employees connect to the Internet, thus, every company today, needs some level of access control implemented. Types of Access Control Obsolete access models include Discretionary Access Control (DAC) and Mandatory Access Control (MAC). Role Based Access Control (RBAC) is the most common method...
Post a Comment
Read more

Some special shortcut keys are used in MS WORD এ ব্যবহৃত কয়েকটি বিশেষ শর্টকাট কী

Some special shortcut keys are used in ms word ms word এ ব্যবহৃত কয়েকটি বিশেষ শর্টকাট কী F1 = Help বা Office Assistant পাওয়া যায় F2 = text বা Graphyics স্থানান্তর করে F3 = Auto Text Insert হয় F4 = শেষ কাজটির পুনরাবৃত্তি হয় F5 = Edit মেনুর Go To কম্যান্ড পাওয়া যায় F6 = নতুন ফ্রেমে যাওয়া যায় F7 = Tools মেনুর Spelling কম্যান্ড পাওয়া যায় F8 = কোনো Selection কে বাড়ানো যায় F9 = Select করা field গুলিকে Update করা যায় F10 = মেনুবার Active হয় F11 = পরের Field টিতে যাওয়া যায় F12 = File মেনুর Save As কম্যান্ড পাওয়া যায় Ctrl + Shift + F = Font পাল্টানো যায় Ctrl + Shift + P = Font সাইজ পাল্টানো যায় Ctrl + Shift + > = Font সাইজ বৃদ্ধি হয় Ctrl + Shift + < = Font সাইজ কমিয়ে হয় Ctrl + ] = Font সাইজ 1 Point বাড়ে Ctrl + [ = Font সাইজ 1 Point কমে Ctrl + D = Format মেনুর Font কম্যান্ড পাওয়া যায় Ctrl + F3 = অক্ষরগুলির case পরিবর্তন হয় Ctrl + Shift + A = প্রতিটি অক্ষর capital letter হয় Ctrl + B = লেখাকে bold করার জন্য Ctrl + I = Italics আকার দেওয়ার জন্য Ctrl + U = Underline হয় C...
Post a Comment
Read more

Joins in DBMS

DBMS Joins: Inner, THETA, Outer, Equi Types of Join Operations Join in DBMS is a binary operation that allows you to combine join product and selection in one single statement. The goal of creating a join condition is that it helps you to combine the data from two or more DBMS tables. The tables in DBMS are associated using the primary key and foreign keys. Types of Join There are mainly two types of joins in DBMS: Inner Joins: Theta, Natural, EQUI Outer Join: Left, Right, Full Inner Join Inner Join is used to return rows from both tables which satisfy the given condition. It is the most widely used join operation and can be considered as a default join-type An Inner join or equijoin is a comparator-based join which uses equality comparisons in the join-predicate. However, if you use other comparison operators like “>” it can’t be called equijoin. Inner Join further divided into three subtypes: Theta join Natural join EQUI join Theta Join Theta Join allows you to merge two tables ba...
Post a Comment
Read more