July 2023
Intermediate to advanced
278 pages
5h 40m
Chinese
Content preview from Trino 权威指南：原书第2版
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Trino
介绍
|
13
1.3 Trino
使用场景
Trino
灵活强大的特性使你可以自行决定如何使用它以获得最佳收益。你可以从仅用它
解决一个特定的小问题开始，实际上，大部分
Trino
用户也是这样开始的。
一旦你或者你所在组织中的其他
Trino
用户熟悉了这些好处和特性，将会发现新的应用
场景。口口相传，很快你就会发现通过访问各种数据源，
Trino
可以满足无数的需求。
在本节中，我们将讨论几个使用场景。记住，你可以将
Trino
应用到所有场景。此外，
仅使用
Trino
解决某个特定问题也完全没有问题，只要准备好爱上
Trino
并在之后频繁
使用它即可。
1.3.1
单一的
SQL
分析访问点
RDBMS
和
SQL
已经出现了很长时间且被证明是非常有用的。没有它们，任何组织都无
法运作。实际上，很多公司会运行多个系统。
Oracle Database
和
IBM DB2
这样的大型
商业数据库可能支撑着你的企业软件。开源系统，如
MariaDB
和
PostgreSQL
，可能用
于其他解决方案或者一些内部应用程序。
作为消费者和分析师，你可能会遇到数不清的问题：
•
有时你甚至不知道数据在哪里，只有凭借公司某个部门的内部知识或组织内多年的
工作经验，你才能找到正确的数据。
•
为了查询多种源的不同数据库，你需要使用不同的连接并运行多种不同
SQL
方言的
不同查询。这些查询看起来很相似，行为上却不同，因此你会感到困惑，并需要了
解其中的细节。
•
若不使用数据仓库，就无法使用查询功能合并来自不同系统的数据。
Trino
可以帮你避免这些问题。你可以从
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.