Relation Dataset

A relation dataset refers to a dataset used to store association relationships between objects in two datasets. This type of dataset can permanently store relationships between objects in one dataset and another, serving as an advanced management mechanism compatible with both spatial data and non-spatial data. For example, dataset A stores information on real estate units (parcels) within a specific administrative region (including real estate unit number, land use, area), while dataset B stores information on real estate rights holders (name, ID number, contact number, real estate unit number). By creating an association relationship between dataset A and dataset B based on the key field "real estate unit number," when browsing or querying a parcel in dataset A, you can instantly associate and retrieve all information about the corresponding rights holder. When urban planning involves land expropriation or use adjustment of a specific parcel, this association relationship enables precise and rapid notification to relevant rights holders for communication.

The key difference from a join table is that it can permanently save association relationships between objects in two datasets. Whereas using a join table only temporarily displays attributes of the related table and is limited to operations like SQL queries or SQL condition building; it cannot permanently save attributes of the referenced object.

This section will introduce the following content: