Related Experiment Video
Updated: Jul 5, 2025

Investigating Protein Sequence-structure-dynamics Relationships with Bio3D-web
Published on: July 16, 2017
An optimized relational database for querying structural patterns in proteins
Renzo Angles1,2, Mauricio Arenas-Salinas3, Roberto García2,4
1Department of Computer Science, Faculty of Engineering, Universidad de Talca, Camino a Los Niches Km. 1, Curicó, Región del Maule 3340000, Chile.
Abstract:
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.
More Related Videos
Related Concept Videos
Protein Organization
The primary structure of a protein is its amino acid sequence....
Protein-protein Interfaces
Protein Networks
These interactions can be represented through maps depicting protein-protein interaction networks, represented as nodes and edges. Nodes are circles that are representative of a protein,...
Protein Families
Protein and Protein Structures
Protein and Protein Structure
A protein's shape is critical to its function. For example, an enzyme...

