110 likes | 471 Views
NoSQL. Edel Sherratt. What is NoSQL ?. The o riginal NoSQL – http :// www.strozzi.it/cgi-bin/CSA/tw7/I/en_US/nosql / The NoSQL movement – a variety of alternative approaches to managing persistent data Often described as Not Only SQL. Some characteristics. Large volumes of data
E N D
NoSQL Edel Sherratt
What is NoSQL? • The original NoSQL – http://www.strozzi.it/cgi-bin/CSA/tw7/I/en_US/nosql/ • The NoSQL movement – a variety of alternative approaches to managing persistent data • Often described as Not Only SQL
Some characteristics • Large volumes of data • Variable traffic • No schema • Partition tolerance – scale by adding more commodity servers • Various data models • Various query languages • Eventual consistency
Who uses NoSQL? • Amazon • Yahoo • Google • eBay • Twitter
Some NoSQL database systems • Oracle NoSQL Database • Apache Cassandra • Apache CouchDB • Apache HBase • mongoDB • Google Bigtable • Redis • Riak • Neo4j • FlockDB • MarkLogic
National Library of Wales Welsh newspapers online • January 2013 Hacathon • http://hacathonwiki.llgc.org.uk/w/index.php/Main_Page • Data documentation, mentions couchdb: • http://hacathonwiki.llgc.org.uk/w/index.php/Simple_introduction_to_the_data • http://hacathonwiki.llgc.org.uk/w/index.php/ApiDocumentation • Current public interface: • http://www.llgc.org.uk/index.php?id=4723
Some advantages of NoSQL • Scale using clusters of commodity hardware rather than specialist servers • Handle larger volumes of data and higher transaction rates than rdbms • Less need for database administrators • Lower startup costs • Lower expansion costs • Few, if any data model restrictions
Some disadvantages • NoSQL immaturity means expert support scarce • Many data manipulation languages • reduces portability of queries • reduces transferability of skills • No schema, reduces database maintainability • No normalization challenges consistency • Whole document emphasis challenges analysis of data sets
Reasons to use NoSQL • Need low-cost scaling • Data doesn’t lend itself to conventional normalization • CLOBs and BLOBs • Large amounts of temporary data • Incomplete forms • Reduced need for transactions • ‘Likes’
Summary • Characteristics of NoSQL • Some NoSQL databases • Advantages and disadvantages • Analyse the data – then decide which kind of storage option is appropriate