Difference between revisions of "Software Description"

From SICDB Doc
Jump to navigation Jump to search
(Created page with "== Introduction == We provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats. To install our software refer to the Get Started page. == Software Components == === MySQL Server Community Edition === MySQL is an open-source relational database managment system.<ref>https://en.wikipedia.org/wiki/MySQL</ref> === phpMyAdmin === PhpMyAdmin is one of the...")
 
Line 1: Line 1:
== Introduction ==
== Introduction ==


We provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats.  
Working with medium sized datasets like SICdb, containing billions of entries, may present a challenge to work with. Therefore we provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats.  
 
 


To install our software refer to the [[Get Started]] page.
To install our software refer to the [[Get Started]] page.

Revision as of 11:42, 9 October 2022

Introduction

Working with medium sized datasets like SICdb, containing billions of entries, may present a challenge to work with. Therefore we provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats.


To install our software refer to the Get Started page.

Software Components

MySQL Server Community Edition

MySQL is an open-source relational database managment system.[1]

phpMyAdmin

PhpMyAdmin is one of the most popular open source MySQL administration tools.[2]

RooDataServer

RooDataServer is the software we created to import, view and export data from a relational dataset like SICdb.

Core Features

  • Import the dataset
  • Create and edit queries using predefined fields
  • Perform quick statistics to validate query before export
  • Export to various file formats (.csv, .xlsx, .r (R Studio), .sqlite3, more following)

Installation and running

The environment can be installed fully preconfigured to use in any modern browser. Refer to Get Started for further information.