No packages match

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

openjdk

6.37 score 7 stars 1 dependents 32 scripts 623 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

openjdk

5.93 score 1 stars 2 dependents 285 scripts 162 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

4.94 score 8 stars 11 scripts 611 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.48 score 2 stars 1 dependents 9 scripts 172 downloads

clc - CORINE Land Cover Data and Styles

Streamline the management, analysis, and visualization of CORINE Land Cover data. Addresses challenges associated with its classification system and related styles, such as color mappings and descriptive labels.

Last updated

4.26 score 1 dependents 12 scripts 208 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

4.04 score 11 scripts 122 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

4.00 score 2 stars 7 scripts 236 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

openjdk

4.00 score 2 stars 9 scripts 310 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

4.00 score 2 stars 9 scripts 350 downloads

tab2xml - XML Generation from Tables

Converting structured data from tables into XML format using predefined templates ensures consistency and flexibility, making it ideal for data exchange, reporting, and automated workflows.

Last updated

3.70 score 1 stars 4 scripts 147 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 quizzes to be included in the question bank.

Last updated

openjdk

3.70 score 1 stars 4 scripts 323 downloads

sigugr - Workflow for Geographic Data

Streamlines geographic data transformation, storage and publication, simplifying data preparation and enhancing interoperability across formats and platforms.

Last updated

3.70 score 1 stars 4 scripts 167 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

openjdk

3.70 score 4 scripts 268 downloads