arrow
返回

An optimized relational database for querying structural patterns in proteins

delete2024-01-17
delete0
delete
OA
AI
R
Renzo Angles *
M
Mauricio Arenas‐Salinas
R
Roberto García
B
Ben Ingram
DOI:10.1093/database/baad093delete
delete原文链接
delete分享
delete收藏
查看原文
摘要

摘要

En 中文
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.
Keyword:
DATA-BANK
STRATEGIES
GENE
AI总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

D
Database-The Journal of Biological Databases and Curation
IF:
3.6
论文数:
1.7K
被引数:
6.1K

机构

U
universidad de talca
学者数:
2.5K
论文数: 2.4K
被引数: 1
引用论文

引用论文

The Protein Data Bank蛋白质数据库
err2000-01-01
err3.3W
errOAAI
errBerman, HM; Westbrook, J; Feng, Z; Gilliland, G; Bhat, TN; Weissig, H; Shindyalov, IN; Bourne, PE
err分享
err收藏
Overhauling the PDB
err2007-04-01
err6
PREAI
errSchierz, Amanda C.; Soldatova, Larisa N.; King, Ross D.
err分享
err收藏
Virtual Denormalization via Array Index Reference for Main Memory OLAP
err2016-04-01
err13
errOAAI
errZhang, Yansong; Zhou, Xuan; Zhang, Ying; Zhang, Yu; Su, Mingchuan; Wang, Shan
err分享
err收藏
Magnetic resonance imaging of the uterus after endometrial resection
err2005-08-19
err0
PREAI
errL. W. Turnbull; A. Jumaa; S. J. Bowsley; S. Dhawan; A. Horsman; S. R. Killick
err分享
err收藏
Zinc-finger proteins in health and disease锌指蛋白在健康和疾病中的作用
err2017-11-13
err600
errOAAI
errCassandri, Matteo; Smirnov, Artem; Novelli, Flavia; Pitolli, Consuelo; Agostini, Massimiliano; Malewicz, Michal; Melino, Gerry; Raschella, Giuseppe
err分享
err收藏
Strategies in the Rational Drug Design合理药物设计中的策略
err2011-06-01
err98
PREAI
errMavromoustakos, T.; Durdagi, S.; Koukoulitsa, C.; Simcic, M.; Papadopoulos, M. G.; Hodoscek, M.; Grdadolnik, S. Golic
err分享
err收藏
Microseiramide from the freshwater cyanobacterium Microseira sp. UIC 10445
err2015-09-01
err0
errOAAI
errShangwen Luo; Aleksej Krunic; George E. Chlipala; Jimmy Orjala
err分享
err收藏
学者 查看更多内容