dbms-comparison
Science Score: 44.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
✓CITATION.cff file
Found CITATION.cff file -
✓codemeta.json file
Found codemeta.json file -
✓.zenodo.json file
Found .zenodo.json file -
○DOI references
-
○Academic publication links
-
○Academic email domains
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (7.8%) to scientific vocabulary
Repository
Basic Info
- Host: GitHub
- Owner: rdj94
- Language: Python
- Default Branch: main
- Size: 32.2 KB
Statistics
- Stars: 0
- Watchers: 1
- Forks: 0
- Open Issues: 0
- Releases: 0
Metadata Files
README.md
mongodb mysql postgresql comparison
This repository is a repository that is implemented to experiment with spatial queries on the geolife dataset.
Schemas exist for geolife datasets in each dbms (mysql, postgresql, mongodb) and contain DML experimental results for index, non-index.
For implementation, I implemented update, delete, and spatial query excluding the insert part in the code in the repository of those who referred.
Setup
Prerequisites:
- Python
- Docker-compose
Steps:
- Make a copy of the
.env-templatefile and rename it.env - Download the dataset from https://www.microsoft.com/en-us/research/publication/geolife-gps-trajectory-dataset-user-guide/ and place the user folders (000-181) in the folder
./data
Experiment
To run the experiments with the CLI:
```bash
Start Docker containers for all DBMSs
docker-compose --compatibility up
Drop and create SQLite tables for storing experimental results
py cli.py prepare
Run experiment with desired iterations and total size
py cli.py run -i 3 -n 5000 or sh ./run.sh ```
The results are stored in a SQLite database, which can be easily accessed with Python or a GUI tool like DB Browser.
Reference
Owner
- Name: Ryu_dong_jun
- Login: rdj94
- Kind: user
- Repositories: 2
- Profile: https://github.com/rdj94
Citation (CITATION.cff)
# This CITATION.cff file was generated with cffinit.
# Visit https://bit.ly/cffinit to generate yours today!
cff-version: 1.2.0
title: >-
Insertion speed of indexed spatial data: comparing
MySQL, PostgreSQL and MongoDB
message: >-
If you use this software, please cite it using the
metadata from this file.
type: software
authors:
- given-names: Lars-Olav
family-names: Vågene
email: larsolov@stud.ntnu.no
- given-names: Eirik
family-names: Schøien
email: eirischo@stud.ntnu.no
- given-names: Christian
family-names: Axell
email: cdaxell@stud.ntnu.no
- given-names: Ingvild
family-names: Løver Thon
email: ingvlt@stud.ntnu.no
- given-names: Lukas
family-names: Tveiten
email: lukasnt@stud.ntnu.no