🔵 Storage & Databases

Cloud Storage, Cloud SQL, Spanner, Firestore, Bigtable, BigQuery

Google Cloud ACE · ACE · ⏱️ 25 min · ❓ 6 savol

🪣 Cloud Storage

Object storage. Storage classes: Standard (frequent), Nearline (1 oy <), Coldline (3 oy <), Archive (1 yil <). Uniform vs Fine-grained access. Signed URL — vaqtinchalik private object access. Transfer Service — boshqa clouddan import.

🗄️ Cloud SQL vs Cloud Spanner

Cloud SQL — managed MySQL, PostgreSQL, SQL Server. Regional, 30TB gacha. Cloud Spanner — globally distributed, horizontally scalable relational DB. 99.999% availability. Financial, gaming kabi critical systemlar uchun.

📄 Firestore & Bigtable

Firestore — serverless NoSQL document database, real-time sync, offline support. Mobile/web app backend uchun ideal. Cloud Bigtable — NoSQL wide-column store, petabyte scale, millisecond latency. IoT, time-series, AdTech uchun.

📊 BigQuery

Serverless data warehouse. PB scale, SQL query. BigQuery ML — SQL orqali ML model train. BigQuery Omni — multi-cloud analytics. Columnar storage, on-demand (TB skanerlash uchun) yoki flat-rate pricing.

📊 GCP Database Xizmatlar Taqqoslash

Xizmat	Tur	Scale	Latency	Asosiy use case
Cloud SQL	Relational (MySQL/PG)	Regional, 30TB	ms	OLTP, web apps, ERP
Cloud Spanner	Relational (global)	Global, unlimited	ms	Financial, gaming (5 nines)
Firestore	NoSQL document	Serverless, auto	ms	Mobile/web backend, real-time
Bigtable	NoSQL wide-column	PB scale	ms	IoT, time-series, AdTech
BigQuery	Data Warehouse	PB scale	Soniyalar	Analytics, OLAP, ML

💡 Asosiy nuqtalar

Cloud Storage: Standard > Nearline > Coldline > Archive (narx va kirish tezligi)
Cloud SQL: regional managed SQL
Spanner: global distributed SQL, 5 nines availability
Firestore: document NoSQL, real-time
Bigtable: wide-column, time-series/IoT
BigQuery: serverless analytics warehouse

🎯 Imtihon maslahatlari

"Global, strongly consistent relational DB" → Cloud Spanner (99.999%)
"Real-time sync, mobile app" → Firestore, "IoT time-series" → Bigtable
BigQuery = analytics (OLAP), Cloud SQL = transactions (OLTP) — bu farq ko'p so'raladi
Cloud Storage Nearline = 30 kun < kirish, Coldline = 90 kun, Archive = 1 yil < kirish
Cloud Storage transfer narxi: egress (chiqish) bepul emas — region tashqarisiga

⚠️ Ko'p adashadigan

BigQuery ni relational transactional DB deb o'ylash — BigQuery OLAP, real-time insert uchun emas
Firestore va Bigtable ni bir xil deb hisoblash: Firestore=document/hierarchical, Bigtable=flat/wide-column
Cloud SQL va Cloud Spanner narx farqini e'tiborsiz qoldirish — Spanner ancha qimmat

🧠 Eslab qolish: "SQL=Regional, Spanner=Global, Firestore=Mobile, Bigtable=IoT, BigQuery=Analytics" — har biri o'z nishiga ega