Package: DBmaps 0.1.1

DBmaps: An R Tool for Streamlining Database Joins

Simplifies and automates the process of exploring and merging data from relational databases. This package allows users to discover table relationships, create a map of all possible joins, and generate executable plans to merge data based on a structured metadata framework.

Authors:Akshat Maurya [aut, cre], David Shilane [aut]

DBmaps_0.1.1.tar.gz
DBmaps_0.1.1.zip(r-4.7-any)DBmaps_0.1.1.zip(r-4.6-any)DBmaps_0.1.1.zip(r-4.5-any)
DBmaps_0.1.1.tgz(r-4.6-any)DBmaps_0.1.1.tgz(r-4.5-any)
DBmaps_0.1.1.tar.gz(r-4.7-any)DBmaps_0.1.1.tar.gz(r-4.6-any)
DBmaps_0.1.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
DBmaps/json (API)

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

Bug tracker:https://github.com/akshat09867/dbmaps/issues

Datasets:

On CRAN:

Conda:

4.48 score 3 stars 332 downloads 8 exports 1 dependencies

Last updated from:3b86703072. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-develOK136
source / vignettesOK212
linux-releaseOK132
macos-releaseOK181
macos-oldrelOK189
windows-develOK82
windows-releaseOK92
windows-oldrelOK72
wasm-releaseOK123

Exports:add_tablecreate_join_plancreate_metadata_registryexecute_join_plangenerate_aggregation_codemap_join_pathsplot_join_plantable_info

Dependencies:data.table

Introduction to DBmaps
Introduction | A Complete Workflow Example | 1. The Example Data | 2. Defining Metadata with table_info() | Understanding the Metadata Columns | 3. create_metadata_registry() and add_table() | 4. Discovering Join Paths with map_join_paths() | Combining Both Methods | 5. Creating an Execution Plan with create_join_plan() | 6. Visualizing the Plan | 7. Executing the Plan | Conclusion
Rendered fromDBmaps-introduction.Rmdusingknitr::rmarkdown

Last update: 2025-08-28
Started: 2025-05-31

Creating Execution Plans for Data Joins
Introduction to the Planner | 1. Define Metadata | 2. Create Join Plan | 3. Handling Invalid Requests
Rendered fromjoin-plan.Rmdusingknitr::rmarkdown

Last update: 2025-08-06
Started: 2025-07-31

Automated Join Path Discovery
Introduction | Case 1: Standard Joins via Metadata | Case 2: Multi-Variable Key Joins | Case 3: Inferring Joins from Data | Combining Both Methods
Rendered fromdiscovering-join-paths.Rmdusingknitr::rmarkdown

Last update: 2025-07-14
Started: 2025-07-01

Defining Table Metadata with table_info()
Introduction | The table_info() Function | Example 1: The Customers Table | Example 2: The Products Table | Example 3: The Transactions Table | Assembling a Master Metadata Table
Rendered fromdefining-table-metadata.Rmdusingknitr::rmarkdown

Last update: 2025-06-24
Started: 2025-06-09

Generating Aggregation Code from Metadata
Introduction | Create the Master Metadata | Generate Aggregation Code | Execute the Generated Code | Conclusion
Rendered fromgenerating-aggregation-code.Rmdusingknitr::rmarkdown

Last update: 2025-06-17
Started: 2025-06-17