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...
A blog about all things data and data processing issues and interests. SQL, NoSQL, flexible schema, scale-up, scale-out, transactions, high availability.