一个优化的关系数据库,用于查询蛋白质中的结构模式
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.
Database : the journal of biological databases and curation
|January 18, 2024
概括
数据库优化对于软件系统至关重要. 这项研究通过应用非规范化和索引来增强GSP4PDB蛋白质结构模式搜索系统,显著提高了查询性能.
科学领域:
- 生物信息学是一种生物信息学.
- 计算生物学 计算生物学
- 数据库系统 数据库系统
背景情况:
- 数据库是软件系统的基础,需要数据建模和性能调整.
- 设计用于蛋白质结构模式搜索的GSP4PDB系统使用了一个规范化的关系数据库.
- 规范化数据库可能表现出效率低下,特别是在像GSP4PDB.中那些复杂的查询中.
研究的目的:
- 优化GSP4PDB数据库的性能,以有效地搜索蛋白质结构模式.
- 评估非规范化和索引技术在提高数据库查询速度方面的有效性.
主要方法:
- 实现了数据库非规范化,以减少合并操作.
- 应用索引策略以加速数据检索.
- 通过使用真实和人工图形基础的结构模式进行经验评估.
主要成果:
- 无规范化和索引的联合应用显著提高了数据库的效率.
- 优化的查询显示了对真实和人工结构模式搜索的性能提高.
- 该研究验证了这些技术在生物信息学中基于图表的数据的有效性.
结论:
- 非规范化和索引化是优化关系数据库在专业系统中的有效策略,如GSP4PDB.
- 增强的GSP4PDB系统为查询蛋白质结构模式提供了更好的性能.
- 这项工作有助于更高效的生物信息学数据管理和分析.
相关概念视频
Protein Organization
6.5K
Proteins are polymers of amino acid residues. They are versatile and responsible for different cellular functions, including DNA replication, molecular transport, catalysis, and structural support. Proteins have a hierarchical structure comprising at least three levels of organization: primary, secondary, and tertiary structure. Some large proteins have a quaternary structure where individual protein subunits are linked together.
The primary structure of a protein is its amino acid sequence....
The primary structure of a protein is its amino acid sequence....
6.5K
Protein-protein Interfaces
12.5K
Many proteins form complexes to carry out their functions, making protein-protein interactions (PPIs) essential for an organism's survival. Most PPIs are stabilized by numerous weak noncovalent chemical forces. The physical shape of the interfaces determines the way two proteins interact. Many globular proteins have closely-matching shapes on their surfaces, which form a large number of weak bonds. Additionally, many PPIs occur between two helices or between a surface cleft and a...
12.5K
Protein Networks
4.0K
An organism can have thousands of different proteins, and these proteins must cooperate to ensure the health of an organism. Proteins bind to other proteins and form complexes to carry out their functions. Many proteins interact with multiple other proteins creating a complex network of protein interactions.
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,...
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,...
4.0K
Protein Families
15.3K
Protein families are groups of homologous proteins; that is, they have similarities in amino acid sequences and three-dimensional structures. Protein families usually occur because of gene duplication, where an additional copy of a gene is inserted into the genome of an organism. Mutations that change the amino acids but still allow the protein to be properly synthesized, will lead to new protein family members. If these new proteins contain similar amino acids in key...
15.3K
Protein and Protein Structures
10.5K
10.5K
Protein and Protein Structure
79.6K
Proteins are one of the most abundant organic molecules in living systems and have the most diverse range of functions of all macromolecules. Proteins may be structural, regulatory, contractile, or protective. They may serve in transport, storage, or membranes; or they may be toxins or enzymes. Their structures, like their functions, vary greatly. They are all, however, amino acid polymers arranged in a linear sequence.
A protein's shape is critical to its function. For example, an enzyme...
A protein's shape is critical to its function. For example, an enzyme...
79.6K


