BestHub
Sign in
Smart Sea Tide
Author

Smart Sea Tide

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

101
Articles
0
Likes
317
Views
0
Comments
Recent Articles

Latest from Smart Sea Tide

100 recent articles max
Smart Sea Tide
Smart Sea Tide
Oct 14, 2025 · Industry Insights

How to Choose the Right Data Warehouse Modeling Tool for Your Enterprise

The article presents a three‑step methodology—identifying core requirements, constructing a capability‑matching matrix, and validating through pilot scenarios—to help enterprises evaluate data warehouse modeling tools based on scale, architecture compatibility, team skills, automation, extensibility, cost, performance testing, and continuous optimization.

Enterprise Datadata warehouseevaluation matrix
0 likes · 7 min read
How to Choose the Right Data Warehouse Modeling Tool for Your Enterprise
Smart Sea Tide
Smart Sea Tide
Oct 13, 2025 · Big Data

How Zhihu Evolved Its Real-Time Data Warehouse Architecture

The article details Zhihu's step‑by‑step evolution from a Spark‑Streaming‑based real‑time data warehouse (v1.0) to a Flink‑Streaming SQL‑driven platform (v2.0), explaining design choices, Lambda architecture implementation, scalability challenges, and future automation plans.

DruidFlinkHBase
0 likes · 22 min read
How Zhihu Evolved Its Real-Time Data Warehouse Architecture
Smart Sea Tide
Smart Sea Tide
Oct 9, 2025 · Big Data

Effective Spark Performance Tuning and Troubleshooting Guide

This article details practical Spark performance optimizations—including RDD reuse, broadcast variables, Kryo serialization, parallelism settings, shuffle tuning, and JVM tweaks—while also presenting systematic solutions for data skew, shuffle failures, serialization errors, and YARN mode issues, all illustrated with concrete code snippets and examples.

BroadcastData SkewJVM
0 likes · 25 min read
Effective Spark Performance Tuning and Troubleshooting Guide
Smart Sea Tide
Smart Sea Tide
Sep 29, 2025 · Databases

Data Warehouse Architecture and Construction Methodology

The article explains why scattered, heterogeneous enterprise data requires a unified, subject‑oriented data warehouse, outlines its historical evolution, compares Inmon and Kimball architectures, describes the core components and modeling stages, and details dimensional modeling techniques and best practices.

Business IntelligenceETLInmon
0 likes · 48 min read
Data Warehouse Architecture and Construction Methodology
Smart Sea Tide
Smart Sea Tide
Sep 24, 2025 · Big Data

How to Build a User Profile Tag System: Methods, Architecture, and Quality Evaluation

The article defines objects, tags, and tag systems, distinguishes physical, network, and electronic tags, explains user profiling and its role in recommendation, CRM, DMP and CDP, outlines a three‑principle construction process, architecture layers, classification rules, and a comprehensive quality assessment covering data, application, and business dimensions.

CDPDMPdata middle platform
0 likes · 15 min read
How to Build a User Profile Tag System: Methods, Architecture, and Quality Evaluation
Smart Sea Tide
Smart Sea Tide
Sep 22, 2025 · Big Data

Data Warehouse Development Standards: Phase Planning, Roles, and End-to-End Process

This article outlines a comprehensive data warehouse development framework, detailing each lifecycle phase—from requirement gathering and design to development, testing, release, and operations—while defining the responsibilities of product managers, designers, developers, testers, and ops staff to improve efficiency and reduce risk.

DesignETLOperations
0 likes · 16 min read
Data Warehouse Development Standards: Phase Planning, Roles, and End-to-End Process
Smart Sea Tide
Smart Sea Tide
Sep 18, 2025 · Big Data

Comprehensive Guide to Hive Static, Dynamic, and Multi-Level Partitions

This article explains Hive's partitioning mechanisms—including static, dynamic, and multi-level partitions—by showing how to create partitioned tables, load data with explicit or inferred partition values, compare query performance, and follow best practices for effective data organization.

Big DataDynamic PartitionHive
0 likes · 9 min read
Comprehensive Guide to Hive Static, Dynamic, and Multi-Level Partitions
Smart Sea Tide
Smart Sea Tide
Sep 12, 2025 · Fundamentals

Practical Data Modeling Patterns for Data Warehousing

The article explains why a well‑designed data model is essential for data‑warehouse performance and reliability, then walks through three core modeling patterns—flat tables, master/detail, and dimensional (star) schemas—illustrating each with concrete Power BI examples, step‑by‑step design stages, and trade‑offs such as many‑to‑many relationships and bidirectional filters.

Power BIdata modelingdata warehouse
0 likes · 11 min read
Practical Data Modeling Patterns for Data Warehousing