Indexing Attribute Domains in Relational DBMS

• Grant number: 15/15392-7
• Support Opportunities: Scholarships in Brazil - Doctorate
• Start date: March 01, 2016
• End date: September 30, 2020
• Field of knowledge: Physical Sciences and Mathematics - Computer Science - Computing Methodologies and Techniques
• Principal Investigator: Caetano Traina Junior
• Grantee: Paulo Henrique de Oliveira
• Host Institution: Instituto de Ciências Matemáticas e de Computação (ICMC). Universidade de São Paulo (USP). São Carlos , SP, Brazil
• Associated scholarship(s): 18/20360-5 - Improving Scalability in Holistic Data Cleaning, BE.EP.DR

Abstract

Modern applications demand more flexibility in terms of data management, with which the rigid schemas of Relational Database Management Systems (RDBMS) have not properly coped. This demand has led to the development of DBMS that are not based on the Relational Model and, usually, do not employ SQL, the typical access language of the RDBMS. However, such DBMS, called NoSQL (Not Only SQL), stand only by the most prominent tools of their classes in the moment, and not by a conceptual foundation model. This leads to uncertainty in institutions that depend on such tools, because the fact that a tool is currently adequate does not guarantee that it will remain adequate or even exist in the future. Therefore, this project aims at developing data management solutions that meet the flexibility requirements of modern applications, yet maintaining the Relational Model as their conceptual reference. We advance from the premise that the rigidity of the current RDBMS derives from how they have been implemented and that it is possible to build an RDBMS that allows: (i) flexibility when defining a relation, so that the structure of the tuples need to be neither identical for the entire relation nor thoroughly defined in a tabular structure; (ii) flexibility when defining an index, so that it can be associated with attributes sharing the same domain across different relations, including attributes not predicted in the schema. In this context, this project proposes to define and develop the concept of domain index, in order to provide such flexibility for the current RDBMS. This project also involves to develop a prototype including all the modules needed to extend an existing RDBMS in order to execute and evaluate the new concept.

Scientific publications

(References retrieved automatically from Web of Science and SciELO through information on FAPESP grants and their corresponding numbers as mentioned in the publications by the authors)

NESSO-, MARCOS R., JR.; CAZZOLATO, MIRELA T.; SCABORA, LUCAS C.; OLIVEIRA, PAULO H.; SPADON, GABRIEL; DE SOUZA, JESSICA A.; OLIVEIRA, WILLIAN D.; CHINO, DANIEL Y. T.; RODRIGUES-, JOSE F., JR.; TRAINA, AGMA J. M.; et al. RAFIKI: Retrieval-Based Application for Imaging and Knowledge Investigation. 2018 31ST IEEE INTERNATIONAL SYMPOSIUM ON COMPUTER-BASED MEDICAL SYSTEMS (CBMS 2018), v. N/A, p. 6-pg., 2018-01-01. (13/21378-1, 17/08376-0, 16/17330-1, 15/15392-7, 16/17078-0)

OLIVEIRA, PAULO H.; SCABORA, LUCAS C.; CAZZOLATO, MIRELA T.; OLIVEIRA, WILLIAN D.; PAIXAO, RAFAEL S.; TRAINA, AGMA J. M.; TRAINA, CAETANO. Employing Domain Indexes to Efficiently Query Medical Data From Multiple Repositories. IEEE JOURNAL OF BIOMEDICAL AND HEALTH INFORMATICS, v. 23, n. 6, p. 2220-2229, NOV 2019. (16/17078-0, 15/15392-7, 16/17330-1)

Academic Publications

(References retrieved automatically from State of São Paulo Research Institutions)

OLIVEIRA, Paulo Henrique de. Enriching data analytics with incremental data cleaning and attribute domain management. 2021. Doctoral Thesis - Universidade de São Paulo (USP). Instituto de Ciências Matemáticas e de Computação (ICMC/SB) São Carlos.