reduce.database: Remove database relations not linked to the main relations

In autodb: Automatic Database Normalisation for Data Frames

Remove database relations not linked to the main relations

Description

Filters a database's relations, keeping only the main relations, and those considered ancestors via foreign key references. Foreign key references involving removed relations are also removed.

Usage

## S3 method for class 'database'
reduce(x, ...)

Arguments

x	A database, whose relations are to be filtered.
...	further arguments passed to or from other methods.

Details

The main relations are considered to be the relations with the largest number of records.

Using rejoin on the database resulting from reduce is likely to fail or return incomplete results.

Value

A database, with the auxiliary relations and foreign key references removed.

autodb documentation built on April 4, 2025, 5:12 a.m.