Obtaining Star Databases from Flat Tables
Add custom column
Add dimension instances
For each row, add a vector of values
A star_operation object row is added with a new operation
Add the surrogate key from a dimension table to the instances table.
Apply filter dimension
Apply select dimension
Apply select fact
Generate csv files with fact and dimension tables
Generate a dm class with fact and dimension tables
Get a geolayer object
Save as GeoPackage
Generate a geomultistar::multistar object
Generate tables in a relational database
Generate a list of tibbles of flat tables
Get a star database from a flat table
Generate a list of tibbles with fact and dimension tables
Generate a xlsx file with fact and dimension tables
Cancel deployment
Check a geoattribute geometry instances.
Check the result of joining a flat table with a lookup table
Checks the refresh of the selected star database from the given databa...
Conform dimensions
Create constellation
Transform coordinates to point geometry
Default disconnect function
Define dimension in a star_schema object.
Define facts in a star_schema object.
Define geoattribute of a dimension
Define geoattribute from a layer
Delete in stars all operations found
Delete an operation
Delete a set of operations
Deploy a star database in a relational database
dimension_schema S3 class
dimension_table S3 class
Draw tables
fact_schema S3 class
fact_table S3 class
Filter dimension
From attributes, leave only these contained in dimensions
From geodimensions, leave only contained in vector of names
From rpd dimensions, leave only contained in vector of names.
flat_table S3 class
Generate refresh sql
Generate table sql delete
Generate table sql insert
Generate table sql update
Get aggregate functions
Gets the operations performed on a dimension in all star_database ob...
Get the names of the attributes
Get attribute names
Get attribute names
get default unknown value
Get the names of the facts of a star database
Get the names of the dimensions of a star database
Get dimension table
Get existing fact instances
Get fact name
Get the names of the facts of a star database
Get geoattribute geometries
Get geoattribute name
Get geoattributes
Get geographic information layer
Get layer from attribute
Get layer geometry
Get lookup tables
Get the names of the measures
Get measure names
Get measure names
Get new dimension instances
A star_operation object row is returned, the one following the actua...
Get number of rows aggregate column
Get the names of the primary key attributes of a flat table
Get point geometry
Get the names of the role playing dimensions
Get rpd dimensions of a dimension
Get similar attribute values combination
Get similar values for individual attributes
Get similar values in a table
Get star database
Get star query schema
Get star schema
Get surrogate key names
Get the table of the flat table
Get the names of the tables of a star database
Get transformation function code
Get transformation function file
Get unique attribute values
Get unique values in a table
Get the unknown value defined
Get unknown attribute values
Get variable description
Get the variables layer
Group table instances by keys aggregating the measures using the corre...
Group instances of a dimension
Group facts
Refresh a star database in a constellation
Integrate two geodimensions
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
Interpret operation
check if a string is empty
A star_operation is new?
Is a scd dimension
Join a flat table with a lookup table
Get line last operation
Load star_database (from a RDS file)
Transform a flat table into a look up table
Multiple value key
Name with nexus
multistar S3 class
Prepare the instances table implemented by a tibble to join
Purge instances of a dimension
Purge instances of dimensions
Purge instances of dimensions
Import flat table file
Import all flat table files in a folder
Get line last operation
Refresh deployments
Remove instance if all measures are na
Remove duplicate dimension rows
Remove instances without measures
Replace instance values
Replace empty values with the unknown value
Replace empty values with the unknown value
Replace names
Replace strings
Replace unknown values with the given value
Define a role playing dimension and its associated dimensions
Transform role playing dimensions in constellation
Run query
Do all fact tables have the same granularity?
Select attributes of a flat table
Select dimension
Select fact
Select instances of a flat table by value
Select instances of a flat table by comparison
Select measures of a flat table
Separate measures in flat tables
Rename attributes
Set geographic layer
Rename measures
Set variables layer
Share dimension instance operations between all star_database object...
Share the given dimensions in the database
From a vector of dimensions, leave only one of each rpd.
Transform names according to the snake case style
Transform names according to the snake case style
Transform names according to the snake case style
star_database S3 class
Creates a star_database adding previous operations
star_operation S3 class
star_query S3 class
star_schema S3 class
Get the representation to output
Transforms string into a vector of strings.
Summarize geometry of a layer
Transform attribute format
Transform attribute values into measure names
For each row, add a vector of values
Transform to attribute
Transform to measure
Transform measure names into attribute values
Unify facts and dimensions in a flat table
Unify lists of dimension names if there are any in common
Update a flat table according to another structure
Validate attribute names
Validate dimension attributes
Validate dimension names
Validate fact names
Validate lookup parameters
Validate measure names
Validate names
vector to string for presentation
Transforms a vector of strings into a string.
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 ROLAP (Relational On-Line Analytical Processing) star database. The main objective of the package is to allow the definition of these transformations easily. The implementation of the multidimensional database obtained can be exported to work with multidimensional analysis tools on spreadsheets or relational databases.
Useful links