Global Economic and Population Indicators Dataset (Normalized Relational Structure, 1976–2025)

This dataset presents a normalized relational database of global economic and population indicators collected from publicly available international data sources, including organizations such as the World Bank and United Nations. The dataset focuses on key metrics such as economic performance indicators and demographic population measurements across multiple countries and years. The original raw datasets contained redundant, inconsistent, and unstructured attributes, which were transformed into a structured format through normalization techniques.

The database was designed using a relational model and normalized to reduce redundancy and improve data integrity. The final schema includes five primary tables: country, economic_indicator, economic_measurement, population_indicator, and population_measurement. Each table serves a specific purpose in organizing the data, with relationships defined using foreign keys to ensure referential integrity across entities.

The economic_measurement table captures country-level economic metrics by linking country codes with specific indicators and years. Similarly, the population_measurement table captures demographic data segmented by attributes such as age group, sex, category, and time. Supporting tables, such as economic_indicator and population_indicator, define the metadata and meaning behind each measurement.

This dataset is intended for academic and analytical purposes, enabling users to explore relationships between economic performance and demographic trends across countries. The normalized structure allows for efficient querying, scalability, and integration into analytical workflows such as machine learning, statistical analysis, and data visualization.

本数据集为经规范化处理的关系型数据库，收录自世界银行（World Bank）、联合国（United Nations）等国际公开数据源的全球经济与人口指标数据。数据集聚焦多国、多年度的核心统计指标，涵盖经济表现指标与人口统计测量数据。原始数据集存在冗余、不一致且非结构化的属性，经规范化技术处理后转换为结构化格式。

该数据库采用关系模型设计，并通过规范化处理以降低数据冗余、提升数据完整性。最终架构包含五张主表：country、economic_indicator、economic_measurement、population_indicator 及 population_measurement。每张主表承担专属数据组织职能，并通过外键定义表间关联关系，确保各实体间的引用完整性。

economic_measurement（经济测量表）通过将国家代码与特定指标及年度关联，记录国家级经济统计指标。同理，population_measurement（人口测量表）记录按年龄组、性别、类别及时间等维度细分的人口统计数据。作为支撑的附属表（如economic_indicator与population_indicator）用于定义各项统计指标的元数据与实际含义。

本数据集旨在服务于学术研究与分析场景，支持用户探索多国经济表现与人口趋势间的关联关系。其规范化架构支持高效数据查询、良好可扩展性，并可便捷集成至机器学习、统计分析及数据可视化等各类分析工作流中。