QMapper for Smart Grid: Migrating SQL-based Application to Hive

Summary: QMapper automates SQL-to-HiveQL translation for migrating RDBMS apps to Hive, via a rule-based rewriter and a cost-based optimizer. TPC-H and a real Smart Grid workload show substantial latency reductions versus manually rewritten Hive queries. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 5017
Venue: SIGMOD
Year: 2015
Pagerank: 4.427232e-05
Overall Rank: 8,924 | 37.92%
DOI: 10.1145/2723372.2742792

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,242	SQL-Exchange: Transforming SQL Queries Across Domains	2026	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
3	Pig Latin: A Not-So-Foreign Language for Data Processing	2008	SIGMOD	0.0024183614
70	Hive - A Warehousing Solution Over a Map-Reduce Framework	2009	VLDB	0.00059533166
157	HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads	2009	VLDB	0.00040397359
542	Shark: SQL and Rich Analytics at Scale	2013	SIGMOD	0.00020595648
868	Profiling, What-if Analysis, and Cost-based Optimization of MapReduce Programs	2011	VLDB	0.00015789681
913	Tenzing A SQL Implementation On The MapReduce Framework	2011	VLDB	0.00015408131
979	Interactive Analytical Processing in Big Data Systems: A Cross-Industry Study of MapReduce Workloads	2012	VLDB	0.0001488055
1,071	Starfish: A Self-tuning System for Big Data Analytics	2011	CIDR	0.00014312777
1,265	Jaql: A Scripting Language for Large Scale Semistructured Data Analysis	2011	VLDB	0.00012947629
2,127	SQL-on-Hadoop: Full Circle Back to Shared-Nothing Database Architectures	2014	VLDB	9.4863172e-05
2,344	Performance Tradeoffs for Client-Server Query Processing	1996	SIGMOD	8.9992357e-05
2,747	Stubby: A Transformation-based Optimizer for MapReduce Workflows	2012	VLDB	8.1828918e-05
11,987	DGFIndex for Smart Grid: Enhancing Hive with a Cost-Effective Multidimensional Range Index	2014	VLDB	4.1945683e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
2,337	Efficient Processing of Data Warehousing Queries in a Split Execution Environment	2011	SIGMOD	9.0098186e-05
1,261	Hadoop-GIS: A High Performance Spatial Data Warehousing System over MapReduce	2013	VLDB	0.00012989236
10,568	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1945683e-05
5,014	Dynamically Optimizing Queries over Large Scale Data Platforms	2014	SIGMOD	5.7586174e-05
11,286	DHive: Query Execution Performance Analysis via Dataflow in Apache Hive	2023	VLDB	4.1945683e-05
2,127	SQL-on-Hadoop: Full Circle Back to Shared-Nothing Database Architectures	2014	VLDB	9.4863172e-05
2,998	Major Technical Advancements in Apache Hive	2014	SIGMOD	7.753765e-05
11,987	DGFIndex for Smart Grid: Enhancing Hive with a Cost-Effective Multidimensional Range Index	2014	VLDB	4.1945683e-05
70	Hive - A Warehousing Solution Over a Map-Reduce Framework	2009	VLDB	0.00059533166
3,973	Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing	2019	SIGMOD	6.5758017e-05