====== NoSQL ====== Google as inventé BigTable sur son Google File System (GFS) qui utilise le paradigme de [[http://labs.google.com/papers/mapreduce-osdi04.pdf|MapReduce (Simplified Data Processing on Large Clusters)]] pour gérer d'énormes quantités de données dans une infrastructure distribuée. D'autres qui ont des problématiques similaires lui ont emboité le pas comme Facebook avec Cassandra, ... La fondation Apache propose Hbase sur Hadoop ([[/glossaire/HDFS|HDFS]]). Une liste de serveurs et d'outils NoSQL sur la page [[/informatique/sgbd#sgbd_nosql|informatique/sgbd sgbd_nosql]] Doc: * An [[http://guide.couchdb.org/draft/cookbook.html|NoSQL's View cookbook for SQL jockeys]] * [[http://wiki.apache.org/couchdb/View_Snippets|View Snippets]] * The [[http://blog.mudynamics.com/wp-content/uploads/2009/04/icouch.html|interactive CouchDB simulator]] Discussions: * 2009-06 [[http://www.developpez.net/forums/d773158/bases-donnees/decisions-sgbd/sgbd-mouvement-anti-sql-s-amplifie/#post4458431|SGBD : le mouvement anti-SQL s’amplifie ?]] En vrac: http://localhost:5984/boamp/_design/resumes/_view/byLieu?key="75" // The Map function "titles_by_posted_at" : // Get all article titles ordered by posted date. function(doc) { if(doc.type == 'article') { emit([doc.posted_at], doc.title); } } // Query : // GET /blog/_articles/titles_by_posted_at // Result: { "total_rows":75, "offset":0, "rows":[ {"id":"2157b289eed2fe4512326698fd114d2f","key":["2007-12-15T20:14:02Z"],"value":"Showing multiple message types with the flash"}, {"id":"2157b289eed2fe4512326698fd0de8b3","key":["2007-12-20T14:50:41Z"],"value":"Class, Instance and Singleton methods"}, // ... and so on ... } // Query for a key : // GET /blog/_articles/titles_by_posted_at?key=["2007-12-20T14:50:41Z"] // Query for a start and end key : // GET /blog/_view/articles/titles_by_created_at?startkey=[%222007-12-01T00:00:00Z%22]&endkey=[%222007-12-31T24:00:00Z%22]