Logo des Repositoriums
 

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

dc.contributor.authorShi, Lei
dc.contributor.authorJong, Lenneke
dc.contributor.authorMueller, Wolfgang
dc.contributor.authorAlgaa, Enkhjargal
dc.contributor.editorHeiß, Hans-Ulrich
dc.contributor.editorPepper, Peter
dc.contributor.editorSchlingloff, Holger
dc.contributor.editorSchneider, Jörg
dc.date.accessioned2018-11-27T10:00:34Z
dc.date.available2018-11-27T10:00:34Z
dc.date.issued2011
dc.description.abstractSABIO-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”.en
dc.identifier.isbn978-88579-286-4
dc.identifier.pissn1617-5468
dc.identifier.urihttps://dl.gi.de/handle/20.500.12116/18872
dc.language.isoen
dc.publisherGesellschaft für Informatik e.V.
dc.relation.ispartofINFORMATIK 2011 – Informatik schafft Communities
dc.relation.ispartofseriesLecture Notes in Informatics (LNI) - Proceedings, Volume P-192
dc.title50x faster: speeding up an SQL-based legacy system with few changesen
dc.typeText/Conference Paper
gi.citation.endPage159
gi.citation.publisherPlaceBonn
gi.citation.startPage159
gi.conference.date4.-7. Oktober 2011
gi.conference.locationBerlin
gi.conference.sessiontitleRegular Research Papers

Dateien

Originalbündel
1 - 1 von 1
Lade...
Vorschaubild
Name:
159.pdf
Größe:
16.08 KB
Format:
Adobe Portable Document Format