Search Results

This paper studies how privacy guarantees on relational databases (RDBs) with foreign key constraints can be transposed to Semantic Web (RDF) databases and vice versa. Thus, we consider a Differentially Private (DP) model for RDB related to ...

Real-world relational databases (RW-RDB) have large, complex schemas often expressed in terms alien to end-users. This scenario is challenging to LLM-based text-to-SQL tools, that is, tools that translate Natural Language (NL) sentences into SQL ...${}_{}{}_{}$${}_{}$${}_{}$${}_{}$${}_{}{}_{}$${}_{}$${}_{}$

The task of SQL query equivalence checking is important in various real-world applications (including query rewriting and automated grading) that involve complex queries with integrity constraints; yet, state-of-the-art techniques are very limited in ...

The reactive paradigm for developing user interfaces promises both simplicity and scalability, but existing frameworks usually compromise one for the other. We present Riffle, a reactive state management system that achieves both simplicity and ...

Digitized enterprise processes often encompass interaction with relational databases. Describing and simulating large-scale and complex processes on different abstraction levels lead to the use of tools and methods of Model-based Systems ...

In the age of information, there is a growing need to process data, both structured and unstructured, with ease and accuracy. Such an intensive task might be achieved through machine learning based applications, but not always. Moreover, the major ...

The object-relational impedance mismatch (ORIM) problem characterises differences between the object-oriented and relational approaches to data access. Queries generated by object-relational mapping (ORM) frameworks are designed to overcome ORIM ...

Many programs that interact with a database need to undergo schema refactoring several times during their life cycle. Since this process typically requires making significant changes to the program's implementation, schema refactoring is often non-...

In this paper, we present a parallel tool for partitioning open-source relational databases. This tool is implemented with the goal of improving the performance and scalability of the relational databases. The tool provides a command line interface ...

Recently there has been an effort to solve the problems caused by the infamous NULL in relational databases, by systematically applying Kleene's three-valued logic to SQL. The third truth-value is unknown. In this paper we show that by using a fourth ...

This paper addresses the problem of verifying equivalence between a pair of programs that operate over databases with different schemas. This problem is particularly important in the context of web applications, which typically undergo database ...

In this paper, we present a high-level tool for partitioning open-source relational databases, thereby, enhancing their performance and scalability. The tool is implemented using Java and SQL, and has been tested on both MySQL and PostgreSQL databases. ...

This paper presents a new technique for automatically synthesizing SQL queries from natural language (NL). At the core of our technique is a new NL-based program synthesis methodology that combines semantic parsing techniques from the NLP community with ...

Structured Query Language (SQL) is widely used to operate Relational Databases (RDBs), and to operate an RDB with SQL, an application called an SQL Client is used. Recently, many SQL Clients have been developed and have become more users friendly. An ...

Semantic Querying (SQ) is emerging as an attractive approach for retrieval of data from relational and other conceptually similar databases, targeting users with limited or no technical expertise. Using SQ queries can be formulated using terminologies ...

This article focuses on testing a path-oriented querying approach to hierarchical data in relational databases. The authors execute a user study to compare the path-oriented approach and traditional SQL from two perspectives: correctness of queries and ...

Sometimes, data belonging to Relational databases need to be transferred to NoSQL ones. However, the data conversion process between Relational to NoSQL databases is considered as not trivial, since it is necessary to have considerable knowledge about ...

In certain situations, syntactically valid, but incorrect, data entered into a database can result in near-immediate, catastrophic financial losses for an organization. Examples include: omitting zeros in prices of goods on e-commerce sites; and ...

Process-Aware Information System (PAIS) are IT systems that manages, supports business processes and generate large event logs from execution of business processes. Process Mining consists of analyzing event logs generated by PAISs and discover business ...

Information granulation is a powerful tool for data analysis and processing. However, not much attention has been devoted to application of this tool to data stored in a relational structure. This paper extends the notion of information granules to a ...