An optimized relational database for querying structural patterns in proteins

被引：0

作者：

Angles, Renzo ^{[1
,2
]}

Arenas-Salinas, Mauricio ^{[3
]}

Garcia, Roberto ^{[2
,4
]}

Ingram, Ben ^{[5
]}

机构：

[1] Univ Talca, Fac Engn, Dept Comp Sci, Camino Los Niches Km 1, Curico 3340000, Region Del Maul, Chile

[2] Millennium Inst Fdn Res Data IMFD, Vicuna Mackenna 4860, Santiago 7810000, Region Metropol, Chile

[3] Univ Talca, Fac Engn, Ctr Bioinformat & Simulac Mol CBSM, Av Lircay S-N, Talca 34600000, Region Del Maul, Chile

[4] Univ Talca, Fac Engn, Engn Syst Doctoral Program, Camino Los Niches Km 1, Curico 3340000, Region Del Maul, Chile

[5] Cranfield Univ, Sch Water Energy & Environm, Coll Rd, Cranfield MK43 0AL, Beds, England

来源：

DATABASE-THE JOURNAL OF BIOLOGICAL DATABASES AND CURATION | 2024年 / 2024卷

关键词：

DATA-BANK; STRATEGIES; GENE;

D O I：

10.1093/database/baad093

中图分类号：

Q [生物科学];

学科分类号：

07 ; 0710 ; 09 ;

摘要：

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.

引用

页数：15

共 50 条

[31] Optimized query translation strategy for XML stored in relational database
Wang, HZ
Li, JZ
He, ZY
ADVANCES IN WEB-AGE INFORMATION MANAGEMENT: PROCEEDINGS, 2004, 3129 : 378 - 388
[32] A comprehensive relational database of structural damping data
Khare, S
Jones, NP
BUILDING AN INTERNATIONAL COMMUNITY OF STRUCTURAL ENGINEERS, VOLS 1 AND 2, 1996, : 1236 - 1243
[33] Cooperative querying in relational databases
Ramos, CV
Braga, JL
Laender, AHF
XVII INTERNATIONAL CONFERENCE OF THE CHILEAN COMPUTER SCIENCE SOCIETY, PROCEEDINGS, 1997, : 190 - 198
[34] Querying Communities in Relational Databases
Qin, Lu
Yu, Jeffrey Xu
Chang, Lijun
Tao, Yufei
ICDE: 2009 IEEE 25TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, VOLS 1-3, 2009, : 724 - 735
[35] Database of structural motifs in proteins
Guruprasad, K
Prasad, MS
Kumar, GR
BIOINFORMATICS, 2000, 16 (04) : 372 - 375
[36] MIPDB:: a relational database dedicated to MIP family proteins
El Karkouri, K
Gueuné, H
Delamarche, C
BIOLOGY OF THE CELL, 2005, 97 (07) : 535 - 543
[37] Mining Multidimensional Frequent Patterns from Relational Database
Lee, Yue-Shi
Yen, Show-Jane
INTELLIGENT INFORMATION AND DATABASE SYSTEMS (ACIIDS 2013), PT I,, 2013, 7802 : 51 - 60
[38] Querying a summary of database
Voglozin, WA
Raschia, G
Ughetto, L
Mouaddib, N
JOURNAL OF INTELLIGENT INFORMATION SYSTEMS, 2006, 26 (01) : 59 - 73
[39] Querying a summary of database
W. A. Voglozin
G. Raschia
L. Ughetto
N. Mouaddib
Journal of Intelligent Information Systems, 2006, 26 : 59 - 73
[40] GALT Protein Database: Querying Structural and Functional Features of GALT Enzyme
d'Acierno, Antonio
Facchiano, Angelo
Marabotti, Anna
HUMAN MUTATION, 2014, 35 (09) : 1060 - 1067

← 1 2 3 4 5 →