Posts tagged “データベース”
5 posts Subscribe by RSS
5 posts
AP Subject A 35 — Distributed databases and data warehouses: from partitioning, replication, CAP and two-phase commit to ETL and OLAP
AP Subject A supplement: partitioning and sharding, replication and consistency, CAP during a partition, two-phase commit, DWH, data marts, ETL/ELT, star schema, OLAP, 5 original questions.
AP Subject A #13: Database keys, functional dependencies, and normalization
Keys and attribute closure, full, partial and transitive dependencies, anomalies, 1NF to 3NF, lossless decomposition and the BCNF boundary for AP Subject A, with five original questions.
AP Subject A #14: SQL joins, aggregation, and NULL
SQL SELECT/WHERE, INNER vs LEFT JOIN, GROUP BY/HAVING and COUNT, NULL and three-valued logic, NOT IN pitfalls and DISTINCT for AP Subject A, with five original questions.
AP Subject A 15: Transactions, Concurrency, and Recovery
ACID, COMMIT/ROLLBACK, S/X locks and deadlock, isolation levels and anomalies, and WAL-based UNDO/REDO recovery for AP Subject A, with traced examples and five original questions.
AP Subject A 32 — AP1–32 core-map mixed diagnostic: closing the database gaps
AP Subject A diagnostic closing the AP1–32 core map on database gaps: B-tree, hash, bitmap and covering indexes, page-access cost math, GRANT/REVOKE and least privilege, with five original questions.
No posts match. Try another word.