Learn R Programming

ReDaMoR (version 0.8.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

309

Version

0.8.2

License

GPL-3

Issues

Pull Requests

Stars

Forks

Maintainer

Patrice Godard

Last Published

February 21st, 2025

Functions in ReDaMoR (0.8.2)

col_types

Get the types of the columns of a RelTableModel object
clean_autosaved_RelDataModels

Remove all autosaved RelDataModel
confront_table_data

Confront a RelTableModel to actual data
correct_constraints

Correct the constraints of a table to make them consistent
get_foreign_keys.RelTableModel

Get foreign keys from RelTableModel
format_confrontation_report

Format confrontation report for printing in console
plot.RelDataModel

Plot a RelDataModel object
read_SQL_data_model

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

Check if a set of types is supported
format.RelTableModel

Format a RelTableModel object for printing
guess_constraints

Guess RelDataModel constraints based on the provided or existing tables
model_relational_data

Relational data modeler GUI
read_json_data_model

Read a data model from JSON
modelToVn

VisNetwork representation of a RelDataModel object
get_foreign_keys.RelDataModel

Get foreign keys in RelDataModel
list_type_ref

List supported types references
list_autosaved_RelDataModel

List autosaved RelDataModel
df_to_model

Create a RelDataModel object from column names of data frames
get_foreign_keys

Get a foreign key table from an object
read_named_MM

Read a named sparse matrix in MatrixMarket text format
identical_RelDataModel

Check if two RelDataModel are identical
format_confrontation_report_md

Format confrontation report in markdown format
write_json_data_model

Write a data model in a JSON file
[.RelDataModel

Subset a RelDataModel
toDBM

Convert a RelDataModel object in a list of 5 normalized tibbles
is.RelTableModel

Check if the object is a RelTableModel object
is.RelDataModel

Check if the object is a RelDataModel object
identical_RelTableModel

Check if two RelTableModel are identical
index_table

List indexes of a RelTableModel object
set_primary_key

Set the primary key a table in a RelDataModel
order_fields

Order fields in a table in a RelDataModel
rename_field

Rename an existing field in a RelDataModel table
norm_type_ref

Normalize type names
rename_table

Rename a table in a RelDataModel
update_foreign_key

Update a the cardinalities of a foreign key between two tables
update_field

Update field information in a table of a RelDataModel
is_MM

Identify if a file is in MatrixMarket text format
lengths

Lengths of object elements
set_unique_index

Set table index uniqueness in a RelDataModel
is.MatrixModel

Check if the object is a RelTableModel matrix object
read_named_MM_header

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

Remove an index from a table in a RelDataModel
remove_table

Remove a table from a RelDataModel
recover_RelDataModel

Recover an autosaved RelDataModel
update_table_display

Update the display of a table of a RelDataModel
remove_field

Remove a field from a table in a RelDataModel
view_confrontation_report

View confrontation report in rstudio viewer
remove_foreign_key

Remove a foreign key between two tables
fromDBM

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

Create a RelDataModel object
RelTableModel

Create a RelTableModel object
add_field

Add a field to a table in a RelDataModel
auto_layout

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

Convert an object into a specific type
add_foreign_key

Add a foreign key between two tables
add_index

Add an index to a table in a RelDataModel
add_table

Add a table to a RelDataModel
c.RelDataModel

Merge RelDataModel objects
SUPPTYPES

Supported R types
check_foreign_keys

Check the availability of foreign keys
copy_fields

Copy fields from one table to another in a RelDataModel
conv_type_ref

Convert a set of types from or to R supported types
confront_data

Confront a RelDataModel to actual data