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 条
  • [1] Querying ontologies in relational database systems
    Trissl, S
    Leser, U
    DATA INTEGRATION IN THE LIFE SCIENCES, PROCEEDINGS, 2005, 3615 : 63 - 79
  • [2] SQLF - A RELATIONAL DATABASE LANGUAGE FOR FUZZY QUERYING
    BOSC, P
    PIVERT, O
    IEEE TRANSACTIONS ON FUZZY SYSTEMS, 1995, 3 (01) : 1 - 17
  • [3] Querying Heterogeneous Relational Database using SPARQL
    Wang, Jinpeng
    Miao, Zhuang
    Zhang, Yafei
    Zhou, Bo
    PROCEEDINGS OF THE 8TH IEEE/ACIS INTERNATIONAL CONFERENCE ON COMPUTER AND INFORMATION SCIENCE, 2009, : 475 - 480
  • [4] Indexing and Querying Semistructured Data Views of Relational Database
    Alom, B. M. Monjurul
    Henskens, Frans
    Hannaford, Michael
    INTERNATIONAL JOURNAL OF COMPUTER SCIENCE AND NETWORK SECURITY, 2010, 10 (06): : 118 - 133
  • [5] Conflicting Viewpoint Relational Database Querying: an Argumentation Approach
    Tamani, Nouredine
    Croitoru, Madalina
    Buche, Patrice
    AAMAS'14: PROCEEDINGS OF THE 2014 INTERNATIONAL CONFERENCE ON AUTONOMOUS AGENTS & MULTIAGENT SYSTEMS, 2014, : 1553 - 1554
  • [6] Querying XML documents from a relational database in the presence of DTDs
    Rege, M
    Caraconcea, I
    Lu, SY
    Fotouhi, F
    DISTRIBUTED COMPUTING AND INTERNET TECHNOLOGY, PROCEEDINGS, 2004, 3347 : 168 - 177
  • [7] A knowledge-based approach to cooperative relational database querying
    Braga, JL
    Laender, AHF
    Vander Ramos, C
    INTERNATIONAL JOURNAL OF PATTERN RECOGNITION AND ARTIFICIAL INTELLIGENCE, 2000, 14 (01) : 73 - 90
  • [8] Querying XML data by the nested relational sequence database system
    Lau, HL
    Ng, W
    SEVENTH INTERNATIONAL DATABASE ENGINEERING AND APPLICATIONS SYMPOSIUM, PROCEEDINGS, 2003, : 236 - 241
  • [9] Relational Database Design Patterns
    Haraty, Ramzi A.
    Stephan, Georges
    2013 IEEE 16TH INTERNATIONAL CONFERENCE ON COMPUTATIONAL SCIENCE AND ENGINEERING (CSE 2013), 2013, : 818 - 824
  • [10] Transforming a Multi-value Database System into a Relational Database System for Faster Querying
    Hasan, Md. Zahid
    Huq, Mohammad Rezwanul
    2016 3RD INTERNATIONAL CONFERENCE ON ELECTRICAL ENGINEERING AND INFORMATION & COMMUNICATION TECHNOLOGY (ICEEICT), 2016,
12345