Creating Local Instances for ATSD and Axibase Collector using Docker
Below is a step-by-step guide for setting up local instances of Axibase Time Series Database (ATSD) and Axibase Collector on a Docker host.
docker-compose.ymlfile to launch the ATSD and Collector container bundle.
curl -o docker-compose.yml https://raw.githubusercontent.com/axibase/atsd-use-cases/master/research/us-mortality/resources/docker-compose.yml
Launch containers by specifying the built-in collector account credentials used by Axibase Collector to insert data into ATSD.
export C_USER=myuser; export C_PASSWORD=mypassword; docker-compose pull && docker-compose up -d
Access the ATSD user interface by navigating to
https://localhost:8443. Note that it may take several minutes for the containers to launch and for ATSD to become available. Create a username and password.
Log in to ATSD with your newly created username and password.
Navigate to the Entities tab in ATSD. The job creates a new entity in ATSD named
Open Data > Replacement Tables.
Upload the files included in this repository (
youngstown-2010-population) into a Replacement Table. Click Save.
city-sizecontains 2015 population figures for each of the 122 cities included in this dataset.
us-regionsis a list of all of the regions (i.e. 1=New-England, 2=Middle-Atlantic etc.).
youngstown-2010-populationare used to compute mortality statistics.
Navigate to Data > CSV Parsers and import
After uploading the parser import
This file contains population estimates from
https://www.census.gov/data.htmlfor all 122 cities for 1960, 1970, 1980, 1990, 2000, 2010, and 2015. Save a local copy of this file. Open the
US_population_all_citiesparser and upload
Click To submitted tasks button.
If the upload is successful, ATSD notifies:
Next, navigate to Metrics and enter
us.population into the Search Bar.