Advanced search
Start date

Indexing Attribute Domains in Relational DBMS

Grant number: 15/15392-7
Support Opportunities:Scholarships in Brazil - Doctorate
Effective date (Start): March 01, 2016
Effective date (End): 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


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.

News published in Agência FAPESP Newsletter about the scholarship:
Articles published in other media outlets (0 total):
More itemsLess items

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)
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, . (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.

Please report errors in scientific publications list by writing to: