{"id":311,"date":"2017-04-02T02:00:38","date_gmt":"2017-04-02T02:00:38","guid":{"rendered":"http:\/\/kaizen-koka.com\/?p=311"},"modified":"2017-04-02T03:05:51","modified_gmt":"2017-04-02T03:05:51","slug":"mongodb-nosql","status":"publish","type":"post","link":"https:\/\/kaizen-koka.com\/?p=311","title":{"rendered":"MongoDB – NoSQL"},"content":{"rendered":"

\n\t–<\/strong> Its document-oriented NoSQL database by 10gen.
\n\t– <\/strong>It is scalable, open source, high-performance document oriented DB.
\n\t– <\/strong>New nodes can be added to NoSQL databases. Which means we can achieve horizontal scalability (linearly proposal to performance. More DB's -> more performance)<\/span><\/span>\n<\/p>\n

\n\tNoSQL database types:<\/span><\/span>\n<\/p>\n

\n\t\"Screen<\/a>\n<\/p>\n

\n\t
\n\tPros<\/strong>:
\n\t– Query language
\n\t– Fast performance
\n\t– Horizontal scalability<\/span><\/span>\n<\/p>\n

\n\tCons<\/strong>:
\n\t– No join support
\n\t– No complex transactions support
\n\t– No constraints support<\/span><\/span>\n<\/p>\n

\n\t–<\/strong> Entity can be represented by collections(table)
\n\t– <\/strong>Its stores documents(objects, row) with in a collection(table) in BSON format
\n\t   var mydoc = {
\n\t               _id: ObjectId("5099803df3f4948bd2f98391"),  <- mandatory
\n\t               name: { first: "Alan", last: "Turing" },
\n\t               birth: new Date('Jun 23, 1912'),
\n\t               death: new Date('Jun 07, 1954'),
\n\t               contribs: [ “Turing machine”, “Turing test”, “Turingery” ],
\n\t               views : NumberLong(1250000)
\n\t            }
\n\t   The above fields have the following data types:<\/span><\/span>\n<\/p>\n

\n\t    _id holds an ObjectId.
\n\t    name holds an embedded document that contains the fields first and last.
\n\t    birth and death hold values of the Date type.
\n\t    contribs holds an array of strings.
\n\t    views holds a value of the NumberLong type.         <\/span><\/span>\n<\/p>\n

\n\tDocument Oriented Query Language<\/strong>: Wild cards can be used.
\n\t  db.employess.find({_id:1234});
\n\t  db.employees.find({name:"Hasan"});
\n\t  db.employees.find().sort({name:1});<\/span><\/span>\n<\/p>\n

\n\t– Adhoc Queries<\/strong>: Support search by field, range queries, and regular expression searches.
\n\t– Indexing support<\/strong> : Any field in a document can be indexed.
\n\t– Replication support<\/strong>: supports master-slave replication
\n\t   – A master can perform reads and writes.
\n\t   – A slave can perform master and can only be used for reads and backup.
\n\t– Duplication data<\/strong>: Runs over multiple servers. The data is duplicated to keep the system running on hardware failures.
\n\t– Load balancing<\/strong>: (Automatic)
\n\t– Scalable<\/strong>: New nodes can be provisioned against running DB. Scales horizontally.
\n\t– Capped collection<\/strong>: circular queue.
\n\t– File storage<\/strong>: MongoDB can be used as a file system, taking advantage of load balancing & data replication features. Special feature GridFS available for this purpose.
\n\t– Aggregation<\/strong>: MapReduce can be used for batch processing of data and aggregation operations. Offers similar functionalities as SQL Group by clause.
\n\t– Server side javascript execution<\/strong>: java script can be used in queries.
\n\t– Location support
\n\t– No conversion required between OOPL & MongoDB.<\/span><\/span>\n<\/p>\n

\n\tBasic Queries<\/strong>:  (RoboMOngo -> Groovy Adminstrative UI)<\/span><\/span>\n<\/p>\n

\n\t1. create the database -> use cricketleague
\n\t2. create a table(collections)-> db.createCollection("Teams");
\n\t3. list a collection(table) with in DB -> show collections
\n\t4. drop a collection -> db.Teams.drop();<\/span><\/span>\n<\/p>\n

\n\t5. insert data into collection ->
\n\t    a={"name":"siva", "conference":"America"}
\n\t    db.Teams.save(a);
\n\t6. query data from collection ->
\n\t    db.Teams.find("name":"NY");
\n\t7. multiple update a document(row) with in a collection ->
\n\t    db.Teams.update({"name":"NY" },{"name":"XY"},{multi:true});
\n\t8. single update a document(row) with in a collection ->
\n\t    db.Teams.update({_id:1010,"name":"NY"});
\n\t    db.Teams.remove({_id:1001});
\n\t9. Bulk load or script data in to the collection
\n\t    load(<"file path">);
\n\t10. db.CopyDatabase("cricketLeague", "Football League", "localhost");
\n\t11. Aggregator:
\n\t        db.users.aggregate({
\n\t           $group:{
\n\t             _id:"eyecolor",
\n\t             total:{$sum:1}
\n\t           }
\n\t        });
\n\t        db.users.aggregate({
\n\t           $group:{
\n\t              _id:"$gender",
\n\t              avgAge:{$avg:"$age"}
\n\t           }
\n\t        })
\n\t12. db.users.ensureIndex({"age":1})
\n\t13. db.users.getIndexes()<\/span><\/span>\n<\/p>\n

\n\t
\n\tSpring MongoDB integration<\/strong>:<\/span><\/span>\n<\/p>\n

\n\t.MongoDBFactory
\n\t.SimpleMongoDBFactory
\n\t.MongoOperations<\/span><\/span>\n<\/p>\n

\r\n@Bean\r\npublic MongoDbFactory mongoDbFactory(){\r\n    return new MongoClient(MONGO_HOST, MONGO_PORT)\r\n}\r\n\r\n@Bean\r\npublic MongoOperations mongoOperations(){\r\n    return new MongoTemplate(mongoDBFactory());\r\n}\r\n\r\n-Define your document\r\n@Document(collections="simpleDocument") \r\npublic class SimpleDocument{\r\n    @Id\r\n    String id;\r\n    String name;\r\n}\r\n\r\nSimpleDocument s1 = new SimpleDocument("1","Siva");\r\nmongoOperations.save(s1);<\/pre>\n
\n\t <\/p>\n","protected":false},"excerpt":{"rendered":"
– Its document-oriented NoSQL database by 10gen. – It is scalable, open source, high-performance document oriented DB. – New nodes can be added to NoSQL databases. Which means we can […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[20],"tags":[],"class_list":["post-311","post","type-post","status-publish","format-standard","hentry","category-nosql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p70lnf-51","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/posts\/311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=311"}],"version-history":[{"count":2,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/posts\/311\/revisions"}],"predecessor-version":[{"id":314,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/posts\/311\/revisions\/314"}],"wp:attachment":[{"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}