CemBase - cement database from Nanocem
The database CemBase has been developed since 2012 during a core project 10 within Nanocem consortium. It contains microstructure characterization of ordinary and blended cement pastes and some mortars, often complemented with compressive strength and elastic moduli. At a glance, CemBase covers- Mix designs for 83 pastes and 27 mortars
- Time point data for 297 pastes and 101 mortars
- Water/binder ratios 0.16-0.69
- Compressive strength 0-169 MPa
- Young's moduli 0-41 MPa
CemBase as an Excel spreadsheet
Output from CemBase can be carried out as an Excel spreadsheet - download the latest version from 2016-10-20. It contains several duplicities in rows due to postgreSQL's join of tables. However, this output is easy-to-use with standard excel functionality for sorting, plotting etc.CemBase as a postgreSQL database
The current version of CemBase is postgreSQL 9.3. It can be installed on a postgreSQL server - download the latest version from 2016-10-20. The structure of the CemBase comprises of mutually interconnected tables; tbl_references, tbl_material, tbl_type_mat, tbl_mixture, tbl_mechtest. More description is in the following figure.
In order to clone CemBase on a local postgreSQL server, one needs to
- Create a database with name Blends, e.g. $ sudo -i -u postgres createdb Blends
- Unpack a file, e.g. $ gunzip 2016-10-20-Backup.gz
- Upload a database as a user, e.g. $ psql -p 5432 -h localhost -U _UserName -d Blends -f /home/UserName/2016-10-20-Backup
- Grant priviledges for writing for other users, e.g.
$ sudo -i -u postgres psql -d Blends $ GRANT ALL ON tbl_material, tbl_mechtest, tbl_mixture, tbl_references, tbl_type_mat TO _UserOne;
$ sudo -i -u postgres psql -d Blends $ \d tbl_materialIt is possible to read/write using a graphical pgAdmin tool. Alternatively, a python psycopg2 module is very handy for read/write access and for executing postgreSQL's commands, e.g.
import psycopg2
import psycopg2.extras
import base64
con = psycopg2.connect(user=userName, host=hostName, database="Blends", password=pw)
cur = con.cursor(cursor_factory=psycopg2.extras.DictCursor)
cur.execute("""SELECT compr_str, w_b, age_mechtest FROM tbl_mixture INNER JOIN tbl_mechtest ON mixture_id=mixture_id_mechtest ORDER BY compr_str""")
row=cur.fetchall()
print(row)
Acknowledgement and citing
The database is provided as it is. You may use data from the database once you acknowledge origial data source (from CemBase etries under author, title, journal, year), or cite the articleM. Hlobil, V. Šmilauer, G. Chanvillard: Micromechanical multiscale fracture model for compressive strength of blended cement pastes. Cement and Concrete Research. 2016, vol. 83, p. 188-202
and acknowledge Nanocem consortium.