Downloaded 24 times
Sql vs NoSQL-Presentation
- 1. A Comparison ofSql and NoSQL Database Presented by-Shubham Tomar Software Developer at Nagarro
- 2. Content Index- Abstract What isDatabase Different Types of Databases Relational Database What is Sql Sql Process - Architecture Introduction-Nosql Difference between Sql and NoSQL Difference in their query syntax Introduction -MongoDB CAP Theorem Summary Web references
- 3. Abstract NoSQL databases (eitherno-SQL or Not Only SQL) are currently a hot topic in some parts of computing. In fact, one website lists over a hundred different NoSQL databases. This presentation reviews the features common to the NoSQL databases and compares those features to the features and capabilities of SQL databases.
- 4.
- 5. Different Types ofDatabases ? Flat File Database Relational Database Hierarchical Database Desktop Database
- 6.
- 7. SQL (Structured querylanguage) • SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database. • SQL is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.
- 8.
- 9. NOSQL (Non-Sql) • NoSQLis a class of database management system identified by its non-adherence to the widely used relational database management system (RDBMS) model with its structured query language(SQL). • NOSQL has evolved to mean Not Only SQL • NOSQL has become prominent with the advent of web scale data and systems created by Google, Facebook, Amazon, Twitter and others to manage data for which SQL was not the best fit.
- 10. DIFFERNCE BEWTEEN SQLANDNOSQL How Does NOSQL compare to SQL? While there are numerous characteristics that differentiate SQL and NOSQL the two most significant are Scaling and Modeling. Scaling Traditionally SQL does not lend itself to massively parallel processing, which lead to larger computers (scale up) vs. distribution to numerous commodity servers, virtual machines or cloud instances (scale out). Modeling SQL databases are highly normalized and require pre-defined data models prior to inserting data into the system. In contrast NOSQL databases do not require (although they support) pre-defined data model(s).
- 11. Pictorial View ofsql and nosql db
- 12. Difference in theirquery syntax
- 13. Data Structures andPerformance Considerations Structured vs. Unstructured Tables, fields, pairs vs. unstructured text Transactions vs. Analytics Federated vs. Persisted Big Data Volume, Variety and Velocity Retrieval Indexing, MapReduce, Search, Query Precision vs. Discovery
- 14.
- 15. What is CAPTheorem ? The CAP theorem applies a similar type of logic to distributed systems— namely, that a distributed system can deliver only two of three desired characteristics: consistency, availability, and partition tolerance (the ‘C,’ ‘A’ and ‘P’ in CAP).
- 16. Summary Projects WhereSQL is Ideal: • Logical related discrete data requirements which can be identified up-front. • Data Integrity is Essential. • Standards-based proven technology with good developer experience and support. Projects Where NOSQL is Ideal- • Unrelated, in terminate or evolving data requirements. Simpler or below project objectives, able to start immediately. • Speed and scalability is imperative.
- 17. Web References! • NoSQL-- Your Ultimate Guide to the Non -Relational Universe! http//nosql-database.org/links.html • NoSQL (RDBMS)http//en.wikipedia.org/wiki/NoSQL • PODC Keynote, July 19, 2000. Towards Robust. Distributed Systems. Dr. Eric A. Brewer. Professor, UC Berkeley. Co-Founder Chief Scientist, Inktomi .www.eecs.berkeley.edu/brewer/cs262b-2004/PODC-keynote.pdf • Brewer's CAP Theorem posted by Julian Browne, January 11, 2009. http//www.julianbrowne.com/article/viewer/brewers-cap-theorem • How to write a CV Geek Poke Cartoon http//geekandpoke.typepad.com/geekandpoke/2011/01/nosql.html
- 18.