Enhancing road traffic flow in sustainable cities through transformer models: Advancements and challenges

S Soudeep, MLN Aurthy, JR Jim, MF Mridha… - Sustainable Cities and …, 2024 - Elsevier
Efficient traffic flow is crucial for sustainable cities, as it directly impacts energy consumption,
pollution levels, and overall quality of life. The integration of superficial intelligence …

[HTML][HTML] On measuring inconsistency in definite and indefinite databases with denial constraints

F Parisi, J Grant - Artificial Intelligence, 2023 - Elsevier
Real-world databases are often inconsistent. Although there has been an extensive body of
work on handling inconsistency, little work has been done on measuring inconsistency in …

Fast approximate denial constraint discovery

R **ao, Z Tan, H Wang, S Ma - Proceedings of the VLDB Endowment, 2022 - dl.acm.org
We investigate the problem of discovering approximate denial constraints (DCs), for finding
DCs that hold with some exceptions to avoid overfitting real-life dirty data and facilitate data …

Discovering functional dependencies through hitting set enumeration

T Bleifuß, T Papenbrock, T Bläsius… - Proceedings of the …, 2024 - dl.acm.org
Functional dependencies (FDs) are among the most important integrity constraints in
databases. They serve to normalize datasets and thus resolve redundancies, they contribute …

Towards the efficient discovery of meaningful functional dependencies

Z Wei, S Link - Information Systems, 2023 - Elsevier
We propose the first framework for discovering the set of meaningful functional
dependencies from data. This set contains the true positives among the set of functional …

Querybooster: Improving SQL performance using middleware services for human-centered query rewriting

Q Bai, S Alsudais, C Li - arxiv preprint arxiv:2305.08272, 2023 - arxiv.org
SQL query performance is critical in database applications, and query rewriting is a
technique that transforms an original query into an equivalent query with a better …

Mixed covers of keys and functional dependencies for maintaining the integrity of data under updates

Z Zhang, S Link - Proceedings of the VLDB Endowment, 2024 - dl.acm.org
Covers for a set of functional dependencies (FDs) are fundamental for many areas of data
management, such as integrity maintenance, query optimization, database design, and data …

Efficiently enumerating hitting sets of hypergraphs arising in data profiling

T Bläsius, T Friedrich, J Lischeid, K Meeks… - Journal of Computer and …, 2022 - Elsevier
The transversal hypergraph problem asks to enumerate the minimal hitting sets of a
hypergraph. If the solutions have bounded size, Eiter and Gottlob [SICOMP'95] gave an …

A resource-aware deep cost model for big data query processing

Y Li, L Wang, S Wang, Y Sun… - 2022 IEEE 38th …, 2022 - ieeexplore.ieee.org
The efficiency of query processing is highly affected by execution plans and allocated
resources in the Spark SQL big data processing engine. However, the cost models for Spark …

The complexity of dependency detection and discovery in relational databases

T Bläsius, T Friedrich, M Schirneck - Theoretical Computer Science, 2022 - Elsevier
Multi-column dependencies in relational databases come associated with two different
computational tasks. The detection problem is to decide whether a dependency of a certain …