database normalisation - Githubissues

The nubase database is formatted using symbolic expressions for flagging the source of different parameters such as half-life, decay modes etc. These flags indicate things like if the decay mode hasn't been seen experimentally but is energetically allowed (?) etc. The nubase database also has units that are non-SI units, such as years, days etc for half-life. These parameters need to all be converted to SI units, and for the flags to be dealt with in a clearer way.

The database normalisation will take in the Parsed_nubase2016.xlsx file and output a .db file written using SQLite. The purpose of this is to make a easily accessibly database in a format that is used in many programming languages. This will leave the original Parsed_nubase2016.xlsx file unmodified, so others can verify the conversions in the SQLite database.

The database normalisation will be stored in the databases directory

./
├───databases
│       fyu235thermal.txt
│       Parsed_nubase2016.xlsx
│       SQLite_gen.py
│       nuclide_data.db

The nuclide_data.db will contain 2 tables, one for nuclide data and another for fission data. It will be of the form

NUCLIDE

A	Z	element	id	excess_energy_en	en_uncert	en_extrapolated	half_life_hl
`int`\| `int` \| `str` \| `str` \| `float` \| `float` \| `int bool (0, 1)` \| `float` or `str`

NUCLIDE CONT'D

hl_uncert	hl_unit	hl_relation	hl_extrapolated	j_pi	decay_mode_dm	dm_relation
`float` or `None` \| `str` or `None` \| `str` \| `int bool (0, 1)` \|`str` or `None` \| `str` or `None` \| `str` or `None`

NUCLIDE CONT'D 2

dm_branch_ratio	dm_branch_ratio_uncert	dm_extrapolated	isotope_abundance_ia	ia_uncert	isomer_excitation_energy_iee
`float` or `None` \| `float` or `None`\| `int bool (0, 1)` \| `float` or `None` \| `float` or `None` \| `float` or `None`

NUCLIDE CONT'D 3

iee_uncert	iee_extrapolated	isomer_half_life_ihl	ihl_uncert	ihl_unit	ihl_relation	ihl_extrapolated
`float` or `None` \| `int bool (0, 1)` or `None` \| `float` or `None` \| `float` or `None` \| `str` or `None` \| `str` or `None` \| `int bool (0, 1)` or `None`

NUCLIDE CONT'D 4

isomer_decay_mode_idm	idm_branch_ratio	idm_branch_ratio_uncert	idm_relation	idm_extrapolated	isomer_j_pi	isomer_T
`str` or `None` \| `float` or `None` \| `float` or `None` \| `str` or `None` \| `int bool (0, 1)` or `None` \| `str` or `None` \| `str` or `None`

FISSION YIELD

Z	A	level	yield	yield_uncert
`int`\|`int`\|`int`\| `float` \| `float`

To do:

[ ] SQL database setup
- [x] Make tables
- [x] Add data to tables
- [ ] Get data from tables
[ ] Convert units to SI units and deal with symbols

lmcc-lab / neupy