Pilar de Teodoro
Database Expert and Software Engineer at Aurora/ESA
Pilar de Teodoro is physicist and works at the European Space Agency (ESA)/ESAC Science Data Centre (ESDC) in Madrid, Spain. After many years working in Oracle Corp., she moved to the European Space Agency working first for the Gaia mission being in charge of the databases for the largest survey of objects in the universe dealing with hundreds of Terabytes of data. After Gaia, she joined the ESDC team where all archives from the different ESA missions are kept. PostgreSQL is the database system most used in the science archives helping the the singularity of every space mission and it is the pillar of the ESA Sky project.
Upcoming presentations
No upcoming presentations...
Past presentations
Will partitioning and sharding improve performance?
We will present the results obtained from the tests ran at the ESA Science Data Center to join 2 tables storing star information based on their position in the sky under the use of open source Greenplum v.6.
What is the best solution to join 2 very big tables (>1TB) with billion rows and hundreds of columns with the help of distribution and partitioning? We have analysed different distribution and partition methods to achieve the best performance for a crossmatch, that is, identifying different rows from 2 tables (star catalogues) referring to the same star. Crossmatching helps scientists around th...
ESA Sky is the science-driven discovery portal developed by engineers and scientists working at the European Space Agency to allow users to explore the multi-wavelength sky and to seamlessly retrieve science-ready data in all ESA Astronomy mission archives from a web application without prior-knowledge of any of the missions. The first public beta of the service has been released, future rele...