gv.database_schema

Produces text input for Graphviz to make an HTML diagram of a given database
schema.

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

gv.database_schema function

<dl><dt>x</dt>
<dd>a database schema, as given by <code>normalise</code>,
<code>synthesise</code>, or <code>autoref</code>.</dd>
<dt>name</dt>
<dd>a character scalar, giving the name of the schema, if any.</dd>
<dt>...</dt>
<dd>further arguments passed to or from other methods.</dd></dl>

Arguments

Generate Graphviz input text to plot database schemas — gv.database_schema

<dl>

<dt>x</dt>
<dd>a database schema, as given by <code>normalise</code>,
<code>synthesise</code>, or <code>autoref</code>.</dd>


<dt>name</dt>
<dd>a character scalar, giving the name of the schema, if any.</dd>


<dt>...</dt>
<dd>further arguments passed to or from other methods.</dd>

</dl>

gv.database_schema: Generate Graphviz input text to plot database schemas

Description

Usage

Value

Arguments

Details

See Also