Package: ReDaMoR 0.7.6

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_0.7.6.tar.gz
ReDaMoR_0.7.6.zip(r-4.5)ReDaMoR_0.7.6.zip(r-4.4)ReDaMoR_0.7.6.zip(r-4.3)
ReDaMoR_0.7.6.tgz(r-4.4-any)ReDaMoR_0.7.6.tgz(r-4.3-any)
ReDaMoR_0.7.6.tar.gz(r-4.5-noble)ReDaMoR_0.7.6.tar.gz(r-4.4-noble)
ReDaMoR_0.7.6.tgz(r-4.4-emscripten)ReDaMoR_0.7.6.tgz(r-4.3-emscripten)
ReDaMoR.pdf |ReDaMoR.html✨
ReDaMoR/json (API)

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

Peer review:

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

On CRAN:

56 exports 18 stars 2.28 score 82 dependencies 1 dependents 20 scripts 322 downloads

Last updated 13 days agofrom:a19b1e3e3c. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKSep 04 2024
R-4.5-winOKSep 04 2024
R-4.5-linuxOKSep 04 2024
R-4.4-winOKSep 04 2024
R-4.4-macOKSep 04 2024
R-4.3-winOKSep 04 2024
R-4.3-macOKSep 04 2024

Exports:add_fieldadd_foreign_keyadd_indexadd_tableas_typeauto_layoutcheck_foreign_keyscheck_typesclean_autosaved_RelDataModelscol_typesconfront_dataconfront_table_dataconv_type_refcopy_fieldscorrect_constraintsdf_to_modelformat_confrontation_reportformat_confrontation_report_mdfromDBMget_foreign_keysidentical_RelDataModelidentical_RelTableModelindex_tableis_MMis.MatrixModelis.RelDataModelis.RelTableModellengthslist_autosaved_RelDataModellist_type_refmodel_relational_datanorm_type_reforder_fieldsread_json_data_modelread_named_MMread_named_MM_headerread_SQL_data_modelreadSQLDataModelrecover_RelDataModelRelDataModelRelTableModelremove_fieldremove_foreign_keyremove_indexremove_tablerename_fieldrename_tableset_primary_keyset_unique_indexSUPPTYPEStoDBMupdate_fieldupdate_foreign_keyupdate_table_displayview_confrontation_reportwrite_json_data_model

Dependencies:base64encbitbit64bslibcachemclicliprcolorspacecolourpickercommonmarkcpp11crayoncrosstalkdigestdplyrDTevaluatefansifarverfastmapfontawesomefsgenericsggplot2gluegtablehighrhmshtmltoolshtmlwidgetshttpuvisobandjquerylibjsonliteknitrlabelinglaterlatticelazyevallifecyclemagrittrmarkdownMASSMatrixmemoisemgcvmimeminiUImunsellnlmepillarpkgconfigprettyunitsprogresspromisesR6rappdirsRColorBrewerRcppreadrrintrojsrlangrmarkdownrstudioapisassscalesshinyshinyjssourcetoolstibbletidyselecttinytextzdbutf8vctrsviridisLitevisNetworkvroomwithrxfunxtableyaml

Modeling Relational Data in R with ReDaMoR

Patrice Godard

Rendered fromReDaMoR.Rmdusingknitr::rmarkdownon Sep 04 2024.

Last update: 2024-07-06
Started: 2020-02-26

Readme and manuals

Help Manual

Help pageTopics
Subset a RelDataModel[.RelDataModel
Add a field to a table in a RelDataModeladd_field
Add a foreign key between two tablesadd_foreign_key
Add an index to a table in a RelDataModeladd_index
Add a table to a RelDataModeladd_table
Convert an object into a specific typeas_type
Pre-compute RelDataModel layout when missing any x or y table positionauto_layout
Merge RelDataModel objectsc.RelDataModel
Check the availability of foreign keyscheck_foreign_keys
Check if a set of types is supportedcheck_types
Remove all autosaved RelDataModelclean_autosaved_RelDataModels
Get the types of the columns of a RelTableModel objectcol_types
Confront a RelDataModel to actual dataconfront_data
Confront a RelTableModel to actual dataconfront_table_data
Convert a set of types from or to R supported typesconv_type_ref
Copy fields from one table to another in a RelDataModelcopy_fields
Correct the constraints of a table to make them consistentcorrect_constraints
Create a RelDataModel object from column names of data framesdf_to_model
Format confrontation report for printing in consoleformat_confrontation_report
Format confrontation report in markdown formatformat_confrontation_report_md
Format a RelTableModel object for printingformat.RelTableModel
Convert a list of 5 normalized tibbles in a RelDataModel objectfromDBM
Get a foreign key table from an objectget_foreign_keys
Get foreign keys in RelDataModelget_foreign_keys.RelDataModel
Get foreign keys from RelTableModelget_foreign_keys.RelTableModel
Check if two RelDataModel are identicalidentical_RelDataModel
Check if two RelTableModel are identicalidentical_RelTableModel
List indexes of a RelTableModel objectindex_table
Identify if a file is in MatrixMarket text formatis_MM
Check if the object is a RelTableModel matrix objectis.MatrixModel
Check if the object is a RelDataModel objectis.RelDataModel
Check if the object is a RelTableModel objectis.RelTableModel
Lengths of object elementslengths
List autosaved RelDataModellist_autosaved_RelDataModel
List supported types referenceslist_type_ref
Relational data modeler GUImodel_relational_data
VisNetwork representation of a RelDataModel objectmodelToVn
Normalize type namesnorm_type_ref
Order fields in a table in a RelDataModelorder_fields
Plot a RelDataModel objectplot.RelDataModel
Read a data model from JSONread_json_data_model
Read a named sparse matrix in MatrixMarket text formatread_named_MM
Read the header of a named sparse matrix in MatrixMarket text formatread_named_MM_header
Read a data model from an SQL file from the MySQL WorkbenchreadSQLDataModel read_SQL_data_model
Recover an autosaved RelDataModelrecover_RelDataModel
Create a RelDataModel objectRelDataModel
Create a RelTableModel objectRelTableModel
Remove a field from a table in a RelDataModelremove_field
Remove a foreign key between two tablesremove_foreign_key
Remove an index from a table in a RelDataModelremove_index
Remove a table from a RelDataModelremove_table
Rename an existing field in a RelDataModel tablerename_field
Rename a table in a RelDataModelrename_table
Set the primary key a table in a RelDataModelset_primary_key
Set table index uniqueness in a RelDataModelset_unique_index
Supported R typesSUPPTYPES
Convert a RelDataModel object in a list of 5 normalized tibblestoDBM
Update field information in a table of a RelDataModelupdate_field
Update a the cardinalities of a foreign key between two tablesupdate_foreign_key
Update the display of a table of a RelDataModelupdate_table_display
View confrontation report in rstudio viewerview_confrontation_report
Write a data model in a JSON filewrite_json_data_model