starschemar1.2.5 package

Obtaining Stars from Flat Tables

get_conformed_dimension

Get conformed dimension

get_conformed_dimension_names

Get conformed dimension names

get_conformed_dimension_names_st

Get conformed dimension names

get_dimension

Get dimension

get_dimension_attribute_names

Get dimension attribute names

get_dimension_name

Get the dimension name

get_dimension_names

Get dimension names

get_dimension_type

Get the dimension type

get_fact_name

Get fact name

get_measure_names

Get measure names

get_name_of_role_playing_dimensions

Get the name of the role playing dimensions

get_name_of_uniquely_implemented_dimensions

Get name of uniquely implemented dimensions

get_role_dimension_names

Get role dimension names associated to a role-playing dimension

get_role_playing_dimension_name

Get the associated role-playing dimension name

get_star_schema

Get star schema

get_star_schema_names

Get star schema names

group_facts

Group facts

group_records

Group records

group_table

Group the records in the table

homogenize

Homogenize a dimension

purge_dimensions_constellation

Purge dimensions in a constellation

purge_dimensions_star_schema

Purge dimensions

record_update_set

record_update_set S3 class

role_dimension

Transform a dimension into a role dimension

set_dimension_type_role_playing

Set the type of a role-playing dimension

set_fact_name

Set fact name

set_role_playing_dimension_name

Set the associated role-playing dimension name

update_dimension

Apply dimension record update operations to a dimension

update_dimensions

Apply update operations to dimensions

update_facts_with_dimensions

Update facts with a list of modified dimensions

update_facts_with_general_dimension

Update facts with a general dimension

update_facts_with_role_dimension

Update facts with a role dimension

conform_dimensions

Conform dimensions of given name

replace_role_dimension_in_facts

Replace in facts a star schema role dimension

union_of_dimensions

Perform union of dimensions

set_dimension_type

Set the dimension type

set_dimension_type_conformed

Set the type of a conformed dimension

typed_value

Transform a value according to its type

unify_facts_by_grain

Unify facts by grain

new_fact_table

fact_table S3 class

constellation

constellation S3 class

new_multistar

multistar S3 class

new_record_update

record_update S3 class

dimensional_model

dimensional_model S3 class

dimensional_query

dimensional_query S3 class

get_all_dimensions

Get all dimensions

get_attribute_names

Get attribute names

new_record_update_set

record_update_set S3 class

new_star_schema

star_schema S3 class

prepare_join

Transform a tibble to join

new_dimension_table

dimension_table S3 class

new_dimensional_model

dimensional_model S3 class

new_dimensional_query

dimensional_query S3 class

conform_all_dimensions

Conform all dimensions of a constellation

character_dimension

Transform a dimension numeric attributes to character

character_dimensions

Transform dimension numeric attributes to character

constellation_as_multistar

Export a constellation as a multistar

constellation_as_tibble_list

Export a constellation as a tibble list

define_dimension

Define dimensions in a dimensional_model object

define_fact

Define facts in a dimensional_model object

define_selected_dimensions

Define selected dimensions

define_selected_facts

Define selected facts

delete_records

Delete records

delete_unused_foreign_keys

Delete unused foreign keys

dereference_dimension

Dereference a dimension

enrich_dimension_export

Export selected attributes of a dimension

enrich_dimension_import

Import tibble to enrich a dimension

enrich_dimension_import_test

Import tibble to test to enrich a dimension

filter_dimension

Filter dimension

filter_fact_rows

Filter fact rows

filter_selected_instances

Filter selected instances

find_values

Find values in a dimension

incremental_refresh_constellation

Incrementally refresh a constellation with a star schema

incremental_refresh_dimension

Incrementally refresh a dimension with another

incremental_refresh_fact

Incrementally refresh a fact table with another

incremental_refresh_star_schema

Incrementally refresh a star schema with another

is_conformed_dimension

Is it conformed dimension?

is_dimension_in_updates

Is dimension in set of updates?

is_role_dimension

Is it role dimension?

is_role_playing_dimension

Is it role-playing dimension?

match_records

Make a dimension record equal to another

modify_conformed_dimension_records

Apply dimension record update operations to conformed dimensions

modify_dimension_records

Apply dimension record update operations

multistar_as_flat_table

Export a multistar as a flat table

new_constellation

constellation S3 class

reference_dimension

Reference a dimension

remove_duplicate_dimension_rows

Remove duplicate dimension rows

rename_dimension

Rename dimension

rename_dimension_attributes

Rename dimension attributes

rename_fact

Rename fact

rename_measures

Rename measures

replace_dimension

Replace a star schema dimension

replace_dimension_in_facts

Replace in facts a star schema dimension

replace_general_dimension_in_facts

Replace in facts a star schema general dimension

replace_records

Replace records

role_playing_dimension

Define a role playing dimension in a star_schema object

run_query

Run query

select_dimension

Select dimension

select_fact

Select fact

selection_bit_map

Generate a record selection bitmap

set_dimension_name

Set the dimension name

snake_case

Transform names according to the snake case style

snake_case_dimension

Transform names according to the snake case style in a dimension

snake_case_fact

Transform names according to the snake case style in a fact table

star_schema

star_schema S3 class

star_schema_as_flat_table

Export a star schema as a flat table

star_schema_as_mst

Star schema as multistar export (common)

star_schema_as_multistar

Export a star schema as a multistar

star_schema_as_tibble_list

Export a star schema as a tibble list

star_schema_as_tl

Export a star schema as a tibble list (common)

starschemar

Obtaining Star Schemas from Flat Tables

update_record

Update a dimension record with a set of values

update_selection

Update dimension records with a set of values

update_selection_general

Update dimension records with a set of values in given columns

validate_names

Validate names

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.

  • Maintainer: Jose Samos
  • License: MIT + file LICENSE
  • Last published: 2024-05-02