Package: ReDaMoR 1.0.0

ReDaMoR: Relational Data Modeler

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' (<https://www.mysql.com/products/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.

Authors:Patrice Godard [aut, cre, cph], Kai Lin [ctb]

ReDaMoR_1.0.0.tar.gz
ReDaMoR_1.0.0.zip(r-4.7)ReDaMoR_1.0.0.zip(r-4.6)ReDaMoR_1.0.0.zip(r-4.5)
ReDaMoR_1.0.0.tgz(r-4.6-any)ReDaMoR_1.0.0.tgz(r-4.5-any)
ReDaMoR_1.0.0.tar.gz(r-4.7-any)ReDaMoR_1.0.0.tar.gz(r-4.6-any)
ReDaMoR_1.0.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION
card.svg |card.png
ReDaMoR/json (API)

# Install 'ReDaMoR' in R:

install.packages('ReDaMoR', repos = c('https://patzaw.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/patzaw/redamor/issues

Pkgdown/docs site:https://patzaw.github.io

On CRAN:

6.49 score 20 stars 1 packages 26 scripts 629 downloads 58 exports 79 dependencies

Last updated from:7b1aede73a. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	170
source / vignettes	OK	228
linux-release-x86_64	OK	171
macos-release-arm64	OK	137
macos-oldrel-arm64	OK	123
windows-devel	OK	158
windows-release	OK	118
windows-oldrel	OK	129
wasm-release	OK	132

Exports:add_field add_foreign_key add_index add_table as_type auto_layout check_foreign_keys check_types clean_autosaved_RelDataModels col_types confront_data confront_table_data conv_type_ref copy_fields correct_constraints df_to_model format_confrontation_report format_confrontation_report_md fromDBM get_foreign_keys guess_constraints identical_RelDataModel identical_RelTableModel index_table is_MM is.MatrixModel is.RelDataModel is.RelTableModel lengths list_autosaved_RelDataModel list_type_ref model_relational_data norm_type_ref order_fields order_indexes read_json_data_model read_named_MM read_named_MM_header read_SQL_data_model readSQLDataModel recover_RelDataModel RelDataModel RelTableModel remove_field remove_foreign_key remove_index remove_table rename_field rename_table set_primary_key set_unique_index SUPPTYPES toDBM update_field update_foreign_key update_table_display view_confrontation_report write_json_data_model

Dependencies:base64enc bit bit64 bslib cachem cli clipr colourpicker commonmark cpp11 crayon crosstalk digest dplyr DT evaluate farver fastmap fontawesome fs generics ggplot2 glue gtable highr hms htmltools htmlwidgets httpuv isoband jquerylib jsonlite knitr labeling later lattice lazyeval lifecycle litedown magrittr markdown Matrix memoise mime miniUI otel pillar pkgconfig prettyunits progress promises R6 rappdirs RColorBrewer Rcpp readr rintrojs rlang rmarkdown rstudioapi S7 sass scales shiny shinyjs sourcetools tibble tidyselect tinytex tzdb utf8 vctrs viridisLite visNetwork vroom withr xfun xtable yaml

Modeling Relational Data in R with ReDaMoR

Rendered fromReDaMoR.Rmdusingknitr::rmarkdown

Last update: 2026-05-18
Started: 2020-02-26

Help page	Topics
Subset a RelDataModel	[.RelDataModel
Add a field to a table in a RelDataModel	add_field
Add a foreign key between two tables	add_foreign_key
Add an index to a table in a RelDataModel	add_index
Add a table to a RelDataModel	add_table
Convert an object into a specific type	as_type
Pre-compute RelDataModel layout when missing any x or y table position	auto_layout
Merge RelDataModel objects	c.RelDataModel
Check the availability of foreign keys	check_foreign_keys
Check if a set of types is supported	check_types
Remove all autosaved RelDataModel	clean_autosaved_RelDataModels
Get the types of the columns of a RelTableModel object	col_types
Confront a RelDataModel to actual data	confront_data
Confront a RelTableModel to actual data	confront_table_data
Convert a set of types from or to R supported types	conv_type_ref
Copy fields from one table to another in a RelDataModel	copy_fields
Correct the constraints of a table to make them consistent	correct_constraints
Create a RelDataModel object from column names of data frames	df_to_model
Format confrontation report for printing in console	format_confrontation_report
Format confrontation report in markdown format	format_confrontation_report_md
Format a RelTableModel object for printing	format.RelTableModel
Convert a list of 5 normalized tibbles in a RelDataModel object	fromDBM
Get a foreign key table from an object	get_foreign_keys
Get foreign keys in RelDataModel	get_foreign_keys.RelDataModel
Get foreign keys from RelTableModel	get_foreign_keys.RelTableModel
Guess RelDataModel constraints based on the provided or existing tables	guess_constraints
Check if two RelDataModel are identical	identical_RelDataModel
Check if two RelTableModel are identical	identical_RelTableModel
List indexes of a RelTableModel object	index_table
Identify if a file is in MatrixMarket text format	is_MM
Check if the object is a RelTableModel matrix object	is.MatrixModel
Check if the object is a RelDataModel object	is.RelDataModel
Check if the object is a RelTableModel object	is.RelTableModel
Lengths of object elements	lengths
List autosaved RelDataModel	list_autosaved_RelDataModel
List supported types references	list_type_ref
Relational data modeler GUI	model_relational_data
VisNetwork representation of a RelDataModel object	modelToVn
Normalize type names	norm_type_ref
Order fields in a table in a RelDataModel	order_fields
Order index in a table in a RelDataModel	order_indexes
Plot a RelDataModel object	plot.RelDataModel
Read a data model from JSON	read_json_data_model
Read a named sparse matrix in MatrixMarket text format	read_named_MM
Read the header of a named sparse matrix in MatrixMarket text format	read_named_MM_header
Read a data model from an SQL file from the MySQL Workbench	readSQLDataModel read_SQL_data_model
Recover an autosaved RelDataModel	recover_RelDataModel
Create a RelDataModel object	RelDataModel
Create a RelTableModel object	RelTableModel
Remove a field from a table in a RelDataModel	remove_field
Remove a foreign key between two tables	remove_foreign_key
Remove an index from a table in a RelDataModel	remove_index
Remove a table from a RelDataModel	remove_table
Rename an existing field in a RelDataModel table	rename_field
Rename a table in a RelDataModel	rename_table
Set the primary key a table in a RelDataModel	set_primary_key
Set table index uniqueness in a RelDataModel	set_unique_index
Supported R types	SUPPTYPES
Convert a RelDataModel object in a list of 5 normalized tibbles	toDBM
Update field information in a table of a RelDataModel	update_field
Update a the cardinalities of a foreign key between two tables	update_foreign_key
Update the display of a table of a RelDataModel	update_table_display
View confrontation report in rstudio viewer	view_confrontation_report
Write a data model in a JSON file	write_json_data_model

Package: ReDaMoR 1.0.0

ReDaMoR: Relational Data Modeler

Citation

Development and contributors

Readme and manuals

Help Manual

Usage by other packages (reverse dependencies)