A relation dataset is a dataset used to store the association relationships between objects from two datasets. It enables the permanent storage of relationships between objects in one dataset and those in another, serving as an advanced management mechanism compatible with both spatial and non-spatial data.

For example, Dataset A stores information about real estate units (parcels) in a certain administrative region (e.g., real estate unit number, land use type, area), while Dataset B stores information about real estate right holders (e.g., name, ID number, contact number, real estate unit number). By establishing a relationship between Dataset A and Dataset B based on the key field "real estate unit number," users can instantly associate and retrieve all information about the right holder corresponding to a specific parcel when browsing or querying Dataset A. When urban planning involves land expropriation or land use adjustments for specific parcels, this association allows for precise and rapid notification to relevant right holders for communication.

The key difference from a join table is that a relation dataset can permanently store the association between objects from two datasets. In contrast, using a join table only temporarily displays the attributes of the related table and is limited to operations such as SQL queries or SQL condition construction, without the ability to permanently store the attributes of referenced objects.

This section introduces the following topics:

• Basic Terms of Relation Dataset: Introduces the basic terminology used in relation datasets.
• Create a Relational Dataset: Explains how to create a relational dataset.
• View Associated Object Properties: Describes how to view the properties of associated objects.
• View Relationship Dataset Properties: Explains how to view the attributes of a relation dataset.