Obtaining Stars from Flat Tables
![[R logo]](../../../doc/html/Rlogo.svg)
![[Up]](../../../doc/html/left.jpg)
![[Top]](../../../doc/html/up.jpg)
Documentation for package ‘starschemar’ version 1.2.4
Help Pages
| starschemar-package | Obtaining Star Schemas from Flat Tables |
-- C --
| character_dimensions | Transform dimension numeric attributes to character |
| character_dimensions.star_schema | Transform dimension numeric attributes to character |
| constellation | 'constellation' S3 class |
| constellation_as_multistar | Export a constellation as a 'multistar' |
| constellation_as_multistar.constellation | Export a constellation as a 'multistar' |
| constellation_as_tibble_list | Export a constellation as a 'tibble' list |
| constellation_as_tibble_list.constellation | Export a constellation as a 'tibble' list |
| ct_mrs | Constellation for Mortality Reporting System |
| ct_mrs_test | Constellation for Mortality Reporting System Test |
-- D --
| define_dimension | Define dimensions in a 'dimensional_model' object |
| define_dimension.dimensional_model | Define dimensions in a 'dimensional_model' object |
| define_fact | Define facts in a 'dimensional_model' object |
| define_fact.dimensional_model | Define facts in a 'dimensional_model' object |
| dimensional_model | 'dimensional_model' S3 class |
| dimensional_query | 'dimensional_query' S3 class |
| dm_mrs_age | Star Definition for Mortality Reporting System by Age |
| dm_mrs_cause | Star Definition for Mortality Reporting System by Cause |
-- E --
| enrich_dimension_export | Export selected attributes of a dimension |
| enrich_dimension_export.star_schema | Export selected attributes of a dimension |
| enrich_dimension_import | Import 'tibble' to enrich a dimension |
| enrich_dimension_import.star_schema | Import 'tibble' to enrich a dimension |
| enrich_dimension_import_test | Import 'tibble' to test to enrich a dimension |
| enrich_dimension_import_test.star_schema | Import 'tibble' to test to enrich a dimension |
-- F --
| filter_dimension | Filter dimension |
| filter_dimension.dimensional_query | Filter dimension |
| filter_fact_rows | Filter fact rows |
| filter_fact_rows.star_schema | Filter fact rows |
| ft_datagov_uk | Modelling the long-term health impacts of air pollution in London |
| ft_london_boroughs | London Boroughs |
| ft_usa_city_county | USA City and County |
| ft_usa_states | USA States |
-- G --
| get_conformed_dimension | Get conformed dimension |
| get_conformed_dimension.constellation | Get conformed dimension |
| get_conformed_dimension_names | Get conformed dimension names |
| get_conformed_dimension_names.constellation | Get conformed dimension names |
| get_dimension | Get dimension |
| get_dimension.star_schema | Get dimension |
| get_dimension_attribute_names | Get dimension attribute names |
| get_dimension_attribute_names.star_schema | Get dimension attribute names |
| get_dimension_names | Get dimension names |
| get_dimension_names.star_schema | Get dimension names |
| get_measure_names | Get measure names |
| get_measure_names.star_schema | Get measure names |
| get_star_schema | Get star schema |
| get_star_schema.constellation | Get star schema |
| get_star_schema_names | Get star schema names |
| get_star_schema_names.constellation | Get star schema names |
-- I --
| incremental_refresh_constellation | Incrementally refresh a constellation with a star schema |
| incremental_refresh_constellation.constellation | Incrementally refresh a constellation with a star schema |
-- M --
| match_records | Make a dimension record equal to another |
| match_records.record_update_set | Make a dimension record equal to another |
| modify_conformed_dimension_records | Apply dimension record update operations to conformed dimensions |
| modify_conformed_dimension_records.constellation | Apply dimension record update operations to conformed dimensions |
| modify_dimension_records | Apply dimension record update operations |
| modify_dimension_records.star_schema | Apply dimension record update operations |
| mrs | Mortality Reporting System |
| mrs_age | Mortality Reporting System by Age |
| mrs_age_test | Mortality Reporting System by Age Test |
| mrs_age_w10 | Mortality Reporting System by Age for Week 10 |
| mrs_age_w11 | Mortality Reporting System by Age for Week 11 |
| mrs_age_w_test | Mortality Reporting System by Age for Week Test |
| mrs_cause | Mortality Reporting System by Cause |
| mrs_cause_test | Mortality Reporting System by Cause Test |
| mrs_cause_w10 | Mortality Reporting System by Cause for Week 10 |
| mrs_cause_w11 | Mortality Reporting System by Cause for Week 11 |
| mrs_cause_w_test | Mortality Reporting System by Cause for Week Test |
| ms_mrs | Multistar for Mortality Reporting System |
| ms_mrs_test | Multistar for Mortality Reporting System Test |
| multistar_as_flat_table | Export a 'multistar' as a flat table |
| multistar_as_flat_table.multistar | Export a 'multistar' as a flat table |
-- P --
| purge_dimensions_constellation | Purge dimensions in a constellation |
| purge_dimensions_constellation.constellation | Purge dimensions in a constellation |
| purge_dimensions_star_schema | Purge dimensions |
| purge_dimensions_star_schema.star_schema | Purge dimensions |
-- R --
| record_update_set | 'record_update_set' S3 class |
| rename_dimension | Rename dimension |
| rename_dimension.star_schema | Rename dimension |
| rename_dimension_attributes | Rename dimension attributes |
| rename_dimension_attributes.star_schema | Rename dimension attributes |
| rename_fact | Rename fact |
| rename_fact.star_schema | Rename fact |
| rename_measures | Rename measures |
| rename_measures.star_schema | Rename measures |
| role_playing_dimension | Define a role playing dimension in a 'star_schema' object |
| role_playing_dimension.star_schema | Define a role playing dimension in a 'star_schema' object |
| run_query | Run query |
| run_query.dimensional_query | Run query |
-- S --
| select_dimension | Select dimension |
| select_dimension.dimensional_query | Select dimension |
| select_fact | Select fact |
| select_fact.dimensional_query | Select fact |
| snake_case | Transform names according to the snake case style |
| snake_case.star_schema | Transform names according to the snake case style |
| starschemar | Obtaining Star Schemas from Flat Tables |
| star_schema | 'star_schema' S3 class |
| star_schema_as_flat_table | Export a star schema as a flat table |
| star_schema_as_flat_table.star_schema | Export a star schema as a flat table |
| star_schema_as_multistar | Export a star schema as a 'multistar' |
| star_schema_as_multistar.star_schema | Export a star schema as a 'multistar' |
| star_schema_as_tibble_list | Export a star schema as a 'tibble' list |
| star_schema_as_tibble_list.star_schema | Export a star schema as a 'tibble' list |
| st_mrs_age | Star Schema for Mortality Reporting System by Age |
| st_mrs_age_test | Star Schema for Mortality Reporting System by Age Test |
| st_mrs_age_w10 | Star Schema for Mortality Reporting System by Age for Week 10 |
| st_mrs_age_w11 | Star Schema for Mortality Reporting System by Age for Week 11 |
| st_mrs_age_w_test | Star Schema for Mortality Reporting System by Age for Week Test |
| st_mrs_cause | Star Schema for Mortality Reporting System by Cause |
| st_mrs_cause_test | Star Schema for Mortality Reporting System by Cause Test |
| st_mrs_cause_w10 | Star Schema for Mortality Reporting System by Cause for Week 10 |
| st_mrs_cause_w11 | Star Schema for Mortality Reporting System by Cause for Week 11 |
| st_mrs_cause_w_test | Star Schema for Mortality Reporting System by Cause for Week Test |
-- U --
| updates_st_mrs_age | Updates for the Star Schema for Mortality Reporting System by Age |
| updates_st_mrs_age_test | Updates for the Star Schema for Mortality Reporting System by Age Test |
| update_record | Update a dimension record with a set of values |
| update_record.record_update_set | Update a dimension record with a set of values |
| update_selection | Update dimension records with a set of values |
| update_selection.record_update_set | Update dimension records with a set of values |
| update_selection_general | Update dimension records with a set of values in given columns |
| update_selection_general.record_update_set | Update dimension records with a set of values in given columns |