Difference between revisions of "Software Description"
(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...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Introduction == | == 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. | To install our software refer to the [[Get Started]] page. | ||
| Line 24: | Line 26: | ||
* Perform quick statistics to validate query before export | * Perform quick statistics to validate query before export | ||
* Export to various file formats (.csv, .xlsx, .r (R Studio), .sqlite3, more following) | * Export to various file formats (.csv, .xlsx, .r (R Studio), .sqlite3, more following) | ||
Import, Export, Statistics, Charts and more are expendable. Soon it will be possible to directly run python scripts! | |||
== Installation and running == | == Installation and running == | ||
The environment can be installed fully preconfigured to use in any modern browser. Refer to [[Get Started]] for further information. | The environment can be installed fully preconfigured to use in any modern browser. Refer to [[Get Started]] for further information. | ||
Latest revision as of 16:57, 9 November 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)
Import, Export, Statistics, Charts and more are expendable. Soon it will be possible to directly run python scripts!
Installation and running
The environment can be installed fully preconfigured to use in any modern browser. Refer to Get Started for further information.