Export Citations
Save this search
Please login to be able to save your searches and receive alerts for new content matching your search criteria.
- research-articleJanuary 2025
LLM-Based Text-to-SQL for Real-World Databases
- Eduardo R. Nascimento,
- Grettel García,
- Yenier T. Izquierdo,
- Lucas Feijó,
- Gustavo M. C. Coelho,
- Aiko R. de Oliveira,
- Melissa Lemos,
- Robinson L. S. Garcia,
- Luiz A. P. Paes Leme,
- Marco A. Casanova
AbstractText-to-SQL refers to the task defined as “given a relational databaseDand a natural language sentenceSthat describes a question on D, generate an SQL query QoverDthat expressesS”. Several LLM-based text-to-SQL tools, that is, text-to-SQL tools ...
- ArticleDecember 2024
Don’t Abandon the Primary Key: A High-Synchronization and Robust Virtual Primary Key Scheme for Watermarking Relational Databases
AbstractA relational database is an infrastructure that manages and shares structured data. To safeguard the copyrights of data within such databases, database watermarking is an effective technique. Most watermarking schemes rely on the primary key (PK) ...
- research-articleFebruary 2024
Nature of decision valuations in elimination of redundant attributes
International Journal of Approximate Reasoning (IJAR), Volume 165, Issue Chttps://doi.org/10.1016/j.ijar.2023.109091AbstractInformation systems are the basic building blocks of the theory of rough sets which, based on information signatures of objects, develops strategies for classifying concepts and/or deriving significant information about decision attributes. ...
- research-articleNovember 2023
Givens rotations for QR decomposition, SVD and PCA over database joins
The VLDB Journal — The International Journal on Very Large Data Bases (VLDB), Volume 33, Issue 4Pages 1013–1037https://doi.org/10.1007/s00778-023-00818-9AbstractThis article introduces FiGaRo, an algorithm for computing the upper-triangular matrix in the QR decomposition of the matrix defined by the natural join over relational data. FiGaRo ’s main novelty is that it pushes the QR decomposition past the ...
- research-articleNovember 2023
A novel approach to assess and improve syntactic interoperability in data integration
Information Processing and Management: an International Journal (IPRM), Volume 60, Issue 6https://doi.org/10.1016/j.ipm.2023.103522AbstractData integration is essential to enrich a database with external information. One effective approach is to match shared identifiers across diverse databases. However, a lack of syntactic interoperability, which refers to the ability to match data ...
Highlights- A simple measure for syntactic interoperability can be adapted to the usage context.
- This measure is used to study the impact of data quality on interoperability.
- Enhancing data quality can boost interoperability but its cost may ...
-
- research-articleMarch 2023
Modeling and querying temporal RDF knowledge graphs with relational databases
Journal of Intelligent Information Systems (JIIS), Volume 61, Issue 2Pages 569–609https://doi.org/10.1007/s10844-023-00780-6AbstractRDF (Resource Description Framework), a standard resource description model, is popularized and applied in many application scenarios for its explicit representation of semantics. To represent and process time-aware semantics with RDF, the ...
- research-articleJuly 2022
DLToDW: Transferring Relational and NoSQL Databases from a Data Lake
AbstractOver the past decade, digital transformation has led to the evolution of databases towards Big Data. A need to collect and analyze data from different sources has emerged. At the same time, traditional decision support systems are unable to meet ...
- research-articleJune 2022
SQLSketch-TVC: Type, value and compatibility based approach for SQL queries: SQLSketch-typed
Applied Intelligence (KLU-APIN), Volume 53, Issue 4Pages 3889–3898https://doi.org/10.1007/s10489-022-03587-0AbstractUnderstanding the complexity of the translation of Natural Language (NL) sentences to SQL queries becomes an essential part in the resolution process. The majority of the proposed models either focus on simple queries or suffer when exposed to ...
- research-articleMarch 2022
Exploring data structure alternatives in the RDB to NoSQL document store conversion process
AbstractNoSQL databases have emerged as an alternative to relational databases, which do not meet all the currently imposed scenarios. Large applications that handle a variety of data formats often use several types of databases and the need ...
Highlights- Choosing the ideal data structure when converting RDB to NoSQL is not a trivial task.
- research-articleSeptember 2021
On augmenting database schemas by latent visual attributes
Knowledge and Information Systems (KAIS), Volume 63, Issue 9Pages 2277–2312https://doi.org/10.1007/s10115-021-01595-zAbstractDecision-making in our everyday lives is surrounded by visually important information. Fashion, housing, dating, food or travel are just a few examples. At the same time, most commonly used tools for information retrieval operate on relational and ...
- research-articleJune 2021
Schema mapping coverage
Annals of Mathematics and Artificial Intelligence (KLU-AMAI), Volume 89, Issue 5-6Pages 511–549https://doi.org/10.1007/s10472-020-09720-4AbstractIn this paper, we introduce and study schema mapping coverage for relational databases. Given a relational schema mapping in the presence of both source dependencies and target dependencies, the coverage problem is to decide and describe which ...
- research-articleApril 2021
Semantic-driven watermarking of relational textual databases
Expert Systems with Applications: An International Journal (EXWA), Volume 167, Issue Chttps://doi.org/10.1016/j.eswa.2020.114013Highlights- Mark embedding through synonyms substitutions avoids to compromise data quality.
In relational database watermarking, the semantic consistency between the original database and the distorted one is a challenging issue which is disregarded by most watermarking proposals, due to the well-known assumption for which a ...
- ArticleNovember 2020
Quantifying the Impact of EER Modeling on Relational Database Success: An Experimental Investigation
AbstractDespite the widespread idea in literature that the inclusion of EER modeling in the design process of a relational database is beneficial for the success of that database, almost no quantitative cost-benefit analyses of EER modeling exist today to ...
- research-articleSeptember 2020
Think big, start small: a good initiative to design green query optimizers
Cluster Computing (KLU-CLUS), Volume 23, Issue 3Pages 2323–2345https://doi.org/10.1007/s10586-019-03005-0AbstractRecently scientists, politicians, students, associations and actors are sounded the alarm to save our planet. The slogan of Greta Thunberg “Our house is on fire” urges any person to act on the climate. As researchers in the field of databases, one ...
- ArticleApril 2020
Which BM25 Do You Mean? A Large-Scale Reproducibility Study of Scoring Variants
AbstractWhen researchers speak of BM25, it is not entirely clear which variant they mean, since many tweaks to Robertson et al.’s original formulation have been proposed. When practitioners speak of BM25, they most likely refer to the implementation in ...
- research-articleApril 2020
HR-SQL: Extending SQL with hypothetical reasoning and improved recursion for current database systems
AbstractIn this work we present a formalization, backed with a contrasted implementation, of a relational database language (called HR-SQL) that extends SQL in two aspects. On the one hand, including non-linear and mutual recursion. On the ...
- research-articleFebruary 2020
From keywords to relational database content: A semantic mapping method
AbstractKeyword-based query specification to extract data from structured databases has attracted considerable attention from various researchers, and many interesting proposals may be found in the scientific literature. However, many of these ...
Highlights- A keyword-based method for querying relational databases is proposed.
- The ...
- ArticleOctober 2019
A Port Graph Rewriting Approach to Relational Database Modelling
Logic-Based Program Synthesis and TransformationPages 211–227https://doi.org/10.1007/978-3-030-45260-5_13AbstractWe present new algorithms to compute the Syntactic Closure and the Minimal Cover of a set of functional dependencies, using strategic port graph rewriting. We specify a Visual Domain Specific Language to model relational database schemata as port ...
- ArticleAugust 2019
An Evaluation on Robustness and Utility of Fingerprinting Schemes
AbstractFingerprinting of data is a method to embed a traceable marker into the data to identify which specific recipient a certain copy of the data set has been released to. This is crucial for releasing data sets to third parties, especially if the ...
- ArticleJune 2019
A Natural Language Interface Supporting Complex Logic Questions for Relational Databases
Natural Language Processing and Information SystemsPages 384–392https://doi.org/10.1007/978-3-030-23281-8_34AbstractNatural Language Interface to Databases (NLIDB) systems accept questions in any supported natural language (i.e English) and allow users to interrogate a database. Users can access and derive information from a relational database without ...