Learn R Programming

⚠️There's a newer version (0.8.2) of this package.Take me there.

ReDaMoR (version 0.7.2)

Relational Data Modeler

Description

The aim of this package is to manipulate relational data models in R. It provides functions to create, modify and export data models in json format. It also allows importing models created with 'MySQL Workbench' (). These functions are accessible through a graphical user interface made with 'shiny'. Constraints such as types, keys, uniqueness and mandatory fields are automatically checked and corrected when editing a model. Finally, real data can be confronted to a model to check their compatibility.

Copy Link

Version

Install

install.packages('ReDaMoR')

Monthly Downloads

187

Version

0.7.2

License

GPL-3

Issues

Pull Requests

Stars

Forks

Maintainer

Patrice Godard

Last Published

July 6th, 2023

Functions in ReDaMoR (0.7.2)

RelTableModel

Create a RelTableModel object
add_field

Add a field to a table in a RelDataModel
check_foreign_keys

Check the availability of foreign keys
add_index

Add an index to a table in a RelDataModel
format_confrontation_report_md

Format confrontation report in markdown format
add_table

Add a table to a RelDataModel
fromDBM

Convert a list of 5 normalized tibbles in a RelDataModel object
auto_layout

Pre-compute RelDataModel layout when missing any x or y table position
check_types

Check if a set of types is supported
c.RelDataModel

Merge RelDataModel objects
model_relational_data

Relational data modeler GUI
confront_data

Confront a RelDataModel to actual data
confront_table_data

Confront a RelTableModel to actual data
clean_autosaved_RelDataModels

Remove all autosaved RelDataModel
col_types

Get the types of the columns of a RelTableModel object
get_foreign_keys

Get a foreign key table from an object
get_foreign_keys.RelDataModel

Get foreign keys in RelDataModel
conv_type_ref

Convert a set of types from or to R supported types
format.RelTableModel

Format a RelTableModel object for printing
norm_type_ref

Normalize type names
lengths

Lengths of object elements
format_confrontation_report

Format confrontation report for printing in console
as_type

Convert an object into a specific type
list_autosaved_RelDataModel

List autosaved RelDataModel
update_foreign_key

Update a the cardinalities of a foreign key between two tables
is.RelTableModel

Check if the object is a RelTableModel object
remove_foreign_key

Remove a foreign key between two tables
identical_RelTableModel

Check if two RelTableModel are identical
is_MM

Identify if a file is in MatrixMarket text format
copy_fields

Copy fields from one table to another in a RelDataModel
remove_index

Remove an index from a table in a RelDataModel
update_table_display

Update the display of a table of a RelDataModel
read_SQL_data_model

Read a data model from an SQL file from the MySQL Workbench
correct_constraints

Correct the constraints of a table to make them consistent
read_json_data_model

Read a data model from JSON
df_to_model

Create a RelDataModel object from column names of data frames
index_table

List indexes of a RelTableModel object
get_foreign_keys.RelTableModel

Get foreign keys from RelTableModel
is.MatrixModel

Check if the object is a RelTableModel matrix object
rename_table

Rename a table in a RelDataModel
set_primary_key

Set the primary key a table in a RelDataModel
order_fields

Order fields in a table in a RelDataModel
plot.RelDataModel

Plot a RelDataModel object
toDBM

Convert a RelDataModel object in a list of 5 normalized tibbles
update_field

Update field information in a table of a RelDataModel
list_type_ref

List supported types references
identical_RelDataModel

Check if two RelDataModel are identical
is.RelDataModel

Check if the object is a RelDataModel object
modelToVn

VisNetwork representation of a RelDataModel object
recover_RelDataModel

Recover an autosaved RelDataModel
remove_field

Remove a field from a table in a RelDataModel
read_named_MM

Read a named sparse matrix in MatrixMarket text format
read_named_MM_header

Read the header of a named sparse matrix in MatrixMarket text format
remove_table

Remove a table from a RelDataModel
rename_field

Rename an existing field in a RelDataModel table
view_confrontation_report

View confrontation report in rstudio viewer
set_unique_index

Set table index uniqueness in a RelDataModel
[.RelDataModel

Subset a RelDataModel
write_json_data_model

Write a data model in a JSON file
RelDataModel

Create a RelDataModel object
SUPPTYPES

Supported R types
add_foreign_key

Add a foreign key between two tables