Other databases
Articles in the Other databases category (4).
Articles in the Other databases category (4).
- Data Vault, Snowflake and bronze, silver, gold layers: what I keep in mind — Hubs, links and satellites, what Snowflake brings, and how Data Vault fits into the bronze, silver and gold layered architecture.
- Filtering the last 24 hours across SQL engines — Equivalent date conditions for the last 24 hours in MySQL, SQL Server, Oracle, PostgreSQL, Redshift, SQLite and MS Access.
- MongoDB: structure of the _id field (ObjectId) — Breakdown of the 12 bytes of a MongoDB ObjectId: timestamp, machine, process and counter.
- SQL command types: DDL, DQL, DML, DCL and TCL — The five SQL statement categories, their purpose and the typical commands of each.