BestHub
Sign in
Tagged articles
15 articles
Page 1 of 1
Big Data Tech Team
Big Data Tech Team
Apr 16, 2025 · Operations

Mastering Data Warehouse Naming: A Complete Guide to Standards and Processes

This article provides a comprehensive, step‑by‑step guide to data‑warehouse development, covering the full R&D workflow, data modeling layers, data dictionary creation, naming conventions for tables, columns, indexes and ETL jobs, metric standardization, and governance processes to ensure consistent, maintainable data assets across the organization.

ETLdata dictionarymetadata
0 likes · 28 min read
Mastering Data Warehouse Naming: A Complete Guide to Standards and Processes
ITPUB
ITPUB
Dec 4, 2022 · Databases

Can National Standards Accelerate the Growth of China's Domestic Databases?

The article examines whether establishing national standards for Chinese domestic databases can foster industry development, weighing the risks of over‑regulation against the benefits of standardized observability, data‑dictionary, cloud‑integration, and programming interfaces, while sharing real‑world migration experiences.

Chinese DatabasesDatabase StandardsObservability
0 likes · 11 min read
Can National Standards Accelerate the Growth of China's Domestic Databases?
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 27, 2021 · Databases

Troubleshooting MySQL 5.6→5.7→8.0 Upgrade Failure Caused by Orphan Tablespaces and Data Dictionary Inconsistency

This article details the background, error analysis, and step‑by‑step solutions—including logical dump/restore and tablespace transfer—for fixing a MySQL 5.6 to 8.0 in‑place upgrade failure caused by missing #sql‑ib orphan files and data‑dictionary mismatches in a large Zabbix deployment.

Tablespacedata dictionaryin-place
0 likes · 10 min read
Troubleshooting MySQL 5.6→5.7→8.0 Upgrade Failure Caused by Orphan Tablespaces and Data Dictionary Inconsistency
Alibaba Cloud Developer
Alibaba Cloud Developer
Aug 23, 2021 · Databases

How MySQL 8.0’s Data Dictionary Eliminates Metadata Redundancy and Boosts Performance

MySQL 8.0 replaces duplicated server‑level and engine‑level metadata with a unified data dictionary stored in InnoDB, introduces a two‑level cache (local and shared) built on templated hash maps, and provides atomic DDL operations, dramatically improving metadata consistency, performance, and management simplicity.

DDLcache architecturedata dictionary
0 likes · 21 min read
How MySQL 8.0’s Data Dictionary Eliminates Metadata Redundancy and Boosts Performance
Xueersi Online School Tech Team
Xueersi Online School Tech Team
Jul 31, 2020 · Big Data

Designing and Implementing a Comprehensive Data Metric System and Data Warehouse for Online Education

This article explains how to build a systematic data metric framework—including indicator definitions, dimension management, data dictionary, and data warehouse architecture—to turn massive online‑school data into actionable business insights and support efficient decision‑making and BI visualization.

Business IntelligenceIndicator DesignOLAP
0 likes · 23 min read
Designing and Implementing a Comprehensive Data Metric System and Data Warehouse for Online Education
Aikesheng Open Source Community
Aikesheng Open Source Community
May 8, 2019 · Databases

MySQL 8.0.16 New Upgrade Method: Replacing mysql_upgrade with the --upgrade Option

Starting with MySQL 8.0.16, the traditional mysql_upgrade command is deprecated and replaced by a new server upgrade method using the --upgrade option, which offers faster, simpler, and safer upgrades without restarting, and provides four modes (NONE, AUTO, MINIMAL, FORCE) to control data dictionary and system table updates.

SQLServerdata dictionary
0 likes · 4 min read
MySQL 8.0.16 New Upgrade Method: Replacing mysql_upgrade with the --upgrade Option
Tencent Database Technology
Tencent Database Technology
Mar 12, 2019 · Databases

Understanding MySQL 8.0 Data Dictionary, Atomic DDL, and Persistent Autoincrement

This article explains the evolution of MySQL's data dictionary from pre‑8.0 scattered metadata to the unified InnoDB dictionary tables in MySQL 8.0, covering storage structures, dictionary caching, information_schema changes, serialized dictionary information (SDI), atomic DDL mechanisms, persistent autoincrement handling, upgrade considerations, and provides practical code examples.

Atomic DDLInnoDBSQL
0 likes · 22 min read
Understanding MySQL 8.0 Data Dictionary, Atomic DDL, and Persistent Autoincrement
ITPUB
ITPUB
Dec 6, 2017 · Databases

Mastering Oracle Data Dictionary: Types, Views, and Practical Queries

This article explains the classification of Oracle data dictionary objects, demonstrates how to query static and dynamic dictionary tables and views, lists common view families and permission views, and provides numerous SQL examples for inspecting users, tables, indexes, sequences, constraints, and PL/SQL objects.

OracleSQLViews
0 likes · 13 min read
Mastering Oracle Data Dictionary: Types, Views, and Practical Queries
dbaplus Community
dbaplus Community
Oct 31, 2017 · Databases

What’s New in MySQL 8.0? Key Features, Performance Boosts, and Best Practices

This article summarizes the most compelling MySQL 8.0 enhancements—including a unified Data Dictionary, revamped Information Schema, role‑based privilege management, persistent configuration, auto‑increment fixes, InnoDB histogram and invisible index support, mutex refinements, row‑cache improvements, temporary‑table changes, character‑set updates, default parameter tweaks, and atomic DDL operations—providing practical guidance for DBAs and developers.

8.0Database OptimizationInnoDB
0 likes · 10 min read
What’s New in MySQL 8.0? Key Features, Performance Boosts, and Best Practices
Architecture Digest
Architecture Digest
Mar 9, 2017 · Backend Development

Common Design Issues and Best Practices for Distributed System Interfaces

The article outlines key challenges in distributed API design—including date formatting, decimal precision, response structures, idempotency, security, and naming consistency—and provides practical recommendations to improve usability, scalability, and maintainability across backend services.

BackendDistributed SystemsIdempotency
0 likes · 12 min read
Common Design Issues and Best Practices for Distributed System Interfaces
ITPUB
ITPUB
Feb 24, 2017 · Databases

Why Adding NOT NULL Columns Can Still Store NULLs in Oracle?

This article examines the surprising behavior of Oracle when adding NOT NULL columns with default NULL values, explains how different Oracle versions handle the constraint, demonstrates test cases, and clarifies the underlying data‑dictionary mechanism that leads to unexpected query results.

ALTER TABLENOT NULLOracle
0 likes · 7 min read
Why Adding NOT NULL Columns Can Still Store NULLs in Oracle?