Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm looking for a good explanation of terminology for No-SQL. I have some colleagues that won't get the point, and for the sake of advancing i need to have definitions of the names.. Though this seems real hard to find.

let's see a Database is a database, talking about No-SQL or SQL it keeps the same name. People do understand that.. But if you start looking on the internet.. there are people that say that you have: "a database with documents", "a database with rows and each row is a document" and "a document has rows", It's real confusing if you ask me..

So could anybody give a good explanation of the terminology that exists in No-SQL, to improve communication about the subject. And also how this compares to the traditional SQL terminology?(like a row is a document? a table.. etc..)

EDIT Can anybody confirm that this is the relation between the terms: A Database has multiple documents. In this case each documents will be the same as a row and the specification of an Table like in SQL does not exist. you could see all the tables with the same type as a table, if i'm right....?

EDIT 2

I'm specifically looking for couchDB.

share|improve this question
add comment

closed as primarily opinion-based by RolandoMySQLDBA, Mark Storey-Smith, Max Vernon, Michael - sqlbot, Kin Feb 6 at 20:17

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

up vote 1 down vote accepted

http://docs.mongodb.org/manual/reference/sql-comparison/

check out full documentation. everything is perfectly explained.

share|improve this answer
    
Sorry, Maby i should have defined that i'm looking for CouchDB references.. I thought that it would be all the same for no-sql but in Couchdb never seen or heard of an collection... like your reference says. –  spons Jan 30 at 9:55
    
I accept your answer together with this reference that explains that every "SQL table" is a type within a Cloudant - couchdb document to make the reference: cloudant.com/blog/sql-cloudant-and-going-schemaless –  spons Jan 30 at 9:57
    
couchDB and mongoBD are pretty similar as far as I know. check out this stackoverflow.com/questions/12437790/… and this blog.nahurst.com/visual-guide-to-nosql-systems hope it's helpful –  dimitar Jan 30 at 10:03
    
I wouldn't say that mongoDB and CouchDB are so similar. But that's another topic that doesn't belong here. Through this reference: guide.couchdb.org/draft/design.html i would say that a collection in Couchdb is an design document which reference to a set of typed documents.. Though you can't say it as a table nor an collection. –  spons Jan 30 at 10:13
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.