Carnegie Mellon Database Application Catalog

Success	The application was successfully deployed and the system was able to run a workload and capture queries.
Download Error	The system failed to download the application's source code from the on-line repository. This could be a transient network error or the application could have been deleted.
Missing Required Files	The application did not contain the necessary files that are needed to deploy and run it. This likely means that the application is not the project type that we assumed that it was. This can occur if the crawler mis-idenfies it as a database application.
Missing Dependencies	The deployer was unable to determine what dependencies are needed to automatically deploy the application.
Database Error	The application failed to instantiate and synchronize its database properly. This can occur if there are additional manual steps that are needed prior to deployment.
Running Error	The system was able to install the dependencies needed for the application but then it experienced an unexpected error when trying to actually run it. This could because the application in its current form is broken and is thus not runnable.
No Queries	The application was successfully deployed but the system was not able to run a workload and capture queries.

Project Overview

We crawl on-line source code repositories (e.g., GitHub, Bitbucket) to find open-source database applications using common web frameworks.

Our deployment tool downloads each application, automatically determines the dependencies need to run it, and deploys it in a Vagrant sandbox.

We inject a driver in the sandbox that causes the application to interact with the database and monitor the DBMS's log to capture the workload.

We then analyze these query workloads and extrapolate information about the nature of real-world database applications.

Project Type	Found Apps	Runnable Apps	Success Rate	Updated
Django	31016	6171	19%	2017-09-28
Ruby on Rails	16654	2226	13%	2017-09-28
Node.js	1133	32	2%	2017-09-28
Drupal	287	287	100%	2017-09-21
Grails	9	9	100%	2017-09-27

Repository	Database	Result	Date
DipakPanchal/magazine_app	MySQL	Success	2016-11-21
ARBELL/my-first-blog	MySQL	Success	2016-10-28
tgmiller5/todo	MySQL	Success	2016-10-28
ategixadmin/my-first-blog	MySQL	Success	2016-10-28
Mousab/mousabWork	MySQL	Success	2016-10-28