eCite Digital Repository

50x faster: speeding up an SQL-based legacy system with few changes

Citation

Shi, L and Jong, L and Mueller, W and Algaa, E, 50x faster: speeding up an SQL-based legacy system with few changes, Lecture Notes in Informatics: Informatik 2011, 4-7 October 2011, Berlin, Germany, pp. 1-11. ISBN 978-3-88579-286-4 (2011) [Refereed Conference Paper]


Preview
PDF
Restricted - Request a copy
701Kb
  

Copyright Statement

Copyright unknown

Official URL: http://www.informatik2011.de/

Abstract

   SABIO-RK (http://sabio.h-its.org/) is a database for reaction kinetic data. Its complex schema led to slow querying. The challenge described in this paper is how to improve the speed with as few as possible changes in the time tested SABIORK code. The dilemma of whether to rewrite a whole system or to best reuse the expertise embodied in existing code appears often in existing, grown academic bio software solutions. We describe our solution that uses the existing SQL database for consistent data storage, and uses inverted indexes for fast retrieval. We further outline how we migrated to a new interface and RESTful web services in order to improve SABIO-RK code reuse and standards compliance.
   The work presented in this paper has been partly funded by the DFG project "Integrierte webbasierte Forschungsinfrastruktur zur Speicherung und Bereitstellung quantitativer zeitaufgeloester Daten im Laborkontext und fuer die Wissenschaftsffentlichkeit".

Item Details

Item Type:Refereed Conference Paper
Keywords:databases, web services, legacy systems
Research Division:Information and Computing Sciences
Research Group:Computer Software
Research Field:Computer Software not elsewhere classified
Objective Division:Expanding Knowledge
Objective Group:Expanding Knowledge
Objective Field:Expanding Knowledge in the Information and Computing Sciences
Author:Jong, L (Dr Lenneke Jong)
ID Code:102788
Year Published:2011
Deposited By:IMAS Research and Education Centre
Deposited On:2015-09-04
Last Modified:2018-03-14
Downloads:0

Repository Staff Only: item control page