{ "_id": "6a1f134cb401979e7341df3c", "Package": "rolap", "Title": "Obtaining Star Databases from Flat Tables", "Version": "2.5.2.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 ROLAP (Relational On-Line\nAnalytical Processing) star database. The main objective of the\npackage is to allow the definition of these transformations\neasily. The implementation of the multidimensional database\nobtained can be exported to work with multidimensional analysis\ntools on spreadsheets or relational databases.", "License": "MIT + file LICENSE", "URL": "https://josesamos.github.io/rolap/,\nhttps://github.com/josesamos/rolap", "BugReports": "https://github.com/josesamos/rolap/issues", "VignetteBuilder": "knitr", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Language": "en-GB", "LazyData": "true", "LazyDataCompression": "xz", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "Config/pak/sysreqs": "libabsl-dev cmake libgdal-dev gdal-bin libgeos-dev\nmake default-jdk libicu-dev libssl-dev libproj-dev\nlibsqlite3-dev libudunits2-dev libx11-dev", "Repository": "https://josesamos.r-universe.dev", "Date/Publication": "2025-05-22 06:10:00 UTC", "RemoteUrl": "https://github.com/josesamos/rolap", "RemoteRef": "HEAD", "RemoteSha": "065b0e5904d15e6b393a96cc642b11a7da188b01", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-17 07:24:44 UTC", "User": "root" }, "Author": "Jose Samos [aut, cre] (ORCID: ),\nUniversidad de Granada [cph]", "Maintainer": "Jose Samos ", "MD5sum": "49316c2af21c7876f103fff51b65dcd6", "_user": "josesamos", "_type": "src", "_file": "rolap_2.5.2.9000.tar.gz", "_fileid": "6b025d1179e544d6a08a30316eb16d3f9c08d332dfa74d52df082f93205af3d5", "_filesize": 1917048, "_sha256": "6b025d1179e544d6a08a30316eb16d3f9c08d332dfa74d52df082f93205af3d5", "_created": "2026-05-17T07:24:44.000Z", "_published": "2026-06-02T17:30:52.515Z", "_distro": "noble", "_jobs": [ { "job": 79132241516, "time": 245, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7040426777" }, { "job": 79132241724, "time": 227, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7040424991" }, { "job": 79132241801, "time": 187, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7040420559" }, { "job": 79132241615, "time": 133, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7040414522" }, { "job": 79132241073, "time": 297, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7040399669" }, { "job": 79132240782, "time": 154, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7365154660" }, { "job": 79132241633, "time": 260, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7040428401" }, { "job": 79132241906, "time": 196, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7040421445" }, { "job": 79132241612, "time": 188, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7040420634" } ], "_buildurl": "https://github.com/r-universe/josesamos/actions/runs/25984489920", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/josesamos/rolap", "_commit": { "id": "065b0e5904d15e6b393a96cc642b11a7da188b01", "author": "Jose Samos ", "committer": "Jose Samos ", "message": "Increment version number to 2.5.2.9000\n", "time": 1747894200 }, "_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": "dm", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "sf", "role": "Imports" }, { "package": "snakecase", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "tidyselect", "role": "Imports" }, { "package": "tools", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "when", "role": "Imports" }, { "package": "xlsx", "role": "Imports" }, { "package": "DBI", "role": "Suggests" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "DiagrammeR", "role": "Suggests" }, { "package": "DiagrammeRsvg", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "lubridate", "role": "Suggests" }, { "package": "magrittr", "role": "Suggests" }, { "package": "maps", "role": "Suggests" }, { "package": "pander", "role": "Suggests" }, { "package": "pivottabler", "role": "Suggests" }, { "package": "RMariaDB", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "stringr", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "josesamos", "_selfowned": true, "_usedby": 1, "_updates": [ { "week": "2025-21", "n": 4 } ], "_tags": [ { "name": "v2.5.2", "date": "2025-05-21" } ], "_stars": 7, "_contributors": [ { "user": "josesamos", "count": 172, "uuid": 13182483 } ], "_userbio": { "uuid": 13182483, "type": "user", "name": "JOSE SAMOS JIMENEZ", "description": "R / GIS / Geocomputation / DW / OLAP / Multidimensional Systems" }, "_downloads": { "count": 625, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/rolap" }, "_devurl": "https://github.com/josesamos/rolap", "_pkgdown": "https://josesamos.github.io/rolap/", "_searchresults": 25, "_topics": [ "openjdk" ], "_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/rolap.html", "manual.pdf" ], "_homeurl": "https://github.com/josesamos/rolap", "_realowner": "josesamos", "_cranurl": true, "_releases": [ { "version": "2.0.0", "date": "2023-08-08" }, { "version": "2.1.0", "date": "2023-08-13" }, { "version": "2.2.0", "date": "2023-09-15" }, { "version": "2.3.0", "date": "2023-10-16" }, { "version": "2.4.0", "date": "2023-11-14" }, { "version": "2.5.0", "date": "2023-12-11" }, { "version": "2.5.1", "date": "2024-01-10" }, { "version": "2.5.2", "date": "2025-05-27" } ], "_exports": [ "add_custom_column", "as_csv_files", "as_dm_class", "as_geolayer", "as_GeoPackage", "as_multistar", "as_rdb", "as_single_tibble_list", "as_star_database", "as_tibble_list", "as_xlsx_file", "cancel_deployment", "check_geoattribute_geometry", "check_lookup_table", "constellation", "coordinates_to_point", "define_dimension", "define_facts", "define_geoattribute", "deploy", "dimension_schema", "draw_tables", "fact_schema", "filter_dimension", "flat_table", "get_attribute_names", "get_deployment_names", "get_dimension_names", "get_dimension_table", "get_existing_fact_instances", "get_fact_names", "get_geoattribute_geometries", "get_geoattributes", "get_layer", "get_layer_geometry", "get_lookup_tables", "get_measure_names", "get_new_dimension_instances", "get_pk_attribute_names", "get_point_geometry", "get_role_playing_dimension_names", "get_similar_attribute_values", "get_similar_attribute_values_individually", "get_star_database", "get_star_schema", "get_table", "get_table_names", "get_transformation_code", "get_transformation_file", "get_unique_attribute_values", "get_unknown_value_defined", "get_unknown_values", "get_variable_description", "get_variables", "group_dimension_instances", "incremental_refresh", "join_lookup_table", "load_star_database", "lookup_table", "multiple_value_key", "read_flat_table_file", "read_flat_table_folder", "remove_instances_without_measures", "replace_attribute_values", "replace_empty_values", "replace_string", "replace_unknown_values", "role_playing_dimension", "run_query", "select_attributes", "select_dimension", "select_fact", "select_instances", "select_instances_by_comparison", "select_measures", "separate_measures", "set_attribute_names", "set_layer", "set_measure_names", "set_variables", "snake_case", "star_database", "star_query", "star_schema", "summarize_layer", "transform_attribute_format", "transform_from_values", "transform_to_attribute", "transform_to_measure", "transform_to_values", "update_according_to" ], "_datasets": [ { "name": "ft", "title": "Mortality Reporting System", "object": "ft", "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": 20, "table": true, "tojson": true }, { "name": "ft_age", "title": "Mortality Reporting System by Age Group", "object": "ft_age", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Age", "All Deaths" ], "rows": 100, "table": true, "tojson": true }, { "name": "ft_age_rpd", "title": "Mortality Reporting System by Age", "object": "ft_age_rpd", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Arrival Year", "Arrival Week", "Arrival Date", "Data Availability Year", "Data Availability Week", "Data Availability Date", "Year", "WEEK", "Week Ending Date", "REGION", "State", "City", "Age Range", "Deaths" ], "rows": 12, "table": true, "tojson": true }, { "name": "ft_cause_rpd", "title": "Mortality Reporting System by Cause", "object": "ft_cause_rpd", "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": 10, "table": true, "tojson": true }, { "name": "ft_num", "title": "Mortality Reporting System with numerical measures", "object": "ft_num", "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": 20, "table": true, "tojson": true }, { "name": "mrs_age_schema", "title": "Star schema for Mortality Reporting System by Age", "object": "mrs_age_schema", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "mrs_age_schema_rpd", "title": "Star schema for Mortality Reporting System by Age with additional dates", "object": "mrs_age_schema_rpd", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "mrs_cause_schema", "title": "Star schema for Mortality Reporting System by Cause", "object": "mrs_cause_schema", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "mrs_cause_schema_rpd", "title": "Star schema for Mortality Reporting System by Cause with additional dates", "object": "mrs_cause_schema_rpd", "class": [ "star_schema" ], "fields": [], "table": false, "tojson": false }, { "name": "mrs_db", "title": "Constellation generated from MRS file", "object": "mrs_db", "class": [ "star_database" ], "fields": [], "table": false, "tojson": false }, { "name": "mrs_db_geo", "title": "Constellation generated from MRS file through a query and with geographic information", "object": "mrs_db_geo", "class": [ "star_database" ], "fields": [], "table": false, "tojson": false }, { "name": "mrs_ft", "title": "Flat table generated from MRS file", "object": "mrs_ft", "class": [ "flat_table" ], "fields": [], "table": false, "tojson": false }, { "name": "mrs_ft_new", "title": "Flat table generated from MRS file", "object": "mrs_ft_new", "class": [ "flat_table" ], "fields": [], "table": false, "tojson": false }, { "name": "us_census_state", "title": "Census of US States, by sex and age", "object": "us_census_state", "class": [ "spec_tbl_df", "tbl_df", "tbl", "data.frame" ], "fields": [ "year", "GEOID", "REGION", "REGION_name", "DIVISION", "DIVISION_name", "GEOID_last", "STUSPS", "NAME", "report", "sex", "age", "group", "estimate", "margin_of_error" ], "rows": 133824, "table": true, "tojson": true }, { "name": "us_layer_state", "title": "Geographic layer of US States", "object": "us_layer_state", "class": [ "sf", "data.frame" ], "fields": [ "FUNCSTAT", "GEOID", "GEOID_Data", "LSAD", "MTFCC", "STATENS", "STATEFP", "STUSPS", "NAME", "DIVISION", "DIVISION_Name", "REGION", "REGION_Name", "NATION", "Shape_Length", "Shape_Area", "AWATER", "ALAND", "INTPTLAT", "INTPTLON", "geom" ], "rows": 52, "table": false, "tojson": true } ], "_help": [ { "page": "add_custom_column", "title": "Add custom column", "concept": [ "flat table transformation functions" ], "topics": [ "add_custom_column", "add_custom_column.flat_table" ] }, { "page": "as_csv_files", "title": "Generate csv files with fact and dimension tables", "concept": [ "star database exportation functions" ], "topics": [ "as_csv_files", "as_csv_files.star_database" ] }, { "page": "as_dm_class", "title": "Generate a 'dm' class with fact and dimension tables", "concept": [ "star database exportation functions" ], "topics": [ "as_dm_class", "as_dm_class.star_database" ] }, { "page": "as_geolayer", "title": "Get a 'geolayer' object", "concept": [ "query functions" ], "topics": [ "as_geolayer", "as_geolayer.star_database" ] }, { "page": "as_GeoPackage", "title": "Save as 'GeoPackage'", "concept": [ "query functions" ], "topics": [ "as_GeoPackage", "as_GeoPackage.geolayer" ] }, { "page": "as_multistar", "title": "Generate a 'geomultistar::multistar' object", "concept": [ "star database exportation functions" ], "topics": [ "as_multistar", "as_multistar.star_database" ] }, { "page": "as_rdb", "title": "Generate tables in a relational database", "concept": [ "star database exportation functions" ], "topics": [ "as_rdb", "as_rdb.star_database" ] }, { "page": "as_single_tibble_list", "title": "Generate a list of tibbles of flat tables", "concept": [ "star database exportation functions" ], "topics": [ "as_single_tibble_list", "as_single_tibble_list.star_database" ] }, { "page": "as_star_database", "title": "Get a star database from a flat table", "concept": [ "flat table definition functions" ], "topics": [ "as_star_database", "as_star_database.flat_table" ] }, { "page": "as_tibble_list", "title": "Generate a list of tibbles with fact and dimension tables", "concept": [ "star database exportation functions" ], "topics": [ "as_tibble_list", "as_tibble_list.star_database" ] }, { "page": "as_xlsx_file", "title": "Generate a xlsx file with fact and dimension tables", "concept": [ "star database exportation functions" ], "topics": [ "as_xlsx_file", "as_xlsx_file.star_database" ] }, { "page": "cancel_deployment", "title": "Cancel deployment", "concept": [ "star database deployment functions" ], "topics": [ "cancel_deployment", "cancel_deployment.star_database" ] }, { "page": "check_geoattribute_geometry", "title": "Check a 'geoattribute' geometry instances.", "concept": [ "star database geographic attributes" ], "topics": [ "check_geoattribute_geometry", "check_geoattribute_geometry.star_database" ] }, { "page": "check_lookup_table", "title": "Check the result of joining a flat table with a lookup table", "concept": [ "flat table join functions" ], "topics": [ "check_lookup_table", "check_lookup_table.flat_table" ] }, { "page": "constellation", "title": "Create constellation", "concept": [ "star database and constellation definition functions" ], "topics": [ "constellation" ] }, { "page": "coordinates_to_point", "title": "Transform coordinates to point geometry", "concept": [ "level definition functions" ], "topics": [ "coordinates_to_point" ] }, { "page": "define_dimension", "title": "Define dimension in a 'star_schema' object.", "concept": [ "star schema definition functions" ], "topics": [ "define_dimension", "define_dimension.star_schema" ] }, { "page": "define_facts", "title": "Define facts in a 'star_schema' object.", "concept": [ "star schema definition functions" ], "topics": [ "define_facts", "define_facts.star_schema" ] }, { "page": "define_geoattribute", "title": "Define 'geoattribute' of a dimension", "concept": [ "star database geographic attributes" ], "topics": [ "define_geoattribute", "define_geoattribute.star_database" ] }, { "page": "deploy", "title": "Deploy a star database in a relational database", "concept": [ "star database deployment functions" ], "topics": [ "deploy", "deploy.star_database" ] }, { "page": "dimension_schema", "title": "'dimension_schema' S3 class", "concept": [ "star schema definition functions" ], "topics": [ "dimension_schema" ] }, { "page": "draw_tables", "title": "Draw tables", "concept": [ "star database exportation functions" ], "topics": [ "draw_tables", "draw_tables.star_database" ] }, { "page": "fact_schema", "title": "'fact_schema' S3 class", "concept": [ "star schema definition functions" ], "topics": [ "fact_schema" ] }, { "page": "filter_dimension", "title": "Filter dimension", "concept": [ "query functions" ], "topics": [ "filter_dimension", "filter_dimension.star_query" ] }, { "page": "flat_table", "title": "'flat_table' S3 class", "concept": [ "flat table definition functions" ], "topics": [ "flat_table" ] }, { "page": "ft", "title": "Mortality Reporting System", "concept": [ "mrs example data" ], "topics": [ "ft" ] }, { "page": "ft_age", "title": "Mortality Reporting System by Age Group", "concept": [ "mrs example data" ], "topics": [ "ft_age" ] }, { "page": "ft_age_rpd", "title": "Mortality Reporting System by Age", "concept": [ "mrs example data" ], "topics": [ "ft_age_rpd" ] }, { "page": "ft_cause_rpd", "title": "Mortality Reporting System by Cause", "concept": [ "mrs example data" ], "topics": [ "ft_cause_rpd" ] }, { "page": "ft_num", "title": "Mortality Reporting System with numerical measures", "concept": [ "mrs example data" ], "topics": [ "ft_num" ] }, { "page": "get_attribute_names", "title": "Get the names of the attributes", "concept": [ "star database and flat table functions" ], "topics": [ "get_attribute_names", "get_attribute_names.flat_table", "get_attribute_names.star_database" ] }, { "page": "get_deployment_names", "title": "Get the names of the facts of a star database", "concept": [ "star database deployment functions" ], "topics": [ "get_deployment_names", "get_deployment_names.star_database" ] }, { "page": "get_dimension_names", "title": "Get the names of the dimensions of a star database", "concept": [ "star database definition functions" ], "topics": [ "get_dimension_names", "get_dimension_names.star_database" ] }, { "page": "get_dimension_table", "title": "Get dimension table", "concept": [ "star database definition functions" ], "topics": [ "get_dimension_table", "get_dimension_table.star_database" ] }, { "page": "get_existing_fact_instances", "title": "Get existing fact instances", "concept": [ "star database refresh functions" ], "topics": [ "get_existing_fact_instances", "get_existing_fact_instances.star_database_update" ] }, { "page": "get_fact_names", "title": "Get the names of the facts of a star database", "concept": [ "star database definition functions" ], "topics": [ "get_fact_names", "get_fact_names.star_database" ] }, { "page": "get_geoattribute_geometries", "title": "Get geoattribute geometries", "concept": [ "star database geographic attributes" ], "topics": [ "get_geoattribute_geometries", "get_geoattribute_geometries.star_database" ] }, { "page": "get_geoattributes", "title": "Get geoattributes", "concept": [ "star database geographic attributes" ], "topics": [ "get_geoattributes", "get_geoattributes.star_database" ] }, { "page": "get_layer", "title": "Get geographic information layer", "concept": [ "query functions" ], "topics": [ "get_layer", "get_layer.geolayer" ] }, { "page": "get_layer_geometry", "title": "Get layer geometry", "concept": [ "star database geographic attributes" ], "topics": [ "get_layer_geometry" ] }, { "page": "get_lookup_tables", "title": "Get lookup tables", "concept": [ "star database refresh functions" ], "topics": [ "get_lookup_tables", "get_lookup_tables.star_database_update" ] }, { "page": "get_measure_names", "title": "Get the names of the measures", "concept": [ "star database and flat table functions" ], "topics": [ "get_measure_names", "get_measure_names.flat_table", "get_measure_names.star_database" ] }, { "page": "get_new_dimension_instances", "title": "Get new dimension instances", "concept": [ "star database refresh functions" ], "topics": [ "get_new_dimension_instances", "get_new_dimension_instances.star_database_update" ] }, { "page": "get_pk_attribute_names", "title": "Get the names of the primary key attributes of a flat table", "concept": [ "flat table join functions" ], "topics": [ "get_pk_attribute_names", "get_pk_attribute_names.flat_table" ] }, { "page": "get_point_geometry", "title": "Get point geometry", "concept": [ "star database geographic attributes" ], "topics": [ "get_point_geometry" ] }, { "page": "get_role_playing_dimension_names", "title": "Get the names of the role playing dimensions", "concept": [ "star database definition functions" ], "topics": [ "get_role_playing_dimension_names", "get_role_playing_dimension_names.star_database" ] }, { "page": "get_similar_attribute_values_individually", "title": "Get similar values for individual attributes", "concept": [ "star database and flat table functions" ], "topics": [ "get_similar_attribute_values_individually", "get_similar_attribute_values_individually.flat_table", "get_similar_attribute_values_individually.star_database" ] }, { "page": "get_similar_attribute_values", "title": "Get similar attribute values combination", "concept": [ "star database and flat table functions" ], "topics": [ "get_similar_attribute_values", "get_similar_attribute_values.flat_table", "get_similar_attribute_values.star_database" ] }, { "page": "get_star_database", "title": "Get star database", "concept": [ "star database refresh functions" ], "topics": [ "get_star_database", "get_star_database.star_database", "get_star_database.star_database_update" ] }, { "page": "get_star_schema", "title": "Get star schema", "concept": [ "star database refresh functions" ], "topics": [ "get_star_schema", "get_star_schema.star_database_update" ] }, { "page": "get_table", "title": "Get the table of the flat table", "concept": [ "flat table definition functions" ], "topics": [ "get_table", "get_table.flat_table" ] }, { "page": "get_table_names", "title": "Get the names of the tables of a star database", "concept": [ "star database definition functions" ], "topics": [ "get_table_names", "get_table_names.star_database" ] }, { "page": "get_transformation_code", "title": "Get transformation function code", "concept": [ "star database refresh functions" ], "topics": [ "get_transformation_code", "get_transformation_code.star_database_update" ] }, { "page": "get_transformation_file", "title": "Get transformation function file", "concept": [ "star database refresh functions" ], "topics": [ "get_transformation_file", "get_transformation_file.star_database_update" ] }, { "page": "get_unique_attribute_values", "title": "Get unique attribute values", "concept": [ "star database and flat table functions" ], "topics": [ "get_unique_attribute_values", "get_unique_attribute_values.flat_table", "get_unique_attribute_values.star_database" ] }, { "page": "get_unknown_value_defined", "title": "Get the unknown value defined", "concept": [ "flat table definition functions" ], "topics": [ "get_unknown_value_defined", "get_unknown_value_defined.flat_table" ] }, { "page": "get_unknown_values", "title": "Get unknown attribute values", "concept": [ "flat table definition functions" ], "topics": [ "get_unknown_values", "get_unknown_values.flat_table" ] }, { "page": "get_variable_description", "title": "Get variable description", "concept": [ "query functions" ], "topics": [ "get_variable_description", "get_variable_description.geolayer" ] }, { "page": "get_variables", "title": "Get the variables layer", "concept": [ "query functions" ], "topics": [ "get_variables", "get_variables.geolayer" ] }, { "page": "group_dimension_instances", "title": "Group instances of a dimension", "concept": [ "star database definition functions" ], "topics": [ "group_dimension_instances", "group_dimension_instances.star_database" ] }, { "page": "incremental_refresh", "title": "Refresh a star database in a constellation", "concept": [ "star database refresh functions" ], "topics": [ "incremental_refresh", "incremental_refresh.star_database" ] }, { "page": "join_lookup_table", "title": "Join a flat table with a lookup table", "concept": [ "flat table join functions" ], "topics": [ "join_lookup_table", "join_lookup_table.flat_table" ] }, { "page": "load_star_database", "title": "Load star_database (from a RDS file)", "concept": [ "star database deployment functions" ], "topics": [ "load_star_database" ] }, { "page": "lookup_table", "title": "Transform a flat table into a look up table", "concept": [ "flat table join functions" ], "topics": [ "lookup_table", "lookup_table.flat_table" ] }, { "page": "mrs_age_schema", "title": "Star schema for Mortality Reporting System by Age", "concept": [ "mrs example schema" ], "topics": [ "mrs_age_schema" ] }, { "page": "mrs_age_schema_rpd", "title": "Star schema for Mortality Reporting System by Age with additional dates", "concept": [ "mrs example schema" ], "topics": [ "mrs_age_schema_rpd" ] }, { "page": "mrs_cause_schema", "title": "Star schema for Mortality Reporting System by Cause", "concept": [ "mrs example schema" ], "topics": [ "mrs_cause_schema" ] }, { "page": "mrs_cause_schema_rpd", "title": "Star schema for Mortality Reporting System by Cause with additional dates", "concept": [ "mrs example schema" ], "topics": [ "mrs_cause_schema_rpd" ] }, { "page": "mrs_db", "title": "Constellation generated from MRS file", "concept": [ "mrs example data" ], "topics": [ "mrs_db" ] }, { "page": "mrs_db_geo", "title": "Constellation generated from MRS file through a query and with geographic information", "concept": [ "mrs example data" ], "topics": [ "mrs_db_geo" ] }, { "page": "mrs_ft", "title": "Flat table generated from MRS file", "concept": [ "mrs example data" ], "topics": [ "mrs_ft" ] }, { "page": "mrs_ft_new", "title": "Flat table generated from MRS file", "concept": [ "mrs example data" ], "topics": [ "mrs_ft_new" ] }, { "page": "multiple_value_key", "title": "Multiple value key", "concept": [ "utility functions" ], "topics": [ "multiple_value_key" ] }, { "page": "read_flat_table_file", "title": "Import flat table file", "concept": [ "flat table definition functions" ], "topics": [ "read_flat_table_file" ] }, { "page": "read_flat_table_folder", "title": "Import all flat table files in a folder", "concept": [ "flat table definition functions" ], "topics": [ "read_flat_table_folder" ] }, { "page": "remove_instances_without_measures", "title": "Remove instances without measures", "concept": [ "flat table transformation functions" ], "topics": [ "remove_instances_without_measures", "remove_instances_without_measures.flat_table" ] }, { "page": "replace_attribute_values", "title": "Replace instance values", "concept": [ "star database and flat table functions" ], "topics": [ "replace_attribute_values", "replace_attribute_values.flat_table", "replace_attribute_values.star_database" ] }, { "page": "replace_empty_values", "title": "Replace empty values with the unknown value", "concept": [ "flat table transformation functions" ], "topics": [ "replace_empty_values", "replace_empty_values.flat_table" ] }, { "page": "replace_string", "title": "Replace strings", "concept": [ "flat table transformation functions" ], "topics": [ "replace_string", "replace_string.flat_table" ] }, { "page": "replace_unknown_values", "title": "Replace unknown values with the given value", "concept": [ "flat table transformation functions" ], "topics": [ "replace_unknown_values", "replace_unknown_values.flat_table" ] }, { "page": "role_playing_dimension", "title": "Define a role playing dimension and its associated dimensions", "concept": [ "star database definition functions" ], "topics": [ "role_playing_dimension", "role_playing_dimension.star_database" ] }, { "page": "run_query", "title": "Run query", "concept": [ "query functions" ], "topics": [ "run_query", "run_query.star_database" ] }, { "page": "select_attributes", "title": "Select attributes of a flat table", "concept": [ "flat table transformation functions" ], "topics": [ "select_attributes", "select_attributes.flat_table" ] }, { "page": "select_dimension", "title": "Select dimension", "concept": [ "query functions" ], "topics": [ "select_dimension", "select_dimension.star_query" ] }, { "page": "select_fact", "title": "Select fact", "concept": [ "query functions" ], "topics": [ "select_fact", "select_fact.star_query" ] }, { "page": "select_instances", "title": "Select instances of a flat table by value", "concept": [ "flat table transformation functions" ], "topics": [ "select_instances", "select_instances.flat_table" ] }, { "page": "select_instances_by_comparison", "title": "Select instances of a flat table by comparison", "concept": [ "flat table transformation functions" ], "topics": [ "select_instances_by_comparison", "select_instances_by_comparison.flat_table" ] }, { "page": "select_measures", "title": "Select measures of a flat table", "concept": [ "flat table transformation functions" ], "topics": [ "select_measures", "select_measures.flat_table" ] }, { "page": "separate_measures", "title": "Separate measures in flat tables", "concept": [ "flat table transformation functions" ], "topics": [ "separate_measures", "separate_measures.flat_table" ] }, { "page": "set_attribute_names", "title": "Rename attributes", "concept": [ "star database and flat table functions" ], "topics": [ "set_attribute_names", "set_attribute_names.flat_table", "set_attribute_names.star_database" ] }, { "page": "set_layer", "title": "Set geographic layer", "concept": [ "query functions" ], "topics": [ "set_layer", "set_layer.geolayer" ] }, { "page": "set_measure_names", "title": "Rename measures", "concept": [ "star database and flat table functions" ], "topics": [ "set_measure_names", "set_measure_names.flat_table", "set_measure_names.star_database" ] }, { "page": "set_variables", "title": "Set variables layer", "concept": [ "query functions" ], "topics": [ "set_variables", "set_variables.geolayer" ] }, { "page": "snake_case", "title": "Transform names according to the snake case style", "concept": [ "star database and flat table functions" ], "topics": [ "snake_case", "snake_case.flat_table", "snake_case.star_database" ] }, { "page": "star_database", "title": "'star_database' S3 class", "concept": [ "star database definition functions" ], "topics": [ "star_database" ] }, { "page": "star_query", "title": "'star_query' S3 class", "concept": [ "query functions" ], "topics": [ "star_query", "star_query.star_database" ] }, { "page": "star_schema", "title": "'star_schema' S3 class", "concept": [ "star schema definition functions" ], "topics": [ "star_schema" ] }, { "page": "summarize_layer", "title": "Summarize geometry of a layer", "concept": [ "star database geographic attributes" ], "topics": [ "summarize_layer" ] }, { "page": "transform_attribute_format", "title": "Transform attribute format", "concept": [ "flat table transformation functions" ], "topics": [ "transform_attribute_format", "transform_attribute_format.flat_table" ] }, { "page": "transform_from_values", "title": "Transform attribute values into measure names", "concept": [ "flat table transformation functions" ], "topics": [ "transform_from_values", "transform_from_values.flat_table" ] }, { "page": "transform_to_attribute", "title": "Transform to attribute", "concept": [ "flat table transformation functions" ], "topics": [ "transform_to_attribute", "transform_to_attribute.flat_table" ] }, { "page": "transform_to_measure", "title": "Transform to measure", "concept": [ "flat table transformation functions" ], "topics": [ "transform_to_measure", "transform_to_measure.flat_table" ] }, { "page": "transform_to_values", "title": "Transform measure names into attribute values", "concept": [ "flat table transformation functions" ], "topics": [ "transform_to_values", "transform_to_values.flat_table" ] }, { "page": "update_according_to", "title": "Update a flat table according to another structure", "concept": [ "star database refresh functions" ], "topics": [ "update_according_to", "update_according_to.flat_table" ] }, { "page": "us_census_state", "title": "Census of US States, by sex and age", "topics": [ "us_census_state" ] }, { "page": "us_layer_state", "title": "Geographic layer of US States", "topics": [ "us_layer_state" ] } ], "_pkglogo": "https://github.com/josesamos/rolap/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/josesamos/rolap/raw/HEAD/README.md", "_rundeps": [ "backports", "bit", "bit64", "cachem", "class", "classInt", "cli", "clipr", "cpp11", "crayon", "DBI", "dm", "dplyr", "e1071", "fastmap", "generics", "glue", "hms", "KernSmooth", "lifecycle", "lubridate", "magrittr", "MASS", "memoise", "pillar", "pkgconfig", "prettyunits", "progress", "proxy", "purrr", "R6", "Rcpp", "readr", "rJava", "rlang", "s2", "sf", "snakecase", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "timechange", "tzdb", "units", "utf8", "vctrs", "vroom", "when", "withr", "wk", "xlsx", "xlsxjars" ], "_sysdeps": [ { "shlib": "libjvm", "package": "openjdk-21-jre-headless", "headers": "openjdk-21-jre-headless", "source": "openjdk", "version": "21.0.10+7-1~24.04", "name": "openjdk", "homepage": "https://openjdk.java.net/", "description": "OpenJDK Java runtime, using Hotspot JIT (headless)" } ], "_vignettes": [ { "source": "rolap.Rmd", "filename": "rolap.html", "title": "Basics and getting started with the rolap package", "author": "Jose Samos (jsamos@ugr.es)", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Dimensional modelling and star databases", "Dimensional modelling", "Dimensions and dimension attributes", "Facts and measures", "Star databases", "Dimension tables", "Surrogate keys", "Special dimensions", "Fact table", "Primary key", "Grain", "Constellation", "Conformed dimensions", "An illustrative example", "Data sets", "Star Schema", "Dimensions", "Facts", "Rename fact measures and dimension attributes", "Constellations", "Definition of star databases", "Constellation definition", "Export results", "tibble list", "dm object", "Single tibble list", "Conclusions", "References" ], "created": "2023-07-28 09:59:00", "modified": "2023-12-01 07:51:08", "commits": 21 }, { "source": "v10-rpd.Rmd", "filename": "v10-rpd.html", "title": "Definition of role-playing and role dimensions", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Role-playing and role dimensions in a star database", "Flat table with the initial data", "Star schema", "Star database", "Star database with a role-playing dimension and role dimensions", "Role-playing and role dimensions in a constellation", "Second star database", "Constellation", "Conclusions" ], "created": "2023-08-21 18:02:09", "modified": "2023-10-16 11:35:31", "commits": 3 }, { "source": "v50-deploy.Rmd", "filename": "v50-deploy.html", "title": "Deployment of star databases with incremental refresh", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Star databases and deployments", "Star databases", "Deployment", "Contents of the constellation and the relational database", "Another deployment", "Incremental refresh", "New data", "Incremental refresh process", "Incremental refresh result", "Star database", "First deployment", "Second deployment", "Checking star database copy synchronization", "Conclusions" ], "created": "2023-10-23 10:59:31", "modified": "2023-10-23 10:59:31", "commits": 1 }, { "source": "v40-refresh.Rmd", "filename": "v40-refresh.html", "title": "Incremental refresh of star databases", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Starting data sets", "Generation of star database refresh structures", "Refresh structures", "Transformation code", "Instances included in the structure", "Incremental refresh", "Existing fact instances", "Incremental refresh operation", "Changes in transformation operations", "New transformation function", "Conclusions" ], "created": "2023-10-16 11:35:31", "modified": "2023-12-16 11:24:55", "commits": 2 }, { "source": "v05-flat-table-op.Rmd", "filename": "v05-flat-table-op.html", "title": "Obtaining and transforming flat tables", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Data sets", "122 US Cities Mortality Reporting System", "Database of US cities", "Flat tables", "Create flat_table objects", "flat_table attributes and measures", "Mortality Reporting System", "Measures", "Attributes", "US cities", "Capital status", "Joining flat tables", "Joining US cities and capital status tables", "Joining Mortality Reporting System and US cities tables", "Flat table transformation", "Separate measures", "Transform column names", "Transform measure names into attribute values", "Definition of the star databases", "MRS Cause star database", "MRS Age star database", "Constellation", "Conclusions" ], "created": "2023-09-07 18:03:37", "modified": "2023-12-16 11:24:55", "commits": 7 }, { "source": "v70-star_query.Rmd", "filename": "v70-star_query.html", "title": "Performing Multidimensional Queries (also Including Geographic Attributes)", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Stars and constellations", "Include geographic information layers", "Query functions", "star_query()", "select_fact()", "select_dimension()", "filter_dimension()", "run_query()", "Exploitation of the result", "Obtaining layers with geographic information", "Get a geolayer object", "Operations on variables", "Data representation", "Conclusions" ], "created": "2023-11-13 11:30:12", "modified": "2023-12-12 10:35:26", "commits": 6 }, { "source": "v60-export.Rmd", "filename": "v60-export.html", "title": "Star Database Export Features", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Example star_database object", "Select only one star database", "dm class object", "List of tibble objects", "From component tables", "From flat tables", "Relational database", "xlsx file", "csv files", "geomultistar::multistar object", "Conclusions" ], "created": "2023-10-23 18:59:04", "modified": "2023-11-13 09:04:44", "commits": 3 } ], "_score": 6.264227347756233, "_indexed": true, "_nocasepkg": "rolap", "_universes": [ "josesamos" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "2.5.2.9000", "date": "2026-05-17T07:27:45.000Z", "distro": "noble", "commit": "065b0e5904d15e6b393a96cc642b11a7da188b01", "fileid": "5db8d03a03451431f08d56a44a423e0829b605c765136b7ca379b8114b0710f0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/25984489920" }, { "r": "4.6.0", "os": "linux", "version": "2.5.2.9000", "date": "2026-05-17T07:27:37.000Z", "distro": "noble", "commit": "065b0e5904d15e6b393a96cc642b11a7da188b01", "fileid": "26c75404b55346f92e1ddbbab1b787064c0c0891d1eb01f4a5ee5d667ef09bb8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/25984489920" }, { "r": "4.5.3", "os": "mac", "version": "2.5.2.9000", "date": "2026-05-17T07:26:42.000Z", "commit": "065b0e5904d15e6b393a96cc642b11a7da188b01", "fileid": "5b780d19e7673ec0beba5b0e9f71372bc92e2ba5b3514d71b7de81872daeb5da", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/25984489920" }, { "r": "4.6.0", "os": "mac", "version": "2.5.2.9000", "date": "2026-05-17T07:26:31.000Z", "commit": "065b0e5904d15e6b393a96cc642b11a7da188b01", "fileid": "0e0e9f7161d1afbce698429ecfd6b50bb8a996ac0628ef38078ae0ed847a89b5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/25984489920" }, { "r": "4.7.0", "os": "win", "version": "2.5.2.9000", "date": "2026-05-17T07:27:10.000Z", "commit": "065b0e5904d15e6b393a96cc642b11a7da188b01", "fileid": "f5d21edc52414b49a7ee1ed1aca974956e714671fc157b4da9a929e1ebcb9d19", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/25984489920" }, { "r": "4.5.3", "os": "win", "version": "2.5.2.9000", "date": "2026-05-17T07:26:24.000Z", "commit": "065b0e5904d15e6b393a96cc642b11a7da188b01", "fileid": "b8d1585525759b0770f70592fdd91d1047d33defe430f5763b051654db56a2c5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/25984489920" }, { "r": "4.6.0", "os": "win", "version": "2.5.2.9000", "date": "2026-05-17T07:26:25.000Z", "commit": "065b0e5904d15e6b393a96cc642b11a7da188b01", "fileid": "c11bed842d0933780b23c5b7a3231bf2a67d17944b844c806ec14b274ac3cbe2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/25984489920" }, { "r": "4.6.0", "os": "wasm", "version": "2.5.2.9000", "date": "2026-06-02T17:30:23.000Z", "commit": "065b0e5904d15e6b393a96cc642b11a7da188b01", "fileid": "f7414427d6a39d85470472231bebc2f51d2459de7be358eb82777f04c62434f4", "status": "success", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/25984489920" } ] }