Planet NoSQL

SQL is the only 22nd century tool available in 21st century Here are the articles comparing  architecture , database objects , data types and data modeling of Oracle with Couchbase. This will focus on SQL support.   Oracle was the first and staunch  supporter  of  SQL . Oracle's SQL implementation beat IBM to market by two years.  That changed the fortune of one or two people :-)  All of the modern relational databases implement SQL. So much so, relational databases are sometimes called SQL databases, much to the  chagrin of C. J. Date .  Nations are known by their languages... English, French, and American(!). It's not a stretch for a class of database system to be known by their languages as well.  SQL has been so effective, many big data and non-relational systems have picked up SQL as the lingua franca . SQL is here to stay, even for noSQL systems.  SQL > SQL SQL may have started as a structured english query language ...

Oracle DBAs work with physical clusters, machines, instances, storage systems, disks, etc. All of Oracles users, developers and their applications work with logical entities: databases, tables, rows, columns, partitions, users, data types.  There are a lot of similarities and some differences.  Let’s compare and contrast how this is done on Couchbase. Here’s the home page for the series:  http://blog.planetnosql.com/2022/01/introduction-to-couchbase-for-oracle.html ORACLE Organization Full list of Oracle schema objects are listed here . A database instance can have many databases; A databases many schema; A schema many tables, indexes, functions, etc. COUCHBASE Organization A Couchbase instance can have many buckets; A bucket can have many scopes; A Scope can have many collections, indexes, functions, search indexes, analytic collections, eventing functions. Each bucket comes with a _default scope and _default collection mainly for backward compatibility. You can create n...