BestHub
Sign in
Smart Sea Tide
Author

Smart Sea Tide

Sharing cutting‑edge big data and AI technologies, with occasional lifestyle insights.

98
Articles
0
Likes
45
Views
0
Comments
Recent Articles

Latest from Smart Sea Tide

98 recent articles
Smart Sea Tide
Smart Sea Tide
Jan 22, 2026 · Operations

Adaptive Management of Elasticsearch Cluster Capacity

The article details how eBay's Pronto platform implements an adaptive capacity management system for hundreds of Elasticsearch clusters, describing the challenges of uniform resource allocation, traffic spikes, and resource waste, and outlining a multi‑step process that includes monitoring, pre‑check, analysis, throttling, scaling, and post‑check to ensure high availability and efficient resource use.

AutoscalingCapacity ManagementCloud Native
0 likes · 20 min read
Adaptive Management of Elasticsearch Cluster Capacity
Smart Sea Tide
Smart Sea Tide
Jan 20, 2026 · Big Data

How Atlas’s Metadata Storage Model Enables Scalable Hadoop Governance

The article provides a detailed technical analysis of Apache Atlas, describing its core components, type system, JanusGraph‑based graph storage on HBase, the mapping of various metadata types to vertices and edges, and the three‑phase parsing and validation process that together support scalable Hadoop governance.

Apache AtlasData GovernanceHBase
0 likes · 16 min read
How Atlas’s Metadata Storage Model Enables Scalable Hadoop Governance
Smart Sea Tide
Smart Sea Tide
Jan 13, 2026 · Industry Insights

15 Essential Data Analysis Models for Market Professionals

This article introduces fifteen commonly used data analysis models for market work, detailing each model's purpose, core components, advantages, disadvantages, and practical application in market analysis, research, positioning, and marketing.

7S modelBalanced ScorecardBusiness Model Canvas
0 likes · 17 min read
15 Essential Data Analysis Models for Market Professionals
Smart Sea Tide
Smart Sea Tide
Jan 9, 2026 · Databases

How to Build a Layered Data Warehouse Architecture

The article outlines the essential principles and step‑by‑step design of a three‑layer data warehouse—source (ODS), historical, and data‑model layers—covering data consistency, universality, storage strategies, usability, and security to help architects construct reliable analytical platforms.

ODSdata consistencydata warehouse
0 likes · 9 min read
How to Build a Layered Data Warehouse Architecture
Smart Sea Tide
Smart Sea Tide
Jan 8, 2026 · Databases

How count(1), count(*) and count(column) Differ in Execution

The article explains that count(1) and count(*) produce identical results and similar execution plans, while count(column) skips NULL values; it also compares their performance under various table schemas and provides a MySQL example demonstrating these differences.

COUNTDatabaseMySQL
0 likes · 4 min read
How count(1), count(*) and count(column) Differ in Execution
Smart Sea Tide
Smart Sea Tide
Jan 7, 2026 · Databases

Designing Distributed System Architecture with Elasticsearch

The article explains Elasticsearch's cluster architecture, covering nodes, shards, replicas, two deployment models, data‑layer design, and the trade‑offs of each approach, while also comparing alternative distributed storage architectures and their impact on reliability and performance.

Data StorageDeployment ModesDistributed Architecture
0 likes · 14 min read
Designing Distributed System Architecture with Elasticsearch
Smart Sea Tide
Smart Sea Tide
Jan 6, 2026 · Databases

Practical Guide to Building the DWD Layer in a Data Warehouse

This article walks through the DWD (Data Warehouse Detail) layer design, explaining its purpose, the four-step modeling process, and detailed implementations of transactional, periodic snapshot, and cumulative snapshot fact tables with Hive SQL examples and schema definitions.

DWDFact TableHive
0 likes · 15 min read
Practical Guide to Building the DWD Layer in a Data Warehouse
Smart Sea Tide
Smart Sea Tide
Dec 25, 2025 · Databases

10 Classic SQL Interview Questions with Solutions

This article presents ten classic SQL interview questions ranging from simple GROUP BY and LIMIT usage to complex window functions and session generation, each accompanied by detailed problem statements, reasoning steps, and complete query solutions for data extraction and analysis.

Data AnalysisDatabaseInterview Questions
0 likes · 14 min read
10 Classic SQL Interview Questions with Solutions
Smart Sea Tide
Smart Sea Tide
Dec 22, 2025 · Big Data

Apache Sentry vs. Ranger: Comparing Big Data Permission Management Frameworks

This article compares Apache Sentry and Apache Ranger, two open‑source frameworks for fine‑grained, role‑based access control in Hadoop ecosystems, detailing their architectures, integration points, policy configuration, and practical examples of row‑level and column‑level security.

Apache RangerApache SentryBig Data Security
0 likes · 8 min read
Apache Sentry vs. Ranger: Comparing Big Data Permission Management Frameworks
Smart Sea Tide
Smart Sea Tide
Dec 18, 2025 · Databases

ClickHouse Performance Test on a 600‑Million‑Row Table

This article records a ClickHouse performance benchmark on a single‑node 20.8.11.17 deployment with a 600 million‑row star‑schema table, detailing server specs, data compression, and the execution time, rows processed, and result size of multiple analytical queries, highlighting first‑run latency of about 8 seconds and sub‑second speeds on repeated runs.

ClickHouseLarge DatasetPerformance
0 likes · 10 min read
ClickHouse Performance Test on a 600‑Million‑Row Table