- DDL: CREATE TABLE
- DML: SELECT
- DML: JOIN
- DML: HAVING
- DML: INSERT
- DML: INSERT INTO
- DML: SELECT INTO
- ADMIN: Connect
- ADMIN: User Management
- DDL: Database
- DDL: Table
- DML: Transactions
- PL: Stored Routines (Procedures and Functions)
- ADMIN: Connect
- ADMIN: User Management
- ADMIN: User Privileges (Grant and Revoke)
- ADMIN: User Roles
- ADMIN: Auditing
- ADMIN: Data Pump (Export/Import)
- DDL: Database (Tablespace)
- DDL: Data Types
- DDL: Oracle Function List
- PL: Basics
- PL: Stored Procedure
- PL: Stored Function
- PL: Scheduler Job
A document storage capable of scaling horizontally but is infamous for its questionable durability.
- Basics
- Collection of Documents
- Inserting Document
- Querying Document
- Update Document
- Remove Document
- Embedded Document
- GeoJSON: Geospatial Index and Queries
- MapReduce
Transactional, Scalable, Fully-managed PaaS, Document-based storage.
- indexes are required for queries
- replicated
- hierchical keys
- get, set, and ancestor queries are strongly consistent
- index queries are eventually consistent
- Objectify: Java ORM
A memory-based key-value store.
Another memory-based storage.
A columnar key-value store. A "row" is actually a sequence of actual rows sharing the same ID. Good for sparse data since unpopulated columns are not occupying space.
HBase service for Google Cloud. No other column is indexed aside from the row key, so choose wisely.
Another BigTable implementation. Sparse, distributed, sorted, and multi-dimensional map.
- field-level visibility
- internally stores fields in a key-value format, and blank fields are not stored