We help IT Professionals succeed at work.

MongoDB - What is it?

Medium Priority
108 Views
Last Modified: 2019-12-30
From data Source point of view, I'm coming from  SQL Server background but I'm planning to learn MongoDB. I'm familiar with the structure/elements of SQL Server- physical elements such Tables, Views and logical stored procedures. What makes MongoDB diifferent?
Is there a physical structure in a MongoDB? How are data get into the database? How to implement the principles of Select, Update,Delete?
Comment
Watch Question

Fractional CTO
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
1) From data Source point of view, I'm coming from  SQL Server background but I'm planning to learn MongoDB. I'm familiar with the structure/elements of SQL Server- physical elements such Tables, Views and logical stored procedures. What makes MongoDB diifferent?

https://en.wikipedia.org/wiki/MongoDB provides a quick look at Mongo.

In simple terms, you can think of Mongo as being a JSON based system, where you can lookup data using various JSON keys + data items.

You can't really compare/correlate Mongo + SQL as they're both very different.

2) Is there a physical structure in a MongoDB?

Yes. Think of this as (SQL terms) of rows of data containing JSON... with various lookup keys.

Again, best you read about Mongo for more details, as trying to talk about Mongo (or any similar non-SQL system) in SQL terms is near impossible.

3) How are data get into the database?

Load data, just like any system... whether SQL or simple text files in a file system.

4) How to implement the principles of Select, Update,Delete?

Best if you just study Mongo.

Start with https://www.youtube.com/watch?v=pWbMrx5rVBE or one of the other nearly 3M Mongo YouTube tutorials.

You read that right. There are almost 3M Mongo YouTube tutorials.
nociSoftware Engineer
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
You can think of a MongoDB as an SQL database with a KeyField + BLOB attachment.   The difference is there are indices on parts of the blob field.
It has it's value but surely is NOT a panacea for database performance.  it does fit a lot of website data storages.
(it is sometimes mentioned as a Key/Value store, or a "Document" database.   It more or less behaves like a library.

This does give a comparison:   http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/
(or more a rant why mongo somtimes is a bad idea).

Author

Commented:
Thank YOU! I will get a good book on it.