starschemar: Obtaining Star Schemas 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 ETL (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 this package is to define transformations that allow obtaining star schemas from flat tables easily. In addition, it includes basic data cleaning, dimension enrichment, incremental data refresh and query operations, adapted to this context.

Package details

AuthorJose Samos [aut, cre, cph] (<https://orcid.org/0000-0002-4457-3439>)
MaintainerJose Samos <jsamos@ugr.es>
LicenseMIT + file LICENSE
Version1.2.0
Package repositoryView on CRAN
Installation Install the latest version of this package by entering the following in R:
install.packages("starschemar")

Try the starschemar package in your browser

Any scripts or data that you put into this service are public.

starschemar documentation built on Jan. 13, 2021, 7:33 p.m.