[PDF][PDF] Maliva: Using Machine Learning to Rewrite Visualization Queries Under Time Constraints.

Q Bai, S Alsudais, C Li, S Zhao - EDBT, 2023 - openproceedings.org
We consider data-visualization systems where a middleware layer translates a frontend
request to a SQL query to a backend database to compute visual results. We study the …

Indexing the pickup and drop-off locations of NYC taxi trips in PostgreSQL–lessons from the road

J Yu, M Sarwat - Advances in Spatial and Temporal Databases: 15th …, 2017 - Springer
In this paper, we present our experience in indexing the drop-off and pick-up locations of taxi
trips in New York City. The paper presents a comprehensive experimental analysis of classic …

Marviq: Quality-Aware Geospatial Visualization of Range-Selection Queries Using Materialization

L Dong, Q Bai, T Kim, T Chen, W Liu, C Li - Proceedings of the 2020 …, 2020 - dl.acm.org
We study the problem of efficient spatial visualization on a large data set stored in a
database using SQL queries with ad-hoc range conditions on numerical attributes, for …

[BOOK][B] Supporting Interactive Analytics and Visualization on Large Data

J Jia - 2017 - search.proquest.com
There is an increasing demand to visualize large datasets as human observable reports in
order to quickly draw insights and gain timely awareness from the data. An interactive user …

[BOOK][B] Improving SQL Performance Using Middleware-Based Query Rewriting

Q Bai - 2023 - search.proquest.com
Query performance is critical in database-supported applications where users need answers
quickly to make timely decisions. For decades, databases have relied heavily on query …

Maliva: Using Machine Learning to Rewrite Visualization Queries Under Time Constraints

Q Bai, S Alsudais, C Li, S Zhao - arxiv preprint arxiv:2112.00182, 2021 - arxiv.org
We consider data-visualization systems where a middleware layer translates a frontend
request to a SQL query to a backend database to compute visual results. We study the …

[PDF][PDF] Rainbow: A Rendering-Aware Index for High-Quality Spatial Scatterplots with Result-Size Budgets.

Q Bai, S Alsudais, C Li, S Zhao - EGPGV@ EuroVis, 2022 - diglib.eg.org
We study the problem of computing a spatial scatterplot on a large dataset for arbitrary
zooming/panning queries. We introduce a general framework called “Rainbow” that …

Advancing Spatial Analytical Database Systems

V Pandey - 2021 - mediatum.ub.tum.de
Spatial data is pervasive. This thesis makes three contributions to the design and
implementation of systems that handle spatial data. First, we study the big-data spatial …

ST-Hadoop: A MapReduce Framework for Big Spatio-temporal Data Management

L Alarabi - 2019 - search.proquest.com
Abstract Apache Hadoop, employing the MapReduce programming paradigm, that has been
widely accepted as the standard framework for analyzing big data in distributed …