Other packages > Find by keyword >

starschemar  

Obtaining Stars from Flat Tables
View on CRAN: Click here


Download and install starschemar package within the R console
Install from CRAN:
install.packages("starschemar")

Install from Github:
library("remotes")
install_github("cran/starschemar")

Install by package version:
library("remotes")
install_version("starschemar", "1.2.5")



Attach the package and use:
library("starschemar")
Maintained by
Jose Samos
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2020-08-07
Latest Update: 2024-05-02
Description:
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 star schema. Transformations can be carried out using professional extract, transform and load tools or tools intended for data transformation for end users. With the tools mentioned, this transformation can be carried out, but it requires a lot of work. The main objective of this package is to define transformations that allow obtaining stars from flat tables easily. In addition, it includes basic data cleaning, dimension enrichment, incremental data refresh and query operations, adapted to this context.
How to cite:
Jose Samos (2020). starschemar: Obtaining Stars from Flat Tables. R package version 1.2.5, https://cran.r-project.org/web/packages/starschemar. Accessed 26 Aug. 2026.
Previous versions and publish date:
(2026-07-09 07:09), 1.0.0 (2020-08-07 15:50), 1.1.0 (2020-09-13 18:50), 1.2.0 (2020-09-25 23:30), 1.2.1 (2023-08-12 17:50), 1.2.2 (2023-09-14 06:50), 1.2.3 (2023-11-11 12:10), 1.2.4 (2024-01-08 16:30)
Other packages that cited starschemar R package
View starschemar citation profile
Other R packages that starschemar depends, imports, suggests or enhances
Complete documentation for starschemar
Functions, R codes and Examples using the starschemar R package
Some associated functions: character_dimension . character_dimensions . conform_all_dimensions . conform_dimensions . constellation . constellation_as_multistar . constellation_as_tibble_list . ct_mrs . ct_mrs_test . define_dimension . define_fact . define_selected_dimensions . define_selected_facts . delete_records . delete_unused_foreign_keys . dereference_dimension . dimensional_model . dimensional_query . dm_mrs_age . dm_mrs_cause . enrich_dimension_export . enrich_dimension_import . enrich_dimension_import_test . filter_dimension . filter_fact_rows . filter_selected_instances . find_values . ft_datagov_uk . ft_london_boroughs . ft_usa_city_county . ft_usa_states . get_all_dimensions . get_attribute_names . get_conformed_dimension . get_conformed_dimension_names . get_conformed_dimension_names_st . get_dimension . get_dimension_attribute_names . get_dimension_name . get_dimension_names . get_dimension_type . get_fact_name . get_measure_names . get_name_of_role_playing_dimensions . get_name_of_uniquely_implemented_dimensions . get_role_dimension_names . get_role_playing_dimension_name . get_star_schema . get_star_schema_names . group_facts . group_records . group_table . homogenize . incremental_refresh_constellation . incremental_refresh_dimension . incremental_refresh_fact . incremental_refresh_star_schema . is_conformed_dimension . is_dimension_in_updates . is_role_dimension . is_role_playing_dimension . match_records . modify_conformed_dimension_records . modify_dimension_records . mrs . mrs_age . mrs_age_test . mrs_age_w10 . mrs_age_w11 . mrs_age_w_test . mrs_cause . mrs_cause_test . mrs_cause_w10 . mrs_cause_w11 . mrs_cause_w_test . ms_mrs . ms_mrs_test . multistar_as_flat_table . new_constellation . new_dimension_table . new_dimensional_model . new_dimensional_query . new_fact_table . new_multistar . new_record_update . new_record_update_set . new_star_schema . prepare_join . purge_dimensions_constellation . purge_dimensions_star_schema . record_update_set . reference_dimension . remove_duplicate_dimension_rows . rename_dimension . rename_dimension_attributes . rename_fact . rename_measures . replace_dimension . replace_dimension_in_facts . replace_general_dimension_in_facts . replace_records . replace_role_dimension_in_facts . role_dimension . role_playing_dimension . run_query . select_dimension . select_fact . selection_bit_map . set_dimension_name . set_dimension_type . set_dimension_type_conformed . set_dimension_type_role_playing . set_fact_name . set_role_playing_dimension_name . snake_case . snake_case_dimension . snake_case_fact . st_mrs_age . st_mrs_age_test . st_mrs_age_w10 . st_mrs_age_w11 . st_mrs_age_w_test . st_mrs_cause . st_mrs_cause_test . st_mrs_cause_w10 . st_mrs_cause_w11 . st_mrs_cause_w_test . star_schema . star_schema_as_flat_table . star_schema_as_mst . star_schema_as_multistar . star_schema_as_tibble_list . star_schema_as_tl . starschemar . typed_value . unify_facts_by_grain . union_of_dimensions . update_dimension . update_dimensions . update_facts_with_dimensions . update_facts_with_general_dimension . update_facts_with_role_dimension . update_record . update_selection . update_selection_general . updates_st_mrs_age . updates_st_mrs_age_test . validate_names . 
Some associated R codes: common.R . constellation.R . constellation_as_multistar.R . constellation_as_tibble_list.R . constellation_get_conformed_dimension.R . constellation_get_star_schema.R . constellation_incremental_refresh.R . constellation_modify_conformed_dimension_records.R . constellation_purge_dimensions.R . data.R . dimension_table.R . dimension_table_attributes.R . dimension_table_character_dimensions.R . dimension_table_homogenize.R . dimension_table_incremental_refresh.R . dimension_table_role_dimension.R . dimension_table_snake_case.R . dimension_table_update_dimension.R . dimensional_model.R . dimensional_model_define_dimension.R . dimensional_model_define_fact.R . fact_table.R . fact_table_incremental_refresh.R . fact_table_snake_case.R . geomultistar.R . record_update.R . record_update_set.R . record_update_set_is_dimension_in_updates.R . record_update_set_match_records.R . record_update_set_update_record.R . record_update_set_update_selection.R . record_update_set_update_selection_general.R . star_schema.R . star_schema_as_flat_table.R . star_schema_as_multistar.R . star_schema_as_tibble_list.R . star_schema_attributes.R . star_schema_character_dimensions.R . star_schema_enrich_dimension.R . star_schema_filter_fact_rows.R . star_schema_get_dimension.R . star_schema_incremental_refresh.R . star_schema_modify_dimension_records.R . star_schema_purge_dimensions.R . star_schema_rename.R . star_schema_replace_dimension.R . star_schema_role_playing_dimension.R . star_schema_snake_case.R . star_schema_update_facts_with_dimensions.R . starschemar.R .  Full starschemar package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

nextGenShinyApps  
Craft Exceptional 'R Shiny' Applications and Dashboards with Novel Responsive Tools
Nove responsive tools for designing and developing 'Shiny' dashboards and applications. The scripts ...
Download / Learn more Package Citations See dependency  
RCytoGPS  
Using Cytogenetics Data in R
Defines classes and methods to process text-based cytogenetics using the CytoGPS web site, then imp ...
Download / Learn more Package Citations See dependency  
leafgl  
High-Performance 'WebGl' Rendering for Package 'leaflet'
Provides bindings to the 'Leaflet.glify' JavaScript library which extends the 'leaflet' JavaScript l ...
Download / Learn more Package Citations See dependency  
PCADSC  
Tools for Principal Component Analysis-Based Data Structure Comparisons
A suite of non-parametric, visual tools for assessing differences in data structures for two datase ...
Download / Learn more Package Citations See dependency  
clinUtils  
General Utility Functions for Analysis of Clinical Data
Utility functions to facilitate the import, the reporting and analysis of clinical data. Example ...
Download / Learn more Package Citations See dependency  
SelvarMix  
Regularization for Variable Selection in Model-Based Clustering and Discriminant Analysis
Performs a regularization approach to variable selection in themodel-based clustering and classifica ...
Download / Learn more Package Citations See dependency  

28,332

R Packages

239,283

Dependencies

75,113

Author Associations

28,333

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA