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 条

[41] VIREX: Interactive approach for database querying and integration by re-engineering relational data into XML
Lo, Anthony
Alhajj, Reda
Barker, Ken
2006 IEEE/WIC/ACM INTERNATIONAL CONFERENCE ON WEB INTELLIGENCE, (WI 2006 MAIN CONFERENCE PROCEEDINGS), 2006, : 1079 - +
[42] Data in support of UbSRD: The Ubiquitin Structural Relational Database
Harrison, Joseph S.
Jacobs, Tim M.
Houlihan, Kevin
Van Doorslaer, Koenraad
Kuhlman, Brian
DATA IN BRIEF, 2015, 5 : 605 - 615
[43] On Reducing Reasoning and Querying in Natural Logic to Database Querying
Andreasen, Troels
Bulskov, Henrik
Nilsson, Jorgen Fischer
FLEXIBLE QUERY ANSWERING SYSTEMS, FQAS 2023, 2023, 14113 : 3 - 14
[44] An Efficient Approach for Effectual Mining of Relational Patterns from Multi-Relational Database
Dhanasekar, Vimalkumar
Angamuthu, Tamilarasi
INTERNATIONAL ARAB JOURNAL OF INFORMATION TECHNOLOGY, 2013, 10 (03) : 260 - 268
[45] Querying relational databases through XSLT
Liu, JX
Vincent, M
DATA & KNOWLEDGE ENGINEERING, 2004, 48 (01) : 103 - 128
[46] SCOP: a structural classification of proteins database
Hubbard, TJP
Ailey, B
Brenner, SE
Murzin, AG
Chothia, C
NUCLEIC ACIDS RESEARCH, 1999, 27 (01) : 254 - 256
[47] SCOP: A structural classification of proteins database
Hubbard, TJP
Murzin, AG
Brenner, SE
Chothia, C
NUCLEIC ACIDS RESEARCH, 1997, 25 (01) : 236 - 239
[48] Database querying on the World Wide Web: UniGuide, an object-relational search engine for Australian universities
Enguix, CF
COMPUTER NETWORKS AND ISDN SYSTEMS, 1998, 30 (1-7): : 567 - 572
[49] DbStRiPs: Database of structural repeats in proteins
Chakrabarty, Broto
Parekh, Nita
PROTEIN SCIENCE, 2022, 31 (01) : 23 - 36
[50] SCOP: a Structural Classification of Proteins database
Lo Conte, L
Ailey, B
Hubbard, TJP
Brenner, SE
Murzin, AG
Chothia, C
NUCLEIC ACIDS RESEARCH, 2000, 28 (01) : 257 - 259

← 1 2 3 4 5 →