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）。每张表均承担特定的数据组织职能，并通过外键定义实体间的关联关系，以保障跨实体的引用完整性。

经济测算表通过将国家代码与特定指标及年度进行关联，记录国家级经济测算数据。同理，人口测算表记录按年龄组、性别、类别及时间维度划分的人口统计数据。配套的数据表如经济指标表与人口指标表，用于定义每项测算指标的元数据与含义。

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