Download to read offline
No sqlpresentation
- 1. No Sql Prepared By: BouzidiNayrouz Gouia Salma Zarrouk Asma
- 2. Introduction1 What is NOSQL?2 Whereto use NoSQL?5 Advantages of NOSQL6 Plan Conclusion7 Need of NoSQL3 NoSQL Types4
- 3.
- 4. A database isa collection of information that is organized so that it can be easily accessed, managed and updated. Computer databases typically contain aggregations of data records or files, containing information about sales transactions or interactions with specific customers. Two main categories : Relational database(SQL) and NOSQL. 4
- 5.
- 6. Class of non-relationaldata storage systems. Relaxation for one or more of the ACID properties (Atomicity, Consistency, Isolation, Durability) using CAP theorem. Stands for Not Only SQL Do not require a fixed table schema nor do they use the concept of joins. 6
- 7.
- 8. Just as movingto dynamically- typed languages (Ruby/Groovy), a shift to dynamically-typed data with frequent schema changes Expansion of Open- source community. . NoSQL solution is more acceptable to a client now than a year ago. Explosion of social media sites (Facebook, Twitter, Google etc.) with large data needs. (Sharding is a problem) Rise of cloud-based solutions such as Amazon S3 (simple storage solution). 8
- 9.
- 10. Key Value pair based Columnbased Document based Graph based 10
- 11. Key Value pairbased It uses sort of Map /Dictionary as a fundamental Data model You can’t control data structure but you can manipulate value if you know it’s key The simplest non-trivial data model Data is represented as a collection of key-value pairs. 11
- 12. for storing sessioninformation, user profiles, preferences, shopping cart data.. We use it when we need to query data having relationships between entities. . We would avoid it CouchDB, Oracle NoSQL Database, Riak etc.. Example 12
- 13. Column based It storedata as Column families containing rows that have many columns associated with a row key. Each row can have different columns Column families are groups of related data that is accessed together 13
- 14. for content managementsystems, blogging platforms, log aggregation We use it for systems that are in early development, changing query patterns. We would avoid it Cassandra, HBase, Hypertable, and Amazon DynamoDB. Example 14
- 15. Document based The databasestores and retrieves documents. It stores documents in the value part of the key-value store. Self- describing, hierarchical tree data structures consisting of maps, collections, and scalar values 15
- 16. for content managementsystems, blogging platforms, web analytics, real-time analytics, e- commerce applications. We use it for systems that need complex transactions spanning multiple operations or queries against varying aggregate structures. We would avoid it Lotus Notes, MongoDB, Couch DB, Orient DB, Raven DB. Example 16
- 17. Graph based Store entitiesand relationships between these entities as nodes and edges of a graph respectively. Entities have properties Traversing the relationships is very fast as relationship between nodes is not calculated at query time but is actually persisted as a relationship. 17
- 18. for connected data,such as social networks, spatial data, routing information for goods and supply. We use it Neo4J, Infinite Graph, OrientDB, FlockDB.. Example 18
- 19.
- 20. 03 To improve dataaccess performance via some combination of handling larger data volumes, reducing latency, and improving throughput. To improve programmer productivity by using a database that better matches an application's needs. NoSQL Data storage systems makes sense for applications that process very large semi-structured data –like Log Analysis, Social Networking Feeds, Time-based data. 20
- 21.
- 22. Cheap and easyto implement (open source) Don't require a schema Easy to distribute Data are replicated to multiple nodes and can be partitioned What is not provided by NoSQL Joins Group by SQL Integration with applications that are based on SQL 22
- 23.
- 24. All the choicesprovided by the rise of NoSQL databases does not mean the demise of RDBMS databases as Relational databases are a powerful tool. We are entering an erea of Polyglot persistence, a technique that uses different data storage technologies to handle varying data storage needs. It can apply across an enterprise or within an individual application. 24
- 25.
Editor's Notes
- #2 1
- #3 1 2 3 4 5 6 7
- #7 NOSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.
- #9 1
- #11 NoSQL database are classified into four types: • Key Value pair based • Column based • Document based • Graph based