Tagged articles
data dictionary
18 articles · Page 1 of 1
This article outlines a comprehensive methodology for data planning, covering historical context, requirement analysis with subtractive thinking, Data Requirements Document (DRD) design, data flow diagrams, data dictionaries, and internal versus external data collection strategies including web scraping considerations.
DRDbig datadata collection
0 likes · 15 min read

The article explains the distinct purposes, contents, usage scenarios, and target users of data catalogs and data dictionaries, illustrates their complementary relationship, and highlights practical challenges and a tool‑based approach for keeping them up to date.
data catalogdata dictionarydata discovery
0 likes · 9 min read

The article explains what a data dictionary is, why it is essential for collaboration, clarity, and security, and provides a step‑by‑step guide—including examples of data items, structures, flows, storage, and processing—to help teams create and maintain effective dictionaries.
Data Modelingdata dictionarydata governance
0 likes · 8 min read

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

This article provides a comprehensive technical analysis of MySQL 8.0's atomic DDL implementation, detailing the transition from fragmented FRM-based metadata to a unified InnoDB Data Dictionary, and explaining how the DDL Log mechanism ensures crash-safe physical file operations during schema modifications.
Atomic DDLDDL LogInnoDB Engine
0 likes · 17 min read


ITPUBDec 4, 2022 · 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 StandardsSQL Compatibility
0 likes · 11 min read

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.
data dictionaryin-placetablespace
0 likes · 10 min read

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.
DDLMySQLcache architecture
0 likes · 21 min read

This article explains the concepts of data model, data dictionary, database schema, and ER diagram, clarifies their differences, and compares them across stages, purposes, detail levels, authors, users, tools, and forms to help readers grasp database design terminology.
Data ModelingDatabase DesignER diagram
0 likes · 6 min read

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 IntelligenceOLAPdata dictionary
0 likes · 23 min read

This article provides a comprehensive overview of Oracle Database Management System, covering its overall architecture, instance concepts, process structures, memory components, configuration schemes, program interfaces, data dictionary organization, and transaction handling mechanisms.
Database ArchitectureOracledata dictionary
0 likes · 16 min read

This article explains how MySQL 8.0 introduces atomic DDL by moving the data dictionary into InnoDB system tables, describes the pre‑8.0 non‑atomic behavior, outlines the DDL execution phases, shows practical comparison results, and details how to view and configure DDL logs.
Atomic DDLDDL LogInnoDB
0 likes · 8 min read

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.
MySQLSQLUpgrade
0 likes · 4 min read

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 DDLInnoDBMySQL
0 likes · 22 min read


ITPUBDec 6, 2017 · Databases
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.
OracleSQLdata dictionary
0 likes · 13 min read

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.0InnoDBMySQL
0 likes · 10 min read

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.
API DesignBackendIdempotency
0 likes · 12 min read


ITPUBFeb 24, 2017 · Databases
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
