Presto Use Cases

Use Cases

Presto can be deployed in many different platforms and locations. Whether in the cloud or on-premises, the technology is truly platform agnostic. Today, companies are using Presto in a variety of ways — for single reporting applications, as a single enterprise-wide query engine, and much more. With the tremendous growth of cloud computing and self-service BI demand, Presto can offer a more agile approach to data access by data consumers.

Allowing data to be consumed by anyone that needs access has become increasingly important to organizations, along with the time it takes to make said data available. In fact, these time metrics have become critical to the success of company departments, whether they are looking at IoT data or providing customers with important buying decision data.

Presto provides a quick and easy way to allow access to data from a variety of sources using industry standard SQL query language. Further, end users don’t have to learn any new complex language or new tool; they can simply utilize existing tools with which they are comfortable.

What Presto Is Not

Since Presto is being called a database by many members of the community, it makes sense to define what Presto is not. Do not mistake the fact that Presto understands SQL with it providing the features of a standard database. Presto is not a general-purpose relational database and is not a replacement for databases like MySQL, PostgreSQL, or Oracle. Moreover, Presto was not designed to handle Online Transaction Processing (OLTP), similar to other databases designed and optimized for data warehousing or analytics.