SQLShare: Interactive DB-as-a-Service

SQLShare is a database service aimed at removing the obstacles to using relational databases: installation, configuration, schema design, tuning, data ingest, and even application design. You simply upload your data and immediately start querying it. One of the main lessons from SQLShare is that a relatively minor set of changes to how existing database technology is packaged and delivered is sufficient to convince science and data science users to adopt SQL in their day-to-day data manipulation and analysis tasks, potentially displacing script-and-file based approaches. We analyzed the handwritten SQL queries and found that the features of SQLShare were instrumental in attracting new kinds of ad hoc queries and that the SQLShare workload is demonstrably more diverse than a comparable public workload in science, and that users are writing very complex queries by hand.

The query log can be downloaded from SQLShare data release page.