An optimized relational database for querying structural patterns in proteins
| datacite.creator | Angles, Renzo | |
| datacite.creator | Arenas Salinas, Mauricio | |
| datacite.creator | García, Roberto | |
| datacite.creator | Ingram, Ben | |
| datacite.date.issued | 2024 | |
| datacite.identifier | DOI | |
| datacite.identifier.doi | 10.1093/database/baad093 | |
| datacite.identifier.issn | 1758-0463 | |
| datacite.identifier.orcid | 0000-0001-6466-4541 | |
| datacite.identifier.orcid | 0000-0001-5143-1845 | |
| datacite.identifier.orcid | 0000-0002-6740-9711 | |
| datacite.identifier.orcid | 0000-0003-4557-4342 | |
| datacite.identifier.wosid | WOS:001145401400001 | |
| datacite.rights | Acceso abierto | |
| datacite.size | 15 p. | |
| datacite.subject | Data-bank | |
| datacite.subject | Strategies | |
| datacite.subject | Gene | |
| datacite.title | An optimized relational database for querying structural patterns in proteins | |
| dc.date.accessioned | 2024-10-07T13:52:05Z | |
| dc.date.available | 2024-10-07T13:52:05Z | |
| dc.description.abstract | 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. | |
| dc.identifier.folio | 1221727 | |
| dc.identifier.folio | NACIONAL/2019 | |
| dc.identifier.folio | 21192157 | |
| dc.identifier.uri | https://repositorio.utalca.cl/repositorio/handle/1950/14187 | |
| dc.language | Inglés | |
| dc.publisher | Oxford University Press | |
| dc.relation.uri | https://academic.oup.com/database/article/doi/10.1093/database/baad093/7571373 | |
| dc.source | Database: The Journal of Biological Databases and Curation | |
| oaire.citationTitle | Database: The Journal of Biological Databases and Curation | |
| oaire.fundingReference | R.A. was supported by ANID FONDECYT Chile through grant 1221727. R.G. was supported by CONICYT PFCHA/BECA DE DOCTORADO NACIONAL/2019 under Grant 21192157. | |
| oaire.licenseCondition | http://creativecommons.org/licenses/by/4.0/ | |
| oaire.licenseCondition.uri | http://creativecommons.org/licenses/by/4.0/ | |
| oaire.resourceType | Artículo de Revista | |
| oaire.version | Versión Publicada | |
| utalca.catalogador | PAG | |
| utalca.facultad | Universidad de Talca (Chile). Facultad de Ingeniería. Departamento de Ciencias de la Computación. | |
| utalca.facultad | Universidad de Talca (Chile). Facultad de Ingeniería. Centro de Bioinformática Simulación y Modelado | |
| utalca.facultad | Universidad de Talca (Chile). Facultad de Ingeniería. | |
| utalca.idcarga | pag07102024 | |
| utalca.index | Artículo indexado en Web of Science | |
| utalca.index | Artículo indexado en Scopus | |
| utalca.informaciondegenero | Hombre | |
| utalca.ods | Industria, innovación e infraestructura |
Files
Original bundle
1 - 1 of 1
