No articles match
tab2xml: XML Generation from Tables1 years ago
Introduction | Content | Example: Mondrian Schema | Scheme decomposition | Root of the schema template: schema_template.xml | Cube | Table | Dimension | Hierarchy | Level | Measure | CalculatedMember | CalculatedMemberProperty | Validation of Relational Schema and Template Consistency | Usage Example | Generate the Schema | Conclusions
moodef: Defining Moodle Quizzes from R1 years ago
Introduction | Question Definition Styles | Simple Style | Extended Style | Question Definition Process | Define the category | Define questions | Definition function | Definition using a CSV file or an Excel file | Definition using a data frame | Generate the XML file | Kind of questions | Essay (essay: '') | True/False (truefalse: '') | Numerical (numerical: '') | Short Answer (shortanswer: '') | Multiple Choice (multichoice: '') | Ordering (ordering<|>h: h or ordering<|>v: v) | Drag and Drop into Text (ddwtos: '') and Select Missing Words (gapselect: x) | Matching (matching: '') | Drag and Drop Markers (ddmarker: '') | Conclusions
Geographic Data Transformation, Storage, and Publication2 years ago
Introduction | Datasets | sigugr.gpkg | sat.tif | mdt | clc.gpkg | Data Transformation | Other transformations | Clipping | Data Storage in PostGIS | Layer storage | Style management | Data Publication on GeoServer | Conclusions
CORINE Land Cover Data and Styles2 years ago
Introduction | CORINE Land Cover | The clc package | Document Structure | Data Included in the Package | Class-Based Operations | Create an object of class clc | Plot of Vector CLC Data | Clipping CLC Data to a Region of Interest | Saving CLC Data and Styles | Copying Styles | Converting CLC Data to Raster Format | Applications of the Generated Raster | Visualizing the Raster Data | Getting the Raster | Conclusions
rexer: Random Exercises and Exams Generator2 years ago
Introduction | Exercises and exams definition process | Object creation | Exercise definition | Definition of answers in exercises | Template definition | Generation of the exam instances | Conclusions
geodimension: Definition of Geographic Dimensions2 years ago
Introduction | An illustrative example | Definition of levels | Definition of relationships | Obtaining information | Conclusions
starschemar Transformation Operations2 years ago
Introduction | Dimensional modelling | Star schema and constellation definition | Star schema definition | Star schema rename | Constellation definition | Cleaning and conforming data | Obtaining components | Star schema | Constellation | Definition of updates | Updates application | Dimension enrichment | Incremental refresh | Exporting results | multistar | Query functions | Conclusions
starschemar: Obtaining Star Schemas from Flat Tables2 years ago
Introduction | Dimensional modelling and star schemas | Dimensional modelling | Dimensions and dimension attributes | Facts and measures | Star schemas | Dimension tables | Surrogate keys | Special dimensions | Fact table | Primary key | Grain | Multiple fact tables | Conformed dimensions | Additional operations | Cleaning and conforming data | Dimension enrichment | Incremental refresh | An illustrative example | Starting data sets | Dimensional modelling data according to age range | Dimensional modelling data according to cause | Star schema definition and transformation: Constellations | Star schema definition for data according to age range | Star schema definition for data according to cause | Star schema transformation, cleaning and conforming data | Star schema rename | Definition of updates | Updates in the where dimension | Updates in the when dimension | Updates in the who dimension | Updates application | Enrich the who dimension | Enrich the where dimension | Constellation definition | Refresh operations for data according to age range | Refresh operations for data according to cause | Filter and purge operations | Exporting results | Star schema | Constellation | multistar | Query functions | Conclusions | References
Generating the When Dimension based on date and time tables3 years ago
Introduction | Definition process | Creating an object | Definition of general aspects | Definition of instances | Selection of levels and attributes | Generation of the result | Getting the dimension table | Other configuration options | Dimension table features | Table name | Surrogate key | Renaming the attributes | Names of the parts of the day | Configuration of day and week levels | The first day of the week | Numbering of weeks in the year | Get date range of weeks | Change the definition function of an attribute | Conclusions | Bibliography
Incremental refresh of star databases3 years ago
Introduction | Starting data sets | Generation of star database refresh structures | Refresh structures | Transformation code | Instances included in the structure | Incremental refresh | Existing fact instances | Incremental refresh operation | Changes in transformation operations | New transformation function | Conclusions
Obtaining and transforming flat tables3 years ago
Introduction | Data sets | 122 US Cities Mortality Reporting System | Database of US cities | Flat tables | Create flat_table objects | flat_table attributes and measures | Mortality Reporting System | Measures | Attributes | US cities | Capital status | Joining flat tables | Joining US cities and capital status tables | Joining Mortality Reporting System and US cities tables | Flat table transformation | Separate measures | Transform column names | Transform measure names into attribute values | Definition of the star databases | MRS Cause star database | MRS Age star database | Constellation | Conclusions
Performing Multidimensional Queries (also Including Geographic Attributes)3 years ago
Introduction | Stars and constellations | Include geographic information layers | Query functions | star_query() | select_fact() | select_dimension() | filter_dimension() | run_query() | Exploitation of the result | Obtaining layers with geographic information | Get a geolayer object | Operations on variables | Data representation | Conclusions
Basics and getting started with the rolap package3 years ago
Introduction | Dimensional modelling and star databases | Dimensional modelling | Dimensions and dimension attributes | Facts and measures | Star databases | Dimension tables | Surrogate keys | Special dimensions | Fact table | Primary key | Grain | Constellation | Conformed dimensions | An illustrative example | Data sets | Star Schema | Dimensions | Facts | Rename fact measures and dimension attributes | Constellations | Definition of star databases | Constellation definition | Export results | tibble list | dm object | Single tibble list | Conclusions | References
Star Database Export Features3 years ago
Introduction | Example star_database object | Select only one star database | dm class object | List of tibble objects | From component tables | From flat tables | Relational database | xlsx file | csv files | geomultistar::multistar object | Conclusions
Queries on Multidimensional Data Enriched with Geographic Information3 years ago
Introduction | Get a multistar object | Get a multistar object from the rolap package | Generate a multistar object | Add fact tables | Add dimension tables | Relate dimensions | Additional operations on the multistar object | geomultistar query functions | dimensional_query() | select_fact() | select_dimension() | filter_dimension() | run_query() | Add geographic information | Define geographic dimensions and attributes | Run queries adding geographic information | Get wide tables | Conclusions
Generator from American Community Survey (ACS) Geodatabases3 years ago
Introduction | American Community Survey 5-Year Estimates | An illustrative example | Obtaining the data | Data selection | Generation of results | acs_5yr_geo class format | rolap package objects | Conclusions
Deployment of star databases with incremental refresh3 years ago
Introduction | Star databases and deployments | Star databases | Deployment | Contents of the constellation and the relational database | Another deployment | Incremental refresh | New data | Incremental refresh process | Incremental refresh result | Star database | First deployment | Second deployment | Checking star database copy synchronization | Conclusions
Definition of role-playing and role dimensions3 years ago
Introduction | Role-playing and role dimensions in a star database | Flat table with the initial data | Star schema | Star database | Star database with a role-playing dimension and role dimensions | Role-playing and role dimensions in a constellation | Second star database | Constellation | Conclusions
Selecting and transforming satellite bands3 years ago
Introduction | Data and object creation | Data | Creation of objects of the satres class | Results obtained | Band selection | Get available bands | Select bands | Other transformation functions | Merge tiles | Clip bands | Conclusion
Grouping satellite bands by spectral and spatial resolution3 years ago
Introduction | An illustrative example | Getting the data | Merging and classifying data | Using the results | Conclusions
Transforming a pivot table into a flat table with the flattabler package3 years ago
Introduction | An illustrative example | Pivot table | Obtaining a flat table | Transforming a set of pivot tables | Pivot table operations | Pivot table import | Operations that return an object | Operations that return a list of objects | Pivot table definition | Define pivot table characteristics | Remove rows and columns | Pivot table transformation | Transform labels | Transform values | Flat table generation | Generation from a pivot table | Generation from a list of pivot tables | Conclusions