loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
19th International Conference on Scientific and Statistical Database Management (SSDBM 2007)
Banff, Alberta, Canada
July 09-July 11
ISBN: 0-7695-2868-6
M. Ivanova, Centrum voor Wiskunde en Informatica, Netherlands
N. Nes, Centrum voor Wiskunde en Informatica, Netherlands
R. Goncalves, Centrum voor Wiskunde en Informatica, Netherlands
M. Kersten, Centrum voor Wiskunde en Informatica, Netherlands
This paper presents our experiences in porting the Sloan Digital Sky Survey(SDSS)/ SkyServer to the state-of- the-art open source database system MonetDB/SQL. SDSS acts as a well-documented benchmark for scientific database management. We have achieved a fully functional prototype for the personal SkyServer, to be downloaded from our site. The lessons learned are 1) the column store approach of MonetDB demonstrates a great potential in the world of scientific databases. However, the application also challenged the functionality of our implementation and revealed that a fully operational SQL environment is needed, e.g. including persistent stored modules; 2) the initial performance is competitive to the reference platform, MS SQL Server 2005, and 3) the analysis of SDSS query traces hints at several techniques to boost performance by utilizing repetitive behavior and zoom-in/zoom-out access patterns, that are currently not captured by the system.
Citation:
M. Ivanova, N. Nes, R. Goncalves, M. Kersten, "MonetDB/SQL Meets SkyServer: the Challenges of a Scientific Database," ssdbm, pp.13, 19th International Conference on Scientific and Statistical Database Management (SSDBM 2007), 2007
Usage of this product signifies your acceptance of the Terms of Use.