rolap - Obtaining Star Databases 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 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.

Last updated 11 months ago

6.42 score 2 stars 1 packages 25 scripts 276 downloads

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.

Last updated 7 months ago

6.36 score 7 stars 2 packages 11 scripts 630 downloads

when - Definition of Date and Time Dimension Tables

In Multidimensional Systems the When dimension allows us to express when the analysed facts have occurred. The purpose of this package is to provide support for implementing this dimension in the form of date and time tables for Relational On-Line Analytical Processing star database systems.

Last updated 11 months ago

6.28 score 1 stars 2 packages 158 scripts 162 downloads

geomultistar - Multidimensional Queries Enriched with Geographic Data

Multidimensional systems allow complex queries to be carried out in an easy way. The geographical dimension, together with the temporal dimension, plays a fundamental role in multidimensional systems. Through this package, vector geographic data layers can be associated to the attributes of geographic dimensions, so that the results of multidimensional queries can be obtained directly as vector layers. The multidimensional structures on which we can define the queries can be created from a flat table or imported directly using functions from this package.

Last updated 4 months ago

5.08 score 2 stars 1 packages 8 scripts 227 downloads

satres - Grouping Satellite Bands by Spectral and Spatial Resolution

Given raster files directly downloaded from various websites, it generates a raster structure where it merges them if they are tiles of the same scene and classifies them according to their spectral and spatial resolution for easy access by name.

Last updated 1 months ago

4.70 score 9 scripts 199 downloads

geodimension - Definition of Geographic Dimensions

The geographic dimension plays a fundamental role in multidimensional systems. To define a geographic dimension in a star schema, we need a table with attributes corresponding to the levels of the dimension. Additionally, we will also need one or more geographic layers to represent the data using this dimension. The goal of this package is to support the definition of geographic dimensions from layers of geographic information related to each other. It makes it easy to define relationships between layers and obtain the necessary data from them.

Last updated 11 months ago

4.70 score 2 stars 8 scripts 247 downloads

flattabler - Obtaining a Flat Table from Pivot Tables

Transformations that allow obtaining a flat table from reports in text or Excel format that contain data in the form of pivot tables. They can be defined for a single report and applied to a set of reports.

Last updated 7 months ago

4.60 score 2 stars 7 scripts 287 downloads

geogenr - Generator from American Community Survey Geodatabases

The American Community Survey (ACS) <https://www.census.gov/programs-surveys/acs> offers geodatabases with geographic information and associated data of interest to researchers in the area. The goal of this package is to generate objects that allow us to access and consult the information available in various formats, such as in 'GeoPackage' format or in multidimensional 'ROLAP' (Relational On-Line Analytical Processing) star format.

Last updated 7 months ago

openjdk

4.48 score 2 stars 8 scripts 200 downloads

moodef - Defining 'Moodle' Elements from R

The main objective of this package is to support the definition of 'Moodle' elements taking advantage of the power that R offers. In this first version, it allows the definition of questions to be included in the question bank.

Last updated 9 months ago

4.40 score 1 stars 4 scripts 148 downloads

rexer - Random Exercises and Exams Generator

The main purpose of this package is to streamline the generation of exams that include random elements in exercises. Exercises can be defined in a table, based on text and figures, and may contain gaps to be filled with provided options. Exam documents can be generated in various formats. It allows us to generate a version for conducting the assessment and another version that facilitates correction, linked through a code.

Last updated 9 months ago

4.30 score 4 scripts 129 downloads