Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

5. MapReduce Views for SQL Users

Chapter 5. MapReduce Views for SQL Users

Many developers who are new to CouchDB are already familiar with relational databases such as MySQL. However, there are some important differences between CouchDB and relational databases. These differences include:

  • There are no tables in a CouchDB database as each document can have its own schema. Since there are no tables, there are also no columns.

  • Views in CouchDB serve a similar role as indexes in a relational database. However, views/indexes are queried directly in CouchDB, whereas in a relational database indexes are used to optimize more generalized queries.

  • A column in a CouchDB result set can contain a mix of logical data types. A column in a result set from a relational database will always contain the same logical data type.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint