{ "_id": "6abcd7aa99f7aa8c6aa4cbab", "Package": "DBmaps", "Title": "An R Tool for Streamlining Database Joins", "Version": "0.1.1", "Authors@R": "c(\nperson(\"Akshat\", \"Maurya\", ,\"codingmaster902@gmail.com\", role = c(\"aut\", \"cre\")),\nperson(\"David\", \"Shilane\", ,\"david.shilane@columbia.edu\", role = c(\"aut\"))\n)", "Description": "Simplifies and automates the process of exploring and\nmerging data from relational databases. This package allows\nusers to discover table relationships, create a map of all\npossible joins, and generate executable plans to merge data\nbased on a structured metadata framework.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "Config/testthat/edition": "3", "VignetteBuilder": "knitr", "LazyData": "true", "Repository": "https://akshat09867.r-universe.dev", "Date/Publication": "2026-08-31 06:06:20 UTC", "RemoteUrl": "https://github.com/akshat09867/dbmaps", "RemoteRef": "HEAD", "RemoteSha": "3b86703072bb28b65c70c334a788e9db3f40f67e", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-30 09:06:33 UTC", "User": "root" }, "Author": "Akshat Maurya [aut, cre],\nDavid Shilane [aut]", "Maintainer": "Akshat Maurya ", "_user": "akshat09867", "_type": "src", "_file": "DBmaps_0.1.1.tar.gz", "_fileid": "https://r2.ropensci.org/fff62f29502f0591ea0286cc437589fc2255402141bc2a0649fb31f56dad9667", "_filesize": 1923525, "_sha256": "fff62f29502f0591ea0286cc437589fc2255402141bc2a0649fb31f56dad9667", "_expires": "2027-01-08T09:34:32.000Z", "_created": "2026-09-30T09:06:33.000Z", "_published": "2026-09-30T09:34:34.358Z", "_jobs": [ { "job": 109817517055, "time": 136, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11086953641" }, { "job": 109817517040, "time": 132, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11087023098" }, { "job": 109817516877, "time": 189, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11088266948" }, { "job": 109817516899, "time": 181, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11087074526" }, { "job": 109816272121, "time": 212, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11087260001" }, { "job": 109817516934, "time": 123, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11087110615" }, { "job": 109817516939, "time": 82, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11086509928" }, { "job": 109817517131, "time": 72, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11086509893" }, { "job": 109817517115, "time": 92, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11086858794" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/akshat09867/actions/runs/36693579748", "_status": "success", "_upstream": "https://github.com/akshat09867/dbmaps", "_commit": { "id": "3b86703072bb28b65c70c334a788e9db3f40f67e", "author": "akshat09867 ", "committer": "akshat09867 ", "message": "fixed inferred join code generation\n", "time": 1788156380 }, "_maintainer": { "name": "Akshat Maurya", "email": "codingmaster902@gmail.com", "login": "akshat09867", "description": "", "uuid": 149756977 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.5", "role": "Depends" }, { "package": "data.table", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "DiagrammeR", "role": "Suggests" } ], "_owner": "akshat09867", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-49", "n": 2 }, { "week": "2026-36", "n": 1 } ], "_tags": [], "_stars": 3, "_contributors": [ { "user": "akshat09867", "count": 68, "uuid": 149756977 } ], "_userbio": { "uuid": 149756977, "type": "user", "name": "Akshat Maurya", "followers": 8 }, "_downloads": { "count": 332, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/DBmaps" }, "_devurl": "https://github.com/akshat09867/dbmaps", "_searchresults": 0, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/DBmaps.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "LICENSE" ], "_homeurl": "https://github.com/akshat09867/dbmaps", "_realowner": "akshat09867", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2025-09-08" }, { "version": "0.1.1", "date": "2026-09-08" } ], "_exports": [ "add_table", "create_join_plan", "create_metadata_registry", "execute_join_plan", "generate_aggregation_code", "map_join_paths", "plot_join_plan", "table_info" ], "_datasets": [ { "name": "customers", "title": "Sample Customer Data", "object": "customers", "class": [ "data.table", "data.frame" ], "fields": [ "customer_id", "age", "gender", "income", "region" ], "rows": 30000, "table": true, "tojson": true }, { "name": "products", "title": "Sample Product Data", "object": "products", "class": [ "data.table", "data.frame" ], "fields": [ "product_id", "category", "original_price" ], "rows": 8637, "table": true, "tojson": true }, { "name": "transactions", "title": "Sample Transaction Data", "object": "transactions", "class": [ "data.table", "data.frame" ], "fields": [ "customer_id", "product_id", "time", "quantity", "price" ], "rows": 40000, "table": true, "tojson": true }, { "name": "views", "title": "Sample Product View Data", "object": "views", "class": [ "data.table", "data.frame" ], "fields": [ "customer_id", "product_id", "time" ], "rows": 50000, "table": true, "tojson": true } ], "_help": [ { "page": "add_table", "title": "Add a Table's Metadata to a Registry", "topics": [ "add_table" ] }, { "page": "create_join_plan", "title": "Create a Plan for Aggregating and Merging Tables", "topics": [ "create_join_plan" ] }, { "page": "create_metadata_registry", "title": "Create a Metadata Registry", "topics": [ "create_metadata_registry" ] }, { "page": "customers", "title": "Sample Customer Data", "topics": [ "customers" ] }, { "page": "execute_join_plan", "title": "Execute a Join Plan", "topics": [ "execute_join_plan" ] }, { "page": "generate_aggregation_code", "title": "Generate data.table Aggregation Code from Metadata", "topics": [ "generate_aggregation_code" ] }, { "page": "map_join_paths", "title": "Discover Potential Join Paths from Metadata and Data", "topics": [ "map_join_paths" ] }, { "page": "plot_join_plan", "title": "Plot a Join Plan as a Flowchart", "topics": [ "plot_join_plan" ] }, { "page": "products", "title": "Sample Product Data", "topics": [ "products" ] }, { "page": "table_info", "title": "Define Metadata for a Data Table in a Tidy data.table", "topics": [ "table_info" ] }, { "page": "transactions", "title": "Sample Transaction Data", "topics": [ "transactions" ] }, { "page": "views", "title": "Sample Product View Data", "topics": [ "views" ] } ], "_rundeps": [ "data.table" ], "_vignettes": [ { "source": "discovering-join-paths.Rmd", "filename": "discovering-join-paths.html", "title": "Automated Join Path Discovery", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Case 1: Standard Joins via Metadata", "Case 2: Multi-Variable Key Joins", "Case 3: Inferring Joins from Data", "Combining Both Methods" ], "created": "2025-07-01 05:54:06", "modified": "2025-07-14 05:54:25", "commits": 2 }, { "source": "join-plan.Rmd", "filename": "join-plan.html", "title": "Creating Execution Plans for Data Joins", "engine": "knitr::rmarkdown", "headings": [ "Introduction to the Planner", "1. Define Metadata", "2. Create Join Plan", "3. Handling Invalid Requests" ], "created": "2025-07-31 05:28:40", "modified": "2025-08-06 08:44:06", "commits": 2 }, { "source": "defining-table-metadata.Rmd", "filename": "defining-table-metadata.html", "title": "Defining Table Metadata with table_info()", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2025-06-09 05:59:30", "modified": "2025-06-24 04:51:31", "commits": 5 }, { "source": "generating-aggregation-code.Rmd", "filename": "generating-aggregation-code.html", "title": "Generating Aggregation Code from Metadata", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Create the Master Metadata", "Generate Aggregation Code", "Execute the Generated Code", "Conclusion" ], "created": "2025-06-17 05:59:49", "modified": "2025-06-17 05:59:49", "commits": 1 }, { "source": "DBmaps-introduction.Rmd", "filename": "DBmaps-introduction.html", "title": "Introduction to DBmaps", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2025-05-31 05:36:14", "modified": "2025-08-28 06:08:05", "commits": 13 } ], "_score": 4.477121254719663, "_indexed": true, "_nocasepkg": "dbmaps", "_universes": [ "akshat09867" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.1", "date": "2026-09-30T09:08:51.000Z", "distro": "resolute", "commit": "3b86703072bb28b65c70c334a788e9db3f40f67e", "fileid": "https://r2.ropensci.org/0e63ddb4d327e555049115e347d34441203a195904da251e6a0e451d09cf4cb9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/36693579748" }, { "r": "4.6.1", "os": "linux", "version": "0.1.1", "date": "2026-09-30T09:08:47.000Z", "distro": "resolute", "commit": "3b86703072bb28b65c70c334a788e9db3f40f67e", "fileid": "https://r2.ropensci.org/c69291c9c745262c9fe37bb2a8c076016c8e96081f0b12f797eb070c397d7f69", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/36693579748" }, { "r": "4.5.3", "os": "mac", "version": "0.1.1", "date": "2026-09-30T09:28:34.000Z", "commit": "3b86703072bb28b65c70c334a788e9db3f40f67e", "fileid": "https://r2.ropensci.org/d7f46c6b8c8153c7244e768598a99c9b0e134136abd67909f38927a3b9ec4f06", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/36693579748" }, { "r": "4.6.1", "os": "mac", "version": "0.1.1", "date": "2026-09-30T09:33:16.000Z", "commit": "3b86703072bb28b65c70c334a788e9db3f40f67e", "fileid": "https://r2.ropensci.org/785783e4b14118f763b214465e4edbb3d46912f23912053ee996c3615990d2b3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/36693579748" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.1", "date": "2026-09-30T09:08:50.000Z", "commit": "3b86703072bb28b65c70c334a788e9db3f40f67e", "fileid": "https://r2.ropensci.org/3332e520a4bfac66372e18250bbf90878f04c0178dc63cfe4567c0de520e7146", "status": "success", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/36693579748" }, { "r": "4.7.0", "os": "win", "version": "0.1.1", "date": "2026-09-30T09:07:45.000Z", "commit": "3b86703072bb28b65c70c334a788e9db3f40f67e", "fileid": "https://r2.ropensci.org/78082b06bd6c305a2cd339802d7710491f5fb0570c1311a53184042f2916e34f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/36693579748" }, { "r": "4.5.3", "os": "win", "version": "0.1.1", "date": "2026-09-30T09:07:39.000Z", "commit": "3b86703072bb28b65c70c334a788e9db3f40f67e", "fileid": "https://r2.ropensci.org/20d5375b572795aa62d31cf189d5f5d771c74f79951e845c724324007e77af89", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/36693579748" }, { "r": "4.6.1", "os": "win", "version": "0.1.1", "date": "2026-09-30T09:07:57.000Z", "commit": "3b86703072bb28b65c70c334a788e9db3f40f67e", "fileid": "https://r2.ropensci.org/4d92d0d14a33142b466f7c02ae7c6c8954bf69bb7d1cf91d91a33fcf5a6f54b4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/36693579748" } ] }