1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

What is nosql database?

Discussion in 'Databases' started by rmmrj, Aug 15, 2013.

  1. #1
    Can anyone tell me, how to implement nosql databases? What are the pros and cons of it?
    SEMrush
    Thanks
    Ramesh
     
    rmmrj, Aug 15, 2013 IP
    SEMrush
  2. ayushirajput

    ayushirajput Member

    Messages:
    31
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    28
    #2
    The Oracle NoSQL Database is a distributed key-value database. It is designed to provide highly reliable, scalable and available data storage across a configurable set of systems that function as storage nodes.NoSQL DEFINITION: Next Generation Databases mostly addressing some of the points: being non-relational, distributed, open-source and horizontally scalable.
     
    ayushirajput, Aug 16, 2013 IP
  3. Endurint

    Endurint Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #3
    It's a type of database that doesn't use the relational architecture. The "tables" aren't defined by strict schema; any record can have its own properties and fields that are unique to it. Most NoSQL databases have their own control language, or have picked an existing open source language. MongoDB, for example, uses JavaScript as its control language.
     
    Endurint, Sep 9, 2013 IP
  4. webfantasy

    webfantasy Greenhorn

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #4
    Next Generation Databases mostly addressing some of the points: being non-relational, distributed, open-source and horizontally scalable.
     
    webfantasy, Sep 29, 2013 IP
  5. khodem

    khodem Member

    Messages:
    201
    Likes Received:
    5
    Best Answers:
    3
    Trophy Points:
    45
    #5


    Hi you can read my article here NoSQL: The Big Picture and why you should use it? and there is many other articles that you can read in my website... even how to install NoSQL database like MongoDB and others... if you have any more question let me know I will help you out :D

    or even if you want to know how many category of NoSQL database exist you can read my article Four category of NoSQL databases with examples
     
    khodem, Dec 15, 2013 IP
  6. Amjad Chughtai

    Amjad Chughtai Greenhorn

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #6
    NoSQL databases are non-relational data-stores that do not need fixed schema and usually avoid join operations. NoSQL's are distributed databases which are designed to be highly available and scalable. Though there are many prons and cons of NoSQL, but I will only point out the important ones.

    Prons:
    1. High Availability
    2. Scalability
    3. Designed to scale easily

    Cons:
    1. Non-relational -> has advantages (no predefined schema) and disadvantages (different ways of storing same data, e.g. key-value)
    2. Lack of standards due to different data models (e.g key-value store, document databases)
    3. No standard API available to addresses the issue such as Portability
     
    Amjad Chughtai, Apr 22, 2014 IP
  7. shmekerosu

    shmekerosu Active Member

    Messages:
    571
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    90
    #7
    NoSQL is a general type of database term used to define distributed databases designed for great scalability and availability.

    "A NoSQL or Not Only SQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. Motivations for this approach include simplicity of design, horizontal scaling and finer control over availability"

    As for the product I am using MongoDB, see some pros and cons below (taken from stakoverflow).

    Pros:
    • Schema-less. If you have a flexible schema, this is ideal for a document store like MongoDB. This is difficult to implement in a performant manner in RDBMS
    • ease of scale-out. Scale reads by using replica sets. Scale writes by using sharding (auto balancing). Just fire up another machine and away you go. Adding more machines = adding more RAM over which to distribute your working set.
    • cost. Depends on which RDBMS of course, but MongoDB is free and can run on Linux, ideal for running on cheaper commodity kit.
    • you can choose what level of consistency you want depending on the value of the data (e.g. faster performance = fire and forget inserts to MongoDB, slower performance = wait til insert has been replicated to multiple nodes before returning)
    Cons:

    • Data size in MongoDB is typically higher due to e.g. each document has field names stored it
    • less flexibity with querying (e.g. no JOINs)
    • no support for transactions - certain atomic operations are supported, at a single document level
    • at the moment Map/Reduce (e.g. to do aggregations/data analysis) is OK, but not blisteringly fast. So if that's required, something like Hadoop may need to be added into the mix
    • less up to date information available/fast evolving product
    Final solution is pretty much determined by your application requirements.

    Hope this helps,
    S.
     
    shmekerosu, May 5, 2014 IP
  8. cmehreen

    cmehreen Greenhorn

    Messages:
    10
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    23
    #8
    Hey Shmekerosu, thank you so much for this article. It really helps! I have read an another informative article (http://www.nascenia.com/nosql-future-of-database/) where you can find also the reason behind the rising popularity of using NOSQL. I hope you will like it too :)

    Regards,
    CM
     
    cmehreen, May 8, 2014 IP
    shmekerosu likes this.
  9. Jigney

    Jigney Active Member

    Messages:
    168
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    93
    #9
    Jigney, May 27, 2014 IP
  10. Karthika Qpt

    Karthika Qpt Member

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #10
    NoSQL database used for storage and retrieval of data which is modeled in means other than the tabular relations used in relational databases. NoSQL databases are more scalable and provide superior performance, and their data model addresses several issues.
     
    Karthika Qpt, Mar 19, 2016 IP