searchdatamanagement.techtarget.com Open in urlscan Pro
2606:4700::6812:5c  Public Scan

Form analysis
1 forms found in the DOM

GET https://www.techtarget.com/search/query

<form action="https://www.techtarget.com/search/query" method="get" class="header-search">
  <label for="header-search-input" class="visuallyhidden">Search the TechTarget Network</label>
  <input class="header-search-input ui-autocomplete-input" id="header-search-input" autocomplete="off" type="text" name="q" placeholder="Search the TechTarget Network">
  <button aria-label="Search" class="header-search-submit"><i class="icon" data-icon="g"></i></button>
</form>

Text Content

3
Trending Now

Ransomware-as-a-Service (RaaS): An evolving threatDownload NowView All3
X
3Hello, these 3 documents have been trending and as a member they are free to
you.
 * 
   Ransomware-as-a-Service (RaaS): An evolving threatDownload Now
 * 
   The digital banking strategy playbook for 2021Download Now
 * 
   How to introduce NoSQL into your infrastructureDownload Now




SearchDataManagement
Search the TechTarget Network
Sign-up now. Start my free, unlimited access.
Login Register
 * Techtarget Network
 * News
 * Features
 * Tips
 * More Content
    * Answers
    * Buyer's Guides
    * Definitions
    * Essential Guides
    * Opinions
    * Photo Stories
    * Podcasts
    * Quizzes
    * Tutorials
    * Sponsored Communities

 * Multimedia

 * SearchDataManagement
 * Topic DBMS
    * Integration
    * Resources
    * Quality / governance
    * BI
    * ECM
    * Data warehouse
    * MDM
    * Verticals
    * All Topics

 * SubTopic All Subtopics
    * AWS data warehousing
    * DBMS strategy
    * DBMS software
    * IBM DB2
    * Microsoft SQL Server management
    * Oracle database management
    * All Subtopics

 * Follow:
 * 
 * 
 * 



Getty Images/iStockphoto

Getty Images/iStockphoto

News


TRINO SET TO ADVANCE OPEN SOURCE SQL QUERY PERFORMANCE




THE REBRANDING OF PRESTOSQL TO TRINO HAS BEEN A BOON TO THE OPEN SOURCE EFFORT,
AS NEW CAPABILITIES AND ADOPTION OF THE QUERY TECHNOLOGY ARE GROWING IN 2021.

Share this item with your network:

 * 
 * 
 * 


By
 * Sean Michael Kerner

Published: 25 Oct 2021

The open source Trino distributed SQL query engine has had a big year in 2021
and is gearing up for more innovation in the year to come.

At the recent Trino Summit virtual event, supporters and users of Trino detailed
use cases for the open source distributed SQL query engine. The event was
sponsored by commercial Trino vendor Starburst, one of the leading contributors
to the Trino open source project.



Before late 2020, Trino was known as PrestoSQL, which was a competitive effort
to a related technology backed by The Linux Foundation known as PrestoDB and now
simply called Presto.

At the Trino Summit, multiple users including LinkedIn, Electronic Arts,
Robinhood and DoorDash took the virtual stage to explain how their organizations
are using Trino at scale to enable distributed data queries.

> We use Trino to build our core data query platform that empowers us to make
> data-driven analysis and decisions. Grace LuSenior software engineer,
> Robinhood

"We use Trino to build our core data query platform that empowers us to make
data-driven analysis and decisions," said Grace Lu, a senior software engineer
at investing app vendor Robinhood, during a user session on Oct. 22.


HOW TRINO HELPS ROBINHOOD WITH A DISTRIBUTED SQL ENGINE

Robinhood uses Trino for its own internal-facing applications. Those
applications include data analytics and business intelligence, as well as
overall platform visibility to help troubleshoot availability and performance
problems.

Robinhood has multiple Trino clusters that connect to different data sources and
enable the company's users to run queries against those data sources.

Among the data sources are multiple PostgreSQL databases Robinhood uses as its
primary transactional data source. Robinhood also uses an Alation data catalog
as well as the Looker analytics platform, which are both connected to
Robinhood's data sources with Trino to enable users to query data.


DOORDASH IS ONBOARDING TRINO FOR DISTRIBUTED SQL QUERIES

The pandemic has sparked an upsurge in business for food delivery services,
including DoorDash. In a user session on Oct. 21, Akshat Nair, engineering
manager at the San Francisco-based company, detailed how the organization uses
Trino to enable distributed data queries.

DoorDash has a complex data architecture that uses PostgreSQL, Apache Cassandra
and CockroachDB as core data sources. For real-time event streaming, DoorDash
uses Kafka. Some of the data lands in a Snowflake cloud data warehouse, while
other data flows to an Amazon S3-based data lake.

DoorDash is now in an early adoption phase for Trino and is using it to enable
queries across its data architecture, Nair said. DoorDash's initial use case is
similar to that of Robinhood, enabling internal users to run data analytics on
business processes and operations.

"We are in an adoption phase at this point in time, so the volume of queries is
not huge, but the data being processed is measured in terabytes and petabytes
for some of these tables," Nair said.

Screenshot by Sean Michael Kerner

DoorDash has a complex data architecture and is now starting to use Trino to
enable distributed SQL queries.



THE STATE OF TRINO MOVING FORWARD

Martin Traverso, co-creator of Presto and Trino and CTO of Starburst, gave
insight during a keynote presentation Oct. 21 into the technical progress Trino
has made this year and where the vendor is headed.

Traverso explained that PrestoSQL, which was rebranded as Trino last December,
and PrestoDB really began to diverge in 2019. He noted that while the two
projects have a shared history, more than 40% of the changes have occurred since
2019 and all those changes are exclusive to Trino.

A number of new capabilities will come to Trino over the coming months, Traverso
said. Among them is a capability that Traverso referred to as granular fault
tolerance.

One of the big limitations of Trino now is that if a query exceeds the amount of
memory available in a cluster, the query will fail. With the granular fault
tolerance capability, the query engine will be able to retry a query to help it
succeed, instead of just failing entirely.

Trino uses the Java programming language at its foundation. Traverso noted that
Trino currently is based on Java 11, which is several years old. In the coming
months Trino is moving to the newer Java 17 as a foundation.

"We've actually started doing some benchmarking with Java 17, and we see that we
get 20% improvement in performance," Traverso said. "So it is very important to
be able to move to Java 17 as the platform on top of which Trino is built."



DIG DEEPER ON DATABASE MANAGEMENT SYSTEMS (DBMS)

 * PROJECT TRINO: A DATA-DEVELOPER INSIDE STORY
   
   
   By: Adrian Bridgwater

 * VARADA SCALES CLOUD DATA PLATFORM WITH NEW RELEASE
   
   
   By: Sean Kerner

 * CHAOSSEARCH BRINGS SQL TO CLOUD DATA LAKE PLATFORM
   
   
   By: Sean Kerner

 * 15 BIG DATA TOOLS AND TECHNOLOGIES TO KNOW ABOUT IN 2021
   
   
   By: Mary Pratt

Sponsored News
 * The Business Case for a Consistent Platform from Data Center to Multi-Cloud
   to ... –Dell Technologies
 * How AI Will Blanket Your World –Intel
 * Three Ways to Beat the Complexity of Storage and Data Management to Spark ...
   –HPE
 * See More

Related Content
 * Project Trino: a data-developer inside story – ComputerWeekly.com
 * Starburst and Varada partner for Trino data platform ... –
   SearchDataManagement
 * Originators form group to boost Presto SQL query ... – SearchDataManagement



Latest TechTarget resources
 * Business Analytics
 * AWS
 * Content Management
 * Oracle
 * SAP
 * SQL Server

SearchBusinessAnalytics
 * Alation: How to develop a data governance framework
   
   Data governance should keep organizations from violating regulations while
   fostering data exploration and decision-making, but ...

 * Qlik adds Forts to analytics suite, enabling faster analysis
   
   Qlik Forts, a tool that enables customers to access and analyze data where it
   resides rather than forcing them to first import it...

 * Toucan Toco expands beyond data storytelling
   
   Once a niche vendor with a particular area of expertise, the startup's latest
   update includes data preparation and embedded BI ...

SearchAWS
 * In search of AWS Solutions Architect preparation?
   
   Think you're ready for the AWS Certified Solutions Architect certification
   exam? Test your knowledge with these 12 questions, and...

 * Experts raise privacy concerns over Amazon fleet surveillance
   
   Amazon said its van monitoring system is designed solely for driver safety.
   But many industry experts have concerns regarding the...

 * Here's why Amazon's global expansion won't come easy
   
   Amazon would like to strengthen its global footprint, but the e-commerce
   giant faces roadblocks and challenges today that did not...

SearchContentManagement
 * Acquia adds CDP, digital experience platform features
   
   Analyst: Latest features added to Acquia's marketing, commerce and customer
   data platform offerings show the company is serious ...

 * Adobe adds Workfront integrations to creative, marketing apps
   
   Adobe begins long task of integrating Workfront with its universe of popular
   creative collaboration cloud that includes Photoshop...

 * OpenText releases document capture, Salesforce integrations
   
   Like Salesforce, Box and Adobe, OpenText invests in AI and machine learning
   to enable smartphone document capture so users can ...

SearchOracle
 * Supreme Court sides with Google in Oracle API copyright suit
   
   The Supreme Court ruled 6-2 that Java APIs used in Android phones are not
   subject to American copyright law, ending a ...

 * Oracle Autonomous Database shifts IT focus to strategic planning
   
   This handbook looks at what Oracle Autonomous Database offers to Oracle users
   and issues that organizations should consider ...

 * Oracle Autonomous Database features free DBAs from routine tasks
   
   Oracle Autonomous Database can automate routine administrative and
   operational tasks for DBAs and improve productivity, but ...

SearchSAP
 * Google-Lemongrass partnership boosts SAP on GCP
   
   Google stakes its claim as the best public cloud option for SAP workloads
   thanks to a new partnership with Lemongrass, a ...

 * The at-a-glance guide to the latest SAP ERP choices
   
   IT leaders may find it difficult to distinguish between the versions of
   S/4HANA. Here's a cheat sheet on the strengths and ...

 * What's next for SAP HANA 1.0 users
   
   SAP HANA 1.0 is now out of mainstream maintenance. Here's how that pertains
   to an SAP HANA 2.0 upgrade and what happens if users ...

SearchSQLServer
 * SQL Server database design best practices and tips for DBAs
   
   Good database design is a must to meet processing needs in SQL Server
   systems. In a webinar, consultant Koen Verbeeck offered ...

 * SQL Server in Azure database choices and what they offer users
   
   SQL Server databases can be moved to the Azure cloud in several different
   ways. Here's what you'll get from each of the options ...

 * Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL
   
   In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN
   techniques and find various examples for creating SQL ...

 * About Us
 * Editorial Ethics Policy
 * Meet The Editors
 * Contact Us
 * Advertisers
 * Business Partners
 * Media Kit
 * Corporate Site

 * Contributors
 * Reprints
 * Answers
 * Definitions
 * E-Products
 * Events
 * Features

 * Guides
 * Opinions
 * Photo Stories
 * Quizzes
 * Tips
 * Tutorials
 * Videos

All Rights Reserved, Copyright 2005 - 2021, TechTarget

Privacy Policy
Cookie Preferences
Do Not Sell My Personal Info


Close