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-01-08
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 21 Nov. 2024.
Previous versions and publish date:
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
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

crossrun  
Joint Distribution of Number of Crossings and Longest Run
Joint distribution of number of crossings and the longest run in a series of independent Bernoulli ...
Download / Learn more Package Citations See dependency  
pkgdepends  
Package Dependency Resolution and Downloads
Find recursive dependencies of 'R' packages from various sources. Solve the dependencies to obtain ...
Download / Learn more Package Citations See dependency  
kgschart  
KGS Rank Graph Parser
Restore underlining numeric data from rating history graph of KGS (an online platform of the game o ...
Download / Learn more Package Citations See dependency  
r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
SCBiclust  
Identifies Mean, Variance, and Hierarchically Clustered Biclusters
Identifies a bicluster, a submatrix of the data such that the features and observations within the s ...
Download / Learn more Package Citations See dependency  
RcppHNSW  
'Rcpp' Bindings for 'hnswlib', a Library for Approximate Nearest Neighbors
'Hnswlib' is a C++ library for Approximate Nearest Neighbors. This package provides a minimal R int ...
Download / Learn more Package Citations See dependency  

23,229

R Packages

199,929

Dependencies

62,984

Author Associations

23,230

Publication Badges

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