{ "_id": "6a27da8c24555f66ed547453", "Package": "starschemar", "Title": "Obtaining Stars from Flat Tables", "Version": "1.2.5.9000", "Authors@R": "c(\nperson(\"Jose\", \"Samos\", , \"jsamos@ugr.es\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-4457-3439\")),\nperson(\"Universidad de Granada\", role = \"cph\")\n)", "Description": "Data in multidimensional systems is obtained from\noperational systems and is transformed to adapt it to the new\nstructure. Frequently, the operations to be performed aim to\ntransform a flat table into a star schema. Transformations can\nbe carried out using professional extract, transform and load\ntools or tools intended for data transformation for end users.\nWith the tools mentioned, this transformation can be carried\nout, but it requires a lot of work. The main objective of this\npackage is to define transformations that allow obtaining stars\nfrom flat tables easily. In addition, it includes basic data\ncleaning, dimension enrichment, incremental data refresh and\nquery operations, adapted to this context.", "License": "MIT + file LICENSE", "URL": "https://josesamos.github.io/starschemar/,\nhttps://github.com/josesamos/starschemar", "BugReports": "https://github.com/josesamos/starschemar/issues", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "Language": "en-GB", "LazyData": "true", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.1", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://josesamos.r-universe.dev", "Date/Publication": "2024-05-02 07:21:05 UTC", "RemoteUrl": "https://github.com/josesamos/starschemar", "RemoteRef": "HEAD", "RemoteSha": "5ed318f0a05cec36e5dbecb8a182185b6465c87d", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-09 09:15:30 UTC", "User": "root" }, "Author": "Jose Samos [aut, cre] (ORCID: ),\nUniversidad de Granada [cph]", "Maintainer": "Jose Samos ", "MD5sum": "f9712c8cc47f37cebf01e386663e18a6", "_user": "josesamos", "_type": "src", "_file": "starschemar_1.2.5.9000.tar.gz", "_fileid": "db2af981c1bbbef2e3075e80e83d9b5db1b58095e5bc315d81e64848ece70f2c", "_filesize": 756739, "_sha256": "db2af981c1bbbef2e3075e80e83d9b5db1b58095e5bc315d81e64848ece70f2c", "_created": "2026-06-09T09:15:30.000Z", "_published": "2026-06-09T09:19:08.160Z", "_distro": "noble", "_jobs": [ { "job": 80288512261, "time": 147, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7503504868" }, { "job": 80288512188, "time": 182, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7503517542" }, { "job": 80288512201, "time": 129, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7503497685" }, { "job": 80288512212, "time": 84, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7503481103" }, { "job": 80287922929, "time": 191, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7503447152" }, { "job": 80288512192, "time": 108, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7503490112" }, { "job": 80288512221, "time": 118, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7503494037" }, { "job": 80288512223, "time": 98, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7503486270" }, { "job": 80288512226, "time": 106, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7503489784" } ], "_buildurl": "https://github.com/r-universe/josesamos/actions/runs/27196059437", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/josesamos/starschemar", "_commit": { "id": "5ed318f0a05cec36e5dbecb8a182185b6465c87d", "author": "josesamos ", "committer": "josesamos ", "message": "Increment version number to 1.2.5.9000\n", "time": 1714634465 }, "_maintainer": { "name": "Jose Samos", "email": "jsamos@ugr.es", "login": "josesamos", "description": "R / GIS / Geocomputation / DW / OLAP / Multidimensional Systems", "uuid": 13182483, "orcid": "0000-0002-4457-3439" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "dplyr", "role": "Imports" }, { "package": "generics", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "snakecase", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "pander", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "josesamos", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 8, "_contributors": [ { "user": "josesamos", "count": 111, "uuid": 13182483 } ], "_userbio": { "uuid": 13182483, "type": "user", "name": "JOSE SAMOS JIMENEZ", "description": "R / GIS / Geocomputation / DW / OLAP / Multidimensional Systems" }, "_downloads": { "count": 611, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/starschemar" }, "_devurl": "https://github.com/josesamos/starschemar", "_pkgdown": "https://josesamos.github.io/starschemar/", "_searchresults": 11, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/starschemar.html", "manual.pdf" ], "_homeurl": "https://github.com/josesamos/starschemar", "_realowner": "josesamos", "_cranurl": true, "_releases": [ { "version": "1.0.0", "date": "2020-08-07" }, { "version": "1.1.0", "date": "2020-09-13" }, { "version": "1.2.0", "date": "2020-09-25" }, { "version": "1.2.1", "date": "2023-08-12" }, { "version": "1.2.2", "date": "2023-09-14" }, { "version": "1.2.3", "date": "2023-11-11" }, { "version": "1.2.4", "date": "2024-01-08" }, { "version": "1.2.5", "date": "2024-05-02" } ], "_exports": [ "character_dimensions", "constellation", "constellation_as_multistar", "constellation_as_tibble_list", "define_dimension", "define_fact", "dimensional_model", "dimensional_query", "enrich_dimension_export", "enrich_dimension_import", "enrich_dimension_import_test", "filter_dimension", "filter_fact_rows", "get_conformed_dimension", "get_conformed_dimension_names", "get_dimension", "get_dimension_attribute_names", "get_dimension_names", "get_measure_names", "get_star_schema", "get_star_schema_names", "incremental_refresh_constellation", "incremental_refresh_star_schema", "match_records", "modify_conformed_dimension_records", "modify_dimension_records", "multistar_as_flat_table", "purge_dimensions_constellation", "purge_dimensions_star_schema", "record_update_set", "rename_dimension", "rename_dimension_attributes", "rename_fact", "rename_measures", "role_playing_dimension", "run_query", "select_dimension", "select_fact", "snake_case", "star_schema", "star_schema_as_flat_table", "star_schema_as_multistar", "star_schema_as_tibble_list", "update_record", "update_selection", "update_selection_general" ], "_datasets": [ { "name": "ct_mrs", "title": "Constellation for Mortality Reporting System", "object": "ct_mrs", "class": [ "constellation" ], "fields": [], "table": false, "tojson": false }, { "name": "ct_mrs_test", "title": "Constellation for Mortality Reporting System Test", "object": "ct_mrs_test", "class": [ "constellation" ], "fields": [], "table": false, "tojson": false }, { "name": "dm_mrs_age", "title": "Star Definition for Mortality Reporting System by Age", "object": "dm_mrs_age", "class": [ "dimensional_model" ], "fields": [], "table": true, "tojson": false }, { "name": "dm_mrs_cause", "title": "Star Definition for Mortality Reporting System by Cause", "object": "dm_mrs_cause", "class": [ "dimensional_model" ], "fields": [], "table": true, "tojson": false }, { "name": "ft_datagov_uk", "title": "Modelling the long-term health impacts of air pollution in London", "object": "ft_datagov_uk", "class": [ "spec_tbl_df", "tbl_df", "tbl", "data.frame" ], "fields": [ "Pollutant", "Place", "Scenario", "Year", "Disease", "AgeGroup", "Incidence" ], "rows": 144031, "table": true, "tojson": true }, { "name": "ft_london_boroughs", "title": "London Boroughs", "object": "ft_london_boroughs", "class": [ "spec_tbl_df", "tbl_df", "tbl", "data.frame" ], "fields": [ "name", "code", "sub_region", "zone", "zone_code" ], "rows": 33, "table": true, "tojson": true }, { "name": "ft_usa_city_county", "title": "USA City and County", "object": "ft_usa_city_county", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "city", "state", "county" ], "rows": 117, "table": true, "tojson": true }, { "name": "ft_usa_states", "title": "USA States", "object": "ft_usa_states", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "state", "state_name" ], "rows": 52, "table": true, "tojson": true }, { "name": "mrs", "title": "Mortality Reporting System", "object": "mrs", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Pneumonia and Influenza Deaths", "All Deaths", "<1 year (all cause deaths)", "1-24 years (all cause deaths)", "25-44 years", "45-64 years (all cause deaths)", "65+ years (all cause deaths)" ], "rows": 1342, "table": true, "tojson": true }, { "name": "mrs_age", "title": "Mortality Reporting System by Age", "object": "mrs_age", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Reception Year", "Reception Week", "Reception Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Age Range", "Deaths" ], "rows": 4711, "table": true, "tojson": true }, { "name": "mrs_age_test", "title": "Mortality Reporting System by Age Test", "object": "mrs_age_test", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Reception Year", "Reception Week", "Reception Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Age Range", "Deaths" ], "rows": 24, "table": true, "tojson": true }, { "name": "mrs_age_w_test", "title": "Mortality Reporting System by Age for Week Test", "object": "mrs_age_w_test", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Reception Year", "Reception Week", "Reception Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Age Range", "Deaths" ], "rows": 18, "table": true, "tojson": true }, { "name": "mrs_age_w10", "title": "Mortality Reporting System by Age for Week 10", "object": "mrs_age_w10", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Reception Year", "Reception Week", "Reception Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Age Range", "Deaths" ], "rows": 719, "table": true, "tojson": true }, { "name": "mrs_age_w11", "title": "Mortality Reporting System by Age for Week 11", "object": "mrs_age_w11", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Reception Year", "Reception Week", "Reception Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Age Range", "Deaths" ], "rows": 685, "table": true, "tojson": true }, { "name": "mrs_cause", "title": "Mortality Reporting System by Cause", "object": "mrs_cause", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Reception Year", "Reception Week", "Reception Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Pneumonia and Influenza Deaths", "All Deaths", "Other Deaths" ], "rows": 1026, "table": true, "tojson": true }, { "name": "mrs_cause_test", "title": "Mortality Reporting System by Cause Test", "object": "mrs_cause_test", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Reception Year", "Reception Week", "Reception Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Pneumonia and Influenza Deaths", "All Deaths", "Other Deaths" ], "rows": 6, "table": true, "tojson": true }, { "name": "mrs_cause_w_test", "title": "Mortality Reporting System by Cause for Week Test", "object": "mrs_cause_w_test", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Reception Year", "Reception Week", "Reception Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Pneumonia and Influenza Deaths", "All Deaths", "Other Deaths" ], "rows": 6, "table": true, "tojson": true }, { "name": "mrs_cause_w10", "title": "Mortality Reporting System by Cause for Week 10", "object": "mrs_cause_w10", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Reception Year", "Reception Week", "Reception Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Pneumonia and Influenza Deaths", "All Deaths", "Other Deaths" ], "rows": 167, "table": true, "tojson": true }, { "name": "mrs_cause_w11", "title": "Mortality Reporting System by Cause for Week 11", "object": "mrs_cause_w11", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Reception Year", "Reception Week", "Reception Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Pneumonia and Influenza Deaths", "All Deaths", "Other Deaths" ], "rows": 158, "table": true, "tojson": true }, { "name": "ms_mrs", "title": "Multistar for Mortality Reporting System", "object": "ms_mrs", "class": [ "multistar" ], "fields": [], "table": false, "tojson": false }, { "name": "ms_mrs_test", "title": "Multistar for Mortality Reporting System Test", "object": "ms_mrs_test", "class": [ "multistar" ], "fields": [], "table": false, "tojson": false }, { "name": "st_mrs_age", "title": "Star Schema for Mortality Reporting System by Age", "object": "st_mrs_age", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "st_mrs_age_test", "title": "Star Schema for Mortality Reporting System by Age Test", "object": "st_mrs_age_test", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "st_mrs_age_w_test", "title": "Star Schema for Mortality Reporting System by Age for Week Test", "object": "st_mrs_age_w_test", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "st_mrs_age_w10", "title": "Star Schema for Mortality Reporting System by Age for Week 10", "object": "st_mrs_age_w10", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "st_mrs_age_w11", "title": "Star Schema for Mortality Reporting System by Age for Week 11", "object": "st_mrs_age_w11", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "st_mrs_cause", "title": "Star Schema for Mortality Reporting System by Cause", "object": "st_mrs_cause", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "st_mrs_cause_test", "title": "Star Schema for Mortality Reporting System by Cause Test", "object": "st_mrs_cause_test", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "st_mrs_cause_w_test", "title": "Star Schema for Mortality Reporting System by Cause for Week Test", "object": "st_mrs_cause_w_test", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "st_mrs_cause_w10", "title": "Star Schema for Mortality Reporting System by Cause for Week 10", "object": "st_mrs_cause_w10", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "st_mrs_cause_w11", "title": "Star Schema for Mortality Reporting System by Cause for Week 11", "object": "st_mrs_cause_w11", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "updates_st_mrs_age", "title": "Updates for the Star Schema for Mortality Reporting System by Age", "object": "updates_st_mrs_age", "class": [ "record_update_set" ], "fields": [], "table": true, "tojson": false }, { "name": "updates_st_mrs_age_test", "title": "Updates for the Star Schema for Mortality Reporting System by Age Test", "object": "updates_st_mrs_age_test", "class": [ "record_update_set" ], "fields": [], "table": true, "tojson": false } ], "_help": [ { "page": "character_dimensions", "title": "Transform dimension numeric attributes to character", "concept": [ "star schema and constellation definition functions" ], "topics": [ "character_dimensions", "character_dimensions.star_schema" ] }, { "page": "constellation", "title": "'constellation' S3 class", "concept": [ "star schema and constellation definition functions" ], "topics": [ "constellation" ] }, { "page": "constellation_as_multistar", "title": "Export a constellation as a 'multistar'", "concept": [ "results export functions" ], "topics": [ "constellation_as_multistar", "constellation_as_multistar.constellation" ] }, { "page": "constellation_as_tibble_list", "title": "Export a constellation as a 'tibble' list", "concept": [ "results export functions" ], "topics": [ "constellation_as_tibble_list", "constellation_as_tibble_list.constellation" ] }, { "page": "ct_mrs", "title": "Constellation for Mortality Reporting System", "topics": [ "ct_mrs" ] }, { "page": "ct_mrs_test", "title": "Constellation for Mortality Reporting System Test", "topics": [ "ct_mrs_test" ] }, { "page": "define_dimension", "title": "Define dimensions in a 'dimensional_model' object", "concept": [ "star definition functions" ], "topics": [ "define_dimension", "define_dimension.dimensional_model" ] }, { "page": "define_fact", "title": "Define facts in a 'dimensional_model' object", "concept": [ "star definition functions" ], "topics": [ "define_fact", "define_fact.dimensional_model" ] }, { "page": "dimensional_model", "title": "'dimensional_model' S3 class", "concept": [ "star definition functions" ], "topics": [ "dimensional_model" ] }, { "page": "dimensional_query", "title": "'dimensional_query' S3 class", "concept": [ "query functions" ], "topics": [ "dimensional_query" ] }, { "page": "dm_mrs_age", "title": "Star Definition for Mortality Reporting System by Age", "topics": [ "dm_mrs_age" ] }, { "page": "dm_mrs_cause", "title": "Star Definition for Mortality Reporting System by Cause", "topics": [ "dm_mrs_cause" ] }, { "page": "enrich_dimension_export", "title": "Export selected attributes of a dimension", "concept": [ "dimension enrichment functions" ], "topics": [ "enrich_dimension_export", "enrich_dimension_export.star_schema" ] }, { "page": "enrich_dimension_import", "title": "Import 'tibble' to enrich a dimension", "concept": [ "dimension enrichment functions" ], "topics": [ "enrich_dimension_import", "enrich_dimension_import.star_schema" ] }, { "page": "enrich_dimension_import_test", "title": "Import 'tibble' to test to enrich a dimension", "concept": [ "dimension enrichment functions" ], "topics": [ "enrich_dimension_import_test", "enrich_dimension_import_test.star_schema" ] }, { "page": "filter_dimension", "title": "Filter dimension", "concept": [ "query functions" ], "topics": [ "filter_dimension", "filter_dimension.dimensional_query" ] }, { "page": "filter_fact_rows", "title": "Filter fact rows", "concept": [ "incremental refresh functions" ], "topics": [ "filter_fact_rows", "filter_fact_rows.star_schema" ] }, { "page": "ft_datagov_uk", "title": "Modelling the long-term health impacts of air pollution in London", "topics": [ "ft_datagov_uk" ] }, { "page": "ft_london_boroughs", "title": "London Boroughs", "topics": [ "ft_london_boroughs" ] }, { "page": "ft_usa_city_county", "title": "USA City and County", "topics": [ "ft_usa_city_county" ] }, { "page": "ft_usa_states", "title": "USA States", "topics": [ "ft_usa_states" ] }, { "page": "get_conformed_dimension", "title": "Get conformed dimension", "concept": [ "data cleaning functions" ], "topics": [ "get_conformed_dimension", "get_conformed_dimension.constellation" ] }, { "page": "get_conformed_dimension_names", "title": "Get conformed dimension names", "concept": [ "data cleaning functions" ], "topics": [ "get_conformed_dimension_names", "get_conformed_dimension_names.constellation" ] }, { "page": "get_dimension", "title": "Get dimension", "concept": [ "data cleaning functions" ], "topics": [ "get_dimension", "get_dimension.star_schema" ] }, { "page": "get_dimension_attribute_names", "title": "Get dimension attribute names", "concept": [ "rename functions" ], "topics": [ "get_dimension_attribute_names", "get_dimension_attribute_names.star_schema" ] }, { "page": "get_dimension_names", "title": "Get dimension names", "concept": [ "data cleaning functions" ], "topics": [ "get_dimension_names", "get_dimension_names.star_schema" ] }, { "page": "get_measure_names", "title": "Get measure names", "concept": [ "rename functions" ], "topics": [ "get_measure_names", "get_measure_names.star_schema" ] }, { "page": "get_star_schema", "title": "Get star schema", "concept": [ "incremental refresh functions" ], "topics": [ "get_star_schema", "get_star_schema.constellation" ] }, { "page": "get_star_schema_names", "title": "Get star schema names", "concept": [ "incremental refresh functions" ], "topics": [ "get_star_schema_names", "get_star_schema_names.constellation" ] }, { "page": "incremental_refresh_constellation", "title": "Incrementally refresh a constellation with a star schema", "concept": [ "incremental refresh functions" ], "topics": [ "incremental_refresh_constellation", "incremental_refresh_constellation.constellation" ] }, { "page": "match_records", "title": "Make a dimension record equal to another", "concept": [ "data cleaning functions" ], "topics": [ "match_records", "match_records.record_update_set" ] }, { "page": "modify_conformed_dimension_records", "title": "Apply dimension record update operations to conformed dimensions", "concept": [ "data cleaning functions" ], "topics": [ "modify_conformed_dimension_records", "modify_conformed_dimension_records.constellation" ] }, { "page": "modify_dimension_records", "title": "Apply dimension record update operations", "concept": [ "data cleaning functions" ], "topics": [ "modify_dimension_records", "modify_dimension_records.star_schema" ] }, { "page": "mrs", "title": "Mortality Reporting System", "topics": [ "mrs" ] }, { "page": "mrs_age", "title": "Mortality Reporting System by Age", "topics": [ "mrs_age" ] }, { "page": "mrs_age_test", "title": "Mortality Reporting System by Age Test", "topics": [ "mrs_age_test" ] }, { "page": "mrs_age_w_test", "title": "Mortality Reporting System by Age for Week Test", "topics": [ "mrs_age_w_test" ] }, { "page": "mrs_age_w10", "title": "Mortality Reporting System by Age for Week 10", "topics": [ "mrs_age_w10" ] }, { "page": "mrs_age_w11", "title": "Mortality Reporting System by Age for Week 11", "topics": [ "mrs_age_w11" ] }, { "page": "mrs_cause", "title": "Mortality Reporting System by Cause", "topics": [ "mrs_cause" ] }, { "page": "mrs_cause_test", "title": "Mortality Reporting System by Cause Test", "topics": [ "mrs_cause_test" ] }, { "page": "mrs_cause_w_test", "title": "Mortality Reporting System by Cause for Week Test", "topics": [ "mrs_cause_w_test" ] }, { "page": "mrs_cause_w10", "title": "Mortality Reporting System by Cause for Week 10", "topics": [ "mrs_cause_w10" ] }, { "page": "mrs_cause_w11", "title": "Mortality Reporting System by Cause for Week 11", "topics": [ "mrs_cause_w11" ] }, { "page": "ms_mrs", "title": "Multistar for Mortality Reporting System", "topics": [ "ms_mrs" ] }, { "page": "ms_mrs_test", "title": "Multistar for Mortality Reporting System Test", "topics": [ "ms_mrs_test" ] }, { "page": "multistar_as_flat_table", "title": "Export a 'multistar' as a flat table", "concept": [ "results export functions" ], "topics": [ "multistar_as_flat_table", "multistar_as_flat_table.multistar" ] }, { "page": "purge_dimensions_constellation", "title": "Purge dimensions in a constellation", "concept": [ "incremental refresh functions" ], "topics": [ "purge_dimensions_constellation", "purge_dimensions_constellation.constellation" ] }, { "page": "purge_dimensions_star_schema", "title": "Purge dimensions", "concept": [ "incremental refresh functions" ], "topics": [ "purge_dimensions_star_schema", "purge_dimensions_star_schema.star_schema" ] }, { "page": "record_update_set", "title": "'record_update_set' S3 class", "concept": [ "data cleaning functions" ], "topics": [ "record_update_set" ] }, { "page": "rename_dimension", "title": "Rename dimension", "concept": [ "rename functions" ], "topics": [ "rename_dimension", "rename_dimension.star_schema" ] }, { "page": "rename_dimension_attributes", "title": "Rename dimension attributes", "concept": [ "rename functions" ], "topics": [ "rename_dimension_attributes", "rename_dimension_attributes.star_schema" ] }, { "page": "rename_fact", "title": "Rename fact", "concept": [ "rename functions" ], "topics": [ "rename_fact", "rename_fact.star_schema" ] }, { "page": "rename_measures", "title": "Rename measures", "concept": [ "rename functions" ], "topics": [ "rename_measures", "rename_measures.star_schema" ] }, { "page": "role_playing_dimension", "title": "Define a role playing dimension in a 'star_schema' object", "concept": [ "star schema and constellation definition functions" ], "topics": [ "role_playing_dimension", "role_playing_dimension.star_schema" ] }, { "page": "run_query", "title": "Run query", "concept": [ "query functions" ], "topics": [ "run_query", "run_query.dimensional_query" ] }, { "page": "select_dimension", "title": "Select dimension", "concept": [ "query functions" ], "topics": [ "select_dimension", "select_dimension.dimensional_query" ] }, { "page": "select_fact", "title": "Select fact", "concept": [ "query functions" ], "topics": [ "select_fact", "select_fact.dimensional_query" ] }, { "page": "snake_case", "title": "Transform names according to the snake case style", "concept": [ "star schema and constellation definition functions" ], "topics": [ "snake_case", "snake_case.star_schema" ] }, { "page": "st_mrs_age", "title": "Star Schema for Mortality Reporting System by Age", "topics": [ "st_mrs_age" ] }, { "page": "st_mrs_age_test", "title": "Star Schema for Mortality Reporting System by Age Test", "topics": [ "st_mrs_age_test" ] }, { "page": "st_mrs_age_w_test", "title": "Star Schema for Mortality Reporting System by Age for Week Test", "topics": [ "st_mrs_age_w_test" ] }, { "page": "st_mrs_age_w10", "title": "Star Schema for Mortality Reporting System by Age for Week 10", "topics": [ "st_mrs_age_w10" ] }, { "page": "st_mrs_age_w11", "title": "Star Schema for Mortality Reporting System by Age for Week 11", "topics": [ "st_mrs_age_w11" ] }, { "page": "st_mrs_cause", "title": "Star Schema for Mortality Reporting System by Cause", "topics": [ "st_mrs_cause" ] }, { "page": "st_mrs_cause_test", "title": "Star Schema for Mortality Reporting System by Cause Test", "topics": [ "st_mrs_cause_test" ] }, { "page": "st_mrs_cause_w_test", "title": "Star Schema for Mortality Reporting System by Cause for Week Test", "topics": [ "st_mrs_cause_w_test" ] }, { "page": "st_mrs_cause_w10", "title": "Star Schema for Mortality Reporting System by Cause for Week 10", "topics": [ "st_mrs_cause_w10" ] }, { "page": "st_mrs_cause_w11", "title": "Star Schema for Mortality Reporting System by Cause for Week 11", "topics": [ "st_mrs_cause_w11" ] }, { "page": "star_schema", "title": "'star_schema' S3 class", "concept": [ "star schema and constellation definition functions" ], "topics": [ "star_schema" ] }, { "page": "star_schema_as_flat_table", "title": "Export a star schema as a flat table", "concept": [ "results export functions" ], "topics": [ "star_schema_as_flat_table", "star_schema_as_flat_table.star_schema" ] }, { "page": "star_schema_as_multistar", "title": "Export a star schema as a 'multistar'", "concept": [ "results export functions" ], "topics": [ "star_schema_as_multistar", "star_schema_as_multistar.star_schema" ] }, { "page": "star_schema_as_tibble_list", "title": "Export a star schema as a 'tibble' list", "concept": [ "results export functions" ], "topics": [ "star_schema_as_tibble_list", "star_schema_as_tibble_list.star_schema" ] }, { "page": "starschemar", "title": "Obtaining Star Schemas from Flat Tables", "topics": [ "starschemar-package", "starschemar", "_PACKAGE" ] }, { "page": "update_record", "title": "Update a dimension record with a set of values", "concept": [ "data cleaning functions" ], "topics": [ "update_record", "update_record.record_update_set" ] }, { "page": "update_selection", "title": "Update dimension records with a set of values", "concept": [ "data cleaning functions" ], "topics": [ "update_selection", "update_selection.record_update_set" ] }, { "page": "update_selection_general", "title": "Update dimension records with a set of values in given columns", "concept": [ "data cleaning functions" ], "topics": [ "update_selection_general", "update_selection_general.record_update_set" ] }, { "page": "updates_st_mrs_age", "title": "Updates for the Star Schema for Mortality Reporting System by Age", "topics": [ "updates_st_mrs_age" ] }, { "page": "updates_st_mrs_age_test", "title": "Updates for the Star Schema for Mortality Reporting System by Age Test", "topics": [ "updates_st_mrs_age_test" ] } ], "_pkglogo": "https://github.com/josesamos/starschemar/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/josesamos/starschemar/raw/HEAD/README.md", "_rundeps": [ "cli", "cpp11", "dplyr", "generics", "glue", "lifecycle", "magrittr", "pillar", "pkgconfig", "purrr", "R6", "rlang", "snakecase", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "utf8", "vctrs", "withr" ], "_vignettes": [ { "source": "v10_transformation_op.Rmd", "filename": "v10_transformation_op.html", "title": "starschemar Transformation Operations", "author": "Jose Samos (jsamos@ugr.es)", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Dimensional modelling", "Star schema and constellation definition", "Star schema definition", "Star schema rename", "Constellation definition", "Cleaning and conforming data", "Obtaining components", "Star schema", "Constellation", "Definition of updates", "Updates application", "Dimension enrichment", "Incremental refresh", "Exporting results", "multistar", "Query functions", "Conclusions" ], "created": "2024-01-08 11:13:27", "modified": "2024-01-08 11:13:27", "commits": 1 }, { "source": "starschemar.Rmd", "filename": "starschemar.html", "title": "starschemar: Obtaining Star Schemas from Flat Tables", "author": "Jose Samos (jsamos@ugr.es)", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Dimensional modelling and star schemas", "Dimensional modelling", "Dimensions and dimension attributes", "Facts and measures", "Star schemas", "Dimension tables", "Surrogate keys", "Special dimensions", "Fact table", "Primary key", "Grain", "Multiple fact tables", "Conformed dimensions", "Additional operations", "Cleaning and conforming data", "Dimension enrichment", "Incremental refresh", "An illustrative example", "Starting data sets", "Dimensional modelling data according to age range", "Dimensional modelling data according to cause", "Star schema definition and transformation: Constellations", "Star schema definition for data according to age range", "Star schema definition for data according to cause", "Star schema transformation, cleaning and conforming data", "Star schema rename", "Definition of updates", "Updates in the where dimension", "Updates in the when dimension", "Updates in the who dimension", "Updates application", "Enrich the who dimension", "Enrich the where dimension", "Constellation definition", "Refresh operations for data according to age range", "Refresh operations for data according to cause", "Filter and purge operations", "Exporting results", "Star schema", "Constellation", "multistar", "Query functions", "Conclusions", "References" ], "created": "2020-07-24 18:18:25", "modified": "2024-01-08 11:13:27", "commits": 23 } ], "_score": 4.944482672150169, "_indexed": true, "_nocasepkg": "starschemar", "_universes": [ "josesamos" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.2.5.9000", "date": "2026-06-09T09:17:43.000Z", "distro": "noble", "commit": "5ed318f0a05cec36e5dbecb8a182185b6465c87d", "fileid": "4d913c909d078d49e9a9b98c46deb6bdf3a1b3b4c34556cc7e1e86472c409b37", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27196059437" }, { "r": "4.6.0", "os": "linux", "version": "1.2.5.9000", "date": "2026-06-09T09:18:22.000Z", "distro": "noble", "commit": "5ed318f0a05cec36e5dbecb8a182185b6465c87d", "fileid": "5b08bef7f48481b736c6679fbdc5c8530984d3f01fb1fe8115269eadbed9732a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27196059437" }, { "r": "4.5.3", "os": "mac", "version": "1.2.5.9000", "date": "2026-06-09T09:17:33.000Z", "commit": "5ed318f0a05cec36e5dbecb8a182185b6465c87d", "fileid": "0a7ea8d110835235919b36163eea70da00a188f6de54290656726f63cb504aa9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27196059437" }, { "r": "4.6.0", "os": "mac", "version": "1.2.5.9000", "date": "2026-06-09T09:16:56.000Z", "commit": "5ed318f0a05cec36e5dbecb8a182185b6465c87d", "fileid": "21a3168ef7c8ffa89e32f2aa2ba676364c0eb733b9f4669ba85b567f961f243d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27196059437" }, { "r": "4.6.0", "os": "wasm", "version": "1.2.5.9000", "date": "2026-06-09T09:17:38.000Z", "commit": "5ed318f0a05cec36e5dbecb8a182185b6465c87d", "fileid": "4b8b8de23405193f86025930583c5697644cea7f53e50f5173fcee0455f4a468", "status": "success", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27196059437" }, { "r": "4.7.0", "os": "win", "version": "1.2.5.9000", "date": "2026-06-09T09:17:04.000Z", "commit": "5ed318f0a05cec36e5dbecb8a182185b6465c87d", "fileid": "cc38217c216465b2b7035b5b8ab3cd8e41451614c4c5e45cf70b541cbe083b55", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27196059437" }, { "r": "4.5.3", "os": "win", "version": "1.2.5.9000", "date": "2026-06-09T09:16:55.000Z", "commit": "5ed318f0a05cec36e5dbecb8a182185b6465c87d", "fileid": "aead0957119ce22c331b5a0ffefd44ef5927557eb10ed402c0fa56a6314fe663", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27196059437" }, { "r": "4.6.0", "os": "win", "version": "1.2.5.9000", "date": "2026-06-09T09:17:01.000Z", "commit": "5ed318f0a05cec36e5dbecb8a182185b6465c87d", "fileid": "70b4394cff0855795b3bf4ea564b116f4eda5273780855e195e2ecd21b542e4f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27196059437" } ] }