Share Email Print

Proceedings Paper

Mining the SDSS SkyServer SQL queries log
Author(s): Vitor Makiyama Hirota; Rafael Santos; Jordan Raddick; Ani Thakar
Format Member Price Non-Member Price
PDF $17.00 $21.00

Paper Abstract

SkyServer, the Internet portal for the Sloan Digital Sky Survey (SDSS) astronomic catalog, provides a set of tools that allows data access for astronomers and scientific education. One of SkyServer data access interfaces allows users to enter ad-hoc SQL statements to query the catalog. SkyServer also presents some template queries that can be used as basis for more complex queries. This interface has logged over 330 million queries submitted since 2001. It is expected that analysis of this data can be used to investigate usage patterns, identify potential new classes of queries, find similar queries, etc. and to shed some light on how users interact with the Sloan Digital Sky Survey data and how scientists have adopted the new paradigm of e-Science, which could in turn lead to enhancements on the user interfaces and experience in general. In this paper we review some approaches to SQL query mining, apply the traditional techniques used in the literature and present lessons learned, namely, that the general text mining approach for feature extraction and clustering does not seem to be adequate for this type of data, and, most importantly, we find that this type of analysis can result in very different queries being clustered together.

Paper Details

Date Published: 12 May 2016
PDF: 13 pages
Proc. SPIE 9851, Next-Generation Analyst IV, 98510S (12 May 2016); doi: 10.1117/12.2224237
Show Author Affiliations
Vitor Makiyama Hirota, National Institute for Space Research (Brazil)
Rafael Santos, National Institute for Space Research (Brazil)
Jordan Raddick, Johns Hopkins Univ. (United States)
Ani Thakar, Johns Hopkins Univ. (United States)

Published in SPIE Proceedings Vol. 9851:
Next-Generation Analyst IV
Barbara D. Broome; Timothy P. Hanratty; David L. Hall; James Llinas, Editor(s)

© SPIE. Terms of Use
Back to Top
Sign in to read the full article
Create a free SPIE account to get access to
premium articles and original research
Forgot your username?