The next meeting of the Information Modeling Seminar will be held on February 22 (Thursday), at 2 p.m., in room 503 of IMI-BAS. A talk on:

Integrating relational data and unstructured big data with a functional SQL-like query language

will be delivered by Senior Assist. Prof. Boyan Kolev.

Abstract: Polystore systems have been proposed to provide integrated access to multiple, heterogeneous data stores through a single query engine. In particular, much attention is being paid on the integration of relational data with unstructured big data typically stored in HDFS. One typical legacy solution is to use a relational query engine that allows SQL-like queries to retrieve data from HDFS, which requires the system to provide a relational view of the unstructured data and hence is not always feasible. This talk presents an approach to overcome such limitations through a functional SQL-like query language that can integrate data retrieved from different data stores and take full advantage of the functionality of the underlying data processing frameworks by allowing the ad hoc usage of user-defined map/filter/reduce operators in combination with traditional SQL statements. Furthermore, the query language allows for optimization by enabling subquery rewriting so that filter conditions can be pushed inside and executed at the data store as early as possible. The approach is validated with two data stores (an SQL database and the parallel data processing framework Apache Spark that operates on a distributed dataset) and a representative query that demonstrates the usability of the query language and evaluates the benefits from query optimization.

For remote participation:

Join Zoom Meeting
https://us02web.zoom.us/j/81054245812?pwd=NDltMlpjbXRnUEZGeTRuZkt2Um9SZz09

Meeting ID: 810 5424 5812
Passcode: 286884