The dates of the updating of the database are available in the release calendar. The public database is updated at 8 a.m. on the day announced in advance in the release calendar.
New database software
Statistical database shows official statistics. For offering this service, Statistics Estonia has been using PX-Web software, which no longer meets the growing needs of users of statistics. In November of this year, Statistics Estonia will adopt a new statistical database software called .Stat, which offers many new options for providing quality information service.
Advantages of .Stat:
- table content and division by themes with a list of tables are displayed on one page;
- full-text search across the whole database;
- a filter for selecting only tables containing necessary key words;
- adjusting table layout to display only data of interest;
- customizing table rows, columns and headers;
- downloading the table in Excel, CSV, SDMX-XML or PX format;
- concepts, methodology and metadata can be found next to the table.
Technical capabilities of .Stat:
- displaying large quantities of data in one table;
- an opportunity to search for official statistics directly from one’s own information system, website, phone application, etc.;
- machine-readable interfaces, i.e. APIs, which enable to query the database for any data or their smaller components published by Statistics Estonia;
- open standards such as SDMX-XML and SDMX-JSON are available and both SOAP and REST requests are supported.
The transition will take place in three stages. In November 2017, the new software will be adopted. In the first few months, both the old and the new database will be available for use, but since the beginning of 2018, only the new one will remain available.
In the next two years, datasets will be redesigned and missing or randomly chosen classifications and code lists will be reviewed and brought into conformity with the official versions found in the statistical system.
At the end of 2019, the software will be updated, which will make the user interface simpler and faster.
The chosen database software is developed in cooperation with many other international organisations, including OECD, ILO, the statistical offices of Australia, Italy and New Zealand, the National Bank of Belgium, etc. Shared software development enables saving a considerable amount of taxpayer money and expanding the circle of specialists involved in analysis.