Obtaining Stars from Flat Tables

Documentation for package ‘starschemar’ version 1.2.5

Help Pages

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

-- misc --

_PACKAGE

Obtaining Star Schemas from Flat Tables