starschemar: Obtaining Stars from Flat Tables

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.

Version: 1.2.5
Depends: R (≥ 2.10)
Imports: dplyr, generics, methods, purrr, rlang, snakecase, stats, tibble, tidyr
Suggests: knitr, pander, rmarkdown, testthat
Published: 2024-05-02
DOI: 10.32614/CRAN.package.starschemar
Author: Jose Samos ORCID iD [aut, cre], Universidad de Granada [cph]
Maintainer: Jose Samos <jsamos at ugr.es>
BugReports: https://github.com/josesamos/starschemar/issues
License: MIT + file LICENSE
URL: https://josesamos.github.io/starschemar/, https://github.com/josesamos/starschemar
NeedsCompilation: no
Language: en-GB
Materials: README NEWS
CRAN checks: starschemar results

Documentation:

Reference manual: starschemar.pdf
Vignettes: starschemar: Obtaining Star Schemas from Flat Tables
starschemar Transformation Operations

Downloads:

Package source: starschemar_1.2.5.tar.gz
Windows binaries: r-devel: starschemar_1.2.5.zip, r-release: starschemar_1.2.5.zip, r-oldrel: starschemar_1.2.5.zip
macOS binaries: r-release (arm64): starschemar_1.2.5.tgz, r-oldrel (arm64): starschemar_1.2.5.tgz, r-release (x86_64): starschemar_1.2.5.tgz, r-oldrel (x86_64): starschemar_1.2.5.tgz
Old sources: starschemar archive

Reverse dependencies:

Reverse imports: rolap

Linking:

Please use the canonical form https://CRAN.R-project.org/package=starschemar to link to this page.