Showing 6 of total 6 results (show query)
josesamos
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.
Maintained by Jose Samos. Last updated 1 years ago.
5 stars 6.12 score 25 scripts 1 dependentsjosesamos
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.
Maintained by Jose Samos. Last updated 11 months ago.
7 stars 5.66 score 11 scripts 2 dependents
omniacsdao
Rnumerai:Interface to the Numerai Machine Learning Tournament API
Routines to interact with the Numerai Machine Learning Tournament API <https://numer.ai>. The functionality includes the ability to automatically download the current tournament data, submit predictions, and to get information for your user.
Maintained by Eric Hare. Last updated 3 years ago.
35 stars 5.53 score 39 scripts
azure
AzureKusto:Interface to 'Kusto'/'Azure Data Explorer'
An interface to 'Azure Data Explorer', also known as 'Kusto', a fast, distributed data exploration service from Microsoft: <https://azure.microsoft.com/en-us/products/data-explorer/>. Includes 'DBI' and 'dplyr' interfaces, with the latter modelled after the 'dbplyr' package, whereby queries are translated from R into the native 'KQL' query language and executed lazily. On the admin side, the package extends the object framework provided by 'AzureRMR' to support creation and deletion of databases, and management of database principals. Part of the 'AzureR' family of packages.
Maintained by Alex Kyllo. Last updated 1 years ago.
azureazure-data-explorerazure-sdk-rbig-data-analyticskusto
18 stars 5.11 score 9 scripts
broccolito
bolt4jr:Interface for the 'Neo4j Bolt' Protocol
Querying, extracting, and processing large-scale network data from Neo4j databases using the 'Neo4j Bolt' <https://neo4j.com/docs/bolt/current/bolt/> protocol. This interface supports efficient data retrieval, batch processing for large datasets, and seamless conversion of query results into R data frames, making it ideal for bioinformatics, computational biology, and other graph-based applications.
Maintained by Wanjun Gu. Last updated 17 days ago.
4.65 score 2 scriptsjosesamos
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.
Maintained by Jose Samos. Last updated 8 months ago.
2 stars 4.48 score 8 scripts 1 dependents