Topic Vendors use SQL database
Salesforce.com: The Customer Success Platform To Grow Your Business
Business Applications | Microsoft Dynamics 365
Oracle Australia | Integrated Cloud Applications and Platform Services
Act! - CRM & Marketing Automation in One
SQL vs. NoSQL - DZone Database
Advantages of SQL:
High Speed:
SQL Queries can be used to retrieve large amounts of records from a database quickly and efficiently.
Well Defined Standards Exist:
SQL databases use long-established standard, which is being adopted by ANSI & ISO. Non-SQL databases do not adhere to any clear standard.
No Coding Required:
Using standard SQL it is easier to manage database systems without having to write substantial amount of code.
Emergence of ORDBMS:
Previously SQL databases were synonymous with relational database. With the emergence of Object Oriented DBMS, object storage capabilities are extended to relational databases.
Analytical Queries
Data analysts use SQL for setting, executing and running analytical queries regularly.
Advantages of NoSQL
NoSQL is Non-relational
Non-relational, in other words, you can call it as table-less, these NoSQL databases vary from SQL databases. In this sense, they provide the ease of management while ensuring a high level of flexibility with data models that are new.
NoSQL is Low Cost
The various kinds of NoSQL databases available in the market include Couchbase, Amazon’s Dynamo Db, MongoDB and MarkLogic to provide for the processing of big data apps that are cost-effective.
Scalability is Easier
NoSQL has been gaining popularity because of the elasticity and scalability that it offers over the other kinds of databases that are available. It has been designed to perform exceptionally well under any conditions including low-cost hardware.
Disadvantages of SQL:
Difficulty in Interfacing:
Interfacing an SQL database is more complex than adding a few lines of code.
More Features Implemented in Proprietary way:
Although SQL databases conform to ANSI & ISO standards, some databases go for proprietary extensions to standard SQL to ensure vendor lock-in.
Implementation
Certain databases implement proprietary extensions to standard SQL to ensure the vendor lock-in.
Only Partial Control
Since there are certain hidden rules and conditions, the programmers who use SQL do not have power over the database.
Expense
The expenses involved in SQL operation is too much, making it difficult for bringing vendor-in.
Disadvantages of NoSQL
Less Community Support
Though the NoSQL has been expanding at an unbelievable pace, the community support is relatively less as its new.
Standardization
It lacks a standardized platform like SQL, which is preventing it from further expanding. This has been creating concerns during migration. Standardization is what helps the database industry to unify.
Interfaces and Interoperability
Interfaces and interoperability is another concern that is faced by NoSQL, which needs fixing immediately.
SQL Advantages & Disadvantages
SQL and NoSQL Advantages and Disadvantages | Role of SQL in DBMS
**Why, Why, Why? For instance, I could store all the organization’s documents and web articles in a document DB like MongoDB. The question is why? What is the purpose and what problems does this solve? Are we just collecting all the documents for sake of collecting them? What is the purpose of using a DB?**
For a new ERP or CRM, what is the suggested database, PostgreSQL or NoSQL, and which NoSQL type?
NoSQL Tutorial: Types of NoSQL Databases, What is & Example
Short summary of ideas that why choose SQL for CRM