Computer Science – Databases
Scientific paper
2004-03-12
Comput.Sci.Eng. 5 (2003) 16-29
Computer Science
Databases
Scientific paper
The Sloan Digital Sky Survey Science Archive is the first in a series of multi-Terabyte digital archives in Astronomy and other data-intensive sciences. To facilitate data mining in the SDSS archive, we adapted a commercial database engine and built specialized tools on top of it. Originally we chose an object-oriented database management system due to its data organization capabilities, platform independence, query performance and conceptual fit to the data. However, after using the object database for the first couple of years of the project, it soon began to fall short in terms of its query support and data mining performance. This was as much due to the inability of the database vendor to respond our demands for features and bug fixes as it was due to their failure to keep up with the rapid improvements in hardware performance, particularly faster RAID disk systems. In the end, we were forced to abandon the object database and migrate our data to a relational database. We describe below the technical issues that we faced with the object database and how and why we migrated to relational technology.
Gray Jim
Kunszt Peter Z.
Szalay Alexander S.
Thakar Aniruddha R.
No associations
LandOfFree
The Sloan Digital Sky Survey Science Archive: Migrating a Multi-Terabyte Astronomical Archive from Object to Relational DBMS does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.
If you have personal experience with The Sloan Digital Sky Survey Science Archive: Migrating a Multi-Terabyte Astronomical Archive from Object to Relational DBMS, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and The Sloan Digital Sky Survey Science Archive: Migrating a Multi-Terabyte Astronomical Archive from Object to Relational DBMS will most certainly appreciate the feedback.
Profile ID: LFWR-SCP-O-161383