Drug outcome prediction is one of the biggest challenges in Big Data world. With various technologies used to collect and store data and even more different storage formats it is essential to have a unified tool that will allow medical specialists to do their research with minimal knowledge of underlying technology.
We were approached by a customer who wanted to build a GUI that will allow its users to build complex queries to OMOP Common Database Model (CDM) using quite simple Web-based interface that should be also capable of showing the results of built queries giving user an insight of what data was done under the hood.
We worked in collaboration with some medical experts to build a user experience which will match the needs of researchers as close as possible. The tool we created is capable of working with several CDM versions and various storage technologies. We were able to reproduce most famous discoveries in drug outcome prediction using our simple GUI.
The core of our application is SQL builder which should support quite complex queries and various platforms. So for the base technology we’ve chosen Python and SQL-Alchemy framework famous for its strong database abstraction layer. This core was then integrated into a quite simple Web application developed using Django framework.
Hi, we are Sciforce - a company where the integration of various branches of science builds up a powerful force to create robust software solutions. Working at the intersection of Computer Science with other technical, natural and humanitarian sciences let us go beyond traditional IT services and become both technical and scientific forces to our customers.
