Learn R Programming

Andromeda

Andromeda is part of HADES.

Introduction

AsynchroNous Disk-based Representation of MassivE DAta (ANDROMEDA): An R package for storing large data objects. Andromeda allow storing data objects on a local drive, while still making it possible to manipulate the data in an efficient manner.

Features

  • Allows storage of data objects much larger than what can fit in memory.
  • Integrates with dplyr package for data manipulation.
  • Objects are stored in a temporary location on the local file system.
  • Ability to save and load the objects to a compressed file in a permanent location on the local file system.

Examples

library(Andromeda)
bigData <- andromeda()

# Add some 'big' data:
bigData$cars <- cars

# Manipulate using dplyr:
bigData$cars %>% filter(speed > 10) %>% count() %>% collect()
# # A tibble: 1 x 1
#       n
#   <int>
# 1    41

saveAndromeda(bigData, "bigData.zip")
close(bigData)

Technology

The Andromeda package is an R package wrapped around RSQLite.

System Requirements

Running the package requires R.

Installation

To install the latest development version, install from GitHub:

install.packages("devtools")
devtools::install_github("ohdsi/Andromeda")

User Documentation

Documentation can be found on the package website.

Support

  • Developer questions/comments/feedback: OHDSI Forum
  • We use the GitHub issue tracker for all bugs/issues/enhancements

Contributing

Read here how you can contribute to this package.

License

Andromeda is licensed under Apache License 2.0

Development

Andromeda is being developed in R Studio.

Development status

Beta. Use at your own risk.

Copy Link

Version

Install

install.packages('Andromeda')

Monthly Downloads

8,939

Version

1.1.0

License

Apache License 2.0

Issues

Pull Requests

Stars

Forks

Maintainer

Martijn Schuemie

Last Published

July 24th, 2025

Functions in Andromeda (1.1.0)

listIndices

List all indices on an Andromeda table
names<-.tbl_Andromeda

Set column names of an Andromeda table
names.tbl_Andromeda

Get the column names of an Andromeda table
isValidAndromeda

Check whether an Andromeda object is still valid
removeIndex

Removes an index from an Andromeda table
loadAndromeda

Load Andromeda from file
restoreDate

Restore dates
saveAndromeda

Save Andromeda to file
restorePosixct

Restore timestamps
andromeda

Create an Andromeda object
createIndex

Create an index on one or more columns in an Andromeda table
batchTest

Apply a boolean test to batches of data in an Andromeda table and terminate early
getAndromedaTempDiskSpace

Get the available disk space in Andromeda temp
appendToTable

Append to an Andromeda table
Andromeda-class

The Andromeda class
batchApply

Apply a function to batches of data in an Andromeda table
flushAndromeda

Flush changes to disk
copyAndromeda

Copy Andromeda
groupApply

Apply a function to groups of data in an Andromeda table
isAndromedaTable

Is the object an Andromeda table?
Andromeda-package

Andromeda: Asynchronous Disk-Based Representation of Massive Data
names<-,Andromeda-method

Set table names in an Andromeda object
isAndromeda

Check whether an object is an Andromeda object