{ "_id": "6a103a5cacfb0bcc41c9b376", "Package": "DBmaps", "Title": "An R Tool for Streamlining Database Joins", "Version": "0.0.0.9000", "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.2", "Config/testthat/edition": "3", "VignetteBuilder": "knitr", "LazyData": "true", "Repository": "https://akshat09867.r-universe.dev", "Date/Publication": "2025-12-04 08:38:24 UTC", "RemoteUrl": "https://github.com/akshat09867/dbmaps", "RemoteRef": "HEAD", "RemoteSha": "16cba739d673fa871e2c2b26d58826cdb41b5533", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-11 08:28:13 UTC", "User": "root" }, "Author": "Akshat Maurya [aut, cre],\nDavid Shilane [aut]", "Maintainer": "Akshat Maurya ", "MD5sum": "94a51a36d9a3068a085f0e4424cf0e92", "_user": "akshat09867", "_type": "src", "_file": "DBmaps_0.0.0.9000.tar.gz", "_fileid": "7531e3e57e3e019ca994e05a0f54052c06551a0bfd23fc2bf251778fb6200be7", "_filesize": 1926363, "_sha256": "7531e3e57e3e019ca994e05a0f54052c06551a0bfd23fc2bf251778fb6200be7", "_created": "2026-05-11T08:28:13.000Z", "_published": "2026-05-22T11:13:32.179Z", "_distro": "noble", "_jobs": [ { "job": 77368297162, "time": 127, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6913760427" }, { "job": 77368297634, "time": 128, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6913758927" }, { "job": 77368297925, "time": 160, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6913758343" }, { "job": 77368297538, "time": 130, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6913752155" }, { "job": 77368297040, "time": 209, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6913716581" }, { "job": 77368296985, "time": 112, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7159130447" }, { "job": 77368297657, "time": 82, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6936081785" }, { "job": 77368297542, "time": 186, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6913777733" }, { "job": 77368297575, "time": 186, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6913777852" } ], "_buildurl": "https://github.com/r-universe/akshat09867/actions/runs/25658890857", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/akshat09867/dbmaps", "_commit": { "id": "16cba739d673fa871e2c2b26d58826cdb41b5533", "author": "akshat09867 ", "committer": "akshat09867 ", "message": "Add Readme\n", "time": 1764837504 }, "_maintainer": { "name": "Akshat Maurya", "email": "codingmaster902@gmail.com", "login": "akshat09867", "uuid": 149756977 }, "_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-22", "n": 7 }, { "week": "2025-23", "n": 2 }, { "week": "2025-24", "n": 8 }, { "week": "2025-25", "n": 3 }, { "week": "2025-26", "n": 4 }, { "week": "2025-27", "n": 5 }, { "week": "2025-28", "n": 3 }, { "week": "2025-29", "n": 2 }, { "week": "2025-30", "n": 9 }, { "week": "2025-31", "n": 3 }, { "week": "2025-32", "n": 2 }, { "week": "2025-33", "n": 2 }, { "week": "2025-34", "n": 9 }, { "week": "2025-35", "n": 6 }, { "week": "2025-49", "n": 2 } ], "_tags": [], "_stars": 3, "_contributors": [ { "user": "akshat09867", "count": 67, "uuid": 149756977 } ], "_userbio": { "uuid": 149756977, "type": "user", "name": "Akshat Maurya" }, "_downloads": { "count": 481, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/DBmaps" }, "_devurl": "https://github.com/akshat09867/dbmaps", "_searchresults": 10, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/DBmaps.html", "extra/NEWS.html", "extra/NEWS.txt", "manual.pdf" ], "_homeurl": "https://github.com/akshat09867/dbmaps", "_realowner": "akshat09867", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2025-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": 5.352182518111363, "_indexed": true, "_nocasepkg": "dbmaps", "_universes": [ "akshat09867" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.0.9000", "date": "2026-05-11T08:30:30.000Z", "distro": "noble", "commit": "16cba739d673fa871e2c2b26d58826cdb41b5533", "fileid": "5fa637d0444dd341f7e44dc5c88f98381db03fcef0ca6b24ea0dd2228de427b7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/25658890857" }, { "r": "4.6.0", "os": "linux", "version": "0.0.0.9000", "date": "2026-05-11T08:30:26.000Z", "distro": "noble", "commit": "16cba739d673fa871e2c2b26d58826cdb41b5533", "fileid": "e931d38b976f0876169915e508ac807901a8c94c41c5f1964eed55b7232196e9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/25658890857" }, { "r": "4.5.3", "os": "mac", "version": "0.0.0.9000", "date": "2026-05-11T08:30:28.000Z", "commit": "16cba739d673fa871e2c2b26d58826cdb41b5533", "fileid": "b385d722ff370db0e53676e924f6661da349ab00acd4378e8e467bfe14704217", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/25658890857" }, { "r": "4.6.0", "os": "mac", "version": "0.0.0.9000", "date": "2026-05-11T08:30:10.000Z", "commit": "16cba739d673fa871e2c2b26d58826cdb41b5533", "fileid": "fabd30195e283e059c27cb5461c0686d238b8b81d1d0090f6474b9906a44f7a7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/25658890857" }, { "r": "4.7.0", "os": "win", "version": "0.0.0.9000", "date": "2026-05-12T05:06:04.000Z", "commit": "16cba739d673fa871e2c2b26d58826cdb41b5533", "fileid": "369b09f368073878d33d5ae92b4942b218ccc2f72a07603e660d8320de1bf3bb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/25658890857" }, { "r": "4.5.3", "os": "win", "version": "0.0.0.9000", "date": "2026-05-11T08:31:19.000Z", "commit": "16cba739d673fa871e2c2b26d58826cdb41b5533", "fileid": "b5c4565f10a307ce628c5d296dd2aacaa7c59d950a72ede016874f4d4455ad59", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/25658890857" }, { "r": "4.6.0", "os": "win", "version": "0.0.0.9000", "date": "2026-05-11T08:30:39.000Z", "commit": "16cba739d673fa871e2c2b26d58826cdb41b5533", "fileid": "647a8836e24c44dfd86ee5b5c3cde6a312cda55b2630d72f48d1154d99edda85", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/25658890857" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.0.9000", "date": "2026-05-22T11:13:09.000Z", "commit": "16cba739d673fa871e2c2b26d58826cdb41b5533", "fileid": "f65043996b14b7e2a2c62ba3cc95ce8fab6ddf72a9988660f6bc56aea5469819", "status": "success", "buildurl": "https://github.com/r-universe/akshat09867/actions/runs/25658890857" } ] }