Obtaining Star Databases from Flat Tables

Documentation for package ‘rolap’ version 2.5.1

Help Pages

-- A --

add_custom_column	Add custom column
add_custom_column.flat_table	Add custom column
as_csv_files	Generate csv files with fact and dimension tables
as_csv_files.star_database	Generate csv files with fact and dimension tables
as_dm_class	Generate a 'dm' class with fact and dimension tables
as_dm_class.star_database	Generate a 'dm' class with fact and dimension tables
as_geolayer	Get a 'geolayer' object
as_geolayer.star_database	Get a 'geolayer' object
as_GeoPackage	Save as 'GeoPackage'
as_GeoPackage.geolayer	Save as 'GeoPackage'
as_multistar	Generate a 'geomultistar::multistar' object
as_multistar.star_database	Generate a 'geomultistar::multistar' object
as_rdb	Generate tables in a relational database
as_rdb.star_database	Generate tables in a relational database
as_single_tibble_list	Generate a list of tibbles of flat tables
as_single_tibble_list.star_database	Generate a list of tibbles of flat tables
as_star_database	Get a star database from a flat table
as_star_database.flat_table	Get a star database from a flat table
as_tibble_list	Generate a list of tibbles with fact and dimension tables
as_tibble_list.star_database	Generate a list of tibbles with fact and dimension tables
as_xlsx_file	Generate a xlsx file with fact and dimension tables
as_xlsx_file.star_database	Generate a xlsx file with fact and dimension tables

-- C --

cancel_deployment	Cancel deployment
cancel_deployment.star_database	Cancel deployment
check_geoattribute_geometry	Check a 'geoattribute' geometry instances.
check_geoattribute_geometry.star_database	Check a 'geoattribute' geometry instances.
check_lookup_table	Check the result of joining a flat table with a lookup table
check_lookup_table.flat_table	Check the result of joining a flat table with a lookup table
constellation	Create constellation
coordinates_to_point	Transform coordinates to point geometry

-- D --

define_dimension	Define dimension in a 'star_schema' object.
define_dimension.star_schema	Define dimension in a 'star_schema' object.
define_facts	Define facts in a 'star_schema' object.
define_facts.star_schema	Define facts in a 'star_schema' object.
define_geoattribute	Define 'geoattribute' of a dimension
define_geoattribute.star_database	Define 'geoattribute' of a dimension
deploy	Deploy a star database in a relational database
deploy.star_database	Deploy a star database in a relational database
dimension_schema	'dimension_schema' S3 class
draw_tables	Draw tables
draw_tables.star_database	Draw tables

-- F --

fact_schema	'fact_schema' S3 class
filter_dimension	Filter dimension
filter_dimension.star_query	Filter dimension
flat_table	'flat_table' S3 class
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

-- G --

get_attribute_names	Get the names of the attributes
get_attribute_names.flat_table	Get the names of the attributes
get_attribute_names.star_database	Get the names of the attributes
get_deployment_names	Get the names of the facts of a star database
get_deployment_names.star_database	Get the names of the facts of a star database
get_dimension_names	Get the names of the dimensions of a star database
get_dimension_names.star_database	Get the names of the dimensions of a star database
get_dimension_table	Get dimension table
get_dimension_table.star_database	Get dimension table
get_existing_fact_instances	Get existing fact instances
get_existing_fact_instances.star_database_update	Get existing fact instances
get_fact_names	Get the names of the facts of a star database
get_fact_names.star_database	Get the names of the facts of a star database
get_geoattributes	Get geoattributes
get_geoattributes.star_database	Get geoattributes
get_geoattribute_geometries	Get geoattribute geometries
get_geoattribute_geometries.star_database	Get geoattribute geometries
get_layer	Get geographic information layer
get_layer.geolayer	Get geographic information layer
get_layer_geometry	Get layer geometry
get_lookup_tables	Get lookup tables
get_lookup_tables.star_database_update	Get lookup tables
get_measure_names	Get the names of the measures
get_measure_names.flat_table	Get the names of the measures
get_measure_names.star_database	Get the names of the measures
get_new_dimension_instances	Get new dimension instances
get_new_dimension_instances.star_database_update	Get new dimension instances
get_pk_attribute_names	Get the names of the primary key attributes of a flat table
get_pk_attribute_names.flat_table	Get the names of the primary key attributes of a flat table
get_point_geometry	Get point geometry
get_role_playing_dimension_names	Get the names of the role playing dimensions
get_role_playing_dimension_names.star_database	Get the names of the role playing dimensions
get_similar_attribute_values	Get similar attribute values combination
get_similar_attribute_values.flat_table	Get similar attribute values combination
get_similar_attribute_values.star_database	Get similar attribute values combination
get_similar_attribute_values_individually	Get similar values for individual attributes
get_similar_attribute_values_individually.flat_table	Get similar values for individual attributes
get_similar_attribute_values_individually.star_database	Get similar values for individual attributes
get_star_database	Get star database
get_star_database.star_database	Get star database
get_star_database.star_database_update	Get star database
get_star_schema	Get star schema
get_star_schema.star_database_update	Get star schema
get_table	Get the table of the flat table
get_table.flat_table	Get the table of the flat table
get_table_names	Get the names of the tables of a star database
get_table_names.star_database	Get the names of the tables of a star database
get_transformation_code	Get transformation function code
get_transformation_code.star_database_update	Get transformation function code
get_transformation_file	Get transformation function file
get_transformation_file.star_database_update	Get transformation function file
get_unique_attribute_values	Get unique attribute values
get_unique_attribute_values.flat_table	Get unique attribute values
get_unique_attribute_values.star_database	Get unique attribute values
get_unknown_values	Get unknown attribute values
get_unknown_values.flat_table	Get unknown attribute values
get_unknown_value_defined	Get the unknown value defined
get_unknown_value_defined.flat_table	Get the unknown value defined
get_variables	Get the variables layer
get_variables.geolayer	Get the variables layer
get_variable_description	Get variable description
get_variable_description.geolayer	Get variable description
group_dimension_instances	Group instances of a dimension
group_dimension_instances.star_database	Group instances of a dimension

-- I --

incremental_refresh	Refresh a star database in a constellation
incremental_refresh.star_database	Refresh a star database in a constellation

-- J --

join_lookup_table	Join a flat table with a lookup table
join_lookup_table.flat_table	Join a flat table with a lookup table

-- L --

load_star_database	Load star_database (from a RDS file)
lookup_table	Transform a flat table into a look up table
lookup_table.flat_table	Transform a flat table into a look up table

-- M --

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
multiple_value_key	Multiple value key

-- R --

read_flat_table_file	Import flat table file
read_flat_table_folder	Import all flat table files in a folder
remove_instances_without_measures	Remove instances without measures
remove_instances_without_measures.flat_table	Remove instances without measures
replace_attribute_values	Replace instance values
replace_attribute_values.flat_table	Replace instance values
replace_attribute_values.star_database	Replace instance values
replace_empty_values	Replace empty values with the unknown value
replace_empty_values.flat_table	Replace empty values with the unknown value
replace_string	Replace strings
replace_string.flat_table	Replace strings
replace_unknown_values	Replace unknown values with the given value
replace_unknown_values.flat_table	Replace unknown values with the given value
role_playing_dimension	Define a role playing dimension and its associated dimensions
role_playing_dimension.star_database	Define a role playing dimension and its associated dimensions
run_query	Run query
run_query.star_database	Run query

-- S --

select_attributes	Select attributes of a flat table
select_attributes.flat_table	Select attributes of a flat table
select_dimension	Select dimension
select_dimension.star_query	Select dimension
select_fact	Select fact
select_fact.star_query	Select fact
select_instances	Select instances of a flat table by value
select_instances.flat_table	Select instances of a flat table by value
select_instances_by_comparison	Select instances of a flat table by comparison
select_instances_by_comparison.flat_table	Select instances of a flat table by comparison
select_measures	Select measures of a flat table
select_measures.flat_table	Select measures of a flat table
separate_measures	Separate measures in flat tables
separate_measures.flat_table	Separate measures in flat tables
set_attribute_names	Rename attributes
set_attribute_names.flat_table	Rename attributes
set_attribute_names.star_database	Rename attributes
set_layer	Set geographic layer
set_layer.geolayer	Set geographic layer
set_measure_names	Rename measures
set_measure_names.flat_table	Rename measures
set_measure_names.star_database	Rename measures
set_variables	Set variables layer
set_variables.geolayer	Set variables layer
snake_case	Transform names according to the snake case style
snake_case.flat_table	Transform names according to the snake case style
snake_case.star_database	Transform names according to the snake case style
star_database	'star_database' S3 class
star_query	'star_query' S3 class
star_query.star_database	'star_query' S3 class
star_schema	'star_schema' S3 class
summarize_layer	Summarize geometry of a layer

-- T --

transform_attribute_format	Transform attribute format
transform_attribute_format.flat_table	Transform attribute format
transform_from_values	Transform attribute values into measure names
transform_from_values.flat_table	Transform attribute values into measure names
transform_to_attribute	Transform to attribute
transform_to_attribute.flat_table	Transform to attribute
transform_to_measure	Transform to measure
transform_to_measure.flat_table	Transform to measure
transform_to_values	Transform measure names into attribute values
transform_to_values.flat_table	Transform measure names into attribute values

-- U --

update_according_to	Update a flat table according to another structure
update_according_to.flat_table	Update a flat table according to another structure
us_census_state	Census of US States, by sex and age
us_layer_state	Geographic layer of US States