keys

keys&lt;-

Generic function, with the only given method fetching candidate key lists for
relation schemas.

Automatic normalisation of a data frame to third normal form, with
the intention of easing the process of data cleaning. (Usage to design your
actual database for you is not advised.)
Originally inspired by the 'AutoNormalize' library for 'Python' by 'Alteryx'
(<https://github.com/alteryx/autonormalize>), with various changes and
improvements. Automatic discovery of functional or approximate dependencies,
normalisation based on those, and plotting of the resulting "database" via
'Graphviz', with options to exclude some attributes at discovery time, or
remove discovered dependencies at normalisation time.

Mark Webster

autodb

Automatic Database Normalisation for Data Frames

keys function

<dl><dt>x</dt>
<dd>a relational schema object, such as a <code>relation_schema</code>
or <code>database_schema</code> object, or a relational data object, such
as a <code>relation</code> or <code>database</code> object.</dd>
<dt>...</dt>
<dd>further arguments passed on to methods.</dd>
<dt>value</dt>
<dd>A list of lists of character vectors, of the same length as
<code>keys(x, ...)</code>. The number of keys for an element of <code>x</code> can be
changed.</dd></dl>

Arguments

Relational data keys — keys

<dl>

<dt>x</dt>
<dd>a relational schema object, such as a <code>relation_schema</code>
or <code>database_schema</code> object, or a relational data object, such
as a <code>relation</code> or <code>database</code> object.</dd>


<dt>...</dt>
<dd>further arguments passed on to methods.</dd>


<dt>value</dt>
<dd>A list of lists of character vectors, of the same length as
<code>keys(x, ...)</code>. The number of keys for an element of <code>x</code> can be
changed.</dd>

</dl>

keys: Relational data keys

Description

Usage

Value

Arguments