Package: rolap 2.5.1
rolap: Obtaining Star Databases from Flat Tables
Data in multidimensional systems is obtained from operational systems and is transformed to adapt it to the new structure. Frequently, the operations to be performed aim to transform a flat table into a ROLAP (Relational On-Line Analytical Processing) star database. The main objective of the package is to allow the definition of these transformations easily. The implementation of the multidimensional database obtained can be exported to work with multidimensional analysis tools on spreadsheets or relational databases.
Authors:
rolap_2.5.1.tar.gz
rolap_2.5.1.tar.gz(r-4.5-noble)rolap_2.5.1.tar.gz(r-4.4-noble)
rolap_2.5.1.tgz(r-4.4-emscripten)rolap_2.5.1.tgz(r-4.3-emscripten)
rolap.pdf |rolap.html✨
rolap/json (API)
NEWS
# Install 'rolap' in R: |
install.packages('rolap', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/josesamos/rolap/issues
Pkgdown:https://josesamos.github.io
- ft - Mortality Reporting System
- ft_age - Mortality Reporting System by Age Group
- ft_age_rpd - Mortality Reporting System by Age
- ft_cause_rpd - Mortality Reporting System by Cause
- ft_num - Mortality Reporting System with numerical measures
- mrs_age_schema - Star schema for Mortality Reporting System by Age
- mrs_age_schema_rpd - Star schema for Mortality Reporting System by Age with additional dates
- mrs_cause_schema - Star schema for Mortality Reporting System by Cause
- mrs_cause_schema_rpd - Star schema for Mortality Reporting System by Cause with additional dates
- mrs_db - Constellation generated from MRS file
- mrs_db_geo - Constellation generated from MRS file through a query and with geographic information
- mrs_ft - Flat table generated from MRS file
- mrs_ft_new - Flat table generated from MRS file
- us_census_state - Census of US States, by sex and age
- us_layer_state - Geographic layer of US States
Last updated 11 months agofrom:5e0a268e0c. Checks:OK: 2. Indexed: no.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Dec 06 2024 |
R-4.5-linux | OK | Dec 06 2024 |
Exports:add_custom_columnas_csv_filesas_dm_classas_geolayeras_GeoPackageas_multistaras_rdbas_single_tibble_listas_star_databaseas_tibble_listas_xlsx_filecancel_deploymentcheck_geoattribute_geometrycheck_lookup_tableconstellationcoordinates_to_pointdefine_dimensiondefine_factsdefine_geoattributedeploydimension_schemadraw_tablesfact_schemafilter_dimensionflat_tableget_attribute_namesget_deployment_namesget_dimension_namesget_dimension_tableget_existing_fact_instancesget_fact_namesget_geoattribute_geometriesget_geoattributesget_layerget_layer_geometryget_lookup_tablesget_measure_namesget_new_dimension_instancesget_pk_attribute_namesget_point_geometryget_role_playing_dimension_namesget_similar_attribute_valuesget_similar_attribute_values_individuallyget_star_databaseget_star_schemaget_tableget_table_namesget_transformation_codeget_transformation_fileget_unique_attribute_valuesget_unknown_value_definedget_unknown_valuesget_variable_descriptionget_variablesgroup_dimension_instancesincremental_refreshjoin_lookup_tableload_star_databaselookup_tablemultiple_value_keyread_flat_table_fileread_flat_table_folderremove_instances_without_measuresreplace_attribute_valuesreplace_empty_valuesreplace_stringreplace_unknown_valuesrole_playing_dimensionrun_queryselect_attributesselect_dimensionselect_factselect_instancesselect_instances_by_comparisonselect_measuresseparate_measuresset_attribute_namesset_layerset_measure_namesset_variablessnake_casestar_databasestar_querystar_schemasummarize_layertransform_attribute_formattransform_from_valuestransform_to_attributetransform_to_measuretransform_to_valuesupdate_according_to
Dependencies:backportsbitbit64cachemclassclassIntclicliprcpp11crayonDBIdmdplyre1071fansifastmapgenericsgluehmsigraphKernSmoothlatticelifecyclelubridatemagrittrMASSMatrixmemoisepillarpkgconfigprettyunitsprogressproxypurrrR6RcppreadrrJavarlangs2sfsnakecasestarschemarstringistringrtibbletidyrtidyselecttimechangetzdbunitsutf8vctrsvroomwhenwithrwkxlsxxlsxjars
Basics and getting started with the rolap package
Rendered fromrolap.Rmd
usingknitr::rmarkdown
on Dec 06 2024.Last update: 2023-12-12
Started: 2023-08-08
Definition of role-playing and role dimensions
Rendered fromv10-rpd.Rmd
usingknitr::rmarkdown
on Dec 06 2024.Last update: 2023-10-16
Started: 2023-09-15
Deployment of star databases with incremental refresh
Rendered fromv50-deploy.Rmd
usingknitr::rmarkdown
on Dec 06 2024.Last update: 2023-11-15
Started: 2023-11-15
Incremental refresh of star databases
Rendered fromv40-refresh.Rmd
usingknitr::rmarkdown
on Dec 06 2024.Last update: 2024-01-11
Started: 2023-10-16
Obtaining and transforming flat tables
Rendered fromv05-flat-table-op.Rmd
usingknitr::rmarkdown
on Dec 06 2024.Last update: 2024-01-11
Started: 2023-09-15
Performing Multidimensional Queries (also Including Geographic Attributes)
Rendered fromv70-star_query.Rmd
usingknitr::rmarkdown
on Dec 06 2024.Last update: 2024-01-11
Started: 2023-11-15
Star Database Export Features
Rendered fromv60-export.Rmd
usingknitr::rmarkdown
on Dec 06 2024.Last update: 2023-11-15
Started: 2023-11-15
Readme and manuals
Help Manual
Help page | Topics |
---|---|
Add custom column | add_custom_column add_custom_column.flat_table |
Generate csv files with fact and dimension tables | as_csv_files as_csv_files.star_database |
Generate a 'dm' class with fact and dimension tables | as_dm_class as_dm_class.star_database |
Get a 'geolayer' object | as_geolayer as_geolayer.star_database |
Save as 'GeoPackage' | as_GeoPackage as_GeoPackage.geolayer |
Generate a 'geomultistar::multistar' object | as_multistar as_multistar.star_database |
Generate tables in a relational database | as_rdb as_rdb.star_database |
Generate a list of tibbles of flat tables | as_single_tibble_list as_single_tibble_list.star_database |
Get a star database from a flat table | as_star_database as_star_database.flat_table |
Generate a list of tibbles with fact and dimension tables | as_tibble_list as_tibble_list.star_database |
Generate a xlsx file with fact and dimension tables | as_xlsx_file as_xlsx_file.star_database |
Cancel deployment | cancel_deployment cancel_deployment.star_database |
Check a 'geoattribute' geometry instances. | check_geoattribute_geometry check_geoattribute_geometry.star_database |
Check the result of joining a flat table with a lookup table | check_lookup_table check_lookup_table.flat_table |
Create constellation | constellation |
Transform coordinates to point geometry | coordinates_to_point |
Define dimension in a 'star_schema' object. | define_dimension define_dimension.star_schema |
Define facts in a 'star_schema' object. | define_facts define_facts.star_schema |
Define 'geoattribute' of a dimension | define_geoattribute define_geoattribute.star_database |
Deploy a star database in a relational database | deploy deploy.star_database |
'dimension_schema' S3 class | dimension_schema |
Draw tables | draw_tables draw_tables.star_database |
'fact_schema' S3 class | fact_schema |
Filter dimension | filter_dimension filter_dimension.star_query |
'flat_table' S3 class | flat_table |
Mortality Reporting System | ft |
Mortality Reporting System by Age Group | ft_age |
Mortality Reporting System by Age | ft_age_rpd |
Mortality Reporting System by Cause | ft_cause_rpd |
Mortality Reporting System with numerical measures | ft_num |
Get the names of the attributes | get_attribute_names get_attribute_names.flat_table get_attribute_names.star_database |
Get the names of the facts of a star database | get_deployment_names get_deployment_names.star_database |
Get the names of the dimensions of a star database | get_dimension_names get_dimension_names.star_database |
Get dimension table | get_dimension_table get_dimension_table.star_database |
Get existing fact instances | get_existing_fact_instances get_existing_fact_instances.star_database_update |
Get the names of the facts of a star database | get_fact_names get_fact_names.star_database |
Get geoattribute geometries | get_geoattribute_geometries get_geoattribute_geometries.star_database |
Get geoattributes | get_geoattributes get_geoattributes.star_database |
Get geographic information layer | get_layer get_layer.geolayer |
Get layer geometry | get_layer_geometry |
Get lookup tables | get_lookup_tables get_lookup_tables.star_database_update |
Get the names of the measures | get_measure_names get_measure_names.flat_table get_measure_names.star_database |
Get new dimension instances | get_new_dimension_instances get_new_dimension_instances.star_database_update |
Get the names of the primary key attributes of a flat table | get_pk_attribute_names get_pk_attribute_names.flat_table |
Get point geometry | get_point_geometry |
Get the names of the role playing dimensions | get_role_playing_dimension_names get_role_playing_dimension_names.star_database |
Get similar values for individual attributes | get_similar_attribute_values_individually get_similar_attribute_values_individually.flat_table get_similar_attribute_values_individually.star_database |
Get similar attribute values combination | get_similar_attribute_values get_similar_attribute_values.flat_table get_similar_attribute_values.star_database |
Get star database | get_star_database get_star_database.star_database get_star_database.star_database_update |
Get star schema | get_star_schema get_star_schema.star_database_update |
Get the table of the flat table | get_table get_table.flat_table |
Get the names of the tables of a star database | get_table_names get_table_names.star_database |
Get transformation function code | get_transformation_code get_transformation_code.star_database_update |
Get transformation function file | get_transformation_file get_transformation_file.star_database_update |
Get unique attribute values | get_unique_attribute_values get_unique_attribute_values.flat_table get_unique_attribute_values.star_database |
Get the unknown value defined | get_unknown_value_defined get_unknown_value_defined.flat_table |
Get unknown attribute values | get_unknown_values get_unknown_values.flat_table |
Get variable description | get_variable_description get_variable_description.geolayer |
Get the variables layer | get_variables get_variables.geolayer |
Group instances of a dimension | group_dimension_instances group_dimension_instances.star_database |
Refresh a star database in a constellation | incremental_refresh incremental_refresh.star_database |
Join a flat table with a lookup table | join_lookup_table join_lookup_table.flat_table |
Load star_database (from a RDS file) | load_star_database |
Transform a flat table into a look up table | lookup_table lookup_table.flat_table |
Star schema for Mortality Reporting System by Age | mrs_age_schema |
Star schema for Mortality Reporting System by Age with additional dates | mrs_age_schema_rpd |
Star schema for Mortality Reporting System by Cause | mrs_cause_schema |
Star schema for Mortality Reporting System by Cause with additional dates | mrs_cause_schema_rpd |
Constellation generated from MRS file | mrs_db |
Constellation generated from MRS file through a query and with geographic information | mrs_db_geo |
Flat table generated from MRS file | mrs_ft |
Flat table generated from MRS file | mrs_ft_new |
Multiple value key | multiple_value_key |
Import flat table file | read_flat_table_file |
Import all flat table files in a folder | read_flat_table_folder |
Remove instances without measures | remove_instances_without_measures remove_instances_without_measures.flat_table |
Replace instance values | replace_attribute_values replace_attribute_values.flat_table replace_attribute_values.star_database |
Replace empty values with the unknown value | replace_empty_values replace_empty_values.flat_table |
Replace strings | replace_string replace_string.flat_table |
Replace unknown values with the given value | replace_unknown_values replace_unknown_values.flat_table |
Define a role playing dimension and its associated dimensions | role_playing_dimension role_playing_dimension.star_database |
Run query | run_query run_query.star_database |
Select attributes of a flat table | select_attributes select_attributes.flat_table |
Select dimension | select_dimension select_dimension.star_query |
Select fact | select_fact select_fact.star_query |
Select instances of a flat table by value | select_instances select_instances.flat_table |
Select instances of a flat table by comparison | select_instances_by_comparison select_instances_by_comparison.flat_table |
Select measures of a flat table | select_measures select_measures.flat_table |
Separate measures in flat tables | separate_measures separate_measures.flat_table |
Rename attributes | set_attribute_names set_attribute_names.flat_table set_attribute_names.star_database |
Set geographic layer | set_layer set_layer.geolayer |
Rename measures | set_measure_names set_measure_names.flat_table set_measure_names.star_database |
Set variables layer | set_variables set_variables.geolayer |
Transform names according to the snake case style | snake_case snake_case.flat_table snake_case.star_database |
'star_database' S3 class | star_database |
'star_query' S3 class | star_query star_query.star_database |
'star_schema' S3 class | star_schema |
Summarize geometry of a layer | summarize_layer |
Transform attribute format | transform_attribute_format transform_attribute_format.flat_table |
Transform attribute values into measure names | transform_from_values transform_from_values.flat_table |
Transform to attribute | transform_to_attribute transform_to_attribute.flat_table |
Transform to measure | transform_to_measure transform_to_measure.flat_table |
Transform measure names into attribute values | transform_to_values transform_to_values.flat_table |
Update a flat table according to another structure | update_according_to update_according_to.flat_table |
Census of US States, by sex and age | us_census_state |
Geographic layer of US States | us_layer_state |