Universidad de Talca
search.button.filter.restore
search.filters.applied.f.ods: Industria, innovación e infraestructura × Subject: Data-bank ×

Filters

20241
Reset filters

Settings

Search Results

Now showing 1 - 1 of 1
  • Item
    Thumbnail ImageArtículo de Revista
    An optimized relational database for querying structural patterns in proteins
    Autores: Angles, Renzo; Arenas Salinas, Mauricio; García, Roberto; Ingram, Ben
    A database is an essential component in almost any software system, and its creation involves more than just data modeling and schema design. It also includes query optimization and tuning. This paper focuses on a web system called GSP4PDB, which is used for searching structural patterns in proteins. The system utilizes a normalized relational database, which has proven to be inefficient even for simple queries. This article discusses the optimization of the GSP4PDB database by implementing two techniques: denormalization and indexing. The empirical evaluation described in the article shows that combining these techniques enhances the efficiency of the database when querying both real and artificial graph-based structural patterns.
    Data-bank Oxford University Press 2024