SQL-on-Hadoop Engines Compared

R20/Consultancy SQL-on-Hadoop Engines Explained, May 2014

A high-level comparison of several SQL-on-Hadoop engines plus a classic SQL database server.



Operational processing is a use case where zero-latency data is presented to users. It usually involves a data source that is continuously updated with new data and concurrently queried. Seconds and even microseconds count in operational processing. It could be the difference between success and failure. Operational reporting is the basis for popular trends such as operational intelligence or real-time analytics.

Interactive processing (OLAP, self-service BI, data visualization) is the classic use case of data warehouse environments. With interactive reporting, users repeatedly access their data to see what’s happening with certain business processes. They see their data organized as cubes, dimensions, and hierarchies. They can filter their data, drill down to a more detailed level or, vice versa, do a roll-up, and they can apply aggregations and statistical functions, such as sum, average, and standard deviation. It’s called interactive because the users are continuously sending new queries to the database.

Batch processing is the most classic use case of reporting in the IT industry. Usually, on predefined days and times reports are created and the results are distributed to the business users. The queries executed in batch reporting environments usually consist of simple joins and no complex analytical functions. This use case fits like a glove for SQL-on-Hadoop. Almost all these engines can support this type of workload.

Ovaj unos je objavljen u Nekategorizirano. Bookmarkirajte stalnu vezu.

Jedan odgovor na SQL-on-Hadoop Engines Compared

  1. Dubravko Cunovic napisao:

    An Introduction to SAP HANA by Dr. Vishal Sikka



Popunite niže tražene podatke ili kliknite na neku od ikona za prijavu:

WordPress.com Logo

Ovaj komentar pišete koristeći vaš WordPress.com račun. Odjava /  Izmijeni )

Google+ photo

Ovaj komentar pišete koristeći vaš Google+ račun. Odjava /  Izmijeni )

Twitter picture

Ovaj komentar pišete koristeći vaš Twitter račun. Odjava /  Izmijeni )

Facebook slika

Ovaj komentar pišete koristeći vaš Facebook račun. Odjava /  Izmijeni )


Spajanje na %s